· 8 years ago · Feb 20, 2018, 08:30 PM
1CREATE TABLE IF NOT EXISTS `countries` (
2`id` int(10) unsigned NOT NULL,
3 `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
4 `flagpic` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
5) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
6
7ALTER TABLE `countries`
8 ADD PRIMARY KEY (`id`);
9
10ALTER TABLE `countries`
11MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;