Viewing File sql/schema.sql of 0.00.0a
|
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: PRIMARY KEY (`customerid`) 30: ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; 31: /*!40101 SET character_set_client = @saved_cs_client */; 32: 33: -- 34: -- Table structure for table `permgroup` 35: -- 36: 37: /*!40101 SET @saved_cs_client = @@character_set_client */; 38: /*!40101 SET character_set_client = utf8 */; 39: CREATE TABLE `permgroup` ( 40: `permgroupid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 41: `groupname` varchar(254) NOT NULL, 42: PRIMARY KEY (`permgroupid`) 43: ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; 44: /*!40101 SET character_set_client = @saved_cs_client */; 45: 46: -- 47: -- Table structure for table `permissions` 48: -- 49: 50: /*!40101 SET @saved_cs_client = @@character_set_client */; 51: /*!40101 SET character_set_client = utf8 */; 52: CREATE TABLE `permissions` ( 53: `permissionid` bigint(20) NOT NULL AUTO_INCREMENT, 54: `permissiontype` varchar(16) NOT NULL, 55: `permission` varchar(254) NOT NULL, 56: `usergroupid` varchar(254) NOT NULL, 57: `allowed` tinyint(4) NOT NULL, 58: PRIMARY KEY (`permissionid`), 59: KEY `permissiontype` (`permissiontype`,`permission`,`usergroupid`) 60: ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1; 61: /*!40101 SET character_set_client = @saved_cs_client */; 62: 63: -- 64: -- Table structure for table `plugins` 65: -- 66: 67: /*!40101 SET @saved_cs_client = @@character_set_client */; 68: /*!40101 SET character_set_client = utf8 */; 69: CREATE TABLE `plugins` ( 70: `pluginid` bigint(20) NOT NULL AUTO_INCREMENT, 71: `plugin` varchar(254) NOT NULL, 72: `active` int(11) NOT NULL DEFAULT '0', 73: PRIMARY KEY (`pluginid`), 74: KEY `active` (`active`) 75: ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; 76: /*!40101 SET character_set_client = @saved_cs_client */; 77: 78: -- 79: -- Table structure for table `request` 80: -- 81: 82: /*!40101 SET @saved_cs_client = @@character_set_client */; 83: /*!40101 SET character_set_client = utf8 */; 84: CREATE TABLE `request` ( 85: `requestid` bigint(20) NOT NULL AUTO_INCREMENT, 86: `customer` bigint(20) NOT NULL, 87: `assignteam` bigint(20) NOT NULL, 88: `assignuser` varchar(254) NOT NULL, 89: `class` int(11) NOT NULL, 90: `openeddt` datetime NOT NULL, 91: `status` int(11) NOT NULL, 92: PRIMARY KEY (`requestid`), 93: KEY `customer` (`customer`,`assignteam`,`assignuser`,`status`) 94: ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; 95: /*!40101 SET character_set_client = @saved_cs_client */; 96: 97: -- 98: -- Table structure for table `requestclass` 99: -- 100: 101: /*!40101 SET @saved_cs_client = @@character_set_client */; 102: /*!40101 SET character_set_client = utf8 */; 103: CREATE TABLE `requestclass` ( 104: `classid` int(10) unsigned NOT NULL AUTO_INCREMENT, 105: `classname` varchar(254) NOT NULL, 106: `classclass` varchar(254) NOT NULL, 107: PRIMARY KEY (`classid`) 108: ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; 109: /*!40101 SET character_set_client = @saved_cs_client */; 110: 111: -- 112: -- Table structure for table `session` 113: -- 114: 115: /*!40101 SET @saved_cs_client = @@character_set_client */; 116: /*!40101 SET character_set_client = utf8 */; 117: CREATE TABLE `session` ( 118: `session_id` varchar(254) NOT NULL, 119: `username` varchar(254) NOT NULL, 120: `sessiontype` int(11) NOT NULL DEFAULT '-1', 121: `created_dt` datetime NOT NULL, 122: `updated_dt` datetime NOT NULL, 123: `expires_dt` datetime NOT NULL, 124: `realname` varchar(254) NOT NULL, 125: PRIMARY KEY (`session_id`) 126: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 127: /*!40101 SET character_set_client = @saved_cs_client */; 128: 129: -- 130: -- Table structure for table `status` 131: -- 132: 133: /*!40101 SET @saved_cs_client = @@character_set_client */; 134: /*!40101 SET character_set_client = utf8 */; 135: CREATE TABLE `status` ( 136: `status` int(11) NOT NULL, 137: `description` varchar(254) NOT NULL, 138: PRIMARY KEY (`status`) 139: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 140: /*!40101 SET character_set_client = @saved_cs_client */; 141: 142: -- 143: -- Table structure for table `sysconfig` 144: -- 145: 146: /*!40101 SET @saved_cs_client = @@character_set_client */; 147: /*!40101 SET character_set_client = utf8 */; 148: CREATE TABLE `sysconfig` ( 149: `sc_option` varchar(254) NOT NULL, 150: `sc_value` varchar(254) NOT NULL, 151: PRIMARY KEY (`sc_option`), 152: UNIQUE KEY `sc_option` (`sc_option`) 153: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 154: /*!40101 SET character_set_client = @saved_cs_client */; 155: 156: -- 157: -- Table structure for table `syslog` 158: -- 159: 160: /*!40101 SET @saved_cs_client = @@character_set_client */; 161: /*!40101 SET character_set_client = utf8 */; 162: CREATE TABLE `syslog` ( 163: `event_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 164: `event_dt` datetime NOT NULL, 165: `event` varchar(254) NOT NULL, 166: `event_class` varchar(128) NOT NULL, 167: `event_type` varchar(128) NOT NULL, 168: `event_level` int(11) NOT NULL, 169: PRIMARY KEY (`event_id`) 170: ) ENGINE=InnoDB AUTO_INCREMENT=7579 DEFAULT CHARSET=latin1; 171: /*!40101 SET character_set_client = @saved_cs_client */; 172: 173: -- 174: -- Table structure for table `team` 175: -- 176: 177: /*!40101 SET @saved_cs_client = @@character_set_client */; 178: /*!40101 SET character_set_client = utf8 */; 179: CREATE TABLE `team` ( 180: `teamid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 181: `teamname` varchar(254) NOT NULL, 182: PRIMARY KEY (`teamid`) 183: ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; 184: /*!40101 SET character_set_client = @saved_cs_client */; 185: 186: -- 187: -- Table structure for table `teamuserlink` 188: -- 189: 190: /*!40101 SET @saved_cs_client = @@character_set_client */; 191: /*!40101 SET character_set_client = utf8 */; 192: CREATE TABLE `teamuserlink` ( 193: `linkid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 194: `teamid` bigint(20) unsigned NOT NULL, 195: `username` varchar(254) NOT NULL, 196: PRIMARY KEY (`linkid`), 197: KEY `teamid` (`teamid`,`username`) 198: ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1; 199: /*!40101 SET character_set_client = @saved_cs_client */; 200: 201: -- 202: -- Table structure for table `update` 203: -- 204: 205: /*!40101 SET @saved_cs_client = @@character_set_client */; 206: /*!40101 SET character_set_client = utf8 */; 207: CREATE TABLE `update` ( 208: `updateid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 209: `requestid` bigint(20) unsigned NOT NULL, 210: `update` text NOT NULL, 211: `public` tinyint(4) NOT NULL, 212: `updateby` varchar(254) NOT NULL, 213: `updatedt` datetime NOT NULL, 214: PRIMARY KEY (`updateid`), 215: KEY `requestid` (`requestid`) 216: ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=latin1; 217: /*!40101 SET character_set_client = @saved_cs_client */; 218: 219: -- 220: -- Table structure for table `user` 221: -- 222: 223: /*!40101 SET @saved_cs_client = @@character_set_client */; 224: /*!40101 SET character_set_client = utf8 */; 225: CREATE TABLE `user` ( 226: `username` varchar(254) NOT NULL, 227: `password` varchar(254) NOT NULL, 228: `realname` varchar(254) NOT NULL, 229: `email` varchar(254) NOT NULL, 230: `permgroup` bigint(20) unsigned NOT NULL, 231: `authtype` varchar(254) NOT NULL, 232: `sparefield0` varchar(254) NOT NULL, 233: `sparefield1` varchar(254) NOT NULL, 234: `sparefield2` varchar(254) NOT NULL, 235: `sparefield3` varchar(254) NOT NULL, 236: `sparefield4` varchar(254) NOT NULL, 237: `sparefield5` varchar(254) NOT NULL, 238: `sparefield6` varchar(254) NOT NULL, 239: `sparefield7` varchar(254) NOT NULL, 240: `sparefield8` varchar(254) NOT NULL, 241: `sparefield9` varchar(254) NOT NULL, 242: PRIMARY KEY (`username`) 243: ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 244: /*!40101 SET character_set_client = @saved_cs_client */; 245: /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 246: 247: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 248: /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 249: /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 250: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 251: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 252: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 253: /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 254: 255: -- Dump completed on 2012-07-03 1:43:33 256: