· 5 years ago · May 10, 2020, 03:34 PM
1INSERT INTO 'catetory_relations' ('Id', 'UUID', 'categoryId', 'ParentcategoryId') VALUES
2(1, NULL, 5, 1),
3(161, NULL, 11, 15),
4(160, NULL, 77, 6),
5(4, NULL, 8, 1),
6(5, NULL, 9, 1),
7(6, NULL, 10, 1),
8(8, NULL, 12, 2),
9(9, NULL, 13, 2),
10(10, NULL, 14, 2),
11(11, NULL, 15, 2),
12(12, NULL, 16, 2),
13(13, NULL, 17, 3),
14(14, NULL, 18, 3),
15(15, NULL, 19, 3),
16(16, NULL, 20, 3),
17(17, NULL, 21, 3),
18(18, NULL, 22, 3),
19(19, NULL, 23, 5),
20(20, NULL, 24, 5),
21(21, NULL, 25, 5),
22(22, NULL, 26, 5),
23(23, NULL, 27, 5),
24(24, NULL, 28, 5),
25(25, NULL, 29, 5),
26(26, NULL, 30, 6),
27(27, NULL, 31, 6),
28(28, NULL, 33, 8),
29(29, NULL, 34, 8),
30(30, NULL, 32, 8),
31(31, NULL, 35, 8),
32(32, NULL, 36, 10),
33(33, NULL, 37, 10),
34(34, NULL, 38, 10),
35(35, NULL, 39, 16),
36(36, NULL, 40, 16),
37(37, NULL, 41, 16),
38(38, NULL, 42, 16),
39(39, NULL, 43, 16),
40(40, NULL, 44, 16),
41(41, NULL, 45, 16),
42(42, NULL, 46, 15),
43(43, NULL, 47, 15),
44(44, NULL, 49, 13),
45(45, NULL, 48, 13),
46(46, NULL, 50, 13),
47(47, NULL, 51, 13),
48(48, NULL, 52, 11),
49(49, NULL, 53, 11),
50(50, NULL, 54, 11),
51(51, NULL, 56, 22),
52(52, NULL, 57, 22),
53(53, NULL, 58, 22),
54(54, NULL, 59, 22),
55(55, NULL, 60, 22),
56(56, NULL, 61, 22),
57(57, NULL, 62, 22),
58(58, NULL, 63, 21),
59(59, NULL, 64, 21),
60(60, NULL, 66, 19),
61(61, NULL, 65, 19),
62(62, NULL, 67, 19),
63(63, NULL, 68, 19),
64(95, NULL, 70, 17),
65(96, NULL, 71, 17),
66(97, NULL, 81, 10),
67(67, NULL, 76, 4),
68(137, NULL, 73, 72),
69(152, NULL, 74, 72),
70(70, NULL, 72, 4),
71(138, NULL, 75, 72),
72(72, NULL, 7, 6),
73(116, NULL, 89, 88),
74(94, NULL, 69, 17),
75(85, NULL, 79, 22),
76(90, NULL, 80, 16),
77(100, NULL, 82, 6),
78(103, NULL, 83, 6),
79(154, NULL, 108, 10),
80(108, NULL, 85, 9),
81(110, NULL, 85, 18),
82(111, NULL, 86, 10),
83(115, NULL, 78, 5),
84(117, NULL, 90, 11),
85(129, NULL, 92, 88),
86(128, NULL, 91, 1),
87(130, NULL, 93, 88),
88(131, NULL, 88, 1),
89(134, NULL, 95, 72),
90(133, NULL, 94, 72),
91(136, NULL, 96, 4),
92(139, NULL, 97, 76),
93(140, NULL, 98, 76),
94(141, NULL, 99, 76),
95(142, NULL, 100, 10),
96(145, NULL, 101, 88),
97(146, NULL, 102, 88),
98(148, NULL, 103, 88),
99(149, NULL, 104, 88),
100(150, NULL, 105, 96),
101(151, NULL, 106, 96),
102(153, NULL, 107, 96),
103(157, NULL, 6, 1),
104(163, NULL, 84, 6);
105
106DROP TABLE IF EXISTS 'Item';
107CREATE TABLE 'Item' (
108 'Id' int(11) NOT NULL AUTO_INCREMENT,
109 'CustomData' varchar(250) DEFAULT NULL,
110 'Number' varchar(250) DEFAULT NULL,
111 'Barcode' varchar(250) DEFAULT NULL,
112 'Name1' varchar(250) DEFAULT NULL,
113 'Name2' varchar(250) DEFAULT NULL,
114 'Name3' varchar(250) DEFAULT NULL,
115 'Note' longtext DEFAULT NULL,
116 'Discountgroup' varchar(250) DEFAULT NULL,
117 'Pricegroup' varchar(250) DEFAULT NULL,
118 'Statisticsgroup' varchar(250) DEFAULT NULL,
119 'Price' double DEFAULT 0,
120 'PriceCost' double DEFAULT 0,
121 'PriceRecRetail' double DEFAULT 0,
122 'Currency' varchar(3) DEFAULT 'DKK',
123 'VatRate' double DEFAULT 0,
124 'Group' varchar(250) DEFAULT NULL,
125 'Colli' varchar(250) DEFAULT NULL,
126 'AllowOrderDiscount' tinyint(1) DEFAULT 0,
127 'Stock' double DEFAULT 0,
128 'StockReserved' double DEFAULT 0,
129 'StockAvailable' double DEFAULT 0,
130 'StockOrdered' double DEFAULT 0,
131 'SupplierName' varchar(250) DEFAULT NULL,
132 'SupplierNumber' varchar(250) DEFAULT NULL,
133 'Weight' double DEFAULT 0,
134 'Volume' double DEFAULT 0,
135 'Dimensions' varchar(250) DEFAULT NULL,
136 'Unit' varchar(250) DEFAULT NULL,
137 'AltItemNumber' varchar(250) DEFAULT NULL,
138 'Image' blob DEFAULT NULL,
139 'SortPriority' double DEFAULT NULL,
140 'StockStatus' tinyint(1) DEFAULT NULL,
141 PRIMARY KEY ('Id')
142)