install/schemas/postgresql_stage2.sql
changeset 862 8356381e8d1e
parent 857 f3a5a276208c
child 923 9ef3ccac13de
equal deleted inserted replaced
861:b550f497cdbf 862:8356381e8d1e
    41   page_text text,
    41   page_text text,
    42   char_tag varchar(40),
    42   char_tag varchar(40),
    43   author varchar(63),
    43   author varchar(63),
    44   edit_summary text,
    44   edit_summary text,
    45   minor_edit smallint,
    45   minor_edit smallint,
       
    46   page_format varchar(16) NOT NULL DEFAULT 'wikitext',
    46   is_draft smallint NOT NULL DEFAULT 0,
    47   is_draft smallint NOT NULL DEFAULT 0,
    47   PRIMARY KEY ( log_id )
    48   PRIMARY KEY ( log_id )
    48 );
    49 );
    49 
    50 
    50 CREATE TABLE {{TABLE_PREFIX}}page_text(
    51 CREATE TABLE {{TABLE_PREFIX}}page_text(
   362   ('contact_email', '{{ADMIN_EMAIL}}'),
   363   ('contact_email', '{{ADMIN_EMAIL}}'),
   363   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
   364   ('allowed_mime_types', 'cbf2:7414a6b80184038102810b810781098106830a810282018101820683018102840182038104821a850682028104810a82018116'),
   364   ('enano_version', '{{VERSION}}');
   365   ('enano_version', '{{VERSION}}');
   365 
   366 
   366 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   367 INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
   367   ('Main_Page', 'Article', E'{{MAIN_PAGE_CONTENT}}', '');
   368   ('Main_Page', 'Article', '{{MAIN_PAGE_CONTENT}}', '');
   368   
   369   
   369 INSERT INTO {{TABLE_PREFIX}}logs(time_id, date_string, log_type, action, page_id, namespace, author, page_text) VALUES
   370 INSERT INTO {{TABLE_PREFIX}}logs(time_id, date_string, log_type, action, page_id, namespace, author, page_text) VALUES
   370   ({{UNIX_TIME}}, 'DEPRECATED', 'page', 'edit', 'Main_Page', 'Article', '{{ADMIN_USER}}', '{{MAIN_PAGE_CONTENT}}');
   371   ({{UNIX_TIME}}, 'DEPRECATED', 'page', 'edit', 'Main_Page', 'Article', '{{ADMIN_USER}}', '{{MAIN_PAGE_CONTENT}}');
   371 
   372 
   372 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
   373 INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES