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 TABLE IF NOT EXISTS "auth_user" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "password" varchar(128) NOT NULL, "last_login" datetime NULL, "is_superuser" bool NOT NULL, "username" varchar(150) NOT NULL UNIQUE, "first_name" varchar(30) NOT NULL, "email" varchar(254) NOT NULL, "is_staff" bool NOT NULL, "is_active" bool NOT NULL, "date_joined" datetime NOT NULL, "last_name" varchar(150) NOT NULL);
INSERT INTO auth_user VALUES(1,'pbkdf2_sha256$120000$3ZKC56an7slm$A7IhT39VQCS25CRUFicosYd2uNXxoUBnOs8tDXSqZdc=','2025-06-18 12:27:26.792693',1,'admin','','nicolas.grosjean@neovision.fr',1,1,'2019-02-11 12:29:25.867459','');
INSERT INTO auth_user VALUES(5,'pbkdf2_sha256$120000$B3Bof0GYzkZ1$hqNF3AvuCQtB6GAZHYFmoRVEhkSN6IObZfuj7G+q7BI=','2024-05-21 11:28:25.833186',0,'cmonturet','Céline','cmonturet@transarc.fr',0,1,'2019-10-08 07:46:08','MONTURET');
INSERT INTO auth_user VALUES(8,'pbkdf2_sha256$120000$DQqugAgInTMk$JcToo4URryZyqpmvD7Xabfv3kvFm4bxizGSU0YfNmdE=','2020-02-06 13:04:16',0,'rmonnier','René','rmonnier@transarc.fr',0,1,'2019-10-08 07:48:45','MONNIER');
INSERT INTO auth_user VALUES(11,'pbkdf2_sha256$120000$0If9sNdJV58L$sVMHgL8zpmIMN4SiTY5Y3oL2wbX1frt87Wbd49LUoXc=','2021-02-05 10:35:42.974295',0,'cnaudin','Carine','cnaudin@transarc.fr',0,1,'2019-10-08 07:50:49','NAUDIN');
INSERT INTO auth_user VALUES(13,'pbkdf2_sha256$120000$PRml7q1PBs9O$VNFf+R9aygROarFFotXlHyQb6fD0J1dy5obvxhMdo2I=','2020-06-23 13:31:45',0,'rblanchet','Romain','rblanchet@transarc.fr',0,0,'2020-05-26 12:57:10','BLANCHET');
INSERT INTO auth_user VALUES(15,'pbkdf2_sha256$120000$Fjasvj36INbf$YFpzBJjXztcPZRxiwy9jU03qW8E51VGvnw2sLsn0ZEI=',NULL,0,'amattei@transarc.fr','Alexis','amattei@transarc.fr',0,1,'2021-11-12 10:56:58','MATTEI');
INSERT INTO auth_user VALUES(16,'pbkdf2_sha256$120000$ixQvd0ldb8Wl$GDqfrkl05JDzbyl+00Cm8alexxe2RbBQP3rZNlfXpMU=','2024-03-21 12:55:54.275417',1,'aperrot@transarc.fr','Alban','aperrot@transarc.fr',0,1,'2024-03-20 08:28:41','PERROT');
INSERT INTO auth_user VALUES(17,'pbkdf2_sha256$120000$qUlpTkwjvop3$62d2k5beEenQg5JltANXtRSqr/TW0GqTrD8As5OCmwk=','2025-04-30 07:41:46.568574',1,'lgueritas@transarc.fr','Léonie','lgueritas@transarc.fr',0,1,'2024-03-20 08:37:51','GUERITAS');
INSERT INTO auth_user VALUES(18,'pbkdf2_sha256$120000$hQDx4Pmo7AuM$Mz4IZ7z2v70/22EY68ihLoHgS6rwXWNMU97zLVncrM0=','2024-03-20 08:43:03.205759',1,'ldufour@transarc.fr','Léna','ldufour@transarc.fr',0,1,'2024-03-20 08:38:28','DUFOUR');
INSERT INTO auth_user VALUES(19,'pbkdf2_sha256$120000$1NVXlmfSgMtm$VyvQHDCJgp3W5MEe6upHnjgQljFHYCCrIpTfAekMIZI=','2024-09-24 09:28:01.586612',1,'mlacroix@transarc.fr','Maxime','mlacroix@transarc.fr',0,1,'2024-03-20 08:39:02','LACROIX');
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;
