Skip to content
This repository
tree: 2bf223051e
Fetching contributors…

Cannot retrieve contributors at this time

file 165 lines (139 sloc) 3.893 kb
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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165
CREATE TABLE 'accounts' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'firm_id' INTEGER DEFAULT NULL,
  'credit_limit' INTEGER DEFAULT NULL
);

CREATE TABLE 'companies' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'type' VARCHAR(255) DEFAULT NULL,
  'ruby_type' VARCHAR(255) DEFAULT NULL,
  'firm_id' INTEGER DEFAULT NULL,
  'name' TEXT DEFAULT NULL,
  'client_of' INTEGER DEFAULT NULL,
  'rating' INTEGER DEFAULT 1
);


CREATE TABLE 'topics' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'title' VARCHAR(255) DEFAULT NULL,
  'author_name' VARCHAR(255) DEFAULT NULL,
  'author_email_address' VARCHAR(255) DEFAULT NULL,
  'written_on' DATETIME DEFAULT NULL,
  'bonus_time' TIME DEFAULT NULL,
  'last_read' DATE DEFAULT NULL,
  'content' TEXT,
  'approved' INTEGER DEFAULT 1,
  'replies_count' INTEGER DEFAULT 0,
  'parent_id' INTEGER DEFAULT NULL,
  'type' VARCHAR(255) DEFAULT NULL
);

CREATE TABLE 'developers' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'name' TEXT DEFAULT NULL,
  'salary' INTEGER DEFAULT 70000
);

CREATE TABLE 'projects' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'name' TEXT DEFAULT NULL
);

CREATE TABLE 'developers_projects' (
  'developer_id' INTEGER NOT NULL,
  'project_id' INTEGER NOT NULL,
  'joined_on' DATE DEFAULT NULL
);

CREATE TABLE 'customers' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'name' VARCHAR(255) DEFAULT NULL,
  'balance' INTEGER DEFAULT 0,
  'address_street' TEXT DEFAULT NULL,
  'address_city' TEXT DEFAULT NULL,
  'address_country' TEXT DEFAULT NULL,
  'gps_location' TEXT DEFAULT NULL
);

CREATE TABLE 'movies' (
  'movieid' INTEGER PRIMARY KEY NOT NULL,
  'name' VARCHAR(255) DEFAULT NULL
);

CREATE TABLE subscribers (
 'nick' VARCHAR(255) PRIMARY KEY NOT NULL,
 'name' VARCHAR(255) DEFAULT NULL
);

CREATE TABLE 'booleantests' (
  'id' INTEGER PRIMARY KEY NOT NULL,
  'value' INTEGER DEFAULT NULL
);

CREATE TABLE 'auto_id_tests' (
  'auto_id' INTEGER PRIMARY KEY NOT NULL,
  'value' INTEGER DEFAULT NULL
);

CREATE TABLE 'entrants' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'name' VARCHAR(255) NOT NULL,
  'course_id' INTEGER NOT NULL
);

CREATE TABLE 'colnametests' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'references' INTEGER NOT NULL
);

CREATE TABLE 'mixins' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'parent_id' INTEGER DEFAULT NULL,
  'type' VARCHAR(40) DEFAULT NULL,
  'pos' INTEGER DEFAULT NULL,
  'lft' INTEGER DEFAULT NULL,
  'rgt' INTEGER DEFAULT NULL,
  'root_id' INTEGER DEFAULT NULL,
  'created_at' DATETIME DEFAULT NULL,
  'updated_at' DATETIME DEFAULT NULL
);

CREATE TABLE 'people' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'first_name' VARCHAR(40) DEFAULT NULL,
  'lock_version' INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE 'binaries' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'data' BLOB DEFAULT NULL
);

CREATE TABLE 'computers' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'developer' INTEGER NOT NULL,
  'extendedWarranty' INTEGER NOT NULL
);

CREATE TABLE 'posts' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'author_id' INTEGER,
  'title' VARCHAR(255) NOT NULL,
  'type' VARCHAR(255) NOT NULL,
  'body' TEXT NOT NULL
);

CREATE TABLE 'comments' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'post_id' INTEGER NOT NULL,
  'type' VARCHAR(255) NOT NULL,
  'body' TEXT NOT NULL
);

CREATE TABLE 'authors' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'name' VARCHAR(255) NOT NULL
);

CREATE TABLE 'tasks' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'starting' DATETIME DEFAULT NULL,
  'ending' DATETIME DEFAULT NULL
);

CREATE TABLE 'categories' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'name' VARCHAR(255) NOT NULL
);

CREATE TABLE 'categories_posts' (
  'category_id' INTEGER NOT NULL,
  'post_id' INTEGER NOT NULL
);

CREATE TABLE 'fk_test_has_pk' (
  'id' INTEGER NOT NULL PRIMARY KEY
);

CREATE TABLE 'fk_test_has_fk' (
  'id' INTEGER NOT NULL PRIMARY KEY,
  'fk_id' INTEGER NOT NULL,

  FOREIGN KEY ('fk_id') REFERENCES 'fk_test_has_pk'('id')
);
Something went wrong with that request. Please try again.