DROP TABLE IF EXISTS "groups";
CREATE TABLE "groups" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , "name" VARCHAR, "created_at" DATETIME DEFAULT CURRENT_TIMESTAMP);
INSERT INTO "groups" VALUES(1,'coders','2012-02-01 21:17:50');
INSERT INTO "groups" VALUES(2,'jazzman','2012-02-01 21:18:40');
DROP TABLE IF EXISTS "permissions";
CREATE TABLE "permissions" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , "user_id" INTEGER, "group_id" INTEGER, "role" VARCHAR);
INSERT INTO "permissions" VALUES(1,1,1,'member');
INSERT INTO "permissions" VALUES(2,2,1,'member');
INSERT INTO "permissions" VALUES(5,3,2,'member');
INSERT INTO "permissions" VALUES(7,4,2,'admin');
DROP TABLE IF EXISTS "users";
CREATE TABLE "users" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , "name" VARCHAR, "email" VARCHAR, "created_at" DATETIME DEFAULT CURRENT_TIMESTAMP);
INSERT INTO "users" VALUES(1,'davert','davert@mail.ua','2012-02-01 21:17:04');
INSERT INTO "users" VALUES(2,'nick','nick@mail.ua','2012-02-01 21:17:15');
INSERT INTO "users" VALUES(3,'miles','miles@davis.com','2012-02-01 21:17:25');
INSERT INTO "users" VALUES(4,'bird','charlie@parker.com','2012-02-01 21:17:39');
