db/rtt.sqlite3 in rtt-0.0.0.11 vs db/rtt.sqlite3 in rtt-0.0.0.12

- old
+ new

@@ -1,9 +1,9 @@ -SQLite format 3@ bB๖ -๛๖0-  เเฟฟ!  +SQLite format 3@ ฌ +B๖ ๛๖0-  เเฟฟ!   -  ((z•P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚ *%%„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)z+?%indexindex_rtt_projects_clientrtt_projectsCREATE INDEX "index_rtt_projects_client" ON "rtt_projects" ("client_id")z,=%indexunique_rtt_projects_namertt_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")‚h-…tablertt_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) €๓h.5 indexindex_rtt_tasks_userrtt_tasks CREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")q/;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„ -0‡ctablertt_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')  •ˆz1?#indexunique_rtt_users_nicknamertt_users CREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")p2##ƒ'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')v3;#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name") +  ((z•P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚ *%%„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)z+?%indexindex_rtt_projects_clientrtt_projectsCREATE INDEX "index_rtt_projects_client" ON "rtt_projects" ("client_id")z,=%indexunique_rtt_projects_namertt_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")‚h-…tablertt_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) €๓h.5 indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")q/;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„ +0‡ctablertt_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')   •ˆz1?#indexunique_rtt_users_nicknamertt_users CREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")p2##ƒ'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')v3;#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name") +   -    - + \ No newline at end of file