· 8 years ago · Jan 26, 2018, 04:00 AM
1CREATE TABLE IF NOT EXISTS `events` (
2 `event_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
3 `title` varchar(255) DEFAULT NULL,
4 `venue_id` int(6) unsigned NOT NULL DEFAULT '1',
5 `contact_id` int(6) unsigned NOT NULL DEFAULT '1',
6 `description` text,
7 `category_id` int(6) unsigned NOT NULL DEFAULT '1',
8 `user_id` int(6) unsigned DEFAULT NULL,
9 `group_id` int(6) unsigned NOT NULL DEFAULT '1',
10 `status_id` int(1) unsigned NOT NULL DEFAULT '1',
11 `stamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
12 `quick_approve` varchar(32) DEFAULT NULL,
13 `date` datetime NOT NULL,
14 PRIMARY KEY (`event_id`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;