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

-- generated by: SchemaCrawler 17.3.0
-- generated on: 2026-01-11T21:40:53.2932335
-- database: HSQL Database Engine 2.7.4
-- driver: HSQL Database Engine Driver 2.7.4
-- operating system: Windows 11 10.0
-- JVM system: Microsoft OpenJDK 64-Bit Server VM 21.0.8+9-LTS


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 CHARACTER,
  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 "Celebrities"
(
  "Id" INTEGER NOT NULL,
  NAME VARCHAR
);

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

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 PUBLISHERS
(
  ID INTEGER NOT NULL,
  PUBLISHER VARCHAR
);

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

CREATE TABLE "Celebrity Updates"
(
  "Celebrity Id" INTEGER NOT NULL,
  "UPDATE" VARCHAR
);

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

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,
  COUPON_ID INTEGER,
  PERIODENDDATE DATE,
  TOTALAMOUNT DOUBLE,
  SALESDATAID INTEGER
);

SET SCHEMA PUBLIC.SYSTEM_LOBS;

