bonjour à tous Ce petit mail pour vous informer que j'ai terminé mon stage dans la société OpenSides, et que ceci étant, j'arrête (du mois jusqu'à jeudi prochain, le temps de faire mon mémoire) ma collaboration à GLPI.
Avant d'expliquer ou j'en suis arrivé pour le portage pour PGSQL, je
tiens vite fait à remercier les gens qui m'ont aidé, et ceux qui m'ont
pas aidé aussi, ce fut un plaisir de rencontrer d'autres dev fan de
logiciel libre (yen a trop peu à mon école).
En ce qui concerne le portage vrs PostGreSQL, je suis arrivé ici :
Sur les conseils avisé de DJ Anubis, j'ai utilisé la librairie
d'interfacage AdoDB (dispo sur sourceforge) en version 4.6.2 (environ,
si je dis pas nawak).
L'installation se fait tout connement, dézipper le fichier zip la ou
ca vous arrange, dans $phproot/glpi/adodb dans mon cas.
Après ceci, il suffit de rajouter
include($phproot . "/glpi/adodb/adodb.inc.php"); dans le fichier
glpi/includes.php, ceci pour avoir accès aux fonctions proposées par
AdoDB ou que vous soyiez dans le code de GLPI.
les autres fichiers modifiés sont :
- install.php, modifié de tel sorte à demander quel dbms utiliser, et
continuer le script d'installation en fonction (à ce propos, j'ai
rajouté une variable $driver dans la classe DB du fichier
config_db.php).
- la classe DBmysql (fichier glpi/common/classe.php) renommée en
DBhandler, vu qu'elle n'est plus vraiment pleine de MySQL. elle
contient juste le constructeur, et un getInstance qui renvoie le
handler DB.
- le fichier AdoDB.php.inc (c'est gore, mais c'est plus simple) pour
les requetes typiques MySQL (genre $db->result($result,$i,$field), ou
numrow($result), qui font simplement appel à des fonctions définies
dans le même fichier.
- le fichier config.php, qui contient le premier script sql à toujours
être appelé (select * from config), et qui contient l'appel au
constructeur DB.
Le système employé pour cette histoire de getInstance est celui-ci :
on crée le handler DB via
GLOBAL $mydb = new DB();
new DB fait lui même appel à &ADONewConnection('$driver'); si le
handler db n'existe pas encore. il se connecte également à la DB et
sélectionne la DB GLPI.
dans le code en lui meme, il suffit alors de remplacer tous les appels
à $db = new DB() (suivi des query kivonbien) par
$db = $db = $GLOBALS["mydb"]->getInstance();
suite à quoi $db permet d'atteindre les fonctions définies par AdoDB.
Vous trouverez mes fichiers modifiés en pièce jointe.
La ou j'en suis arrivé :
- la connexion à la db et l'execution des querys marche parfaitement.
Ca coince à deux endroits :
- il arrive que mysql ou AdoDB (pas trop eu le temps d'investiguer la
dessus) renvoie un resultset en majuscule, alors que glpi s'attend à
un resultset avec clés associatives comme écrites dans la db (genre
FK_glpi_entreprise, ID, ou type). Ceci cause un problème à php qui s'y
retrouve plus, etaffiche un superbe message d'erreur.
L'autre soucis provient de l'implémentation actuelle de GLPI, et du
passage par copie de PHP.
quand on parcours un résultset avec la méthode GLPI-ienne (qui
fonctionne, personne n'en doutera), il "faut" faire comme ceci :
while ($data = $db->fetch_assoc|num|array($result)) {
// traitement sur $data
}
avec AdoDB, ca se complique un chouia, et le problème est les quelques
centaines (voir plus) de querys à modifier à la main (nan, pas de sed
ici, bien trop compliqué)
while (!$result->EOF) {
$data = $result->fields;
// traitement de $data
$result->MoveNext();
}
J'ai bien sur commencé avec cette méthode la, elle fonctionne, mais le
temps qu'il faut passer à débugger le truc quand le problème de
majuscule arrive en meme temps...
Donc voila, mes conclusions sur la tentative de portage vers PostGreSQL :
C'est possible, si si, promis juré.
le problème est que c'est pas un gentil stagiaire à qui il restait 3
semaine pour porter l'application qui va y arriver.
d'abord parce que le temps de tout patcher est assez long
surtout parce que le code cvs bouge assez (beaucoup) vite
enfin parce qu'il faut que les développeurs principaux soient vraiment
désireux qu'on porte leur application vers un truc plus portable, et
acceptent d'aider un peu (dans le sens commencer à penser à utiliser
un truc portable pour la version 0.6 plutot que s'amuser à modifier la
classe DBmysql pour accepter ce qui viendra plus tard - procédures
stockées, trigger, etc, alors qu'un truc tout fait et éprouvé existe).
Enfin bon, je sais que je pourrai pas changer le monde, mais ca
m'empêche pas de rêver.
De toute facon bonne chance pour la suite, d'après ce que je lis un
peu partout, GLPI est largement en avance sur les autre outils de
gestion de parc info libres, profitez-en pour réfléchir sur le futur
lointain, genre plugins perso, version gprs, traduction plus simple
(gettext), utilisation de plusieurs db possibles, avant de retourner
mettre les doigts dans la versio CVS :))
Amusez-vous bien sans moi, faites attention à vous, et bonne soirée :)
nicodache
ps : vous trouverez également parmis les fichiers joint le script SQL
de création de DB compatible PostGreSQL.
install.php
Description: application/php
classes.php
Description: application/php
adodb.inc.php
Description: application/php
config.php
Description: application/php
-- GLPI Dump database on 2005-05-04 01:15
-- Dump table glpi_cartridges
-- DROP TABLE IF EXISTS glpi_cartridges;
CREATE TABLE glpi_cartridges (
ID SERIAL PRIMARY KEY,
FK_glpi_cartridges_type INT4 DEFAULT '0' NOT NULL,
FK_glpi_printers INT4 DEFAULT '0' NOT NULL,
date_in DATE,
date_use DATE,
date_out DATE,
pages INT4 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_cartridges_assoc
-- DROP TABLE IF EXISTS glpi_cartridges_assoc;
CREATE TABLE glpi_cartridges_assoc (
ID SERIAL PRIMARY KEY,
FK_glpi_cartridges_type INT4 DEFAULT '0' NOT NULL,
FK_glpi_type_printer INT4 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_cartridges_type
-- DROP TABLE IF EXISTS glpi_cartridges_type;
CREATE TABLE glpi_cartridges_type (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
ref varchar(255) NOT NULL,
location INT4 DEFAULT '0' NOT NULL,
type INT2 DEFAULT '0' NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
tech_num INT4 DEFAULT '0',
deleted BOOL DEFAULT 'N' NOT NULL,
comments TEXT NOT NULL,
);
-- Dump table glpi_computer_device
-- DROP TABLE IF EXISTS glpi_computer_device;
CREATE TABLE glpi_computer_device (
ID SERIAL PRIMARY KEY,
specificity varchar(250) NOT NULL,
device_type INT2 DEFAULT '0' NOT NULL,
FK_device INT4 DEFAULT '0' NOT NULL,
FK_computers INT4 DEFAULT '0' NOT NULL,
);
INSERT INTO glpi_computer_device VALUES ('1','','8','1','19');
INSERT INTO glpi_computer_device VALUES ('2','','8','1','21');
INSERT INTO glpi_computer_device VALUES ('3','','8','4','8');
INSERT INTO glpi_computer_device VALUES ('4','','8','4','10');
INSERT INTO glpi_computer_device VALUES ('5','','8','4','15');
INSERT INTO glpi_computer_device VALUES ('6','','8','4','18');
INSERT INTO glpi_computer_device VALUES ('7','','8','4','20');
INSERT INTO glpi_computer_device VALUES ('8','20','4','1','10');
INSERT INTO glpi_computer_device VALUES ('9','20','4','1','15');
INSERT INTO glpi_computer_device VALUES ('10','20','4','1','18');
INSERT INTO glpi_computer_device VALUES ('11','6','4','1','20');
INSERT INTO glpi_computer_device VALUES ('12','10','4','2','8');
INSERT INTO glpi_computer_device VALUES ('13','','4','2','19');
INSERT INTO glpi_computer_device VALUES ('14','','4','2','21');
INSERT INTO glpi_computer_device VALUES ('15','','5','1','8');
INSERT INTO glpi_computer_device VALUES ('16','','5','1','10');
INSERT INTO glpi_computer_device VALUES ('17','','5','1','18');
INSERT INTO glpi_computer_device VALUES ('18','','5','1','19');
INSERT INTO glpi_computer_device VALUES ('19','','5','1','21');
INSERT INTO glpi_computer_device VALUES ('20','','5','5','15');
INSERT INTO glpi_computer_device VALUES ('21','','5','5','20');
INSERT INTO glpi_computer_device VALUES ('22','','1','2','19');
INSERT INTO glpi_computer_device VALUES ('23','','1','2','21');
INSERT INTO glpi_computer_device VALUES ('24','','1','3','8');
INSERT INTO glpi_computer_device VALUES ('25','','1','3','10');
INSERT INTO glpi_computer_device VALUES ('26','','1','3','15');
INSERT INTO glpi_computer_device VALUES ('27','','1','3','18');
INSERT INTO glpi_computer_device VALUES ('28','','1','3','20');
INSERT INTO glpi_computer_device VALUES ('29','333','2','6','20');
INSERT INTO glpi_computer_device VALUES ('30','750','2','7','8');
INSERT INTO glpi_computer_device VALUES ('31','750','2','7','10');
INSERT INTO glpi_computer_device VALUES ('32','750','2','7','15');
INSERT INTO glpi_computer_device VALUES ('33','750','2','7','18');
INSERT INTO glpi_computer_device VALUES ('34','','2','11','19');
INSERT INTO glpi_computer_device VALUES ('35','','2','11','21');
INSERT INTO glpi_computer_device VALUES ('36','','3','1','19');
INSERT INTO glpi_computer_device VALUES ('37','','3','1','21');
INSERT INTO glpi_computer_device VALUES ('38','512','3','6','8');
INSERT INTO glpi_computer_device VALUES ('39','128','3','6','10');
INSERT INTO glpi_computer_device VALUES ('40','512','3','6','15');
INSERT INTO glpi_computer_device VALUES ('41','128','3','6','18');
INSERT INTO glpi_computer_device VALUES ('42','128','3','9','20');
INSERT INTO glpi_computer_device VALUES ('43','','9','1','19');
INSERT INTO glpi_computer_device VALUES ('44','','9','3','8');
INSERT INTO glpi_computer_device VALUES ('45','','9','3','10');
INSERT INTO glpi_computer_device VALUES ('46','','9','3','15');
INSERT INTO glpi_computer_device VALUES ('47','','9','3','18');
INSERT INTO glpi_computer_device VALUES ('48','','9','3','20');
INSERT INTO glpi_computer_device VALUES ('49','','9','3','21');
-- Dump table glpi_computers
-- DROP TABLE IF EXISTS glpi_computers;
CREATE TABLE glpi_computers (
ID SERIAL PRIMARY KEY,
name varchar(200) NOT NULL,
flags_server INT2 DEFAULT '0' NOT NULL,
serial varchar(200) NOT NULL,
otherserial varchar(200) NOT NULL,
contact varchar(90) NOT NULL,
contact_num varchar(90) NOT NULL,
tech_num INT4 DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
date_mod TIMESTAMP,
os INT4,
location INT4,
type INT4,
is_template INT DEFAULT '0' NOT NULL CHECK (is_template IN (0,1)),
tplname varchar(200),
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
);
INSERT INTO glpi_computers VALUES ('8','Dell Inspiron 450','0','4586-sd6-fds','','Roger Rabbit','5462','0','','2003-09-18 00:15:44','5','1','1','0',NULL,'0','N');
INSERT INTO glpi_computers VALUES ('10','Dell Inspiron 450','0','4598-jhd-545','','Peter Pan','8565','0','','2003-09-18 00:07:58','13','1','1','0',NULL,'0','N');
INSERT INTO glpi_computers VALUES ('15','Dell Inspiron 450','0','4561-hsub-dfsnj','','Poppins Marry','6545','0','','2003-09-18 00:09:47','1','1','1','0',NULL,'0','N');
INSERT INTO glpi_computers VALUES ('18','IBM 945gx','0','9854-5f-4s4f','','Jeannot Lapin','5465','0','','2003-09-18 00:05:07','2','1','1','0',NULL,'0','N');
INSERT INTO glpi_computers VALUES ('19','','0','','','','','0','Empty Template',NULL,'2','0','1','1','Blank Template','0','N');
INSERT INTO glpi_computers VALUES ('20','','0','','','','','0','Standard iMac',NULL,'9','0','3','1','iMac','0','N');
INSERT INTO glpi_computers VALUES ('21','','0','','','','','0','',NULL,'12','1','1','1','test','0','N');
-- Dump table glpi_config
-- DROP TABLE IF EXISTS glpi_config;
CREATE TABLE glpi_config (
ID SERIAL PRIMARY KEY,
num_of_events varchar(200) NOT NULL,
jobs_at_login varchar(200) NOT NULL,
sendexpire varchar(200) NOT NULL,
cut varchar(200) NOT NULL,
expire_events varchar(200) NOT NULL,
list_limit varchar(200) NOT NULL,
version varchar(200) NOT NULL,
logotxt varchar(200) NOT NULL,
root_doc varchar(200) NOT NULL,
event_loglevel varchar(200) NOT NULL,
mailing varchar(200) NOT NULL,
imap_auth_server varchar(200) NOT NULL,
imap_host varchar(200) NOT NULL,
ldap_host varchar(200) NOT NULL,
ldap_basedn varchar(200) NOT NULL,
ldap_rootdn varchar(200) NOT NULL,
ldap_pass varchar(200) NOT NULL,
admin_email varchar(200) NOT NULL,
mailing_signature varchar(200) NOT NULL,
mailing_new_admin varchar(200) NOT NULL,
mailing_followup_admin varchar(200) NOT NULL,
mailing_finish_admin varchar(200) NOT NULL,
mailing_new_all_admin varchar(200) NOT NULL,
mailing_followup_all_admin varchar(200) NOT NULL,
mailing_finish_all_admin varchar(200) NOT NULL,
mailing_new_all_normal varchar(200) NOT NULL,
mailing_followup_all_normal varchar(200) NOT NULL,
mailing_finish_all_normal varchar(200) NOT NULL,
mailing_new_attrib varchar(200) NOT NULL,
mailing_followup_attrib varchar(200) NOT NULL,
mailing_finish_attrib varchar(200) NOT NULL,
mailing_new_user varchar(200) NOT NULL,
mailing_followup_user varchar(200) NOT NULL,
mailing_finish_user varchar(200) NOT NULL,
ldap_field_name varchar(200) NOT NULL,
ldap_field_email varchar(200) NOT NULL,
ldap_field_location varchar(200) NOT NULL,
ldap_field_realname varchar(200) NOT NULL,
ldap_field_phone varchar(200) NOT NULL,
ldap_condition varchar(255) NOT NULL,
permit_helpdesk varchar(200) NOT NULL,
default_language varchar(255) DEFAULT 'french' NOT NULL,
priority_1 varchar(200) DEFAULT '#fff2f2' NOT NULL,
priority_2 varchar(200) DEFAULT '#ffe0e0' NOT NULL,
priority_3 varchar(200) DEFAULT '#ffcece' NOT NULL,
priority_4 varchar(200) DEFAULT '#ffbfbf' NOT NULL,
priority_5 varchar(200) DEFAULT '#ffadad' NOT NULL,
date_fiscale DATE DEFAULT '2005-12-31' NOT NULL,
cartridges_alarm INT4 DEFAULT '10' NOT NULL,
);
INSERT INTO glpi_config VALUES ('1','10','1','1','80','30','15',' 0.51','GLPI powered by indepnet','/glpi','5','0','','','','','','','[EMAIL PROTECTED]','SIGNATURE','1','1','1','1','0','0','0','0','0','0','0','0','1','1','1','uid','mail','physicaldeliveryofficename','cn','telephonenumber','','','french','#fff2f2','#ffe0e0','#ffcece','#ffbfbf','#ffadad','2005-12-31','10');
-- Dump table glpi_connect_wire
-- DROP TABLE IF EXISTS glpi_connect_wire;
CREATE TABLE glpi_connect_wire (
ID SERIAL PRIMARY KEY,
end1 INT4 DEFAULT '0' NOT NULL,
end2 INT4 DEFAULT '0' NOT NULL,
type INT2 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_contact_enterprise
-- DROP TABLE IF EXISTS glpi_contact_enterprise;
CREATE TABLE glpi_contact_enterprise (
ID SERIAL PRIMARY KEY,
FK_enterprise INT4 DEFAULT '0' NOT NULL,
FK_contact INT4 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_contacts
-- DROP TABLE IF EXISTS glpi_contacts;
CREATE TABLE glpi_contacts (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
phone varchar(30) NOT NULL,
phone2 varchar(30) NOT NULL,
fax varchar(30) NOT NULL,
email varchar(255) NOT NULL,
type INT2 DEFAULT '1' NOT NULL,
comments TEXT NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
);
-- Dump table glpi_contract_device
-- DROP TABLE IF EXISTS glpi_contract_device;
CREATE TABLE glpi_contract_device (
ID SERIAL PRIMARY KEY,
FK_contract INT4 DEFAULT '0' NOT NULL,
FK_device INT4 DEFAULT '0' NOT NULL,
device_type INT2 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_contract_enterprise
-- DROP TABLE IF EXISTS glpi_contract_enterprise;
CREATE TABLE glpi_contract_enterprise (
ID SERIAL PRIMARY KEY,
FK_enterprise INT4 DEFAULT '0' NOT NULL,
FK_contract INT4 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_contracts
-- DROP TABLE IF EXISTS glpi_contracts;
CREATE TABLE glpi_contracts (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
num varchar(255) NOT NULL,
cost float DEFAULT '0' NOT NULL,
contract_type INT4 DEFAULT '0' NOT NULL,
begin_date DATE,
duration INT2 DEFAULT '0' NOT NULL,
notice INT2 DEFAULT '0' NOT NULL,
periodicity INT2 DEFAULT '0' NOT NULL,
facturation INT2 DEFAULT '0' NOT NULL,
bill_type INT4 DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
compta_num varchar(255) NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
week_begin_hour time DEFAULT '00:00:00' NOT NULL,
week_end_hour time DEFAULT '00:00:00' NOT NULL,
saturday_begin_hour time DEFAULT '00:00:00' NOT NULL,
saturday_end_hour time DEFAULT '00:00:00' NOT NULL,
saturday BOOL DEFAULT 'N' NOT NULL,
monday_begin_hour time DEFAULT '00:00:00' NOT NULL,
monday_end_hour time DEFAULT '00:00:00' NOT NULL,
monday BOOL DEFAULT 'N' NOT NULL,
);
-- Dump table glpi_device_case
-- DROP TABLE IF EXISTS glpi_device_case;
CREATE TABLE glpi_device_case (
ID SERIAL PRIMARY KEY,
designation varchar(255) NOT NULL,
format varchar(10) CHECK (format IN ('Grand','Moyen','Micro') DEFAULT 'Moyen' NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
-- Dump table glpi_device_control
-- DROP TABLE IF EXISTS glpi_device_control;
CREATE TABLE glpi_device_control (
ID SERIAL PRIMARY KEY,
designation varchar(255) NOT NULL,
interface enum('IDE','SATA','SCSI','USB') DEFAULT 'IDE' NOT NULL,
raid BOOL DEFAULT 'Y' NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
-- Dump table glpi_device_drive
-- DROP TABLE IF EXISTS glpi_device_drive;
CREATE TABLE glpi_device_drive (
ID SERIAL PRIMARY KEY,
designation varchar(255) NOT NULL,
is_writer BOOL DEFAULT 'Y' NOT NULL,
speed varchar(30) NOT NULL,
interface varchar(10) CHECK (interface IN ('IDE','SATA','SCSI')) DEFAULT 'IDE' NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
-- Dump table glpi_device_gfxcard
-- DROP TABLE IF EXISTS glpi_device_gfxcard;
CREATE TABLE glpi_device_gfxcard (
ID SERIAL PRIMARY KEY,
designation varchar(120) NOT NULL,
ram varchar(10) NOT NULL,
interface varchar(10) CHECK (interface IN ('ISA','PCI','AGP','PCI-Express')) DEFAULT 'AGP' NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_gfxcard VALUES ('1','ATI Rage Pro 3D AGP','','AGP','','0','');
INSERT INTO glpi_device_gfxcard VALUES ('2','Matrox Millenium G400DH','','AGP','','0','');
INSERT INTO glpi_device_gfxcard VALUES ('3','S3 Trio 64V+','','AGP','','0','');
INSERT INTO glpi_device_gfxcard VALUES ('4','integrated','','AGP','','0','');
-- Dump table glpi_device_hdd
-- DROP TABLE IF EXISTS glpi_device_hdd;
CREATE TABLE glpi_device_hdd (
ID SERIAL PRIMARY KEY,
designation varchar(100) NOT NULL,
rpm varchar(20) NOT NULL,
interface varchar(10) CHECK (interface IN ('IDE','SATA','SCSI')) DEFAULT 'IDE' NOT NULL,
cache varchar(20) NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_hdd VALUES ('1','IBM DTTA 35101','','IDE','','','0','');
INSERT INTO glpi_device_hdd VALUES ('2','IBM DCAS 34330','','IDE','','','0','');
-- Dump table glpi_device_iface
-- DROP TABLE IF EXISTS glpi_device_iface;
CREATE TABLE glpi_device_iface (
ID SERIAL PRIMARY KEY,
designation varchar(120) NOT NULL,
bandwidth varchar(20) NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_iface VALUES ('1','3Com (100Mbps)','','','0','');
INSERT INTO glpi_device_iface VALUES ('2','3Com (10Mbps)','','','0','');
INSERT INTO glpi_device_iface VALUES ('3','Intel (100Mbps)','','','0','');
INSERT INTO glpi_device_iface VALUES ('4','Intel (10Mbps)','','','0','');
INSERT INTO glpi_device_iface VALUES ('5','Generic 100Mbps Card','','','0','');
INSERT INTO glpi_device_iface VALUES ('6','Generic 10Mbps Card','','','0','');
INSERT INTO glpi_device_iface VALUES ('7','None','','','0','');
INSERT INTO glpi_device_iface VALUES ('8','AMD 10Mbps','','','0','');
INSERT INTO glpi_device_iface VALUES ('9','Realtek 10Mbps','','','0','');
INSERT INTO glpi_device_iface VALUES ('10','Realtek 100Mbps','','','0','');
INSERT INTO glpi_device_iface VALUES ('11','integrated','','','0','');
-- Dump table glpi_device_moboard
-- DROP TABLE IF EXISTS glpi_device_moboard;
CREATE TABLE glpi_device_moboard (
ID SERIAL PRIMARY KEY,
designation varchar(100) NOT NULL,
chipset varchar(120) NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_moboard VALUES ('1','Asus T2P4S','','','0','');
INSERT INTO glpi_device_moboard VALUES ('2','Asus P2BX','','','0','');
INSERT INTO glpi_device_moboard VALUES ('3','unknown','','','0','');
-- Dump table glpi_device_pci
-- DROP TABLE IF EXISTS glpi_device_pci;
CREATE TABLE glpi_device_pci (
ID SERIAL PRIMARY KEY,
designation varchar(255) NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
-- Dump table glpi_device_power
-- DROP TABLE IF EXISTS glpi_device_power;
CREATE TABLE glpi_device_power (
ID SERIAL PRIMARY KEY,
designation varchar(255) NOT NULL,
power varchar(20) NOT NULL,
atx BOOL DEFAULT 'Y' NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
-- Dump table glpi_device_processor
-- DROP TABLE IF EXISTS glpi_device_processor;
CREATE TABLE glpi_device_processor (
ID SERIAL PRIMARY KEY,
designation varchar(120) NOT NULL,
frequence INT4 DEFAULT '0' NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_processor VALUES ('1','Intel Pentium','0','','0','');
INSERT INTO glpi_device_processor VALUES ('2','Intel Pentium II','0','','0','');
INSERT INTO glpi_device_processor VALUES ('3','AMD K6-1','0','','0','');
INSERT INTO glpi_device_processor VALUES ('4','AMD K6-2','0','','0','');
INSERT INTO glpi_device_processor VALUES ('5','AMD K6-3','0','','0','');
INSERT INTO glpi_device_processor VALUES ('6','PowerPC G3','0','','0','');
INSERT INTO glpi_device_processor VALUES ('7','Intel Pentium III','0','','0','');
INSERT INTO glpi_device_processor VALUES ('8','AMD Athlon','0','','0','');
INSERT INTO glpi_device_processor VALUES ('9','68k (Motorola)','0','','0','');
INSERT INTO glpi_device_processor VALUES ('10','486 SX','0','','0','');
INSERT INTO glpi_device_processor VALUES ('11','486 DX','0','','0','');
INSERT INTO glpi_device_processor VALUES ('12','486 DX2/4','0','','0','');
INSERT INTO glpi_device_processor VALUES ('13','Intel Itanium','0','','0','');
INSERT INTO glpi_device_processor VALUES ('14','PowerPC G4','0','','0','');
INSERT INTO glpi_device_processor VALUES ('15','RS3000','0','','0','');
INSERT INTO glpi_device_processor VALUES ('16','RS10k','0','','0','');
INSERT INTO glpi_device_processor VALUES ('17','Alpha EV6.7','0','','0','');
INSERT INTO glpi_device_processor VALUES ('18','PowerPC 603ev','0','','0','');
INSERT INTO glpi_device_processor VALUES ('19','PowerPC 603','0','','0','');
INSERT INTO glpi_device_processor VALUES ('20','PowerPC 601','0','','0','');
INSERT INTO glpi_device_processor VALUES ('21','68040','0','','0','');
INSERT INTO glpi_device_processor VALUES ('22','68040','0','','0','');
INSERT INTO glpi_device_processor VALUES ('23','ULTRASparc II','0','','0','');
INSERT INTO glpi_device_processor VALUES ('24','Intel Pentium IV','0','','0','');
INSERT INTO glpi_device_processor VALUES ('25','AMD Athlon','0','','0','');
INSERT INTO glpi_device_processor VALUES ('26','AMD Duron','0','','0','');
-- Dump table glpi_device_ram
-- DROP TABLE IF EXISTS glpi_device_ram;
CREATE TABLE glpi_device_ram (
ID SERIAL PRIMARY KEY,
designation varchar(100) NOT NULL,
type varchar(10) CHECK (type IN ('FPM','EDO','SDRAM','RDRAM','DDR-SDRAM','DDR2-SDRAM')) DEFAULT 'DDR' NOT NULL,
frequence varchar(8) NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_ram VALUES ('1','36pin SIMMS','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('2','72pin SIMMS (Fast Page)','FPM','','','0');
INSERT INTO glpi_device_ram VALUES ('3','72pin SIMMS (EDO)','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('4','Unbuffered DIMMs','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('5','DIMMs w/EEPROM','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('6','SDRAM DIMMs (<10ns)','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('7','ECC DIMMs','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('8','Other','EDO','','','0');
INSERT INTO glpi_device_ram VALUES ('9','168 pin Synchronous Dynamic RAM','SDRAM','','','0');
INSERT INTO glpi_device_ram VALUES ('10','Rambus Dynamic RAM','RDRAM','','','0');
INSERT INTO glpi_device_ram VALUES ('11','184 pin Double Data Rate RAM','DDR-SDRAM','','','0');
INSERT INTO glpi_device_ram VALUES ('12','240 pin Double Data Rate 2 RAM','DDR2-SDRAM','','','0');
-- Dump table glpi_device_sndcard
-- DROP TABLE IF EXISTS glpi_device_sndcard;
CREATE TABLE glpi_device_sndcard (
ID SERIAL PRIMARY KEY,
designation varchar(120) NOT NULL,
type varchar(100) NOT NULL,
comment TEXT NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
specif_default varchar(250) NOT NULL,
);
INSERT INTO glpi_device_sndcard VALUES ('1','Soundblaster 128 PCI','','','0','');
INSERT INTO glpi_device_sndcard VALUES ('2','Soundblaster 16 PnP','','','0','');
INSERT INTO glpi_device_sndcard VALUES ('3','integrated','','','0','');
-- Dump table glpi_doc_device
-- DROP TABLE IF EXISTS glpi_doc_device;
CREATE TABLE glpi_doc_device (
ID SERIAL PRIMARY KEY,
FK_doc INT4 DEFAULT '0' NOT NULL,
FK_device INT4 DEFAULT '0' NOT NULL,
device_type INT2 DEFAULT '0' NOT NULL,
);
-- Dump table glpi_docs
-- DROP TABLE IF EXISTS glpi_docs;
CREATE TABLE glpi_docs (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
filename varchar(255) NOT NULL,
rubrique INT4 DEFAULT '0' NOT NULL,
mime varchar(30) NOT NULL,
date_mod TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
comment TEXT NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
link varchar(255) NOT NULL,
);
-- Dump table glpi_dropdown_contact_type
-- DROP TABLE IF EXISTS glpi_dropdown_contact_type;
CREATE TABLE glpi_dropdown_contact_type (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
);
INSERT INTO glpi_dropdown_contact_type VALUES ('1','Technicien');
INSERT INTO glpi_dropdown_contact_type VALUES ('2','Commercial');
-- Dump table glpi_dropdown_enttype
-- DROP TABLE IF EXISTS glpi_dropdown_enttype;
CREATE TABLE glpi_dropdown_enttype (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
);
-- Dump table glpi_dropdown_firmware
-- DROP TABLE IF EXISTS glpi_dropdown_firmware;
CREATE TABLE glpi_dropdown_firmware (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
);
-- Dump table glpi_dropdown_iface
-- DROP TABLE IF EXISTS glpi_dropdown_iface;
CREATE TABLE glpi_dropdown_iface (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
INSERT INTO glpi_dropdown_iface VALUES ('1','10Mbps Ethernet (UTP)');
INSERT INTO glpi_dropdown_iface VALUES ('2','100Mbps Ethernet (UTP)');
INSERT INTO glpi_dropdown_iface VALUES ('3','100Base FL');
INSERT INTO glpi_dropdown_iface VALUES ('4','100Mbps FDDI');
INSERT INTO glpi_dropdown_iface VALUES ('5','Frame Relay');
INSERT INTO glpi_dropdown_iface VALUES ('6','ISDN');
INSERT INTO glpi_dropdown_iface VALUES ('7','T1/E1 +');
INSERT INTO glpi_dropdown_iface VALUES ('8','Serial Link');
-- Dump table glpi_dropdown_kbcategories
-- DROP TABLE IF EXISTS glpi_dropdown_kbcategories;
CREATE TABLE glpi_dropdown_kbcategories (
ID SERIAL PRIMARY KEY,
parentID INT4 DEFAULT '0' NOT NULL,
name varchar(255) NOT NULL,
);
-- Dump table glpi_dropdown_locations
-- DROP TABLE IF EXISTS glpi_dropdown_locations;
CREATE TABLE glpi_dropdown_locations (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
parentID INT4 DEFAULT '0' NOT NULL,
);
INSERT INTO glpi_dropdown_locations VALUES ('1','1 ier etage','0');
INSERT INTO glpi_dropdown_locations VALUES ('2','2nd etage','0');
-- Dump table glpi_dropdown_netpoint
-- DROP TABLE IF EXISTS glpi_dropdown_netpoint;
CREATE TABLE glpi_dropdown_netpoint (
ID SERIAL PRIMARY KEY,
location INT4 DEFAULT '0' NOT NULL,
name varchar(255) NOT NULL,
);
-- Dump table glpi_dropdown_os
-- DROP TABLE IF EXISTS glpi_dropdown_os;
CREATE TABLE glpi_dropdown_os (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
INSERT INTO glpi_dropdown_os VALUES ('1','Windows 2000 - SP2');
INSERT INTO glpi_dropdown_os VALUES ('2','Linux (Redhat 6.2)');
INSERT INTO glpi_dropdown_os VALUES ('3','Linux (Slackware 7)');
INSERT INTO glpi_dropdown_os VALUES ('4','Solaris');
INSERT INTO glpi_dropdown_os VALUES ('5','Windows NT 4.0');
INSERT INTO glpi_dropdown_os VALUES ('6','Windows 95a');
INSERT INTO glpi_dropdown_os VALUES ('7','Other');
INSERT INTO glpi_dropdown_os VALUES ('8','Windows 98');
INSERT INTO glpi_dropdown_os VALUES ('9','MacOS - 9');
INSERT INTO glpi_dropdown_os VALUES ('10','Windows 95 OSR2');
INSERT INTO glpi_dropdown_os VALUES ('11','Windows 98 SR2');
INSERT INTO glpi_dropdown_os VALUES ('12','Debian woody 3.0');
INSERT INTO glpi_dropdown_os VALUES ('13','Windows NT 4.0 - SP3');
-- Dump table glpi_dropdown_rubdocs
-- DROP TABLE IF EXISTS glpi_dropdown_rubdocs;
CREATE TABLE glpi_dropdown_rubdocs (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
-- Dump table glpi_dropdown_state
-- DROP TABLE IF EXISTS glpi_dropdown_state;
CREATE TABLE glpi_dropdown_state (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
-- Dump table glpi_dropdown_tracking_category
-- DROP TABLE IF EXISTS glpi_dropdown_tracking_category;
CREATE TABLE glpi_dropdown_tracking_category (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
-- Dump table glpi_enterprises
-- DROP TABLE IF EXISTS glpi_enterprises;
CREATE TABLE glpi_enterprises (
ID SERIAL PRIMARY KEY,
name varchar(50) NOT NULL,
type INT4 DEFAULT '0' NOT NULL,
address TEXT NOT NULL,
website varchar(100) NOT NULL,
phonenumber varchar(20) NOT NULL,
comments TEXT NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
fax varchar(255) NOT NULL,
);
-- Dump table glpi_event_log
-- DROP TABLE IF EXISTS glpi_event_log;
CREATE TABLE glpi_event_log (
ID SERIAL PRIMARY KEY,
item INT4 DEFAULT '0' NOT NULL,
itemtype varchar(20) NOT NULL,
DATE TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
service varchar(20),
level INT2 DEFAULT '0' NOT NULL,
message TEXT NOT NULL,
);
INSERT INTO glpi_event_log VALUES ('366','-1','system','2005-04-18 18:14:42','login','3','glpi logged in.');
INSERT INTO glpi_event_log VALUES ('367','-1','system','2005-04-20 09:16:16','login','1','failed login: post-only');
INSERT INTO glpi_event_log VALUES ('368','-1','system','2005-04-20 09:16:21','login','1','failed login: normal');
INSERT INTO glpi_event_log VALUES ('369','-1','system','2005-04-20 09:16:30','login','1','failed login: post-only');
INSERT INTO glpi_event_log VALUES ('370','-1','system','2005-04-20 09:16:34','login','3','glpi logged in.');
INSERT INTO glpi_event_log VALUES ('371','0','users','2005-04-20 09:17:18','setup','5','glpi updated user post-only.');
INSERT INTO glpi_event_log VALUES ('372','0','users','2005-04-20 09:17:36','setup','5','glpi updated user glpi.');
INSERT INTO glpi_event_log VALUES ('373','0','users','2005-04-20 09:17:44','setup','5','glpi updated user normal.');
INSERT INTO glpi_event_log VALUES ('374','0','users','2005-04-20 09:18:33','setup','5','glpi updated user tech.');
INSERT INTO glpi_event_log VALUES ('375','0','users','2005-04-20 09:18:43','setup','5','glpi updated user post-only.');
INSERT INTO glpi_event_log VALUES ('376','0','users','2005-04-20 09:19:04','setup','5','glpi updated user post-only.');
INSERT INTO glpi_event_log VALUES ('377','-1','system','2005-04-20 09:19:10','login','3','post-only logged in.');
INSERT INTO glpi_event_log VALUES ('378','-1','system','2005-04-20 09:19:28','login','3','glpi logged in.');
INSERT INTO glpi_event_log VALUES ('379','2','Peripherals','2005-04-20 09:20:27','inventory','4','glpi purge item.');
INSERT INTO glpi_event_log VALUES ('380','-1','system','2005-05-04 01:08:31','login','3','glpi logged in.');
-- Dump table glpi_followups
-- DROP TABLE IF EXISTS glpi_followups;
CREATE TABLE glpi_followups (
ID SERIAL PRIMARY KEY,
tracking INT4,
DATE TIMESTAMP,
author varchar(200),
contents TEXT,
);
INSERT INTO glpi_followups VALUES ('1','1','2003-09-18 00:53:35','tech','J\'ai été voir, je pense que la carte mere a grillé.');
INSERT INTO glpi_followups VALUES ('2','1','2003-09-18 00:54:06','tech','L\'alimentation est foutue, je vais tester la carte mere pour voir si elle est recuperable');
-- Dump table glpi_infocoms
-- DROP TABLE IF EXISTS glpi_infocoms;
CREATE TABLE glpi_infocoms (
ID SERIAL PRIMARY KEY,
FK_device INT4 DEFAULT '0' NOT NULL,
device_type INT2 DEFAULT '0' NOT NULL,
buy_date DATE DEFAULT '0000-00-00' NOT NULL,
use_date DATE DEFAULT '0000-00-00' NOT NULL,
warranty_duration INT2 DEFAULT '0' NOT NULL,
warranty_info varchar(255) NOT NULL,
FK_enterprise INT4,
num_commande varchar(50) NOT NULL,
bon_livraison varchar(50) NOT NULL,
num_immo varchar(50) NOT NULL,
value float DEFAULT '0' NOT NULL,
warranty_value float,
amort_time INT2 DEFAULT '0' NOT NULL,
amort_type varchar(20) NOT NULL,
amort_coeff float DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
facture varchar(255) NOT NULL,
);
INSERT INTO glpi_infocoms VALUES ('1','18','1','2001-09-24','0000-00-00','12','',NULL,'','','','0',NULL,'0','','0','','');
-- Dump table glpi_inst_software
-- DROP TABLE IF EXISTS glpi_inst_software;
CREATE TABLE glpi_inst_software (
ID SERIAL PRIMARY KEY,
cID INT4 DEFAULT '0' NOT NULL,
license INT4 DEFAULT '0' NOT NULL,
);
INSERT INTO glpi_inst_software VALUES ('2','10','7');
INSERT INTO glpi_inst_software VALUES ('1','8','8');
INSERT INTO glpi_inst_software VALUES ('3','8','6');
INSERT INTO glpi_inst_software VALUES ('4','8','9');
-- Dump table glpi_kbitems
-- DROP TABLE IF EXISTS glpi_kbitems;
CREATE TABLE glpi_kbitems (
ID SERIAL PRIMARY KEY,
categoryID INT4 DEFAULT '0' NOT NULL,
question TEXT NOT NULL,
answer TEXT NOT NULL,
faq varchar(5) CHECK (faq IN ('yes','no')) DEFAULT 'no' NOT NULL,
);
-- Dump table glpi_licenses
-- DROP TABLE IF EXISTS glpi_licenses;
CREATE TABLE glpi_licenses (
ID int(15) NOT NULL auto_increment,
sID int(15) DEFAULT '0' NOT NULL,
serial varchar(255) NOT NULL,
expire DATE,
oem BOOL DEFAULT 'N' NOT NULL,
oem_computer INT4 DEFAULT '0' NOT NULL,
buy BOOL DEFAULT 'Y' NOT NULL,
);
INSERT INTO glpi_licenses VALUES ('7','4','12-aa-asd-12-aa',NULL,'N','0','Y');
INSERT INTO glpi_licenses VALUES ('6','4','asd-asdf-asdf-12',NULL,'N','0','Y');
INSERT INTO glpi_licenses VALUES ('4','4','au-23-as-23-cd',NULL,'N','0','Y');
INSERT INTO glpi_licenses VALUES ('5','4','qw-as-23-0k-23-dg',NULL,'N','0','Y');
INSERT INTO glpi_licenses VALUES ('8','3','free',NULL,'N','0','Y');
INSERT INTO glpi_licenses VALUES ('9','5','free',NULL,'N','0','Y');
-- Dump table glpi_monitors
-- DROP TABLE IF EXISTS glpi_monitors;
CREATE TABLE glpi_monitors (
ID int(10) NOT NULL auto_increment,
name varchar(255) NOT NULL,
date_mod TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
contact varchar(255) NOT NULL,
contact_num varchar(255) NOT NULL,
tech_num INT4 DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
serial varchar(255) NOT NULL,
otherserial varchar(255) NOT NULL,
size int(3) DEFAULT '0' NOT NULL,
flags_micro INT2 DEFAULT '0' NOT NULL,
flags_speaker INT2 DEFAULT '0' NOT NULL,
flags_subd INT2 DEFAULT '0' NOT NULL,
flags_bnc INT2 DEFAULT '0' NOT NULL,
location INT4,
type INT4,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
is_template INT DEFAULT '0' NOT NULL CHECK (is_template IN (0,1)),
tplname varchar(255),
);
INSERT INTO glpi_monitors VALUES ('3','nokia 20\'','2003-09-18 00:14:14','','','0','Ecran infographiste','','','20','1','1','1','0','1','1','0','N','0',NULL);
INSERT INTO glpi_monitors VALUES ('2','Sony 19\'','2003-09-18 00:14:50','','','0','ecran documentation','','','19','0','0','1','1','1','3','0','N','0',NULL);
INSERT INTO glpi_monitors VALUES ('4','','0000-00-00 00:00:00','','','0','','','','0','0','0','0','0',NULL,NULL,'0','N','1','Blank Template');
-- Dump table glpi_networking
-- DROP TABLE IF EXISTS glpi_networking;
CREATE TABLE glpi_networking (
ID SERIAL PRIMARY KEY,
name varchar(30) NOT NULL,
ram varchar(10) NOT NULL,
serial varchar(50) NOT NULL,
otherserial varchar(50) NOT NULL,
contact varchar(30) NOT NULL,
contact_num varchar(30) NOT NULL,
tech_num INT4 DEFAULT '0' NOT NULL,
date_mod TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
comments TEXT NOT NULL,
location INT4,
type INT4,
firmware INT4,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
is_template INT DEFAULT '0' NOT NULL CHECK (is_template IN (0,1)),
tplname varchar(255),
ifmac varchar(30) NOT NULL,
ifaddr varchar(30) NOT NULL,
);
INSERT INTO glpi_networking VALUES ('9','Dlink 450','','4586-puis-kioe','','','','0','0000-00-00 00:00:00','','1','1',NULL,'0','N','0',NULL,'','');
INSERT INTO glpi_networking VALUES ('10','','','','','','','0','0000-00-00 00:00:00','',NULL,NULL,NULL,'0','N','1','Blank Template','','');
-- Dump table glpi_networking_ports
-- DROP TABLE IF EXISTS glpi_networking_ports;
CREATE TABLE glpi_networking_ports (
ID SERIAL PRIMARY KEY,
on_device INT4 DEFAULT '0' NOT NULL,
device_type INT2 DEFAULT '0' NOT NULL,
logical_number INT4 DEFAULT '0' NOT NULL,
name char(30) NOT NULL,
ifaddr char(30) NOT NULL,
ifmac char(30) NOT NULL,
iface INT4,
netpoint INT4,
);
INSERT INTO glpi_networking_ports VALUES ('1','8','1','1','3Com','10.10.0.26','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('2','10','1','1','3com','10.10.0.27','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('3','15','1','1','Generic','10.10.0.28','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('4','18','1','1','3Com','10.10.0.29','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('5','9','2','1','Dlink port','10.10.0.1','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('6','9','2','2','Dlink port','10.10.0.1','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('7','9','2','3','Dlink port','10.10.0.1','','2',NULL);
INSERT INTO glpi_networking_ports VALUES ('8','10','2','0','','','','5',NULL);
-- Dump table glpi_networking_wire
-- DROP TABLE IF EXISTS glpi_networking_wire;
CREATE TABLE glpi_networking_wire (
ID SERIAL PRIMARY KEY,
end1 INT4 DEFAULT '0' NOT NULL,
end2 INT4 DEFAULT '0' NOT NULL,
);
INSERT INTO glpi_networking_wire VALUES ('1','5','1');
INSERT INTO glpi_networking_wire VALUES ('2','6','2');
INSERT INTO glpi_networking_wire VALUES ('3','7','3');
-- Dump table glpi_peripherals
-- DROP TABLE IF EXISTS glpi_peripherals;
CREATE TABLE glpi_peripherals (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
date_mod TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
contact varchar(255) NOT NULL,
contact_num varchar(255) NOT NULL,
tech_num INT4 DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
serial varchar(255) NOT NULL,
otherserial varchar(255) NOT NULL,
location INT4 DEFAULT '0' NOT NULL,
type INT4 DEFAULT '0' NOT NULL,
brand varchar(255) NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
is_template INT DEFAULT '0' NOT NULL CHECK (is_template IN (0,1)),
tplname varchar(255),
);
INSERT INTO glpi_peripherals VALUES ('1','','0000-00-00 00:00:00','','','0','','','','0','0','','0','N','1','Blank Template');
-- Dump table glpi_prefs
-- DROP TABLE IF EXISTS glpi_prefs;
CREATE TABLE glpi_prefs (
username varchar(80) NOT NULL,
tracking_order enum('no','yes') DEFAULT 'no' NOT NULL,
language varchar(255) NOT NULL,
ID SERIAL PRIMARY KEY,
);
INSERT INTO glpi_prefs VALUES ('glpi','yes','french','1');
INSERT INTO glpi_prefs VALUES ('Helpdesk','no','french','2');
INSERT INTO glpi_prefs VALUES ('normal','','english','3');
INSERT INTO glpi_prefs VALUES ('tech','yes','french','4');
INSERT INTO glpi_prefs VALUES ('post-only','','english','5');
-- Dump table glpi_printers
-- DROP TABLE IF EXISTS glpi_printers;
CREATE TABLE glpi_printers (
ID int(10) NOT NULL auto_increment,
name varchar(255) NOT NULL,
date_mod TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
contact varchar(255) NOT NULL,
contact_num varchar(255) NOT NULL,
tech_num INT4 DEFAULT '0' NOT NULL,
serial varchar(255) NOT NULL,
otherserial varchar(255) NOT NULL,
flags_serial INT2 DEFAULT '0' NOT NULL,
flags_par INT2 DEFAULT '0' NOT NULL,
flags_usb INT2 DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
ramSize varchar(6) NOT NULL,
location INT4,
type INT4,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
is_template INT DEFAULT '0' NOT NULL CHECK (is_template IN (0,1)),
tplname varchar(255),
);
INSERT INTO glpi_printers VALUES ('1','HP laser','2003-09-18 00:12:43','','','0','hp-jsgsj-658','','0','1','0','Imprimante bureau du directeur','','1','1','0','N','0',NULL);
INSERT INTO glpi_printers VALUES ('2','HP deskjet','2003-09-18 00:13:11','','','0','45dskjs-ds','','0','1','0','Imprimante documentation','','2','3','0','N','0',NULL);
INSERT INTO glpi_printers VALUES ('3','','0000-00-00 00:00:00','','','0','','','0','0','0','','',NULL,NULL,'0','N','1','Blank Template');
-- Dump table glpi_reservation_item
-- DROP TABLE IF EXISTS glpi_reservation_item;
CREATE TABLE glpi_reservation_item (
ID SERIAL PRIMARY KEY,
device_type INT2 DEFAULT '0' NOT NULL,
id_device INT4 DEFAULT '0' NOT NULL,
comments TEXT NOT NULL,
);
INSERT INTO glpi_reservation_item VALUES ('1','1','10','Pile Poil');
-- Dump table glpi_reservation_resa
-- DROP TABLE IF EXISTS glpi_reservation_resa;
CREATE TABLE glpi_reservation_resa (
ID bigint(20) NOT NULL auto_increment,
id_item INT4 DEFAULT '0' NOT NULL,
begin TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
end TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
id_user INT4 DEFAULT '0' NOT NULL,
comment varchar(255) NOT NULL,
);
-- Dump table glpi_software
-- DROP TABLE IF EXISTS glpi_software;
CREATE TABLE glpi_software (
ID SERIAL PRIMARY KEY,
name varchar(200) NOT NULL,
version varchar(20) NOT NULL,
comments TEXT,
location INT4,
tech_num INT4 DEFAULT '0' NOT NULL,
platform INT4,
is_update enum('N','Y') DEFAULT 'N' NOT NULL,
update_software INT4 DEFAULT '-1' NOT NULL,
FK_glpi_enterprise INT4 DEFAULT '0' NOT NULL,
deleted BOOL DEFAULT 'N' NOT NULL,
is_template INT DEFAULT '0' NOT NULL CHECK (is_template IN (0,1)),
tplname varchar(255),
date_mod TIMESTAMP,
);
INSERT INTO glpi_software VALUES ('3','Acrobat PDF Viewer','4',NULL,NULL,'0','5','N','-1','0','N','0',NULL,NULL);
INSERT INTO glpi_software VALUES ('4','MS Windows NT','4.0',NULL,NULL,'0','5','N','-1','0','N','0',NULL,NULL);
INSERT INTO glpi_software VALUES ('5','Latex','6.2','Latex','1','0','2','N','-1','0','N','0',NULL,NULL);
INSERT INTO glpi_software VALUES ('6','','',NULL,NULL,'0',NULL,'N','-1','0','N','1','Blank Template',NULL);
-- Dump table glpi_state_item
-- DROP TABLE IF EXISTS glpi_state_item;
CREATE TABLE glpi_state_item (
ID SERIAL PRIMARY KEY,
device_type INT2 DEFAULT '0' NOT NULL,
id_device INT4 DEFAULT '0' NOT NULL,
state INT4 DEFAULT '1',
);
INSERT INTO glpi_state_item VALUES ('1','1','8','1');
-- Dump table glpi_tracking
-- DROP TABLE IF EXISTS glpi_tracking;
CREATE TABLE glpi_tracking (
ID SERIAL PRIMARY KEY,
DATE TIMESTAMP,
closedate TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
status enum('new','old'),
author varchar(200),
assign varchar(200),
device_type INT4 DEFAULT '1' NOT NULL,
computer INT4,
contents TEXT,
priority INT2 DEFAULT '1' NOT NULL,
is_group enum('no','yes') DEFAULT 'no' NOT NULL,
uemail varchar(100),
emailupdates varchar(4),
realtime float DEFAULT '0' NOT NULL,
category INT4,
);
INSERT INTO glpi_tracking VALUES ('1','2003-09-18 00:46:40','2003-09-18 00:54:43','old','Helpdesk','tech','1','8','Mon ordinateur ne s\'allume plus, et il ya des bruits byzarres','3','no','','','0',NULL);
INSERT INTO glpi_tracking VALUES ('2','2003-09-18 00:48:19','0000-00-00 00:00:00','new','Helpdesk','tech','1','10','Un message en anglais s\'affiche, je n\'y comprend rien, je n\'ose plus toucher à rien de peur de tout casser.
Venez vite !!!!','4','no','','','0',NULL);
INSERT INTO glpi_tracking VALUES ('3','2003-09-18 00:49:29','0000-00-00 00:00:00','new','Helpdesk','tech','1','18','Ma souris se bloque sans arret, elle defile mal sur l\'ecran et elle glisse tres mal sur le tapis de souris.','3','no','','','0',NULL);
-- Dump table glpi_type_computers
-- DROP TABLE IF EXISTS glpi_type_computers;
CREATE TABLE glpi_type_computers (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
INSERT INTO glpi_type_computers VALUES ('1','Generic x86 PC');
INSERT INTO glpi_type_computers VALUES ('2','PowerMac G4');
INSERT INTO glpi_type_computers VALUES ('3','iMac 2nd Generation');
INSERT INTO glpi_type_computers VALUES ('4','PowerMac G3');
-- Dump table glpi_type_docs
-- DROP TABLE IF EXISTS glpi_type_docs;
CREATE TABLE glpi_type_docs (
ID SERIAL PRIMARY KEY,
name varchar(255) NOT NULL,
ext varchar(10) NOT NULL,
icon varchar(255) NOT NULL,
mime varchar(100) NOT NULL,
upload BOOL DEFAULT 'Y' NOT NULL,
date_mod TIMESTAMP,
);
INSERT INTO glpi_type_docs VALUES ('1','JPEG','jpg','jpg-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('2','PNG','png','png-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('3','GIF','gif','gif-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('4','BMP','bmp','bmp-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('5','Photoshop','psd','psd-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('6','TIFF','tif','tif-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('7','AIFF','aiff','aiff-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('8','Windows Media','asf','asf-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('9','Windows Media','avi','avi-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('44','C source','c','','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('27','RealAudio','rm','rm-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('16','Midi','mid','mid-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('17','QuickTime','mov','mov-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('18','MP3','mp3','mp3-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('19','MPEG','mpg','mpg-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('20','Ogg Vorbis','ogg','ogg-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('24','QuickTime','qt','qt-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('10','BZip','bz2','bz2-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('25','RealAudio','ra','ra-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('26','RealAudio','ram','ram-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('11','Word','doc','doc-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('12','DjVu','djvu','','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('42','MNG','mng','','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('13','PostScript','eps','ps-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('14','GZ','gz','gz-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('37','WAV','wav','wav-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('15','HTML','html','html-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('34','Flash','swf','','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('21','PDF','pdf','pdf-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('22','PowerPoint','ppt','ppt-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('23','PostScript','ps','ps-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('40','Windows Media','wmv','','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('28','RTF','rtf','rtf-dist.png','','Y','2004-12-13 19:47:21');
INSERT INTO glpi_type_docs VALUES ('29','StarOffice','sdd','sdd-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('30','StarOffice','sdw','sdw-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('31','Stuffit','sit','sit-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('43','Adobe Illustrator','ai','ai-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('32','OpenOffice Impress','sxi','sxi-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('33','OpenOffice','sxw','sxw-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('46','DVI','dvi','dvi-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('35','TGZ','tgz','tgz-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('36','TEXTe','txt','txt-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('49','RedHat/Mandrake/SuSE','rpm','rpm-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('38','Excel','xls','xls-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('39','XML','xml','xml-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('41','Zip','zip','zip-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('45','Debian','deb','deb-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('47','C header','h','','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('48','Pascal','pas','','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('50','OpenOffice Calc','sxc','sxc-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('51','LaTeX','tex','tex-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('52','GIMP multi-layer','xcf','xcf-dist.png','','Y','2004-12-13 19:47:22');
INSERT INTO glpi_type_docs VALUES ('53','JPEG','jpeg','jpg-dist.png','','Y','2005-03-07 22:23:17');
-- Dump table glpi_type_monitors
-- DROP TABLE IF EXISTS glpi_type_monitors;
CREATE TABLE glpi_type_monitors (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
INSERT INTO glpi_type_monitors VALUES ('1','Nokia 445Xav');
INSERT INTO glpi_type_monitors VALUES ('2','Sony 200GDM');
INSERT INTO glpi_type_monitors VALUES ('3','Sony 200sf');
INSERT INTO glpi_type_monitors VALUES ('4','integrated');
-- Dump table glpi_type_networking
-- DROP TABLE IF EXISTS glpi_type_networking;
CREATE TABLE glpi_type_networking (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
INSERT INTO glpi_type_networking VALUES ('1','Dlink Switch');
-- Dump table glpi_type_peripherals
-- DROP TABLE IF EXISTS glpi_type_peripherals;
CREATE TABLE glpi_type_peripherals (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
-- Dump table glpi_type_printers
-- DROP TABLE IF EXISTS glpi_type_printers;
CREATE TABLE glpi_type_printers (
ID SERIAL PRIMARY KEY,
name varchar(255),
);
INSERT INTO glpi_type_printers VALUES ('1','HP Laserjet 4050N');
INSERT INTO glpi_type_printers VALUES ('2','HP Laserjet 4+');
INSERT INTO glpi_type_printers VALUES ('3','HP Deskjet 850c');
-- Dump table glpi_users
-- DROP TABLE IF EXISTS glpi_users;
CREATE TABLE glpi_users (
ID SERIAL PRIMARY KEY,
name varchar(80) NOT NULL,
password varchar(80) NOT NULL,
password_md5 varchar(80) NOT NULL,
email varchar(80) NOT NULL,
phone varchar(100),
type enum('normal','admin','post-only','super-admin') DEFAULT 'normal' NOT NULL,
realname varchar(255) NOT NULL,
can_assign_job enum('yes','no') DEFAULT 'no' NOT NULL,
location INT4,
);
INSERT INTO glpi_users VALUES ('1','Helpdesk','14e43c2d31dcbdd1','','',NULL,'post-only','Helpdesk Injector','no',NULL);
INSERT INTO glpi_users VALUES ('2','glpi','*64B4BB8F2A8C2F41C639DBC894D2759330199470','41ece51526515624ff89973668497d00','','','super-admin','','yes','2');
INSERT INTO glpi_users VALUES ('3','post-only','*5683D7F638D6598D057638B1957F194E4CA974FB','3177926a7314de24680a9938aaa97703','','','post-only','','no','1');
INSERT INTO glpi_users VALUES ('4','tech','*B09F1B2C210DEEA69C662977CC69C6C461965B09','d9f9133fb120cd6096870bc2b496805b','','','super-admin','','yes','2');
INSERT INTO glpi_users VALUES ('5','normal','*F3F91B23FC1DB728B49B1F22DEE3D7A839E10F0E','fea087517c26fadd409bd4b9dc642555','','','normal','','no','1');
