[geeklog-cvs] geeklog: Added missing fields

[geeklog-cvs at lists.geeklog.net]

details:   http://project.geeklog.net/cgi-bin/hgweb.cgi/rev/aa75e418b922
changeset: 6902:aa75e418b922
user:      Dirk Haun <dirk at haun-online.de>
date:      Fri Apr 10 18:20:12 2009 +0200
description:
Added missing fields

diffstat:

2 files changed, 4 insertions(+)
sql/updates/mssql_1.5.2_to_1.6.0.php |    2 ++
sql/updates/mysql_1.5.2_to_1.6.0.php |    2 ++

diffs (24 lines):

diff -r 6cd8ac70b1ff -r aa75e418b922 sql/updates/mssql_1.5.2_to_1.6.0.php
--- a/sql/updates/mssql_1.5.2_to_1.6.0.php	Fri Apr 10 17:34:06 2009 +0200
+++ b/sql/updates/mssql_1.5.2_to_1.6.0.php	Fri Apr 10 18:20:12 2009 +0200
@@ -45,6 +45,8 @@
   PRIMARY KEY  (cid)
 ) ENGINE=MyISAM
 ";
+$_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD comment_expire datetime NOT NULL default '0000-00-00 00:00:00' AFTER comments";
+$_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD name varchar(32) default NULL AFTER indent";
 */
 $_SQL[] = "INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr, grp_gl_core) VALUES ('Comment Admin', 'Can moderate comments', 1)";
 $_SQL[] = "INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr, grp_gl_core) VALUES ('Comment Submitters', 'Can submit comments', 0);";
diff -r 6cd8ac70b1ff -r aa75e418b922 sql/updates/mysql_1.5.2_to_1.6.0.php
--- a/sql/updates/mysql_1.5.2_to_1.6.0.php	Fri Apr 10 17:34:06 2009 +0200
+++ b/sql/updates/mysql_1.5.2_to_1.6.0.php	Fri Apr 10 18:20:12 2009 +0200
@@ -45,6 +45,8 @@
   PRIMARY KEY  (cid)
 ) ENGINE=MyISAM
 ";
+$_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD comment_expire datetime NOT NULL default '0000-00-00 00:00:00' AFTER comments";
+$_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD name varchar(32) default NULL AFTER indent";
 $_SQL[] = "INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr, grp_gl_core) VALUES ('Comment Admin', 'Can moderate comments', 1)";
 $_SQL[] = "INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr, grp_gl_core) VALUES ('Comment Submitters', 'Can submit comments', 0);";
 $_SQL[] = "INSERT INTO {$_TABLES['features']} (ft_name, ft_descr, ft_gl_core) VALUES ('comment.moderate',  'Ability to moderate comments', 1)";