12 CREATE TABLE {{TABLE_PREFIX}}language( lang_id smallint(5) NOT NULL auto_increment, lang_code varchar(16) NOT NULL, lang_name_default varchar(64) NOT NULL, lang_name_native varchar(64) NOT NULL, last_changed int(12) NOT NULL DEFAULT 0, PRIMARY KEY ( lang_id ) ) CHARACTER SET `utf8`; |
12 CREATE TABLE {{TABLE_PREFIX}}language( lang_id smallint(5) NOT NULL auto_increment, lang_code varchar(16) NOT NULL, lang_name_default varchar(64) NOT NULL, lang_name_native varchar(64) NOT NULL, last_changed int(12) NOT NULL DEFAULT 0, PRIMARY KEY ( lang_id ) ) CHARACTER SET `utf8`; |
13 CREATE TABLE {{TABLE_PREFIX}}language_strings( string_id bigint(15) NOT NULL auto_increment, lang_id smallint(5) NOT NULL, string_category varchar(32) NOT NULL, string_name varchar(64) NOT NULL, string_content longtext NOT NULL, PRIMARY KEY ( string_id ) ); |
13 CREATE TABLE {{TABLE_PREFIX}}language_strings( string_id bigint(15) NOT NULL auto_increment, lang_id smallint(5) NOT NULL, string_category varchar(32) NOT NULL, string_name varchar(64) NOT NULL, string_content longtext NOT NULL, PRIMARY KEY ( string_id ) ); |
14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_lang smallint(5) NOT NULL; |
14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_lang smallint(5) NOT NULL; |
15 ---END Stable1.0ToUnstable1.1--- |
15 ---END Stable1.0ToUnstable1.1--- |
16 ---BEGIN 1.0.2--- |
16 ---BEGIN 1.0.2--- |
|
17 -- No DB changes in this release |
17 ---END 1.0.2--- |
18 ---END 1.0.2--- |
18 ---BEGIN 1.0.2b1--- |
19 ---BEGIN 1.0.2b1--- |
19 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
20 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
20 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
21 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
21 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |
22 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |