June 18, 2022 at 12:26 AM
leak time 2019
title
-- Table structure for table `mgvm_sales_order_address`
--
DROP TABLE IF EXISTS `mgvm_sales_order_address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mgvm_sales_order_address` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
`parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Id',
`customer_address_id` int(11) DEFAULT NULL COMMENT 'Customer Address Id',
`quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address Id',
`region_id` int(11) DEFAULT NULL COMMENT 'Region Id',
`customer_id` int(11) DEFAULT NULL COMMENT 'Customer Id',
`fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
`region` varchar(255) DEFAULT NULL COMMENT 'Region',
`postcode` varchar(255) DEFAULT NULL COMMENT 'Postcode',
`lastname` varchar(255) DEFAULT NULL COMMENT 'Lastname',
`street` varchar(255) DEFAULT NULL COMMENT 'Street',
`city` varchar(255) DEFAULT NULL COMMENT 'City',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`telephone` varchar(255) DEFAULT NULL COMMENT 'Phone Number',
`country_id` varchar(2) DEFAULT NULL COMMENT 'Country Id',
`firstname` varchar(255) DEFAULT NULL COMMENT 'Firstname',
`address_type` varchar(255) DEFAULT NULL COMMENT 'Address Type',
`prefix` varchar(255) DEFAULT NULL COMMENT 'Prefix',
`middlename` varchar(255) DEFAULT NULL COMMENT 'Middlename',
`suffix` varchar(255) DEFAULT NULL COMMENT 'Suffix',
`company` varchar(255) DEFAULT NULL COMMENT 'Company',
`vat_id` text COMMENT 'Vat Id',
`vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
`vat_request_id` text COMMENT 'Vat Request Id',
`vat_request_date` text COMMENT 'Vat Request Date',
`vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
PRIMARY KEY (`entity_id`),
KEY `MGVM_SALES_ORDER_ADDRESS_PARENT_ID` (`parent_id`),
CONSTRAINT `MGVM_SALES_ORDER_ADDRESS_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `mgvm_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=70882 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Address';
/*!40101 SET character_set_client = @saved_cs_client */;
sample
(2,1,NULL,NULL,43,4,'','New York','11552','socol','719 knollwood drive , ','west hempstead','[email protected]','917-846-2066','US','leslie','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(3,2,NULL,NULL,57,6,'','Texas','77904','Schilling','403 Bridle Lane , ','Victoria','[email protected]','3616498065','US','Heather','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(4,2,NULL,NULL,57,6,'','Texas','78705','Schilling','2712 Whitis Ave House A , ','Austin','[email protected]','3616498065','US','Heather','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(5,3,NULL,NULL,0,7,'','Central and Western Hong Kong Island','0000','LAM','FLAT 2307, MING YU HOUSE, KIN MING ESTATE, TIU KENG LENG , ','HONG KONG','[email protected]','0852-62079229','HK','VINCENT','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(6,3,NULL,NULL,0,7,'','Central and Western Hong Kong Island','0000','LAM','FLAT 2307, MING YU HOUSE, KIN MING ESTATE, TIU KENG LENG , ','HONG KONG','[email protected]','0852-62079229','HK','VINCENT','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(7,4,NULL,NULL,12,12,'','California','90402','Sternberg','715 18th Street , ','Santa Monica','[email protected]','310-562-7297','US','Alison','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(8,4,NULL,NULL,12,12,'','California','90402','Sternberg','715 18th Street , ','Santa Monica','[email protected]','310-562-7297','US','Alison','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(9,5,NULL,NULL,43,14,'','New York','11358','ferone','33-18 160st. , ','fLUSHING','[email protected]','917 270-8080','US','joseph','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(10,5,NULL,NULL,43,14,'','New York','11358','ferone','33-18 160st. , ','fLUSHING','[email protected]','917 270-8080','US','joseph','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
title
-- Table structure for table `mgvm_sales_order_address`
--
DROP TABLE IF EXISTS `mgvm_sales_order_address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mgvm_sales_order_address` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
`parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Id',
`customer_address_id` int(11) DEFAULT NULL COMMENT 'Customer Address Id',
`quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address Id',
`region_id` int(11) DEFAULT NULL COMMENT 'Region Id',
`customer_id` int(11) DEFAULT NULL COMMENT 'Customer Id',
`fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
`region` varchar(255) DEFAULT NULL COMMENT 'Region',
`postcode` varchar(255) DEFAULT NULL COMMENT 'Postcode',
`lastname` varchar(255) DEFAULT NULL COMMENT 'Lastname',
`street` varchar(255) DEFAULT NULL COMMENT 'Street',
`city` varchar(255) DEFAULT NULL COMMENT 'City',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`telephone` varchar(255) DEFAULT NULL COMMENT 'Phone Number',
`country_id` varchar(2) DEFAULT NULL COMMENT 'Country Id',
`firstname` varchar(255) DEFAULT NULL COMMENT 'Firstname',
`address_type` varchar(255) DEFAULT NULL COMMENT 'Address Type',
`prefix` varchar(255) DEFAULT NULL COMMENT 'Prefix',
`middlename` varchar(255) DEFAULT NULL COMMENT 'Middlename',
`suffix` varchar(255) DEFAULT NULL COMMENT 'Suffix',
`company` varchar(255) DEFAULT NULL COMMENT 'Company',
`vat_id` text COMMENT 'Vat Id',
`vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
`vat_request_id` text COMMENT 'Vat Request Id',
`vat_request_date` text COMMENT 'Vat Request Date',
`vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
PRIMARY KEY (`entity_id`),
KEY `MGVM_SALES_ORDER_ADDRESS_PARENT_ID` (`parent_id`),
CONSTRAINT `MGVM_SALES_ORDER_ADDRESS_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `mgvm_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=70882 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Address';
/*!40101 SET character_set_client = @saved_cs_client */;
sample
(2,1,NULL,NULL,43,4,'','New York','11552','socol','719 knollwood drive , ','west hempstead','[email protected]','917-846-2066','US','leslie','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(3,2,NULL,NULL,57,6,'','Texas','77904','Schilling','403 Bridle Lane , ','Victoria','[email protected]','3616498065','US','Heather','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(4,2,NULL,NULL,57,6,'','Texas','78705','Schilling','2712 Whitis Ave House A , ','Austin','[email protected]','3616498065','US','Heather','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(5,3,NULL,NULL,0,7,'','Central and Western Hong Kong Island','0000','LAM','FLAT 2307, MING YU HOUSE, KIN MING ESTATE, TIU KENG LENG , ','HONG KONG','[email protected]','0852-62079229','HK','VINCENT','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(6,3,NULL,NULL,0,7,'','Central and Western Hong Kong Island','0000','LAM','FLAT 2307, MING YU HOUSE, KIN MING ESTATE, TIU KENG LENG , ','HONG KONG','[email protected]','0852-62079229','HK','VINCENT','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(7,4,NULL,NULL,12,12,'','California','90402','Sternberg','715 18th Street , ','Santa Monica','[email protected]','310-562-7297','US','Alison','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(8,4,NULL,NULL,12,12,'','California','90402','Sternberg','715 18th Street , ','Santa Monica','[email protected]','310-562-7297','US','Alison','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(9,5,NULL,NULL,43,14,'','New York','11358','ferone','33-18 160st. , ','fLUSHING','[email protected]','917 270-8080','US','joseph','billing',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(10,5,NULL,NULL,43,14,'','New York','11358','ferone','33-18 160st. , ','fLUSHING','[email protected]','917 270-8080','US','joseph','shipping',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),


