install/schemas/postgresql_stage2.sql
changeset 410 9db359d6e60c
parent 406 7468a663315f
child 413 6607cd646d6d
equal deleted inserted replaced
409:267be9e394c2 410:9db359d6e60c
    29   ip_address varchar(39),
    29   ip_address varchar(39),
    30   PRIMARY KEY ( comment_id )
    30   PRIMARY KEY ( comment_id )
    31 );
    31 );
    32 
    32 
    33 CREATE TABLE {{TABLE_PREFIX}}logs(
    33 CREATE TABLE {{TABLE_PREFIX}}logs(
       
    34   log_id SERIAL,
    34   log_type varchar(16),
    35   log_type varchar(16),
    35   action varchar(16),
    36   action varchar(16),
    36   time_id int NOT NULL default '0',
    37   time_id int NOT NULL default '0',
    37   date_string varchar(63),
    38   date_string varchar(63),
    38   page_id text,
    39   page_id text,
    39   namespace text,
    40   namespace text,
    40   page_text text,
    41   page_text text,
    41   char_tag varchar(40),
    42   char_tag varchar(40),
    42   author varchar(63),
    43   author varchar(63),
    43   edit_summary text,
    44   edit_summary text,
    44   minor_edit smallint
    45   minor_edit smallint,
       
    46   PRIMARY KEY ( log_id )
    45 );
    47 );
    46 
    48 
    47 CREATE TABLE {{TABLE_PREFIX}}page_text(
    49 CREATE TABLE {{TABLE_PREFIX}}page_text(
    48   page_id varchar(255),
    50   page_id varchar(255),
    49   namespace varchar(16) NOT NULL default 'Article',
    51   namespace varchar(16) NOT NULL default 'Article',