Fixed user -> user_id transition for enano_tags table
authorDan
Thu, 14 Feb 2008 21:56:28 -0500
changeset 422 ca37fcd08c4e
parent 419 b8b4e38825db
child 423 990ccfb20120
Fixed user -> user_id transition for enano_tags table
install/schemas/mysql_stage2.sql
install/schemas/upgrade/1.1.1-1.1.2-mysql.sql
--- a/install/schemas/mysql_stage2.sql	Tue Feb 12 22:17:58 2008 -0500
+++ b/install/schemas/mysql_stage2.sql	Thu Feb 14 21:56:28 2008 -0500
@@ -248,7 +248,7 @@
   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   page_id varchar(255) NOT NULL,
   namespace varchar(255) NOT NULL,
-  user mediumint(8) NOT NULL DEFAULT 1,
+  user_id mediumint(8) NOT NULL DEFAULT 1,
   PRIMARY KEY ( tag_id )
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
--- a/install/schemas/upgrade/1.1.1-1.1.2-mysql.sql	Tue Feb 12 22:17:58 2008 -0500
+++ b/install/schemas/upgrade/1.1.1-1.1.2-mysql.sql	Thu Feb 14 21:56:28 2008 -0500
@@ -7,6 +7,8 @@
 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,
                                   ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0;
 
+ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
+
 CREATE TABLE {{TABLE_PREFIX}}ranks(
   rank_id int(12) NOT NULL auto_increment,
   rank_title varchar(63) NOT NULL DEFAULT '',