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