test.script

来自「Example Hibernate and Java」· SCRIPT 代码 · 共 10 行

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE CONTACTO(ID_CONTACTO BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,NOMBRE VARCHAR(255),MAIL VARCHAR(255),ID_PROVEEDOR BIGINT NOT NULL)
CREATE MEMORY TABLE PROVEEDOR(ID_PROVEEDOR BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,NOMBRE VARCHAR(255),WEB VARCHAR(255))
ALTER TABLE CONTACTO ADD CONSTRAINT FKCD3504F8119A416 FOREIGN KEY(ID_PROVEEDOR) REFERENCES PROVEEDOR(ID_PROVEEDOR)
ALTER TABLE CONTACTO ALTER COLUMN ID_CONTACTO RESTART WITH 1
ALTER TABLE PROVEEDOR ALTER COLUMN ID_PROVEEDOR RESTART WITH 1
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10