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