· 10 years ago · Dec 14, 2015, 08:21 PM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8 */;
5/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
6/*!40103 SET TIME_ZONE='+00:00' */;
7/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
8/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
9/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
10/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
11
12DROP TABLE IF EXISTS `accounts`;
13SET @saved_cs_client = @@character_set_client;
14SET character_set_client = utf8;
15CREATE TABLE `accounts` (
16 `aid` int(10) unsigned NOT NULL auto_increment,
17 `account_dn` varchar(128) NOT NULL,
18 `account_id` varchar(128) NOT NULL,
19 `account_pw` varchar(128) NOT NULL,
20 `account_host` varchar(128) NOT NULL,
21 `account_host_smtp` varchar(128) NOT NULL,
22 `preferences` text,
23 `user_id` int(10) unsigned NOT NULL default '0',
24 PRIMARY KEY (`aid`),
25 KEY `user_id_fk_accounts` (`user_id`),
26 CONSTRAINT `accounts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28SET character_set_client = @saved_cs_client;
29
30--
31-- Dumping data for table `accounts`
32--
33
34LOCK TABLES `accounts` WRITE;
35/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
36/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
37UNLOCK TABLES;
38
39--
40-- Table structure for table `bookmarks`
41--
42
43DROP TABLE IF EXISTS `bookmarks`;
44SET @saved_cs_client = @@character_set_client;
45SET character_set_client = utf8;
46CREATE TABLE `bookmarks` (
47 `id` int(5) NOT NULL auto_increment,
48 `name` varchar(255) NOT NULL,
49 `url` varchar(1000) NOT NULL,
50 `grouped` varchar(255) NOT NULL,
51 PRIMARY KEY (`id`)
52) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
53SET character_set_client = @saved_cs_client;
54
55--
56-- Dumping data for table `bookmarks`
57--
58
59LOCK TABLES `bookmarks` WRITE;
60/*!40000 ALTER TABLE `bookmarks` DISABLE KEYS */;
61INSERT INTO `bookmarks` VALUES (1,'T-Online','http://www.t-online.de','Main'),(2,'Jornal Record','http://www.record.pt','Sport'),(3,'A Bola','http://www.abola.pt','Sport'),(4,'O Jogo','http://www.ojogo.pt','Sport');
62/*!40000 ALTER TABLE `bookmarks` ENABLE KEYS */;
63UNLOCK TABLES;
64
65--
66-- Table structure for table `cache`
67--
68
69DROP TABLE IF EXISTS `cache`;
70SET @saved_cs_client = @@character_set_client;
71SET character_set_client = utf8;
72CREATE TABLE `cache` (
73 `cache_id` int(10) unsigned NOT NULL auto_increment,
74 `cache_key` varchar(128) character set ascii NOT NULL,
75 `created` datetime NOT NULL default '1000-01-01 00:00:00',
76 `data` longtext NOT NULL,
77 `user_id` int(10) unsigned NOT NULL,
78 PRIMARY KEY (`cache_id`),
79 KEY `created_index` (`created`),
80 KEY `user_cache_index` (`user_id`,`cache_key`),
81 CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;
83SET character_set_client = @saved_cs_client;
84
85--
86-- Dumping data for table `cache`
87--
88
89LOCK TABLES `cache` WRITE;
90/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
91/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
92UNLOCK TABLES;
93
94--
95-- Table structure for table `cache_index`
96--
97
98DROP TABLE IF EXISTS `cache_index`;
99SET @saved_cs_client = @@character_set_client;
100SET character_set_client = utf8;
101CREATE TABLE `cache_index` (
102 `user_id` int(10) unsigned NOT NULL,
103 `mailbox` varchar(255) character set utf8 collate utf8_bin NOT NULL,
104 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
105 `valid` tinyint(1) NOT NULL default '0',
106 `data` longtext NOT NULL,
107 PRIMARY KEY (`user_id`,`mailbox`),
108 KEY `changed_index` (`changed`),
109 CONSTRAINT `user_id_fk_cache_index` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
110) ENGINE=InnoDB DEFAULT CHARSET=utf8;
111SET character_set_client = @saved_cs_client;
112
113--
114-- Dumping data for table `cache_index`
115--
116
117LOCK TABLES `cache_index` WRITE;
118/*!40000 ALTER TABLE `cache_index` DISABLE KEYS */;
119/*!40000 ALTER TABLE `cache_index` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `cache_messages`
124--
125
126DROP TABLE IF EXISTS `cache_messages`;
127SET @saved_cs_client = @@character_set_client;
128SET character_set_client = utf8;
129CREATE TABLE `cache_messages` (
130 `user_id` int(10) unsigned NOT NULL,
131 `mailbox` varchar(255) character set utf8 collate utf8_bin NOT NULL,
132 `uid` int(11) unsigned NOT NULL default '0',
133 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
134 `data` longtext NOT NULL,
135 `flags` int(11) NOT NULL default '0',
136 PRIMARY KEY (`user_id`,`mailbox`,`uid`),
137 KEY `changed_index` (`changed`),
138 CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
140SET character_set_client = @saved_cs_client;
141
142--
143-- Dumping data for table `cache_messages`
144--
145
146LOCK TABLES `cache_messages` WRITE;
147/*!40000 ALTER TABLE `cache_messages` DISABLE KEYS */;
148/*!40000 ALTER TABLE `cache_messages` ENABLE KEYS */;
149UNLOCK TABLES;
150
151--
152-- Table structure for table `cache_thread`
153--
154
155DROP TABLE IF EXISTS `cache_thread`;
156SET @saved_cs_client = @@character_set_client;
157SET character_set_client = utf8;
158CREATE TABLE `cache_thread` (
159 `user_id` int(10) unsigned NOT NULL,
160 `mailbox` varchar(255) character set utf8 collate utf8_bin NOT NULL,
161 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
162 `data` longtext NOT NULL,
163 PRIMARY KEY (`user_id`,`mailbox`),
164 KEY `changed_index` (`changed`),
165 CONSTRAINT `user_id_fk_cache_thread` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
166) ENGINE=InnoDB DEFAULT CHARSET=utf8;
167SET character_set_client = @saved_cs_client;
168
169--
170-- Dumping data for table `cache_thread`
171--
172
173LOCK TABLES `cache_thread` WRITE;
174/*!40000 ALTER TABLE `cache_thread` DISABLE KEYS */;
175/*!40000 ALTER TABLE `cache_thread` ENABLE KEYS */;
176UNLOCK TABLES;
177
178--
179-- Table structure for table `contactgroupmembers`
180--
181
182DROP TABLE IF EXISTS `contactgroupmembers`;
183SET @saved_cs_client = @@character_set_client;
184SET character_set_client = utf8;
185CREATE TABLE `contactgroupmembers` (
186 `contactgroup_id` int(10) unsigned NOT NULL,
187 `contact_id` int(10) unsigned NOT NULL,
188 `created` datetime NOT NULL default '1000-01-01 00:00:00',
189 PRIMARY KEY (`contactgroup_id`,`contact_id`),
190 KEY `contactgroupmembers_contact_index` (`contact_id`),
191 CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE,
192 CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE
193) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194SET character_set_client = @saved_cs_client;
195
196--
197-- Dumping data for table `contactgroupmembers`
198--
199
200LOCK TABLES `contactgroupmembers` WRITE;
201/*!40000 ALTER TABLE `contactgroupmembers` DISABLE KEYS */;
202/*!40000 ALTER TABLE `contactgroupmembers` ENABLE KEYS */;
203UNLOCK TABLES;
204
205--
206-- Table structure for table `contactgroups`
207--
208
209DROP TABLE IF EXISTS `contactgroups`;
210SET @saved_cs_client = @@character_set_client;
211SET character_set_client = utf8;
212CREATE TABLE `contactgroups` (
213 `contactgroup_id` int(10) unsigned NOT NULL auto_increment,
214 `user_id` int(10) unsigned NOT NULL,
215 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
216 `del` tinyint(1) NOT NULL default '0',
217 `name` varchar(128) NOT NULL default '',
218 PRIMARY KEY (`contactgroup_id`),
219 KEY `contactgroups_user_index` (`user_id`,`del`),
220 CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
221) ENGINE=InnoDB DEFAULT CHARSET=utf8;
222SET character_set_client = @saved_cs_client;
223
224--
225-- Dumping data for table `contactgroups`
226--
227
228LOCK TABLES `contactgroups` WRITE;
229/*!40000 ALTER TABLE `contactgroups` DISABLE KEYS */;
230/*!40000 ALTER TABLE `contactgroups` ENABLE KEYS */;
231UNLOCK TABLES;
232
233--
234-- Table structure for table `contacts`
235--
236
237DROP TABLE IF EXISTS `contacts`;
238SET @saved_cs_client = @@character_set_client;
239SET character_set_client = utf8;
240CREATE TABLE `contacts` (
241 `contact_id` int(10) unsigned NOT NULL auto_increment,
242 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
243 `del` tinyint(1) NOT NULL default '0',
244 `name` varchar(128) NOT NULL default '',
245 `email` text NOT NULL,
246 `firstname` varchar(128) NOT NULL default '',
247 `surname` varchar(128) NOT NULL default '',
248 `vcard` longtext,
249 `words` text,
250 `user_id` int(10) unsigned NOT NULL,
251 PRIMARY KEY (`contact_id`),
252 KEY `user_contacts_index` (`user_id`,`del`),
253 CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
254) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
255SET character_set_client = @saved_cs_client;
256
257--
258-- Dumping data for table `contacts`
259--
260
261LOCK TABLES `contacts` WRITE;
262/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
263INSERT INTO `contacts` VALUES (1,'2012-01-31 21:39:31',0,'Ricardo Alho','risualho@hotmail.com','Ricardo','Alho','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Alho;Ricardo;;;\r\nFN:Ricardo Alho\r\nEMAIL;type=INTERNET;type=OTHER:risualho@hotmail.com\r\nEND:VCARD',' ricardo alho risualho@hotmail.com',1),(2,'2012-01-31 21:39:32',0,'Ruben Barroso','ruben_barroso93@hotmail.com','Ruben','Barroso','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Barroso;Ruben;;;\r\nFN:Ruben Barroso\r\nTEL;type=CELL:+351937492624\r\nEMAIL;type=INTERNET;type=OTHER:ruben_barroso93@hotmail.com\r\nEND:VCARD',' ruben barroso 351937492624 ruben_barroso93@hotmail.com',1),(3,'2012-01-31 21:39:31',0,'Coelho','dunumax@gmail.com','','Coelho','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Coelho;;;;\r\nFN:Coelho\r\nEMAIL;type=INTERNET;type=OTHER:dunumax@gmail.com\r\nEND:VCARD',' colho dunumax@gmail.com',1),(4,'2012-01-31 21:39:32',0,'Tania Isabel Lourenco da Cruz','taniacruz_184@sapo.pt','Tania Isabel Lourenco da','Cruz','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Cruz;Tania Isabel Lourenco da;;;\r\nFN:Tania Isabel Lourenco da Cruz\r\nNICKNAME:Tanuska\r\nEMAIL;type=INTERNET;type=OTHER:taniacruz_184@sapo.pt\r\nEND:VCARD',' tania isabel lourenco cruz da tanuska taniacruz_184@sapo.pt',1),(5,'2012-01-31 21:39:31',0,'Bruno Cruz','ferreiracruz21@yahoo.de','Bruno','Cruz','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Cruz;Bruno;;;\r\nFN:Bruno Cruz\r\nTEL;type=home:+494018190449\r\nBDAY;value=date:1982-05-18\r\nEMAIL;type=INTERNET;type=OTHER:ferreiracruz21@yahoo.de\r\nEND:VCARD',' bruno cruz 494018190449 ferreiracruz21@yahoo.de',1),(6,'2012-01-31 21:39:31',0,'Joana Cruz','joana.cruz@hotmail.de','Joana','Cruz','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Cruz;Joana;;;\r\nFN:Joana Cruz\r\nTEL;type=home:+494018190449\r\nBDAY;value=date:1986-12-24\r\nEMAIL;type=INTERNET;type=OTHER:joana.cruz@hotmail.de\r\nEND:VCARD',' joana cruz 494018190449 joana.cruz@hotmail.de',1),(7,'2012-01-31 21:39:31',0,'Amorita Faustino','amorita@bardiagharib.com','Amorita','Faustino','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Faustino;Amorita;;;\r\nFN:Amorita Faustino\r\nEMAIL;type=INTERNET;type=OTHER:amorita@bardiagharib.com\r\nEND:VCARD',' amorita faustino amorita@bardiagharib.com',1),(8,'2012-01-31 21:39:31',0,'Joel Fonseca','joelmendesdafonseca@gmail.com','Joel','Fonseca','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Fonseca;Joel;;;\r\nFN:Joel Fonseca\r\nEMAIL;type=INTERNET;type=OTHER:joelmendesdafonseca@gmail.com\r\nEND:VCARD',' jol fonseca jolmendesdafonseca@gmail.com',1),(9,'2012-01-31 21:39:31',0,'Gil','lab_of_design@hotmail.com','','Gil','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Gil;;;;\r\nFN:Gil\r\nEMAIL;type=INTERNET;type=OTHER:lab_of_design@hotmail.com\r\nEND:VCARD',' gil lab_of_design@hotmail.com',1),(10,'2012-01-31 21:39:31',0,'Esmeralda Gomes','gomes.222@hotmail.com','Esmeralda','Gomes','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Gomes;Esmeralda;;;\r\nFN:Esmeralda Gomes\r\nTEL;type=home:+41419174556\r\nEMAIL;type=INTERNET;type=OTHER:gomes.222@hotmail.com\r\nADR;type=home:;;Luzernerstrasse 15b;Hitzkirch;;6285;Schweiz\r\nEND:VCARD',' esmeralda gomes 41419174556 gomes.222@hotmail.com schweiz 6285 hitzkirch luzernerstrasse 15b',1),(11,'2012-01-31 21:39:31',0,'Luis Amandio Ramos Gouveia','largouveia@netcabo.pt','Luis Amandio Ramos','Gouveia','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Gouveia;Luis Amandio Ramos;;;\r\nFN:Luis Amandio Ramos Gouveia\r\nEMAIL;type=INTERNET;type=OTHER:largouveia@netcabo.pt\r\nEND:VCARD',' luis amandio ramos gouveia largouveia@netcabo.pt',1),(12,'2012-01-31 21:39:31',0,'Guido Gruhn','guido@portugalparadies.de','Guido','Gruhn','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Gruhn;Guido;;;\r\nFN:Guido Gruhn\r\nEMAIL;type=INTERNET;type=OTHER:guido@portugalparadies.de\r\nEND:VCARD',' guido gruhn guido@portugalparadies.de',1),(13,'2012-01-31 21:39:31',0,'Frederico Hamann','friendlystay@gmail.com','Frederico','Hamann','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Hamann;Frederico;;;\r\nFN:Frederico Hamann\r\nEMAIL;type=INTERNET;type=OTHER:friendlystay@gmail.com\r\nEND:VCARD',' frederico hamann friendlystay@gmail.com',1),(14,'2012-01-31 21:39:31',0,'Markus Hertlein','markus_hertlein@hotmail.com','Markus','Hertlein','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Hertlein;Markus;;;\r\nFN:Markus Hertlein\r\nEMAIL;type=INTERNET;type=OTHER:markus_hertlein@hotmail.com\r\nEND:VCARD',' markus hertlein markus_hertlein@hotmail.com',1),(15,'2012-01-31 21:39:31',0,'Kelly Holmes','shlwlkr6@gmail.com','Kelly','Holmes','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Holmes;Kelly;;;\r\nFN:Kelly Holmes\r\nEMAIL;type=INTERNET;type=OTHER:shlwlkr6@gmail.com\r\nEND:VCARD',' kelly holmes shlwlkr6@gmail.com',1),(16,'2012-01-31 21:39:31',0,'Iberent','iberent@sapo.pt','','Iberent','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Iberent;;;;\r\nFN:Iberent\r\nEMAIL;type=INTERNET;type=OTHER:iberent@sapo.pt\r\nEND:VCARD',' iberent iberent@sapo.pt',1),(17,'2012-01-31 21:39:31',0,'Alvaro Landeira','alvaro@tima.pt','Alvaro','Landeira','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Landeira;Alvaro;;;\r\nFN:Alvaro Landeira\r\nEMAIL;type=INTERNET;type=OTHER:alvaro@tima.pt\r\nEND:VCARD',' alvaro landeira alvaro@tima.pt',1),(18,'2012-01-31 21:39:31',0,'Mike Ledig','info@gidel.de','Mike','Ledig','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Ledig;Mike;;;\r\nFN:Mike Ledig\r\nEMAIL;type=INTERNET;type=OTHER:info@gidel.de\r\nEND:VCARD',' mike ledig info@gidel.de',1),(19,'2012-01-31 21:39:31',0,'Joao Manuel Lourenco','jolourenco@sapo.pt','Joao Manuel','Lourenco','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Lourenco;Joao Manuel;;;\r\nFN:Joao Manuel Lourenco\r\nTEL;type=CELL:+3519117721958\r\nEMAIL;type=INTERNET;type=OTHER:jolourenco@sapo.pt\r\nEND:VCARD',' joao manul lourenco 3519117721958 jolourenco@sapo.pt',1),(20,'2012-01-31 21:39:31',0,'Jose Almerindo Freitas LuÃs','almerindo69@live.com.pt','Jose Almerindo Freitas','LuÃs','BEGIN:VCARD\r\nVERSION:3.0\r\nN:LuÃs;Jose Almerindo Freitas;;;\r\nFN:Jose Almerindo Freitas LuÃs\r\nEMAIL;type=INTERNET;type=OTHER:almerindo69@live.com.pt\r\nEND:VCARD',' jose almerindo freitas luis almerindo69@live.com.pt',1),(21,'2012-01-31 21:39:31',0,'Lurdes','milu959@hotmail.com','','Lurdes','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Lurdes;;;;\r\nFN:Lurdes\r\nEMAIL;type=INTERNET;type=OTHER:milu959@hotmail.com\r\nEND:VCARD',' lurdes milu959@hotmail.com',1),(22,'2012-01-31 21:39:32',0,'Susana Machado','s-machado@sympatico.ca','Susana','Machado','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Machado;Susana;;;\r\nFN:Susana Machado\r\nEMAIL;type=INTERNET;type=OTHER:s-machado@sympatico.ca\r\nEND:VCARD',' susana machado s machado@sympatico.ca',1),(23,'2012-01-31 21:39:31',0,'Megasis','megasis.rh@tap.pt','','Megasis','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Megasis;;;;\r\nFN:Megasis\r\nTEL;type=work:+351218416888\r\nEMAIL;type=INTERNET;type=OTHER:megasis.rh@tap.pt\r\nEND:VCARD',' megasis 351218416888 megasis.rh@tap.pt',1),(24,'2012-01-31 21:39:31',0,'Larry & Sonia Ourique','ourique2005@gmail.com','Larry & Sonia','Ourique','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Ourique;Larry & Sonia;;;\r\nFN:Larry & Sonia Ourique\r\nEMAIL;type=INTERNET;type=OTHER:ourique2005@gmail.com\r\nEND:VCARD',' larry & sonia ouriqu ouriqu2005@gmail.com',1),(25,'2012-01-31 21:39:31',0,'MANUEL OURIQUE','manuelourique@live.com','MANUEL','OURIQUE','BEGIN:VCARD\r\nVERSION:3.0\r\nN:OURIQUE;MANUEL;;;\r\nFN:MANUEL OURIQUE\r\nEMAIL;type=INTERNET;type=OTHER:manuelourique@live.com\r\nEND:VCARD',' manul ouriqu manulouriqu@live.com',1),(26,'2012-01-31 21:39:31',0,'Larry Ourique','lourique@PLANT.MIT.EDU','Larry','Ourique','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Ourique;Larry;;;\r\nFN:Larry Ourique\r\nEMAIL;type=INTERNET;type=OTHER:lourique@PLANT.MIT.EDU\r\nEND:VCARD',' larry ouriqu louriqu@plant.mit.edu',1),(27,'2012-01-31 21:39:31',0,'João Peralta','assiscal@sapo.pt','João','Peralta','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Peralta;João;;;\r\nFN:João Peralta\r\nEMAIL;type=INTERNET;type=OTHER:assiscal@sapo.pt\r\nEND:VCARD',' joao peralta assiscal@sapo.pt',1),(28,'2012-01-31 21:39:32',0,'Vitor Pinto','vitorpinto4@gmail.com','Vitor','Pinto','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Pinto;Vitor;;;\r\nFN:Vitor Pinto\r\nEMAIL;type=INTERNET;type=OTHER:vitorpinto4@gmail.com\r\nEND:VCARD',' vitor pinto vitorpinto4@gmail.com',1),(29,'2012-01-31 21:39:31',0,'Fernando Pinto','fmpinto@iol.pt','Fernando','Pinto','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Pinto;Fernando;;;\r\nFN:Fernando Pinto\r\nEMAIL;type=INTERNET;type=OTHER:fmpinto@iol.pt\r\nEND:VCARD',' fernando pinto fmpinto@iol.pt',1),(30,'2012-01-31 21:39:31',0,'Carlos Pinto','carlospintoedfisica@sapo.pt','Carlos','Pinto','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Pinto;Carlos;;;\r\nFN:Carlos Pinto\r\nTEL;type=CELL:+351933202444\r\nEMAIL;type=INTERNET;type=OTHER:carlospintoedfisica@sapo.pt\r\nEND:VCARD',' carlos pinto 351933202444 carlospintodfisica@sapo.pt',1),(31,'2012-01-31 21:39:31',0,'LuÃs Silva Reis','morsilva_5@hotmail.com','LuÃs','Reis','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Reis;LuÃs;Silva;;\r\nFN:LuÃs Silva Reis\r\nEMAIL;type=INTERNET;type=OTHER:morsilva_5@hotmail.com\r\nEND:VCARD',' luis silva reis morsilva_5@hotmail.com',1),(32,'2012-01-31 21:39:32',0,'Susana Ribeiro','kirilinca@hotmail.com','Susana','Ribeiro','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Ribeiro;Susana;;;\r\nFN:Susana Ribeiro\r\nTEL;type=CELL:+351966829919\r\nEMAIL;type=INTERNET;type=OTHER:kirilinca@hotmail.com\r\nEND:VCARD',' susana ribeiro 351966829919 kirilinca@hotmail.com',1),(33,'2012-01-31 21:39:31',0,'Ricardo Ribeiro','ricardoribeiro@iol.pt','Ricardo','Ribeiro','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Ribeiro;Ricardo;;;\r\nFN:Ricardo Ribeiro\r\nEMAIL;type=INTERNET;type=OTHER:ricardoribeiro@iol.pt\r\nEND:VCARD',' ricardo ribeiro ricardoribeiro@iol.pt',1),(34,'2012-01-31 21:39:31',0,'Paulo Rino','paulo.rino@gmail.com','Paulo','Rino','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Rino;Paulo;;;\r\nFN:Paulo Rino\r\nEMAIL;type=INTERNET;type=OTHER:paulo.rino@gmail.com\r\nEND:VCARD',' paulo rino paulo.rino@gmail.com',1),(35,'2012-01-31 21:39:31',0,'Nicole Rodrigues','nikole.rodrigues@hotmail.de','Nicole','Rodrigues','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Rodrigues;Nicole;;;\r\nFN:Nicole Rodrigues\r\nTEL;type=home:+49231839999\r\nEMAIL;type=INTERNET;type=OTHER:nikole.rodrigues@hotmail.de\r\nEND:VCARD',' nicole rodrigus 49231839999 nikole.rodrigus@hotmail.de',1),(36,'2012-01-31 21:39:32',0,'Sandra','sandrabarrigabico@hotmail.com','','Sandra','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Sandra;;;;\r\nFN:Sandra\r\nEMAIL;type=INTERNET;type=OTHER:sandrabarrigabico@hotmail.com\r\nEND:VCARD',' sandra sandrabarrigabico@hotmail.com',1),(37,'2012-01-31 21:39:31',0,'Marina Santos','marinasantos@live.com.pt','Marina','Santos','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Santos;Marina;;;\r\nFN:Marina Santos\r\nEMAIL;type=INTERNET;type=OTHER:marinasantos@live.com.pt\r\nEND:VCARD',' marina santos marinasantos@live.com.pt',1),(38,'2012-01-31 21:39:31',0,'Jose Santos','jose.santos@torrestir.pt','Jose','Santos','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Santos;Jose;;;\r\nFN:Jose Santos\r\nEMAIL;type=INTERNET;type=OTHER:jose.santos@torrestir.pt\r\nEND:VCARD',' jose santos jose.santos@torrestir.pt',1),(39,'2012-01-31 21:39:31',0,'Christian Schrott','christian.schrott@t-online.de','Christian','Schrott','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Schrott;Christian;;;\r\nFN:Christian Schrott\r\nEMAIL;type=INTERNET;type=OTHER:christian.schrott@t-online.de\r\nEND:VCARD',' christian schrott christian.schrott@t online.de',1),(40,'2012-01-31 21:39:31',0,'Elmano Silva','elmano.silva@gmail.com','Elmano','Silva','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Silva;Elmano;;;\r\nFN:Elmano Silva\r\nEMAIL;type=INTERNET;type=OTHER:elmano.silva@gmail.com\r\nEND:VCARD',' elmano silva elmano.silva@gmail.com',1),(41,'2012-01-31 21:39:31',0,'Günther Sörgel','gsoergel@aocruz.de','Günther','Sörgel','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Sörgel;Günther;;;\r\nFN:Günther Sörgel\r\nEMAIL;type=INTERNET;type=OTHER:gsoergel@aocruz.de\r\nEND:VCARD',' gunther sorgel gsorgel@aocruz.de',1),(42,'2012-01-31 21:39:31',0,'Eddy Stranzenbach','stranzenbach@web.de','Eddy','Stranzenbach','BEGIN:VCARD\r\nVERSION:3.0\r\nN:Stranzenbach;Eddy;;;\r\nFN:Eddy Stranzenbach\r\nNICKNAME:Eddy\r\nEMAIL;type=INTERNET;type=OTHER:stranzenbach@web.de\r\nEND:VCARD',' eddy stranzenbach stranzenbach@web.de',1),(43,'2012-01-31 21:39:32',0,'Sabine Stäblein','BMW.STH@t-online.de','','','BEGIN:VCARD\r\nVERSION:3.0\r\nFN:Sabine Stäblein\r\nEMAIL;type=INTERNET:BMW.STH@t-online.de\r\nEND:VCARD',' sabine stablein bmw.sth@t online.de',1);
264/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `dictionary`
269--
270
271DROP TABLE IF EXISTS `dictionary`;
272SET @saved_cs_client = @@character_set_client;
273SET character_set_client = utf8;
274CREATE TABLE `dictionary` (
275 `user_id` int(10) unsigned default NULL,
276 `language` varchar(5) NOT NULL,
277 `data` longtext NOT NULL,
278 UNIQUE KEY `uniqueness` (`user_id`,`language`),
279 CONSTRAINT `user_id_fk_dictionary` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
280) ENGINE=InnoDB DEFAULT CHARSET=utf8;
281SET character_set_client = @saved_cs_client;
282
283--
284-- Dumping data for table `dictionary`
285--
286
287LOCK TABLES `dictionary` WRITE;
288/*!40000 ALTER TABLE `dictionary` DISABLE KEYS */;
289/*!40000 ALTER TABLE `dictionary` ENABLE KEYS */;
290UNLOCK TABLES;
291
292--
293-- Table structure for table `events`
294--
295
296DROP TABLE IF EXISTS `events`;
297SET @saved_cs_client = @@character_set_client;
298SET character_set_client = utf8;
299CREATE TABLE `events` (
300 `event_id` int(11) unsigned NOT NULL auto_increment,
301 `uid` text,
302 `recurrence_id` text,
303 `user_id` int(10) unsigned NOT NULL default '0',
304 `start` int(10) unsigned NOT NULL default '0',
305 `end` int(10) unsigned NOT NULL default '0',
306 `expires` int(10) unsigned NOT NULL default '0',
307 `rr` varchar(1) default NULL,
308 `recurring` text NOT NULL,
309 `occurrences` int(11) default '0',
310 `byday` text,
311 `bymonth` text,
312 `bymonthday` text,
313 `summary` varchar(255) NOT NULL,
314 `description` text NOT NULL,
315 `location` varchar(255) NOT NULL default '',
316 `categories` varchar(255) NOT NULL default '',
317 `all_day` tinyint(1) NOT NULL default '0',
318 `group` text,
319 `caldav` text,
320 `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
321 `del` int(1) NOT NULL default '0',
322 `notified` int(1) NOT NULL default '0',
323 `client` text,
324 PRIMARY KEY (`event_id`),
325 KEY `user_id_fk_events` (`user_id`),
326 CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
327) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8;
328SET character_set_client = @saved_cs_client;
329
330--
331-- Dumping data for table `events`
332--
333
334LOCK TABLES `events` WRITE;
335/*!40000 ALTER TABLE `events` DISABLE KEYS */;
336INSERT INTO `events` VALUES (1,'1@tcruz@','0',1,1307664000,1309132740,1309730340,'0','0',0,'','','','Motorradtour','Motorradtour nach Portugal','Europa','Holiday',1,NULL,NULL,'2011-07-01 19:08:15',0,0,'0'),(2,'Neujahr-Bayern-201101011152551978@schulferien.org','0',1,1293840000,1293926399,1893452399,'0','0',0,'0','0','0','Neujahr','Neujahr ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:57',0,0,'0'),(3,'Heilige Drei Koenige-Bayern-201101061047951731@schulferien.org','0',1,1294272000,1294358399,1893452399,'0','0',0,'0','0','0','Heilige Drei Koenige','Heilige Drei Koenige ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:57',0,0,'0'),(4,'Karfreitag-Bayern-201104221142747631@schulferien.org','0',1,1303430400,1303516799,1893452399,'0','0',0,'0','0','0','Karfreitag','Karfreitag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:57',0,0,'0'),(5,'Ostermontag-Bayern-201104251270931637@schulferien.org','0',1,1303689600,1303775999,1893452399,'0','0',0,'0','0','0','Ostermontag','Ostermontag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:57',0,0,'0'),(6,'Tag der Arbeit-Bayern-201105011301263672@schulferien.org','0',1,1304208000,1304294399,1893452399,'0','0',0,'0','0','0','Tag der Arbeit','Tag der Arbeit ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:57',0,0,'0'),(7,'Christi Himmelfahrt-Bayern-201106021179827961@schulferien.org','0',1,1306972800,1307059199,1893452399,'0','0',0,'0','0','0','Christi Himmelfahrt','Christi Himmelfahrt ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(8,'Pfingstmontag-Bayern-201106131296409277@schulferien.org','0',1,1307923200,1308009599,1893452399,'0','0',0,'0','0','0','Pfingstmontag','Pfingstmontag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(9,'Fronleichnam-Bayern-201106231234703184@schulferien.org','0',1,1308787200,1308873599,1893452399,'0','0',0,'0','0','0','Fronleichnam','Fronleichnam ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(10,'Mariae Himmelfahrt-Bayern-201108151097814126@schulferien.org','0',1,1313366400,1313452799,1893452399,'0','0',0,'0','0','0','Mariae Himmelfahrt','Mariae Himmelfahrt ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(11,'Tag der Deutschen Einheit-Bayern-201110031364606954@schulferien.org','0',1,1317600000,1317686399,1893452399,'0','0',0,'0','0','0','Tag der Deutschen Einheit','Tag der Deutschen Einheit ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(12,'Allerheiligen-Bayern-201111011209422107@schulferien.org','0',1,1320105600,1320191999,1893452399,'0','0',0,'0','0','0','Allerheiligen','Allerheiligen ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(13,'1. Weihnachtsfeiertag-Bayern-201112251146228494@schulferien.org','0',1,1324771200,1324857599,1893452399,'0','0',0,'0','0','0','1. Weihnachtsfeiertag','1. Weihnachtsfeiertag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(14,'2. Weihnachtsfeiertag-Bayern-201112261394299461@schulferien.org','0',1,1324857600,1324943999,1893452399,'0','0',0,'0','0','0','2. Weihnachtsfeiertag','2. Weihnachtsfeiertag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:10:58',0,0,'0'),(15,'Neujahr-Bayern-201201011195868091@schulferien.org','0',1,1325376000,1325462399,1893452399,'0','0',0,'0','0','0','Neujahr','Neujahr ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(16,'Heilige Drei Koenige-Bayern-201201061041507500@schulferien.org','0',1,1325808000,1325894399,1893452399,'0','0',0,'0','0','0','Heilige Drei Koenige','Heilige Drei Koenige ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(17,'Karfreitag-Bayern-201204061166973285@schulferien.org','0',1,1333670400,1333756799,1893452399,'0','0',0,'0','0','0','Karfreitag','Karfreitag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(18,'Ostermontag-Bayern-201204091347950467@schulferien.org','0',1,1333929600,1334015999,1893452399,'0','0',0,'0','0','0','Ostermontag','Ostermontag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(19,'Tag der Arbeit-Bayern-201205011241318343@schulferien.org','0',1,1335830400,1335916799,1893452399,'0','0',0,'0','0','0','Tag der Arbeit','Tag der Arbeit ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(20,'Christi Himmelfahrt-Bayern-201205171319659107@schulferien.org','0',1,1337212800,1337299199,1893452399,'0','0',0,'0','0','0','Christi Himmelfahrt','Christi Himmelfahrt ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(21,'Pfingstmontag-Bayern-201205281171007610@schulferien.org','0',1,1338163200,1338249599,1893452399,'0','0',0,'0','0','0','Pfingstmontag','Pfingstmontag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(22,'Fronleichnam-Bayern-201206071105744321@schulferien.org','0',1,1339027200,1339113599,1893452399,'0','0',0,'0','0','0','Fronleichnam','Fronleichnam ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(23,'Mariae Himmelfahrt-Bayern-201208151288616338@schulferien.org','0',1,1344988800,1345075199,1893452399,'0','0',0,'0','0','0','Mariae Himmelfahrt','Mariae Himmelfahrt ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(24,'Tag der Deutschen Einheit-Bayern-201210031362731084@schulferien.org','0',1,1349222400,1349308799,1893452399,'0','0',0,'0','0','0','Tag der Deutschen Einheit','Tag der Deutschen Einheit ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(25,'Allerheiligen-Bayern-201211011370757665@schulferien.org','0',1,1351728000,1351814399,1893452399,'0','0',0,'0','0','0','Allerheiligen','Allerheiligen ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(26,'1. Weihnachtsfeiertag-Bayern-201212251175356348@schulferien.org','0',1,1356393600,1356479999,1893452399,'0','0',0,'0','0','0','1. Weihnachtsfeiertag','1. Weihnachtsfeiertag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(27,'2. Weihnachtsfeiertag-Bayern-201212261372503746@schulferien.org','0',1,1356480000,1356566399,1893452399,'0','0',0,'0','0','0','2. Weihnachtsfeiertag','2. Weihnachtsfeiertag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:22',0,0,'0'),(28,'Neujahr-Bayern-201301011128232937@schulferien.org','0',1,1356998400,1357084799,1893452399,'0','0',0,'0','0','0','Neujahr','Neujahr ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(29,'Heilige Drei Koenige-Bayern-201301061053483186@schulferien.org','0',1,1357430400,1357516799,1893452399,'0','0',0,'0','0','0','Heilige Drei Koenige','Heilige Drei Koenige ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(30,'Karfreitag-Bayern-201303291146760353@schulferien.org','0',1,1364515200,1364601599,1893452399,'0','0',0,'0','0','0','Karfreitag','Karfreitag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(31,'Ostermontag-Bayern-201304011120118795@schulferien.org','0',1,1364774400,1364860799,1893452399,'0','0',0,'0','0','0','Ostermontag','Ostermontag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(32,'Tag der Arbeit-Bayern-201305011064439925@schulferien.org','0',1,1367366400,1367452799,1893452399,'0','0',0,'0','0','0','Tag der Arbeit','Tag der Arbeit ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(33,'Christi Himmelfahrt-Bayern-201305091409556164@schulferien.org','0',1,1368057600,1368143999,1893452399,'0','0',0,'0','0','0','Christi Himmelfahrt','Christi Himmelfahrt ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(34,'Pfingstmontag-Bayern-201305201280797157@schulferien.org','0',1,1369008000,1369094399,1893452399,'0','0',0,'0','0','0','Pfingstmontag','Pfingstmontag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(35,'Fronleichnam-Bayern-201305301224555649@schulferien.org','0',1,1369872000,1369958399,1893452399,'0','0',0,'0','0','0','Fronleichnam','Fronleichnam ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(36,'Mariae Himmelfahrt-Bayern-201308151062077680@schulferien.org','0',1,1376524800,1376611199,1893452399,'0','0',0,'0','0','0','Mariae Himmelfahrt','Mariae Himmelfahrt ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(37,'Tag der Deutschen Einheit-Bayern-201310031085182272@schulferien.org','0',1,1380758400,1380844799,1893452399,'0','0',0,'0','0','0','Tag der Deutschen Einheit','Tag der Deutschen Einheit ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:48',0,0,'0'),(38,'Allerheiligen-Bayern-201311011281363265@schulferien.org','0',1,1383264000,1383350399,1893452399,'0','0',0,'0','0','0','Allerheiligen','Allerheiligen ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:49',0,0,'0'),(39,'1. Weihnachtsfeiertag-Bayern-201312251104894118@schulferien.org','0',1,1387929600,1388015999,1893452399,'0','0',0,'0','0','0','1. Weihnachtsfeiertag','1. Weihnachtsfeiertag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:49',0,0,'0'),(40,'2. Weihnachtsfeiertag-Bayern-201312261387620950@schulferien.org','0',1,1388016000,1388102399,1893452399,'0','0',0,'0','0','0','2. Weihnachtsfeiertag','2. Weihnachtsfeiertag ist gesetzlicher Feiertag in Bayern. Alle Termine auf www.schulferien.org/Feiertage','','',1,NULL,NULL,'2011-06-02 18:11:49',0,0,'0'),(41,'Winterferien-Bayern-201103121032176069@schulferien.org','0',1,1299456000,1299887999,1893452399,'0','0',0,'0','0','0','Winterferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(42,'Osterferien-Bayern-201105011398472534@schulferien.org','0',1,1303084800,1304207999,1893452399,'0','0',0,'0','0','0','Osterferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(43,'Pfingstferien-Bayern-201106261224785024@schulferien.org','0',1,1308009600,1309046399,1893452399,'0','0',0,'0','0','0','Pfingstferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(44,'Sommerferien-Bayern-201109131334640396@schulferien.org','0',1,1311984000,1315871999,1893452399,'0','0',0,'0','0','0','Sommerferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(45,'Herbstferien-Bayern-201111061262737181@schulferien.org','0',1,1320019200,1320537599,1893452399,'0','0',0,'0','0','0','Herbstferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(46,'Weihnachtsferien-Bayern-201101081167400834@schulferien.org','0',1,1293840000,1294444799,1893452399,'0','0',0,'0','0','0','Weihnachtsferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(47,'Weihnachtsferien-Bayern-201201011316815636@schulferien.org','0',1,1324944000,1325375999,1893452399,'0','0',0,'0','0','0','Weihnachtsferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:00',0,0,'0'),(48,'Winterferien-Bayern-201202251048086714@schulferien.org','0',1,1329696000,1330127999,1893452399,'0','0',0,'0','0','0','Winterferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(49,'Osterferien-Bayern-201204151075766896@schulferien.org','0',1,1333324800,1334447999,1893452399,'0','0',0,'0','0','0','Osterferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(50,'Pfingstferien-Bayern-201206101144195646@schulferien.org','0',1,1338249600,1339286399,1893452399,'0','0',0,'0','0','0','Pfingstferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(51,'Sommerferien-Bayern-201209131019428872@schulferien.org','0',1,1343779200,1347494399,1893452399,'0','0',0,'0','0','0','Sommerferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(52,'Herbstferien-Bayern-201211041278322835@schulferien.org','0',1,1351468800,1351987199,1893452399,'0','0',0,'0','0','0','Herbstferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(53,'Weihnachtsferien-Bayern-201201061209460610@schulferien.org','0',1,1325376000,1325807999,1893452399,'0','0',0,'0','0','0','Weihnachtsferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(54,'Weihnachtsferien-Bayern-201301011020499449@schulferien.org','0',1,1356307200,1356998399,1893452399,'0','0',0,'0','0','0','Weihnachtsferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:19',0,0,'0'),(55,'Winterferien-Bayern-201302161369875362@schulferien.org','0',1,1360540800,1360972799,1893452399,'0','0',0,'0','0','0','Winterferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(56,'Osterferien-Bayern-201304071016221636@schulferien.org','0',1,1364169600,1365292799,1893452399,'0','0',0,'0','0','0','Osterferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(57,'Pfingstferien-Bayern-201306011293220899@schulferien.org','0',1,1369094400,1370044799,1893452399,'0','0',0,'0','0','0','Pfingstferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(58,'Sommerferien-Bayern-201309121267564999@schulferien.org','0',1,1375228800,1378943999,1893452399,'0','0',0,'0','0','0','Sommerferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(59,'Herbstferien-Bayern-201311011198654777@schulferien.org','0',1,1382918400,1383263999,1893452399,'0','0',0,'0','0','0','Herbstferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(60,'Weihnachtsferien-Bayern-201301061347330672@schulferien.org','0',1,1356998400,1357430399,1893452399,'0','0',0,'0','0','0','Weihnachtsferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(61,'Weihnachtsferien-Bayern-201401011115536001@schulferien.org','0',1,1387756800,1388534399,1893452399,'0','0',0,'0','0','0','Weihnachtsferien Bayern','Alle Termine auf www.schulferien.org','','',1,NULL,NULL,'2011-06-02 18:12:30',0,0,'0'),(62,'62@tcruz@','0',1,1319846400,1320627540,1320627540,'0','0',0,'','','','Urlaub','Urlaub in Portugal mit Kim und Kelly','Capeludos','Holiday',1,NULL,NULL,'2011-06-02 19:52:41',0,0,'0'),(63,'63@tcruz@','0',1,1324684800,1325462340,1325455140,'0','0',0,'','','','Urlaub','','Erding','Holiday',1,NULL,NULL,'2011-06-02 19:53:52',0,0,'0'),(64,'64@tania_cruz@','0',2,1308528000,1308614340,1308614340,'0','0',0,'','','','Aniversário Mãe','','St° Estevão','Family',1,NULL,NULL,'2011-06-02 20:18:04',1,0,'0'),(65,'4LOA3CFlightMUC_201110290610_201110290715','0',1,1319861400,1319865300,1893452340,'0','0',0,'','','','4LOA3C - Flight: München - Frankfurt (Lufthansa LH 099)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 099: \n \n \n From: München International (München, Deutschland) - Terminal2 at Sat, Oct 29, 2011 06:10 (local time) \n To: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sat, Oct 29, 2011 07:15 (local time) \n Cabin: Economy\n Duration: 01:05\n Stop(s): 0\n Aircraft: Airbus Industrie A321','München International (München, Deutschland)','Holiday',0,NULL,NULL,'2011-07-05 06:57:30',0,0,'0'),(66,'4LOA3CFlightFRA_201110290845_201110291025','0',1,1319870700,1319880300,1893452340,'0','0',0,'','','','4LOA3C - Flight: Frankfurt - Porto (Lufthansa LH 1176)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 1176: \n \n \n From: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sat, Oct 29, 2011 08:45 (local time) \n To: Francisco SA Carneiro (Porto, Portugal) at Sat, Oct 29, 2011 10:25 (local time) \n Cabin: Economy\n Duration: 02:40\n Stop(s): 0\n Aircraft: Airbus Industrie A321','Frankfurt International (Frankfurt, Deutschland)','Holiday',0,NULL,NULL,'2011-07-05 06:57:42',0,0,'0'),(67,'4LOA3CFlightOPO_201111060600_201111060955','0',1,1320562800,1320573300,1893452340,'0','0',0,'','','','4LOA3C - Flight: Porto - Frankfurt (Lufthansa LH 1181)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 1181: \n \n \n From: Francisco SA Carneiro (Porto, Portugal) at Sun, Nov 6, 2011 06:00 (local time) \n To: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sun, Nov 6, 2011 09:55 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 02:55\n Stop(s): 0\n Aircraft: Airbus Industrie A321','Francisco SA Carneiro (Porto, Portugal)','Holiday',0,NULL,NULL,'2011-07-05 06:57:57',0,0,'0'),(68,'4LOA3CFlightFRA_201111061155_201111061300','0',1,1320580500,1320584400,1893452340,'0','0',0,'','','','4LOA3C - Flight: Frankfurt - München (Lufthansa LH 108)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 108: \n \n \n From: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sun, Nov 6, 2011 11:55 (local time) \n To: München International (München, Deutschland) - Terminal2 at Sun, Nov 6, 2011 13:00 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 01:05\n Stop(s): 0\n Aircraft: Airbus Industrie A321','Frankfurt International (Frankfurt, Deutschland)','Holiday',0,NULL,NULL,'2011-07-05 06:58:12',0,0,'0'),(69,'69@tcruz@','0',1,1314403200,1314489540,1314489540,'0','0',0,'','','','BMW K1600 GT','Abholung de BMW K1600 GT','Möhra','Personal',1,NULL,NULL,'2011-07-19 10:33:46',0,0,'0'),(70,'5636c46d5fefbf1b5c2ee9089b0bf396','0',1,1314370800,1314450000,1893452340,'0','0',0,'','','','Ibis Hotel Eisenach','Ankunft: Freitag, 26. August 2011, anreise 13:00 – 22:00\n\nAbreise: Samstag, 27. August 2011, abreise 08:00 – 11:00','Am Grundbach 1, Eisenach, 99819, Deutschland','Holiday',0,NULL,NULL,'2011-07-19 19:38:45',0,0,'0'),(71,'71@tcruz@','0',1,1344643200,1346543940,1346543940,'0','0',0,'','','','Urlaub','','Portugal','Holiday',1,NULL,NULL,'2011-09-02 06:24:48',0,0,'0'),(72,'72@tcruz@','0',1,1317912300,1317915900,1317938340,'0','0',0,'','','','Tania - Hautarzt','Landshuter Straße 12, Erding','Erding','Arzt',0,NULL,NULL,'2011-10-06 08:40:52',0,0,'0'),(73,'73@tcruz@','0',1,1319016600,1319020200,1319061540,'0','0',0,'','','','Tania - Frauenärztin','Bajuwarenstr. 7, 85435 Erding','Erding','Arzt',0,NULL,NULL,'2011-10-06 08:41:03',0,0,'0'),(74,'74@tcruz@','0',1,1318579200,1318582800,1318629540,'0','0',0,'','','','Hautarzt Tânia','','Erding','Arzt',0,NULL,NULL,'2011-10-07 18:24:08',0,0,'0'),(75,'75@tcruz@','0',1,1319032800,1319038200,1319061540,'0','0',0,'','','','Fahrstunde Tânia','Fahrschule Englberger','Erding','',0,NULL,NULL,'2011-10-13 19:15:29',0,0,'0'),(76,'76@tania_cruz@','0',2,1321002000,1321007400,1321055940,'0','0',0,'','','','Aula de Condução','O Matias vem-me buscar a casa.','Erding','Pessoal',0,NULL,NULL,'2011-10-27 12:16:26',0,0,'0'),(77,'77@tania_cruz@','0',2,1320667200,1320672600,1320710340,'d','86400',0,'','','','Programa de Treino com a Sandra','','Body and Soul Erding','Pessoal',0,NULL,NULL,'2011-10-27 12:16:37',0,0,'0'),(78,'78@tania_cruz@','0',2,1317945600,1318031940,1318028340,'0','0',0,'','','','Avó Antonieta','','Capeludos de Aguiar','Aniversários',1,NULL,NULL,'2011-10-27 12:13:10',1,0,'0'),(79,'79@tania_cruz@','0',2,1318377600,1318463940,1318463940,'0','0',0,'','','','Primo João Martin','','Coimbra','Aniversários',1,NULL,NULL,'2011-10-27 12:18:48',1,0,'0'),(80,'80@tania_cruz@','0',2,1318723200,1318809540,1318809540,'0','0',0,'','','','Tia Tonicha','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-27 12:18:51',1,0,'0'),(81,'81@tania_cruz@','0',2,1319328000,1319414340,1319414340,'0','0',0,'','','','Tiago Paulo','','Benavente','Aniversários',1,NULL,NULL,'2011-10-27 12:18:54',1,0,'0'),(82,'82@tania_cruz@','0',2,1319500800,1319587140,1319587140,'0','0',0,'','','','Mor','','Erding','Aniversários',1,NULL,NULL,'2011-10-27 12:19:00',1,0,'0'),(83,'83@tania_cruz@','0',2,1319587200,1319673540,1319673540,'0','0',0,'','','','Catarina Martins','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-27 12:18:57',1,0,'0'),(84,'84@tania_cruz@','0',2,1320624000,1320710340,1320710340,'0','0',0,'','','','Avó Antonieta','','Capeludos de Aguiar','Aniversários',1,NULL,NULL,'2011-10-27 12:13:22',1,0,'0'),(85,'85@tania_cruz@','0',2,1320624000,1320710340,1893455940,'y','31536000',0,'','','','Avó Antonieta','','Capeludos de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:44:11',0,0,'0'),(86,'86@tania_cruz@','0',2,1321056000,1321142340,1893455940,'y','31536000',0,'','','','Primo João Matin','','Coimbra','Aniversários',1,NULL,NULL,'2011-10-30 15:44:31',0,0,'0'),(87,'87@tania_cruz@','0',2,1321401600,1321487940,1893455940,'y','31536000',0,'','','','Tia Tonicha','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:44:40',0,0,'0'),(88,'88@tania_cruz@','0',2,1322006400,1322092740,1893455940,'y','31536000',0,'','','','Tiago Paulo','','Benavente','Aniversários',1,NULL,NULL,'2011-10-30 15:44:48',0,0,'0'),(89,'89@tania_cruz@','0',2,1322179200,1322265540,1893455940,'y','31536000',0,'','','','Mor','','Erding','Aniversários',1,NULL,NULL,'2011-10-30 15:44:55',0,0,'0'),(90,'90@tania_cruz@','0',2,1322265600,1322351940,1893455940,'y','31536000',0,'','','','Catarina Martins','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:45:04',0,0,'0'),(91,'91@tania_cruz@','0',2,1324252800,1324339140,1893455940,'y','31536000',0,'','','','Avó Maria','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:45:26',0,0,'0'),(92,'92@tania_cruz@','0',2,1324771200,1324857540,1893455940,'y','31536000',0,'','','','Natal','','','Public',1,NULL,NULL,'2011-10-30 15:45:33',0,0,'0'),(93,'93@tania_cruz@','0',2,1325462400,1325548740,1893455940,'y','31536000',0,'','','','Mónica Ribeiro','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:45:52',0,0,'0'),(94,'94@tania_cruz@','0',2,1326585600,1326671940,1893455940,'y','31536000',0,'','','','Fernando Góis','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:46:08',0,0,'0'),(95,'95@tania_cruz@','0',2,1326585600,1326671940,1893455940,'y','31536000',0,'','','','Cátia Rosa','','Santo Estêvao','Aniversários',1,NULL,NULL,'2011-10-30 15:46:15',0,0,'0'),(96,'96@tania_cruz@','0',2,1326067200,1326153540,1893455940,'y','31536000',0,'','','','Manel Sousa','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:45:59',0,0,'0'),(97,'97@tania_cruz@','0',2,1329004800,1329091140,1893455940,'y','31536000',0,'','','','Raquel Tavares','','Cidadelha se Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:46:25',0,0,'0'),(98,'98@tania_cruz@','0',2,1329091200,1329177540,1893455940,'y','31536000',0,'','','','Alexandre Miguel Gois Moura','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:46:35',0,0,'0'),(99,'99@tania_cruz@','0',2,1331769600,1331855940,1893455940,'y','31536000',0,'','','','Avô João','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:47:24',0,0,'0'),(100,'100@tania_cruz@','0',2,1331769600,1331855940,1893455940,'y','31536000',0,'','','','LuÃs Silva','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:47:12',0,0,'0'),(101,'101@tania_cruz@','0',2,1331769600,1331855940,1893455940,'y','31536000',0,'','','','Tio Zé Victor','','Entroncamento','Aniversários',1,NULL,NULL,'2011-10-30 15:47:19',0,0,'0'),(102,'102@tania_cruz@','0',2,1331769600,1331855940,1893455940,'y','31536000',0,'','','','Zé Agostinho','','Cidadelha de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:47:33',0,0,'0'),(103,'103@tania_cruz@','0',2,1331769600,1331855940,1893455940,'y','31536000',0,'','','','Tânia Lamas','','Vila Pouca de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:47:41',0,0,'0'),(104,'104@tania_cruz@','0',2,1332547200,1332633540,1893455940,'y','31536000',0,'','','','Madrinha Celeste','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:47:49',0,0,'0'),(105,'105@tania_cruz@','0',2,1333497600,1333583940,1893459540,'y','31536000',0,'','','','Sara','','Freixeda','Aniversários',1,NULL,NULL,'2011-10-30 15:47:57',0,0,'0'),(106,'106@tania_cruz@','0',2,1333756800,1333843140,1893459540,'y','31536000',0,'','','','Jasão Jonas Grilo Ferreira (Jota)','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:48:03',0,0,'0'),(107,'107@tania_cruz@','0',2,1333929600,1334015940,1893459540,'y','31536000',0,'','','','Tio Chico Zé','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:48:25',0,0,'0'),(108,'108@tania_cruz@','0',2,1334102400,1334188740,1893459540,'y','31536000',0,'','','','Adriana','','Capeludos de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:48:41',0,0,'0'),(109,'109@tania_cruz@','0',2,1334102400,1334188740,1893459540,'0','0',0,'','','','Tio LuÃs','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:23:03',0,0,'0'),(110,'110@tania_cruz@','0',2,1334275200,1334361540,1893459540,'y','31536000',0,'','','','Fábio (Keke)','','Vila Pouca de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:48:47',0,0,'0'),(111,'111@tania_cruz@','0',2,1334707200,1334793540,1893459540,'0','0',0,'','','','Avô Tó','','Samora Correia','Aniversários',1,NULL,NULL,'2011-10-30 15:48:55',0,0,'0'),(112,'112@tania_cruz@','0',2,1334707200,1334793540,1893459540,'y','31536000',0,'','','','Ana Rua','','Castanheira do Ribatejo','Aniversários',1,NULL,NULL,'2011-10-30 15:49:02',0,0,'0'),(113,'113@tania_cruz@','0',2,1335139200,1335225540,1893459540,'y','31536000',0,'','','','Tânia Santos','','Loures','Aniversários',1,NULL,NULL,'2011-10-30 15:49:09',0,0,'0'),(114,'114@tania_cruz@','0',2,1335830400,1335916740,1893459540,'y','31536000',0,'','','','Marina Alves','','Fontes','Aniversários',1,NULL,NULL,'2011-10-30 15:49:21',0,0,'0'),(115,'115@tania_cruz@','0',2,1335916800,1336003140,1893459540,'y','31536000',0,'','','','Prima Susana','','Vialonga','Aniversários',1,NULL,NULL,'2011-10-30 15:50:00',0,0,'0'),(116,'116@tania_cruz@','0',2,1336867200,1336953540,1893459540,'y','31536000',0,'','','','Emilia Valério','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:50:07',0,0,'0'),(117,'117@tania_cruz@','0',2,1337299200,1337385540,1893459540,'y','31536000',0,'','','','Nádia Brigas','','Vila Pouca de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:50:13',0,0,'0'),(118,'118@tania_cruz@','0',2,1337299200,1337385540,1893459540,'y','31536000',0,'','','','Kelly','','Erding','Aniversários',1,NULL,NULL,'2011-10-30 15:50:29',0,0,'0'),(119,'119@tania_cruz@','0',2,1338163200,1338249540,1893459540,'y','31536000',0,'','','','Sara Taveira Saraiva','','Cidadelha de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:50:37',0,0,'0'),(120,'120@tania_cruz@','0',2,1339372800,1339459140,1893459540,'y','31536000',0,'','','','Andreia Horta','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:50:51',0,0,'0'),(121,'121@tania_cruz@','0',2,1339545600,1339631940,1893459540,'y','31536000',0,'','','','Idalina Barreto','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:50:58',0,0,'0'),(122,'122@tania_cruz@','0',2,1340150400,1340236740,1893459540,'y','31536000',0,'','','','Mãe','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:51:07',0,0,'0'),(123,'123@tania_cruz@','0',2,1340236800,1340323140,1893459540,'y','31536000',0,'','','','Ana Isabel Monteiro Coelho','','Nuzedo','Aniversários',1,NULL,NULL,'2011-10-30 15:51:14',0,0,'0'),(124,'124@tania_cruz@','0',2,1342224000,1342310340,1893459540,'y','31536000',0,'','','','João Pintassilgo','','Benavente','Aniversários',1,NULL,NULL,'2011-10-30 15:51:26',0,0,'0'),(125,'125@tania_cruz@','0',2,1342310400,1342396740,1893459540,'y','31536000',0,'','','','Filipe (Piwipinho)','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:51:33',0,0,'0'),(126,'126@tania_cruz@','0',2,1342310400,1342396740,1893459540,'y','31536000',0,'','','','André Filipe dos Santos Brioso','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:51:39',0,0,'0'),(127,'127@tania_cruz@','0',2,1342656000,1342742340,1893459540,'y','31536000',0,'','','','Ana Carolina Garcia Ganhão Horta (Prima)','','Differdange','Aniversários',1,NULL,NULL,'2011-10-30 15:51:46',0,0,'0'),(128,'128@tania_cruz@','0',2,1343347200,1343433540,1893459540,'y','31536000',0,'','','','Kim','','Erding','Aniversários',1,NULL,NULL,'2011-10-30 15:51:53',0,0,'0'),(129,'129@tania_cruz@','0',2,1343433600,1343519940,1893459540,'y','31536000',0,'','','','Tia Andreia','','Differdange','Aniversários',1,NULL,NULL,'2011-10-30 15:51:59',0,0,'0'),(130,'130@tania_cruz@','0',2,1343606400,1343692740,1893459540,'y','31536000',0,'','','','Ruben (Beta)','','Samora Correia','Aniversários',1,NULL,NULL,'2011-10-30 15:52:05',0,0,'0'),(131,'131@tania_cruz@','0',2,1344556800,1344643140,1893459540,'y','31536000',0,'','','','Fábio Silva','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:52:16',0,0,'0'),(132,'132@tania_cruz@','0',2,1344643200,1344729540,1893459540,'y','31536000',0,'','','','Francisco Alberto Rodrigues Martinho (Kiko)','','Benavente','Aniversários',1,NULL,NULL,'2011-10-30 15:52:22',0,0,'0'),(133,'133@tania_cruz@','0',2,1344643200,1344729540,1893459540,'y','31536000',0,'','','','Fabiano','','Vila Pouca de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:52:29',0,0,'0'),(134,'134@tania_cruz@','0',2,1345593600,1345679940,1345679940,'y','31536000',0,'','','','António João de Abreu Horta','','Santo Estêvão','Aniversários',1,NULL,NULL,'2011-10-30 15:52:37',0,0,'0'),(135,'135@tania_cruz@','0',2,1346112000,1346198340,1893459540,'y','31536000',0,'','','','Filipa Lúcio','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:52:44',0,0,'0'),(136,'136@tania_cruz@','0',2,1347321600,1347407940,1893459540,'y','31536000',0,'','','','Tio João Manel','','Coimbra','Aniversários',1,NULL,NULL,'2011-10-30 15:52:54',0,0,'0'),(137,'137@tania_cruz@','0',2,1348876800,1348963140,1893459540,'y','31536000',0,'','','','Avô Jorge','','Capeludos de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:53:00',0,0,'0'),(138,'138@tania_cruz@','0',2,1350259200,1350345540,1893459540,'y','31536000',0,'','','','Patrick Alexander da Silva Ehrenberg','','Vila Pouca de Aguiar','Aniversários',1,NULL,NULL,'2011-10-30 15:53:09',0,0,'0'),(139,'139@tania_cruz@','0',2,1350691200,1350777540,1893459540,'y','31536000',0,'','','','Primo Ricardo','','Vila Franca de Xira','Aniversários',1,NULL,NULL,'2011-10-30 15:53:16',0,0,'0'),(140,'140@tania_cruz@','0',2,1351468800,1351555140,1893455940,'y','31536000',0,'','','','Prima PatrÃcia','','Alvalade do Sado','Aniversários',1,NULL,NULL,'2011-10-30 15:53:23',0,0,'0'),(141,'141@tania_cruz@','0',2,1335916800,1336003140,1893459540,'y','31536000',0,'','','','','','','',1,NULL,NULL,'2011-10-30 15:49:53',1,0,'0'),(142,'142@tania_cruz@','0',2,1322146800,1322154000,1322179140,'0','0',0,'','','','Ausdawertest','Com a Sandra','Body and Soul','Personal',0,NULL,NULL,'2011-11-07 14:48:00',0,0,'0'),(143,'6G6XJ7FlightMUC_201205270955_201205271105','0',1,1338119700,1338123900,1893459540,'0','0',0,'','','','6G6XJ7 - Flight: München - Frankfurt (Lufthansa LH 107)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 107: \n \n \n From: München International (München, Deutschland) - Terminal2 at Sun, May 27, 2012 09:55 (local time) \n To: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sun, May 27, 2012 11:05 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 01:10\n Stop(s): 0\n Aircraft: Airbus Industrie A321','München International (München, Deutschland)','Urlaub',0,NULL,NULL,'2012-01-18 17:55:23',0,0,'0'),(144,'6G6XJ7FlightFRA_201205271250_201205271435','0',1,1338130200,1338158100,1893459540,'0','0',0,'','','','6G6XJ7 - Flight: Frankfurt - Boston (Lufthansa LH 422)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 422: \n \n \n From: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sun, May 27, 2012 12:50 (local time) \n To: Logan International (Boston, USA) - TerminalE at Sun, May 27, 2012 14:35 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 07:45\n Stop(s): 0\n Aircraft: Boeing 747-400','Frankfurt International (Frankfurt, Deutschland)','Urlaub',0,NULL,NULL,'2012-01-18 17:55:29',0,0,'0'),(145,'6G6XJ7FlightBOS_201206032025_201206040945','0',1,1338780300,1338806700,1893459540,'0','0',0,'','','','6G6XJ7 - Flight: Boston - München (Lufthansa LH 425)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 425: \n \n \n From: Logan International (Boston, USA) - TerminalE at Sun, Jun 3, 2012 20:25 (local time) \n To: München International (München, Deutschland) - Terminal2 at Mon, Jun 4, 2012 09:45 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 07:20\n Stop(s): 0\n Aircraft: Airbus Industrie A340-600','Logan International (Boston, USA)','Urlaub',0,NULL,NULL,'2012-01-18 17:55:35',0,0,'0'),(146,'8P9LITFlightMUC_201203230700_201203230815','0',1,1332482400,1332486900,1893452340,'0','0',0,'','','','8P9LIT - Flight: München - Frankfurt (Lufthansa LH 101)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 101: \n \n \n From: München International (München, Deutschland) - Terminal2 at Fri, Mar 23, 2012 07:00 (local time) \n To: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Fri, Mar 23, 2012 08:15 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 01:15\n Stop(s): 0\n Aircraft: Airbus Industrie A321','München International (München, Deutschland)','Urlaub',0,NULL,NULL,'2012-01-24 12:46:37',0,0,'0'),(147,'8P9LITFlightFRA_201203230910_201203231055','0',1,1332490200,1332500100,1893452340,'0','0',0,'','','','8P9LIT - Flight: Frankfurt - Porto (Lufthansa LH 1176)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 1176: \n \n \n From: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Fri, Mar 23, 2012 09:10 (local time) \n To: Francisco SA Carneiro (Porto, Portugal) at Fri, Mar 23, 2012 10:55 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 02:45\n Stop(s): 0\n Aircraft: Airbus Industrie A321','Frankfurt International (Frankfurt, Deutschland)','Urlaub',0,NULL,NULL,'2012-01-24 12:46:43',0,0,'0'),(148,'8P9LITFlightOPO_201203311625_201203312005','0',1,1333218300,1333227900,1893459540,'0','0',0,'','','','8P9LIT - Flight: Porto - Frankfurt (Lufthansa LH 1179)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 1179: \n \n \n From: Francisco SA Carneiro (Porto, Portugal) at Sat, Mar 31, 2012 16:25 (local time) \n To: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sat, Mar 31, 2012 20:05 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 02:40\n Stop(s): 0\n Aircraft: Airbus Industrie A321','Francisco SA Carneiro (Porto, Portugal)','Urlaub',0,NULL,NULL,'2012-01-24 12:46:54',0,0,'0'),(149,'8P9LITFlightFRA_201203312135_201203312230','0',1,1333233300,1333236600,1893459540,'0','0',0,'','','','8P9LIT - Flight: Frankfurt - München (Lufthansa LH 124)','Trip status: Bestätigt\n \n FLIGHT INFORMATION: \n \n Lufthansa LH 124: \n \n \n From: Frankfurt International (Frankfurt, Deutschland) - Terminal1 at Sat, Mar 31, 2012 21:35 (local time) \n To: München International (München, Deutschland) - Terminal2 at Sat, Mar 31, 2012 22:30 (local time) \n Cabin: Economy (Sondertarife)\n Duration: 00:55\n Stop(s): 0\n Aircraft: Airbus Industrie A321','Frankfurt International (Frankfurt, Deutschland)','Urlaub',0,NULL,NULL,'2012-01-24 12:47:05',0,0,'0'),(150,'150@tcruz@','0',1,1329436800,1329695940,1329695940,'d','86400',0,'','','','IMOT Austellung','','München - Riem','Public',1,NULL,NULL,'2012-01-27 18:37:04',0,0,'0'),(152,'152@tcruz@','0',1,1329501600,1329505200,1329519540,'0','0',0,'','','','Fitnessplan Susi','','Erding','Sport',0,NULL,NULL,'2012-02-04 18:58:30',0,0,'0'),(153,'153@tania_cruz@','0',2,1330588800,1330592400,1330642740,'0','0',0,'','','','Novo programa de Treino','Novo programa de treino com o Tom','Body and Soul','Personal',0,NULL,NULL,'2012-02-21 08:51:39',0,0,'0'),(154,'154@tcruz@','0',1,1335601800,1335609000,1335657540,'0','0',0,'','','','Opel Inspektion','','ATU Erding','Termin',0,NULL,NULL,'2012-03-05 20:56:06',0,0,'0'),(155,'155@tcruz@','0',1,1337594400,1337601600,1337637540,'0','0',0,'','','','Opel','Endschalldämpfer Bremsbeläge','Erding','Personal',0,NULL,NULL,'2012-05-14 14:36:18',0,0,'0'),(156,'156@tcruz@','0',1,1341619200,1341705540,1341705540,'0','0',0,'','','','BMW Motorrad Days','','Garmisch','Personal',1,NULL,NULL,'2012-06-11 09:06:09',0,0,'0'),(157,'157@tcruz@','0',1,1346339700,1346343300,1346363940,'0','0',0,'','','','Augenarzt','Augenarztuntersuchung\n\nAugenärztliche Gemeinschaftspraxis Erding\nLandshuter Straße 9\n85435 Erding','Erding','Personal',0,NULL,NULL,'2012-08-27 09:03:44',0,0,'0');
337/*!40000 ALTER TABLE `events` ENABLE KEYS */;
338UNLOCK TABLES;
339
340--
341-- Table structure for table `events_cache`
342--
343
344DROP TABLE IF EXISTS `events_cache`;
345SET @saved_cs_client = @@character_set_client;
346SET character_set_client = utf8;
347CREATE TABLE `events_cache` (
348 `event_id` int(11) unsigned NOT NULL auto_increment,
349 `uid` text,
350 `recurrence_id` text,
351 `user_id` int(10) unsigned NOT NULL default '0',
352 `start` int(10) unsigned NOT NULL default '0',
353 `end` int(10) unsigned NOT NULL default '0',
354 `expires` int(10) unsigned NOT NULL default '0',
355 `rr` varchar(1) default NULL,
356 `recurring` text NOT NULL,
357 `occurrences` int(11) default '0',
358 `byday` text,
359 `bymonth` text,
360 `bymonthday` text,
361 `summary` varchar(255) NOT NULL,
362 `description` text NOT NULL,
363 `location` varchar(255) NOT NULL default '',
364 `categories` varchar(255) NOT NULL default '',
365 `all_day` tinyint(1) NOT NULL default '0',
366 `group` text,
367 `caldav` text,
368 `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
369 `del` int(1) NOT NULL default '0',
370 `notified` int(1) NOT NULL default '0',
371 `client` text,
372 PRIMARY KEY (`event_id`),
373 KEY `user_id_fk_events_cache` (`user_id`),
374 CONSTRAINT `user_id_fk_events_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
375) ENGINE=InnoDB DEFAULT CHARSET=utf8;
376SET character_set_client = @saved_cs_client;
377
378--
379-- Dumping data for table `events_cache`
380--
381
382LOCK TABLES `events_cache` WRITE;
383/*!40000 ALTER TABLE `events_cache` DISABLE KEYS */;
384/*!40000 ALTER TABLE `events_cache` ENABLE KEYS */;
385UNLOCK TABLES;
386
387--
388-- Table structure for table `events_caldav`
389--
390
391DROP TABLE IF EXISTS `events_caldav`;
392SET @saved_cs_client = @@character_set_client;
393SET character_set_client = utf8;
394CREATE TABLE `events_caldav` (
395 `event_id` int(11) unsigned NOT NULL auto_increment,
396 `uid` text,
397 `recurrence_id` text,
398 `user_id` int(10) unsigned NOT NULL default '0',
399 `start` int(10) unsigned NOT NULL default '0',
400 `end` int(10) unsigned NOT NULL default '0',
401 `expires` int(10) unsigned NOT NULL default '0',
402 `rr` varchar(1) default NULL,
403 `recurring` text NOT NULL,
404 `occurrences` int(11) default '0',
405 `byday` text,
406 `bymonth` text,
407 `bymonthday` text,
408 `summary` varchar(255) NOT NULL,
409 `description` text NOT NULL,
410 `location` varchar(255) NOT NULL default '',
411 `categories` varchar(255) NOT NULL default '',
412 `all_day` tinyint(1) NOT NULL default '0',
413 `group` text,
414 `caldav` text,
415 `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
416 `del` int(1) NOT NULL default '0',
417 `notified` int(1) NOT NULL default '0',
418 `client` text,
419 PRIMARY KEY (`event_id`),
420 KEY `user_id_fk_events_caldav` (`user_id`),
421 CONSTRAINT `user_id_fk_events_caldav` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
422) ENGINE=InnoDB DEFAULT CHARSET=utf8;
423SET character_set_client = @saved_cs_client;
424
425--
426-- Dumping data for table `events_caldav`
427--
428
429LOCK TABLES `events_caldav` WRITE;
430/*!40000 ALTER TABLE `events_caldav` DISABLE KEYS */;
431/*!40000 ALTER TABLE `events_caldav` ENABLE KEYS */;
432UNLOCK TABLES;
433
434--
435-- Table structure for table `google_contacts`
436--
437
438DROP TABLE IF EXISTS `google_contacts`;
439SET @saved_cs_client = @@character_set_client;
440SET character_set_client = utf8;
441CREATE TABLE `google_contacts` (
442 `contact_id` int(10) unsigned NOT NULL auto_increment,
443 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
444 `del` tinyint(1) NOT NULL default '0',
445 `name` varchar(128) NOT NULL default '',
446 `email` text NOT NULL,
447 `firstname` varchar(128) NOT NULL default '',
448 `surname` varchar(128) NOT NULL default '',
449 `vcard` longtext,
450 `words` text,
451 `user_id` int(10) unsigned NOT NULL,
452 PRIMARY KEY (`contact_id`),
453 KEY `user_contacts_index` (`user_id`,`del`),
454 CONSTRAINT `google_contacts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
455) ENGINE=InnoDB DEFAULT CHARSET=utf8;
456SET character_set_client = @saved_cs_client;
457
458--
459-- Dumping data for table `google_contacts`
460--
461
462LOCK TABLES `google_contacts` WRITE;
463/*!40000 ALTER TABLE `google_contacts` DISABLE KEYS */;
464/*!40000 ALTER TABLE `google_contacts` ENABLE KEYS */;
465UNLOCK TABLES;
466
467--
468-- Table structure for table `identities`
469--
470
471DROP TABLE IF EXISTS `identities`;
472SET @saved_cs_client = @@character_set_client;
473SET character_set_client = utf8;
474CREATE TABLE `identities` (
475 `identity_id` int(10) unsigned NOT NULL auto_increment,
476 `user_id` int(10) unsigned NOT NULL,
477 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
478 `del` tinyint(1) NOT NULL default '0',
479 `standard` tinyint(1) NOT NULL default '0',
480 `name` varchar(128) NOT NULL,
481 `organization` varchar(128) NOT NULL default '',
482 `email` varchar(128) NOT NULL,
483 `reply-to` varchar(128) NOT NULL default '',
484 `bcc` varchar(128) NOT NULL default '',
485 `signature` text,
486 `html_signature` tinyint(1) NOT NULL default '0',
487 PRIMARY KEY (`identity_id`),
488 KEY `user_identities_index` (`user_id`,`del`),
489 CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
490) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
491SET character_set_client = @saved_cs_client;
492
493--
494-- Dumping data for table `identities`
495--
496
497LOCK TABLES `identities` WRITE;
498/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
499INSERT INTO `identities` VALUES (1,1,'2011-06-25 10:27:23',0,1,'Tino Cruz','','werbung@aocruz.de','','','',0),(2,2,'2012-09-09 14:22:31',1,1,'tania_cruz','','tania_cruz@localhost','','',NULL,0),(3,1,'2011-06-25 10:26:26',0,0,'Tino Cruz','','tinocruz251@msn.com','','','',0),(4,1,'2011-07-31 21:13:08',0,0,'Tino Cruz','','tcruz1971@yahoo.de','','','<hr />\r\n<pre><span style=\"font-family: arial black,avant garde;\">Agostinho Ourique Cruz<br /><span style=\"font-size: x-small; font-family: arial,helvetica,sans-serif;\">Spitzsteinstr. 13<br />D-85435 Erding<br /></span></span></pre>',1),(5,1,'2011-06-25 10:27:12',0,0,'Tino Cruz','','tcruz@aocruz.de','','','',0),(6,1,'2011-06-25 10:27:44',0,0,'Tino Cruz','','geschaeft@aocruz.de','','','',0),(7,2,'2012-04-05 19:56:23',0,0,'Tania Cruz','','taniacruz_184@hotmail.com','','','',0),(8,1,'2012-04-05 19:57:32',0,0,'Tania Cruz','','taniacruz_184@hotmail.com','','','',0),(9,3,'2012-04-22 21:10:05',0,1,'tania_Cruz','','tania_Cruz@localhost','','',NULL,0),(10,3,'2012-04-23 17:02:54',0,1,'tania_Cruz','','tania_Cruz@localhost','','',NULL,0);
500/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
501UNLOCK TABLES;
502
503--
504-- Table structure for table `notes`
505--
506
507DROP TABLE IF EXISTS `notes`;
508SET @saved_cs_client = @@character_set_client;
509SET character_set_client = utf8;
510CREATE TABLE `notes` (
511 `id` int(11) NOT NULL auto_increment,
512 `nid` int(11) NOT NULL,
513 `width` int(11) default '0',
514 `height` int(11) default '0',
515 `pos_x` int(11) default '0',
516 `pos_y` int(11) default '0',
517 `text` text,
518 `user_id` int(10) unsigned NOT NULL,
519 `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
520 PRIMARY KEY (`id`),
521 KEY `user_id` (`user_id`),
522 CONSTRAINT `notes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
523) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
524SET character_set_client = @saved_cs_client;
525
526--
527-- Dumping data for table `notes`
528--
529
530LOCK TABLES `notes` WRITE;
531/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
532INSERT INTO `notes` VALUES (1,3,0,0,0,3,'a:3:{i:0;s:11:\"Apartamento\";i:1;s:57:\"BPE_1968\nBPE_1536\nBPE_1730\nhttp://www.bertinpicanco.pt/\n\n\";i:2;s:6:\"yellow\";}',1,'2012-09-16 16:37:36');
533/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
534UNLOCK TABLES;
535
536--
537-- Table structure for table `searches`
538--
539
540DROP TABLE IF EXISTS `searches`;
541SET @saved_cs_client = @@character_set_client;
542SET character_set_client = utf8;
543CREATE TABLE `searches` (
544 `search_id` int(10) unsigned NOT NULL auto_increment,
545 `user_id` int(10) unsigned NOT NULL,
546 `type` int(3) NOT NULL default '0',
547 `name` varchar(128) NOT NULL,
548 `data` text,
549 PRIMARY KEY (`search_id`),
550 UNIQUE KEY `uniqueness` (`user_id`,`type`,`name`),
551 CONSTRAINT `user_id_fk_searches` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
552) ENGINE=InnoDB DEFAULT CHARSET=utf8;
553SET character_set_client = @saved_cs_client;
554
555--
556-- Dumping data for table `searches`
557--
558
559LOCK TABLES `searches` WRITE;
560/*!40000 ALTER TABLE `searches` DISABLE KEYS */;
561/*!40000 ALTER TABLE `searches` ENABLE KEYS */;
562UNLOCK TABLES;
563
564--
565-- Table structure for table `session`
566--
567
568DROP TABLE IF EXISTS `session`;
569SET @saved_cs_client = @@character_set_client;
570SET character_set_client = utf8;
571CREATE TABLE `session` (
572 `sess_id` varchar(128) NOT NULL,
573 `created` datetime NOT NULL default '1000-01-01 00:00:00',
574 `changed` datetime NOT NULL default '1000-01-01 00:00:00',
575 `ip` varchar(40) NOT NULL,
576 `vars` mediumtext NOT NULL,
577 PRIMARY KEY (`sess_id`),
578 KEY `changed_index` (`changed`)
579) ENGINE=InnoDB DEFAULT CHARSET=utf8;
580SET character_set_client = @saved_cs_client;
581
582--
583-- Dumping data for table `session`
584--
585
586LOCK TABLES `session` WRITE;
587/*!40000 ALTER TABLE `session` DISABLE KEYS */;
588INSERT INTO `session` VALUES ('h9jlua00kpsn47lkv658te7qtqo98qnv','2012-10-26 19:46:47','2012-10-26 19:46:47','10.0.2.2','bGFuZ3VhZ2V8czo1OiJkZV9ERSI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5Ijs=');
589/*!40000 ALTER TABLE `session` ENABLE KEYS */;
590UNLOCK TABLES;
591
592--
593-- Table structure for table `users`
594--
595
596DROP TABLE IF EXISTS `users`;
597SET @saved_cs_client = @@character_set_client;
598SET character_set_client = utf8;
599CREATE TABLE `users` (
600 `user_id` int(10) unsigned NOT NULL auto_increment,
601 `username` varchar(128) character set utf8 collate utf8_bin NOT NULL,
602 `mail_host` varchar(128) NOT NULL,
603 `alias` varchar(128) character set utf8 collate utf8_bin NOT NULL,
604 `created` datetime NOT NULL default '1000-01-01 00:00:00',
605 `last_login` datetime default NULL,
606 `language` varchar(5) default NULL,
607 `preferences` text,
608 PRIMARY KEY (`user_id`),
609 UNIQUE KEY `username` (`username`,`mail_host`),
610 KEY `alias_index` (`alias`)
611) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
612SET character_set_client = @saved_cs_client;
613
614--
615-- Dumping data for table `users`
616--
617
618LOCK TABLES `users` WRITE;
619/*!40000 ALTER TABLE `users` DISABLE KEYS */;
620INSERT INTO `users` VALUES (1,'tcruz','localhost','','2011-05-30 22:07:32','2012-10-26 18:58:07','de_DE','a:34:{s:19:\"default_addressbook\";s:1:\"0\";s:16:\"use_google_abook\";b:0;s:10:\"googleuser\";s:24:\"tcruz1971@googlemail.com\";s:10:\"googlepass\";s:24:\"WltGs5WIG4//+6ny3BoXFA==\";s:6:\"tzname\";s:13:\"Europe/Berlin\";s:8:\"timezone\";s:4:\"auto\";s:11:\"date_format\";s:5:\"Y-m-d\";s:4:\"skin\";s:5:\"larry\";s:12:\"preview_pane\";s:1:\"1\";s:11:\"drafts_mbox\";s:15:\"INBOX.Entwuerfe\";s:9:\"sent_mbox\";s:14:\"INBOX.Gesendet\";s:9:\"junk_mbox\";s:10:\"INBOX.spam\";s:10:\"trash_mbox\";s:16:\"INBOX.Papierkorb\";s:15:\"default_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:15:\"INBOX.Entwuerfe\";i:2;s:14:\"INBOX.Gesendet\";i:3;s:10:\"INBOX.spam\";i:4;s:16:\"INBOX.Papierkorb\";}s:13:\"calendarfeeds\";a:1:{s:88:\"http://www.google.com/calendar/feeds/german__de@holiday.calendar.google.com/public/basic\";s:8:\"Personal\";}s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:15:\"INBOX.Entwuerfe\";i:2;s:14:\"INBOX.Gesendet\";i:3;s:10:\"INBOX.spam\";i:4;s:11:\"INBOX.Trash\";}s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";s:11:\"search_mods\";a:5:{s:1:\"*\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}s:14:\"INBOX.Gesendet\";a:2:{s:7:\"subject\";i:1;s:2:\"to\";i:1;}s:15:\"INBOX.Entwuerfe\";a:2:{s:7:\"subject\";i:1;s:2:\"to\";i:1;}s:5:\"INBOX\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}s:13:\"INBOX.Wichtig\";a:2:{s:7:\"subject\";i:1;s:4:\"from\";i:1;}}s:10:\"categories\";a:6:{s:8:\"Personal\";s:6:\"C0C0C0\";s:4:\"Work\";s:6:\"FF0000\";s:6:\"Family\";s:6:\"00FF00\";s:6:\"Urlaub\";s:6:\"2A12FF\";s:5:\"Sport\";s:6:\"FF14D8\";s:6:\"Termin\";s:6:\"FFFF0A\";}s:10:\"dst_active\";b:0;s:10:\"htmleditor\";i:1;s:12:\"logout_purge\";b:1;s:17:\"check_all_folders\";b:1;s:11:\"top_posting\";b:1;s:7:\"backend\";s:8:\"database\";s:12:\"default_view\";s:5:\"month\";s:16:\"default_duration\";s:4:\"0.25\";s:13:\"caldav_server\";s:24:\"ssl://www.google.com:443\";s:10:\"caldav_url\";s:61:\"https://www.google.com/calendar/dav/john.doe@gmail.com/events\";s:14:\"upcoming_range\";s:5:\"86400\";s:10:\"cal_notify\";b:1;s:13:\"cal_notify_to\";s:15:\"tcruz@localhost\";s:15:\"namespace_fixed\";b:1;}'),(2,'tania_cruz','localhost','','2011-06-02 12:06:03','2012-10-25 14:34:32','pt_PT','a:17:{s:16:\"message_sort_col\";s:4:\"date\";s:18:\"message_sort_order\";s:4:\"DESC\";s:10:\"categories\";a:3:{s:7:\"Pessoal\";s:6:\"1CFFE1\";s:8:\"Trabalho\";s:6:\"ACFF59\";s:8:\"FamÃlia\";s:6:\"B870FF\";}s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:10:\"dst_active\";b:0;s:12:\"preview_pane\";s:1:\"0\";s:7:\"backend\";s:8:\"database\";s:16:\"default_duration\";s:4:\"0.25\";s:13:\"caldav_server\";s:24:\"ssl://www.google.com:443\";s:14:\"upcoming_range\";s:5:\"86400\";s:13:\"cal_notify_to\";s:20:\"tania_cruz@localhost\";s:15:\"namespace_fixed\";b:1;}'),(3,'tania_Cruz','localhost','','2012-04-23 17:02:54','2012-04-23 17:02:54','de_DE','a:7:{s:11:\"drafts_mbox\";s:12:\"INBOX.Drafts\";s:9:\"junk_mbox\";s:10:\"INBOX.Junk\";s:9:\"sent_mbox\";s:10:\"INBOX.Sent\";s:10:\"trash_mbox\";s:11:\"INBOX.Trash\";s:20:\"default_imap_folders\";a:5:{i:0;s:5:\"INBOX\";i:1;s:12:\"INBOX.Drafts\";i:2;s:10:\"INBOX.Sent\";i:3;s:10:\"INBOX.Junk\";i:4;s:11:\"INBOX.Trash\";}s:8:\"timezone\";s:4:\"auto\";s:15:\"namespace_fixed\";b:1;}');
621/*!40000 ALTER TABLE `users` ENABLE KEYS */;
622UNLOCK TABLES;
623
624--
625-- Dumping routines for database 'roundcubemail'
626--
627DELIMITER ;;
628DELIMITER ;
629/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
630
631/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
632/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
633/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
634/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
635/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
636/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
637/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;