|
From: <kg...@us...> - 2003-08-15 22:00:57
|
Update of /cvsroot/babeldoc/babeldoc/readme/sql/postgresql In directory sc8-pr-cvs1:/tmp/cvs-serv11104/readme/sql/postgresql Added Files: journal-tables.sql Log Message: Add PostgreSQL journal implementation. --- NEW FILE: journal-tables.sql --- DROP TABLE journal CASCADE ; CREATE TABLE journal ( jrn_log_id INTEGER NOT NULL, jrn_log_step INTEGER NOT NULL, jrn_data BYTEA, PRIMARY KEY (jrn_log_id, jrn_log_step) ); DROP TABLE journal_data CASCADE ; CREATE TABLE journal_data ( jda_log_id INTEGER NOT NULL, jda_log_step INTEGER NOT NULL, jda_name TEXT, jda_value TEXT, PRIMARY KEY (jda_log_id, jda_log_step, jda_name) ); DROP TABLE log CASCADE ; CREATE TABLE log ( log_id INTEGER NOT NULL, log_step INTEGER NOT NULL, log_operation TEXT NOT NULL, log_datetime BIGINT NOT NULL, log_other_data TEXT, log_pipeline TEXT, log_additional TEXT, PRIMARY KEY (log_id, log_step) ); CREATE SEQUENCE log_seq; |