scripts/mir-setup/README: update with link to new doc on wiki

[mir.git] / dbscripts / help_users.sql

diff --git a/dbscripts/help_users.sql b/dbscripts/help_users.sql
index 42cb663..d5dc985 100755 (executable)
--- a/dbscripts/help_users.sql
+++ b/dbscripts/help_users.sql
@@ -1,11 +1,5 @@
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
-\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');
-INSERT INTO "webdb_users" VALUES (4,'admin','indymedia','t');
-BEGIN TRANSACTION;
-CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint);
-INSERT INTO "tr" SELECT C."relname", count(T."oid") FROM "pg_class" C, "pg_trigger" T WHERE C."oid" = T."tgrelid" AND C."relname" !~ '^pg_' GROUP BY 1;
-UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr" TMP WHERE "pg_class"."relname" = TMP."tmp_relname";
-COMMIT TRANSACTION;
+INSERT INTO webdb_users(login, password, is_admin, comment, is_disabled, email, profile, webdb_create)
+VALUES ('open', '', 'f', 'Default open posting user', 'f', '', '', now());
+
+INSERT INTO webdb_users(login, password, is_admin, comment, is_disabled, email, profile, webdb_create)
+VALUES ('admin', 'indymedia', 't', 'Default admin user', 'f', '', '', now());