1 create database glpi;
2 use glpi;
4 CREATE TABLE `glpi_cartridges` (
5 `ID` int(11) NOT NULL auto_increment,
6 `FK_glpi_cartridges_type` int(11) NOT NULL default '0',
7 `FK_glpi_printers` int(11) NOT NULL default '0',
8 `date_in` date default NULL,
9 `date_use` date default NULL,
10 `date_out` date default NULL,
11 `pages` int(11) NOT NULL default '0',
12 PRIMARY KEY (`ID`),
13 KEY `FK_glpi_cartridges_type` (`FK_glpi_cartridges_type`),
14 KEY `FK_glpi_printers` (`FK_glpi_printers`)
15 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
17 INSERT INTO `glpi_cartridges` (`ID`, `FK_glpi_cartridges_type`, `FK_glpi_printers`, `date_in`, `date_use`, `date_out`, `pages`) VALUES
18 (5, 5, 5, '2006-09-29', '2006-09-29', NULL, 0),
19 (4, 5, 5, '2006-09-29', '2006-09-29', NULL, 0);
22 CREATE TABLE `glpi_cartridges_assoc` (
23 `ID` int(11) NOT NULL auto_increment,
24 `FK_glpi_cartridges_type` int(11) NOT NULL default '0',
25 `FK_glpi_type_printer` int(11) NOT NULL default '0',
26 PRIMARY KEY (`ID`),
27 UNIQUE KEY `FK_glpi_type_printer` (`FK_glpi_type_printer`,`FK_glpi_cartridges_type`),
28 KEY `FK_glpi_cartridges_type` (`FK_glpi_cartridges_type`),
29 KEY `FK_glpi_type_printer_2` (`FK_glpi_type_printer`)
30 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
33 INSERT INTO `glpi_cartridges_assoc` (`ID`, `FK_glpi_cartridges_type`, `FK_glpi_type_printer`) VALUES
34 (1, 1, 1),
35 (2, 2, 5),
36 (3, 2, 1),
37 (4, 3, 13),
38 (5, 4, 13),
39 (6, 5, 11),
40 (7, 5, 10),
41 (8, 5, 5),
42 (9, 5, 12),
43 (10, 5, 2),
44 (11, 5, 14),
45 (12, 5, 3);
49 CREATE TABLE `glpi_cartridges_type` (
50 `ID` int(11) NOT NULL auto_increment,
51 `name` varchar(255) NOT NULL default '',
52 `ref` varchar(255) NOT NULL default '',
53 `location` int(11) NOT NULL default '0',
54 `type` tinyint(4) NOT NULL default '0',
55 `FK_glpi_enterprise` int(11) NOT NULL default '0',
56 `tech_num` int(11) default '0',
57 `deleted` enum('Y','N') NOT NULL default 'N',
58 `comments` text NOT NULL,
59 `alarm` tinyint(4) NOT NULL default '10',
60 PRIMARY KEY (`ID`),
61 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
62 KEY `tech_num` (`tech_num`),
63 KEY `deleted` (`deleted`)
64 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
67 INSERT INTO `glpi_cartridges_type` (`ID`, `name`, `ref`, `location`, `type`, `FK_glpi_enterprise`, `tech_num`, `deleted`, `comments`, `alarm`) VALUES
68 (1, 'TestPatrone', '', 0, 1, 8, 0, '', '', 0),
69 (2, 'HP_deskjet_7100C', '', 0, 4, 8, 0, '', 'None', 0),
70 (3, 'teseter', '', 0, 3, 12, 0, '', '', 0),
71 (4, 'teseter2', '', 0, 3, 12, 0, '', '', 0),
72 (5, 'Epson Stylus Nuclear Color', '', 0, 3, 12, 0, '', 'Uranium green.\r\n', 0);
76 CREATE TABLE `glpi_computer_device` (
77 `ID` int(11) NOT NULL auto_increment,
78 `specificity` varchar(250) NOT NULL default '',
79 `device_type` tinyint(4) NOT NULL default '0',
80 `FK_device` int(11) NOT NULL default '0',
81 `FK_computers` int(11) NOT NULL default '0',
82 PRIMARY KEY (`ID`),
83 KEY `device_type` (`device_type`),
84 KEY `device_type_2` (`device_type`,`FK_device`),
85 KEY `FK_computers` (`FK_computers`)
86 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=136 ;
89 INSERT INTO `glpi_computer_device` (`ID`, `specificity`, `device_type`, `FK_device`, `FK_computers`) VALUES
90 (87, '', 1, 1, 1),
91 (92, '', 1, 1, 13),
92 (133, '', 1, 1, 17),
93 (120, '', 1, 1, 23),
94 (122, '', 1, 1, 24),
95 (135, '', 1, 1, 19),
96 (132, '', 1, 1, 29);
100 CREATE TABLE `glpi_computers` (
101 `ID` int(11) NOT NULL auto_increment,
102 `name` varchar(200) NOT NULL default '',
103 `serial` varchar(200) NOT NULL default '',
104 `otherserial` varchar(200) NOT NULL default '',
105 `contact` varchar(90) NOT NULL default '',
106 `contact_num` varchar(90) NOT NULL default '',
107 `tech_num` int(11) NOT NULL default '0',
108 `comments` text NOT NULL,
109 `date_mod` datetime default NULL,
110 `os` int(11) default NULL,
111 `location` int(11) default NULL,
112 `domain` int(11) NOT NULL default '0',
113 `network` int(11) NOT NULL default '0',
114 `model` int(11) default NULL,
115 `type` int(11) default NULL,
116 `is_template` enum('0','1') NOT NULL default '0',
117 `tplname` varchar(200) default NULL,
118 `FK_glpi_enterprise` int(11) NOT NULL default '0',
119 `deleted` enum('Y','N') NOT NULL default 'N',
120 PRIMARY KEY (`ID`),
121 KEY `location` (`location`),
122 KEY `os` (`os`),
123 KEY `type` (`model`),
124 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
125 KEY `deleted` (`deleted`),
126 KEY `is_template` (`is_template`),
127 KEY `date_mod` (`date_mod`),
128 KEY `tech_num` (`tech_num`),
129 KEY `type_2` (`type`)
130 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
133 INSERT INTO `glpi_computers` (`ID`, `name`, `serial`, `otherserial`, `contact`, `contact_num`, `tech_num`, `comments`, `date_mod`, `os`, `location`, `domain`, `network`, `model`, `type`, `is_template`, `tplname`, `FK_glpi_enterprise`, `deleted`) VALUES
134 (1, 'cn=asterisk,ou=servers,ou=systems,dc=gonicus,dc=de', '', '', '', '1', 1, '', '2006-03-08 12:12:04', 5, 0, 0, 0, 0, 27, '0', NULL, 8, 'N'),
135 (4, 'cn=pyramid,ou=terminals,ou=systems,dc=gonicus,dc=de', '', '', '', '', 0, '', '2006-03-08 07:05:07', 5, 0, 0, 0, 0, 21, '0', NULL, 8, 'N'),
136 (5, 'cn=ctu03,ou=phones,ou=systems,dc=gonicus,dc=de', '', '', '', '', 0, '', '2006-02-10 08:58:15', 6, 0, 0, 0, 0, 21, '0', NULL, 8, 'N'),
137 (6, 'cn=fax,ou=servers,ou=systems,dc=gonicus,dc=de', '', '', '', '', 3, '', '2006-03-01 10:04:06', 6, 0, 0, 0, 0, 21, '0', NULL, 12, 'N'),
138 (19, 'cn=cl1--6665,ou=workstations,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '18', 0, '', '2007-01-30 08:03:00', 5, 0, 0, 0, 0, 27, '0', NULL, 16, 'N'),
139 (11, 'cn=vserver-04f,ou=servers,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '', 0, '', '2006-05-12 07:51:32', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
140 (13, 'cn=GetraenkeHalter,ou=netdevices,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '6', 7, 'tester', '2006-06-21 12:34:54', 7, 0, 0, 0, 0, 28, '0', NULL, 16, 'N'),
141 (18, 'cn=cl1--151,ou=workstations,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'tester', '2007-01-30 07:55:33', 18, 0, 0, 0, 0, 18, '0', NULL, 16, 'N'),
142 (16, 'cn=ctu153,ou=phones,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '8', 9, 'Tester für den Comment \\\\\\n<br>\r\ntester', '2006-06-20 09:24:35', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
143 (17, 'cn=cl1--157,ou=workstations,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'asdfasdf \n\r\nasdf', '2007-01-30 07:01:41', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
144 (20, 'cn=vserver-01.intranet.gonicus.de,ou=servers,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'sda', '2007-05-21 06:53:29', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
145 (21, 'cn=vserver-01.intranet.gonicus.de,ou=servers,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'sda', '2007-05-21 06:53:29', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
146 (23, 'cn=kohlenhydrate,ou=servers,ou=systems,ou=keks,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '11', 11, 'eg', '2006-09-29 09:37:30', 7, 0, 0, 0, 0, 26, '0', NULL, 8, 'N'),
147 (24, 'cn=Mineralstoffe,ou=workstations,ou=systems,ou=keks,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'dfsaaaaaaaaaaaaaaaaaaaaaaaaaaa', '2006-10-18 11:21:03', 7, 0, 0, 0, 0, 27, '0', NULL, 16, 'N'),
148 (25, 'cn=Ammoniumcarbonat,ou=phones,ou=systems,ou=keks,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '11', 11, 'asdf', '2006-09-29 10:34:32', 7, 0, 0, 0, 0, 21, '0', NULL, 16, 'N'),
149 (26, 'cn=Kakaomasse,ou=netdevices,ou=systems,ou=keks,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '11', 11, 'ikk', '2006-09-29 10:41:12', 7, 0, 0, 0, 0, 27, '0', NULL, 8, 'N'),
150 (27, 'cn=afs-22,ou=servers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '', 0, '-ö', '2006-11-30 13:31:50', 7, 0, 0, 0, 0, 26, '0', NULL, 16, 'N'),
151 (28, 'cn=Netzwerkkomponente,ou=netdevices,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '11', 0, '', '2006-11-29 14:43:00', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
152 (29, 'cn=vserver-04.intranet.gonicus.de,ou=servers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'asdfasdf', '2006-11-30 12:48:22', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
153 (30, 'cn=okulele,ou=servers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '21', 21, 'No comment', '2007-01-23 14:20:48', 11, 0, 0, 0, 0, 21, '0', NULL, 16, 'N'),
154 (31, 'cn=keksesindlecker45,ou=workstations,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '', 0, 'sdfsdfaasdf', '2007-01-16 08:26:35', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N'),
155 (32, 'cn=phoneTesterAparatz,ou=phones,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '', 0, '', '2007-01-15 08:21:39', 5, 0, 0, 0, 0, 18, '0', NULL, 12, 'N'),
156 (39, 'cn=terminal,ou=terminals,ou=systems,o=Landeshauptstadt München,c=de', '', '', '', '', 0, '', '2007-05-21 07:02:42', 6, 0, 0, 0, 0, 28, '0', NULL, 12, 'N');
160 CREATE TABLE `glpi_config` (
161 `ID` int(11) NOT NULL auto_increment,
162 `ldap_port` varchar(10) NOT NULL default '389',
163 `num_of_events` varchar(200) NOT NULL default '',
164 `jobs_at_login` varchar(200) NOT NULL default '',
165 `sendexpire` varchar(200) NOT NULL default '',
166 `cut` varchar(200) NOT NULL default '',
167 `expire_events` varchar(200) NOT NULL default '',
168 `list_limit` varchar(200) NOT NULL default '',
169 `version` varchar(200) NOT NULL default '',
170 `logotxt` varchar(200) NOT NULL default '',
171 `root_doc` varchar(200) NOT NULL default '',
172 `event_loglevel` varchar(200) NOT NULL default '',
173 `mailing` varchar(200) NOT NULL default '',
174 `imap_auth_server` varchar(200) NOT NULL default '',
175 `imap_host` varchar(200) NOT NULL default '',
176 `ldap_host` varchar(200) NOT NULL default '',
177 `ldap_basedn` varchar(200) NOT NULL default '',
178 `ldap_rootdn` varchar(200) NOT NULL default '',
179 `ldap_pass` varchar(200) NOT NULL default '',
180 `admin_email` varchar(200) NOT NULL default '',
181 `mailing_resa_all_admin` varchar(200) NOT NULL default '0',
182 `mailing_resa_user` varchar(200) NOT NULL default '1',
183 `mailing_resa_admin` varchar(200) NOT NULL default '1',
184 `mailing_signature` varchar(200) NOT NULL default '',
185 `mailing_new_admin` varchar(200) NOT NULL default '',
186 `mailing_followup_admin` varchar(200) NOT NULL default '',
187 `mailing_finish_admin` varchar(200) NOT NULL default '',
188 `mailing_new_all_admin` varchar(200) NOT NULL default '',
189 `mailing_followup_all_admin` varchar(200) NOT NULL default '',
190 `mailing_finish_all_admin` varchar(200) NOT NULL default '',
191 `mailing_new_all_normal` varchar(200) NOT NULL default '',
192 `mailing_followup_all_normal` varchar(200) NOT NULL default '',
193 `mailing_finish_all_normal` varchar(200) NOT NULL default '',
194 `mailing_new_attrib` varchar(200) NOT NULL default '',
195 `mailing_followup_attrib` varchar(200) NOT NULL default '',
196 `mailing_finish_attrib` varchar(200) NOT NULL default '',
197 `mailing_new_user` varchar(200) NOT NULL default '',
198 `mailing_followup_user` varchar(200) NOT NULL default '',
199 `mailing_finish_user` varchar(200) NOT NULL default '',
200 `ldap_field_name` varchar(200) NOT NULL default '',
201 `ldap_field_email` varchar(200) NOT NULL default '',
202 `ldap_field_location` varchar(200) NOT NULL default '',
203 `ldap_field_realname` varchar(200) NOT NULL default '',
204 `ldap_field_phone` varchar(200) NOT NULL default '',
205 `ldap_condition` varchar(255) NOT NULL default '',
206 `permit_helpdesk` varchar(200) NOT NULL default '',
207 `default_language` varchar(255) NOT NULL default 'french',
208 `priority_1` varchar(200) NOT NULL default '#fff2f2',
209 `priority_2` varchar(200) NOT NULL default '#ffe0e0',
210 `priority_3` varchar(200) NOT NULL default '#ffcece',
211 `priority_4` varchar(200) NOT NULL default '#ffbfbf',
212 `priority_5` varchar(200) NOT NULL default '#ffadad',
213 `date_fiscale` date NOT NULL default '2005-12-31',
214 `cartridges_alarm` int(11) NOT NULL default '10',
215 `cas_host` varchar(255) NOT NULL default '',
216 `cas_port` varchar(255) NOT NULL default '',
217 `cas_uri` varchar(255) NOT NULL default '',
218 `planning_begin` time NOT NULL default '08:00:00',
219 `planning_end` time NOT NULL default '20:00:00',
220 `utf8_conv` int(11) NOT NULL default '0',
221 `auto_assign` enum('0','1') NOT NULL default '0',
222 PRIMARY KEY (`ID`)
223 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
226 INSERT INTO `glpi_config` (`ID`, `ldap_port`, `num_of_events`, `jobs_at_login`, `sendexpire`, `cut`, `expire_events`, `list_limit`, `version`, `logotxt`, `root_doc`, `event_loglevel`, `mailing`, `imap_auth_server`, `imap_host`, `ldap_host`, `ldap_basedn`, `ldap_rootdn`, `ldap_pass`, `admin_email`, `mailing_resa_all_admin`, `mailing_resa_user`, `mailing_resa_admin`, `mailing_signature`, `mailing_new_admin`, `mailing_followup_admin`, `mailing_finish_admin`, `mailing_new_all_admin`, `mailing_followup_all_admin`, `mailing_finish_all_admin`, `mailing_new_all_normal`, `mailing_followup_all_normal`, `mailing_finish_all_normal`, `mailing_new_attrib`, `mailing_followup_attrib`, `mailing_finish_attrib`, `mailing_new_user`, `mailing_followup_user`, `mailing_finish_user`, `ldap_field_name`, `ldap_field_email`, `ldap_field_location`, `ldap_field_realname`, `ldap_field_phone`, `ldap_condition`, `permit_helpdesk`, `default_language`, `priority_1`, `priority_2`, `priority_3`, `priority_4`, `priority_5`, `date_fiscale`, `cartridges_alarm`, `cas_host`, `cas_port`, `cas_uri`, `planning_begin`, `planning_end`, `utf8_conv`, `auto_assign`) VALUES
227 (1, '389', '10', '1', '1', '80', '30', '15', ' 0.6', 'GLPI powered by indepnet', '/glpi', '5', '0', '', '', '', '', '', '', 'admsys@xxxxx.fr', '0', '1', '1', 'SIGNATURE', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', 'uid', 'mail', 'physicaldeliveryofficename', 'cn', 'telephonenumber', '', '', 'english', '#fff2f2', '#ffe0e0', '#ffcece', '#ffbfbf', '#ffadad', '2005-12-31', 10, '', '', '', '08:00:00', '20:00:00', 0, '0');
231 CREATE TABLE `glpi_connect_wire` (
232 `ID` int(11) NOT NULL auto_increment,
233 `end1` int(11) NOT NULL default '0',
234 `end2` int(11) NOT NULL default '0',
235 `type` tinyint(4) NOT NULL default '0',
236 PRIMARY KEY (`ID`),
237 UNIQUE KEY `end1_1` (`end1`,`end2`,`type`),
238 KEY `end1` (`end1`),
239 KEY `end2` (`end2`),
240 KEY `type` (`type`)
241 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
244 INSERT INTO `glpi_connect_wire` (`ID`, `end1`, `end2`, `type`) VALUES
245 (1, 1, 1, 4),
246 (5, 2, 17, 4),
247 (4, 2, 13, 4),
248 (7, 2, 23, 4),
249 (8, 2, 24, 4),
250 (9, 2, 29, 4);
254 CREATE TABLE `glpi_consumables` (
255 `ID` int(11) NOT NULL auto_increment,
256 `FK_glpi_consumables_type` int(11) default NULL,
257 `date_in` date default NULL,
258 `date_out` date default NULL,
259 PRIMARY KEY (`ID`),
260 KEY `FK_glpi_cartridges_type` (`FK_glpi_consumables_type`),
261 KEY `date_in` (`date_in`),
262 KEY `date_out` (`date_out`)
263 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
269 CREATE TABLE `glpi_consumables_type` (
270 `ID` int(11) NOT NULL auto_increment,
271 `name` varchar(255) NOT NULL default '',
272 `ref` varchar(255) NOT NULL default '',
273 `location` int(11) NOT NULL default '0',
274 `type` tinyint(4) NOT NULL default '0',
275 `FK_glpi_enterprise` int(11) NOT NULL default '0',
276 `tech_num` int(11) default '0',
277 `deleted` enum('Y','N') NOT NULL default 'N',
278 `comments` text NOT NULL,
279 `alarm` tinyint(4) NOT NULL default '10',
280 PRIMARY KEY (`ID`),
281 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
282 KEY `tech_num` (`tech_num`),
283 KEY `deleted` (`deleted`)
284 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
290 CREATE TABLE `glpi_contact_enterprise` (
291 `ID` int(11) NOT NULL auto_increment,
292 `FK_enterprise` int(11) NOT NULL default '0',
293 `FK_contact` int(11) NOT NULL default '0',
294 PRIMARY KEY (`ID`),
295 UNIQUE KEY `FK_enterprise` (`FK_enterprise`,`FK_contact`),
296 KEY `FK_enterprise_2` (`FK_enterprise`),
297 KEY `FK_contact` (`FK_contact`)
298 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
304 CREATE TABLE `glpi_contacts` (
305 `ID` int(11) NOT NULL auto_increment,
306 `name` varchar(255) NOT NULL default '',
307 `phone` varchar(30) NOT NULL default '',
308 `phone2` varchar(30) NOT NULL default '',
309 `fax` varchar(30) NOT NULL default '',
310 `email` varchar(255) NOT NULL default '',
311 `type` tinyint(4) NOT NULL default '1',
312 `comments` text NOT NULL,
313 `deleted` enum('Y','N') NOT NULL default 'N',
314 PRIMARY KEY (`ID`),
315 KEY `deleted` (`deleted`),
316 KEY `type` (`type`)
317 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
323 CREATE TABLE `glpi_contract_device` (
324 `ID` int(11) NOT NULL auto_increment,
325 `FK_contract` int(11) NOT NULL default '0',
326 `FK_device` int(11) NOT NULL default '0',
327 `device_type` tinyint(4) NOT NULL default '0',
328 `is_template` enum('0','1') NOT NULL default '0',
329 PRIMARY KEY (`ID`),
330 UNIQUE KEY `FK_contract` (`FK_contract`,`FK_device`,`device_type`),
331 KEY `FK_contract_2` (`FK_contract`),
332 KEY `FK_device` (`FK_device`,`device_type`)
333 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
339 CREATE TABLE `glpi_contract_enterprise` (
340 `ID` int(11) NOT NULL auto_increment,
341 `FK_enterprise` int(11) NOT NULL default '0',
342 `FK_contract` int(11) NOT NULL default '0',
343 PRIMARY KEY (`ID`),
344 UNIQUE KEY `FK_enterprise` (`FK_enterprise`,`FK_contract`),
345 KEY `FK_enterprise_2` (`FK_enterprise`),
346 KEY `FK_contract` (`FK_contract`)
347 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
353 CREATE TABLE `glpi_contracts` (
354 `ID` int(11) NOT NULL auto_increment,
355 `name` varchar(255) NOT NULL default '',
356 `num` varchar(255) NOT NULL default '',
357 `cost` float NOT NULL default '0',
358 `contract_type` int(11) NOT NULL default '0',
359 `begin_date` date default NULL,
360 `duration` tinyint(4) NOT NULL default '0',
361 `notice` tinyint(4) NOT NULL default '0',
362 `periodicity` tinyint(4) NOT NULL default '0',
363 `facturation` tinyint(4) NOT NULL default '0',
364 `bill_type` int(11) NOT NULL default '0',
365 `comments` text NOT NULL,
366 `compta_num` varchar(255) NOT NULL default '',
367 `deleted` enum('Y','N') NOT NULL default 'N',
368 `week_begin_hour` time NOT NULL default '00:00:00',
369 `week_end_hour` time NOT NULL default '00:00:00',
370 `saturday_begin_hour` time NOT NULL default '00:00:00',
371 `saturday_end_hour` time NOT NULL default '00:00:00',
372 `saturday` enum('Y','N') NOT NULL default 'N',
373 `monday_begin_hour` time NOT NULL default '00:00:00',
374 `monday_end_hour` time NOT NULL default '00:00:00',
375 `monday` enum('Y','N') NOT NULL default 'N',
376 `device_countmax` int(11) NOT NULL default '0',
377 PRIMARY KEY (`ID`),
378 KEY `contract_type` (`contract_type`),
379 KEY `begin_date` (`begin_date`),
380 KEY `bill_type` (`bill_type`)
381 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
387 CREATE TABLE `glpi_device_case` (
388 `ID` int(11) NOT NULL auto_increment,
389 `designation` varchar(255) NOT NULL default '',
390 `format` enum('Grand','Moyen','Micro') NOT NULL default 'Moyen',
391 `comment` text NOT NULL,
392 `FK_glpi_enterprise` int(11) NOT NULL default '0',
393 `specif_default` varchar(250) NOT NULL default '',
394 PRIMARY KEY (`ID`),
395 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
396 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
402 CREATE TABLE `glpi_device_control` (
403 `ID` int(11) NOT NULL auto_increment,
404 `designation` varchar(255) NOT NULL default '',
405 `interface` enum('IDE','SATA','SCSI','USB') NOT NULL default 'IDE',
406 `raid` enum('Y','N') NOT NULL default 'Y',
407 `comment` text NOT NULL,
408 `FK_glpi_enterprise` int(11) NOT NULL default '0',
409 `specif_default` varchar(250) NOT NULL default '',
410 PRIMARY KEY (`ID`),
411 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
412 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
418 CREATE TABLE `glpi_device_drive` (
419 `ID` int(11) NOT NULL auto_increment,
420 `designation` varchar(255) NOT NULL default '',
421 `is_writer` enum('Y','N') NOT NULL default 'Y',
422 `speed` varchar(30) NOT NULL default '',
423 `interface` enum('IDE','SATA','SCSI') NOT NULL default 'IDE',
424 `comment` text NOT NULL,
425 `FK_glpi_enterprise` int(11) NOT NULL default '0',
426 `specif_default` varchar(250) NOT NULL default '',
427 PRIMARY KEY (`ID`),
428 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
429 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
435 CREATE TABLE `glpi_device_gfxcard` (
436 `ID` int(11) NOT NULL auto_increment,
437 `designation` varchar(120) NOT NULL default '',
438 `ram` varchar(10) NOT NULL default '',
439 `interface` enum('AGP','PCI','PCI-X','Other') NOT NULL default 'AGP',
440 `comment` text NOT NULL,
441 `FK_glpi_enterprise` int(11) NOT NULL default '0',
442 `specif_default` varchar(250) NOT NULL default '',
443 PRIMARY KEY (`ID`),
444 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
445 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
451 CREATE TABLE `glpi_device_hdd` (
452 `ID` int(11) NOT NULL auto_increment,
453 `designation` varchar(100) NOT NULL default '',
454 `rpm` varchar(20) NOT NULL default '',
455 `interface` int(11) NOT NULL default '0',
456 `cache` varchar(20) NOT NULL default '',
457 `comment` text NOT NULL,
458 `FK_glpi_enterprise` int(11) NOT NULL default '0',
459 `specif_default` varchar(250) NOT NULL default '',
460 PRIMARY KEY (`ID`),
461 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
462 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
468 CREATE TABLE `glpi_device_iface` (
469 `ID` int(11) NOT NULL auto_increment,
470 `designation` varchar(120) NOT NULL default '',
471 `bandwidth` varchar(20) NOT NULL default '',
472 `comment` text NOT NULL,
473 `FK_glpi_enterprise` int(11) NOT NULL default '0',
474 `specif_default` varchar(250) NOT NULL default '',
475 PRIMARY KEY (`ID`),
476 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
477 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
483 CREATE TABLE `glpi_device_moboard` (
484 `ID` int(11) NOT NULL auto_increment,
485 `designation` varchar(100) NOT NULL default '',
486 `chipset` varchar(120) NOT NULL default '',
487 `comment` text NOT NULL,
488 `FK_glpi_enterprise` int(11) NOT NULL default '0',
489 `specif_default` varchar(250) NOT NULL default '',
490 PRIMARY KEY (`ID`),
491 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
492 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
495 INSERT INTO `glpi_device_moboard` (`ID`, `designation`, `chipset`, `comment`, `FK_glpi_enterprise`, `specif_default`) VALUES
496 (1, 'NVidia Nforce 9', 'Nforce', 'kein', 2, '');
500 CREATE TABLE `glpi_device_pci` (
501 `ID` int(11) NOT NULL auto_increment,
502 `designation` varchar(255) NOT NULL default '',
503 `comment` text NOT NULL,
504 `FK_glpi_enterprise` int(11) NOT NULL default '0',
505 `specif_default` varchar(250) NOT NULL default '',
506 PRIMARY KEY (`ID`),
507 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
508 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
514 CREATE TABLE `glpi_device_power` (
515 `ID` int(11) NOT NULL auto_increment,
516 `designation` varchar(255) NOT NULL default '',
517 `power` varchar(20) NOT NULL default '',
518 `atx` enum('Y','N') NOT NULL default 'Y',
519 `comment` text NOT NULL,
520 `FK_glpi_enterprise` int(11) NOT NULL default '0',
521 `specif_default` varchar(250) NOT NULL default '',
522 PRIMARY KEY (`ID`),
523 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
524 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
530 CREATE TABLE `glpi_device_processor` (
531 `ID` int(11) NOT NULL auto_increment,
532 `designation` varchar(120) NOT NULL default '',
533 `frequence` int(11) NOT NULL default '0',
534 `comment` text NOT NULL,
535 `FK_glpi_enterprise` int(11) NOT NULL default '0',
536 `specif_default` varchar(250) NOT NULL default '',
537 PRIMARY KEY (`ID`),
538 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
539 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
545 CREATE TABLE `glpi_device_ram` (
546 `ID` int(11) NOT NULL auto_increment,
547 `designation` varchar(100) NOT NULL default '',
548 `frequence` varchar(8) NOT NULL default '',
549 `comment` text NOT NULL,
550 `FK_glpi_enterprise` int(11) NOT NULL default '0',
551 `specif_default` varchar(250) NOT NULL default '',
552 `type` int(11) NOT NULL default '0',
553 PRIMARY KEY (`ID`),
554 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
555 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
561 CREATE TABLE `glpi_device_sndcard` (
562 `ID` int(11) NOT NULL auto_increment,
563 `designation` varchar(120) NOT NULL default '',
564 `type` varchar(100) NOT NULL default '',
565 `comment` text NOT NULL,
566 `FK_glpi_enterprise` int(11) NOT NULL default '0',
567 `specif_default` varchar(250) NOT NULL default '',
568 PRIMARY KEY (`ID`),
569 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`)
570 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
576 CREATE TABLE `glpi_doc_device` (
577 `ID` int(11) NOT NULL auto_increment,
578 `FK_doc` int(11) NOT NULL default '0',
579 `FK_device` int(11) NOT NULL default '0',
580 `device_type` tinyint(4) NOT NULL default '0',
581 `is_template` enum('0','1') NOT NULL default '0',
582 PRIMARY KEY (`ID`),
583 UNIQUE KEY `FK_doc` (`FK_doc`,`FK_device`,`device_type`),
584 KEY `FK_doc_2` (`FK_doc`),
585 KEY `FK_device` (`FK_device`,`device_type`),
586 KEY `is_template` (`is_template`)
587 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
590 INSERT INTO `glpi_doc_device` (`ID`, `FK_doc`, `FK_device`, `device_type`, `is_template`) VALUES
591 (17, 1, 1, 1, '0'),
592 (8, 1, 2, 1, '0'),
593 (50, 1, 1, 3, '0'),
594 (51, 4, 5, 3, '0'),
595 (52, 1, 7, 3, '0'),
596 (53, 4, 7, 3, '0'),
597 (54, 1, 8, 3, '0');
601 CREATE TABLE `glpi_docs` (
602 `ID` int(11) NOT NULL auto_increment,
603 `name` varchar(255) NOT NULL default '',
604 `filename` varchar(255) NOT NULL default '',
605 `rubrique` int(11) NOT NULL default '0',
606 `mime` varchar(30) NOT NULL default '',
607 `date_mod` datetime NOT NULL default '0000-00-00 00:00:00',
608 `comment` text NOT NULL,
609 `deleted` enum('Y','N') NOT NULL default 'N',
610 `link` varchar(255) NOT NULL default '',
611 PRIMARY KEY (`ID`),
612 KEY `rubrique` (`rubrique`),
613 KEY `deleted` (`deleted`),
614 KEY `date_mod` (`date_mod`)
615 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
618 INSERT INTO `glpi_docs` (`ID`, `name`, `filename`, `rubrique`, `mime`, `date_mod`, `comment`, `deleted`, `link`) VALUES
619 (1, 'Anleitung', 'class_mail-methods-kolab.inc', 0, 'application/octet-stream', '2006-01-25 11:23:16', 'leeer', 'N', ''),
620 (4, 'Hardware handbuch', 'sieve-php.inc', 0, 'application/octet-stream', '2006-09-29 11:01:52', 'Steht alles drin.\r\n42.342 Seiten', 'N', '');
624 CREATE TABLE `glpi_dropdown_cartridge_type` (
625 `ID` int(11) NOT NULL auto_increment,
626 `name` varchar(255) NOT NULL default '',
627 PRIMARY KEY (`ID`)
628 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
631 INSERT INTO `glpi_dropdown_cartridge_type` (`ID`, `name`) VALUES
632 (3, 'Color blue'),
633 (4, 'Color combination RGB'),
634 (6, 'Laser Cartridge Red'),
635 (8, 'Laser Cartridge Green'),
636 (9, 'Laser Cartridge combination RGB'),
637 (10, 'Color Black'),
638 (11, 'Color Black /& Rgb');
642 CREATE TABLE `glpi_dropdown_consumable_type` (
643 `ID` int(11) NOT NULL auto_increment,
644 `name` varchar(255) NOT NULL default '',
645 PRIMARY KEY (`ID`)
646 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
652 CREATE TABLE `glpi_dropdown_contact_type` (
653 `ID` int(11) NOT NULL auto_increment,
654 `name` varchar(255) NOT NULL default '',
655 PRIMARY KEY (`ID`)
656 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
662 CREATE TABLE `glpi_dropdown_contract_type` (
663 `ID` int(11) NOT NULL auto_increment,
664 `name` varchar(255) NOT NULL default '',
665 PRIMARY KEY (`ID`)
666 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
669 INSERT INTO `glpi_dropdown_contract_type` (`ID`, `name`) VALUES
670 (1, 'Prêt'),
671 (2, 'Location'),
672 (3, 'Leasing'),
673 (4, 'Assurances'),
674 (5, 'Maintenance Hardware'),
675 (6, 'Maintenance Software'),
676 (7, 'Prestation');
680 CREATE TABLE `glpi_dropdown_domain` (
681 `ID` int(11) NOT NULL auto_increment,
682 `name` varchar(255) NOT NULL default '',
683 PRIMARY KEY (`ID`)
684 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
690 CREATE TABLE `glpi_dropdown_enttype` (
691 `ID` int(11) NOT NULL auto_increment,
692 `name` varchar(255) NOT NULL default '',
693 PRIMARY KEY (`ID`)
694 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
700 CREATE TABLE `glpi_dropdown_firmware` (
701 `ID` int(11) NOT NULL auto_increment,
702 `name` varchar(255) NOT NULL default '',
703 PRIMARY KEY (`ID`)
704 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
710 CREATE TABLE `glpi_dropdown_hdd_type` (
711 `ID` int(11) NOT NULL auto_increment,
712 `name` varchar(255) NOT NULL default '',
713 PRIMARY KEY (`ID`)
714 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
717 INSERT INTO `glpi_dropdown_hdd_type` (`ID`, `name`) VALUES
718 (1, 'IDE'),
719 (2, 'SATA'),
720 (3, 'SCSI');
724 CREATE TABLE `glpi_dropdown_iface` (
725 `ID` int(11) NOT NULL auto_increment,
726 `name` varchar(255) default NULL,
727 PRIMARY KEY (`ID`)
728 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
734 CREATE TABLE `glpi_dropdown_kbcategories` (
735 `ID` int(11) NOT NULL auto_increment,
736 `parentID` int(11) NOT NULL default '0',
737 `name` varchar(255) NOT NULL default '',
738 `completename` text NOT NULL,
739 PRIMARY KEY (`ID`),
740 UNIQUE KEY `parentID_2` (`parentID`,`name`),
741 KEY `parentID` (`parentID`)
742 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
748 CREATE TABLE `glpi_dropdown_locations` (
749 `ID` int(11) NOT NULL auto_increment,
750 `name` varchar(255) NOT NULL default '',
751 `parentID` int(11) NOT NULL default '0',
752 `completename` text NOT NULL,
753 PRIMARY KEY (`ID`),
754 UNIQUE KEY `name` (`name`,`parentID`),
755 KEY `parentID` (`parentID`)
756 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
759 INSERT INTO `glpi_dropdown_locations` (`ID`, `name`, `parentID`, `completename`) VALUES
760 (1, 'lala', 0, 'chk'),
761 (2, 'ldala', 1, 'chacka');
765 CREATE TABLE `glpi_dropdown_model` (
766 `ID` int(11) NOT NULL auto_increment,
767 `name` varchar(255) default NULL,
768 PRIMARY KEY (`ID`)
769 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
775 CREATE TABLE `glpi_dropdown_netpoint` (
776 `ID` int(11) NOT NULL auto_increment,
777 `location` int(11) NOT NULL default '0',
778 `name` varchar(255) NOT NULL default '',
779 PRIMARY KEY (`ID`),
780 KEY `location` (`location`)
781 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
787 CREATE TABLE `glpi_dropdown_network` (
788 `ID` int(11) NOT NULL auto_increment,
789 `name` varchar(255) NOT NULL default '',
790 PRIMARY KEY (`ID`)
791 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
797 CREATE TABLE `glpi_dropdown_os` (
798 `ID` int(11) NOT NULL auto_increment,
799 `name` varchar(255) default NULL,
800 PRIMARY KEY (`ID`)
801 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
804 INSERT INTO `glpi_dropdown_os` (`ID`, `name`) VALUES
805 (5, 'Windows 3.1'),
806 (6, 'Debian Sarge'),
807 (7, 'Debian Woody'),
808 (11, 'Windows 98 se'),
809 (10, 'Debian SID'),
810 (14, 'Windows Server 2003'),
811 (18, 'Windows 99');
815 CREATE TABLE `glpi_dropdown_ram_type` (
816 `ID` int(11) NOT NULL auto_increment,
817 `name` varchar(255) NOT NULL default '',
818 PRIMARY KEY (`ID`)
819 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
822 INSERT INTO `glpi_dropdown_ram_type` (`ID`, `name`) VALUES
823 (1, 'EDO'),
824 (2, 'DDR'),
825 (3, 'SDRAM'),
826 (4, 'SDRAM-2');
830 CREATE TABLE `glpi_dropdown_rubdocs` (
831 `ID` int(11) NOT NULL auto_increment,
832 `name` varchar(255) default NULL,
833 PRIMARY KEY (`ID`)
834 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
840 CREATE TABLE `glpi_dropdown_state` (
841 `ID` int(11) NOT NULL auto_increment,
842 `name` varchar(255) default NULL,
843 PRIMARY KEY (`ID`)
844 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
847 INSERT INTO `glpi_dropdown_state` (`ID`, `name`) VALUES
848 (1, 'asdf'),
849 (2, 'asdfasdf');
853 CREATE TABLE `glpi_dropdown_tracking_category` (
854 `ID` int(11) NOT NULL auto_increment,
855 `name` varchar(255) default NULL,
856 PRIMARY KEY (`ID`)
857 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
863 CREATE TABLE `glpi_dropdown_vlan` (
864 `ID` int(11) NOT NULL auto_increment,
865 `name` varchar(255) NOT NULL default '',
866 PRIMARY KEY (`ID`)
867 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
873 CREATE TABLE `glpi_enterprises` (
874 `ID` int(11) NOT NULL auto_increment,
875 `name` varchar(50) NOT NULL default '',
876 `type` int(11) NOT NULL default '0',
877 `address` text NOT NULL,
878 `website` varchar(100) NOT NULL default '',
879 `phonenumber` varchar(20) NOT NULL default '',
880 `comments` text NOT NULL,
881 `deleted` enum('Y','N') NOT NULL default 'N',
882 `fax` varchar(255) NOT NULL default '',
883 `email` varchar(255) NOT NULL default '',
884 PRIMARY KEY (`ID`),
885 KEY `deleted` (`deleted`),
886 KEY `type` (`type`)
887 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
890 INSERT INTO `glpi_enterprises` (`ID`, `name`, `type`, `address`, `website`, `phonenumber`, `comments`, `deleted`, `fax`, `email`) VALUES
891 (8, 'Microsoft', 0, 'Neverlandranche', 'www.google.de', '0001', 'No comment', '', '02', '02@01.00'),
892 (12, 'Cherry', 0, '3 Tasten höher als ''n'' 4 te links.', 'http://cherry_oder_so_aehnlich.com', 'N/A', 'N/A', '', 'N/A', 'N/A@N/A.N/A'),
893 (16, 'GONICUS GmbH', 0, '', 'http://www.gonicus.de', '', 'fg', '', '', '');
897 CREATE TABLE `glpi_event_log` (
898 `ID` int(11) NOT NULL auto_increment,
899 `item` int(11) NOT NULL default '0',
900 `itemtype` varchar(20) NOT NULL default '',
901 `date` datetime NOT NULL default '0000-00-00 00:00:00',
902 `service` varchar(20) default NULL,
903 `level` tinyint(4) NOT NULL default '0',
904 `message` text NOT NULL,
905 PRIMARY KEY (`ID`),
906 KEY `comp` (`item`),
907 KEY `date` (`date`),
908 KEY `itemtype` (`itemtype`)
909 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;
912 INSERT INTO `glpi_event_log` (`ID`, `item`, `itemtype`, `date`, `service`, `level`, `message`) VALUES
913 (90, 0, 'dropdowns', '2006-01-18 14:58:40', 'setup', 5, 'glpi added a value to a dropdown.'),
914 (89, 0, 'dropdowns', '2006-01-18 14:58:31', 'setup', 5, 'glpi added a value to a dropdown.'),
915 (88, 0, 'dropdowns', '2006-01-18 14:58:22', 'setup', 5, 'glpi added a value to a dropdown.'),
916 (87, 0, 'dropdowns', '2006-01-18 14:58:07', 'setup', 5, 'glpi added a value to a dropdown.'),
917 (86, 0, 'dropdowns', '2006-01-18 14:56:55', 'setup', 5, 'glpi added a value to a dropdown.'),
918 (85, 0, 'dropdowns', '2006-01-18 14:56:40', 'setup', 5, 'glpi added a value to a dropdown.'),
919 (84, 0, 'dropdowns', '2006-01-18 14:56:28', 'setup', 5, 'glpi added a value to a dropdown.'),
920 (83, 0, 'dropdowns', '2006-01-18 14:56:12', 'setup', 5, 'glpi added a value to a dropdown.'),
921 (82, 1, 'cartridges', '2006-01-18 14:55:35', 'inventory', 4, 'glpi added item HP Deskjet 80000 Green.'),
922 (81, -1, 'system', '2006-01-18 14:49:46', 'login', 3, 'glpi logged in from 10.3.64.43.'),
923 (80, -1, 'system', '2006-01-18 14:47:02', 'login', 3, 'glpi logged in from 10.3.64.43.'),
924 (79, -1, 'system', '2006-01-17 12:23:40', 'login', 3, 'glpi logged in from 10.3.64.43.'),
925 (78, 4, 'documents', '2006-01-17 09:51:47', 'document', 4, 'glpi associate device.'),
926 (77, 4, 'documents', '2006-01-17 09:51:38', 'document', 4, 'glpi associate device.'),
927 (76, 4, 'printers', '2006-01-17 09:41:51', 'inventory', 4, 'glpi updated item.'),
928 (75, 0, 'dropdowns', '2006-01-17 09:41:28', 'setup', 5, 'glpi added a value to a dropdown.'),
929 (74, 0, 'dropdowns', '2006-01-17 09:41:14', 'setup', 5, 'glpi added a value to a dropdown.'),
930 (73, 0, 'dropdowns', '2006-01-17 09:41:03', 'setup', 5, 'glpi added a value to a dropdown.'),
931 (72, 4, 'printers', '2006-01-17 08:56:20', 'inventory', 4, 'glpi added Name.'),
932 (71, -1, 'system', '2006-01-17 08:48:04', 'login', 3, 'glpi logged in from 10.3.64.43.'),
933 (31, -1, 'system', '2005-12-23 09:38:42', 'login', 3, 'glpi logged in from 10.3.64.43.'),
934 (32, 26, 'computers', '2005-12-23 09:39:05', 'inventory', 4, 'glpi deleted item.'),
935 (33, 0, 'Devices', '2005-12-23 14:53:31', 'inventory', 4, 'glpi added gzt.'),
936 (34, -1, 'system', '2006-01-03 07:49:38', 'login', 3, 'glpi logged in from 10.3.64.43.'),
937 (35, -1, 'system', '2006-01-03 08:16:04', 'login', 3, 'glpi logged in from 10.3.64.43.'),
938 (36, 11, 'networking', '2006-01-03 08:30:08', 'inventory', 4, 'glpi added item name .'),
939 (37, 2, 'Devices', '2006-01-03 12:07:52', 'inventory', 4, 'glpi updated item.'),
940 (38, 0, 'Devices', '2006-01-03 13:12:53', 'inventory', 4, 'glpi added asdfasdf.'),
941 (39, 0, 'Devices', '2006-01-03 13:27:36', 'inventory', 4, 'glpi added amd.'),
942 (40, 0, 'Devices', '2006-01-03 13:33:00', 'inventory', 4, 'glpi added Duschaube.'),
943 (41, 0, 'Devices', '2006-01-03 13:46:11', 'inventory', 4, 'glpi added name.'),
944 (42, 0, 'Devices', '2006-01-03 14:03:42', 'inventory', 4, 'glpi added Hdd.'),
945 (43, 0, 'Devices', '2006-01-03 14:42:23', 'inventory', 4, 'glpi added name.'),
946 (44, 0, 'Devices', '2006-01-03 14:59:12', 'inventory', 4, 'glpi added Controllers.'),
947 (45, 0, 'Devices', '2006-01-03 15:06:59', 'inventory', 4, 'glpi added gfxcard.'),
948 (46, 0, 'Devices', '2006-01-03 15:18:33', 'inventory', 4, 'glpi added power.'),
949 (47, 0, 'Devices', '2006-01-03 15:22:32', 'inventory', 4, 'glpi added pheripgherals.'),
950 (48, -1, 'system', '2006-01-04 08:15:26', 'login', 3, 'glpi logged in from 10.3.64.43.'),
951 (49, 2, 'Devices', '2006-01-04 08:16:05', 'inventory', 4, 'glpi updated item.'),
952 (50, 26, 'computers', '2006-01-04 08:22:28', 'inventory', 4, 'glpi Unlinked a device from computer 26.'),
953 (51, -1, 'system', '2006-01-04 11:23:06', 'login', 3, 'glpi logged in from 10.3.64.43.'),
954 (52, 26, 'documents', '2006-01-04 11:23:47', 'document', 4, 'glpi associate device.'),
955 (53, 2, 'documents', '2006-01-04 11:25:40', 'document', 4, 'glpi added item tester.'),
956 (54, 3, 'documents', '2006-01-04 11:26:09', 'document', 4, 'glpi added item .'),
957 (55, 4, 'documents', '2006-01-04 11:26:29', 'document', 4, 'glpi added item .'),
958 (56, -1, 'system', '2006-01-04 15:22:51', 'login', 3, 'glpi logged in from 10.3.64.43.'),
959 (57, 3, 'documents', '2006-01-04 15:41:50', 'document', 4, 'glpi updated item.'),
960 (58, -1, 'system', '2006-01-05 10:17:59', 'login', 3, 'glpi logged in from 10.3.64.43.'),
961 (59, 26, 'documents', '2006-01-05 10:18:52', 'document', 4, 'glpi associate device.'),
962 (60, -1, 'system', '2006-01-06 08:24:59', 'login', 3, 'glpi logged in from 10.3.64.43.'),
963 (61, -1, 'system', '2006-01-06 09:21:47', 'login', 3, 'glpi logged in from 10.3.64.43.'),
964 (62, -1, 'system', '2006-01-06 10:03:43', 'login', 3, 'glpi logged in from 10.3.64.43.'),
965 (63, 0, 'dropdowns', '2006-01-06 10:33:17', 'setup', 5, 'glpi added a value to a dropdown.'),
966 (64, 0, 'dropdowns', '2006-01-06 10:41:57', 'setup', 5, 'glpi added a value to a dropdown.'),
967 (65, 0, 'dropdowns', '2006-01-06 10:42:12', 'setup', 5, 'glpi added a value to a dropdown.'),
968 (66, 5, 'monitors', '2006-01-06 14:38:56', 'inventory', 4, 'glpi added asdfasdf.'),
969 (67, 27, 'computers', '2006-01-06 14:39:39', 'inventory', 5, 'glpi connected item.'),
970 (68, -1, 'system', '2006-01-16 12:08:10', 'login', 1, 'failed login: root'),
971 (69, -1, 'system', '2006-01-16 12:08:23', 'login', 1, 'failed login: admin'),
972 (70, -1, 'system', '2006-01-16 12:08:35', 'login', 3, 'glpi logged in from 10.3.64.43.'),
973 (91, 0, 'dropdowns', '2006-01-18 14:58:57', 'setup', 5, 'glpi added a value to a dropdown.'),
974 (92, 0, 'dropdowns', '2006-01-18 14:59:08', 'setup', 5, 'glpi added a value to a dropdown.'),
975 (93, 0, 'dropdowns', '2006-01-18 14:59:21', 'setup', 5, 'glpi added a value to a dropdown.'),
976 (94, 1, 'cartridges', '2006-01-18 15:00:07', 'inventory', 4, 'glpi updated item.'),
977 (95, 1, 'cartridges', '2006-01-18 15:02:10', 'inventory', 4, 'glpi added a cartridge.'),
978 (96, 1, 'cartridges', '2006-01-18 15:03:19', 'inventory', 4, 'glpi added a cartridge.'),
979 (97, 1, 'cartridges', '2006-01-18 15:31:39', 'inventory', 5, 'glpi installed cartridge.'),
980 (98, -1, 'system', '2006-01-19 08:33:27', 'login', 3, 'glpi logged in from 10.3.64.43.'),
981 (99, 1, 'cartridges', '2006-01-19 08:34:32', 'inventory', 4, 'glpi added 17 cartridge.'),
982 (100, 0, 'infocom', '2006-01-19 08:34:54', 'financial', 4, 'glpi added infocoms.'),
983 (101, 1, 'cartridges', '2006-01-19 10:21:27', 'inventory', 4, 'glpi updated item.'),
984 (102, 1, 'cartridges', '2006-01-19 10:21:33', 'inventory', 4, 'glpi added 1 cartridge.'),
985 (103, 2, 'cartridges', '2006-01-19 10:22:45', 'inventory', 4, 'glpi added item Laserjet3.'),
986 (104, 2, 'cartridges', '2006-01-19 10:23:16', 'inventory', 4, 'glpi updated item.');
990 CREATE TABLE `glpi_followups` (
991 `ID` int(11) NOT NULL auto_increment,
992 `tracking` int(11) default NULL,
993 `date` datetime default NULL,
994 `author` int(11) NOT NULL default '0',
995 `contents` text,
996 PRIMARY KEY (`ID`),
997 KEY `tracking` (`tracking`),
998 KEY `author` (`author`),
999 KEY `date` (`date`)
1000 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1006 CREATE TABLE `glpi_infocoms` (
1007 `ID` int(11) NOT NULL auto_increment,
1008 `FK_device` int(11) NOT NULL default '0',
1009 `device_type` tinyint(4) NOT NULL default '0',
1010 `buy_date` date NOT NULL default '0000-00-00',
1011 `use_date` date NOT NULL default '0000-00-00',
1012 `warranty_duration` tinyint(4) NOT NULL default '0',
1013 `warranty_info` varchar(255) NOT NULL default '',
1014 `FK_enterprise` int(11) default NULL,
1015 `num_commande` varchar(50) NOT NULL default '',
1016 `bon_livraison` varchar(50) NOT NULL default '',
1017 `num_immo` varchar(50) NOT NULL default '',
1018 `value` float NOT NULL default '0',
1019 `warranty_value` float default NULL,
1020 `amort_time` tinyint(4) NOT NULL default '0',
1021 `amort_type` varchar(20) NOT NULL default '',
1022 `amort_coeff` float NOT NULL default '0',
1023 `comments` text NOT NULL,
1024 `facture` varchar(255) NOT NULL default '',
1025 PRIMARY KEY (`ID`),
1026 UNIQUE KEY `FK_device` (`FK_device`,`device_type`),
1027 KEY `FK_enterprise` (`FK_enterprise`),
1028 KEY `buy_date` (`buy_date`)
1029 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1032 INSERT INTO `glpi_infocoms` (`ID`, `FK_device`, `device_type`, `buy_date`, `use_date`, `warranty_duration`, `warranty_info`, `FK_enterprise`, `num_commande`, `bon_livraison`, `num_immo`, `value`, `warranty_value`, `amort_time`, `amort_type`, `amort_coeff`, `comments`, `facture`) VALUES
1033 (1, 10, 19, '0000-00-00', '0000-00-00', 0, '', NULL, '', '', '', 0, NULL, 0, '', 0, '', '');
1037 CREATE TABLE `glpi_inst_software` (
1038 `ID` int(11) NOT NULL auto_increment,
1039 `cID` int(11) NOT NULL default '0',
1040 `license` int(11) NOT NULL default '0',
1041 PRIMARY KEY (`ID`),
1042 KEY `cID` (`cID`),
1043 KEY `sID` (`license`)
1044 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1050 CREATE TABLE `glpi_kbitems` (
1051 `ID` int(11) NOT NULL auto_increment,
1052 `categoryID` int(11) NOT NULL default '0',
1053 `question` text NOT NULL,
1054 `answer` text NOT NULL,
1055 `faq` enum('yes','no') NOT NULL default 'no',
1056 PRIMARY KEY (`ID`),
1057 KEY `categoryID` (`categoryID`)
1058 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1064 CREATE TABLE `glpi_licenses` (
1065 `ID` int(15) NOT NULL auto_increment,
1066 `sID` int(15) NOT NULL default '0',
1067 `serial` varchar(255) NOT NULL default '',
1068 `expire` date default NULL,
1069 `oem` enum('N','Y') NOT NULL default 'N',
1070 `oem_computer` int(11) NOT NULL default '0',
1071 `buy` enum('Y','N') NOT NULL default 'Y',
1072 PRIMARY KEY (`ID`),
1073 KEY `sID` (`sID`)
1074 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1080 CREATE TABLE `glpi_links` (
1081 `ID` int(11) NOT NULL auto_increment,
1082 `name` varchar(255) NOT NULL default '',
1083 PRIMARY KEY (`ID`)
1084 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1090 CREATE TABLE `glpi_links_device` (
1091 `ID` int(11) NOT NULL auto_increment,
1092 `FK_links` int(11) NOT NULL default '0',
1093 `device_type` int(11) NOT NULL default '0',
1094 PRIMARY KEY (`ID`),
1095 UNIQUE KEY `device_type_2` (`device_type`,`FK_links`),
1096 KEY `device_type` (`device_type`),
1097 KEY `FK_links` (`FK_links`)
1098 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1104 CREATE TABLE `glpi_monitors` (
1105 `ID` int(10) NOT NULL auto_increment,
1106 `name` varchar(255) NOT NULL default '',
1107 `date_mod` datetime NOT NULL default '0000-00-00 00:00:00',
1108 `contact` varchar(255) NOT NULL default '',
1109 `contact_num` varchar(255) NOT NULL default '',
1110 `tech_num` int(11) NOT NULL default '0',
1111 `comments` text NOT NULL,
1112 `serial` varchar(255) NOT NULL default '',
1113 `otherserial` varchar(255) NOT NULL default '',
1114 `size` int(3) NOT NULL default '0',
1115 `flags_micro` tinyint(4) NOT NULL default '0',
1116 `flags_speaker` tinyint(4) NOT NULL default '0',
1117 `flags_subd` tinyint(4) NOT NULL default '0',
1118 `flags_bnc` tinyint(4) NOT NULL default '0',
1119 `location` int(11) default NULL,
1120 `type` int(11) default NULL,
1121 `FK_glpi_enterprise` int(11) NOT NULL default '0',
1122 `is_global` enum('0','1') NOT NULL default '0',
1123 `deleted` enum('Y','N') NOT NULL default 'N',
1124 `is_template` enum('0','1') NOT NULL default '0',
1125 `tplname` varchar(255) default NULL,
1126 PRIMARY KEY (`ID`),
1127 KEY `ID` (`ID`),
1128 KEY `type` (`type`),
1129 KEY `location` (`location`),
1130 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
1131 KEY `deleted` (`deleted`),
1132 KEY `is_template` (`is_template`),
1133 KEY `tech_num` (`tech_num`)
1134 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1137 INSERT INTO `glpi_monitors` (`ID`, `name`, `date_mod`, `contact`, `contact_num`, `tech_num`, `comments`, `serial`, `otherserial`, `size`, `flags_micro`, `flags_speaker`, `flags_subd`, `flags_bnc`, `location`, `type`, `FK_glpi_enterprise`, `is_global`, `deleted`, `is_template`, `tplname`) VALUES
1138 (2, 'asdfasdf', '0000-00-00 00:00:00', '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '');
1142 CREATE TABLE `glpi_networking` (
1143 `ID` int(11) NOT NULL auto_increment,
1144 `name` varchar(30) NOT NULL default '',
1145 `ram` varchar(10) NOT NULL default '',
1146 `serial` varchar(50) NOT NULL default '',
1147 `otherserial` varchar(50) NOT NULL default '',
1148 `contact` varchar(30) NOT NULL default '',
1149 `contact_num` varchar(30) NOT NULL default '',
1150 `tech_num` int(11) NOT NULL default '0',
1151 `date_mod` datetime NOT NULL default '0000-00-00 00:00:00',
1152 `comments` text NOT NULL,
1153 `location` int(11) default NULL,
1154 `domain` int(11) NOT NULL default '0',
1155 `network` int(11) NOT NULL default '0',
1156 `type` int(11) default NULL,
1157 `firmware` int(11) default NULL,
1158 `FK_glpi_enterprise` int(11) NOT NULL default '0',
1159 `deleted` enum('Y','N') NOT NULL default 'N',
1160 `is_template` enum('0','1') NOT NULL default '0',
1161 `tplname` varchar(255) default NULL,
1162 `ifmac` varchar(30) NOT NULL default '',
1163 `ifaddr` varchar(30) NOT NULL default '',
1164 PRIMARY KEY (`ID`),
1165 KEY `location` (`location`),
1166 KEY `type` (`type`),
1167 KEY `firmware` (`firmware`),
1168 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
1169 KEY `deleted` (`deleted`),
1170 KEY `is_template` (`is_template`),
1171 KEY `tech_num` (`tech_num`)
1172 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
1175 INSERT INTO `glpi_networking` (`ID`, `name`, `ram`, `serial`, `otherserial`, `contact`, `contact_num`, `tech_num`, `date_mod`, `comments`, `location`, `domain`, `network`, `type`, `firmware`, `FK_glpi_enterprise`, `deleted`, `is_template`, `tplname`, `ifmac`, `ifaddr`) VALUES
1176 (10, '', '', '', '', '', '', 0, '0000-00-00 00:00:00', '', NULL, 0, 0, NULL, NULL, 0, 'N', '1', 'Blank Template', '', ''),
1177 (11, '', '', '', '', '', '', 0, '2006-01-03 08:30:08', '', 0, 0, 0, 0, 0, 0, 'N', '0', NULL, '', '');
1181 CREATE TABLE `glpi_networking_ports` (
1182 `ID` int(11) NOT NULL auto_increment,
1183 `on_device` int(11) NOT NULL default '0',
1184 `device_type` tinyint(4) NOT NULL default '0',
1185 `logical_number` int(11) NOT NULL default '0',
1186 `name` char(30) NOT NULL default '',
1187 `ifaddr` char(30) NOT NULL default '',
1188 `ifmac` char(30) NOT NULL default '',
1189 `iface` int(11) default NULL,
1190 `netpoint` int(11) default NULL,
1191 PRIMARY KEY (`ID`),
1192 KEY `on_device` (`on_device`,`device_type`),
1193 KEY `netpoint` (`netpoint`)
1194 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1200 CREATE TABLE `glpi_networking_vlan` (
1201 `ID` int(11) NOT NULL auto_increment,
1202 `FK_port` int(11) NOT NULL default '0',
1203 `FK_vlan` int(11) NOT NULL default '0',
1204 PRIMARY KEY (`ID`),
1205 UNIQUE KEY `FK_port_2` (`FK_port`,`FK_vlan`),
1206 KEY `FK_port` (`FK_port`),
1207 KEY `FK_vlan` (`FK_vlan`)
1208 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1214 CREATE TABLE `glpi_networking_wire` (
1215 `ID` int(11) NOT NULL auto_increment,
1216 `end1` int(11) NOT NULL default '0',
1217 `end2` int(11) NOT NULL default '0',
1218 PRIMARY KEY (`ID`),
1219 UNIQUE KEY `end1_1` (`end1`,`end2`),
1220 KEY `end1` (`end1`),
1221 KEY `end2` (`end2`)
1222 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1228 CREATE TABLE `glpi_peripherals` (
1229 `ID` int(11) NOT NULL auto_increment,
1230 `name` varchar(255) NOT NULL default '',
1231 `date_mod` datetime NOT NULL default '0000-00-00 00:00:00',
1232 `contact` varchar(255) NOT NULL default '',
1233 `contact_num` varchar(255) NOT NULL default '',
1234 `tech_num` int(11) NOT NULL default '0',
1235 `comments` text NOT NULL,
1236 `serial` varchar(255) NOT NULL default '',
1237 `otherserial` varchar(255) NOT NULL default '',
1238 `location` int(11) NOT NULL default '0',
1239 `type` int(11) NOT NULL default '0',
1240 `brand` varchar(255) NOT NULL default '',
1241 `FK_glpi_enterprise` int(11) NOT NULL default '0',
1242 `is_global` enum('0','1') NOT NULL default '0',
1243 `deleted` enum('Y','N') NOT NULL default 'N',
1244 `is_template` enum('0','1') NOT NULL default '0',
1245 `tplname` varchar(255) default NULL,
1246 PRIMARY KEY (`ID`),
1247 KEY `type` (`type`),
1248 KEY `location` (`location`),
1249 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
1250 KEY `deleted` (`deleted`),
1251 KEY `is_template` (`is_template`),
1252 KEY `tech_num` (`tech_num`)
1253 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1256 INSERT INTO `glpi_peripherals` (`ID`, `name`, `date_mod`, `contact`, `contact_num`, `tech_num`, `comments`, `serial`, `otherserial`, `location`, `type`, `brand`, `FK_glpi_enterprise`, `is_global`, `deleted`, `is_template`, `tplname`) VALUES
1257 (1, '', '0000-00-00 00:00:00', '', '', 0, '', '', '', 0, 0, '', 0, '0', 'N', '1', 'Blank Template'),
1258 (2, 'gf5200', '2005-12-13 09:34:32', 'Herr Herr', '0231', 4, 'f', '45875486468', '4554', 0, 0, 'GC', 1, '0', 'N', '0', NULL);
1262 CREATE TABLE `glpi_printers` (
1263 `ID` int(10) NOT NULL auto_increment,
1264 `name` varchar(255) NOT NULL default '',
1265 `date_mod` datetime NOT NULL default '0000-00-00 00:00:00',
1266 `contact` varchar(255) NOT NULL default '',
1267 `contact_num` varchar(255) NOT NULL default '',
1268 `tech_num` int(11) NOT NULL default '0',
1269 `serial` varchar(255) NOT NULL default '',
1270 `otherserial` varchar(255) NOT NULL default '',
1271 `flags_serial` tinyint(4) NOT NULL default '0',
1272 `flags_par` tinyint(4) NOT NULL default '0',
1273 `flags_usb` tinyint(4) NOT NULL default '0',
1274 `comments` text NOT NULL,
1275 `ramSize` varchar(6) NOT NULL default '',
1276 `location` int(11) default NULL,
1277 `domain` int(11) NOT NULL default '0',
1278 `network` int(11) NOT NULL default '0',
1279 `type` int(11) default NULL,
1280 `FK_glpi_enterprise` int(11) NOT NULL default '0',
1281 `deleted` enum('Y','N') NOT NULL default 'N',
1282 `is_template` enum('0','1') NOT NULL default '0',
1283 `tplname` varchar(255) default NULL,
1284 `initial_pages` varchar(30) NOT NULL default '0',
1285 PRIMARY KEY (`ID`),
1286 KEY `id` (`ID`),
1287 KEY `location` (`location`),
1288 KEY `type` (`type`),
1289 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
1290 KEY `deleted` (`deleted`),
1291 KEY `is_template` (`is_template`),
1292 KEY `tech_num` (`tech_num`)
1293 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
1296 INSERT INTO `glpi_printers` (`ID`, `name`, `date_mod`, `contact`, `contact_num`, `tech_num`, `serial`, `otherserial`, `flags_serial`, `flags_par`, `flags_usb`, `comments`, `ramSize`, `location`, `domain`, `network`, `type`, `FK_glpi_enterprise`, `deleted`, `is_template`, `tplname`, `initial_pages`) VALUES
1297 (1, 'cn=demohost,ou=printers,ou=systems,dc=gonicus,dc=de', '2006-02-01 12:48:33', '', '', 0, '', '', 0, 0, 0, '', '0', 0, 0, 0, 2, 8, 'N', '0', NULL, '0'),
1298 (2, 'cn=drucker4,ou=printers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '2006-09-19 09:49:33', '', '', 0, '', '', 0, 0, 0, '', '0', 0, 0, 0, 3, 12, 'N', '0', NULL, '0'),
1299 (3, 'cn=drucker6,ou=printers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '2006-11-29 14:53:41', '', '', 0, '', '', 0, 0, 0, '', '0', 0, 0, 0, 3, 12, 'N', '0', NULL, '0'),
1300 (4, 'cn=Fettsäuren,ou=printers,ou=systems,ou=keks,ou=DasTestDep,o=Landeshauptstadt München,c=de', '2006-09-28 09:17:45', '', '', 0, '', '', 1, 1, 1, '', '0', 0, 0, 0, 3, 12, 'N', '0', NULL, '0'),
1301 (5, 'cn=Brennwert,ou=printers,ou=systems,ou=keks,ou=DasTestDep,o=Landeshauptstadt München,c=de', '2006-09-29 11:02:10', '', '', 0, '', '', 1, 1, 1, 'dfsaaaaaaaaaaaaaaaaa', '0', 0, 0, 0, 3, 12, 'N', '0', NULL, '0'),
1302 (7, 'cn=atz23,ou=printers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '2006-11-29 10:19:48', '', '', 19, '', '', 1, 1, 1, 'ursssszzzzzzzzzzzzzzzzzzzzzzzzzzzzzz', '0', 0, 0, 0, 3, 12, 'N', '0', NULL, '0'),
1303 (8, 'cn=drucker2,ou=printers,ou=systems,ou=DasTestDep,o=Landeshauptstadt München,c=de', '2006-11-29 10:25:26', '', '', 0, '', '', 1, 1, 1, 'test', '0', 0, 0, 0, 3, 12, 'N', '0', NULL, '0');
1307 CREATE TABLE `glpi_repair_item` (
1308 `ID` int(11) NOT NULL auto_increment,
1309 `device_type` tinyint(4) NOT NULL default '0',
1310 `id_device` int(11) NOT NULL default '0',
1311 PRIMARY KEY (`ID`),
1312 KEY `device_type` (`device_type`),
1313 KEY `device_type_2` (`device_type`,`id_device`)
1314 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1320 CREATE TABLE `glpi_reservation_item` (
1321 `ID` int(11) NOT NULL auto_increment,
1322 `device_type` tinyint(4) NOT NULL default '0',
1323 `id_device` int(11) NOT NULL default '0',
1324 `comments` text NOT NULL,
1325 PRIMARY KEY (`ID`),
1326 KEY `device_type` (`device_type`)
1327 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1330 INSERT INTO `glpi_reservation_item` (`ID`, `device_type`, `id_device`, `comments`) VALUES
1331 (1, 1, 20, '');
1335 CREATE TABLE `glpi_reservation_resa` (
1336 `ID` bigint(20) NOT NULL auto_increment,
1337 `id_item` int(11) NOT NULL default '0',
1338 `begin` datetime NOT NULL default '0000-00-00 00:00:00',
1339 `end` datetime NOT NULL default '0000-00-00 00:00:00',
1340 `id_user` int(11) NOT NULL default '0',
1341 `comment` varchar(255) NOT NULL default '',
1342 PRIMARY KEY (`ID`),
1343 KEY `id_item` (`id_item`),
1344 KEY `id_user` (`id_user`),
1345 KEY `begin` (`begin`),
1346 KEY `end` (`end`)
1347 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1353 CREATE TABLE `glpi_software` (
1354 `ID` int(11) NOT NULL auto_increment,
1355 `name` varchar(200) NOT NULL default '',
1356 `version` varchar(20) NOT NULL default '',
1357 `comments` text,
1358 `location` int(11) default NULL,
1359 `tech_num` int(11) NOT NULL default '0',
1360 `platform` int(11) default NULL,
1361 `is_update` enum('N','Y') NOT NULL default 'N',
1362 `update_software` int(11) NOT NULL default '-1',
1363 `FK_glpi_enterprise` int(11) NOT NULL default '0',
1364 `deleted` enum('Y','N') NOT NULL default 'N',
1365 `is_template` enum('0','1') NOT NULL default '0',
1366 `tplname` varchar(255) default NULL,
1367 `date_mod` datetime default NULL,
1368 PRIMARY KEY (`ID`),
1369 KEY `platform` (`platform`),
1370 KEY `location` (`location`),
1371 KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`),
1372 KEY `deleted` (`deleted`),
1373 KEY `is_template` (`is_template`),
1374 KEY `date_mod` (`date_mod`),
1375 KEY `tech_num` (`tech_num`)
1376 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
1379 INSERT INTO `glpi_software` (`ID`, `name`, `version`, `comments`, `location`, `tech_num`, `platform`, `is_update`, `update_software`, `FK_glpi_enterprise`, `deleted`, `is_template`, `tplname`, `date_mod`) VALUES
1380 (6, '', '', NULL, NULL, 0, NULL, 'N', -1, 0, 'N', '1', 'Blank Template', NULL);
1384 CREATE TABLE `glpi_state_item` (
1385 `ID` int(11) NOT NULL auto_increment,
1386 `device_type` tinyint(4) NOT NULL default '0',
1387 `id_device` int(11) NOT NULL default '0',
1388 `state` int(11) default '1',
1389 `is_template` enum('0','1') NOT NULL default '0',
1390 PRIMARY KEY (`ID`),
1391 KEY `device_type` (`device_type`),
1392 KEY `device_type_2` (`device_type`,`id_device`)
1393 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1399 CREATE TABLE `glpi_tracking` (
1400 `ID` int(11) NOT NULL auto_increment,
1401 `date` datetime default NULL,
1402 `closedate` datetime NOT NULL default '0000-00-00 00:00:00',
1403 `status` enum('new','old') default NULL,
1404 `author` int(11) NOT NULL default '0',
1405 `assign` int(11) NOT NULL default '0',
1406 `assign_type` tinyint(4) NOT NULL default '0',
1407 `device_type` int(11) NOT NULL default '1',
1408 `computer` int(11) default NULL,
1409 `contents` text,
1410 `priority` tinyint(4) NOT NULL default '1',
1411 `is_group` enum('no','yes') NOT NULL default 'no',
1412 `uemail` varchar(100) default NULL,
1413 `emailupdates` varchar(4) default NULL,
1414 `realtime` float NOT NULL default '0',
1415 `category` int(11) NOT NULL default '0',
1416 PRIMARY KEY (`ID`),
1417 KEY `computer` (`computer`),
1418 KEY `author` (`author`),
1419 KEY `assign` (`assign`),
1420 KEY `date` (`date`),
1421 KEY `closedate` (`closedate`),
1422 KEY `status` (`status`),
1423 KEY `category` (`category`)
1424 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1430 CREATE TABLE `glpi_tracking_planning` (
1431 `ID` bigint(20) NOT NULL auto_increment,
1432 `id_tracking` int(11) NOT NULL default '0',
1433 `id_assign` int(11) NOT NULL default '0',
1434 `begin` datetime NOT NULL default '0000-00-00 00:00:00',
1435 `end` datetime NOT NULL default '0000-00-00 00:00:00',
1436 PRIMARY KEY (`ID`),
1437 KEY `id_tracking` (`id_tracking`),
1438 KEY `begin` (`begin`),
1439 KEY `end` (`end`)
1440 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1446 CREATE TABLE `glpi_type_computers` (
1447 `ID` int(11) NOT NULL auto_increment,
1448 `name` varchar(255) NOT NULL default '',
1449 PRIMARY KEY (`ID`)
1450 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
1453 INSERT INTO `glpi_type_computers` (`ID`, `name`) VALUES
1454 (26, 'SuperDupfer'),
1455 (27, 'Server'),
1456 (18, 'System tester'),
1457 (19, 'Windows workstation'),
1458 (21, 'Network device'),
1459 (28, 'Microcontroller');
1463 CREATE TABLE `glpi_type_docs` (
1464 `ID` int(11) NOT NULL auto_increment,
1465 `name` varchar(255) NOT NULL default '',
1466 `ext` varchar(10) NOT NULL default '',
1467 `icon` varchar(255) NOT NULL default '',
1468 `mime` varchar(100) NOT NULL default '',
1469 `upload` enum('Y','N') NOT NULL default 'Y',
1470 `date_mod` datetime default NULL,
1471 PRIMARY KEY (`ID`),
1472 UNIQUE KEY `extension` (`ext`),
1473 KEY `upload` (`upload`)
1474 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;
1477 INSERT INTO `glpi_type_docs` (`ID`, `name`, `ext`, `icon`, `mime`, `upload`, `date_mod`) VALUES
1478 (1, 'JPEG', 'jpg', 'jpg-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1479 (2, 'PNG', 'png', 'png-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1480 (3, 'GIF', 'gif', 'gif-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1481 (4, 'BMP', 'bmp', 'bmp-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1482 (5, 'Photoshop', 'psd', 'psd-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1483 (6, 'TIFF', 'tif', 'tif-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1484 (7, 'AIFF', 'aiff', 'aiff-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1485 (8, 'Windows Media', 'asf', 'asf-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1486 (9, 'Windows Media', 'avi', 'avi-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1487 (44, 'C source', 'c', '', '', 'Y', '2004-12-13 19:47:22'),
1488 (27, 'RealAudio', 'rm', 'rm-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1489 (16, 'Midi', 'mid', 'mid-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1490 (17, 'QuickTime', 'mov', 'mov-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1491 (18, 'MP3', 'mp3', 'mp3-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1492 (19, 'MPEG', 'mpg', 'mpg-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1493 (20, 'Ogg Vorbis', 'ogg', 'ogg-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1494 (24, 'QuickTime', 'qt', 'qt-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1495 (10, 'BZip', 'bz2', 'bz2-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1496 (25, 'RealAudio', 'ra', 'ra-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1497 (26, 'RealAudio', 'ram', 'ram-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1498 (11, 'Word', 'doc', 'doc-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1499 (12, 'DjVu', 'djvu', '', '', 'Y', '2004-12-13 19:47:21'),
1500 (42, 'MNG', 'mng', '', '', 'Y', '2004-12-13 19:47:22'),
1501 (13, 'PostScript', 'eps', 'ps-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1502 (14, 'GZ', 'gz', 'gz-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1503 (37, 'WAV', 'wav', 'wav-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1504 (15, 'HTML', 'html', 'html-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1505 (34, 'Flash', 'swf', '', '', 'Y', '2004-12-13 19:47:22'),
1506 (21, 'PDF', 'pdf', 'pdf-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1507 (22, 'PowerPoint', 'ppt', 'ppt-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1508 (23, 'PostScript', 'ps', 'ps-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1509 (40, 'Windows Media', 'wmv', '', '', 'Y', '2004-12-13 19:47:22'),
1510 (28, 'RTF', 'rtf', 'rtf-dist.png', '', 'Y', '2004-12-13 19:47:21'),
1511 (29, 'StarOffice', 'sdd', 'sdd-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1512 (30, 'StarOffice', 'sdw', 'sdw-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1513 (31, 'Stuffit', 'sit', 'sit-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1514 (43, 'Adobe Illustrator', 'ai', 'ai-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1515 (32, 'OpenOffice Impress', 'sxi', 'sxi-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1516 (33, 'OpenOffice', 'sxw', 'sxw-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1517 (46, 'DVI', 'dvi', 'dvi-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1518 (35, 'TGZ', 'tgz', 'tgz-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1519 (36, 'texte', 'txt', 'txt-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1520 (49, 'RedHat/Mandrake/SuSE', 'rpm', 'rpm-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1521 (38, 'Excel', 'xls', 'xls-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1522 (39, 'XML', 'xml', 'xml-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1523 (41, 'Zip', 'zip', 'zip-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1524 (45, 'Debian', 'deb', 'deb-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1525 (47, 'C header', 'h', '', '', 'Y', '2004-12-13 19:47:22'),
1526 (48, 'Pascal', 'pas', '', '', 'Y', '2004-12-13 19:47:22'),
1527 (50, 'OpenOffice Calc', 'sxc', 'sxc-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1528 (51, 'LaTeX', 'tex', 'tex-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1529 (52, 'GIMP multi-layer', 'xcf', 'xcf-dist.png', '', 'Y', '2004-12-13 19:47:22'),
1530 (53, 'JPEG', 'jpeg', 'jpg-dist.png', '', 'Y', '2005-03-07 22:23:17');
1534 CREATE TABLE `glpi_type_monitors` (
1535 `ID` int(11) NOT NULL auto_increment,
1536 `name` varchar(255) default NULL,
1537 PRIMARY KEY (`ID`)
1538 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
1541 INSERT INTO `glpi_type_monitors` (`ID`, `name`) VALUES
1542 (1, 'testoe');
1546 CREATE TABLE `glpi_type_networking` (
1547 `ID` int(11) NOT NULL auto_increment,
1548 `name` varchar(255) default NULL,
1549 PRIMARY KEY (`ID`)
1550 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1556 CREATE TABLE `glpi_type_peripherals` (
1557 `ID` int(11) NOT NULL auto_increment,
1558 `name` varchar(255) default NULL,
1559 PRIMARY KEY (`ID`)
1560 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1566 CREATE TABLE `glpi_type_printers` (
1567 `ID` int(11) NOT NULL auto_increment,
1568 `name` varchar(255) default NULL,
1569 PRIMARY KEY (`ID`)
1570 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
1573 INSERT INTO `glpi_type_printers` (`ID`, `name`) VALUES
1574 (2, 'Tintenstrahl'),
1575 (3, 'Farb Laser'),
1576 (5, 'Not known'),
1577 (6, 'Nadeldrucker Farbe'),
1578 (10, 'Nadeldrucker'),
1579 (11, 'Laser'),
1580 (12, 'Photodrucker A3'),
1581 (14, 'Tintentrahl');
1585 CREATE TABLE `glpi_users` (
1586 `ID` int(11) NOT NULL auto_increment,
1587 `name` varchar(80) NOT NULL default '',
1588 `password` varchar(80) NOT NULL default '',
1589 `password_md5` varchar(80) NOT NULL default '',
1590 `email` varchar(80) NOT NULL default '',
1591 `phone` varchar(100) default NULL,
1592 `type` enum('normal','admin','post-only','super-admin') NOT NULL default 'normal',
1593 `realname` varchar(255) NOT NULL default '',
1594 `can_assign_job` enum('yes','no') NOT NULL default 'no',
1595 `location` int(11) default NULL,
1596 `tracking_order` enum('yes','no') NOT NULL default 'no',
1597 `language` varchar(255) NOT NULL default '',
1598 PRIMARY KEY (`ID`),
1599 UNIQUE KEY `name` (`name`),
1600 KEY `type` (`type`),
1601 KEY `name_2` (`name`)
1602 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
1605 INSERT INTO `glpi_users` (`ID`, `name`, `password`, `password_md5`, `email`, `phone`, `type`, `realname`, `can_assign_job`, `location`, `tracking_order`, `language`) VALUES
1606 (1, 'cn=GOsa main administrator admin,ou=people,dc=gonicus,dc=de', '', '', 'asdfasdf@asdfasdf.de', '333333333', 'normal', '', 'no', NULL, 'no', ''),
1607 (2, 'cn=Getester Hainz,ou=people,dc=gonicus,dc=de', '', '', 'gtest@blafasel.org', NULL, 'normal', '', 'no', NULL, 'no', ''),
1608 (3, 'cn=adff dendnen,ou=people,dc=gonicus,dc=de', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1609 (4, 'cn=tttttttttttt testttttttttttttttttt,ou=people,ou=Diesisteinelangeabteilung,ou=', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1610 (5, 'cn=asdff33 asdf333,ou=people,ou=tester,ou=Vertrieb,dc=gonicus,dc=de', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1611 (6, 'cn=Florian Schiessl,ou=people,o=Landeshauptstadt München,c=de', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1612 (7, 'cn=blub blab,ou=people,o=Landeshauptstadt München,c=de', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1613 (8, 'cn=Florian test,ou=people,o=Landeshauptstadt München,c=de', '', '', '', '233-92742', 'normal', '', 'no', NULL, 'no', ''),
1614 (9, 'uid=pppppp,ou=people,o=Landeshauptstadt München,c=de', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1615 (10, 'cn=acltest2 acltest2,ou=people,ou=checkTheFAIStuff,ou=DasTestDep,o=Landeshauptst', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1616 (11, 'cn=acltest acltest,ou=people,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', 'acltest@gonicus.de', '123123', 'normal', '', 'no', NULL, 'no', ''),
1617 (12, 'cn=Max Mustermann,ou=people,ou=PrinterLosesMember,ou=DasTestDep,o=Landeshauptsta', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1618 (13, 'cn=Susanne Neuhaus,ou=people,ou=PrinterLosesMember,ou=DasTestDep,o=Landeshauptst', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1619 (14, '', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1620 (15, 'cn=Florian Meier,ou=people,ou=PrinterLosesMember,ou=DasTestDep,o=Landeshauptstad', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1621 (16, 'cn=abtielung abtielung,ou=people,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '7890', 'normal', '', 'no', NULL, 'no', ''),
1622 (17, 'cn=Franz Keller,ou=people,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', 'ableis@gonicus.de', NULL, 'normal', '', 'no', NULL, 'no', ''),
1623 (18, 'cn=Jan Wenzel,ou=people,o=Landeshauptstadt München,c=de', '', '', '', NULL, 'normal', '', 'no', NULL, 'no', ''),
1624 (19, 'cn=acl2 acl2,ou=people,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', '', '22222222222222', 'normal', '', 'no', NULL, 'no', ''),
1625 (20, 'cn=a11 a11,ou=people,ou=DasTestDep,o=Landeshauptstadt München,c=de', '', '', 'a11@gonicus.de', '311112', 'normal', '', 'no', NULL, 'no', ''),
1626 (21, 'cn=Admin Admin,ou=people,o=Landeshauptstadt München,c=de', '', '', 'ableis@gonicus.de', '1234', 'normal', '', 'no', NULL, 'no', '');