12FaSWb1

1DROP TABLE IF EXISTS `Messages`;
2CREATE TABLE `Messages` (
3  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,
4  `AppID` int(11) unsigned NOT NULL,
5  `type` int(11) NOT NULL,
6  `version` int(11) NOT NULL,
7  `engagement` int(11),
8  `messageId` int(11),
9  `ppId` int(11),
10  `triggers` mediumblob,
11  `body` mediumblob,
12  `created` bigint(20) NOT NULL,
13  `modified` bigint(20) NOT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17
18DROP TABLE IF EXISTS `Engagements`;
19CREATE TABLE `Engagements` (
20  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,
21  `title` varchar(255) BINARY NOT NULL,
22  `AppID` int(11) unsigned NOT NULL,
23  `engagementId` int(11),
24  `version` int(11) NOT NULL,
25  `target` mediumblob,
26  `locations` mediumblob,
27  `schedule` mediumblob,
28  `draft` tinyint(1),
29  `startDate` bigint(20),
30  `stopDate` bigint(20),
31  `created` bigint(20) NOT NULL,
32  `modified` bigint(20) NOT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35
36DROP TABLE IF EXISTS `Locations`;
37CREATE TABLE `Locations` (
38  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,   
39  `name` varchar(255) BINARY NOT NULL,
40  `location` mediumblob, 
41  `AppID` int(11) unsigned NOT NULL,
42  `created` bigint(20) NOT NULL,
43  `modified` bigint(20) NOT NULL,
44  
45  PRIMARY KEY (`id`) 
46) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47
48DROP TABLE IF EXISTS `Targets`;
49CREATE TABLE `Targets` (
50  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,   
51  `name` varchar(255) BINARY NOT NULL,
52  `target` mediumblob,
53  `AppID` int(11) unsigned NOT NULL,
54  `created` bigint(20) NOT NULL,
55  `modified` bigint(20) NOT NULL,
56  PRIMARY KEY (`id`) 
57) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58
59
60DROP TABLE IF EXISTS `MessageCursors`;
61CREATE TABLE `MessageCursors` (
62  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,   
63  `current` int(11) NOT NULL, 
64  PRIMARY KEY (`id`) 
65) ENGINE=InnoDB DEFAULT CHARSET=utf8;
66
67DROP TABLE IF EXISTS `EngagementCursors`;
68CREATE TABLE `EngagementCursors` (
69  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,   
70  `current` int(11) NOT NULL, 
71  PRIMARY KEY (`id`) 
72) ENGINE=InnoDB DEFAULT CHARSET=utf8;
73
74DROP TABLE IF EXISTS `Groups`;
75CREATE TABLE `Groups` (
76  `id` int(11) NOT NULL AUTO_INCREMENT UNIQUE,
77  `appid` int(11) unsigned NOT NULL,
78  `name` varchar(255) BINARY NOT NULL,
79  `created` bigint(20) NOT NULL,
80  `modified` bigint(20) NOT NULL,
81  PRIMARY KEY (`id`) 
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;