create.sql

来自「oracle dal gen,生成.NET ORACLE DAL层代码」· SQL 代码 · 共 59 行

/*
	The primary keys and foreign keys are still missing from this script.
*/


/*
  Sequences
*/
CREATE SEQUENCE  SEQ_CHILD_OBJECT  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 121 CACHE 20 NOORDER  NOCYCLE ;
CREATE SEQUENCE  SEQ_LIST_OBJECT  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 181 CACHE 20 NOORDER  NOCYCLE ;
CREATE SEQUENCE  SEQ_TEST_OBJECT  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 201 CACHE 20 NOORDER  NOCYCLE ;
 
/*
  Tables
*/
CREATE TABLE CHILD_OBJECT
   (	ID NUMBER(38,0), 
	NAME VARCHAR2(255 BYTE)
   ); 
   
CREATE TABLE LIST_OBJECT
 (	ID NUMBER(38,0), 
      NAME VARCHAR2(255 BYTE), 
      TEST_OBJECT_ID NUMBER
 );
 
CREATE TABLE TEST_OBJECT
 (	ID NUMBER(38,0), 
      NAME VARCHAR2(255 BYTE), 
      CHILD_OBJECT_ID NUMBER
 );

/*
  Triggers
*/
CREATE OR REPLACE TRIGGER TRI_CHILD_OBJECT before insert on child_object
for each row WHEN (new.id is null) begin
  select seq_child_object.nextval into :new.id from dual;
end;
 
CREATE OR REPLACE TRIGGER TRI_LIST_OBJECT before insert on list_object
for each row WHEN (new.id is null) begin
  select seq_list_object.nextval into :new.id from dual;
end;
 
CREATE OR REPLACE TRIGGER TRI_TEST_OBJECT before insert on test_object
for each row WHEN (new.id is null) begin
  select seq_test_object.nextval into :new.id from dual;
end;

/*
  Enable triggers
*/
ALTER TRIGGER TRI_CHILD_OBJECT" ENABLE;
ALTER TRIGGER TRI_LIST_OBJECT ENABLE;
ALTER TRIGGER TRI_TEST_OBJECT ENABLE;