· 7 years ago · Oct 08, 2018, 12:42 PM
1CREATE TABLE IF NOT EXISTS `address` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `firstname` varchar(255) NOT NULL,
4 `lastname` varchar(255) NOT NULL,
5 `street` varchar(255) NOT NULL,
6 `city` varchar(255) NOT NULL,
7 `postcode` varchar(255) NOT NULL,
8 `created_at` datetime NOT NULL,
9 `updated_at` datetime DEFAULT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;