| 1 |
-- MySQL dump 10.9
|
| 2 |
--
|
| 3 |
-- Copyright OSI 2005. Licensed under GPL version 2.
|
| 4 |
-- $Id$
|
| 5 |
--
|
| 6 |
-- Host: localhost Database: audeandrupal
|
| 7 |
-- ------------------------------------------------------
|
| 8 |
-- Server version 4.1.13-nt
|
| 9 |
|
| 10 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
| 11 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
| 12 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
| 13 |
/*!40101 SET NAMES utf8 */;
|
| 14 |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
| 15 |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
| 16 |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
| 17 |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
| 18 |
|
| 19 |
--
|
| 20 |
-- Table structure for table `hd_timeinfo`
|
| 21 |
--
|
| 22 |
|
| 23 |
DROP TABLE IF EXISTS `hd_timeinfo`;
|
| 24 |
CREATE TABLE `hd_timeinfo` (
|
| 25 |
`timeid` int(10) unsigned NOT NULL default '0',
|
| 26 |
`stime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
|
| 27 |
`atime` timestamp NOT NULL default '0000-00-00 00:00:00',
|
| 28 |
`mtime` timestamp NOT NULL default '0000-00-00 00:00:00',
|
| 29 |
`etime` timestamp NOT NULL default '0000-00-00 00:00:00',
|
| 30 |
PRIMARY KEY (`timeid`)
|
| 31 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk Module: Start/Access/Modification/End times.';
|
| 32 |
|
| 33 |
--
|
| 34 |
-- Dumping data for table `hd_timeinfo`
|
| 35 |
--
|
| 36 |
|
| 37 |
|
| 38 |
/*!40000 ALTER TABLE `hd_timeinfo` DISABLE KEYS */;
|
| 39 |
LOCK TABLES `hd_timeinfo` WRITE;
|
| 40 |
INSERT INTO `hd_timeinfo` VALUES (1,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00');
|
| 41 |
UNLOCK TABLES;
|
| 42 |
/*!40000 ALTER TABLE `hd_timeinfo` ENABLE KEYS */;
|
| 43 |
|
| 44 |
--
|
| 45 |
-- Table structure for table `hd_user`
|
| 46 |
--
|
| 47 |
|
| 48 |
DROP TABLE IF EXISTS `hd_user`;
|
| 49 |
CREATE TABLE `hd_user` (
|
| 50 |
`uid` int(10) NOT NULL default '0',
|
| 51 |
`uidcustomer` int(10) default NULL,
|
| 52 |
PRIMARY KEY (`uid`)
|
| 53 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk module: users and customers';
|
| 54 |
|
| 55 |
--
|
| 56 |
-- Dumping data for table `hd_user`
|
| 57 |
--
|
| 58 |
|
| 59 |
|
| 60 |
/*!40000 ALTER TABLE `hd_user` DISABLE KEYS */;
|
| 61 |
LOCK TABLES `hd_user` WRITE;
|
| 62 |
INSERT INTO `hd_user` VALUES (4,2),(5,5);
|
| 63 |
UNLOCK TABLES;
|
| 64 |
/*!40000 ALTER TABLE `hd_user` ENABLE KEYS */;
|
| 65 |
|
| 66 |
--
|
| 67 |
-- Table structure for table `hd_event`
|
| 68 |
--
|
| 69 |
|
| 70 |
DROP TABLE IF EXISTS `hd_event`;
|
| 71 |
CREATE TABLE `hd_event` (
|
| 72 |
`nid` int(10) unsigned NOT NULL default '0',
|
| 73 |
`timeid` int(10) unsigned NOT NULL default '0',
|
| 74 |
`description` text NOT NULL,
|
| 75 |
`contractid` int(10) default NULL,
|
| 76 |
`txnid` int(10) unsigned default NULL,
|
| 77 |
`nidparent` int(10) unsigned NOT NULL default '0',
|
| 78 |
`nidroot` int(10) unsigned NOT NULL default '0',
|
| 79 |
`tidseverity` int(10) unsigned NOT NULL default '0',
|
| 80 |
`tidstatus` int(10) unsigned NOT NULL default '0',
|
| 81 |
`uidtech` int(10) unsigned default NULL,
|
| 82 |
`tempcontact` text,
|
| 83 |
`attachment` mediumblob,
|
| 84 |
PRIMARY KEY (`nid`)
|
| 85 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk module: Ticket and followup events';
|
| 86 |
|
| 87 |
--
|
| 88 |
-- Dumping data for table `hd_event`
|
| 89 |
--
|
| 90 |
|
| 91 |
|
| 92 |
/*!40000 ALTER TABLE `hd_event` DISABLE KEYS */;
|
| 93 |
LOCK TABLES `hd_event` WRITE;
|
| 94 |
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);
|
| 95 |
UNLOCK TABLES;
|
| 96 |
/*!40000 ALTER TABLE `hd_event` ENABLE KEYS */;
|
| 97 |
|
| 98 |
--
|
| 99 |
-- Table structure for table `hd_contract`
|
| 100 |
--
|
| 101 |
|
| 102 |
DROP TABLE IF EXISTS `hd_contract`;
|
| 103 |
CREATE TABLE `hd_contract` (
|
| 104 |
`nid` int(10) NOT NULL default '0',
|
| 105 |
`timeid` int(10) NOT NULL default '0',
|
| 106 |
`uidcustomer` int(10) NOT NULL default '0',
|
| 107 |
`maxdate` datetime default NULL,
|
| 108 |
`maxtime` int(10) default NULL,
|
| 109 |
`maxissue` int(10) default NULL,
|
| 110 |
`usemaxdate` tinyint(1) NOT NULL default '0',
|
| 111 |
`usemaxtime` tinyint(1) NOT NULL default '0',
|
| 112 |
`usemaxissue` tinyint(1) NOT NULL default '0',
|
| 113 |
`deftimeincrement` int(10) default '1',
|
| 114 |
`issuspended` int(1) NOT NULL default '0',
|
| 115 |
PRIMARY KEY (`nid`)
|
| 116 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Helpdesk module : contract parameters';
|
| 117 |
|
| 118 |
--
|
| 119 |
-- Dumping data for table `hd_contract`
|
| 120 |
--
|
| 121 |
|
| 122 |
|
| 123 |
/*!40000 ALTER TABLE `hd_contract` DISABLE KEYS */;
|
| 124 |
LOCK TABLES `hd_contract` WRITE;
|
| 125 |
UNLOCK TABLES;
|
| 126 |
/*!40000 ALTER TABLE `hd_contract` ENABLE KEYS */;
|
| 127 |
|
| 128 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
| 129 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
| 130 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
| 131 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
| 132 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
| 133 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
| 134 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
| 135 |
|
Parent Directory
| 
Revision Log
| 
Revision Graph