User Tools

Site Tools


hd:mysql

This is an old revision of the document!


MySQL implementation of the helpdesk tables

The logical model from which this is derived is listed on the Requirements page.

--
-- Table structure for table `hd_timeinfo`
--
 
DROP TABLE IF EXISTS `hd_timeinfo`;
CREATE TABLE `hd_timeinfo` (
  `timeid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `stime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `atime` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `mtime` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `etime` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY  (`timeid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk Module: Start/Access/Modification/End times.';
 
--
-- Dumping data for table `hd_timeinfo`
--
 
 
/*!40000 ALTER TABLE `hd_timeinfo` DISABLE KEYS */;
LOCK TABLES `hd_timeinfo` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `hd_timeinfo` ENABLE KEYS */;
 
--
-- Table structure for table `hd_user`
--
 
DROP TABLE IF EXISTS `hd_user`;
CREATE TABLE `hd_user` (
  `uid` INT(10) NOT NULL DEFAULT '0',
  `uidcustomer` INT(10) DEFAULT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk module: users and customers';
 
--
-- Dumping data for table `hd_user`
--
 
 
/*!40000 ALTER TABLE `hd_user` DISABLE KEYS */;
LOCK TABLES `hd_user` WRITE;
INSERT INTO `hd_user` VALUES (4,5),(5,5);
UNLOCK TABLES;
/*!40000 ALTER TABLE `hd_user` ENABLE KEYS */;
 
--
-- Table structure for table `hd_contract`
--
 
DROP TABLE IF EXISTS `hd_contract`;
CREATE TABLE `hd_contract` (
  `nid` INT(10) NOT NULL DEFAULT '0',
  `timeid` INT(10) NOT NULL DEFAULT '0',
  `uidcustomer` INT(10) NOT NULL DEFAULT '0',
  `maxdate` datetime DEFAULT NULL,
  `maxtime` datetime DEFAULT NULL,
  `maxissue` INT(10) DEFAULT NULL,
  `usemaxdate` tinyint(1) NOT NULL DEFAULT '0',
  `usemaxtime` tinyint(1) NOT NULL DEFAULT '0',
  `usemaxissue` tinyint(1) NOT NULL DEFAULT '0',
  `deftimeincrement` INT(10) DEFAULT '1',
  `issuspended` INT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk module : contract parameters';
 
--
-- Dumping data for table `hd_contract`
--
 
 
/*!40000 ALTER TABLE `hd_contract` DISABLE KEYS */;
LOCK TABLES `hd_contract` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `hd_contract` ENABLE KEYS */;
 
--
-- Table structure for table `hd_event`
--
 
DROP TABLE IF EXISTS `hd_event`;
CREATE TABLE `hd_event` (
  `nid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `timeid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `contractid` INT(10) DEFAULT NULL,
  `txnid` INT(10) UNSIGNED DEFAULT NULL,
  `nidparent` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `nidroot` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `tidseverity` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `tidstatus` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `uidtech` INT(10) UNSIGNED DEFAULT NULL,
  `tempcontact` text,
  `attachment` mediumblob,
  PRIMARY KEY  (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk module: Ticket and followup events';
 
--
-- Dumping data for table `hd_event`
--
 
 
/*!40000 ALTER TABLE `hd_event` DISABLE KEYS */;
LOCK TABLES `hd_event` WRITE;
INSERT INTO `hd_event` VALUES (45,0,'',NULL,NULL,45,45,0,44,NULL,NULL,NULL),(47,0,'',NULL,NULL,47,47,0,0,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `hd_event` ENABLE KEYS */;
hd/mysql.1127660822.txt.gz · Last modified: 2020/11/23 17:23 (external edit)