-
Notifications
You must be signed in to change notification settings - Fork 4
/
default_sync.sql
37 lines (30 loc) · 754 Bytes
/
default_sync.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
/*
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;
-- ----------------------------
-- Table structure for prods
-- ----------------------------
CREATE TABLE IF NOT EXISTS orders (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"bol_id" INTEGER NOT NULL,
"edc_id" INTEGER,
"tnt_track" TEXT
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_bol"
ON "orders" (
"bol_id"
);
CREATE UNIQUE INDEX IF NOT EXISTS "unique_edc"
ON "orders" (
"edc_id"
);
PRAGMA foreign_keys = true;