SQLite format 3@ φϋφ       ((K•‚ %%„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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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)  €σh5 indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")q;indexindex_rtt_tasks_projectrtt_tasks CREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„ ‡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')     ‘ v ;#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name")z ?#indexunique_rtt_users_nicknamertt_users CREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")p ##ƒ'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')