diff options
Diffstat (limited to 'bulk/oracle/auto/person.sql')
-rw-r--r-- | bulk/oracle/auto/person.sql | 33 |
1 files changed, 0 insertions, 33 deletions
diff --git a/bulk/oracle/auto/person.sql b/bulk/oracle/auto/person.sql deleted file mode 100644 index 7676ef6..0000000 --- a/bulk/oracle/auto/person.sql +++ /dev/null @@ -1,33 +0,0 @@ -/* This file was generated by ODB, object-relational mapping (ORM) - * compiler for C++. - */ - -SET FEEDBACK OFF; -WHENEVER SQLERROR EXIT FAILURE; -WHENEVER OSERROR EXIT FAILURE; - -BEGIN - BEGIN - EXECUTE IMMEDIATE 'DROP TABLE "person" CASCADE CONSTRAINTS'; - EXCEPTION - WHEN OTHERS THEN - IF SQLCODE != -942 THEN RAISE; END IF; - END; - BEGIN - EXECUTE IMMEDIATE 'DROP SEQUENCE "person_seq"'; - EXCEPTION - WHEN OTHERS THEN - IF SQLCODE != -2289 THEN RAISE; END IF; - END; -END; -/ - -CREATE TABLE "person" ( - "id" NUMBER(20) NOT NULL PRIMARY KEY, - "num" NUMBER(10) NOT NULL UNIQUE, - "str" CLOB NOT NULL); - -CREATE SEQUENCE "person_seq" - START WITH 1 INCREMENT BY 1; - -EXIT; |