install/schemas/postgresql_stage2.sql
changeset 519 94214ec0871c
parent 499 6b7fdd898ba3
child 541 acb7e23b6ffa
equal deleted inserted replaced
518:2b826f2640e9 519:94214ec0871c
   311 CREATE TABLE {{TABLE_PREFIX}}diffiehellman (
   311 CREATE TABLE {{TABLE_PREFIX}}diffiehellman (
   312   key_id SERIAL,
   312   key_id SERIAL,
   313   private_key text,
   313   private_key text,
   314   public_key text,
   314   public_key text,
   315   PRIMARY KEY ( key_id )
   315   PRIMARY KEY ( key_id )
       
   316 );
       
   317 
       
   318 -- Added in 1.1.4
       
   319 -- This is really honestly a better way to handle plugins.
       
   320 
       
   321 CREATE TABLE {{TABLE_PREFIX}}plugins (
       
   322   plugin_id SERIAL,
       
   323   plugin_filename varchar(63),
       
   324   plugin_flags int,
       
   325   plugin_version varchar(16),
       
   326   PRIMARY KEY ( plugin_id )
   316 );
   327 );
   317 
   328 
   318 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   329 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
   319   ('site_name', '{{SITE_NAME}}'),
   330   ('site_name', '{{SITE_NAME}}'),
   320   ('main_page', 'Main_Page'),
   331   ('main_page', 'Main_Page'),