From: mh <mh>
Date: Thu, 27 Sep 2001 16:33:30 +0000 (+0000)
Subject: all DB data now goes in dbscripts/populate*.sql
X-Git-Tag: prexmlproducerconfig~416
X-Git-Url: http://erislabs.net/gitweb/?p=mir.git;a=commitdiff_plain;h=c3a2c201d92140363c4ec1f59c6457704330270d

all DB data now goes in dbscripts/populate*.sql
---

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 10157120..57a7ff4b 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -605,32 +605,3 @@ CREATE UNIQUE INDEX "idx_content_media" on "content_x_media" using btree ( "cont
 
 CREATE UNIQUE INDEX "idx_media_content" on "content_x_media" using btree ( "media_id" "int4_ops", "content_id" "int4_ops" );
 
---
--- Selected TOC Entries:
---
---
--- Data for TOC Entry ID 2 (OID 28909)
---
--- Name: media_type Type: TABLE DATA Owner: postgres
---
-
-
-\connect - postgres
--- Disable triggers
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type';
-
-COPY "media_type"  FROM stdin;
-2	unknown	application/octet-stream	--	UploadedMedia	\N
-3	gif	image/gif	ImagesGif	Images	\N
-\.
--- Enable triggers
-UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type';
-
---
--- TOC Entry ID 1 (OID 28890)
---
--- Name: media_type_id_seq Type: SEQUENCE SET Owner: 
---
-
-SELECT setval ('"media_type_id_seq"', 1, 't');
-
diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql
new file mode 100755
index 00000000..3fd373ac
--- /dev/null
+++ b/dbscripts/populate_mediatyp.sql
@@ -0,0 +1,29 @@
+--
+-- Selected TOC Entries:
+--
+--
+-- Data for TOC Entry ID 2 (OID 28909)
+--
+-- Name: media_type Type: TABLE DATA Owner: postgres
+--
+
+
+\connect - postgres
+-- Disable triggers
+UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type';
+
+COPY "media_type"  FROM stdin;
+2	unknown	application/octet-stream	--	UploadedMedia	\N
+3	gif	image/gif	ImagesGif	Images	\N
+\.
+-- Enable triggers
+UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type';
+
+--
+-- TOC Entry ID 1 (OID 28890)
+--
+-- Name: media_type_id_seq Type: SEQUENCE SET Owner: 
+--
+
+SELECT setval ('"media_type_id_seq"', 1, 't');
+
diff --git a/doc/INSTALL.mir b/doc/INSTALL.mir
index 58d747d6..b35d9a23 100755
--- a/doc/INSTALL.mir
+++ b/doc/INSTALL.mir
@@ -57,6 +57,7 @@ as user postgres:
 8. create base table
 	psql -Upostgres dbname < dbscripts/create_pg.sql
 	cat dbscript/help*.sql | psql -Upostgres dbname
+	cat dbscript/populate*.sql | psql -Upostgres dbname
 
 9. chmod 777 Mir/log