File: TestSchema-0.001-Oracle.sql

package info (click to toggle)
libdbix-class-helpers-perl 2.033002-1
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 972 kB
  • ctags: 358
  • sloc: perl: 4,654; sql: 167; makefile: 7
file content (31 lines) | stat: -rw-r--r-- 504 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
-- 
-- Created by SQL::Translator::Producer::Oracle
-- Created on Mon Oct 31 16:03:25 2016
-- 
--
-- Table: Gnarly
--;

DROP TABLE "Gnarly" CASCADE CONSTRAINTS;

CREATE TABLE "Gnarly" (
  "id" number NOT NULL,
  "name" varchar2(4000) NOT NULL,
  "literature" clob,
  "your_mom" blob,
  PRIMARY KEY ("id")
);

--
-- Table: HasDateOps
--;

DROP TABLE "HasDateOps" CASCADE CONSTRAINTS;

CREATE TABLE "HasDateOps" (
  "id" number NOT NULL,
  "a_date" date NOT NULL,
  "b_date" date,
  PRIMARY KEY ("id")
);