261 ipaddr varchar(40) NOT NULL, |
261 ipaddr varchar(40) NOT NULL, |
262 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |
262 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |
263 timestamp int(12) NOT NULL DEFAULT 0, |
263 timestamp int(12) NOT NULL DEFAULT 0, |
264 PRIMARY KEY ( id ) |
264 PRIMARY KEY ( id ) |
265 ) CHARACTER SET `utf8`; |
265 ) CHARACTER SET `utf8`; |
|
266 |
|
267 -- Added in 1.1.1 |
|
268 |
|
269 CREATE TABLE {{TABLE_PREFIX}}language( |
|
270 lang_id smallint(5) NOT NULL auto_increment, |
|
271 lang_code varchar(16) NOT NULL, |
|
272 lang_name_default varchar(64) NOT NULL, |
|
273 lang_name_native varchar(64) NOT NULL, |
|
274 PRIMARY KEY ( lang_id ) |
|
275 ) CHARACTER SET `utf8`; |
|
276 |
|
277 -- Added in 1.1.1 |
|
278 |
|
279 CREATE TABLE {{TABLE_PREFIX}}language_strings( |
|
280 string_id bigint(15) NOT NULL auto_increment, |
|
281 lang_id smallint(5) NOT NULL, |
|
282 string_category varchar(32) NOT NULL, |
|
283 string_name varchar(64) NOT NULL, |
|
284 string_content longtext NOT NULL, |
|
285 PRIMARY KEY ( string_id ) |
|
286 ); |
266 |
287 |
267 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
288 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
268 ('site_name', '{{SITE_NAME}}'), |
289 ('site_name', '{{SITE_NAME}}'), |
269 ('main_page', 'Main_Page'), |
290 ('main_page', 'Main_Page'), |
270 ('site_desc', '{{SITE_DESC}}'), |
291 ('site_desc', '{{SITE_DESC}}'), |