-- Hint: use Ctrl+Enter for SQL autocomplete
DROP TABLE IF EXISTS `product`;
CREATE TABLE IF NOT EXISTS `product` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID of the Product',
`name_en` varchar(255) NOT NULL COMMENT 'Name of the Product in Englisch',
`name_de` varchar(255) DEFAULT NULL COMMENT 'Name of the Product in German',
`name_fr` varchar(255) DEFAULT NULL COMMENT 'Name of the Product in France',
`group` int(10) UNSIGNED DEFAULT 1 COMMENT 'ID of the Product Group',
`unit` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Id of the Unit',
`default_consumption` float UNSIGNED NOT NULL DEFAULT 0.5 COMMENT 'Value for Default Consumption',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp of creation Time',
`changed_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() COMMENT 'Timestamp of changed',
`deleted_at` timestamp NULL DEFAULT NULL COMMENT 'Timestamp of deleted',
PRIMARY KEY (`id`),
KEY `product_name_en_idx` (`name_en`),
KEY `product_name_de_idx` (`name_de`),
KEY `product_name_fr_idx` (`name_fr`),
KEY `product_group_idx` (`group`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product`
--
INSERT INTO `product` (`id`, `name_en`, `name_de`, `name_fr`, `group`, `unit`, `default_consumption`, `created_at`, `changed_at`, `deleted_at`) VALUES
(1, 'Test', NULL, NULL, 1, 1, 0.5, '2021-03-23 11:37:17', NULL, NULL);
DROP TABLE IF EXISTS `stock`;
CREATE TABLE IF NOT EXISTS `stock` (
`product` int(10) UNSIGNED NOT NULL COMMENT 'ID of the Product',
`user` int(10) UNSIGNED NOT NULL COMMENT 'ID of the User',
`stock` float UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Stock Value',
`individual_consumption` float UNSIGNED DEFAULT NULL COMMENT 'Individual Consumption Value',
`ki_value` float UNSIGNED DEFAULT 0 COMMENT 'KI Up Down Value',
`last_buy` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestmap of last Buy',
KEY `stock_product_idx` (`product`),
KEY `stock_user_idx` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;