MultiGLPi Specifications » History » Version 1

walid, 05/18/2011 06:35 PM

1 1 walid
h1. MultiGLPi Specifications
2 1 walid
3 1 walid
h2. Dependancies
4 1 walid
5 1 walid
This plugin will work with :
6 1 walid
* GLPI 0.80 and higher
7 1 walid
* WebServices plugin version 1.1.0 and higher
8 1 walid
9 1 walid
h2. Uses cases 
10 1 walid
11 1 walid
* Unidirectionnal synchronization between one central and several local GLPI
12 1 walid
* Bidirectionnal synchronization between or more GLPI
13 1 walid
14 1 walid
h2. Workflow
15 1 walid
16 1 walid
h2. Tables
17 1 walid
18 1 walid
h3. Slave GLPI servers
19 1 walid
20 1 walid
<pre>
21 1 walid
DROP TABLE IF EXISTS `glpi_plugin_multiglpi_servers`;
22 1 walid
CREATE TABLE IF NOT EXISTS `glpi_plugin_multiglpi_servers` (
23 1 walid
  `id` int(11) NOT NULL auto_increment,
24 1 walid
  `name` varchar(255) collate utf8_unicode_ci default NULL,
25 1 walid
  `host` varchar(255) collate utf8_unicode_ci default NULL,
26 1 walid
  `url` varchar(255) collate utf8_unicode_ci default NULL,
27 1 walid
  `ws_user` varchar(50) collate utf8_unicode_ci default NULL,
28 1 walid
  `ws_pass` varchar(50) collate utf8_unicode_ci default NULL,
29 1 walid
  `glpi_user` varchar(50) collate utf8_unicode_ci default NULL,
30 1 walid
  `glpi_pass` varchar(50) collate utf8_unicode_ci default NULL,
31 1 walid
  `is_active` TINYINT NOT NULL default '0', //Activate or not this slave
32 1 walid
  `protocols_id` TINYINT NOT NULL default '1',
33 1 walid
  `entities_id_base` TINYINT NOT NULL default '0', //Source entity ID
34 1 walid
  `is_deflate` TINYINT NOT NULL default '0',
35 1 walid
  `session` varchar(255) collate utf8_unicode_ci default NULL,  
36 1 walid
  `comment` text collate utf8_unicode_ci,
37 1 walid
   PRIMARY KEY  (`id`)
38 1 walid
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
39 1 walid
</pre>
40 1 walid
41 1 walid
h3. Changelog table
42 1 walid
43 1 walid
This table logs all changes in the local GLPI. Will be used by a remote GLPI to get changes since last synchronization.
44 1 walid
45 1 walid
<pre>
46 1 walid
DROP TABLE IF EXISTS `glpi_plugin_multiglpi_logs`;
47 1 walid
CREATE TABLE IF NOT EXISTS `glpi_plugin_multiglpi_logs` (
48 1 walid
     `id` int(11) NOT NULL auto_increment,
49 1 walid
     `items_id` int(11) NOT NULL auto_increment,
50 1 walid
     `itemtype` varchar(50) collate utf8_unicode_ci default NULL,
51 1 walid
     `change_type` varchar(50) collate utf8_unicode_ci default NULL, //[add|update|delete|purge]
52 1 walid
     `change_date` datetime NOT NULL,
53 1 walid
   PRIMARY KEY  (`id`)
54 1 walid
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
55 1 walid
</pre>
56 1 walid
57 1 walid
h3. Links table
58 1 walid
59 1 walid
This table link an unique object in the source and remote GLPI
60 1 walid
<pre>
61 1 walid
DROP TABLE IF EXISTS `glpi_plugin_multiglpi_links`;
62 1 walid
CREATE TABLE IF NOT EXISTS `glpi_plugin_multiglpi_links` (
63 1 walid
     `id` int(11) NOT NULL auto_increment,    
64 1 walid
     `masters_id` int(11) NOT NULL auto_increment, //ID in the master GLPI
65 1 walid
     `slaves_id` int(11) NOT NULL auto_increment, //ID in the slave GLPI
66 1 walid
     `itemtype` varchar(50) collate utf8_unicode_ci default NULL, //Object's itemtype
67 1 walid
   PRIMARY KEY  (`id`)
68 1 walid
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
69 1 walid
</pre>