[geeklog-cvs] geeklog: Added a draft flag (not used yet; for feature request #...

[geeklog-cvs at lists.geeklog.net]

changeset 7532:e8af111e9abb
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/e8af111e9abb
user: Dirk Haun <dirk at haun-online.de>
date: Sun Dec 13 21:32:52 2009 +0100
description:
Added a draft flag (not used yet; for feature request #0000884)

diffstat:

 plugins/staticpages/sql/mssql_install.php |  1 +
 plugins/staticpages/sql/mssql_updates.php |  3 ++-
 plugins/staticpages/sql/mysql_install.php |  1 +
 plugins/staticpages/sql/mysql_updates.php |  3 ++-
 4 files changed, 6 insertions(+), 2 deletions(-)

diffs (48 lines):

diff -r fc38f6a4f164 -r e8af111e9abb plugins/staticpages/sql/mssql_install.php
--- a/plugins/staticpages/sql/mssql_install.php	Sun Dec 13 20:09:58 2009 +0100
+++ b/plugins/staticpages/sql/mssql_install.php	Sun Dec 13 21:32:52 2009 +0100
@@ -49,6 +49,7 @@
     [commentcode] [numeric](4, 0) NOT NULL,
     [meta_description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
     [meta_keywords] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+    [draft_flag] [tinyint] NULL ,
     [owner_id] [numeric](8, 0) NOT NULL ,
     [group_id] [numeric](8, 0) NOT NULL ,
     [perm_owner] [tinyint] NOT NULL ,
diff -r fc38f6a4f164 -r e8af111e9abb plugins/staticpages/sql/mssql_updates.php
--- a/plugins/staticpages/sql/mssql_updates.php	Sun Dec 13 20:09:58 2009 +0100
+++ b/plugins/staticpages/sql/mssql_updates.php	Sun Dec 13 21:32:52 2009 +0100
@@ -39,7 +39,8 @@
     ),
 
     '1.6.1' => array(
-        "ALTER TABLE {$_TABLES['staticpage']} DROP COLUMN sp_uid"
+        "ALTER TABLE {$_TABLES['staticpage']} DROP COLUMN sp_uid",
+        "ALTER TABLE {$_TABLES['staticpage']} ADD [draft_flag] [tinyint] NULL AFTER meta_keywords"
     )
 );
 
diff -r fc38f6a4f164 -r e8af111e9abb plugins/staticpages/sql/mysql_install.php
--- a/plugins/staticpages/sql/mysql_install.php	Sun Dec 13 20:09:58 2009 +0100
+++ b/plugins/staticpages/sql/mysql_install.php	Sun Dec 13 21:32:52 2009 +0100
@@ -48,6 +48,7 @@
   commentcode tinyint(4) NOT NULL default '0',
   meta_description TEXT NULL,
   meta_keywords TEXT NULL,  
+  draft_flag tinyint(1) unsigned default '0',
   owner_id mediumint(8) unsigned NOT NULL default '1',
   group_id mediumint(8) unsigned NOT NULL default '1',
   perm_owner tinyint(1) unsigned NOT NULL default '3',
diff -r fc38f6a4f164 -r e8af111e9abb plugins/staticpages/sql/mysql_updates.php
--- a/plugins/staticpages/sql/mysql_updates.php	Sun Dec 13 20:09:58 2009 +0100
+++ b/plugins/staticpages/sql/mysql_updates.php	Sun Dec 13 21:32:52 2009 +0100
@@ -40,7 +40,8 @@
     ),
 
     '1.6.1' => array(
-        "ALTER TABLE {$_TABLES['staticpage']} DROP COLUMN sp_uid"
+        "ALTER TABLE {$_TABLES['staticpage']} DROP COLUMN sp_uid",
+        "ALTER TABLE {$_TABLES['staticpage']} ADD draft_flag tinyint(1) unsigned default '0' AFTER meta_keywords"
     )
 
 );