START TRANSACTION;
CREATE USER "vidw" WITH ENCRYPTED PASSWORD 'ce268fc489729387e6d34c5b193cd39ce7428c7fb81b3d88aa43979e024c9e52632f679cafe3913c9e87501bd64e2493ba24aae61c5a9f860c0ef21267b9e0e3' NAME 'VIdw Data mining' SCHEMA "sys";
CREATE SCHEMA "vidw" AUTHORIZATION "vidw";
ALTER USER "vidw" SET SCHEMA "vidw";
CREATE SEQUENCE "vidw"."seq_4332" AS INTEGER;
CREATE SEQUENCE "vidw"."seq_4359" AS INTEGER;
CREATE SEQUENCE "vidw"."seq_4371" AS INTEGER;
CREATE SEQUENCE "vidw"."seq_4398" AS INTEGER;
CREATE SEQUENCE "vidw"."seq_4437" AS INTEGER;
CREATE SEQUENCE "vidw"."seq_4529" AS INTEGER;
CREATE SEQUENCE "vidw"."seq_4588" AS INTEGER;
SET SCHEMA "vidw";
CREATE TABLE "vidw"."dim_store" (
	"id" smallint NOT NULL,
	"storenumber" smallint,
	"name" char(50),
	CONSTRAINT "pk_dim_store" PRIMARY KEY ("id")
);
COPY 2 RECORDS INTO "vidw"."dim_store" FROM stdin USING DELIMITERS '\t';
1	3	"Butik #3                                          "
2	5	"Matpressen                                        "
CREATE TABLE "vidw"."dim_itemgroup" (
	"id" smallint NOT NULL,
	"itemgroup" smallint,
	"transtype" smallint,
	"moms" smallint,
	"momstyp" char(1),
	"descr" varchar(30),
	CONSTRAINT "pk_dim_itemgroup" PRIMARY KEY ("id")
);
COPY 377 RECORDS INTO "vidw"."dim_itemgroup" FROM stdin USING DELIMITERS '\t';
1	-1	9	0	"0"	"Vet ej"
2	-1	10	0	"0"	"Vet ej"
3	-1	40	0	"0"	"Vet ej"
4	101	9	12	"V"	"Sas                           "
5	102	9	12	"V"	"Dressing                      "
6	103	9	12	"V"	"Majonnas                      "
7	104	9	12	"V"	"attika                        "
8	105	9	12	"V"	"Vinager                       "
9	106	9	12	"V"	"Olja                          "
10	106	10	12	"V"	"Olja                          "
11	107	9	12	"V"	"Soya                          "
12	108	9	12	"V"	"Ketchup/chilisas              "
13	108	10	12	"V"	"Ketchup/chilisas              "
14	109	9	12	"V"	"Senap                         "
15	110	9	12	"V"	"Buljong/fond                  "
16	111	9	12	"V"	"Kryddor                       "
17	111	10	12	"V"	"Kryddor                       "
18	112	9	12	"V"	"Salt                          "
19	113	9	12	"V"	"Soppa                         "
20	114	9	12	"V"	"Kott/mat konserv              "
21	115	9	12	"V"	"Vegetariska specerier         "
22	116	9	12	"V"	"Matmixer                      "
23	117	9	12	"V"	"Mexikansk mat                 "
24	117	10	12	"V"	"Mexikansk mat                 "
25	118	9	12	"V"	"Gronsaks konserv              "
26	119	9	12	"V"	"Fiskkonserver                 "
27	120	9	12	"V"	"Skaldjurskonserver            "
28	121	9	12	"V"	"Nudlar                        "
29	122	9	12	"V"	"Pasta                         "
30	122	10	12	"V"	"Pasta                         "
31	123	9	12	"V"	"Matris                        "
32	123	10	12	"V"	"Matris                        "
33	124	9	12	"V"	"Pulvermos                     "
34	125	9	12	"V"	"Gryn/bonor/artor              "
35	125	10	12	"V"	"Gryn/bonor/artor              "
36	126	9	12	"V"	"Kosttillskott                 "
37	127	9	12	"V"	"Lagkalori maltidslosningar    "
38	128	9	25	"V"	"Naturlakemedel                "
39	129	9	12	"V"	"Mjol                          "
40	130	9	12	"V"	"Bakmixer                      "
41	131	9	12	"V"	"Mjolkprodukter                "
42	132	9	12	"V"	"Bakartiklar                   "
43	133	9	12	"V"	"Konservering                  "
44	134	9	12	"V"	"Socker/sotning                "
45	135	9	12	"V"	"Marmelad/Smaksattare          "
46	136	9	12	"V"	"Sylt                          "
47	136	10	12	"V"	"Sylt                          "
48	137	9	12	"V"	"appelmos                      "
49	138	9	12	"V"	"Gele                          "
50	139	9	12	"V"	"Frukt konserv                 "
51	139	10	12	"V"	"Frukt konserv                 "
52	140	9	12	"V"	"Torkad frukt                  "
53	141	9	12	"V"	"Julartiklar lag moms          "
54	142	9	12	"V"	"Dessert                       "
55	143	9	12	"V"	"Glasstillbehor                "
56	143	10	12	"V"	"Glasstillbehor                "
57	144	9	12	"V"	"Flingor/Musli                 "
58	145	9	12	"V"	"Vuxen valling/grot            "
59	146	9	12	"V"	"Kaffe                         "
60	146	10	12	"V"	"Kaffe                         "
61	147	9	25	"V"	"Filter                        "
62	148	9	12	"V"	"Te                            "
63	149	9	12	"V"	"Choklad                       "
64	150	9	12	"V"	"Saft                          "
65	151	9	12	"V"	"Snacks                        "
66	151	10	12	"V"	"Snacks                        "
67	152	9	12	"V"	"Konfektyr                     "
68	152	10	12	"V"	"Konfektyr                     "
69	153	9	12	"V"	"Barnmat                       "