install/schemas/mysql_stage2.sql
changeset 436 242353360e37
parent 430 ec90736b9cb9
child 468 194a19711346
equal deleted inserted replaced
435:a434d60e525d 436:242353360e37
   303   code varchar(64) NOT NULL DEFAULT '',
   303   code varchar(64) NOT NULL DEFAULT '',
   304   session_data text,
   304   session_data text,
   305   source_ip varchar(39),
   305   source_ip varchar(39),
   306   user_id int(12),
   306   user_id int(12),
   307   PRIMARY KEY ( code_id )
   307   PRIMARY KEY ( code_id )
       
   308 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
       
   309 
       
   310 -- Added in 1.1.3
       
   311 -- Storing obscenely huge integers as strings since that's how php processes them.
       
   312 
       
   313 CREATE TABLE {{TABLE_PREFIX}}diffiehellman (
       
   314   key_id int(12) NOT NULL auto_increment,
       
   315   private_key text,
       
   316   public_key text,
       
   317   PRIMARY KEY ( key_id )
   308 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   318 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   309 
   319 
   310 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   320 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   311   ('site_name', '{{SITE_NAME}}'),
   321   ('site_name', '{{SITE_NAME}}'),
   312   ('main_page', 'Main_Page'),
   322   ('main_page', 'Main_Page'),