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