github.com/mpchadwick/dbanon@v0.7.1/integration/magento_raw.sql (about) 1 -- 2 -- Table structure for table `admin_user` 3 -- 4 5 DROP TABLE IF EXISTS `admin_user`; 6 /*!40101 SET @saved_cs_client = @@character_set_client */; 7 /*!40101 SET character_set_client = utf8 */; 8 CREATE TABLE `admin_user` ( 9 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'User ID', 10 `firstname` varchar(32) DEFAULT NULL COMMENT 'User First Name', 11 `lastname` varchar(32) DEFAULT NULL COMMENT 'User Last Name', 12 `email` varchar(128) DEFAULT NULL COMMENT 'User Email', 13 `username` varchar(40) DEFAULT NULL COMMENT 'User Login', 14 `password` varchar(255) NOT NULL COMMENT 'User Password', 15 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'User Created Time', 16 `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'User Modified Time', 17 `logdate` timestamp NULL DEFAULT NULL COMMENT 'User Last Login Time', 18 `lognum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'User Login Number', 19 `reload_acl_flag` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Reload ACL', 20 `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'User Is Active', 21 `extra` text COMMENT 'User Extra Data', 22 `rp_token` text COMMENT 'Reset Password Link Token', 23 `rp_token_created_at` timestamp NULL DEFAULT NULL COMMENT 'Reset Password Link Token Creation Date', 24 `interface_locale` varchar(16) NOT NULL DEFAULT 'en_US' COMMENT 'Backend interface locale', 25 `failures_num` smallint(6) DEFAULT '0' COMMENT 'Failure Number', 26 `first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure', 27 `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Expiration Lock Dates', 28 `refresh_token` text COMMENT 'Email connector refresh token', 29 PRIMARY KEY (`user_id`), 30 UNIQUE KEY `ADMIN_USER_USERNAME` (`username`) 31 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Admin User Table'; 32 /*!40101 SET character_set_client = @saved_cs_client */; 33 34 -- 35 -- Dumping data for table `admin_user` 36 -- 37 38 LOCK TABLES `admin_user` WRITE; 39 /*!40000 ALTER TABLE `admin_user` DISABLE KEYS */; 40 INSERT INTO `admin_user` VALUES (1,'adminFirstName','adminLastName','admin@example.com','adminUserName','854480914a2eda69c31a29981f298b1e2464bcd7d9b0b8abe6d83b62c9810634:xDc1CEfXIXSyWq4e:2','2020-10-02 02:35:07','2020-10-02 02:58:09','2020-10-02 02:45:25',1,0,1,'{\"configState\":{\"web_upward\":\"1\",\"web_url\":\"0\",\"web_seo\":\"0\",\"web_unsecure\":\"0\",\"web_secure\":\"0\",\"web_default\":\"0\",\"web_default_layouts\":\"0\",\"web_cookie\":\"0\",\"web_session\":\"0\",\"web_browser_capabilities\":\"0\"}}',NULL,NULL,'en_US',0,NULL,NULL,NULL); 41 /*!40000 ALTER TABLE `admin_user` ENABLE KEYS */; 42 UNLOCK TABLES; 43 44 -- 45 -- Table structure for table `customer_entity` 46 -- 47 48 DROP TABLE IF EXISTS `customer_entity`; 49 /*!40101 SET @saved_cs_client = @@character_set_client */; 50 /*!40101 SET character_set_client = utf8 */; 51 CREATE TABLE `customer_entity` ( 52 `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID', 53 `website_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Website ID', 54 `email` varchar(255) DEFAULT NULL COMMENT 'Email', 55 `group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group ID', 56 `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID', 57 `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store ID', 58 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At', 59 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At', 60 `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active', 61 `disable_auto_group_change` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Disable automatic group change based on VAT ID', 62 `created_in` varchar(255) DEFAULT NULL COMMENT 'Created From', 63 `prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix', 64 `firstname` varchar(255) DEFAULT NULL COMMENT 'First Name', 65 `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name/Initial', 66 `lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name', 67 `suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix', 68 `dob` date DEFAULT NULL COMMENT 'Date of Birth', 69 `password_hash` varchar(128) DEFAULT NULL COMMENT 'Password_hash', 70 `rp_token` varchar(128) DEFAULT NULL COMMENT 'Reset password token', 71 `rp_token_created_at` datetime DEFAULT NULL COMMENT 'Reset password token creation time', 72 `default_billing` int(10) unsigned DEFAULT NULL COMMENT 'Default Billing Address', 73 `default_shipping` int(10) unsigned DEFAULT NULL COMMENT 'Default Shipping Address', 74 `taxvat` varchar(50) DEFAULT NULL COMMENT 'Tax/VAT Number', 75 `confirmation` varchar(64) DEFAULT NULL COMMENT 'Is Confirmed', 76 `gender` smallint(5) unsigned DEFAULT NULL COMMENT 'Gender', 77 `failures_num` smallint(6) DEFAULT '0' COMMENT 'Failure Number', 78 `first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure', 79 `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock Expiration Date', 80 PRIMARY KEY (`entity_id`), 81 UNIQUE KEY `CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`,`website_id`), 82 KEY `CUSTOMER_ENTITY_STORE_ID` (`store_id`), 83 KEY `CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`), 84 KEY `CUSTOMER_ENTITY_FIRSTNAME` (`firstname`), 85 KEY `CUSTOMER_ENTITY_LASTNAME` (`lastname`), 86 KEY `CUSTOMER_ENTITY_CREATED_AT` (`created_at`), 87 KEY `CUSTOMER_ENTITY_DOB` (`dob`), 88 KEY `CUSTOMER_ENTITY_DEFAULT_BILLING` (`default_billing`), 89 KEY `CUSTOMER_ENTITY_DEFAULT_SHIPPING` (`default_shipping`), 90 KEY `CUSTOMER_ENTITY_GENDER` (`gender`), 91 KEY `CUSTOMER_ENTITY_GROUP_ID` (`group_id`), 92 CONSTRAINT `CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL, 93 CONSTRAINT `CUSTOMER_ENTITY_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE SET NULL 94 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Customer Entity'; 95 /*!40101 SET character_set_client = @saved_cs_client */; 96 97 -- 98 -- Dumping data for table `customer_entity` 99 -- 100 -- 101 -- Dumping data for table `customer_entity` 102 -- 103 104 LOCK TABLES `customer_entity` WRITE; 105 /*!40000 ALTER TABLE `customer_entity` DISABLE KEYS */; 106 INSERT INTO `customer_entity` VALUES (1,1,'customer1@example.com',1,NULL,1,'2020-10-02 02:51:54','2020-10-02 02:51:55',1,0,'Default Store View',NULL,'customer1FirstName',NULL,'customer1LastName',NULL,NULL,NULL,'sbFZDK206MEfog23F5y2vUxfnNnNt4qm','2020-10-02 02:51:55',0,0,NULL,NULL,0,0,NULL,NULL),(2,1,'customer2@example.com',1,NULL,1,'2020-11-07 01:08:34','2020-11-07 01:13:31',1,0,'Default Store View',NULL,'customer2FirstName',NULL,'customer2LastName',NULL,NULL,'84790af22fe6977f10617654a358e9eb2be2b024a1468e7c30dee216f7057e4f:VTbIQCsl924X5FTp:2','MRTyfGlxubmGGIMwckazttJKqMtIdMJV','2020-11-07 01:08:35',1,1,NULL,NULL,NULL,0,NULL,NULL); 107 /*!40000 ALTER TABLE `customer_entity` ENABLE KEYS */; 108 UNLOCK TABLES;