install/schemas/mysql_stage2.sql
changeset 1081 745200a9cc2a
parent 929 2e981507dfae
child 1159 a1cca4472a58
equal deleted inserted replaced
1080:6358f769ecb1 1081:745200a9cc2a
   133   user_location text,
   133   user_location text,
   134   user_job text,
   134   user_job text,
   135   user_hobbies text,
   135   user_hobbies text,
   136   email_public tinyint(1) NOT NULL DEFAULT 0,
   136   email_public tinyint(1) NOT NULL DEFAULT 0,
   137   disable_js_fx tinyint(1) NOT NULL DEFAULT 0,
   137   disable_js_fx tinyint(1) NOT NULL DEFAULT 0,
       
   138   date_format varchar(32) NOT NULL DEFAULT 'F d, Y',
       
   139   time_format varchar(32) NOT NULL DEFAULT 'G:i',
   138   PRIMARY KEY ( user_id ) 
   140   PRIMARY KEY ( user_id ) 
   139 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   141 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   140 
   142 
   141 CREATE TABLE {{TABLE_PREFIX}}banlist(
   143 CREATE TABLE {{TABLE_PREFIX}}banlist(
   142   ban_id mediumint(8) NOT NULL auto_increment,
   144   ban_id mediumint(8) NOT NULL auto_increment,