wxGifHelper/init.sql at master · lozzo/wxGifHelper · GitHub

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
DROP TABLE IF EXISTS `gifs`;
DROP TABLE IF EXISTS `users`;
DROP TABLE IF EXISTS `wxUsers`;
DROP TABLE IF EXISTS `tgUsers`;
DROP TABLE IF EXISTS `gifGroups`;
DROP TABLE IF EXISTS `ReportedGifs`;


CREATE TABLE `gifs`
(
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `GroupID` INTEGER  NULL DEFAULT NULL,
    `FileID` CHAR
(40) NOT NULL,
    `UserID` INTEGER NOT NULL,
    PRIMARY KEY
(`id`)
);

CREATE TABLE `wxUsers`
(
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `openID` CHAR
(40) NOT NULL,
    `nickName` CHAR
(40) NOT NULL DEFAULT "",
    PRIMARY KEY
(`id`),
    UNIQUE
(`openID`)
);

CREATE TABLE `ReportedGifs`
(   `id` INTEGER NOT NULL AUTO_INCREMENT,
    `FileID` CHAR(40) NOT NULL,
    `UserID` INTEGER NOT NULL,
    PRIMARY KEY(`id`)
);

CREATE TABLE `tgUsers`
(
    `id` INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY
(`id`)
);

CREATE TABLE `users`
(
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `tgUserID` INTEGER NULL DEFAULT NULL,
    `wxUserID` INTEGER  NOT NULL,
    PRIMARY KEY
(`id`)
);


CREATE TABLE `gifGroups`
(
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `name` CHAR
(40) NOT NULL DEFAULT "",
    PRIMARY KEY
(`id`)
);

ALTER TABLE `gifs`
ADD FOREIGN KEY
(GroupID) REFERENCES `gifGroups`
(`id`);
ALTER TABLE `gifs`
ADD FOREIGN KEY
(UserID) REFERENCES `users`
(`id`);
ALTER TABLE `users`
ADD FOREIGN KEY
(tgUserID) REFERENCES `tgUsers`
(`id`);
ALTER TABLE `users`
ADD FOREIGN KEY
(wxUserID) REFERENCES `wxUsers`
(`id`);


INSERT INTO tgUsers
    (id)
VALUES
    (0);
INSERT INTO