|
1
|
|
|
2
|
|
|
3
|
|
|
4
|
CREATE TABLE `vnc_numberx_info` (
|
|
5
|
`appkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' ,
|
|
6
|
`numberX` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
|
|
7
|
`callBackUrl` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
8
|
`callStateUrl` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
9
|
`createTime` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
10
|
`updateTime` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
11
|
INDEX `ix_appkey` (`appkey`) USING BTREE ,
|
|
12
|
INDEX `ix_number` (`numberX`) USING BTREE
|
|
13
|
)
|
|
14
|
ENGINE=InnoDB
|
|
15
|
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
|
|
16
|
|
|
17
|
;
|
|
18
|
|
|
19
|
|
|
20
|
|
|
21
|
|
|
22
|
CREATE TABLE `vnc_template_info` (
|
|
23
|
`appkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
|
|
24
|
`templateId` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' ,
|
|
25
|
`type` int(11) NOT NULL DEFAULT 0 ,
|
|
26
|
`content` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
27
|
`status` int(11) NOT NULL DEFAULT '-1' ,
|
|
28
|
`createTime` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
29
|
`reviewTime` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
|
|
30
|
INDEX `idx_appkey` (`appkey`) USING BTREE ,
|
|
31
|
INDEX `idx_templateid` (`templateId`) USING BTREE
|
|
32
|
)
|
|
33
|
ENGINE=InnoDB
|
|
34
|
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
|
|
35
|
|
|
36
|
;
|