· 8 years ago · Apr 15, 2018, 10:02 AM
1--
2-- Tábla szerkezet: `khenem_entry_b`
3--
4
5CREATE TABLE IF NOT EXISTS `khenem_entry_b` (
6 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
7 `gid` int(10) unsigned NOT NULL,
8 `fb_uid` varchar(25) NOT NULL,
9 `uname` text NOT NULL,
10 `email` text NOT NULL,
11 `question_seq` text NOT NULL,
12 `question_inc` int(3) unsigned NOT NULL DEFAULT '0',
13 `description` text NOT NULL,
14 `gender` tinyint(1) DEFAULT '1',
15 `point` int(10) NOT NULL DEFAULT '0',
16 `bonus` int(10) NOT NULL DEFAULT '0',
17 `is_completed` tinyint(1) DEFAULT '0',
18 `image` text NOT NULL,
19 `is_image_uploaded` tinyint(1) DEFAULT '0',
20 `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
21 `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
22 PRIMARY KEY (`id`),
23 KEY `fb_uid` (`fb_uid`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1008 ;