--
-- Base de données: `jade`
--

-- --------------------------------------------------------

--
-- Structure de la table `jade`
--

CREATE TABLE `COMPUTERS` (
  `MID` int(10) unsigned NOT NULL auto_increment,
  `NAME` varchar(255) NOT NULL default '',
  `IP` varchar(15) NOT NULL default '',
  `OID1` int(10) unsigned NOT NULL default '0',
  `OID2` int(10) unsigned default NULL,
  `OID3` int(10) unsigned default NULL,
  `OID4` int(10) unsigned default NULL,
  `OID5` int(10) unsigned default NULL,
   PRIMARY KEY  (`MID`)
) TYPE=MyISAM COMMENT='Liste des machines gérées.';

-- --------------------------------------------------------

--
-- Structure de la table `GROUPS`
--

CREATE TABLE `GROUPS` (
  `GID` int(10) unsigned NOT NULL auto_increment,
  `NAME` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`GID`)
) TYPE=MyISAM COMMENT='Liste des groupes';

-- --------------------------------------------------------

--
-- Structure de la table `HISTORY`
--

CREATE TABLE `HISTORY` (
  `DID` int(10) unsigned NOT NULL default '0',
  `MID` int(10) unsigned NOT NULL default '0',
  `PID` int(10) unsigned NOT NULL default '0',
  `MNAME` varchar(255) NOT NULL default '',
  `PNAME` varchar(255) NOT NULL default '',
  `STATE` int(11) NOT NULL default '-1'
) TYPE=MyISAM COMMENT='historique des installations';

-- --------------------------------------------------------

--
-- Structure de la table `INSTALLS`
--

CREATE TABLE `INSTALLS` (
  `DID` int(10) unsigned NOT NULL auto_increment,
  `PID` int(10) unsigned NOT NULL default '0',
  `PRIORITY` int(10) unsigned default '0',
  `DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `STATE` enum('active','inactive') NOT NULL default 'active',
   PRIMARY KEY  (`DID`)
) TYPE=MyISAM COMMENT='État des installations';

-- --------------------------------------------------------

--
-- Structure de la table `INSTALLSMEMBERS`
--

CREATE TABLE `INSTALLSMEMBERS` (
  `DID` int(10) unsigned NOT NULL default '0',
  `MID` int(10) unsigned default NULL,
  `GID` int(10) unsigned default NULL
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Structure de la table `MEMBERS`
--

CREATE TABLE `MEMBERS` (
  `GID` int(10) unsigned NOT NULL default '0',
  `MID` int(10) unsigned default NULL,
  `SGID` int(10) unsigned default NULL
) TYPE=MyISAM COMMENT='Liste des machines/groupes appartenant à un groupe';

-- --------------------------------------------------------

--
-- Structure de la table `OS`
--

CREATE TABLE `OS` (
  `OID` int(10) unsigned NOT NULL auto_increment,
  `NAME` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`OID`)
) TYPE=MyISAM COMMENT='Liste des OS utilisés.';

-- --------------------------------------------------------

--
-- Structure de la table `PACKS`
--

CREATE TABLE `PACKS` (
  `PID` int(10) unsigned NOT NULL auto_increment,
  `NAME` varchar(255) NOT NULL default '',
  `TYPE` enum('ftp','http') NOT NULL default 'ftp',
  `URL` varchar(255) NOT NULL default '',
  `FILE` varchar(255) default NULL,
  `LOGIN` varchar(255) default NULL,
  `PASSWORD` varchar(255) default NULL,
   PRIMARY KEY  (`PID`)
) TYPE=MyISAM COMMENT='Liste des paquets';

-- --------------------------------------------------------

--
-- Structure de la table `PACKSOS`
--

CREATE TABLE `PACKSOS` (
  `PID` int(10) unsigned NOT NULL default '0',
  `OID` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Associations OS<=>Packages';

-- --------------------------------------------------------

--
-- Structure de la table `USERS`
--

CREATE TABLE `USERS` (
  `UID` int(10) unsigned NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `LOGIN` varchar(10) NOT NULL default '',
  `PASSWORD` varchar(32) default NULL,
  `TYPE` enum('admin','deploy','view') NOT NULL default 'view',
   PRIMARY KEY  (`UID`)
) TYPE=MyISAM COMMENT='La liste des utilisateurs';

--
-- Premier utilisateur necessaire pour commencer à utiliser l'interface
--
INSERT INTO `USERS` (`NAME`, `LOGIN`, `PASSWORD`, `TYPE`) VALUES ('Administration', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin');