/* 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;