Uh oh!
There was an error while loading. Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb-setup.sql
More file actions
Latest commit
54 lines (44 loc) · 1.59 KB
/
Copy pathdb-setup.sql
File metadata and controls
54 lines (44 loc) · 1.59 KB
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
SET SQL_MODE ="NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT =0;
START TRANSACTION;
SET time_zone ="+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
-- --------------------------------------------------------
--
-- Table structure for table `events`
--
DROPTABLE IF EXISTS `events`;
CREATETABLEIF NOT EXISTS `events` (
`id`int(11) NOT NULL AUTO_INCREMENT,
`name`varchar(191) DEFAULT NULL,
`location`varchar(191) DEFAULT NULL,
`description`varchar(191) DEFAULT NULL,
`start_date`DATE DEFAULT NULL,
`start_time`varchar(191) DEFAULT NULL,
`end_date`DATE DEFAULT NULL,
`end_time`varchar(191) DEFAULT NULL,
`repeat_id`varchar(191) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `start_date asc` (`start_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `repeat_events`
--
DROPTABLE IF EXISTS `repeat_events`;
CREATETABLEIF NOT EXISTS `repeat_events` (
`id`int(11) NOT NULL AUTO_INCREMENT,
`freq`varchar(191) DEFAULT NULL,
`interval_num`int(191) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `freq_id_interval_num` (`freq`,`id`,`interval_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;