Changeset: 5d9fcf84c799 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5d9fcf84c799
Added Files:
dump_output.sql
Branch: monetdbe-proxy
Log Message:
Add helper script to test dump.sql.
diffs (41 lines):
diff --git a/dump_output.sql b/dump_output.sql
new file mode 100644
--- /dev/null
+++ b/dump_output.sql
@@ -0,0 +1,36 @@
+START TRANSACTION;
+CREATE ROLE "king";
+CREATE USER "voc" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA sys;
+CREATE USER "voc2" WITH ENCRYPTED PASSWORD
'ea45cf4e124b215a28631ec7ff0bf06e82fc26b2be7a066c9594855690fb5d42438be58d6523132384a1738cb4e5139caa1f970ebdfb422d65834d9a4ef61c0e'
NAME 'VOC Explorer' SCHEMA sys;
+CREATE SCHEMA "sbar" AUTHORIZATION monetdb;
+CREATE SCHEMA "sfoo" AUTHORIZATION monetdb;
+COMMENT ON SCHEMA "sbar" IS 'This is a comment on sbar' ;
+ALTER USER "voc" SET SCHEMA "sfoo";
+CREATE SEQUENCE "sys"."seq_18814" AS INTEGER;
+CREATE SEQUENCE "sys"."seq_8219" AS INTEGER;
+CREATE SEQUENCE "sys"."seq_9119" AS INTEGER;
+CREATE SEQUENCE "sys"."seq_8917" AS INTEGER;
+COMMENT ON SEQUENCE "sys"."seq_8219" IS 'This is a comment on a sequence.' ;
+CREATE TABLE "sys"."test" ("s" CHARACTER LARGE OBJECT);
+CREATE TABLE "sys"."bla" ("s" CHARACTER LARGE OBJECT(10));
+CREATE TABLE "sys"."bob" ("ts" TIMESTAMP(3) );
+CREATE TABLE "sys"."fdgdf" ("tsz" TIMESTAMP(4) WITH TIME ZONE);
+CREATE TABLE "sys"."yoyo" ("tsz" CHARACTER LARGE OBJECT DEFAULT 'BLABOLO');
+CREATE TABLE "sys"."bolo" ("s" CHARACTER LARGE OBJECT NOT NULL, "v" CHARACTER
LARGE OBJECT NOT NULL);
+CREATE TABLE "sys"."rolo" ("v" CHARACTER LARGE OBJECT NOT NULL);
+CREATE TABLE "sys"."ungolo" ("x" INTEGER, "y" INTEGER, "z" INTEGER);
+CREATE TABLE "sfoo"."tfoo" ("i" INTEGER);
+CREATE TABLE "sfoo"."test" ("s" CHARACTER LARGE OBJECT);
+CREATE TABLE "sys"."pfoo1" ("i" INTEGER);
+CREATE TABLE "sys"."pfoo2" ("i" INTEGER);
+CREATE REMOTE TABLE "sys"."rfoo" ("i" INTEGER) ON
'mapi:monetdb://remote.host.url:50000/dbname' WITH USER 'bob' ENCRYPTED
PASSWORD
'4a3ed8147e37876adc8f76328e5abcc1b470e6acfc18efea0135f983604953a58e183c1a6086e91ba3e821d926f5fdeb37761c7ca0328a963f5e92870675b728'
;
+ALTER TABLE "bolo" ADD CONSTRAINT "cpk" PRIMARY KEY ("s", "v");
+ALTER TABLE "rolo" ADD CONSTRAINT "rolo_v_pkey" PRIMARY KEY ("v");
+ALTER TABLE "ungolo" ADD CONSTRAINT "ungolo_x_y_unique" UNIQUE ("x", "y");
+ALTER TABLE "ungolo" ADD CONSTRAINT "ungolo_z_unique" UNIQUE ("z");
+CREATE MERGE TABLE scorers (name clob, first_score int, second_score int)
PARTITION BY VALUES USING (greatest(first_score, second_score) % 10);
+CREATE TABLE lower_scorers (name clob, first_score int, second_score int);
+CREATE TABLE higher_scorers (name clob, first_score int, second_score int);
+ALTER TABLE scorers ADD TABLE lower_scorers AS PARTITION IN (0, 1, 2, 3, 4);
+ALTER TABLE scorers ADD TABLE higher_scorers AS PARTITION IN (5, 6, 7, 8, 9);
+COMMIT;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
