install/schemas/mysql_stage2.sql
changeset 422 ca37fcd08c4e
parent 413 6607cd646d6d
child 430 ec90736b9cb9
equal deleted inserted replaced
419:b8b4e38825db 422:ca37fcd08c4e
   246 CREATE TABLE {{TABLE_PREFIX}}tags(
   246 CREATE TABLE {{TABLE_PREFIX}}tags(
   247   tag_id int(12) NOT NULL auto_increment,
   247   tag_id int(12) NOT NULL auto_increment,
   248   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   248   tag_name varchar(63) NOT NULL DEFAULT 'bla',
   249   page_id varchar(255) NOT NULL,
   249   page_id varchar(255) NOT NULL,
   250   namespace varchar(255) NOT NULL,
   250   namespace varchar(255) NOT NULL,
   251   user mediumint(8) NOT NULL DEFAULT 1,
   251   user_id mediumint(8) NOT NULL DEFAULT 1,
   252   PRIMARY KEY ( tag_id )
   252   PRIMARY KEY ( tag_id )
   253 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   253 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   254 
   254 
   255 -- Added in 1.1.1
   255 -- Added in 1.1.1
   256 
   256