From 0ee7828e9bed6ad40415f6a7b76b1d484f985d86 Mon Sep 17 00:00:00 2001 From: mj Date: Sat, 6 Apr 2002 20:07:04 +0000 Subject: [PATCH] Cleaned up build.xml. Changed the way the database is populated so that it works with a password protected PostgreSQL installation. --- build.xml | 30 +++++++++++++----------------- dbscripts/help_arttype.sql | 2 +- dbscripts/help_imgcolor.sql | 2 +- dbscripts/help_imgform.sql | 2 +- dbscripts/help_imglay.sql | 2 +- dbscripts/help_imgtype.sql | 2 +- dbscripts/help_lang.sql | 2 +- dbscripts/help_rights.sql | 2 +- dbscripts/help_users.sql | 2 +- dbscripts/populate_mediatyp.sql | 3 ++- 10 files changed, 23 insertions(+), 26 deletions(-) diff --git a/build.xml b/build.xml index d26d6951..c68923d7 100755 --- a/build.xml +++ b/build.xml @@ -62,20 +62,18 @@ + + - + - - - - @@ -86,15 +84,10 @@ - + + + @@ -192,9 +185,12 @@ - - + + + + + + diff --git a/dbscripts/help_arttype.sql b/dbscripts/help_arttype.sql index 2c7680bc..a58ed98b 100755 --- a/dbscripts/help_arttype.sql +++ b/dbscripts/help_arttype.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "article_type" VALUES (0,'OpenPosting'); INSERT INTO "article_type" VALUES (1,'Newswire'); INSERT INTO "article_type" VALUES (2,'Feature'); diff --git a/dbscripts/help_imgcolor.sql b/dbscripts/help_imgcolor.sql index d4d08fd0..1f28846c 100755 --- a/dbscripts/help_imgcolor.sql +++ b/dbscripts/help_imgcolor.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "img_color" VALUES (0,'--'); INSERT INTO "img_color" VALUES (3,'color (16)'); INSERT INTO "img_color" VALUES (4,'color (256)'); diff --git a/dbscripts/help_imgform.sql b/dbscripts/help_imgform.sql index 96e177c1..e6f4343d 100755 --- a/dbscripts/help_imgform.sql +++ b/dbscripts/help_imgform.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "img_format" VALUES (0,'jpeg','jpg','image/jpg','jpeg nur vom original bearbeiten'); INSERT INTO "img_format" VALUES (1,'gif','gif','image/gif',NULL); BEGIN TRANSACTION; diff --git a/dbscripts/help_imglay.sql b/dbscripts/help_imglay.sql index 9b7165fd..7da01487 100755 --- a/dbscripts/help_imglay.sql +++ b/dbscripts/help_imglay.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "img_layout" VALUES (0,'--'); INSERT INTO "img_layout" VALUES (1,'quer'); INSERT INTO "img_layout" VALUES (2,'hoch'); diff --git a/dbscripts/help_imgtype.sql b/dbscripts/help_imgtype.sql index dc3c15a1..4145c550 100755 --- a/dbscripts/help_imgtype.sql +++ b/dbscripts/help_imgtype.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "img_type" VALUES (0,'--'); INSERT INTO "img_type" VALUES (1,'Plakat'); INSERT INTO "img_type" VALUES (2,'Photo'); diff --git a/dbscripts/help_lang.sql b/dbscripts/help_lang.sql index ca3356c3..3486bc04 100755 --- a/dbscripts/help_lang.sql +++ b/dbscripts/help_lang.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "language" VALUES (0,'deutsch','de'); INSERT INTO "language" VALUES (1,'english','en'); BEGIN TRANSACTION; diff --git a/dbscripts/help_rights.sql b/dbscripts/help_rights.sql index ae5d7870..851eb01f 100755 --- a/dbscripts/help_rights.sql +++ b/dbscripts/help_rights.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "rights" VALUES (0,'keine angabe',NULL); INSERT INTO "rights" VALUES (1,'indymedia','rechte liegen bei indymedia'); INSERT INTO "rights" VALUES (2,'rechte bei autor/innen',NULL); diff --git a/dbscripts/help_users.sql b/dbscripts/help_users.sql index 42cb663e..c46fddfd 100755 --- a/dbscripts/help_users.sql +++ b/dbscripts/help_users.sql @@ -1,5 +1,5 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -\connect - postgres +-- \connect - postgres INSERT INTO "webdb_users" VALUES (1,'open','','f'); INSERT INTO "webdb_users" VALUES (2,'redaktion','indymedia','t'); INSERT INTO "webdb_users" VALUES (3,'tollendorf','indymedia','t'); diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql index 4ca9fd6c..55d61e46 100755 --- a/dbscripts/populate_mediatyp.sql +++ b/dbscripts/populate_mediatyp.sql @@ -8,7 +8,8 @@ -- -\connect - de_indy +-- \connect - de_indy + -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type'; -- 2.11.0