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 */;