rtt.sqlite3 in rtt-0.0.0.27

- old
+ new
@@ -1,9 +1,9 @@
-SQLite format 3@  
-
^öûöDA

àà¿¿! 
+SQLite format 3@  «
+
löûöNK

àà¿¿! 
 
-

((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_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")‚hA…tablertt_tasksrtt_tasksCREATE 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)
€óhB5	indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")qC;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„
-D‡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')

	
•ˆzE?#indexunique_rtt_users_nicknamertt_usersCREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")pF##ƒ'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')vG;#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name")
+

((z•P++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_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")‚hK…tablertt_tasksrtt_tasksCREATE 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)
€óhL5	indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")qM;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„
+N‡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')

	
•ˆ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_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name")
 

 
 
 
\ No newline at end of file