schema.sql
changeset 207 861807631f70
parent 180 c63c5ee6c6d6
child 205 c4542792db2b
equal deleted inserted replaced
203:8e2fffc5c622 207:861807631f70
   250   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   250   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   251   page_id varchar(255) NOT NULL,
   251   page_id varchar(255) NOT NULL,
   252   namespace varchar(255) NOT NULL,
   252   namespace varchar(255) NOT NULL,
   253   user mediumint(8) NOT NULL DEFAULT 1,
   253   user mediumint(8) NOT NULL DEFAULT 1,
   254   PRIMARY KEY ( tag_id )
   254   PRIMARY KEY ( tag_id )
       
   255 ) CHARACTER SET `utf8`;
       
   256 
       
   257 -- Added in 1.1.1
       
   258 
       
   259 CREATE TABLE {{TABLE_PREFIX}}lockout(
       
   260   id int(12) NOT NULL auto_increment,
       
   261   ipaddr varchar(40) NOT NULL,
       
   262   action ENUM('credential', 'level') NOT NULL DEFAULT 'credential',
       
   263   timestamp int(12) NOT NULL DEFAULT 0,
       
   264   PRIMARY KEY ( id )
   255 ) CHARACTER SET `utf8`;
   265 ) CHARACTER SET `utf8`;
   256 
   266 
   257 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   267 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   258   ('site_name', '{{SITE_NAME}}'),
   268   ('site_name', '{{SITE_NAME}}'),
   259   ('main_page', 'Main_Page'),
   269   ('main_page', 'Main_Page'),