· 7 years ago · Nov 06, 2018, 06:18 PM
1-- Adminer 4.6.3 PostgreSQL dump
2
3DROP TABLE IF EXISTS "customer";
4CREATE TABLE "public"."customer" (
5 "uuid" uuid NOT NULL,
6 "cardnumber" bigint,
7 "cardtype" character varying(255),
8 "cardvalidity" timestamp,
9 "name" character varying(255),
10 "nif" bigint,
11 "number_of_vouchers_gained" integer,
12 "publickey" bytea,
13 "total_price_paid" double precision,
14 "username" character varying(255),
15 CONSTRAINT "customer_pkey" PRIMARY KEY ("uuid")
16) WITH (oids = false);
17
18INSERT INTO "customer" ("uuid", "cardnumber", "cardtype", "cardvalidity", "name", "nif", "number_of_vouchers_gained", "publickey", "total_price_paid", "username") VALUES
19('695a57c6-89a4-4187-9ad8-2ee320d47327', 505433, 'MasterCard', '2019-08-18 01:00:00', 'Marta torgal', 244439486, '0', NULL, 0, 'anaconda18'),
20('303452fe-dd14-11e8-9f8b-f2801f1b9fd1', 12345700, 'Credit', '2018-08-19 00:00:00', 'Marta', 123456, '0', NULL, 0, 'anaconda18'),
21('7b99b698-e125-11e8-9f32-f2801f1b9fd1', 12345200, 'VISA', '2018-08-19 00:00:00', 'Cristiana', 24411422, 11, NULL, 1162, 'chizona');
22
23DROP TABLE IF EXISTS "event";
24CREATE TABLE "public"."event" (
25 "uuid" uuid NOT NULL,
26 "date" timestamp,
27 "description" character varying(255),
28 "name" character varying(255),
29 "photo" character varying(255),
30 "price" double precision,
31 "room" character varying(255),
32 "type_of_concert" character varying(255),
33 CONSTRAINT "event_pkey" PRIMARY KEY ("uuid")
34) WITH (oids = false);
35
36INSERT INTO "event" ("uuid", "date", "description", "name", "photo", "price", "room", "type_of_concert") VALUES
37('1b993a6c-dd2d-11e8-88b0-f2801f1b9fd1', '2018-10-31 00:00:00', 'ganda diufidamds', 'o nome do evento', NULL, 100.05, 'sala316', 'rock'),
38('3b9acf62-dde4-11e8-9f32-f2801f1b9fd1', '2018-10-31 00:00:00', 'descricao top', 'nome do evento', NULL, 52.5, 'sala317', 'rock'),
39('b06ca5aa-de92-11e8-9f32-f2801f1b9fd1', '2018-10-30 00:00:00', 'top top top', 'evento Name', NULL, 175.5, 'sala', 'classic');
40
41DROP TABLE IF EXISTS "invoice";
42CREATE TABLE "public"."invoice" (
43 "uuid" uuid NOT NULL,
44 "date" date,
45 "number" integer,
46 "totalprice" double precision,
47 "customer_id" uuid NOT NULL,
48 CONSTRAINT "invoice_pkey" PRIMARY KEY ("uuid"),
49 CONSTRAINT "fk5e32ukwo9uknwhylogvta4po6" FOREIGN KEY (customer_id) REFERENCES customer(uuid) ON DELETE CASCADE NOT DEFERRABLE
50) WITH (oids = false);
51
52INSERT INTO "invoice" ("uuid", "date", "number", "totalprice", "customer_id") VALUES
53('e3a4001a-d27d-44b4-a54a-af0eb1842601', '2018-11-03', '0', 5, '695a57c6-89a4-4187-9ad8-2ee320d47327'),
54('0dce2fca-6b83-4aad-b7b8-65a8c7ad3bc2', '2018-11-03', 1, 16.625, '695a57c6-89a4-4187-9ad8-2ee320d47327'),
55('0453c03b-1933-42b4-8508-72e5f894cbd3', '2018-11-03', 2, 16.625, '695a57c6-89a4-4187-9ad8-2ee320d47327'),
56('ee197ece-a2ff-4f48-a180-b8539bd52641', '2018-11-03', 3, 16.625, '695a57c6-89a4-4187-9ad8-2ee320d47327'),
57('d4305d96-8407-4f01-9978-e49228d889d4', '2018-11-03', 4, 16.625, '695a57c6-89a4-4187-9ad8-2ee320d47327'),
58('4ac0c345-a4ce-4518-94e1-168e4b09a005', '2018-11-03', 5, 16.625, '695a57c6-89a4-4187-9ad8-2ee320d47327'),
59('b5bb4389-5a73-4981-acf0-44bfd7887da7', '2018-11-03', 6, 16.625, '695a57c6-89a4-4187-9ad8-2ee320d47327');
60
61DROP TABLE IF EXISTS "invoice_products";
62CREATE TABLE "public"."invoice_products" (
63 "invoice_uuid" uuid NOT NULL,
64 "products_uuid" uuid NOT NULL,
65 CONSTRAINT "fk7rg66ohctekmspujbreinvhpe" FOREIGN KEY (invoice_uuid) REFERENCES invoice(uuid) NOT DEFERRABLE,
66 CONSTRAINT "fkknhbnrhsvbxtdigvrauihacki" FOREIGN KEY (products_uuid) REFERENCES product(uuid) NOT DEFERRABLE
67) WITH (oids = false);
68
69INSERT INTO "invoice_products" ("invoice_uuid", "products_uuid") VALUES
70('0453c03b-1933-42b4-8508-72e5f894cbd3', '97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1'),
71('0453c03b-1933-42b4-8508-72e5f894cbd3', 'a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1'),
72('0453c03b-1933-42b4-8508-72e5f894cbd3', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1'),
73('ee197ece-a2ff-4f48-a180-b8539bd52641', '97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1'),
74('ee197ece-a2ff-4f48-a180-b8539bd52641', 'a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1'),
75('ee197ece-a2ff-4f48-a180-b8539bd52641', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1'),
76('d4305d96-8407-4f01-9978-e49228d889d4', '97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1'),
77('d4305d96-8407-4f01-9978-e49228d889d4', 'a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1'),
78('d4305d96-8407-4f01-9978-e49228d889d4', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1'),
79('4ac0c345-a4ce-4518-94e1-168e4b09a005', '97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1'),
80('4ac0c345-a4ce-4518-94e1-168e4b09a005', 'a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1'),
81('4ac0c345-a4ce-4518-94e1-168e4b09a005', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1'),
82('b5bb4389-5a73-4981-acf0-44bfd7887da7', '97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1'),
83('b5bb4389-5a73-4981-acf0-44bfd7887da7', 'a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1'),
84('b5bb4389-5a73-4981-acf0-44bfd7887da7', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1'),
85('e3a4001a-d27d-44b4-a54a-af0eb1842601', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1'),
86('0dce2fca-6b83-4aad-b7b8-65a8c7ad3bc2', '97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1'),
87('0dce2fca-6b83-4aad-b7b8-65a8c7ad3bc2', 'a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1'),
88('0dce2fca-6b83-4aad-b7b8-65a8c7ad3bc2', 'aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1');
89
90DROP TABLE IF EXISTS "product";
91CREATE TABLE "public"."product" (
92 "uuid" uuid NOT NULL,
93 "name" character varying(255),
94 "price" double precision,
95 CONSTRAINT "product_pkey" PRIMARY KEY ("uuid")
96) WITH (oids = false);
97
98INSERT INTO "product" ("uuid", "name", "price") VALUES
99('97cf1c92-dd1d-11e8-9f8b-f2801f1b9fd1', 'popcorn', 10),
100('a5e4d57e-dd1d-11e8-9f8b-f2801f1b9fd1', 'coffee', 2.5),
101('aa90c2c2-dd1d-11e8-ab8b-f2801f1b9fd1', 'sandwich', 5);
102
103DROP TABLE IF EXISTS "ticket";
104CREATE TABLE "public"."ticket" (
105 "uuid" uuid NOT NULL,
106 "seat" integer,
107 "used" boolean NOT NULL,
108 "customer_id" uuid NOT NULL,
109 "event_id" uuid NOT NULL,
110 CONSTRAINT "ticket_pkey" PRIMARY KEY ("uuid"),
111 CONSTRAINT "fkfytuhjopeamxbt1cpudy92x5n" FOREIGN KEY (event_id) REFERENCES event(uuid) ON DELETE CASCADE NOT DEFERRABLE,
112 CONSTRAINT "fkmli0eqrecnnqvdgv3kcx7d9m8" FOREIGN KEY (customer_id) REFERENCES customer(uuid) ON DELETE CASCADE NOT DEFERRABLE
113) WITH (oids = false);
114
115INSERT INTO "ticket" ("uuid", "seat", "used", "customer_id", "event_id") VALUES
116('c5eca606-34df-4983-a3d8-a6c616ec64f0', 43, '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', '1b993a6c-dd2d-11e8-88b0-f2801f1b9fd1'),
117('32fd7946-791c-4068-adcb-17d84e833442', 91, '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', '1b993a6c-dd2d-11e8-88b0-f2801f1b9fd1'),
118('7d7f0785-bfed-4850-9071-d34512c5ef38', 25, '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', '1b993a6c-dd2d-11e8-88b0-f2801f1b9fd1'),
119('cdb80273-bc83-4f95-afeb-c550c189aca5', 42, '1', '695a57c6-89a4-4187-9ad8-2ee320d47327', '1b993a6c-dd2d-11e8-88b0-f2801f1b9fd1');
120
121DROP TABLE IF EXISTS "voucher";
122CREATE TABLE "public"."voucher" (
123 "uuid" uuid NOT NULL,
124 "discount_code" character varying(255),
125 "state" boolean NOT NULL,
126 "customer_id" uuid NOT NULL,
127 "invoice_id" uuid,
128 CONSTRAINT "voucher_pkey" PRIMARY KEY ("uuid"),
129 CONSTRAINT "fk4owsm9wjgdt37tvm2i3o5kmpu" FOREIGN KEY (invoice_id) REFERENCES invoice(uuid) ON DELETE CASCADE NOT DEFERRABLE,
130 CONSTRAINT "fk54x7dllq1ts557joc0cunvyk9" FOREIGN KEY (customer_id) REFERENCES customer(uuid) ON DELETE CASCADE NOT DEFERRABLE
131) WITH (oids = false);
132
133INSERT INTO "voucher" ("uuid", "discount_code", "state", "customer_id", "invoice_id") VALUES
134('78804708-dd22-11e8-9f8b-f2801f1b9fd1', 'popcorn', '1', '695a57c6-89a4-4187-9ad8-2ee320d47327', 'e3a4001a-d27d-44b4-a54a-af0eb1842601'),
135('5b2eb4cc-ded1-11e8-9f32-f2801f1b9fd1', 'coffee', '1', '695a57c6-89a4-4187-9ad8-2ee320d47327', 'e3a4001a-d27d-44b4-a54a-af0eb1842601'),
136('a67733c1-e55e-4f27-86ad-b2380a34d67f', '5%', '1', '695a57c6-89a4-4187-9ad8-2ee320d47327', '4ac0c345-a4ce-4518-94e1-168e4b09a005'),
137('3221c31d-1abb-41df-a94e-ec7b6731ef25', '5%', '1', '695a57c6-89a4-4187-9ad8-2ee320d47327', 'b5bb4389-5a73-4981-acf0-44bfd7887da7'),
138('42f36c94-4ac6-45d4-96b4-770c4d0cbd29', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
139('92007668-4120-4d6c-93b0-1d30e176ead9', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
140('137880b2-21ff-4987-a29b-9b06ae876127', 'popcorn', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
141('2745fc26-5335-4000-9496-ad4885908782', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
142('c43c868b-1d8b-4a46-97d0-c65d8d0b481e', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
143('471a8cf6-6a6c-44d6-b910-691785a6a65b', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
144('4a8af7af-3d5f-4b66-bcd2-cb7b613a8980', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
145('51aa2154-c741-4319-aaee-81854916a297', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
146('02c2816c-4c46-4cd5-839c-6c288b7a679b', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
147('87a6a8d8-c420-443e-80f5-4754ddbf8d5f', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
148('0dc621a4-d6a4-4d38-9295-90b586860f57', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
149('855a03f4-dced-4342-95c6-318d52d084f9', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
150('ea04c857-f950-4c54-8043-1562c6aa0c6e', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
151('a1b3bdc0-d274-4817-b799-ea9bfbb0da98', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
152('48771621-f4f5-419b-9744-40c3259dea5c', 'popcorn', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
153('eb4ef984-5a7b-40f2-bea4-c7e309055dd9', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
154('5fc78bca-1229-4c9c-acc0-7208a8c315fe', 'popcorn', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
155('74542fa2-533e-4a3c-89ab-9b4c03d1da31', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
156('0f5a282c-38b3-4a83-83e1-93118efe3ee5', 'coffee', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL),
157('8ae17c7f-1772-4f76-976b-2a3d026151fd', '5%', '0', '695a57c6-89a4-4187-9ad8-2ee320d47327', NULL);
158
159-- 2018-11-06 09:09:13.481009+00