-- Testing UTF-8 characters: ¥ · £ · € · $ · ¢ · ₡ · ₢ · ₣ · ₤ · ₥ · ₦ · ₧ · ₨ · ₩ · ₪ · ₫ · ₭ · ₮ · ₯

-- generated by: SchemaCrawler 15.05.01
-- generated on: 2019-01-13 00:37:00
-- database: HSQL Database Engine 2.4.1
-- driver: HSQL Database Engine Driver 2.4.1
-- operating system: Windows 10 10.0
-- JVM system: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.8.0_191-b12


SET SCHEMA PUBLIC.BOOKS;

CREATE TABLE AUTHORS
(
  ID INTEGER NOT NULL,
  FIRSTNAME VARCHAR NOT NULL,
  LASTNAME VARCHAR NOT NULL,
  ADDRESS1 VARCHAR,
  ADDRESS2 VARCHAR,
  CITY VARCHAR,
  STATE VARCHAR,
  POSTALCODE VARCHAR,
  COUNTRY VARCHAR
);

CREATE TABLE BOOKS
(
  ID INTEGER NOT NULL,
  TITLE VARCHAR NOT NULL,
  DESCRIPTION VARCHAR,
  PUBLISHERID INTEGER NOT NULL,
  PUBLICATIONDATE DATE,
  PRICE DOUBLE,
  PREVIOUSEDITIONID INTEGER
);

CREATE TABLE COUPONS
(
  ID INTEGER NOT NULL,
  DATA CLOB,
  COUPONS PUBLIC.BOOKS."INTEGER ARRAY",
  BOOKS PUBLIC.BOOKS."VARCHAR(20) ARRAY[10]"
);

CREATE TABLE CUSTOMERDATA
(
  ID INTEGER NOT NULL,
  DATA PUBLIC.BOOKS.VALID_STRING
);

CREATE TABLE CUSTOMERS
(
  ID INTEGER NOT NULL,
  FIRSTNAME PUBLIC.BOOKS.NAME_TYPE NOT NULL,
  LASTNAME PUBLIC.BOOKS.NAME_TYPE NOT NULL,
  AGE PUBLIC.BOOKS.AGE_TYPE
);

CREATE TABLE "Global Counts"
(
  "Global Count" INTEGER,
  "UPDATE" VARCHAR
);

CREATE TABLE PUBLISHERS
(
  ID INTEGER NOT NULL,
  PUBLISHER VARCHAR
);

CREATE TABLE BOOKAUTHORS
(
  BOOKID INTEGER NOT NULL,
  AUTHORID INTEGER NOT NULL,
  SOMEDATA VARCHAR
);

CREATE TABLE ΒΙΒΛΊΑ
(
  ΜΟΝΑΔΙΚΌΣ SMALLINT NOT NULL,
  ΤΊΤΛΟΣ VARCHAR NOT NULL,
  ΠΕΡΙΓΡΑΦΉ VARCHAR,
  ΕΚΔΌΤΗΣ SMALLINT NOT NULL
);

SET SCHEMA PUBLIC.INFORMATION_SCHEMA;

SET SCHEMA PUBLIC.PUBLIC;

SET SCHEMA PUBLIC."PUBLISHER SALES";

CREATE TABLE REGIONS
(
  CITY VARCHAR NOT NULL,
  STATE VARCHAR NOT NULL,
  POSTALCODE VARCHAR NOT NULL,
  COUNTRY VARCHAR NOT NULL
);

CREATE TABLE SALESDATA
(
  SALESDATAID INTEGER,
  YEARLYAMOUNT DOUBLE
);

CREATE TABLE SALES
(
  POSTALCODE VARCHAR NOT NULL,
  COUNTRY VARCHAR NOT NULL,
  BOOKID INTEGER,
  PERIODENDDATE DATE,
  TOTALAMOUNT DOUBLE,
  SALESDATAID INTEGER
);

SET SCHEMA PUBLIC.SYSTEM_LOBS;

