[Babeldoc-devel] babeldoc/readme/sql/postgresql journal-tables.sql,NONE,1.1

[<kg...@us...>]

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;