--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Sat Feb 6 08:01:11 2010
+-- Created on Thu Jun 3 11:52:50 2010
--
-;
--
-- Table: artist
CREATE TABLE artist (
artistid INTEGER PRIMARY KEY NOT NULL,
name varchar(100),
- rank integer NOT NULL DEFAULT '13',
+ rank integer NOT NULL DEFAULT 13,
charfield char(10)
);
);
--
--- Table: bindtype_test2
---
-CREATE TABLE bindtype_test2 (
- id INTEGER PRIMARY KEY NOT NULL,
- bytea blob,
- a_blob blob,
- a_clob clob
-);
-
---
-- Table: collection
--
CREATE TABLE collection (
);
--
--- Table: employee
---
-CREATE TABLE employee (
- employee_id INTEGER PRIMARY KEY NOT NULL,
- position integer NOT NULL,
- group_id integer,
- group_id_2 integer,
- group_id_3 integer,
- name varchar(100)
-);
-
---
-- Table: encoded
--
CREATE TABLE encoded (
--
CREATE TABLE event (
id INTEGER PRIMARY KEY NOT NULL,
- starts_at datetime NOT NULL,
+ starts_at date NOT NULL,
created_on timestamp NOT NULL,
varchar_date varchar(20),
varchar_datetime varchar(20),
);
--
+-- Table: timestamp_primary_key_test
+--
+CREATE TABLE timestamp_primary_key_test (
+ id timestamp NOT NULL DEFAULT current_timestamp,
+ PRIMARY KEY (id)
+);
+
+--
-- Table: treelike
--
CREATE TABLE treelike (
CREATE INDEX books_idx_owner ON books (owner);
+CREATE UNIQUE INDEX books_title ON books (title);
+
+--
+-- Table: employee
+--
+CREATE TABLE employee (
+ employee_id INTEGER PRIMARY KEY NOT NULL,
+ position integer NOT NULL,
+ group_id integer,
+ group_id_2 integer,
+ group_id_3 integer,
+ name varchar(100),
+ encoded integer
+);
+
+CREATE INDEX employee_idx_encoded ON employee (encoded);
+
--
-- Table: forceforeign
--
-- View: year2000cds
--
CREATE VIEW year2000cds AS
- SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000"
\ No newline at end of file
+ SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000";