· 6 years ago · Jun 10, 2019, 02:28 AM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8
9███╗ ██╗███████╗██╗ ██╗███████╗███████╗ ██████╗
10████╗ ██║██╔════╝██║ ██║██╔════╝██╔════╝██╔════╝
11██╔██╗ ██║█████╗ ██║ █╗ ██║███████╗█████╗ ██║
12██║╚██╗██║██╔══╝ ██║███╗██║╚════██║██╔══╝ ██║
13██║ ╚████║███████╗╚███╔███╔╝███████║███████╗╚██████╗
14╚═╝ ╚═══╝╚══════╝ ╚══╝╚══╝ ╚══════╝╚══════╝ ╚═════╝
15
16-------------------------------------------------------------------------------------------------
17
18I am DemonSad <3
19
20Target : https://ufmg.br/ ( Universidade Federal De Minas Gerais )
21
22Greetings: TioSan, Angel, Cloudmore, NedLock, Menor
23
24-- ------------------------------------------------------------------------------------------------
25"HACKED BY : DEMONSAD"
26---------------------------------------------------------------------------------------------------
27
28
29/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
30/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
31/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
32/*!40101 SET NAMES utf8 */;
33/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
34/*!40103 SET TIME_ZONE='+00:00' */;
35/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
36/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
37/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
38/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
39
40--
41-- Current Database: `kayako_resolve`
42--
43
44CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kayako_resolve` /*!40100 DEFAULT CHARACTER SET latin1 */;
45
46USE `kayako_resolve`;
47
48--
49-- Table structure for table `swalertactions`
50--
51
52DROP TABLE IF EXISTS `swalertactions`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `swalertactions` (
56 `alertactionid` int(11) NOT NULL AUTO_INCREMENT,
57 `alertruleid` int(11) NOT NULL DEFAULT '0',
58 `actiontype` smallint(6) NOT NULL DEFAULT '0',
59 PRIMARY KEY (`alertactionid`),
60 KEY `alertactions1` (`actiontype`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `swalertactions`
66--
67
68LOCK TABLES `swalertactions` WRITE;
69/*!40000 ALTER TABLE `swalertactions` DISABLE KEYS */;
70/*!40000 ALTER TABLE `swalertactions` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `swalertrules`
75--
76
77DROP TABLE IF EXISTS `swalertrules`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `swalertrules` (
81 `alertruleid` int(11) NOT NULL AUTO_INCREMENT,
82 `alertscope` smallint(6) NOT NULL DEFAULT '0',
83 `staffid` int(11) NOT NULL DEFAULT '0',
84 `departmentid` int(11) NOT NULL DEFAULT '0',
85 `priorityid` int(11) NOT NULL DEFAULT '0',
86 `ticketstatusid` int(11) NOT NULL DEFAULT '0',
87 `alerttype` smallint(6) NOT NULL DEFAULT '0',
88 `execassign` smallint(6) NOT NULL DEFAULT '0',
89 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
90 PRIMARY KEY (`alertruleid`),
91 KEY `alertrules1` (`alertscope`,`staffid`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `swalertrules`
97--
98
99LOCK TABLES `swalertrules` WRITE;
100/*!40000 ALTER TABLE `swalertrules` DISABLE KEYS */;
101/*!40000 ALTER TABLE `swalertrules` ENABLE KEYS */;
102UNLOCK TABLES;
103
104--
105-- Table structure for table `swattachmentchunks`
106--
107
108DROP TABLE IF EXISTS `swattachmentchunks`;
109/*!40101 SET @saved_cs_client = @@character_set_client */;
110/*!40101 SET character_set_client = utf8 */;
111CREATE TABLE `swattachmentchunks` (
112 `chunkid` int(11) NOT NULL AUTO_INCREMENT,
113 `attachmentid` int(11) NOT NULL DEFAULT '0',
114 `contents` mediumblob NOT NULL,
115 `notbase64` smallint(6) NOT NULL DEFAULT '0',
116 PRIMARY KEY (`chunkid`),
117 KEY `attachmentchunks1` (`attachmentid`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `swattachmentchunks`
123--
124
125LOCK TABLES `swattachmentchunks` WRITE;
126/*!40000 ALTER TABLE `swattachmentchunks` DISABLE KEYS */;
127/*!40000 ALTER TABLE `swattachmentchunks` ENABLE KEYS */;
128UNLOCK TABLES;
129
130--
131-- Table structure for table `swattachments`
132--
133
134DROP TABLE IF EXISTS `swattachments`;
135/*!40101 SET @saved_cs_client = @@character_set_client */;
136/*!40101 SET character_set_client = utf8 */;
137CREATE TABLE `swattachments` (
138 `attachmentid` int(11) NOT NULL AUTO_INCREMENT,
139 `linktype` smallint(6) NOT NULL DEFAULT '0',
140 `linktypeid` int(11) NOT NULL DEFAULT '0',
141 `downloaditemid` int(11) NOT NULL DEFAULT '0',
142 `ticketid` int(11) NOT NULL DEFAULT '0',
143 `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
144 `filesize` int(11) NOT NULL DEFAULT '0',
145 `filetype` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
146 `dateline` int(11) NOT NULL DEFAULT '0',
147 `attachmenttype` smallint(6) NOT NULL DEFAULT '0',
148 `storefilename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
149 PRIMARY KEY (`attachmentid`),
150 KEY `attachments1` (`linktype`,`linktypeid`),
151 KEY `attachments2` (`attachmenttype`),
152 KEY `attachments3` (`downloaditemid`),
153 KEY `attachments4` (`ticketid`,`linktype`,`linktypeid`),
154 KEY `attachments5` (`linktype`,`ticketid`,`linktypeid`),
155 KEY `attachments6` (`linktype`,`ticketid`,`attachmentid`)
156) ENGINE=InnoDB AUTO_INCREMENT=3086 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Dumping data for table `swattachments`
161--
162
163LOCK TABLES `swattachments` WRITE;
164/*!40000 ALTER TABLE `swattachments` DISABLE KEYS */;
165INSERT INTO `swattachments` VALUES (1,1,78,0,46,'emkt geral_e01 - inline table.html',4215,'text/html',1336081027,2,'attach_lh0xc9sb37e3waku21i7obckzm86ic42'),(2,1,80,0,47,'IEDCBR1185305201214004.ret',1452,'application/octet-stream',1336137982,2,'attach_uq7swx96lz3oyy13b3zjfyskbez1gzko'),
166-- Dumping data for table `openreg_roles`
167--
168
169INSERT INTO `openreg_roles` (`name`, `description`, `permissions`) VALUES
170('admin-full', 'Admin with PayPal and User rights', 15),
171('admin', 'Admin', 3),
172('admin-paypal', 'Admin with PayPal rights', 7),
173('manager', 'Manager - reporting rights', 1),
174('manager-paypal', 'Manager with PayPal rights', 5);
175
176-- --------------------------------------------------------
177
178--
179-- Table structure for table `openreg_special_needs`
180--
181
182DROP TABLE IF EXISTS `openreg_special_needs`;
183CREATE TABLE IF NOT EXISTS `openreg_special_needs` (
184 `type` varchar(2) NOT NULL,
185 `description` tinytext NOT NULL,
186 PRIMARY KEY (`type`)
187) ENGINE=MyISAM DEFAULT CHARSET=utf8;
188
189--
190-- Dumping data for table `openreg_special_needs`
191--
192
193INSERT INTO `openreg_special_needs` (`type`, `description`) VALUES
194('WC', 'Wheel Chair'),
195('VG', 'Vegetarian Meal'),
196('HR', 'Hearing Impaired'),
197('BL', 'Blind'),
198('GL', 'Gluten Free'),
199('DI', 'Diabetic');
200
201-- --------------------------------------------------------
202
203--
204-- Table structure for table `openreg_users`
205--
206
207DROP TABLE IF EXISTS `openreg_users`;
208CREATE TABLE IF NOT EXISTS `openreg_users` (
209 `name` char(32) NOT NULL,
210 `realName` varchar(45) NOT NULL,
211 `eMail` varchar(30) NOT NULL,
212 `password` char(32) NOT NULL,
213 `role` varchar(16) NOT NULL,
214 PRIMARY KEY (`name`)
215) ENGINE=MyISAM DEFAULT CHARSET=utf8;
216
217--
218-- Dumping data for table `openreg_users`
219--
220
221INSERT INTO `openreg_users` (`name`, `realName`, `eMail`, `password`, `role`) VALUES
222('superadmin', 'Add your own ID and delete this one', 'none@none.none', '4cb9c8a8048fd02294477fcb1a41191a', 'admin-full');