-
Notifications
You must be signed in to change notification settings - Fork 4
/
default.sql
127 lines (111 loc) · 2.69 KB
/
default.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
/*
Navicat Premium Data Transfer
Source Server : dropship
Source Server Type : SQLite
Source Server Version : 3026000
Source Schema : main
Target Server Type : SQLite
Target Server Version : 3026000
File Encoding : 65001
Date: 06/04/2019 17:10:59
*/
PRAGMA foreign_keys = false;
CREATE TABLE IF NOT EXISTS brands (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"slug" text not null,
"name" TEXT NOT NULL,
"discount" INTEGER NOT NULL
);
-- ----------------------------
-- Table structure for prods
-- ----------------------------
CREATE TABLE IF NOT EXISTS prods (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"slug" TEXT NOT NULL,
"title" TEXT NOT NULL,
"description" TEXT NOT NULL,
"ean" TEXT NOT NULL,
"stock" INTEGER,
"price" real NOT NULL,
"price_me" real NOT NULL,
"vat" integer not null,
"brand_id" integer not null,
"discount" integer not null,
"time_updated" TEXT NOT NULL,
"edc_artnum" TEXT NOT NULL,
"bol_id" text,
"bol_updated" text,
"bol_error" INTEGER,
"prod_id" INTEGER,
"cats" TEXT NOT NULL,
"bol_stock" INTEGER,
"bol_pending" INTEGER,
"bol_price" real,
"calc_price_bol" real not null,
"calc_price_site" real not null
);
CREATE TABLE IF NOT EXISTS bol_prods (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"name" TEXT NOT NULL,
"chunkid" TEXT NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_bol_prod"
ON "bol_prods" (
"chunkid"
);
CREATE TABLE IF NOT EXISTS bol_prod_attrs (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"bol_prod_id" INTEGER NOT NULL,
"name" TEXT NOT NULL,
"label" TEXT NOT NULL,
"definition" TEXT
);
-- ----------------------------
-- Indexes structure for table prods
-- ----------------------------
CREATE UNIQUE INDEX IF NOT EXISTS "unique_ean"
ON "prods" (
"ean" ASC,
"id"
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_bol"
ON "prods" (
"bol_id" ASC
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_prodslug"
ON "prods" (
"slug" ASC
);
CREATE TABLE IF NOT EXISTS cats (
"id" INTEGER NOT NULL,
"slug" text not null,
"title" TEXT NOT NULL,
PRIMARY KEY ("id")
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_cat"
ON "cats" (
"title"
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_cat_slug"
ON "cats" (
"slug"
);
CREATE TABLE IF NOT EXISTS bol_del (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"bol_id" text,
"tm_added" TEXT NOT NULL,
"tm_synced" TEXT
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_boldel"
ON "bol_del" (
"bol_id"
);
CREATE TABLE IF NOT EXISTS prod_img (
"ean" TEXT NOT NULL PRIMARY KEY,
"count" INTEGER NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_prodimg"
ON "prod_img" (
"ean"
);
PRAGMA foreign_keys = true;