View Trackers | Bugs | Export CSV

Date:
2005-09-19 11:07
Priority:
3
State:
Open
Submitted by:
Nobody
Assigned to:
Nobody (None)
Category:
none
Group:
none
Resolution:
none
Summary:
voici tout le contenu du bon tables.mysql.

Detailed description
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', '', '');
Message  ↓
Date: 2007-03-07 09:47
Sender: Nobody

Desidero appena dire che e un luogo ben cotto http://www.hjcost32.org/fuoco

Date: 2007-03-07 04:49
Sender: Nobody

L'information interessante que vous avez! I'am allant revenir bientot. http://www.hjcost32.org/testi

Date: 2007-03-07 02:24
Sender: Nobody

Lo trovo piuttosto impressionante. Lavoro grande fatto..) http://www.hjcost32.org/culo

Date: 2007-03-06 23:58
Sender: Nobody

um... buoni, realmente buoni luogo e molto utile;) http://www.hjcost32.org/credito

Date: 2007-03-06 21:31
Sender: Nobody

La buona visione del senso! http://www.hjcost32.org/foto

Date: 2007-03-06 19:02
Sender: Nobody

i'am really impressed!! http://www.hjcost32.org/azzurra

Date: 2007-03-06 16:34
Sender: Nobody

I'll be BACK! :) ;) http://www.cartk5e68.org/ringtone

Date: 2007-03-06 14:04
Sender: Nobody

La buona visione del senso! http://www.cartk5e68.org/tiscali

Date: 2007-03-06 11:35
Sender: Nobody

Luogo grande! Grande giusto! I miei riguardi migliori al proprietario:) http://www.cartk5e68.org/alitalia

Date: 2007-03-06 09:04
Sender: Nobody

Luogo interessante. Info molto importante, grazie molto! http://www.cartk5e68.org/pasta

Date: 2007-03-06 06:33
Sender: Nobody

i'am really impressed!! http://www.cartk5e68.org/keira-knightley

Date: 2007-03-06 03:59
Sender: Nobody

Grande sito!! http://www.cartk5e68.org/la-scala

Date: 2007-03-05 22:58
Sender: Nobody

Grande! Il luogo cose buon, tutto e abbastanza ragionevole e piacevole.. http://www.nuovi5y.org/tattoo

Date: 2007-03-05 20:28
Sender: Nobody

OOOOO! Luogo che molto buon avete! Saluti da Milano:) http://www.nuovi5y.org/umbria

Date: 2007-03-05 17:59
Sender: Nobody

Luogo grande! Grande giusto! I miei riguardi migliori al proprietario:) http://www.nuovi5y.org/fiorentina

Date: 2007-03-05 15:27
Sender: Nobody

sono eccitato circa questo luogo, buon lavoro!:) http://www.nuovi5y.org/figa

Date: 2007-03-05 12:34
Sender: Nobody

OOOOO! Luogo che molto buon avete! Saluti da Milano:) http://www.nuovi5y.org/dj-italia

Date: 2007-03-04 15:33
Sender: Nobody

Nice site you have! http://www.ojgetti.org/wallpaper

Date: 2007-03-04 12:44
Sender: Nobody

Great site! Good luck to it's owner! http://www.ojgetti.org/nude

Date: 2007-03-04 09:56
Sender: Nobody

Ich erklare meinen Freunden uber diese Seite. Interessieren! http://www.ojgetti.org/bambino

Date: 2007-03-04 07:03
Sender: Nobody

9 su 10! Ottenerlo! Siete buoni! http://www.ojgetti.org/parma

Date: 2007-03-04 04:11
Sender: Nobody

9 su 10! Ottenerlo! Siete buoni! http://www.ojgetti.org/ciao-bella

Date: 2007-03-04 02:55
Sender: Nobody

Marvellous! That's the site I was looking for!:) http://www.google.greatnow.com

Date: 2007-03-04 01:20
Sender: Nobody

Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.ojgetti.org/suonerie

Date: 2007-03-03 22:28
Sender: Nobody

Dein Aufstellungsort verdient nur gute Woerter. Danke. http://www.2ire17.org/sicilia

Date: 2007-03-03 16:43
Sender: Nobody

luogo interessante, soddisfare interessante, buon! http://www.2ire17.org/aria

Date: 2007-03-03 13:50
Sender: Nobody

I'll be BACK! :) ;) http://www.2ire17.org/cristiana

Date: 2007-03-03 10:57
Sender: Nobody

Ich besichtige deinen Aufstellungsort wieder bald fur sicheres! http://www.2ire17.org/pokemon-porn

Date: 2007-03-02 21:55
Sender: Nobody

9 su 10! Ottenerlo! Siete buoni! http://www.2ire17.org/alessandra

Date: 2007-03-02 19:10
Sender: Nobody

http://itsesso.beeplog.com

Date: 2007-03-02 16:21
Sender: Nobody

http://www.bloggingmylife.com/?u=sessois

Date: 2007-03-02 13:30
Sender: Nobody

WOW!! I like it! http://www.avwzioni.org/figa

Date: 2007-03-02 10:40
Sender: Nobody

Grande! Il luogo cose buon, tutto e abbastanza ragionevole e piacevole.. http://www.avwzioni.org/economici

Date: 2007-03-02 07:48
Sender: Nobody

Grand emplacement! La conception est merveilleuse! http://www.avwzioni.org/supereva

Date: 2007-03-02 04:56
Sender: Nobody

luogo grande:) nessun osservazioni! http://www.avwzioni.org/molise

Date: 2007-03-02 02:05
Sender: Nobody

Great site! Good luck to it's owner! http://www.avwzioni.org/nudi

Date: 2007-03-01 23:13
Sender: Nobody

Grande sito!! http://www.avwzioni.org/capelli

Date: 2007-03-01 20:22
Sender: Nobody

Interessieren. SEHR interessant! ;) http://www.avwzioni.org/filmati

Date: 2007-03-01 17:28
Sender: Nobody

Luogo molto buon:) Buona fortuna! http://www.canaxe.org/sexi

Date: 2007-03-01 14:09
Sender: Nobody

Very valuable information you have here. Thanks.. http://www.canaxe.org/traduzioni

Date: 2007-03-01 10:59
Sender: Nobody

I'll be BACK! :) ;) http://www.canaxe.org/videocamere

Date: 2007-03-01 04:31
Sender: Nobody

Desidero appena dire che e un luogo ben cotto http://www.canaxe.org/trasporti

Date: 2007-03-01 01:15
Sender: Nobody

Very valuable information you have here. Thanks.. http://www.canaxe.org/entertainment

Date: 2007-02-28 21:57
Sender: Nobody

Luogo interessante. Info molto importante, grazie molto! http://www.canaxe.org/corsi

Date: 2007-02-28 18:38
Sender: Nobody

Luogo grande! Grande giusto! I miei riguardi migliori al proprietario:) http://www.canaxe.org/antivirus

Date: 2007-02-26 00:49
Sender: Nobody

Dein Aufstellungsort verdient nur gute Woerter. Danke. http://www.flryanair.org/totti

Date: 2007-02-24 06:30
Sender: Nobody

Luogo molto buon:) Buona fortuna! http://www.bovso.org/libera

Date: 2007-02-22 06:15
Sender: Nobody

Chi ha fatto questo? E un buon posto per trovare le informazioni importanti!:) http://www.abkorto.org/giorgia-palmas

Date: 2007-02-16 11:03
Sender: Nobody

I'll be BACK! :) ;) http://www.usate348.org/produttori

No related tasks

No attached documents

No changes have been made to this item

FEDER Powered By FusionForge Collaborative Development Environment Charte d'utilisation / Nous contacter / Mentions légales Haut de page