schema.sql
changeset 179 36b287f1d85c
parent 153 9b86248e8fee
child 180 c63c5ee6c6d6
equal deleted inserted replaced
178:4c19952406db 179:36b287f1d85c
   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'),