/
development_structure.sql
42 lines (28 loc) · 4.81 KB
/
development_structure.sql
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
CREATE TABLE "activities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ticket_id" integer(11) DEFAULT NULL NULL, "user_id" integer(11) DEFAULT NULL NULL, "text" varchar(255) DEFAULT NULL NULL, "date" date DEFAULT NULL NULL, "minutes" integer(11) DEFAULT NULL NULL, "started_at" datetime DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL, "stopped_at" datetime DEFAULT NULL NULL);
CREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer(11) DEFAULT NULL NULL, "name" varchar(255) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "components" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer(11) DEFAULT NULL NULL, "name" varchar(255) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer(11) DEFAULT NULL NULL, "user_id" integer(11) DEFAULT NULL NULL);
CREATE TABLE "milestones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "remote_id" integer(11) DEFAULT NULL NULL, "project_id" integer(11) DEFAULT NULL NULL, "release_id" integer(11) DEFAULT NULL NULL, "type" varchar(255) DEFAULT NULL NULL, "name" varchar(255) DEFAULT NULL NULL, "body" text DEFAULT NULL NULL, "start_at" date DEFAULT NULL NULL, "end_at" date DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "lighthouse_account" varchar(255) DEFAULT NULL NULL, "lighthouse_token" varchar(255) DEFAULT NULL NULL, "remote_id" integer(11) DEFAULT NULL NULL, "name" varchar(255) DEFAULT NULL NULL, "body" text DEFAULT NULL NULL, "synced_at" datetime DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "remote_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT NULL NULL, "local_id" integer DEFAULT NULL NULL, "local_type" varchar(255) DEFAULT NULL NULL, "remote_id" integer DEFAULT NULL NULL);
CREATE TABLE "scheduled_days" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer(11) DEFAULT NULL NULL, "user_id" integer(11) DEFAULT NULL NULL, "day" date DEFAULT NULL NULL, "hours" integer(11) DEFAULT NULL NULL);
CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL);
CREATE TABLE "ticket_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ticket_id" integer(11) DEFAULT NULL NULL, "version" integer(11) DEFAULT NULL NULL, "estimated" float DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL, "sprint_id" integer);
CREATE TABLE "tickets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "remote_id" integer(11) DEFAULT NULL NULL, "parent_id" integer(11) DEFAULT NULL NULL, "project_id" integer(11) DEFAULT NULL NULL, "release_id" integer(11) DEFAULT NULL NULL, "sprint_id" integer(11) DEFAULT NULL NULL, "category_id" integer(11) DEFAULT NULL NULL, "component_id" integer(11) DEFAULT NULL NULL, "user_id" integer(11) DEFAULT NULL NULL, "title" varchar(255) DEFAULT NULL NULL, "body" text DEFAULT NULL NULL, "estimated" float DEFAULT NULL NULL, "actual" float DEFAULT NULL NULL, "state" varchar(255) DEFAULT NULL NULL, "closed" integer(11) DEFAULT NULL NULL, "local" integer(11) DEFAULT NULL NULL, "priority" integer(11) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL, "version" integer(11) DEFAULT NULL NULL);
CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "remote_id" integer(11) DEFAULT NULL NULL, "name" varchar(255) DEFAULT NULL NULL);
CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version");
INSERT INTO schema_migrations (version) VALUES ('20081005082826');
INSERT INTO schema_migrations (version) VALUES ('20081005083905');
INSERT INTO schema_migrations (version) VALUES ('20081007133049');
INSERT INTO schema_migrations (version) VALUES ('20081003095733');
INSERT INTO schema_migrations (version) VALUES ('20081008191637');
INSERT INTO schema_migrations (version) VALUES ('20081003103912');
INSERT INTO schema_migrations (version) VALUES ('20081008195542');
INSERT INTO schema_migrations (version) VALUES ('20081003120619');
INSERT INTO schema_migrations (version) VALUES ('20081003120620');
INSERT INTO schema_migrations (version) VALUES ('20081003120621');
INSERT INTO schema_migrations (version) VALUES ('20081003120622');
INSERT INTO schema_migrations (version) VALUES ('20081003120623');
INSERT INTO schema_migrations (version) VALUES ('20081005075922');
INSERT INTO schema_migrations (version) VALUES ('20081013124942');
INSERT INTO schema_migrations (version) VALUES ('20081023205708');