SHOW CREATE TABLE Sale;
|
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Sale | CREATE TABLE `Sale` (
|
`Sales_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`Sales_Location` mediumint(8) unsigned NOT NULL,
|
`Sales_KioskID` varchar(10) NOT NULL,
|
`Terminal_ID` varchar(10) NOT NULL,
|
`User_ID` smallint(5) unsigned NOT NULL,
|
`Sales_Customer_ID` int(10) unsigned NOT NULL,
|
`Sales_Create` datetime NOT NULL,
|
`Sales_Complete` datetime DEFAULT NULL,
|
`Sales_LastUpdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
|
`Sales_Memo` text NOT NULL,
|
`Sales_PackingSlips` smallint(5) unsigned NOT NULL,
|
`Sales_Invoices` smallint(5) unsigned NOT NULL,
|
`Sales_CustomerOrderID` varchar(50) NOT NULL,
|
`Sales_CustomerVAT` varchar(30) DEFAULT NULL,
|
`Display_VAT` tinyint(1) NOT NULL,
|
`Deleted` tinyint(4) NOT NULL,
|
`Status` enum('Offer','Processing','Historic') NOT NULL,
|
`PaymentStatus` enum('None','Partial','Full') NOT NULL,
|
`Pickup_DT` datetime NOT NULL,
|
`Pickup_Location_ID` mediumint(8) unsigned NOT NULL,
|
`Pickup_Printed` tinyint(1) NOT NULL,
|
`Kiosk_Printed` tinyint(1) NOT NULL,
|
`CombineOrder` tinyint(1) NOT NULL,
|
`PaymentCondition` enum('8','10','14','21','30','60','Advance') NOT NULL DEFAULT '30',
|
`Total` decimal(10,2) NOT NULL,
|
`TotalExVAT` decimal(10,2) NOT NULL,
|
PRIMARY KEY (`Sales_ID`),
|
KEY `Sales_ID` (`Sales_ID`),
|
KEY `Sales_ID_2` (`Sales_ID`,`Sales_Location`),
|
KEY `Sales_ID_3` (`Sales_ID`,`Sales_Customer_ID`),
|
KEY `Sales_Customer_ID` (`Sales_Customer_ID`),
|
KEY `Sales_Location` (`Sales_Location`,`Pickup_DT`),
|
KEY `Sales_Location_2` (`Sales_Location`,`Terminal_ID`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
|
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
|
SHOW CREATE TABLE Customer;
|
+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Customer | CREATE TABLE `Customer` (
|
`Customer_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
`InvoiceDebtor` int(11) unsigned NOT NULL,
|
`SaleCombineOrder` tinyint(1) NOT NULL,
|
`Gender` enum('','F','M') NOT NULL,
|
`First_Name` varchar(100) NOT NULL,
|
`Middle_Name` varchar(50) NOT NULL,
|
`Sur_Name` varchar(100) NOT NULL,
|
`Company` varchar(50) NOT NULL,
|
`Phone_Number` varchar(20) NOT NULL,
|
`Mobile_Phone_Number` varchar(20) NOT NULL,
|
`Fax_Number` varchar(20) NOT NULL,
|
`Email` varchar(100) NOT NULL,
|
`Website` varchar(100) NOT NULL,
|
`Birth_Date` date NOT NULL,
|
`Wedding_Date` datetime NOT NULL,
|
`Street` varchar(50) NOT NULL,
|
`HouseNumber` mediumint(11) unsigned NOT NULL,
|
`HouseNumber_Addition` varchar(10) NOT NULL,
|
`City` varchar(50) NOT NULL,
|
`Postal_Code` varchar(25) NOT NULL,
|
`Country` smallint(3) unsigned NOT NULL,
|
`EAN` bigint(20) unsigned NOT NULL,
|
`BSNRSIN` varchar(30) NOT NULL,
|
`KVK` varchar(30) NOT NULL,
|
`EstablishmentNumber` varchar(25) NOT NULL,
|
`VAT` varchar(30) NOT NULL,
|
`Supplier` tinyint(1) NOT NULL,
|
`Password` char(64) NOT NULL,
|
`Memo` text NOT NULL,
|
`Created` datetime NOT NULL,
|
`LastModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
|
`Entry` varchar(15) NOT NULL,
|
`PackingSlips` smallint(5) unsigned NOT NULL DEFAULT '1',
|
`Invoices` smallint(5) unsigned NOT NULL DEFAULT '1',
|
`State` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '1=not validated per email;2=validated;3=password reset requested',
|
`Display_VAT` smallint(1) unsigned NOT NULL,
|
`Deleted` tinyint(1) NOT NULL,
|
`EDIAdres` varchar(50) NOT NULL,
|
`CustomerGroup` enum('Companies','Private','Dispatch') NOT NULL,
|
`Image` varchar(100) NOT NULL,
|
`PaymentCondition` enum('8','10','14','21','30','60','Advance') NOT NULL DEFAULT '30',
|
`Language` char(5) NOT NULL,
|
PRIMARY KEY (`Customer_ID`),
|
KEY `Customer_ID` (`Customer_ID`),
|
KEY `Supplier` (`Supplier`)
|
) ENGINE=InnoDB AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8 |
|
+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
|
SHOW INDEX IN Sale;
|
+-------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
|
+-------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| Sale | 0 | PRIMARY | 1 | Sales_ID | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_ID | 1 | Sales_ID | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_ID_2 | 1 | Sales_ID | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_ID_2 | 2 | Sales_Location | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_ID_3 | 1 | Sales_ID | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_ID_3 | 2 | Sales_Customer_ID | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_Customer_ID | 1 | Sales_Customer_ID | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_Location | 1 | Sales_Location | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_Location | 2 | Pickup_DT | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_Location_2 | 1 | Sales_Location | A | 0 | NULL | NULL | | BTREE | | |
|
| Sale | 1 | Sales_Location_2 | 2 | Terminal_ID | A | 0 | NULL | NULL | | BTREE | | |
|
+-------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
|
SHOW INDEX IN Customer;
|
+----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
|
+----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
| Customer | 0 | PRIMARY | 1 | Customer_ID | A | 3 | NULL | NULL | | BTREE | | |
|
| Customer | 1 | Customer_ID | 1 | Customer_ID | A | 3 | NULL | NULL | | BTREE | | |
|
| Customer | 1 | Supplier | 1 | Supplier | A | 3 | NULL | NULL | | BTREE | | |
|
+----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
log.txt