Copie e cole o seguinte texto no editor de SQL: --DROP TABLE_TEST_SCHEMA.NOTE;
CREATE TABLE TEST_SCHEMA.NOTE
(
TO CHAR (50),
FROM CHAR (50),
HEADING CHAR (50),
BODY CHAR (50)
) ;
--DROP TABLE TEST_SCHEMA.CUSTOMER;
CREATE TABLE TEST_SCHEMA.CUSTOMER
(
CID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 32672 NO CYCLE CACHE 20),
INFO XML,
HISTORY XML
) ;
--DROP TABLE TEST_SCHEMA.PurchaseOrder
CREATE TABLE TEST_SCHEMA.PurchaseOrder
(
POID BIGINT NOT NULL,
STATUS VARCHAR(10) NOT NULL,
CUSTID BIGINT,
ORDERDATE DATE,
PORDER XML,
COMMENTS VARCHAR(1000)
) ;