schema.sql
changeset 293 fbe306070c40
parent 240 ee1fc84f12a8
equal deleted inserted replaced
292:704e1d3ca378 293:fbe306070c40
   241 CREATE TABLE {{TABLE_PREFIX}}tags(
   241 CREATE TABLE {{TABLE_PREFIX}}tags(
   242   tag_id int(12) NOT NULL auto_increment,
   242   tag_id int(12) NOT NULL auto_increment,
   243   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   243   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   244   page_id varchar(255) NOT NULL,
   244   page_id varchar(255) NOT NULL,
   245   namespace varchar(255) NOT NULL,
   245   namespace varchar(255) NOT NULL,
   246   user mediumint(8) NOT NULL DEFAULT 1,
   246   user_id mediumint(8) NOT NULL DEFAULT 1,
   247   PRIMARY KEY ( tag_id )
   247   PRIMARY KEY ( tag_id )
   248 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   248 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   249 
   249 
   250 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   250 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   251   ('site_name', '{{SITE_NAME}}'),
   251   ('site_name', '{{SITE_NAME}}'),