From 1f401ba91fb6904b0d1dd33909a4cfe86163adea Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 8 Aug 2006 19:04:36 +0000 Subject: [PATCH] moving offline stuff into the DB git-svn-id: svn://svn.open-ils.org/ILS/trunk@5375 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/001.schema.offline.sql | 39 ++++++++++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/001.schema.offline.sql diff --git a/Open-ILS/src/sql/Pg/001.schema.offline.sql b/Open-ILS/src/sql/Pg/001.schema.offline.sql new file mode 100644 index 0000000000..8bd18089ff --- /dev/null +++ b/Open-ILS/src/sql/Pg/001.schema.offline.sql @@ -0,0 +1,39 @@ + +DROP SCHEMA offline CASCADE; + +BEGIN; + +CREATE SCHEMA offline; + +CREATE TABLE offline.script ( + id SERIAL PRIMARY KEY, + session TEXT NOT NULL, + requestor INTEGER NOT NULL, + create_time INTEGER NOT NULL, + workstation TEXT NOT NULL, + logfile TEXT NOT NULL, + time_delta INTEGER NOT NULL DEFAULT 0, + count INTEGER NOT NULL DEFAULT 0 +); +CREATE INDEX offline_script_pkey ON offline.script (id); +CREATE INDEX offline_script_ws ON offline.script (workstation); +CREATE INDEX offline_script_session ON offline.script (session); + + +CREATE TABLE offline.session ( + key TEXT PRIMARY KEY, + org INTEGER NOT NULL, + description TEXT, + creator INTEGER NOT NULL, + create_time INTEGER NOT NULL, + in_process INTEGER NOT NULL DEFAULT 0, + start_time INTEGER, + end_time INTEGER, + num_complete INTEGER NOT NULL DEFAULT 0 +); +CREATE INDEX offline_session_pkey ON offline.session (key); +CREATE INDEX offline_session_org ON offline.session (org); +CREATE INDEX offline_session_creation ON offline.session (create_time); + +COMMIT; + -- 2.11.0