1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2 SET time_zone = "+00:00";
4 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7 /*!40101 SET NAMES utf8 */;
10 DROP TABLE IF EXISTS `category`;
11 CREATE TABLE IF NOT EXISTS `category` (
12 `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key',
13 `title` varchar(255) NOT NULL COMMENT 'Category title',
14 `parent` bigint(20) unsigned DEFAULT NULL COMMENT 'Parent category'
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Categories' AUTO_INCREMENT=3 ;
17 DROP TABLE IF EXISTS `contacts`;
18 CREATE TABLE IF NOT EXISTS `contacts` (
19 `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key',
20 `own_contact` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether own contact',
21 `gender` varchar(10) NOT NULL DEFAULT 'UNKNOWN' COMMENT 'Gender',
22 `surname` varchar(100) NOT NULL COMMENT 'Surname',
23 `family_name` varchar(100) NOT NULL COMMENT 'Family name',
24 `company_name` varchar(255) DEFAULT NULL COMMENT 'Company name',
25 `street` varchar(255) DEFAULT NULL COMMENT 'Street name',
26 `house_number` smallint(5) unsigned DEFAULT NULL COMMENT 'House number',
27 `city` varchar(100) DEFAULT NULL COMMENT 'City name',
28 `zip_code` smallint(5) unsigned DEFAULT NULL COMMENT 'ZIP code',
29 `country_code` char(2) DEFAULT NULL COMMENT 'Country code',
30 `phone_number` varchar(100) DEFAULT NULL COMMENT 'Phone number',
31 `cellphone_number` varchar(100) DEFAULT NULL COMMENT 'Cellphone number',
32 `fax_number` varchar(100) DEFAULT NULL COMMENT 'Fax number',
33 `email_address` varchar(100) DEFAULT NULL COMMENT 'Email addres',
34 `birthday` date DEFAULT NULL COMMENT 'Birth day',
35 `comment` tinytext NOT NULL COMMENT 'Comment',
36 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Entry created',
37 `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Contacts data' AUTO_INCREMENT=1 ;
40 DROP TABLE IF EXISTS `products`;
41 CREATE TABLE IF NOT EXISTS `products` (
42 `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key',
43 `category` bigint(20) unsigned DEFAULT NULL COMMENT 'Category id',
44 `title` varchar(255) NOT NULL COMMENT 'Title of product',
45 `price` decimal(20,2) unsigned NOT NULL COMMENT 'Product price',
46 `available` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether product is available'
47 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Products' AUTO_INCREMENT=2 ;
50 ALTER TABLE `category`
51 ADD PRIMARY KEY (`id`), ADD KEY `parent` (`parent`);
53 ALTER TABLE `contacts`
54 ADD PRIMARY KEY (`id`);
56 ALTER TABLE `products`
57 ADD PRIMARY KEY (`id`), ADD KEY `category` (`category`);
60 ALTER TABLE `category`
61 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',AUTO_INCREMENT=3;
62 ALTER TABLE `contacts`
63 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key';
64 ALTER TABLE `products`
65 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',AUTO_INCREMENT=2;
66 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
67 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
68 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;