From 9d5481aaecc5e267e8502dceb7bfde1b8c6367bd Mon Sep 17 00:00:00 2001 From: mh Date: Fri, 29 Mar 2002 14:51:48 +0000 Subject: [PATCH] initial openposting data --- dbscripts/populate_mediafolder.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100755 dbscripts/populate_mediafolder.sql diff --git a/dbscripts/populate_mediafolder.sql b/dbscripts/populate_mediafolder.sql new file mode 100755 index 00000000..08536c3c --- /dev/null +++ b/dbscripts/populate_mediafolder.sql @@ -0,0 +1,26 @@ +-- +-- Selected TOC Entries: +-- +-- +-- Data for TOC Entry ID 2 (OID 19073) +-- +-- Name: media_folder Type: TABLE DATA Owner: postgres +-- + + +\connect - postgres +-- Disable triggers +UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_folder'; + +INSERT INTO "media_folder" VALUES (7,'openposting','20020329','','openposting','media anonymously uploaded','2002-03-29 14:45:53+01',NULL); +-- Enable triggers +UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_folder'; + +-- +-- TOC Entry ID 1 (OID 18921) +-- +-- Name: media_folder_id_seq Type: SEQUENCE SET Owner: +-- + +SELECT setval ('"media_folder_id_seq"', 1, 't'); + -- 2.11.0