PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "auth_group" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(80) NOT NULL UNIQUE);
CREATE TABLE IF NOT EXISTS "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE TABLE IF NOT EXISTS "auth_user_groups" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE TABLE IF NOT EXISTS "auth_user_user_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user_id" integer NOT NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE TABLE IF NOT EXISTS "auth_permission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED, "codename" varchar(100) NOT NULL, "name" varchar(255) NOT NULL);
INSERT INTO auth_permission VALUES(1,1,'add_logentry','Can add log entry');
INSERT INTO auth_permission VALUES(2,1,'change_logentry','Can change log entry');
INSERT INTO auth_permission VALUES(3,1,'delete_logentry','Can delete log entry');
INSERT INTO auth_permission VALUES(4,1,'view_logentry','Can view log entry');
INSERT INTO auth_permission VALUES(5,2,'add_permission','Can add permission');
INSERT INTO auth_permission VALUES(6,2,'change_permission','Can change permission');
INSERT INTO auth_permission VALUES(7,2,'delete_permission','Can delete permission');
INSERT INTO auth_permission VALUES(8,2,'view_permission','Can view permission');
INSERT INTO auth_permission VALUES(9,3,'add_group','Can add group');
INSERT INTO auth_permission VALUES(10,3,'change_group','Can change group');
INSERT INTO auth_permission VALUES(11,3,'delete_group','Can delete group');
INSERT INTO auth_permission VALUES(12,3,'view_group','Can view group');
INSERT INTO auth_permission VALUES(13,4,'add_user','Can add user');
INSERT INTO auth_permission VALUES(14,4,'change_user','Can change user');
INSERT INTO auth_permission VALUES(15,4,'delete_user','Can delete user');
INSERT INTO auth_permission VALUES(16,4,'view_user','Can view user');
INSERT INTO auth_permission VALUES(17,5,'add_contenttype','Can add content type');
INSERT INTO auth_permission VALUES(18,5,'change_contenttype','Can change content type');
INSERT INTO auth_permission VALUES(19,5,'delete_contenttype','Can delete content type');
INSERT INTO auth_permission VALUES(20,5,'view_contenttype','Can view content type');
INSERT INTO auth_permission VALUES(21,6,'add_session','Can add session');
INSERT INTO auth_permission VALUES(22,6,'change_session','Can change session');
INSERT INTO auth_permission VALUES(23,6,'delete_session','Can delete session');
INSERT INTO auth_permission VALUES(24,6,'view_session','Can view session');
INSERT INTO auth_permission VALUES(25,7,'add_businfo','Can add Modèle de Car');
INSERT INTO auth_permission VALUES(26,7,'change_businfo','Can change Modèle de Car');
INSERT INTO auth_permission VALUES(27,7,'delete_businfo','Can delete Modèle de Car');
INSERT INTO auth_permission VALUES(28,7,'view_businfo','Can view Modèle de Car');
INSERT INTO auth_permission VALUES(29,8,'add_upload','Can add Upload');
INSERT INTO auth_permission VALUES(30,8,'change_upload','Can change Upload');
INSERT INTO auth_permission VALUES(31,8,'delete_upload','Can delete Upload');
INSERT INTO auth_permission VALUES(32,8,'view_upload','Can view Upload');
INSERT INTO auth_permission VALUES(33,9,'add_sector','Can add Secteur');
INSERT INTO auth_permission VALUES(34,9,'change_sector','Can change Secteur');
INSERT INTO auth_permission VALUES(35,9,'delete_sector','Can delete Secteur');
INSERT INTO auth_permission VALUES(36,9,'view_sector','Can view Secteur');
INSERT INTO auth_permission VALUES(37,10,'add_completedtask','Can add completed task');
INSERT INTO auth_permission VALUES(38,10,'change_completedtask','Can change completed task');
INSERT INTO auth_permission VALUES(39,10,'delete_completedtask','Can delete completed task');
INSERT INTO auth_permission VALUES(40,10,'view_completedtask','Can view completed task');
INSERT INTO auth_permission VALUES(41,11,'add_task','Can add task');
INSERT INTO auth_permission VALUES(42,11,'change_task','Can change task');
INSERT INTO auth_permission VALUES(43,11,'delete_task','Can delete task');
INSERT INTO auth_permission VALUES(44,11,'view_task','Can view task');
INSERT INTO auth_permission VALUES(45,12,'add_propositionlist','Can add proposition list');
INSERT INTO auth_permission VALUES(46,12,'change_propositionlist','Can change proposition list');
INSERT INTO auth_permission VALUES(47,12,'delete_propositionlist','Can delete proposition list');
INSERT INTO auth_permission VALUES(48,12,'view_propositionlist','Can view proposition list');
INSERT INTO auth_permission VALUES(49,13,'add_propositionrepresentation','Can add proposition representation');
INSERT INTO auth_permission VALUES(50,13,'change_propositionrepresentation','Can change proposition representation');
INSERT INTO auth_permission VALUES(51,13,'delete_propositionrepresentation','Can delete proposition representation');
INSERT INTO auth_permission VALUES(52,13,'view_propositionrepresentation','Can view proposition representation');
INSERT INTO auth_permission VALUES(53,14,'add_graphicagerepresentation','Can add graphicage representation');
INSERT INTO auth_permission VALUES(54,14,'change_graphicagerepresentation','Can change graphicage representation');
INSERT INTO auth_permission VALUES(55,14,'delete_graphicagerepresentation','Can delete graphicage representation');
INSERT INTO auth_permission VALUES(56,14,'view_graphicagerepresentation','Can view graphicage representation');
INSERT INTO auth_permission VALUES(57,15,'add_usersector','Can add Responsable de secteur');
INSERT INTO auth_permission VALUES(58,15,'change_usersector','Can change Responsable de secteur');
INSERT INTO auth_permission VALUES(59,15,'delete_usersector','Can delete Responsable de secteur');
INSERT INTO auth_permission VALUES(60,15,'view_usersector','Can view Responsable de secteur');
INSERT INTO auth_permission VALUES(61,16,'add_sectorname','Can add Secteur');
INSERT INTO auth_permission VALUES(62,16,'change_sectorname','Can change Secteur');
INSERT INTO auth_permission VALUES(63,16,'delete_sectorname','Can delete Secteur');
INSERT INTO auth_permission VALUES(64,16,'view_sectorname','Can view Secteur');
CREATE UNIQUE INDEX "auth_group_permissions_group_id_permission_id_0cd325b0_uniq" ON "auth_group_permissions" ("group_id", "permission_id");
CREATE INDEX "auth_group_permissions_group_id_b120cbf9" ON "auth_group_permissions" ("group_id");
CREATE INDEX "auth_group_permissions_permission_id_84c5c92e" ON "auth_group_permissions" ("permission_id");
CREATE UNIQUE INDEX "auth_user_groups_user_id_group_id_94350c0c_uniq" ON "auth_user_groups" ("user_id", "group_id");
CREATE INDEX "auth_user_groups_user_id_6a12ed8b" ON "auth_user_groups" ("user_id");
CREATE INDEX "auth_user_groups_group_id_97559544" ON "auth_user_groups" ("group_id");
CREATE UNIQUE INDEX "auth_user_user_permissions_user_id_permission_id_14a6b632_uniq" ON "auth_user_user_permissions" ("user_id", "permission_id");
CREATE INDEX "auth_user_user_permissions_user_id_a95ead1b" ON "auth_user_user_permissions" ("user_id");
CREATE INDEX "auth_user_user_permissions_permission_id_1fbb5f2c" ON "auth_user_user_permissions" ("permission_id");
CREATE UNIQUE INDEX "auth_permission_content_type_id_codename_01ab375a_uniq" ON "auth_permission" ("content_type_id", "codename");
CREATE INDEX "auth_permission_content_type_id_2f476e4b" ON "auth_permission" ("content_type_id");
COMMIT;
