--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Thu Mar 23 11:13:18 2006
+-- Created on Sun Apr 30 07:37:44 2006
--
BEGIN TRANSACTION;
--
--- Table: employees_positioned
+-- Table: employee
--
-CREATE TABLE employees_positioned (
+CREATE TABLE employee (
employee_id INTEGER PRIMARY KEY NOT NULL,
position integer NOT NULL,
group_id integer,
);
--
--- Table: cd_to_producer
---
-CREATE TABLE cd_to_producer (
- cd integer NOT NULL,
- producer integer NOT NULL,
- PRIMARY KEY (cd, producer)
-);
-
---
-- Table: liner_notes
--
CREATE TABLE liner_notes (
);
--
--- Table: employees_adjacencylist
+-- Table: cd_to_producer
--
-CREATE TABLE employees_adjacencylist (
- employee_id INTEGER PRIMARY KEY NOT NULL,
- parent_id integer,
- name varchar(100)
+CREATE TABLE cd_to_producer (
+ cd integer NOT NULL,
+ producer integer NOT NULL,
+ PRIMARY KEY (cd, producer)
);
--
);
--
--- Table: employees_positioned_adjacencylist
+-- Table: twokeytreelike
--
-CREATE TABLE employees_positioned_adjacencylist (
- employee_id INTEGER PRIMARY KEY NOT NULL,
- parent_id integer,
- position integer NOT NULL,
- name varchar(100)
+CREATE TABLE twokeytreelike (
+ id1 integer NOT NULL,
+ id2 integer NOT NULL,
+ parent1 integer NOT NULL,
+ parent2 integer NOT NULL,
+ name varchar(100) NOT NULL,
+ PRIMARY KEY (id1, id2)
);
--
);
--
+-- Table: self_ref
+--
+CREATE TABLE self_ref (
+ id INTEGER PRIMARY KEY NOT NULL,
+ name varchar(100) NOT NULL
+);
+
+--
-- Table: treelike
--
CREATE TABLE treelike (
);
--
--- Table: self_ref
---
-CREATE TABLE self_ref (
- id INTEGER PRIMARY KEY NOT NULL,
- name varchar(100) NOT NULL
-);
-
---
-- Table: twokeys
--
CREATE TABLE twokeys (
name varchar(100) NOT NULL
);
+CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name);
+CREATE UNIQUE INDEX artist_title_cd on cd (artist, title);
COMMIT;