[Summary view] [Print] [Text view]

   1  -- Structure de la table `repairs`
   2  -- Table pour Maintenance.php
   3  
   4  CREATE TABLE IF NOT EXISTS `repairs` (
   5      `ID` bigint(20) unsigned NOT NULL auto_increment,
   6        `DEVICEID` varchar(255) NOT NULL default '',
   7            `NAME` varchar(255) default NULL,
   8          `REQDATE` datetime default NULL,
   9      `REQDESC` text,
  10      `ACTIONDATE` datetime default NULL,
  11      `ACTIONDESC` text,
  12      `WARANTY` varchar(255) default NULL,
  13      `ACCOUNT` varchar(255) default NULL,
  14      `PRICE` varchar(255) default NULL,
  15      `COMMENTS` text,
  16      `STATUT` int(2) NOT NULL default '0',
  17      `PRIORITE` varchar(50) NOT NULL default '',
  18      `ADMIN` varchar(50) NOT NULL default '',
  19       PRIMARY KEY  (`ID`),
  20       KEY `IDEVICEID` (`DEVICEID`)
  21  ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;