equal
deleted
inserted
replaced
5 plugin_filename varchar(63), |
5 plugin_filename varchar(63), |
6 plugin_flags int(12), |
6 plugin_flags int(12), |
7 plugin_version varchar(16), |
7 plugin_version varchar(16), |
8 PRIMARY KEY ( plugin_id ) |
8 PRIMARY KEY ( plugin_id ) |
9 ) ENGINE `MyISAM` CHARACTER SET `utf8` COLLATE `utf8_bin`; |
9 ) ENGINE `MyISAM` CHARACTER SET `utf8` COLLATE `utf8_bin`; |
|
10 |
|
11 ALTER TABLE {{TABLE_PREFIX}}search_index ADD COLUMN word_lcase varchar(64) NOT NULL; |
10 |
12 |
11 -- User title |
13 -- User title |
12 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_title varchar(64) DEFAULT NULL; |
14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_title varchar(64) DEFAULT NULL; |
13 ALTER TABLE {{TABLE_PREFIX}}users MODIFY COLUMN user_rank int(12) unsigned DEFAULT NULL; |
15 ALTER TABLE {{TABLE_PREFIX}}users MODIFY COLUMN user_rank int(12) unsigned DEFAULT NULL; |
14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_group mediumint(5) NOT NULL DEFAULT 1; |
16 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_group mediumint(5) NOT NULL DEFAULT 1; |