Create tables in MySQL

fhueske · fhueske · commit d8997fe26aae · 2020-04-17T22:55:27.000+02:00
diff --git a/mysql/create_tables.sql b/mysql/create_tables.sql
@@ -1 +1,29 @@
-CREATE TABLE AreaCnts (areaId INT NOT NULL, cnt BIGINT NOT NULL, PRIMARY KEY (areaId));
+CREATE TABLE PROD_REGION (
+  R_REGIONKEY     INTEGER        NOT NULL,
+  R_NAME          CHAR(25)       NOT NULL,
+  R_COMMENT       VARCHAR(152)   NOT NULL
+);
+
+CREATE TABLE PROD_NATION (
+  N_NATIONKEY     INTEGER        NOT NULL,
+  N_NAME          CHAR(25)       NOT NULL,
+  N_REGIONKEY     INTEGER        NOT NULL,
+  N_COMMENT       VARCHAR(152)   NOT NULL
+);
+
+CREATE TABLE PROD_CUSTOMER (
+  C_CUSTKEY       INTEGER        NOT NULL,
+  C_NAME          VARCHAR(25)    NOT NULL,
+  C_ADDRESS       VARCHAR(40)    NOT NULL,
+  C_NATIONKEY     INTEGER        NOT NULL,
+  C_PHONE         CHAR(15)       NOT NULL,
+  C_ACCTBAL       DOUBLE         NOT NULL,
+  C_MKTSEGMENT    CHAR(10)       NOT NULL,
+  C_COMMENT       VARCHAR(117)   NOT NULL
+);
+
+CREATE TABLE PROD_RATES (
+  RS_TIMESTAMP    TIMESTAMP(3)   NOT NULL,
+  RS_SYMBOL       CHAR(3)        NOT NULL,
+  RS_RATE         DOUBLE         NOT NULL
+);
