7wCs4eQH

1-- MySQL dump 10.13  Distrib 5.5.49, for debian-linux-gnu (x86_64)
2--
3-- Host: maklarappen.cajqgsp0nnne.eu-west-1.rds.amazonaws.com    Database: maklarappen
4-- ------------------------------------------------------
5-- Server version	5.6.27-log
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 `actor`
20--
21
22DROP TABLE IF EXISTS `actor`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `actor` (
26  `ID` int(11) NOT NULL AUTO_INCREMENT,
27  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
28  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
29  `ISA` varchar(30) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'Seller',
30  `status` varchar(1) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'A',
31  `type` varchar(1) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'N',
32  `login` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
33  `firstname` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
34  `lastname` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
35  `email` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
36  `description` mediumtext COLLATE utf8_swedish_ci,
37  `address1` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
38  `address2` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
39  `postalregion` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
40  `postalcode` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
41  `postaloffice` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
42  `country` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
43  `phone` varchar(20) COLLATE utf8_swedish_ci DEFAULT NULL,
44  `mobilephone` varchar(20) COLLATE utf8_swedish_ci DEFAULT NULL,
45  `fax` varchar(20) COLLATE utf8_swedish_ci DEFAULT NULL,
46  `admin` tinyint(1) NOT NULL DEFAULT '0',
47  `persnbr` varchar(15) COLLATE utf8_swedish_ci DEFAULT NULL,
48  `organization` int(11) DEFAULT NULL,
49  `externalkey` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
50  `password` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
51  `hpassword` varchar(70) COLLATE utf8_swedish_ci DEFAULT NULL,
52  `portraiturl` varchar(255) COLLATE utf8_swedish_ci DEFAULT NULL,
53  `salt` char(3) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'cl1',
54  `lang` varchar(10) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'sv_se',
55  `dynamic` text COLLATE utf8_swedish_ci,
56  PRIMARY KEY (`ID`),
57  UNIQUE KEY `login` (`login`),
58  KEY `email` (`email`),
59  KEY `externalkey` (`externalkey`)
60) ENGINE=InnoDB AUTO_INCREMENT=572 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Table structure for table `authorization`
65--
66
67DROP TABLE IF EXISTS `authorization`;
68/*!40101 SET @saved_cs_client     = @@character_set_client */;
69/*!40101 SET character_set_client = utf8 */;
70CREATE TABLE `authorization` (
71  `ID` int(11) NOT NULL AUTO_INCREMENT,
72  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
73  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
74  `actor` int(11) DEFAULT NULL,
75  `organization` int(11) DEFAULT NULL,
76  `provider` varchar(6) COLLATE utf8_swedish_ci NOT NULL,
77  `fromdate` date DEFAULT NULL,
78  `todate` date DEFAULT NULL,
79  `dynamic` text COLLATE utf8_swedish_ci,
80  PRIMARY KEY (`ID`),
81  UNIQUE KEY `upkey` (`actor`,`organization`,`provider`),
82  KEY `actor` (`actor`),
83  KEY `organization` (`organization`)
84) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Table structure for table `brokerreview`
89--
90
91DROP TABLE IF EXISTS `brokerreview`;
92/*!40101 SET @saved_cs_client     = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `brokerreview` (
95  `ID` int(11) NOT NULL AUTO_INCREMENT,
96  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
97  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
98  `refclass` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
99  `refid` int(11) NOT NULL DEFAULT '0',
100  `rating1` int(1) DEFAULT NULL,
101  `comment` text COLLATE utf8_swedish_ci,
102  `name` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
103  `email` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
104  PRIMARY KEY (`ID`),
105  KEY `ctime` (`ctime`),
106  KEY `ref` (`refid`,`refclass`(5))
107) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Table structure for table `chatmessage`
112--
113
114DROP TABLE IF EXISTS `chatmessage`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `chatmessage` (
118  `ID` int(11) NOT NULL AUTO_INCREMENT,
119  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
120  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
121  `fromactor` int(11) NOT NULL DEFAULT '0',
122  `toactor` int(11) NOT NULL DEFAULT '0',
123  `message` text COLLATE utf8_swedish_ci,
124  `deal` int(11) DEFAULT NULL,
125  PRIMARY KEY (`ID`),
126  KEY `fromactor` (`fromactor`),
127  KEY `toactor` (`toactor`),
128  KEY `deal` (`deal`)
129) ENGINE=InnoDB AUTO_INCREMENT=936 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
130/*!40101 SET character_set_client = @saved_cs_client */;
131
132--
133-- Table structure for table `crawler_broker`
134--
135
136DROP TABLE IF EXISTS `crawler_broker`;
137/*!40101 SET @saved_cs_client     = @@character_set_client */;
138/*!40101 SET character_set_client = utf8 */;
139CREATE TABLE `crawler_broker` (
140  `id` int(11) NOT NULL AUTO_INCREMENT,
141  `RegDate` datetime NOT NULL,
142  `FirstName` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
143  `MiddleName` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
144  `LastName` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
145  `Address` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
146  `ZipCode` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
147  `City` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
148  `Email` varchar(256) COLLATE utf8_swedish_ci NOT NULL,
149  `Mobile` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
150  `Office` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
151  `Home` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
152  PRIMARY KEY (`id`),
153  KEY `email` (`Email`(255))
154) ENGINE=InnoDB AUTO_INCREMENT=41908 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Table structure for table `crawler_estate`
159--
160
161DROP TABLE IF EXISTS `crawler_estate`;
162/*!40101 SET @saved_cs_client     = @@character_set_client */;
163/*!40101 SET character_set_client = utf8 */;
164CREATE TABLE `crawler_estate` (
165  `Address` varchar(255) COLLATE utf8_swedish_ci NOT NULL,
166  `Area` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
167  `City` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
168  `BrokerCompany` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
169  `Price` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
170  `PricePerSquareMeter` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
171  `Fee` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
172  `AskedPrice` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
173  `PriceChange` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
174  `DateSold` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
175  `Type` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
176  `BuildYear` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
177  `BrokerName` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
178  `BrokerPhone` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
179  `BrokerEmail` varchar(255) COLLATE utf8_swedish_ci DEFAULT NULL,
180  `AreaLiving` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
181  `AreaLand` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
182  `AreaSupplemental` varchar(45) COLLATE utf8_swedish_ci DEFAULT NULL,
183  `broker_id` int(11) DEFAULT NULL,
184  `id` int(11) NOT NULL AUTO_INCREMENT,
185  `lat` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
186  `lon` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
187  PRIMARY KEY (`id`),
188  KEY `idx_crawler_estate_BrokerEmail` (`BrokerEmail`),
189  KEY `idx_crawler_estate_broker_id` (`broker_id`)
190) ENGINE=InnoDB AUTO_INCREMENT=332431 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
191/*!40101 SET character_set_client = @saved_cs_client */;
192
193--
194-- Table structure for table `deal`
195--
196
197DROP TABLE IF EXISTS `deal`;
198/*!40101 SET @saved_cs_client     = @@character_set_client */;
199/*!40101 SET character_set_client = utf8 */;
200CREATE TABLE `deal` (
201  `ID` int(11) NOT NULL AUTO_INCREMENT,
202  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
203  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
204  `fsmstate` varchar(70) COLLATE utf8_swedish_ci DEFAULT NULL,
205  `fsmmtime` datetime DEFAULT NULL,
206  `fsm` varchar(19) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'mspecs-deal-default',
207  `name` varchar(255) COLLATE utf8_swedish_ci DEFAULT NULL,
208  `seller` int(11) NOT NULL DEFAULT '0',
209  `broker` int(11) DEFAULT NULL,
210  `externalkey` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
211  `viewingtime2` datetime DEFAULT NULL,
212  `viewingtime4` datetime DEFAULT NULL,
213  `photoshootdates` text COLLATE utf8_swedish_ci,
214  `bidsreceived` int(11) NOT NULL DEFAULT '0',
215  `viewingtime3` datetime DEFAULT NULL,
216  `viewingtime1` datetime DEFAULT NULL,
217  `photoshoottime` datetime DEFAULT NULL,
218  `photographerid` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
219  `winningbidid` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
220  `signingtime` datetime DEFAULT NULL,
221  `signinglocation` varchar(70) COLLATE utf8_swedish_ci DEFAULT NULL,
222  `estate` int(11) DEFAULT NULL,
223  PRIMARY KEY (`ID`),
224  KEY `externalkey` (`externalkey`)
225) ENGINE=InnoDB AUTO_INCREMENT=524 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
226/*!40101 SET character_set_client = @saved_cs_client */;
227
228--
229-- Table structure for table `deal2broker`
230--
231
232DROP TABLE IF EXISTS `deal2broker`;
233/*!40101 SET @saved_cs_client     = @@character_set_client */;
234/*!40101 SET character_set_client = utf8 */;
235CREATE TABLE `deal2broker` (
236  `ID` int(11) NOT NULL AUTO_INCREMENT,
237  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
238  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
239  `owner` int(11) DEFAULT NULL,
240  `reference` int(11) DEFAULT NULL,
241  `fsmstate` varchar(70) COLLATE utf8_swedish_ci DEFAULT NULL,
242  `fsmmtime` datetime DEFAULT NULL,
243  `fsm` varchar(21) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'mspecs-deal-candidate',
244  `inspectiontime` datetime DEFAULT NULL,
245  `offertime` datetime DEFAULT NULL,
246  `externalkey` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
247  PRIMARY KEY (`ID`),
248  KEY `owner` (`owner`),
249  KEY `reference` (`reference`),
250  KEY `externalkey` (`externalkey`)
251) ENGINE=InnoDB AUTO_INCREMENT=774 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
252/*!40101 SET character_set_client = @saved_cs_client */;
253
254--
255-- Table structure for table `estate`
256--
257
258DROP TABLE IF EXISTS `estate`;
259/*!40101 SET @saved_cs_client     = @@character_set_client */;
260/*!40101 SET character_set_client = utf8 */;
261CREATE TABLE `estate` (
262  `ID` int(11) NOT NULL AUTO_INCREMENT,
263  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
264  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
265  `address` varchar(255) COLLATE utf8_swedish_ci DEFAULT NULL,
266  `seller` int(11) DEFAULT NULL,
267  `description` text COLLATE utf8_swedish_ci,
268  `externalkey` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
269  `longitude` float(20,10) DEFAULT NULL,
270  `latitude` float(20,10) DEFAULT NULL,
271  `dynamic` text COLLATE utf8_swedish_ci,
272  PRIMARY KEY (`ID`),
273  KEY `externalkey` (`externalkey`)
274) ENGINE=InnoDB AUTO_INCREMENT=522 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
275/*!40101 SET character_set_client = @saved_cs_client */;
276
277--
278-- Table structure for table `fsmhistorylog`
279--
280
281DROP TABLE IF EXISTS `fsmhistorylog`;
282/*!40101 SET @saved_cs_client     = @@character_set_client */;
283/*!40101 SET character_set_client = utf8 */;
284CREATE TABLE `fsmhistorylog` (
285  `ID` int(11) NOT NULL AUTO_INCREMENT,
286  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
287  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
288  `refclass` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
289  `refid` int(11) NOT NULL DEFAULT '0',
290  `machine` varchar(70) COLLATE utf8_swedish_ci NOT NULL,
291  `fromstate` varchar(70) COLLATE utf8_swedish_ci NOT NULL,
292  `tostate` varchar(70) COLLATE utf8_swedish_ci NOT NULL,
293  `isexception` tinyint(1) DEFAULT NULL,
294  `message` text COLLATE utf8_swedish_ci,
295  PRIMARY KEY (`ID`),
296  KEY `ctime` (`ctime`),
297  KEY `ref` (`refid`,`refclass`(20))
298) ENGINE=InnoDB AUTO_INCREMENT=3001 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Table structure for table `georegion`
303--
304
305DROP TABLE IF EXISTS `georegion`;
306/*!40101 SET @saved_cs_client     = @@character_set_client */;
307/*!40101 SET character_set_client = utf8 */;
308CREATE TABLE `georegion` (
309  `ID` int(11) NOT NULL AUTO_INCREMENT,
310  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
311  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
312  `name` varchar(80) COLLATE utf8_swedish_ci DEFAULT NULL,
313  `refcode` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
314  `isocode` varchar(10) COLLATE utf8_swedish_ci DEFAULT NULL,
315  `type` varchar(12) COLLATE utf8_swedish_ci DEFAULT NULL,
316  `description` text COLLATE utf8_swedish_ci,
317  `partof` int(11) DEFAULT NULL,
318  PRIMARY KEY (`ID`),
319  KEY `refcode` (`refcode`),
320  KEY `type` (`type`),
321  KEY `partof` (`partof`),
322  KEY `name` (`name`(5),`type`),
323  KEY `isocode` (`isocode`)
324) ENGINE=InnoDB AUTO_INCREMENT=18339 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
325/*!40101 SET character_set_client = @saved_cs_client */;
326
327--
328-- Table structure for table `organization`
329--
330
331DROP TABLE IF EXISTS `organization`;
332/*!40101 SET @saved_cs_client     = @@character_set_client */;
333/*!40101 SET character_set_client = utf8 */;
334CREATE TABLE `organization` (
335  `ID` int(11) NOT NULL AUTO_INCREMENT,
336  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
337  `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
338  `ISA` varchar(30) COLLATE utf8_swedish_ci NOT NULL DEFAULT 'Organization',
339  `name` varchar(120) COLLATE utf8_swedish_ci NOT NULL,
340  `dynamic` mediumtext COLLATE utf8_swedish_ci,
341  PRIMARY KEY (`ID`)
342) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
343/*!40101 SET character_set_client = @saved_cs_client */;
344/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
345
346/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
347/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
348/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
349/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
350/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
351/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
352/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
353
354-- Dump completed on 2016-09-12 11:43:13