From c0ba103ca71d665739e7e64c1f1adbc4b12c9e00 Mon Sep 17 00:00:00 2001 From: paca70 Date: Sun, 4 May 2003 10:45:57 +0000 Subject: [PATCH] Added transaction around table creation --- mod/workshop/db/postgres7.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/mod/workshop/db/postgres7.sql b/mod/workshop/db/postgres7.sql index 372dbe0239..8f6547eb9c 100644 --- a/mod/workshop/db/postgres7.sql +++ b/mod/workshop/db/postgres7.sql @@ -1,7 +1,7 @@ # # Table structure for table workshop # - +BEGIN; CREATE TABLE prefix_workshop ( id SERIAL8 PRIMARY KEY, course INT8 NOT NULL default '0', @@ -110,4 +110,4 @@ INSERT INTO prefix_log_display VALUES ('workshop', 'open', 'workshop', 'name'); INSERT INTO prefix_log_display VALUES ('workshop', 'submit', 'workshop', 'name'); INSERT INTO prefix_log_display VALUES ('workshop', 'view', 'workshop', 'name'); INSERT INTO prefix_log_display VALUES ('workshop', 'update', 'workshop', 'name'); - +COMMIT; -- 2.39.5