| Description détaillée |
|
|
DROP TABLE IF EXISTS etat;
CREATE TABLE `etat` (`id` bigint(20) NOT NULL default '0',`nom` text NOT NULL);
INSERT INTO `etat` VALUES (1, 'Non commencé');
INSERT INTO `etat` VALUES (2, 'Programmé');
INSERT INTO `etat` VALUES (3, 'En cours');
INSERT INTO `etat` VALUES (4, 'Fini');
DROP TABLE IF EXISTS j_mailuser_room;
CREATE TABLE j_mailuser_room (`login` text NOT NULL,`id_room` int(11) NOT NULL default '0');
INSERT INTO `j_mailuser_room` VALUES ('RSKAWINSKI', 1);
INSERT INTO `j_mailuser_room` VALUES ('BDELMOTTE', 1);
DROP TABLE IF EXISTS j_user_area;
CREATE TABLE j_user_area (`login` text NOT NULL,`id_area` int(11) NOT NULL default '0');
DROP TABLE IF EXISTS j_user_room;
CREATE TABLE j_user_room (`login` text NOT NULL,`id_room` int(11) NOT NULL default '0');
INSERT INTO `j_user_room` VALUES ('RSKAWINSKI', 1);
INSERT INTO `j_user_room` VALUES ('BDELMOTTE', 6);
DROP TABLE IF EXISTS log;
CREATE TABLE log (`LOGIN` varchar(16) NOT NULL default '',`START` datetime NOT NULL default '0000-00-00 00:00:00',`SESSION_ID` varchar(64) NOT NULL default '',`REMOTE_ADDR` varchar(16) NOT NULL default '',`USER_AGENT` varchar(64) NOT NULL default '',`REFERER` varchar(64) NOT NULL default '',`AUTOCLOSE` enum('0','1') NOT NULL default '0',`END` datetime NOT NULL default '0000-00-00 00:00:00',PRIMARY KEY (`SESSION_ID`,`START`));
DROP TABLE IF EXISTS mrbs_area;
CREATE TABLE mrbs_area (`id` int(11) NOT NULL auto_increment,`area_name` varchar(30) default NULL,`access` char(1) NOT NULL default '',`order_display` smallint(6) NOT NULL default '0',PRIMARY KEY (`id`));
INSERT INTO `mrbs_area` VALUES (1, 'Intervention', 'a', 0);
DROP TABLE IF EXISTS mrbs_entry;
CREATE TABLE mrbs_entry (`id` int(11) NOT NULL auto_increment,`start_time` int(11) NOT NULL default '0',`end_time` int(11) NOT NULL default '0',`entry_type` int(11) NOT NULL default '0',`repeat_id` int(11) NOT NULL default '0',`room_id` int(11) NOT NULL default '1',`timestamp` text NOT NULL,`create_by` varchar(25) NOT NULL default '',`name` varchar(80) NOT NULL default '',`type` char(1) NOT NULL default 'E',`description` text,`statut_entry` char(1) NOT NULL default '-',`idUrgence` int(11) NOT NULL default '4',`idEtat` int(11) NOT NULL default '1',`idService` int(11) NOT NULL default '0',`contact` text,`mailcontact` text,`infosie` text,PRIMARY KEY (`id`));
DROP TABLE IF EXISTS mrbs_repeat;
CREATE TABLE mrbs_repeat (`id` int(11) NOT NULL auto_increment,`start_time` int(11) NOT NULL default '0',`end_time` int(11) NOT NULL default '0',`rep_type` int(11) NOT NULL default '0',`end_date` int(11) NOT NULL default '0',`rep_opt` varchar(32) NOT NULL default '',`room_id` int(11) NOT NULL default '1',`timestamp` text NOT NULL,`create_by` varchar(25) NOT NULL default '',`name` varchar(80) NOT NULL default '',`type` char(1) NOT NULL default 'E',`description` text,`rep_num_weeks` tinyint(4) default '0',PRIMARY KEY (`id`));
DROP TABLE IF EXISTS mrbs_room;
CREATE TABLE mrbs_room (`id` int(11) NOT NULL auto_increment,`area_id` int(11) NOT NULL default '0',`room_name` varchar(25) NOT NULL default '',`description` varchar(60) default NULL,`capacity` int(11) NOT NULL default '0',`max_booking` smallint(6) NOT NULL default '-1',`statut_room` char(1) NOT NULL default '1',`show_fic_room` char(1) NOT NULL default 'n',`picture_room` varchar(50) NOT NULL default '',`comment_room` text NOT NULL,PRIMARY KEY (`id`));
INSERT INTO `mrbs_room` VALUES (1, 1, 'Raphaël SKAWINSKI', '', 0, -1, '1', 'n', '', 'Technicien');
INSERT INTO `mrbs_room` VALUES (6, 1, 'Blandine DELMOTTE', '', 0, -1, '1', 'n', '', 'Chef Service');
DROP TABLE IF EXISTS services;
CREATE TABLE services (`id` int(11) NOT NULL auto_increment,`nom` text NOT NULL,`adresse` text,`telephone` text,PRIMARY KEY (`id`));
INSERT INTO `services` VALUES (1, 'Cyber-base Marais', '60 rue Victor Hugo 59160 LOMME', '03.20.00.61.52');
INSERT INTO `services` VALUES (2, 'Cyber-base Blum', '\r\n', '');
INSERT INTO `services` VALUES (3, 'Cyber-base Mitterie', 'Ecole Léon Blum\r\nRue Max Dormoy 59160 LOMME', '03.20.00.61.49');
INSERT INTO `services` VALUES (4, 'Cyber-base Délivrance', 'Ecole Curie-Pasteur\r\nAv. de la Délivrance 59160 Lomme', '03.20.09.14.63');
INSERT INTO `services` VALUES (5, 'Cyber-base Mont-à -Camp', '343 Av. de Dunkerque 59160 Lomme', '03.20.22.17.04');
INSERT INTO `services` VALUES (6, 'T.I.C', 'Espace les Tisserrands\r\n60 rue Victor Hugo \r\n59160 Lomme', '03.20.08.43.70');
INSERT INTO `services` VALUES (7, 'Police Municipale', NULL, NULL);
INSERT INTO `services` VALUES (8, 'Ateliers Municipaux', NULL, NULL);
INSERT INTO `services` VALUES (9, 'Médiathèque', NULL, NULL);
DROP TABLE IF EXISTS setting;
CREATE TABLE setting (`NAME` varchar(32) NOT NULL default '',`VALUE` text NOT NULL,PRIMARY KEY (`NAME`));
INSERT INTO `setting` VALUES ('sessionMaxLength', '30');
INSERT INTO `setting` VALUES ('automatic_mail', 'yes');
INSERT INTO `setting` VALUES ('company', 'Service T.I.C');
INSERT INTO `setting` VALUES ('webmaster_name', 'Admin');
INSERT INTO `setting` VALUES ('webmaster_email', 'giml@mairie-lomme.fr');
INSERT INTO `setting` VALUES ('technical_support_email', 'support.technique@marie-lomme.fr');
INSERT INTO `setting` VALUES ('grr_url', 'http://www.marie-lomme.fr/giml');
INSERT INTO `setting` VALUES ('disable_login', 'no');
INSERT INTO `setting` VALUES ('begin_bookings', '1109631600');
INSERT INTO `setting` VALUES ('end_bookings', '1230678000');
INSERT INTO `setting` VALUES ('title_home_page', 'Mairie de Lomme');
INSERT INTO `setting` VALUES ('message_home_page', 'En raison du caractère personnel du contenu, ce site est soumis à des restrictions utilisateurs. Pour accéder au planning d''interventions, identifiez-vous :');
INSERT INTO `setting` VALUES ('version', '0.90');
INSERT INTO `setting` VALUES ('default_language', 'fr');
INSERT INTO `setting` VALUES ('default_css', 'style.css');
INSERT INTO `setting` VALUES ('default_area', '1');
INSERT INTO `setting` VALUES ('default_room', '-1');
DROP TABLE IF EXISTS urgence;
CREATE TABLE urgence (`id` bigint(20) NOT NULL default '0',`nom` text NOT NULL);
INSERT INTO `urgence` VALUES (1, 'Immédiat');
INSERT INTO `urgence` VALUES (2, 'Rapide');
INSERT INTO `urgence` VALUES (3, 'Moyenne');
INSERT INTO `urgence` VALUES (4, 'Non Urgent');
DROP TABLE IF EXISTS utilisateurs;
CREATE TABLE utilisateurs (`id` bigint(20) NOT NULL auto_increment,`login` text,`nom` text,`prenom` text,`password` text,`email` text,`statut` text,`etat` varchar(20) default NULL,`default_area` smallint(6) NOT NULL default '0',`default_room` smallint(6) NOT NULL default '0',`default_style` varchar(50) NOT NULL default '',`default_list_type` varchar(50) NOT NULL default '',`default_language` char(3) NOT NULL default '',PRIMARY KEY (`id`));
INSERT INTO `utilisateurs` VALUES (1, 'ADMIN', 'Administrateur', 'GIML', 'ab4f63f9ac65152575886860dde480a1', 'XXXX', 'administrateur', 'actif', 1, -1, 'style.css', 'select', '');
INSERT INTO `utilisateurs` VALUES (2, 'RSKAWINSKI', 'SKAWINSKI ', 'Raphaël', '695f4bc23731820d9d0978cb5a536e1b', 'rskawinski@mairie-lomme.fr', 'utilisateur', 'actif', 1, 1, 'style.css', '', '');
INSERT INTO `utilisateurs` VALUES (3, 'BDELMOTTE', 'DELMOTTE', 'Blandine', '695f4bc23731820d9d0978cb5a536e1b', 'bdelmotte@mairie-lomme.fr', 'utilisateur', 'actif', 1, 6, 'style.css', '', '');
|
|
