 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
--- Truncate tables before insertion
-TRUNCATE TABLE `fcs_action_logs`;
-TRUNCATE TABLE `fcs_address`;
-TRUNCATE TABLE `fcs_attribute`;
-TRUNCATE TABLE `fcs_blog_posts`;
-TRUNCATE TABLE `fcs_cart_product_units`;
-TRUNCATE TABLE `fcs_cart_products`;
-TRUNCATE TABLE `fcs_carts`;
-TRUNCATE TABLE `fcs_category`;
-TRUNCATE TABLE `fcs_category_product`;
-TRUNCATE TABLE `fcs_configuration`;
-TRUNCATE TABLE `fcs_cronjob_logs`;
-TRUNCATE TABLE `fcs_cronjobs`;
-TRUNCATE TABLE `fcs_customer`;
-TRUNCATE TABLE `fcs_deposits`;
-TRUNCATE TABLE `fcs_images`;
-TRUNCATE TABLE `fcs_invoices`;
-TRUNCATE TABLE `fcs_manufacturer`;
-TRUNCATE TABLE `fcs_order_detail`;
-TRUNCATE TABLE `fcs_order_detail_feedbacks`;
-TRUNCATE TABLE `fcs_order_detail_tax`;
-TRUNCATE TABLE `fcs_order_detail_units`;
-TRUNCATE TABLE `fcs_pages`;
-TRUNCATE TABLE `fcs_payments`;
-TRUNCATE TABLE `fcs_pickup_days`;
-TRUNCATE TABLE `fcs_product`;
-TRUNCATE TABLE `fcs_product_attribute`;
-TRUNCATE TABLE `fcs_product_attribute_combination`;
-TRUNCATE TABLE `fcs_sliders`;
-TRUNCATE TABLE `fcs_stock_available`;
-TRUNCATE TABLE `fcs_sync_domains`;
-TRUNCATE TABLE `fcs_sync_products`;
-TRUNCATE TABLE `fcs_tax`;
-TRUNCATE TABLE `fcs_timebased_currency_order_detail`;
-TRUNCATE TABLE `fcs_timebased_currency_payments`;
-TRUNCATE TABLE `fcs_units`;
-TRUNCATE TABLE `phinxlog`;
-TRUNCATE TABLE `queue_phinxlog`;
-TRUNCATE TABLE `queue_processes`;
-TRUNCATE TABLE `queued_jobs`;
-TRUNCATE TABLE `queued_tasks`;
-
+-- Truncate tables before insertion
+TRUNCATE TABLE `fcs_action_logs`;
+TRUNCATE TABLE `fcs_address`;
+TRUNCATE TABLE `fcs_attribute`;
+TRUNCATE TABLE `fcs_blog_posts`;
+TRUNCATE TABLE `fcs_cart_product_units`;
+TRUNCATE TABLE `fcs_cart_products`;
+TRUNCATE TABLE `fcs_carts`;
+TRUNCATE TABLE `fcs_category`;
+TRUNCATE TABLE `fcs_category_product`;
+TRUNCATE TABLE `fcs_configuration`;
+TRUNCATE TABLE `fcs_cronjob_logs`;
+TRUNCATE TABLE `fcs_cronjobs`;
+TRUNCATE TABLE `fcs_customer`;
+TRUNCATE TABLE `fcs_deposits`;
+TRUNCATE TABLE `fcs_images`;
+TRUNCATE TABLE `fcs_invoices`;
+TRUNCATE TABLE `fcs_manufacturer`;
+TRUNCATE TABLE `fcs_order_detail`;
+TRUNCATE TABLE `fcs_order_detail_feedbacks`;
+TRUNCATE TABLE `fcs_order_detail_tax`;
+TRUNCATE TABLE `fcs_order_detail_units`;
+TRUNCATE TABLE `fcs_pages`;
+TRUNCATE TABLE `fcs_payments`;
+TRUNCATE TABLE `fcs_pickup_days`;
+TRUNCATE TABLE `fcs_product`;
+TRUNCATE TABLE `fcs_product_attribute`;
+TRUNCATE TABLE `fcs_product_attribute_combination`;
+TRUNCATE TABLE `fcs_sliders`;
+TRUNCATE TABLE `fcs_stock_available`;
+TRUNCATE TABLE `fcs_sync_domains`;
+TRUNCATE TABLE `fcs_sync_products`;
+TRUNCATE TABLE `fcs_tax`;
+TRUNCATE TABLE `fcs_timebased_currency_order_detail`;
+TRUNCATE TABLE `fcs_timebased_currency_payments`;
+TRUNCATE TABLE `fcs_units`;
+TRUNCATE TABLE `phinxlog`;
+TRUNCATE TABLE `queue_phinxlog`;
+TRUNCATE TABLE `queue_processes`;
+TRUNCATE TABLE `queued_jobs`;
+TRUNCATE TABLE `queued_tasks`;
+
 /*!40000 ALTER TABLE `fcs_action_logs` DISABLE KEYS */;
 /*!40000 ALTER TABLE `fcs_action_logs` ENABLE KEYS */;
 
 /*!40000 ALTER TABLE `fcs_address` DISABLE KEYS */;
-INSERT INTO `fcs_address` VALUES
-(153,87,0,'Mitglied','Demo','Demostrasse 4','','4644','Scharnstein','','','0664/000000000','fcs-demo-mitglied@mailinator.com','2014-12-02 12:19:31','2014-12-02 12:19:31'),
-(154,88,0,'Admin','Demo','Demostrasse 4','','4644','Scharnstein','test','','0600/000000','fcs-demo-admin@mailinator.com','2014-12-02 12:28:44','2014-12-02 12:28:44'),
-(173,0,4,'Fleisch-Hersteller','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-demo-fleisch-hersteller@mailinator.com','2014-05-27 22:20:18','2015-04-07 16:18:28'),
-(177,0,15,'Milch-Hersteller','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-demo-milch-hersteller@mailinator.com','2014-06-04 21:46:38','2015-10-16 10:06:52'),
-(180,0,5,'Gemüse-Hersteller','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-demo-gemuese-hersteller@mailinator.com','2014-05-14 21:20:05','2015-12-30 00:54:35'),
-(181,0,16,'Hersteller ohne Customer-Eintrag','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-hersteller-ohne-customer-eintrag@mailinator.com','2014-05-14 21:20:05','2015-12-30 00:54:35'),
+INSERT INTO `fcs_address` VALUES
+(153,87,0,'Mitglied','Demo','Demostrasse 4','','4644','Scharnstein','','','0664/000000000','fcs-demo-mitglied@mailinator.com','2014-12-02 12:19:31','2014-12-02 12:19:31'),
+(154,88,0,'Admin','Demo','Demostrasse 4','','4644','Scharnstein','test','','0600/000000','fcs-demo-admin@mailinator.com','2014-12-02 12:28:44','2014-12-02 12:28:44'),
+(173,0,4,'Fleisch-Hersteller','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-demo-fleisch-hersteller@mailinator.com','2014-05-27 22:20:18','2015-04-07 16:18:28'),
+(177,0,15,'Milch-Hersteller','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-demo-milch-hersteller@mailinator.com','2014-06-04 21:46:38','2015-10-16 10:06:52'),
+(180,0,5,'Gemüse-Hersteller','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-demo-gemuese-hersteller@mailinator.com','2014-05-14 21:20:05','2015-12-30 00:54:35'),
+(181,0,16,'Hersteller ohne Customer-Eintrag','Demo','Demostrasse 4','','4644','Scharnstein','','','','fcs-hersteller-ohne-customer-eintrag@mailinator.com','2014-05-14 21:20:05','2015-12-30 00:54:35'),
 (182,92,0,'Superadmin','Demo','Demostrasse 4','','4644','Demostadt',NULL,'','0600/000000','fcs-demo-superadmin@mailinator.com','2017-07-26 13:19:19','2017-07-26 13:19:19');
 /*!40000 ALTER TABLE `fcs_address` ENABLE KEYS */;
 
 /*!40000 ALTER TABLE `fcs_attribute` DISABLE KEYS */;
-INSERT INTO `fcs_attribute` VALUES
-(33,'0,5l',0,1,NULL,NULL),
-(35,'1 kg',1,1,NULL,NULL),
+INSERT INTO `fcs_attribute` VALUES
+(33,'0,5l',0,1,NULL,NULL),
+(35,'1 kg',1,1,NULL,NULL),
 (36,'0,5 kg',1,1,NULL,NULL);
 /*!40000 ALTER TABLE `fcs_attribute` ENABLE KEYS */;
 
 /*!40000 ALTER TABLE `fcs_blog_posts` DISABLE KEYS */;
-INSERT INTO `fcs_blog_posts` VALUES
+INSERT INTO `fcs_blog_posts` VALUES
 (2,'Demo Blog Artikel','Lorem ipsum dolor sit amet, consetetur sadipscing','<p>Lorem ipsum dolor sit amet.</p>',88,0,0,1,'2014-12-18 10:37:26','2015-03-16 12:41:46',1);
 /*!40000 ALTER TABLE `fcs_blog_posts` ENABLE KEYS */;
 

/*!40000 ALTER TABLE `fcs_cronjob_logs` ENABLE KEYS */;

/*!40000 ALTER TABLE `fcs_cronjobs` DISABLE KEYS */;
INSERT INTO `fcs_cronjobs` VALUES
(1,'TestCronjob','day',NULL,NULL,'22:30:00',1),
(2,'TestCronjob','week',NULL,'Monday','09:00:00',1),
(3,'TestCronjob','month',11,NULL,'07:30:00',1);
/*!40000 ALTER TABLE `fcs_cronjobs` ENABLE KEYS */;

/*!40000 ALTER TABLE `fcs_customer` DISABLE KEYS */;
INSERT INTO `fcs_customer` VALUES
(87,3,'Demo','Mitglied','fcs-demo-mitglied@mailinator.com','$2y$10$uu/znwy2GwCx0NlLOIqaquY862AdcV6BgTGtNEUdKj4o1US.idVlm',NULL,NULL,NULL,1,'2018-08-03',1,'2014-12-02 12:19:31','2015-12-06 23:37:44',0,0),
(88,4,'Demo','Admin','fcs-demo-admin@mailinator.com','$2y$10$uu/znwy2GwCx0NlLOIqaquY862AdcV6BgTGtNEUdKj4o1US.idVlm',NULL,NULL,NULL,1,'2018-08-03',1,'2014-12-02 12:28:43','2016-09-29 16:25:09',0,0),
(89,4,'Demo','Gemüse-Hersteller','fcs-demo-gemuese-hersteller@mailinator.com','$2y$10$uu/znwy2GwCx0NlLOIqaquY862AdcV6BgTGtNEUdKj4o1US.idVlm',NULL,NULL,NULL,0,'2018-08-03',1,'2014-12-02 12:37:26','2015-03-11 18:12:10',0,0),
(90,4,'Demo','Milch-Hersteller','fcs-demo-milch-hersteller@mailinator.com','$2y$10$uu/znwy2GwCx0NlLOIqaquY862AdcV6BgTGtNEUdKj4o1US.idVlm',NULL,NULL,NULL,0,'2018-08-03',1,'2014-12-02 12:37:49','2015-03-11 18:11:54',0,0),
(91,4,'Demo','Fleisch-Hersteller','fcs-demo-fleisch-hersteller@mailinator.com','$2y$10$uu/znwy2GwCx0NlLOIqaquY862AdcV6BgTGtNEUdKj4o1US.idVlm',NULL,NULL,NULL,0,'2018-08-03',1,'2014-12-02 12:38:12','2015-03-11 18:11:47',0,0),
(92,5,'Demo','Superadmin','fcs-demo-superadmin@mailinator.com','$2y$10$uu/znwy2GwCx0NlLOIqaquY862AdcV6BgTGtNEUdKj4o1US.idVlm',NULL,NULL,NULL,1,'2018-08-03',1,'2016-09-29 16:26:12','2016-09-29 16:26:12',0,0);
/*!40000 ALTER TABLE `fcs_customer` ENABLE KEYS */;

/*!40000 ALTER TABLE `fcs_deposits` DISABLE KEYS */;
INSERT INTO `fcs_deposits` VALUES
(1,346,0,0.5),
(2,0,9,0.5),
(3,0,10,0.5);
/*!40000 ALTER TABLE `fcs_deposits` ENABLE KEYS */;

/*!40000 ALTER TABLE `fcs_images` DISABLE KEYS */;
INSERT INTO `fcs_images` VALUES
(154,60),
(156,340),
(157,338);
/*!40000 ALTER TABLE `fcs_images` ENABLE KEYS */;


/*!40000 ALTER TABLE `fcs_order_detail_units` ENABLE KEYS */;

/*!40000 ALTER TABLE `fcs_pages` DISABLE KEYS */;
INSERT INTO `fcs_pages` VALUES
(3,'Page','',1,'header',1,'',88,0,'2016-08-29 13:36:43','2016-08-29 13:36:43',0,0,0,0);
/*!40000 ALTER TABLE `fcs_pages` ENABLE KEYS */;

/*!40000 ALTER TABLE `fcs_payments` DISABLE KEYS */;
INSERT INTO `fcs_payments` VALUES
(1,92,0,'product',100.00,'','2018-07-03 20:00:20','2018-07-03 20:00:20',NULL,NULL,1,0,'',0,92);
/*!40000 ALTER TABLE `fcs_payments` ENABLE KEYS */;

