Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../helpdezk
• File: helpdezk.sql
-- MySQL dump 10.13 Distrib 5.6.46, for Linux (x86_64)
[0] Fix | Delete
--
[1] Fix | Delete
-- Host: localhost Database: helpdezk1110
[2] Fix | Delete
-- ------------------------------------------------------
[3] Fix | Delete
-- Server version 5.6.46
[4] Fix | Delete
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[6] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[7] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[8] Fix | Delete
/*!40101 SET NAMES utf8 */;
[9] Fix | Delete
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
[10] Fix | Delete
/*!40103 SET TIME_ZONE='+00:00' */;
[11] Fix | Delete
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
[12] Fix | Delete
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
[13] Fix | Delete
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
[14] Fix | Delete
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
[15] Fix | Delete
[16] Fix | Delete
--
[17] Fix | Delete
-- Table structure for table `bbd_tbmessage`
[18] Fix | Delete
--
[19] Fix | Delete
[20] Fix | Delete
DROP TABLE IF EXISTS `bbd_tbmessage`;
[21] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[22] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[23] Fix | Delete
CREATE TABLE `bbd_tbmessage` (
[24] Fix | Delete
`idmessage` int(11) NOT NULL AUTO_INCREMENT,
[25] Fix | Delete
`idtopic` int(11) NOT NULL,
[26] Fix | Delete
`idperson` int(11) NOT NULL,
[27] Fix | Delete
`title` varchar(100) DEFAULT NULL,
[28] Fix | Delete
`description` text,
[29] Fix | Delete
`dtcreate` datetime DEFAULT NULL,
[30] Fix | Delete
`dtstart` datetime DEFAULT NULL,
[31] Fix | Delete
`dtend` datetime DEFAULT NULL,
[32] Fix | Delete
`sendemail` varchar(1) NOT NULL,
[33] Fix | Delete
`showin` varchar(1) NOT NULL,
[34] Fix | Delete
`emailsent` int(1) DEFAULT '0',
[35] Fix | Delete
PRIMARY KEY (`idmessage`),
[36] Fix | Delete
KEY `fk_bbd_tbmessage_bbd_topic1` (`idtopic`),
[37] Fix | Delete
KEY `fk_bbd_tbmessage_tbperson1` (`idperson`),
[38] Fix | Delete
CONSTRAINT `fk_bbd_tbmessage_bbd_topic1` FOREIGN KEY (`idtopic`) REFERENCES `bbd_topic` (`idtopic`) ON DELETE NO ACTION ON UPDATE NO ACTION,
[39] Fix | Delete
CONSTRAINT `fk_bbd_tbmessage_tbperson1` FOREIGN KEY (`idperson`) REFERENCES `tbperson` (`idperson`) ON DELETE NO ACTION ON UPDATE NO ACTION
[40] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
[41] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[42] Fix | Delete
[43] Fix | Delete
--
[44] Fix | Delete
-- Dumping data for table `bbd_tbmessage`
[45] Fix | Delete
--
[46] Fix | Delete
[47] Fix | Delete
LOCK TABLES `bbd_tbmessage` WRITE;
[48] Fix | Delete
/*!40000 ALTER TABLE `bbd_tbmessage` DISABLE KEYS */;
[49] Fix | Delete
INSERT INTO `bbd_tbmessage` VALUES (1,1,1,'Email sending issue .','The email service (SMTP) has problems when sending emails. But receiving emails (POP / IMAP) is working normally.Our infrastructure team is working to resolve the issue as quickly as possible.','2016-02-25 19:48:56','2019-12-26 19:48:00','2046-10-12 01:00:00','N','3',0);
[50] Fix | Delete
/*!40000 ALTER TABLE `bbd_tbmessage` ENABLE KEYS */;
[51] Fix | Delete
UNLOCK TABLES;
[52] Fix | Delete
[53] Fix | Delete
--
[54] Fix | Delete
-- Table structure for table `bbd_tbread`
[55] Fix | Delete
--
[56] Fix | Delete
[57] Fix | Delete
DROP TABLE IF EXISTS `bbd_tbread`;
[58] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[59] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[60] Fix | Delete
CREATE TABLE `bbd_tbread` (
[61] Fix | Delete
`idread` int(11) NOT NULL AUTO_INCREMENT,
[62] Fix | Delete
`dtread` datetime NOT NULL,
[63] Fix | Delete
`idperson` int(11) NOT NULL,
[64] Fix | Delete
`idmessage` int(11) NOT NULL,
[65] Fix | Delete
PRIMARY KEY (`idread`),
[66] Fix | Delete
KEY `fk_bbd_tbread_tbperson1` (`idperson`),
[67] Fix | Delete
CONSTRAINT `fk_bbd_tbread_tbperson1` FOREIGN KEY (`idperson`) REFERENCES `tbperson` (`idperson`) ON DELETE NO ACTION ON UPDATE NO ACTION
[68] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[69] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[70] Fix | Delete
[71] Fix | Delete
--
[72] Fix | Delete
-- Dumping data for table `bbd_tbread`
[73] Fix | Delete
--
[74] Fix | Delete
[75] Fix | Delete
LOCK TABLES `bbd_tbread` WRITE;
[76] Fix | Delete
/*!40000 ALTER TABLE `bbd_tbread` DISABLE KEYS */;
[77] Fix | Delete
/*!40000 ALTER TABLE `bbd_tbread` ENABLE KEYS */;
[78] Fix | Delete
UNLOCK TABLES;
[79] Fix | Delete
[80] Fix | Delete
--
[81] Fix | Delete
-- Table structure for table `bbd_topic`
[82] Fix | Delete
--
[83] Fix | Delete
[84] Fix | Delete
DROP TABLE IF EXISTS `bbd_topic`;
[85] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[86] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[87] Fix | Delete
CREATE TABLE `bbd_topic` (
[88] Fix | Delete
`idtopic` int(11) NOT NULL AUTO_INCREMENT,
[89] Fix | Delete
`title` varchar(100) NOT NULL,
[90] Fix | Delete
`default_display` varchar(10) DEFAULT NULL,
[91] Fix | Delete
`fl_emailsent` varchar(1) DEFAULT 'N',
[92] Fix | Delete
PRIMARY KEY (`idtopic`)
[93] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
[94] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[95] Fix | Delete
[96] Fix | Delete
--
[97] Fix | Delete
-- Dumping data for table `bbd_topic`
[98] Fix | Delete
--
[99] Fix | Delete
[100] Fix | Delete
LOCK TABLES `bbd_topic` WRITE;
[101] Fix | Delete
/*!40000 ALTER TABLE `bbd_topic` DISABLE KEYS */;
[102] Fix | Delete
INSERT INTO `bbd_topic` VALUES (1,'Servers','','N');
[103] Fix | Delete
/*!40000 ALTER TABLE `bbd_topic` ENABLE KEYS */;
[104] Fix | Delete
UNLOCK TABLES;
[105] Fix | Delete
[106] Fix | Delete
--
[107] Fix | Delete
-- Table structure for table `bbd_topic_company`
[108] Fix | Delete
--
[109] Fix | Delete
[110] Fix | Delete
DROP TABLE IF EXISTS `bbd_topic_company`;
[111] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[112] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[113] Fix | Delete
CREATE TABLE `bbd_topic_company` (
[114] Fix | Delete
`idtopiccompany` int(11) NOT NULL AUTO_INCREMENT,
[115] Fix | Delete
`idtopic` int(11) NOT NULL,
[116] Fix | Delete
`idcompany` int(11) NOT NULL,
[117] Fix | Delete
PRIMARY KEY (`idtopiccompany`),
[118] Fix | Delete
KEY `idtopic` (`idtopic`),
[119] Fix | Delete
KEY `idcompany` (`idcompany`),
[120] Fix | Delete
CONSTRAINT `bbd_topic_company_ibfk_1` FOREIGN KEY (`idtopic`) REFERENCES `bbd_topic` (`idtopic`),
[121] Fix | Delete
CONSTRAINT `bbd_topic_company_ibfk_2` FOREIGN KEY (`idcompany`) REFERENCES `tbperson` (`idperson`)
[122] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[123] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[124] Fix | Delete
[125] Fix | Delete
--
[126] Fix | Delete
-- Dumping data for table `bbd_topic_company`
[127] Fix | Delete
--
[128] Fix | Delete
[129] Fix | Delete
LOCK TABLES `bbd_topic_company` WRITE;
[130] Fix | Delete
/*!40000 ALTER TABLE `bbd_topic_company` DISABLE KEYS */;
[131] Fix | Delete
/*!40000 ALTER TABLE `bbd_topic_company` ENABLE KEYS */;
[132] Fix | Delete
UNLOCK TABLES;
[133] Fix | Delete
[134] Fix | Delete
--
[135] Fix | Delete
-- Table structure for table `bbd_topic_group`
[136] Fix | Delete
--
[137] Fix | Delete
[138] Fix | Delete
DROP TABLE IF EXISTS `bbd_topic_group`;
[139] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[140] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[141] Fix | Delete
CREATE TABLE `bbd_topic_group` (
[142] Fix | Delete
`idtopicgroup` int(11) NOT NULL AUTO_INCREMENT,
[143] Fix | Delete
`idtopic` int(11) NOT NULL,
[144] Fix | Delete
`idgroup` int(11) NOT NULL,
[145] Fix | Delete
PRIMARY KEY (`idtopicgroup`),
[146] Fix | Delete
KEY `idtopic` (`idtopic`),
[147] Fix | Delete
KEY `idgroup` (`idgroup`),
[148] Fix | Delete
CONSTRAINT `bbd_topic_group_ibfk_1` FOREIGN KEY (`idtopic`) REFERENCES `bbd_topic` (`idtopic`),
[149] Fix | Delete
CONSTRAINT `bbd_topic_group_ibfk_2` FOREIGN KEY (`idgroup`) REFERENCES `hdk_tbgroup` (`idgroup`)
[150] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[151] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[152] Fix | Delete
[153] Fix | Delete
--
[154] Fix | Delete
-- Dumping data for table `bbd_topic_group`
[155] Fix | Delete
--
[156] Fix | Delete
[157] Fix | Delete
LOCK TABLES `bbd_topic_group` WRITE;
[158] Fix | Delete
/*!40000 ALTER TABLE `bbd_topic_group` DISABLE KEYS */;
[159] Fix | Delete
/*!40000 ALTER TABLE `bbd_topic_group` ENABLE KEYS */;
[160] Fix | Delete
UNLOCK TABLES;
[161] Fix | Delete
[162] Fix | Delete
--
[163] Fix | Delete
-- Table structure for table `bbd_topiccustomer`
[164] Fix | Delete
--
[165] Fix | Delete
[166] Fix | Delete
DROP TABLE IF EXISTS `bbd_topiccustomer`;
[167] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[168] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[169] Fix | Delete
CREATE TABLE `bbd_topiccustomer` (
[170] Fix | Delete
`idtopiccustomer` int(11) NOT NULL,
[171] Fix | Delete
`idperson` int(11) NOT NULL,
[172] Fix | Delete
`idtopic` int(11) NOT NULL,
[173] Fix | Delete
PRIMARY KEY (`idtopiccustomer`),
[174] Fix | Delete
KEY `fk_bbd_topiccustomer_tbperson1` (`idperson`),
[175] Fix | Delete
KEY `fk_bbd_topiccustomer_bbd_topic1` (`idtopic`),
[176] Fix | Delete
CONSTRAINT `fk_bbd_topiccustomer_bbd_topic1` FOREIGN KEY (`idtopic`) REFERENCES `bbd_topic` (`idtopic`) ON DELETE NO ACTION ON UPDATE NO ACTION,
[177] Fix | Delete
CONSTRAINT `fk_bbd_topiccustomer_tbperson1` FOREIGN KEY (`idperson`) REFERENCES `tbperson` (`idperson`) ON DELETE NO ACTION ON UPDATE NO ACTION
[178] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[179] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[180] Fix | Delete
[181] Fix | Delete
--
[182] Fix | Delete
-- Dumping data for table `bbd_topiccustomer`
[183] Fix | Delete
--
[184] Fix | Delete
[185] Fix | Delete
LOCK TABLES `bbd_topiccustomer` WRITE;
[186] Fix | Delete
/*!40000 ALTER TABLE `bbd_topiccustomer` DISABLE KEYS */;
[187] Fix | Delete
/*!40000 ALTER TABLE `bbd_topiccustomer` ENABLE KEYS */;
[188] Fix | Delete
UNLOCK TABLES;
[189] Fix | Delete
[190] Fix | Delete
--
[191] Fix | Delete
-- Table structure for table `dsh_tbcategory`
[192] Fix | Delete
--
[193] Fix | Delete
[194] Fix | Delete
DROP TABLE IF EXISTS `dsh_tbcategory`;
[195] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[196] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[197] Fix | Delete
CREATE TABLE `dsh_tbcategory` (
[198] Fix | Delete
`idcategory` int(11) NOT NULL AUTO_INCREMENT,
[199] Fix | Delete
`title` varchar(100) DEFAULT NULL,
[200] Fix | Delete
`index` int(11) DEFAULT NULL,
[201] Fix | Delete
`status` char(1) DEFAULT 'A',
[202] Fix | Delete
PRIMARY KEY (`idcategory`)
[203] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
[204] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[205] Fix | Delete
[206] Fix | Delete
--
[207] Fix | Delete
-- Dumping data for table `dsh_tbcategory`
[208] Fix | Delete
--
[209] Fix | Delete
[210] Fix | Delete
LOCK TABLES `dsh_tbcategory` WRITE;
[211] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbcategory` DISABLE KEYS */;
[212] Fix | Delete
INSERT INTO `dsh_tbcategory` VALUES (1,'Helpdezk',0,'A');
[213] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbcategory` ENABLE KEYS */;
[214] Fix | Delete
UNLOCK TABLES;
[215] Fix | Delete
[216] Fix | Delete
--
[217] Fix | Delete
-- Table structure for table `dsh_tbcategory_has_widget`
[218] Fix | Delete
--
[219] Fix | Delete
[220] Fix | Delete
DROP TABLE IF EXISTS `dsh_tbcategory_has_widget`;
[221] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[222] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[223] Fix | Delete
CREATE TABLE `dsh_tbcategory_has_widget` (
[224] Fix | Delete
`idcategory` int(11) DEFAULT NULL,
[225] Fix | Delete
`idwidget` int(11) DEFAULT NULL,
[226] Fix | Delete
KEY `FK_dsh_tbcategory_has_widget` (`idwidget`),
[227] Fix | Delete
KEY `FK1_dsh_tbcategory_has_widget` (`idcategory`),
[228] Fix | Delete
CONSTRAINT `FK1_dsh_tbcategory_has_widget` FOREIGN KEY (`idcategory`) REFERENCES `dsh_tbcategory` (`idcategory`) ON DELETE CASCADE,
[229] Fix | Delete
CONSTRAINT `FK_dsh_tbcategory_has_widget` FOREIGN KEY (`idwidget`) REFERENCES `dsh_tbwidget` (`idwidget`) ON DELETE CASCADE
[230] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[231] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[232] Fix | Delete
[233] Fix | Delete
--
[234] Fix | Delete
-- Dumping data for table `dsh_tbcategory_has_widget`
[235] Fix | Delete
--
[236] Fix | Delete
[237] Fix | Delete
LOCK TABLES `dsh_tbcategory_has_widget` WRITE;
[238] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbcategory_has_widget` DISABLE KEYS */;
[239] Fix | Delete
INSERT INTO `dsh_tbcategory_has_widget` VALUES (1,1),(1,3),(1,3);
[240] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbcategory_has_widget` ENABLE KEYS */;
[241] Fix | Delete
UNLOCK TABLES;
[242] Fix | Delete
[243] Fix | Delete
--
[244] Fix | Delete
-- Table structure for table `dsh_tbwidget`
[245] Fix | Delete
--
[246] Fix | Delete
[247] Fix | Delete
DROP TABLE IF EXISTS `dsh_tbwidget`;
[248] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[249] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[250] Fix | Delete
CREATE TABLE `dsh_tbwidget` (
[251] Fix | Delete
`idwidget` int(11) NOT NULL AUTO_INCREMENT,
[252] Fix | Delete
`name` varchar(45) DEFAULT NULL,
[253] Fix | Delete
`dbhost` varchar(45) DEFAULT NULL,
[254] Fix | Delete
`dbuser` varchar(45) DEFAULT NULL,
[255] Fix | Delete
`dbpass` varchar(45) DEFAULT NULL,
[256] Fix | Delete
`dbname` varchar(45) DEFAULT NULL,
[257] Fix | Delete
`field1` varchar(200) DEFAULT NULL,
[258] Fix | Delete
`field2` varchar(200) DEFAULT NULL,
[259] Fix | Delete
`field3` varchar(200) DEFAULT NULL,
[260] Fix | Delete
`field4` varchar(200) DEFAULT NULL,
[261] Fix | Delete
`field5` varchar(200) DEFAULT NULL,
[262] Fix | Delete
`description` varchar(200) DEFAULT NULL,
[263] Fix | Delete
`creator` varchar(100) DEFAULT NULL,
[264] Fix | Delete
`controller` varchar(100) DEFAULT NULL,
[265] Fix | Delete
`image` varchar(100) DEFAULT NULL,
[266] Fix | Delete
`index` int(11) DEFAULT NULL,
[267] Fix | Delete
`status` char(1) DEFAULT 'A',
[268] Fix | Delete
PRIMARY KEY (`idwidget`),
[269] Fix | Delete
KEY `idx_name` (`name`)
[270] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
[271] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[272] Fix | Delete
[273] Fix | Delete
--
[274] Fix | Delete
-- Dumping data for table `dsh_tbwidget`
[275] Fix | Delete
--
[276] Fix | Delete
[277] Fix | Delete
LOCK TABLES `dsh_tbwidget` WRITE;
[278] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbwidget` DISABLE KEYS */;
[279] Fix | Delete
INSERT INTO `dsh_tbwidget` VALUES (1,'Hard Users','','','','','2013','6','','','','Most active users','Rogerio Albandes','hdk_harduser','hard user.jpg',0,'A'),(2,'Requests in Stock','','','','','1800000','12','','','','Requests in stock , in the last 30 days','Rogerio Albandes','hdk_requestassets','Estoque de Solicitacoes.jpg',0,'A'),(3,'Service Level Agreement','','','','','','','','','','Service Level Agreement','Rogerio Albandes','hdk_sla','sla.jpg',0,'A');
[280] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbwidget` ENABLE KEYS */;
[281] Fix | Delete
UNLOCK TABLES;
[282] Fix | Delete
[283] Fix | Delete
--
[284] Fix | Delete
-- Table structure for table `dsh_tbwidgetusuario`
[285] Fix | Delete
--
[286] Fix | Delete
[287] Fix | Delete
DROP TABLE IF EXISTS `dsh_tbwidgetusuario`;
[288] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[289] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[290] Fix | Delete
CREATE TABLE `dsh_tbwidgetusuario` (
[291] Fix | Delete
`idwidgetusuario` int(11) NOT NULL AUTO_INCREMENT,
[292] Fix | Delete
`idusuario` int(10) unsigned NOT NULL,
[293] Fix | Delete
`widgets` blob,
[294] Fix | Delete
PRIMARY KEY (`idwidgetusuario`)
[295] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
[296] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[297] Fix | Delete
[298] Fix | Delete
--
[299] Fix | Delete
-- Dumping data for table `dsh_tbwidgetusuario`
[300] Fix | Delete
--
[301] Fix | Delete
[302] Fix | Delete
LOCK TABLES `dsh_tbwidgetusuario` WRITE;
[303] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbwidgetusuario` DISABLE KEYS */;
[304] Fix | Delete
/*!40000 ALTER TABLE `dsh_tbwidgetusuario` ENABLE KEYS */;
[305] Fix | Delete
UNLOCK TABLES;
[306] Fix | Delete
[307] Fix | Delete
--
[308] Fix | Delete
-- Table structure for table `hdk_base_attachment`
[309] Fix | Delete
--
[310] Fix | Delete
[311] Fix | Delete
DROP TABLE IF EXISTS `hdk_base_attachment`;
[312] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[313] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[314] Fix | Delete
CREATE TABLE `hdk_base_attachment` (
[315] Fix | Delete
`idattachment` int(11) NOT NULL AUTO_INCREMENT,
[316] Fix | Delete
`filename` varchar(200) NOT NULL,
[317] Fix | Delete
`idbase` int(11) NOT NULL,
[318] Fix | Delete
`real_filename` varchar(200) NOT NULL,
[319] Fix | Delete
PRIMARY KEY (`idattachment`),
[320] Fix | Delete
KEY `fk_idbase_tbperson` (`idbase`),
[321] Fix | Delete
CONSTRAINT `fk_idbase_tbperson` FOREIGN KEY (`idbase`) REFERENCES `hdk_base_knowledge` (`idbase`) ON DELETE CASCADE
[322] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[323] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[324] Fix | Delete
[325] Fix | Delete
--
[326] Fix | Delete
-- Dumping data for table `hdk_base_attachment`
[327] Fix | Delete
--
[328] Fix | Delete
[329] Fix | Delete
LOCK TABLES `hdk_base_attachment` WRITE;
[330] Fix | Delete
/*!40000 ALTER TABLE `hdk_base_attachment` DISABLE KEYS */;
[331] Fix | Delete
/*!40000 ALTER TABLE `hdk_base_attachment` ENABLE KEYS */;
[332] Fix | Delete
UNLOCK TABLES;
[333] Fix | Delete
[334] Fix | Delete
--
[335] Fix | Delete
-- Table structure for table `hdk_base_category`
[336] Fix | Delete
--
[337] Fix | Delete
[338] Fix | Delete
DROP TABLE IF EXISTS `hdk_base_category`;
[339] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[340] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[341] Fix | Delete
CREATE TABLE `hdk_base_category` (
[342] Fix | Delete
`idcategory` int(11) NOT NULL AUTO_INCREMENT,
[343] Fix | Delete
`name` varchar(100) NOT NULL,
[344] Fix | Delete
`idcategory_reference` int(11) DEFAULT NULL,
[345] Fix | Delete
PRIMARY KEY (`idcategory`)
[346] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;
[347] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[348] Fix | Delete
[349] Fix | Delete
--
[350] Fix | Delete
-- Dumping data for table `hdk_base_category`
[351] Fix | Delete
--
[352] Fix | Delete
[353] Fix | Delete
LOCK TABLES `hdk_base_category` WRITE;
[354] Fix | Delete
/*!40000 ALTER TABLE `hdk_base_category` DISABLE KEYS */;
[355] Fix | Delete
INSERT INTO `hdk_base_category` VALUES (1,'Definir Categoria',0),(17,'ccc',0),(94,'Siare',0),(95,'CRM - Syonet',0),(96,'WEON',0),(97,'Hardware',0),(98,'Windows',111),(99,'QlikView',0),(100,'Windows XP',98),(101,'Windows Vista',98),(102,'Windows 7',98),(103,'AntiVirus',0),(106,'SENHAS',0),(107,'Internet',0),(110,'PROGRAMAS',0),(111,'“Esta operação foi cancelada devido às re',98),(112,'Senha Desp Adriano',106);
[356] Fix | Delete
/*!40000 ALTER TABLE `hdk_base_category` ENABLE KEYS */;
[357] Fix | Delete
UNLOCK TABLES;
[358] Fix | Delete
[359] Fix | Delete
--
[360] Fix | Delete
-- Table structure for table `hdk_base_knowledge`
[361] Fix | Delete
--
[362] Fix | Delete
[363] Fix | Delete
DROP TABLE IF EXISTS `hdk_base_knowledge`;
[364] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[365] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[366] Fix | Delete
CREATE TABLE `hdk_base_knowledge` (
[367] Fix | Delete
`idbase` int(11) NOT NULL AUTO_INCREMENT,
[368] Fix | Delete
`idcategory` int(11) NOT NULL,
[369] Fix | Delete
`name` varchar(150) NOT NULL,
[370] Fix | Delete
`problem` blob NOT NULL,
[371] Fix | Delete
`solution` blob NOT NULL,
[372] Fix | Delete
`date_register` datetime NOT NULL,
[373] Fix | Delete
`idperson` int(11) NOT NULL,
[374] Fix | Delete
`date_edit` datetime DEFAULT NULL,
[375] Fix | Delete
`idperson_edit` int(11) DEFAULT NULL,
[376] Fix | Delete
`faq` int(1) DEFAULT '0',
[377] Fix | Delete
PRIMARY KEY (`idbase`),
[378] Fix | Delete
KEY `fk_idcategory_hdk_base_category` (`idcategory`),
[379] Fix | Delete
KEY `fk_idperson_edit_tbperson` (`idperson_edit`),
[380] Fix | Delete
KEY `fk_idperson_tbperson` (`idperson`),
[381] Fix | Delete
KEY `idx_1` (`idbase`,`idcategory`,`idperson`,`idperson_edit`,`name`),
[382] Fix | Delete
CONSTRAINT `fk_idcategory_hdk_base_category` FOREIGN KEY (`idcategory`) REFERENCES `hdk_base_category` (`idcategory`) ON DELETE CASCADE,
[383] Fix | Delete
CONSTRAINT `fk_idperson_edit_tbperson` FOREIGN KEY (`idperson_edit`) REFERENCES `tbperson` (`idperson`),
[384] Fix | Delete
CONSTRAINT `fk_idperson_tbperson` FOREIGN KEY (`idperson`) REFERENCES `tbperson` (`idperson`)
[385] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[386] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[387] Fix | Delete
[388] Fix | Delete
--
[389] Fix | Delete
-- Dumping data for table `hdk_base_knowledge`
[390] Fix | Delete
--
[391] Fix | Delete
[392] Fix | Delete
LOCK TABLES `hdk_base_knowledge` WRITE;
[393] Fix | Delete
/*!40000 ALTER TABLE `hdk_base_knowledge` DISABLE KEYS */;
[394] Fix | Delete
/*!40000 ALTER TABLE `hdk_base_knowledge` ENABLE KEYS */;
[395] Fix | Delete
UNLOCK TABLES;
[396] Fix | Delete
[397] Fix | Delete
--
[398] Fix | Delete
-- Table structure for table `hdk_tbaddinfo`
[399] Fix | Delete
--
[400] Fix | Delete
[401] Fix | Delete
DROP TABLE IF EXISTS `hdk_tbaddinfo`;
[402] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[403] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[404] Fix | Delete
CREATE TABLE `hdk_tbaddinfo` (
[405] Fix | Delete
`idaddinfo` int(11) NOT NULL AUTO_INCREMENT,
[406] Fix | Delete
`name` varchar(200) NOT NULL,
[407] Fix | Delete
PRIMARY KEY (`idaddinfo`)
[408] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
[409] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[410] Fix | Delete
[411] Fix | Delete
--
[412] Fix | Delete
-- Dumping data for table `hdk_tbaddinfo`
[413] Fix | Delete
--
[414] Fix | Delete
[415] Fix | Delete
LOCK TABLES `hdk_tbaddinfo` WRITE;
[416] Fix | Delete
/*!40000 ALTER TABLE `hdk_tbaddinfo` DISABLE KEYS */;
[417] Fix | Delete
INSERT INTO `hdk_tbaddinfo` VALUES (1,'Erro no Sistema'),(2,'Erro do Usuário');
[418] Fix | Delete
/*!40000 ALTER TABLE `hdk_tbaddinfo` ENABLE KEYS */;
[419] Fix | Delete
UNLOCK TABLES;
[420] Fix | Delete
[421] Fix | Delete
--
[422] Fix | Delete
-- Table structure for table `hdk_tbapproval_rule`
[423] Fix | Delete
--
[424] Fix | Delete
[425] Fix | Delete
DROP TABLE IF EXISTS `hdk_tbapproval_rule`;
[426] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[427] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[428] Fix | Delete
CREATE TABLE `hdk_tbapproval_rule` (
[429] Fix | Delete
`idapproval` int(10) NOT NULL AUTO_INCREMENT,
[430] Fix | Delete
`iditem` int(3) DEFAULT NULL,
[431] Fix | Delete
`idservice` int(3) DEFAULT NULL,
[432] Fix | Delete
`idperson` int(10) DEFAULT NULL,
[433] Fix | Delete
`order` int(10) DEFAULT '1',
[434] Fix | Delete
`fl_recalculate` int(1) DEFAULT '0',
[435] Fix | Delete
PRIMARY KEY (`idapproval`)
[436] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[437] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[438] Fix | Delete
[439] Fix | Delete
--
[440] Fix | Delete
-- Dumping data for table `hdk_tbapproval_rule`
[441] Fix | Delete
--
[442] Fix | Delete
[443] Fix | Delete
LOCK TABLES `hdk_tbapproval_rule` WRITE;
[444] Fix | Delete
/*!40000 ALTER TABLE `hdk_tbapproval_rule` DISABLE KEYS */;
[445] Fix | Delete
/*!40000 ALTER TABLE `hdk_tbapproval_rule` ENABLE KEYS */;
[446] Fix | Delete
UNLOCK TABLES;
[447] Fix | Delete
[448] Fix | Delete
--
[449] Fix | Delete
-- Table structure for table `hdk_tbattendance_way`
[450] Fix | Delete
--
[451] Fix | Delete
[452] Fix | Delete
DROP TABLE IF EXISTS `hdk_tbattendance_way`;
[453] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[454] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[455] Fix | Delete
CREATE TABLE `hdk_tbattendance_way` (
[456] Fix | Delete
`idattendanceway` int(4) unsigned NOT NULL AUTO_INCREMENT,
[457] Fix | Delete
`way` varchar(100) NOT NULL,
[458] Fix | Delete
PRIMARY KEY (`idattendanceway`)
[459] Fix | Delete
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
[460] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[461] Fix | Delete
[462] Fix | Delete
--
[463] Fix | Delete
-- Dumping data for table `hdk_tbattendance_way`
[464] Fix | Delete
--
[465] Fix | Delete
[466] Fix | Delete
LOCK TABLES `hdk_tbattendance_way` WRITE;
[467] Fix | Delete
/*!40000 ALTER TABLE `hdk_tbattendance_way` DISABLE KEYS */;
[468] Fix | Delete
INSERT INTO `hdk_tbattendance_way` VALUES (1,'Internal'),(2,'External'),(3,'Remote Controll');
[469] Fix | Delete
/*!40000 ALTER TABLE `hdk_tbattendance_way` ENABLE KEYS */;
[470] Fix | Delete
UNLOCK TABLES;
[471] Fix | Delete
[472] Fix | Delete
--
[473] Fix | Delete
-- Table structure for table `hdk_tbconfig`
[474] Fix | Delete
--
[475] Fix | Delete
[476] Fix | Delete
DROP TABLE IF EXISTS `hdk_tbconfig`;
[477] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[478] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[479] Fix | Delete
CREATE TABLE `hdk_tbconfig` (
[480] Fix | Delete
`idconfig` int(3) unsigned NOT NULL AUTO_INCREMENT,
[481] Fix | Delete
`name` varchar(250) DEFAULT NULL,
[482] Fix | Delete
`description` blob,
[483] Fix | Delete
`idconfigcategory` int(10) unsigned DEFAULT NULL,
[484] Fix | Delete
`session_name` varchar(50) DEFAULT NULL,
[485] Fix | Delete
`field_type` varchar(200) DEFAULT NULL,
[486] Fix | Delete
`status` char(1) DEFAULT 'A',
[487] Fix | Delete
`smarty` varchar(120) NOT NULL,
[488] Fix | Delete
`value` varchar(200) DEFAULT NULL,
[489] Fix | Delete
`allowremove` enum('Y','N') NOT NULL DEFAULT 'N',
[490] Fix | Delete
PRIMARY KEY (`idconfig`),
[491] Fix | Delete
KEY `FK_hdk_tbconfig` (`idconfigcategory`),
[492] Fix | Delete
CONSTRAINT `FK_hdk_tbconfig` FOREIGN KEY (`idconfigcategory`) REFERENCES `hdk_tbconfig_category` (`idconfigcategory`)
[493] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
[494] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[495] Fix | Delete
[496] Fix | Delete
--
[497] Fix | Delete
-- Dumping data for table `hdk_tbconfig`
[498] Fix | Delete
--
[499] Fix | Delete
123456...9
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function