· 8 years ago · Dec 10, 2017, 05:50 PM
1CREATE TABLE IF NOT EXISTS `sponsorships` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4 `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 `birth_date` date NOT NULL,
7 `civility` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
8 `news_opt` tinyint(1) NOT NULL,
9 `sponsor_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB