· 9 years ago · Jan 09, 2017, 12:14 AM
1CREATE TABLE IF NOT EXISTS `block` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `fristname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
4 `lastName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
5 `gender` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
6 `street` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
7 `city` varchar(90) COLLATE utf8_unicode_ci NOT NULL,
8 `state` varchar(90) COLLATE utf8_unicode_ci NOT NULL,
9 `blockid` text COLLATE utf8_unicode_ci NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;