Added missing init() method + renamed localInit() -> genericInit()

[pizzaservice-war.git] / install / install.sql

diff --git a/install/install.sql b/install/install.sql
index 04fb29be2baba9bfb898248acf11eae29eb2c2e6..d4bce3b6226c1399f66f4f991b606a0aa6522055 100644 (file)
--- a/install/install.sql
+++ b/install/install.sql
@@ -1,25 +1,18 @@
-SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
-SET time_zone = "+00:00";
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-
-
 DROP TABLE IF EXISTS `category`;
 CREATE TABLE IF NOT EXISTS `category` (
 `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key',
   `title` varchar(255) NOT NULL COMMENT 'Category title',
-  `parent` bigint(20) unsigned DEFAULT NULL COMMENT 'Parent category'
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='Categories' AUTO_INCREMENT=3 ;
+  `parent` bigint(20) unsigned DEFAULT NULL COMMENT 'Parent category',
+  PRIMARY KEY (`id`),
+  INDEX `parent` (`parent`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='Categories' ;
 
 DROP TABLE IF EXISTS `contacts`;
 CREATE TABLE IF NOT EXISTS `contacts` (
 `id` bigint(20) unsigned NOT NULL COMMENT 'Primary key',
   `own_contact` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether own contact',
   `gender` varchar(10) NOT NULL DEFAULT 'UNKNOWN' COMMENT 'Gender',
-  `surname` varchar(100) NOT NULL COMMENT 'Surname',
+  `first_name` varchar(100) NOT NULL COMMENT 'First name',
   `family_name` varchar(100) NOT NULL COMMENT 'Family name',
   `company_name` varchar(255) DEFAULT NULL COMMENT 'Company name',
   `street` varchar(255) DEFAULT NULL COMMENT 'Street name',
@@ -34,8 +27,9 @@ CREATE TABLE IF NOT EXISTS `contacts` (
   `birthday` date DEFAULT NULL COMMENT 'Birth day',
   `comment` tinytext NOT NULL COMMENT 'Comment',
   `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Entry created',
-  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Contacts data' AUTO_INCREMENT=1 ;
+  `updated` timestamp NULL DEFAULT NULL COMMENT 'Entry updated',
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='Contacts data' ;
 
 DROP TABLE IF EXISTS `products`;
 CREATE TABLE IF NOT EXISTS `products` (
@@ -43,26 +37,16 @@ CREATE TABLE IF NOT EXISTS `products` (
   `category` bigint(20) unsigned DEFAULT NULL COMMENT 'Category id',
   `title` varchar(255) NOT NULL COMMENT 'Title of product',
   `price` decimal(20,2) unsigned NOT NULL COMMENT 'Product price',
-  `available` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether product is available'
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='Products' AUTO_INCREMENT=2 ;
-
+  `available` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether product is available',
+  PRIMARY KEY (`id`),
+  INDEX `category` (`category`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='Products' ;
 
 ALTER TABLE `category`
- ADD PRIMARY KEY (`id`), ADD KEY `parent` (`parent`);
+MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key';
 
 ALTER TABLE `contacts`
- ADD PRIMARY KEY (`id`);
+MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key';
 
 ALTER TABLE `products`
- ADD PRIMARY KEY (`id`), ADD KEY `category` (`category`);
-
-
-ALTER TABLE `category`
-MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',AUTO_INCREMENT=3;
-ALTER TABLE `contacts`
 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key';
-ALTER TABLE `products`
-MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',AUTO_INCREMENT=2;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;