db/rtt.sqlite3 in rtt-0.0.0.46 vs db/rtt.sqlite3 in rtt-0.0.0.47

- old
+ new

@@ -1,9 +1,9 @@ -SQLite format 3@  - l- NK +defaultDefault Projectt  rtt_tasks%rtt_projects#rtt_clients rtt_users +SQLite format 3@  + l- NK +defaultDefault Projectt  rtt_tasks%rtt_projects#rtt_clients rtt_users  - default 6 !?DFDF2012-02-262012-02-26T09:11:55-02:00t ((zP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) H%%tablertt_projectsrtt_projectsCREATE TABLE "rtt_projects" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Project', "active" BOOLEAN DEFAULT 'f', "rate" FLOAT, "client_id" INTEGER NOT NULL)zI?%indexindex_rtt_projects_clientrtt_projectsCREATE INDEX "index_rtt_projects_client" ON "rtt_projects" ("client_id")zJ=%indexunique_rtt_projects_namertt_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")hKtablertt_tasksrtt_tasksCREATE TABLE "rtt_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT DEFAULT 'Default task' NOT NULL, "date" DATE, "start_at" TIMESTAMP, "end_at" TIMESTAMP, "active" BOOLEAN DEFAULT 'f', "accumulated_spent_time" FLOAT DEFAULT 0, "rate" FLOAT DEFAULT 0, "project_id" INTEGER NOT NULL, "user_id" INTEGER NOT NULL) hL5 indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")qM;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id") + default R9 !?GFJJJJJ2012-02-262012-02-26T19:28:44-02:00tT !??GF2012-02-262012-02-26T19:27:27-02:002012-02-26T19:28:44-02:00f?MlLZ' V !??DFDF2012-02-262012-02-26T09:11:55-02:002012-02-26T19:27:27-02:00f?[ua' ((zP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) H%%tablertt_projectsrtt_projectsCREATE TABLE "rtt_projects" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Project', "active" BOOLEAN DEFAULT 'f', "rate" FLOAT, "client_id" INTEGER NOT NULL)zI?%indexindex_rtt_projects_clientrtt_projectsCREATE INDEX "index_rtt_projects_client" ON "rtt_projects" ("client_id")zJ=%indexunique_rtt_projects_namertt_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")hKtablertt_tasksrtt_tasksCREATE TABLE "rtt_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT DEFAULT 'Default task' NOT NULL, "date" DATE, "start_at" TIMESTAMP, "end_at" TIMESTAMP, "active" BOOLEAN DEFAULT 'f', "accumulated_spent_time" FLOAT DEFAULT 0, "rate" FLOAT DEFAULT 0, "project_id" INTEGER NOT NULL, "user_id" INTEGER NOT NULL) hL5 indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")qM;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id") Nctablertt_usersrtt_users CREATE TABLE "rtt_users" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "nickname" VARCHAR(50) DEFAULT 'Default user' NOT NULL, "first_name" VARCHAR(50) DEFAULT '', "last_name" VARCHAR(50) DEFAULT '', "company" VARCHAR(50) DEFAULT '', "address" VARCHAR(50) DEFAULT '', "city" VARCHAR(50) DEFAULT '', "country" VARCHAR(50) DEFAULT '', "email" VARCHAR(50) DEFAULT '', "phone" VARCHAR(50) DEFAULT '', "zip" VARCHAR(50) DEFAULT '', "site" VARCHAR(50) DEFAULT '', "active" BOOLEAN DEFAULT 'f') % Default usert   zO?#indexunique_rtt_users_nicknamertt_users CREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")pP##'tablertt_clientsrtt_clients CREATE TABLE "rtt_clients" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Client', "active" BOOLEAN DEFAULT 'f')vQ;#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name") %Default user )defaultDefault Clientt - +  default - + \ No newline at end of file