Viewing File sql/schema.sql of 0.01.1a
|
1: -- MySQL dump 10.13 Distrib 5.5.24, for Linux (i686) 2: -- 3: -- Host: localhost Database: freedesk 4: -- ------------------------------------------------------ 5: -- Server version 5.5.24 6: 7: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 8: /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 9: /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 10: /*!40101 SET NAMES utf8 */; 11: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 12: /*!40103 SET TIME_ZONE='+00:00' */; 13: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 14: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 15: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 16: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 17: 18: -- 19: -- Table structure for table `customer` 20: -- 21: 22: /*!40101 SET @saved_cs_client = @@character_set_client */; 23: /*!40101 SET character_set_client = utf8 */; 24: CREATE TABLE `customer` ( 25: `customerid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 26: `firstname` varchar(254) NOT NULL, 27: `lastname` varchar(254) NOT NULL, 28: `email` varchar(254) NOT NULL, 29: `username` varchar(254) NOT NULL, 30: `password` varchar(254) NOT NULL, 31: PRIMARY KEY (`customerid`) 32: ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; 33: /*!40101 SET character_set_client = @saved_cs_client */; 34: 35: -- 36: -- Table structure for table `email` 37: -- 38: 39: /*!40101 SET @saved_cs_client = @@character_set_client */; 40: /*!40101 SET character_set_client = utf8 */; 41: CREATE TABLE `email` ( 42: `accountid` mediumint(9) NOT NULL AUTO_INCREMENT, 43: `name` varchar(254) NOT NULL, 44: `host` varchar(254) NOT NULL, 45: `from` varchar(254) NOT NULL, 46: `fromname` varchar(254) NOT NULL, 47: `wordwrap` int(11) NOT NULL, 48: `auth` int(11) NOT NULL, 49: `username` varchar(254) NOT NULL, 50: `password` varchar(254) NOT NULL, 51: `smtpsec` varchar(128) NOT NULL, 52: PRIMARY KEY (`accountid`) 53: ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; 54: /*!40101 SET character_set_client = @saved_cs_client */; 55: 56: -- 57: -- Table structure for table `permgroup` 58: -- 59: 60: /*!40101 SET @saved_cs_client = @@character_set_client */; 61: /*!40101 SET character_set_client = utf8 */; 62: CREATE TABLE `permgroup` ( 63: `permgroupid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 64: `groupname` varchar(254) NOT NULL, 65: PRIMARY KEY (`permgroupid`) 66: ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; 67: /*!40101 SET character_set_client = @saved_cs_client */; 68: 69: -- 70: -- Table structure for table `permissions` 71: -- 72: 73: /*!40101 SET @saved_cs_client = @@character_set_client */; 74: /*!40101 SET character_set_client = utf8 */; 75: CREATE TABLE `permissions` ( 76: `permissionid` bigint(20) NOT NULL AUTO_INCREMENT, 77: `permissiontype` varchar(16) NOT NULL, 78: `permission` varchar(254) NOT NULL, 79: `usergroupid` varchar(254) NOT NULL, 80: `allowed` tinyint(4) NOT NULL, 81: PRIMARY KEY (`permissionid`), 82: KEY `permissiontype` (`permissiontype`,`permission`,`usergroupid`) 83: ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1; 84: /*!40101 SET character_set_client = @saved_cs_client */; 85: 86: -- 87: -- Table structure for table `plugins` 88: -- 89: 90: /*!40101 SET @saved_cs_client = @@character_set_client */; 91: /*!40101 SET character_set_client = utf8 */; 92: CREATE TABLE `plugins` ( 93: `pluginid` bigint(20) NOT NULL AUTO_INCREMENT, 94: `plugin` varchar(254) NOT NULL, 95: `active` int(11) NOT NULL DEFAULT '0', 96: PRIMARY KEY (`pluginid`), 97: KEY `active` (`active`) 98: ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; 99: /*!40101 SET character_set_client = @saved_cs_client */; 100: 101: -- 102: -- Table structure for table `priority` 103: -- 104: 105: /*!40101 SET @saved_cs_client = @@character_set_client */; 106: /*!40101 SET character_set_client = utf8 */; 107: CREATE TABLE `priority` ( 108: `priorityid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 109: `priorityname` varchar(128) NOT NULL, 110: `resolutionsla` bigint(20) NOT NULL, 111: `schedule` int(11) NOT NULL, 112: PRIMARY KEY (`priorityid`) 113: ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; 114: /*!40101 SET character_set_client = @saved_cs_client */; 115: 116: -- 117: -- Table structure for table `request` 118: -- 119: 120: /*!40101 SET @saved_cs_client = @@character_set_client */; 121: /*!40101 SET character_set_client = utf8 */; 122: CREATE TABLE `request` ( 123: `requestid` bigint(20) NOT NULL AUTO_INCREMENT, 124: `customer` bigint(20) NOT NULL, 125: `assignteam` bigint(20) NOT NULL, 126: `assignuser` varchar(254) NOT NULL, 127: `class` int(11) NOT NULL, 128: `openeddt` datetime NOT NULL, 129: `status` int(11) NOT NULL, 130: `priority` int(11) NOT NULL, 131: `closeddt` datetime NOT NULL, 132: PRIMARY KEY (`requestid`), 133: KEY `customer` (`customer`,`assignteam`,`assignuser`,`status`) 134: ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=latin1; 135: /*!40101 SET character_set_client = @saved_cs_client */; 136: 137: -- 138: -- Table structure for table `requestclass` 139: -- 140: 141: /*!40101 SET @saved_cs_client = @@character_set_client */; 142: /*!40101 SET character_set_client = utf8 */; 143: CREATE TABLE `requestclass` ( 144: `classid` int(10) unsigned NOT NULL AUTO_INCREMENT, 145: `classname` varchar(254) NOT NULL, 146: `classclass` varchar(254) NOT NULL, 147: PRIMARY KEY (`classid`) 148: ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; 149: /*!40101 SET character_set_client = @saved_cs_client */; 150: 151: -- 152: -- Table structure for table `session` 153: -- 154: 155: /*!40101 SET @saved_cs_client = @@character_set_client */; 156: /*!40101 SET character_set_client = utf8 */; 157: CREATE TABLE `session` ( 158: `session_id` varchar(254) NOT NULL, 159: `username` varchar(254) NOT NULL, 160: `sessiontype` int(11) NOT NULL DEFAULT '-1', 161: `created_dt` datetime NOT NULL, 162: `updated_dt` datetime NOT NULL, 163: `expires_dt` datetime NOT NULL, 164: `realname` varchar(254) NOT NULL, 165: PRIMARY KEY (`session_id`) 166: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 167: /*!40101 SET character_set_client = @saved_cs_client */; 168: 169: -- 170: -- Table structure for table `status` 171: -- 172: 173: /*!40101 SET @saved_cs_client = @@character_set_client */; 174: /*!40101 SET character_set_client = utf8 */; 175: CREATE TABLE `status` ( 176: `status` int(11) NOT NULL, 177: `description` varchar(254) NOT NULL, 178: PRIMARY KEY (`status`) 179: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 180: /*!40101 SET character_set_client = @saved_cs_client */; 181: 182: -- 183: -- Table structure for table `sysconfig` 184: -- 185: 186: /*!40101 SET @saved_cs_client = @@character_set_client */; 187: /*!40101 SET character_set_client = utf8 */; 188: CREATE TABLE `sysconfig` ( 189: `sc_option` varchar(254) NOT NULL, 190: `sc_value` varchar(254) NOT NULL, 191: PRIMARY KEY (`sc_option`), 192: UNIQUE KEY `sc_option` (`sc_option`) 193: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 194: /*!40101 SET character_set_client = @saved_cs_client */; 195: 196: -- 197: -- Table structure for table `syslog` 198: -- 199: 200: /*!40101 SET @saved_cs_client = @@character_set_client */; 201: /*!40101 SET character_set_client = utf8 */; 202: CREATE TABLE `syslog` ( 203: `event_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 204: `event_dt` datetime NOT NULL, 205: `event` varchar(254) NOT NULL, 206: `event_class` varchar(128) NOT NULL, 207: `event_type` varchar(128) NOT NULL, 208: `event_level` int(11) NOT NULL, 209: PRIMARY KEY (`event_id`) 210: ) ENGINE=InnoDB AUTO_INCREMENT=41253 DEFAULT CHARSET=latin1; 211: /*!40101 SET character_set_client = @saved_cs_client */; 212: 213: -- 214: -- Table structure for table `team` 215: -- 216: 217: /*!40101 SET @saved_cs_client = @@character_set_client */; 218: /*!40101 SET character_set_client = utf8 */; 219: CREATE TABLE `team` ( 220: `teamid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 221: `teamname` varchar(254) NOT NULL, 222: PRIMARY KEY (`teamid`) 223: ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; 224: /*!40101 SET character_set_client = @saved_cs_client */; 225: 226: -- 227: -- Table structure for table `teamuserlink` 228: -- 229: 230: /*!40101 SET @saved_cs_client = @@character_set_client */; 231: /*!40101 SET character_set_client = utf8 */; 232: CREATE TABLE `teamuserlink` ( 233: `linkid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 234: `teamid` bigint(20) unsigned NOT NULL, 235: `username` varchar(254) NOT NULL, 236: PRIMARY KEY (`linkid`), 237: KEY `teamid` (`teamid`,`username`) 238: ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; 239: /*!40101 SET character_set_client = @saved_cs_client */; 240: 241: -- 242: -- Table structure for table `templates` 243: -- 244: 245: /*!40101 SET @saved_cs_client = @@character_set_client */; 246: /*!40101 SET character_set_client = utf8 */; 247: CREATE TABLE `templates` ( 248: `templateid` varchar(128) NOT NULL, 249: `subject` text NOT NULL, 250: `body` text NOT NULL, 251: PRIMARY KEY (`templateid`) 252: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 253: /*!40101 SET character_set_client = @saved_cs_client */; 254: 255: -- 256: -- Table structure for table `update` 257: -- 258: 259: /*!40101 SET @saved_cs_client = @@character_set_client */; 260: /*!40101 SET character_set_client = utf8 */; 261: CREATE TABLE `update` ( 262: `updateid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 263: `requestid` bigint(20) unsigned NOT NULL, 264: `update` text NOT NULL, 265: `public` tinyint(4) NOT NULL, 266: `updateby` varchar(254) NOT NULL, 267: `updatedt` datetime NOT NULL, 268: PRIMARY KEY (`updateid`), 269: KEY `requestid` (`requestid`) 270: ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1; 271: /*!40101 SET character_set_client = @saved_cs_client */; 272: 273: -- 274: -- Table structure for table `user` 275: -- 276: 277: /*!40101 SET @saved_cs_client = @@character_set_client */; 278: /*!40101 SET character_set_client = utf8 */; 279: CREATE TABLE `user` ( 280: `username` varchar(254) NOT NULL, 281: `password` varchar(254) NOT NULL, 282: `realname` varchar(254) NOT NULL, 283: `email` varchar(254) NOT NULL, 284: `permgroup` bigint(20) unsigned NOT NULL, 285: `authtype` varchar(254) NOT NULL, 286: `sparefield0` varchar(254) NOT NULL, 287: `sparefield1` varchar(254) NOT NULL, 288: `sparefield2` varchar(254) NOT NULL, 289: `sparefield3` varchar(254) NOT NULL, 290: `sparefield4` varchar(254) NOT NULL, 291: `sparefield5` varchar(254) NOT NULL, 292: `sparefield6` varchar(254) NOT NULL, 293: `sparefield7` varchar(254) NOT NULL, 294: `sparefield8` varchar(254) NOT NULL, 295: `sparefield9` varchar(254) NOT NULL, 296: PRIMARY KEY (`username`) 297: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 298: /*!40101 SET character_set_client = @saved_cs_client */; 299: 300: -- 301: -- Table structure for table `vis_country` 302: -- 303: 304: /*!40101 SET @saved_cs_client = @@character_set_client */; 305: /*!40101 SET character_set_client = utf8 */; 306: CREATE TABLE `vis_country` ( 307: `country` char(2) NOT NULL DEFAULT '', 308: `country_desc` varchar(120) NOT NULL DEFAULT '', 309: `lat` float DEFAULT NULL, 310: `long` float DEFAULT NULL, 311: KEY `country_desc` (`country_desc`), 312: KEY `country` (`country`) 313: ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 314: /*!40101 SET character_set_client = @saved_cs_client */; 315: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 316: 317: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 318: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 319: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 320: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 321: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 322: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 323: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 324: 325: -- Dump completed on 2012-08-22 1:31:09 326: