Bonjour,
Index des tables d'orders
Cordialement,
David DURIEUX
Tel : 04.74.04.81.34
Port : 06.18.42.55.27
Mail : [EMAIL PROTECTED]
Site Web : http://www.siprossii.com/
SIPROSSII
509 rue d'Anse
69400 Villefranche sur Saône
DROP TABLE IF EXISTS `glpi_plugin_orders`;
CREATE TABLE `glpi_plugin_orders` (
`ID` int(11) NOT NULL auto_increment,
`FK_entities` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`Request_Date` date NOT NULL default '0000-00-00',
`Requester_ID` int(11) NOT NULL default '0',
`Request_Text` text,
`Wished_Date` date NOT NULL default '0000-00-00',
`Validation_Date` date NOT NULL default '0000-00-00',
`Validator_ID` int(11) NOT NULL default '0',
`Validation_Text` text,
`Order_Date` date NOT NULL default '0000-00-00',
`Orderer_ID` int(11) NOT NULL default '0',
`Order_Text` text,
`state` varchar(50) NOT NULL default 'waiting',
`ArrivedOrder_Date` date NOT NULL default '0000-00-00',
`ArrivedOrderer_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `Request_Date` (`Request_Date`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `glpi_plugin_orders_items`;
CREATE TABLE `glpi_plugin_orders_items` (
`ID` int(11) NOT NULL auto_increment,
`Order_ID` int(11) NOT NULL default '0',
`type` int(4) NOT NULL default '0',
`device_type` int(4) NOT NULL default '0',
`quantity` int(4) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `Order_ID` (`Order_ID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `glpi_plugin_orders_profiles`;
CREATE TABLE `glpi_plugin_orders_profiles` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`interface` varchar(50) NOT NULL default 'orders',
`is_default` smallint(6) NOT NULL default '0',
`orders` char(1) default NULL,
`create_orders` char(1) default NULL,
`update_orders` char(1) default NULL,
`delete_orders` char(1) default NULL,
`validate_orders` char(1) default NULL,
`confirm_orders` char(1) default NULL,
`receive_orders` char(1) default NULL,
`restore_orders` char(1) default NULL,
`all_orders` char(1) default NULL,
PRIMARY KEY (`ID`),
KEY `interface` (`interface`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `glpi_plugin_orders_mailing`;
CREATE TABLE `glpi_plugin_orders_mailing` (
`ID` int(11) NOT NULL auto_increment,
`active` smallint(6) NOT NULL default '0',
`send_user` smallint(6) NOT NULL default '0',
`send_validator` smallint(6) NOT NULL default '0',
`send_confirmed` smallint(6) NOT NULL default '0',
`send_arrived` smallint(6) NOT NULL default '0',
`title_mailing` varchar(50) NOT NULL default '',
`body_mailing` text,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
INSERT INTO `glpi_plugin_orders_mailing` VALUES (1, '0', '0', '0', '0', '0', '', '');
_______________________________________________
Glpi-dev mailing list
Glpi-dev@gna.org
https://mail.gna.org/listinfo/glpi-dev
