github.com/pingcap/br@v5.3.0-alpha.0.20220125034240-ec59c7b6ce30+incompatible/tests/lightning_parquet/db.sql (about) 1 -- MySQL dump 10.13 Distrib 5.6.39, for macos10.13 (x86_64) 2 -- 3 -- Host: 172.16.4.27 Database: test 4 -- ------------------------------------------------------ 5 -- Server version 5.7.25-TiDB-v4.0.0 6 7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 10 /*!40101 SET NAMES utf8 */; 11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 12 /*!40103 SET TIME_ZONE='+00:00' */; 13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 17 18 -- 19 -- Table structure for table `customer` 20 -- 21 22 DROP TABLE IF EXISTS `customer`; 23 /*!40101 SET @saved_cs_client = @@character_set_client */; 24 /*!40101 SET character_set_client = utf8 */; 25 CREATE TABLE `customer` ( 26 `c_id` int(11) NOT NULL, 27 `c_d_id` int(11) NOT NULL, 28 `c_w_id` int(11) NOT NULL, 29 `c_first` varchar(16) DEFAULT NULL, 30 `c_middle` char(2) DEFAULT NULL, 31 `c_last` varchar(16) DEFAULT NULL, 32 `c_street_1` varchar(20) DEFAULT NULL, 33 `c_street_2` varchar(20) DEFAULT NULL, 34 `c_city` varchar(20) DEFAULT NULL, 35 `c_state` char(2) DEFAULT NULL, 36 `c_zip` char(9) DEFAULT NULL, 37 `c_phone` char(16) DEFAULT NULL, 38 `c_since` datetime DEFAULT NULL, 39 `c_credit` char(2) DEFAULT NULL, 40 `c_credit_lim` decimal(12,2) DEFAULT NULL, 41 `c_discount` decimal(4,4) DEFAULT NULL, 42 `c_balance` decimal(12,2) DEFAULT NULL, 43 `c_ytd_payment` decimal(12,2) DEFAULT NULL, 44 `c_payment_cnt` int(11) DEFAULT NULL, 45 `c_delivery_cnt` int(11) DEFAULT NULL, 46 `c_data` varchar(500) DEFAULT NULL, 47 PRIMARY KEY (`c_w_id`,`c_d_id`,`c_id`), 48 KEY `idx_customer` (`c_w_id`,`c_d_id`,`c_last`,`c_first`) 49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 50 /*!40101 SET character_set_client = @saved_cs_client */; 51 52 -- 53 -- Table structure for table `district` 54 -- 55 56 DROP TABLE IF EXISTS `district`; 57 /*!40101 SET @saved_cs_client = @@character_set_client */; 58 /*!40101 SET character_set_client = utf8 */; 59 CREATE TABLE `district` ( 60 `d_id` int(11) NOT NULL, 61 `d_w_id` int(11) NOT NULL, 62 `d_name` varchar(10) DEFAULT NULL, 63 `d_street_1` varchar(20) DEFAULT NULL, 64 `d_street_2` varchar(20) DEFAULT NULL, 65 `d_city` varchar(20) DEFAULT NULL, 66 `d_state` char(2) DEFAULT NULL, 67 `d_zip` char(9) DEFAULT NULL, 68 `d_tax` decimal(4,4) DEFAULT NULL, 69 `d_ytd` decimal(12,2) DEFAULT NULL, 70 `d_next_o_id` int(11) DEFAULT NULL, 71 PRIMARY KEY (`d_w_id`,`d_id`) 72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 73 /*!40101 SET character_set_client = @saved_cs_client */; 74 75 -- 76 -- Table structure for table `history` 77 -- 78 79 DROP TABLE IF EXISTS `history`; 80 /*!40101 SET @saved_cs_client = @@character_set_client */; 81 /*!40101 SET character_set_client = utf8 */; 82 CREATE TABLE `history` ( 83 `h_c_id` int(11) NOT NULL, 84 `h_c_d_id` int(11) NOT NULL, 85 `h_c_w_id` int(11) NOT NULL, 86 `h_d_id` int(11) NOT NULL, 87 `h_w_id` int(11) NOT NULL, 88 `h_date` datetime DEFAULT NULL, 89 `h_amount` decimal(6,2) DEFAULT NULL, 90 `h_data` varchar(24) DEFAULT NULL, 91 KEY `idx_h_w_id` (`h_w_id`), 92 KEY `idx_h_c_w_id` (`h_c_w_id`) 93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 94 /*!40101 SET character_set_client = @saved_cs_client */; 95 96 -- 97 -- Table structure for table `item` 98 -- 99 100 DROP TABLE IF EXISTS `item`; 101 /*!40101 SET @saved_cs_client = @@character_set_client */; 102 /*!40101 SET character_set_client = utf8 */; 103 CREATE TABLE `item` ( 104 `i_id` int(11) NOT NULL, 105 `i_im_id` int(11) DEFAULT NULL, 106 `i_name` varchar(24) DEFAULT NULL, 107 `i_price` decimal(5,2) DEFAULT NULL, 108 `i_data` varchar(50) DEFAULT NULL, 109 PRIMARY KEY (`i_id`) 110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 111 /*!40101 SET character_set_client = @saved_cs_client */; 112 113 -- 114 -- Table structure for table `new_order` 115 -- 116 117 DROP TABLE IF EXISTS `new_order`; 118 /*!40101 SET @saved_cs_client = @@character_set_client */; 119 /*!40101 SET character_set_client = utf8 */; 120 CREATE TABLE `new_order` ( 121 `no_o_id` int(11) NOT NULL, 122 `no_d_id` int(11) NOT NULL, 123 `no_w_id` int(11) NOT NULL, 124 PRIMARY KEY (`no_w_id`,`no_d_id`,`no_o_id`) 125 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 126 /*!40101 SET character_set_client = @saved_cs_client */; 127 128 -- 129 -- Table structure for table `order_line` 130 -- 131 132 DROP TABLE IF EXISTS `order_line`; 133 /*!40101 SET @saved_cs_client = @@character_set_client */; 134 /*!40101 SET character_set_client = utf8 */; 135 CREATE TABLE `order_line` ( 136 `ol_o_id` int(11) NOT NULL, 137 `ol_d_id` int(11) NOT NULL, 138 `ol_w_id` int(11) NOT NULL, 139 `ol_number` int(11) NOT NULL, 140 `ol_i_id` int(11) NOT NULL, 141 `ol_supply_w_id` int(11) DEFAULT NULL, 142 `ol_delivery_d` datetime DEFAULT NULL, 143 `ol_quantity` int(11) DEFAULT NULL, 144 `ol_amount` decimal(6,2) DEFAULT NULL, 145 `ol_dist_info` char(24) DEFAULT NULL, 146 PRIMARY KEY (`ol_w_id`,`ol_d_id`,`ol_o_id`,`ol_number`) 147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 148 /*!40101 SET character_set_client = @saved_cs_client */; 149 150 -- 151 -- Table structure for table `orders` 152 -- 153 154 DROP TABLE IF EXISTS `orders`; 155 /*!40101 SET @saved_cs_client = @@character_set_client */; 156 /*!40101 SET character_set_client = utf8 */; 157 CREATE TABLE `orders` ( 158 `o_id` int(11) NOT NULL, 159 `o_d_id` int(11) NOT NULL, 160 `o_w_id` int(11) NOT NULL, 161 `o_c_id` int(11) DEFAULT NULL, 162 `o_entry_d` datetime DEFAULT NULL, 163 `o_carrier_id` int(11) DEFAULT NULL, 164 `o_ol_cnt` int(11) DEFAULT NULL, 165 `o_all_local` int(11) DEFAULT NULL, 166 PRIMARY KEY (`o_w_id`,`o_d_id`,`o_id`), 167 KEY `idx_order` (`o_w_id`,`o_d_id`,`o_c_id`,`o_id`) 168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 169 /*!40101 SET character_set_client = @saved_cs_client */; 170 171 -- 172 -- Table structure for table `stock` 173 -- 174 175 DROP TABLE IF EXISTS `stock`; 176 /*!40101 SET @saved_cs_client = @@character_set_client */; 177 /*!40101 SET character_set_client = utf8 */; 178 CREATE TABLE `stock` ( 179 `s_i_id` int(11) NOT NULL, 180 `s_w_id` int(11) NOT NULL, 181 `s_quantity` int(11) DEFAULT NULL, 182 `s_dist_01` char(24) DEFAULT NULL, 183 `s_dist_02` char(24) DEFAULT NULL, 184 `s_dist_03` char(24) DEFAULT NULL, 185 `s_dist_04` char(24) DEFAULT NULL, 186 `s_dist_05` char(24) DEFAULT NULL, 187 `s_dist_06` char(24) DEFAULT NULL, 188 `s_dist_07` char(24) DEFAULT NULL, 189 `s_dist_08` char(24) DEFAULT NULL, 190 `s_dist_09` char(24) DEFAULT NULL, 191 `s_dist_10` char(24) DEFAULT NULL, 192 `s_ytd` int(11) DEFAULT NULL, 193 `s_order_cnt` int(11) DEFAULT NULL, 194 `s_remote_cnt` int(11) DEFAULT NULL, 195 `s_data` varchar(50) DEFAULT NULL, 196 PRIMARY KEY (`s_w_id`,`s_i_id`) 197 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 198 /*!40101 SET character_set_client = @saved_cs_client */; 199 200 -- 201 -- Table structure for table `warehouse` 202 -- 203 204 DROP TABLE IF EXISTS `warehouse`; 205 /*!40101 SET @saved_cs_client = @@character_set_client */; 206 /*!40101 SET character_set_client = utf8 */; 207 CREATE TABLE `warehouse` ( 208 `w_id` int(11) NOT NULL, 209 `w_name` varchar(10) DEFAULT NULL, 210 `w_street_1` varchar(20) DEFAULT NULL, 211 `w_street_2` varchar(20) DEFAULT NULL, 212 `w_city` varchar(20) DEFAULT NULL, 213 `w_state` char(2) DEFAULT NULL, 214 `w_zip` char(9) DEFAULT NULL, 215 `w_tax` decimal(4,4) DEFAULT NULL, 216 `w_ytd` decimal(12,2) DEFAULT NULL, 217 PRIMARY KEY (`w_id`) 218 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 219 /*!40101 SET character_set_client = @saved_cs_client */;