· 6 years ago · Apr 19, 2019, 11:08 AM
1--
2-- table `contact` structure
3--
4
5CREATE TABLE IF NOT EXISTS `contact` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `name` varchar(30) COLLATE utf8_czech_ci NOT NULL,
8 `surname` varchar(30) COLLATE utf8_czech_ci NOT NULL,
9 `email` varchar(150) COLLATE utf8_czech_ci DEFAULT NULL,
10 `phone` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
11 `mobile` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
12 `address` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
15
16--
17-- data for table `contact`
18--
19
20INSERT INTO `contact` (`id`, `name`, `surname`, `email`, `phone`, `mobile`, `address`) VALUES
21(1, 'Radek', 'Vala', 'vala@fai.utb.cz', '777111222', '737111222', 'Street 10, ZlÃn'),
22(2, 'Josef', 'Novak', NULL, NULL, 'Street 20', 'City');