tasks_info

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
CREATE TABLE IF NOT EXISTS `tasks` (
`id` int(11) NOT NULL auto_increment,
`active enum('0','1'),
`key` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`address` varchar(255) NOT NULL,
`addrees_2` varchar(255) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(3) NOT NULL,
`zip` int(5) NOT NULL,
`home_phone` varchar(25) NOT NULL,
`mobile_phone` varchar(25) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;