/rdbms-496

Primary LanguageJavaApache License 2.0Apache-2.0

rdbms-496

Creation of schema results in the following SQL

CREATE TABLE PRODUCT
(
  PRODUCT_ID BIGINT NOT NULL AUTO_INCREMENT,
  PRODUCT_DESCRIPTION VARCHAR(767) BINARY NULL,
  PRODUCT_NAME VARCHAR(128) BINARY NULL,
  CONSTRAINT PRODUCT_PK PRIMARY KEY (PRODUCT_ID)
) ENGINE=INNODB

CREATE TABLE PRODUCT_PERSON
(
  PRODUCT_NAME BIGINT NOT NULL,
  PERSON_AGE BIGINT NOT NULL,
  CITY VARCHAR(256) BINARY NULL,
  PERSON_NAME VARCHAR(128) BINARY NOT NULL,
  CONSTRAINT PRODUCT_SUPPLIER_PK PRIMARY KEY (PRODUCT_NAME,PERSON_NAME)
) ENGINE=INNODB