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

[David G. <dgl...@us...>]

Update of /cvsroot/babeldoc/babeldoc/readme/sql/sqlserver
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22496/babeldoc/readme/sql/sqlserver

Added Files:
	journal-tables.sql 
Log Message:
Added journal support for Sql Server

--- NEW FILE: journal-tables.sql ---
IF OBJECT_ID('journal') IS NOT NULL DROP TABLE journal ;
CREATE TABLE journal (
	jrn_log_id	INTEGER NOT NULL,
	jrn_log_step	INTEGER NOT NULL,
	jrn_data	IMAGE,
	PRIMARY KEY (jrn_log_id, jrn_log_step)
) ;

IF OBJECT_ID('journal_data') IS NOT NULL DROP TABLE journal_data ; 
CREATE TABLE journal_data (
	jda_log_id	INTEGER NOT NULL,
	jda_log_step	INTEGER NOT NULL,
	jda_name	VARCHAR(255),
	jda_value	VARCHAR(255),
	PRIMARY KEY (jda_log_id, jda_log_step, jda_name)
) ;

IF OBJECT_ID('log') IS NOT NULL DROP TABLE [log] ;
CREATE TABLE [log] (
	log_id		INTEGER NOT NULL,
	log_step	INTEGER NOT NULL,
	log_operation	VARCHAR(255) NOT NULL,
	log_datetime	BIGINT NOT NULL,
	log_other_data	VARCHAR(255),
	log_pipeline	VARCHAR(255),
	log_additional	VARCHAR(2000),
	PRIMARY KEY (log_id, log_step)
) ;

IF OBJECT_ID('table_key') IS NOT NULL DROP TABLE table_key ;
CREATE TABLE table_key (
	key_table_name	VARCHAR(255) NOT NULL UNIQUE,
	key_val		VARCHAR(255) NOT NULL,
	PRIMARY KEY (key_table_name)
) ;

IF OBJECT_ID('config') IS NOT NULL DROP TABLE config ;
CREATE TABLE config (
	cfg_name	VARCHAR(255) NOT NULL UNIQUE,
	cfg_value	VARCHAR(255) NOT NULL,
	PRIMARY KEY (cfg_name)
) ;
	
IF OBJECT_ID('babel_user') IS NOT NULL DROP TABLE babel_user ;
CREATE TABLE babel_user (
	[user_name]	VARCHAR(255) NOT NULL UNIQUE,
	user_passwd	VARCHAR(255) NOT NULL,
	PRIMARY KEY ([user_name])
) ;