/
githubmirror
/
tpcc
Обзор
Документация
Войти
/
githubmirror
/
tpcc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
src/test/java/com/oltpbenchmark/api/test-ddl.sql
37 строк
960 B
Wan Shen Lim
Automated code cleanup with IntelliJ.
26 июл 2021, 04:16
26 июл 2021, 04:16
9f5d041
Код
Авторство
О чём код?
-- NOTE: The table names are purposely left as lower case so that we -- can test where the Catalog loader can properly get the information CREATE TABLE a ( A_ID BIGINT NOT NULL, A_ID_STR VARCHAR(64) UNIQUE NOT NULL, A_BALANCE FLOAT NOT NULL, A_SATTR00 VARCHAR(32), A_SATTR01 VARCHAR(16), A_SATTR02 VARCHAR(8), A_IATTR00 TINYINT, A_IATTR01 SMALLINT, A_IATTR02 INT, A_IATTR03 BIGINT, PRIMARY KEY (A_ID) ); CREATE TABLE b ( B_ID BIGINT NOT NULL, B_DEPART_TIME TIMESTAMP NOT NULL, B_ARRIVE_TIME TIMESTAMP NOT NULL, B_STATUS TINYINT NOT NULL, B_BASE_PRICE FLOAT NOT NULL, PRIMARY KEY (B_ID) ); CREATE TABLE c ( C_ID BIGINT NOT NULL, C_A_ID BIGINT NOT NULL REFERENCES A (A_ID), C_B_ID BIGINT NOT NULL REFERENCES B (B_ID), C_SEAT BIGINT NOT NULL, UNIQUE (C_B_ID, C_SEAT), PRIMARY KEY (C_ID, C_A_ID, C_B_ID) );