# HG changeset patch # User Dan # Date 1203044188 18000 # Node ID ca37fcd08c4e7fbe46bc2910113bb97f475e5669 # Parent b8b4e38825db51a4c1d03dd8d856025f3bd5fcc3 Fixed user -> user_id transition for enano_tags table diff -r b8b4e38825db -r ca37fcd08c4e install/schemas/mysql_stage2.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`; diff -r b8b4e38825db -r ca37fcd08c4e install/schemas/upgrade/1.1.1-1.1.2-mysql.sql --- 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 '',