# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: localhost (MySQL 5.5.28)
# Database: cunet
# Generation Time: 2014-02-12 15:16:45 +0000
# ************************************************************




# Dump of table church_types
# ------------------------------------------------------------


CREATE TABLE `church_types` (
  `type_id` smallint(2) unsigned NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `church_types` (`type_id`, `type_name`)
VALUES
	(1,'Apostolische Gemeinschaft'),
	(2,'Chrischona-Gemeinde'),
	(3,'Evangelische Kirche'),
	(4,'Ev. Freikirchl. Gemeinde'),
	(5,'Ev. Freikirchl. Gemeinde (Baptisten)'),
	(6,'Ev. Freikirchl. Gemeinde (Brüdergem.)'),
	(7,'Ev. Luth. Freikirche'),
	(8,'Ev. methodistische Kirche (EmK)'),
	(9,'Ev.-reformierte Kirche'),
	(10,'Evangelische Gemeinschaft'),
	(11,'Freie evangelische Gemeinde'),
	(12,'Freikirchl. Bund der Gemeinde Gottes'),
	(13,'Hauskirche'),
	(14,'Heilsarmee'),
	(15,'Internationale Gemeinde in Deutschland'),
	(16,'Jesus-Freaks'),
	(17,'Jugendverband'),
	(18,'Katholische Kirche'),
	(19,'Landeskirchliche Gemeinschaft'),
	(20,'Mennonitengemeinde'),
	(21,'Pfingstgemeinde'),
	(22,'Selbst. Ev.-Luth. Kirche (SELK)'),
	(23,'Sieben-Tags-Adventisten'),
	(24,'Sonstige Freikirche'),
	(25,'Stadtmission'),
	(26,'Vineyard'),
	(27,'other');



# Dump of table churches
# ------------------------------------------------------------


CREATE TABLE `churches` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` text,
  `type_id_fk` smallint(2) unsigned DEFAULT NULL,
  `address` varchar(255) DEFAULT '',
  `city` varchar(255) DEFAULT '',
  `post_code` varchar(20) DEFAULT '',
  `country_id_fk` smallint(3) unsigned DEFAULT NULL,
  `regular_service` varchar(255) DEFAULT '',
  `other_events` varchar(255) DEFAULT '',
  `website_url` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `lat` float(7,4) DEFAULT NULL,
  `lng` float(7,4) DEFAULT NULL,
  `church_img` varchar(255) DEFAULT NULL,
  `suggested_by` int(11) unsigned NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `reviewed_by` int(11) unsigned DEFAULT NULL,
  `reviewed_on` datetime DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `country_id_fk` (`country_id_fk`),
  KEY `suggested_by` (`suggested_by`),
  KEY `reviewed_by` (`reviewed_by`),
  KEY `type_id_fk` (`type_id_fk`),
  CONSTRAINT `churches_ibfk_1` FOREIGN KEY (`country_id_fk`) REFERENCES `countries` (`country_id`),
  CONSTRAINT `churches_ibfk_2` FOREIGN KEY (`suggested_by`) REFERENCES `users` (`user_id`),
  CONSTRAINT `churches_ibfk_3` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`user_id`),
  CONSTRAINT `churches_ibfk_4` FOREIGN KEY (`type_id_fk`) REFERENCES `church_types` (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `churches` (`id`, `name`, `description`, `type_id_fk`, `address`, `city`, `post_code`, `country_id_fk`, `regular_service`, `other_events`, `website_url`, `contact_person`, `phone_number`, `lat`, `lng`, `church_img`, `suggested_by`, `status`, `reviewed_by`, `reviewed_on`, `created_on`)
VALUES
	(2,'Name','Description',NULL,'Address','City','Post',16,'Regular Service','Other events','http://dir.bg','Contact person','1231434553',50.1347,8.6243,NULL,1,'approved',1,'2013-04-25 00:50:37','2013-04-23 04:00:06'),
	(3,'Name','Description',NULL,'Addess','City','1234',14,'None','Events','http://cunet.org','Carsten Waldeck','123456789',50.1347,8.6243,NULL,1,'pending',NULL,NULL,'2013-04-23 07:07:51'),
	(4,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:01:55'),
	(5,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:02:09'),
	(6,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:03:51'),
	(7,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:04:10'),
	(8,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:04:25'),
	(9,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:04:55'),
	(10,'Test','Test',NULL,'Address','City','12345',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:05:20'),
	(11,'Name','Description',NULL,'Address','City','12345',14,'Re','','','','',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:06:56'),
	(12,'Name','Description',NULL,'Address','City','12345',14,'Re','','','','',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:07:39'),
	(13,'Name','Description',NULL,'Address','City','12345',14,'Re','','','','',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:08:03'),
	(14,'Name','Description',NULL,'Address','City','12345',14,'Re','','','','',49.2391,11.2170,NULL,1,'pending',NULL,NULL,'2013-04-24 09:10:57'),
	(15,'Name','Description',25,'Address','City','12345',14,'Regular service','Other events','http://cu-net.org','None','None',42.6865,23.3020,'0782d1ad5a92e9781c43c4998afb6bff.png',1,'approved',1,'2013-04-25 00:50:27','2013-04-24 09:11:16'),
	(16,'Name','Description',NULL,'Address','City','1234',14,'Regular Service','Other events','http://cu-net.org','Contact person','123456789',49.7387,11.2830,'b6b9d3fff79e9502c98564705da12180.jpg',1,'approved',1,'2013-04-25 00:50:26','2013-04-24 09:20:10'),
	(17,'Name','aaaaa',NULL,'none','none','none',14,'none','none','none','none','none',50.1734,8.5776,NULL,1,'pending',NULL,NULL,'2013-04-25 08:46:48'),
	(18,'Name','aaaaa',8,'none','none','none',14,'none','none','none','none','none',50.1734,8.5776,NULL,1,'approved',1,'2013-04-25 01:49:57','2013-04-25 08:47:41'),
	(19,'Name','Description',1,'2000','City','123',17,'fd','gf','','','',49.9618,8.0475,NULL,1,'pending',NULL,NULL,'2013-05-01 21:36:24');



# Dump of table countries
# ------------------------------------------------------------


CREATE TABLE `countries` (
  `country_id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `country_name` varchar(255) DEFAULT NULL,
  `country_name_en` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `countries` (`country_id`, `country_name`, `country_name_en`)
VALUES
	(1,'Andorra','Andorra'),
	(2,'Austria','Austria'),
	(3,'Belarus','Belarus'),
	(4,'Belgium','Belgium'),
	(5,'Bosnia','Bosnia'),
	(6,'Bulgaria','Bulgaria'),
	(7,'Croatia','Croatia'),
	(8,'Cyprus','Cyprus'),
	(9,'Czech Republic','Czech Republic'),
	(10,'Denmark','Denmark'),
	(11,'Estonia','Estonia'),
	(12,'Finland','Finland'),
	(13,'France','France'),
	(14,'Germany','Germany'),
	(15,'Greece','Greece'),
	(16,'Greenland','Greenland'),
	(17,'Hungary','Hungary'),
	(18,'Iceland','Iceland'),
	(19,'Ireland','Ireland'),
	(20,'Italy','Italy'),
	(21,'Latvia','Latvia'),
	(22,'Liechtenstein','Liechtenstein'),
	(23,'Lithuania','Lithuania'),
	(24,'Luxembourg','Luxembourg'),
	(25,'Macedonia, Rep. of','Macedonia, Rep. of'),
	(26,'Malta','Malta'),
	(27,'Moldova','Moldova'),
	(28,'Monaco','Monaco'),
	(29,'Montenegro','Montenegro'),
	(30,'Netherlands','Netherlands'),
	(31,'Norway','Norway'),
	(32,'Poland','Poland'),
	(33,'Portugal','Portugal'),
	(34,'Romania','Romania'),
	(35,'Russian Federation','Russian Federation'),
	(36,'San Marino','San Marino'),
	(37,'Serbia','Serbia'),
	(38,'Slovakia','Slovakia'),
	(39,'Slovenia','Slovenia'),
	(40,'Spain','Spain'),
	(41,'Sweden','Sweden'),
	(42,'Switzerland','Switzerland'),
	(43,'Turkey','Turkey'),
	(44,'Ukraine','Ukraine'),
	(45,'United Kingdom','United Kingdom'),
	(46,'Vatican City State','Vatican City State'),
	(47,'Абхазия','Abkhazia'),
	(48,'افغانستان','Afghanistan'),
	(49,'Shqipëria','Albania'),
	(50,'الجزائر','Algeria'),
	(51,'Amerika Sāmoa','American Samoa'),
	(52,'Angola','Angola'),
	(53,'Anguilla','Anguilla'),
	(54,'Antigua and Barbuda','Antigua and Barbuda'),
	(55,'Argentina','Argentina'),
	(56,'Հայաստան','Armenia'),
	(57,'Aruba','Aruba'),
	(58,'Australia','Australia'),
	(59,'Azərbaycan','Azerbaijan'),
	(60,'Bahamas, The','Bahamas, The'),
	(61,'البحرين','Bahrain'),
	(62,'বাংলাদেশ','Bangladesh'),
	(63,'Barbados','Barbados'),
	(64,'Belize','Belize'),
	(65,'Bénin','Benin'),
	(66,NULL,'Bermuda'),
	(67,'འབྲུག་ཡུལ','Bhutan'),
	(68,'Bolivia','Bolivia'),
	(69,'Botswana','Botswana'),
	(70,'Brasil','Brazil'),
	(71,'بروني','Brunei'),
	(72,'Burkina Faso','Burkina Faso'),
	(73,'Myanmar','Burma'),
	(74,'Burundi','Burundi'),
	(75,'Kampuchea','Cambodia'),
	(76,'Cameroun','Cameroon'),
	(77,'Canada','Canada'),
	(78,'Cabo Verde','Cape Verde'),
	(79,'Cayman Islands','Cayman Islands'),
	(80,'République Centrafricaine','Central African Republic'),
	(81,'تشاد','Chad'),
	(82,'Chile, República de','Chile, Republic of'),
	(83,'中国','China'),
	(84,'Christmas Island','Christmas Island'),
	(85,'Cocos Islands','Cocos Islands'),
	(86,'Colombia, República de','Colombia, Republic of'),
	(87,'جزر القمر','Comoros'),
	(88,'Congo or Congo-Brazza','Congo'),
	(89,'Cook Islands','Cook Islands'),
	(90,'Costa Rica','Costa Rica'),
	(91,'Côte d\'Ivoire','Côte d\'Ivoire'),
	(92,'Cuba','Cuba'),
	(93,'جيبوتي','Djibouti'),
	(94,'Dominica','Dominica'),
	(95,'Dominicana, República','Dominican Republic'),
	(96,'Timor-Leste','East Timor'),
	(97,'Ecuador','Ecuador'),
	(98,'مصر','Egypt'),
	(99,'El Salvador','El Salvador'),
	(100,'Guinea Ecuatorial','Equatorial Guinea'),
	(101,'إرتريا','Eritrea'),
	(102,'Ityop\'ia','Ethiopia'),
	(103,'Færøerne','Faroe Islands'),
	(104,'फ़िजी','Fiji'),
	(105,'Guyane','French Guiana'),
	(106,'Polynésie française','French Polynesia'),
	(107,'Gabon','Gabon'),
	(108,'Gambia','Gambia, Republic of The '),
	(109,'საქართველო','Georgia'),
	(110,'Ghana','Ghana'),
	(111,'Gibraltar','Gibraltar'),
	(112,'Grenada','Grenada'),
	(113,'Guadeloupe','Guadeloupe'),
	(114,'Guam','Guam'),
	(115,'Guatemala','Guatemala'),
	(116,'Guernsey','Guernsey'),
	(117,'Guinée','Guinea'),
	(118,'Guiné-Bissau','Guinea-Bissau'),
	(119,'Guyana','Guyana'),
	(120,'Haïti','Haiti'),
	(121,'Honduras','Honduras'),
	(122,'भारत गणराज्य','India, Republic of'),
	(123,'Indonesia','Indonesia'),
	(124,'ایران','Iran'),
	(125,'العراق','Iraq'),
	(126,'Ellan Vannin','Isle of Man'),
	(127,'ישראל','Israel'),
	(128,'Jamaica','Jamaica'),
	(129,'日本','Japan'),
	(130,'Jèrri','Jersey'),
	(131,'الأردن','Jordan'),
	(132,'Қазақстан','Kazakhstan'),
	(133,'Kenya','Kenya'),
	(134,'Kiribati','Kiribati'),
	(135,'조선 / 朝鮮','Korea (North)'),
	(136,'한국 / 韓國','Korea (South)'),
	(137,'Косово','Kosovo'),
	(138,'الكويت','Kuwait'),
	(139,'Кыргызстан','Kyrgyzstan'),
	(140,'ລາວ','Laos'),
	(141,'لبنان','Lebanon'),
	(142,'Lesotho','Lesotho'),
	(143,'Liberia','Liberia'),
	(144,'ليبيا','Libya'),
	(145,'Madagasikara','Madagascar'),
	(146,'Malawi','Malawi'),
	(147,'Malaysia','Malaysia'),
	(148,'ދިވެހިރާއްޖެ','Maldives'),
	(149,'Mali','Mali'),
	(150,'Marshall Islands','Marshall Islands'),
	(151,'Martinique','Martinique'),
	(152,'موريتانيا','Mauritania'),
	(153,'Maurice','Mauritius'),
	(154,'Mayotte','Mayotte'),
	(155,'México','Mexico'),
	(156,'Micronesia, Federated States of ','Micronesia, Federated States of '),
	(157,'Монгол Улс','Mongolia'),
	(158,'Montserrat','Montserrat'),
	(159,'المغرب','Morocco'),
	(160,'Moçambique','Mozambique'),
	(161,'Myanma','Myanmar'),
	(162,'Namibia','Namibia'),
	(163,'Nauruo','Nauru'),
	(164,'नेपाल','Nepal'),
	(165,'Nouvelle-Calédonie','New Caledonia'),
	(166,'Aotearoa','New Zealand'),
	(167,'Nicaragua','Nicaragua'),
	(168,'Niger','Niger'),
	(169,'Nigeria','Nigeria'),
	(170,'Niue','Niue'),
	(171,'Norfolk Island','Norfolk Island'),
	(172,'Northern Ireland','Northern Ireland'),
	(173,'Northern Mariana Islands','Northern Mariana Islands'),
	(174,'عُمان','Oman'),
	(175,'پاکستان','Pakistan'),
	(176,'Belau','Palau'),
	(177,'فلسطين','Palestinian National Authority'),
	(178,'Panamá','Panama'),
	(179,'Papua Niugini','Papua New Guinea'),
	(180,'Paraguái','Paraguay'),
	(181,'Perú','Peru'),
	(182,'Pilipinas','Philippines'),
	(183,'Pitcairn Islands','Pitcairn Islands'),
	(184,'Puerto Rico','Puerto Rico'),
	(185,'قطر','Qatar'),
	(186,'Réunion','Réunion'),
	(187,'Rwanda','Rwanda'),
	(188,'Saint Helena','Saint Helena'),
	(189,'Saint Kitts and Nevis','Saint Kitts and Nevis'),
	(190,'Saint Lucia','Saint Lucia'),
	(191,'Saint Vincent and the Grenadines','Saint Vincent and the Grenadines'),
	(192,'Saint-Pierre et Miquelon','Saint-Pierre and Miquelon'),
	(193,'Samoa','Samoa'),
	(194,'São Tomé e Príncipe','São Tomé and Príncipe'),
	(195,'المملكة العربية السعودية','Saudi Arabia'),
	(196,'Sénégal','Senegal'),
	(197,'Sesel','Seychelles'),
	(198,'Sierra Leone','Sierra Leone'),
	(199,'Singapura','Singapore'),
	(200,'Solomon Islands','Solomon Islands'),
	(201,'الصومال','Somalia'),
	(202,'South Africa','South Africa'),
	(203,'Хуссар Ирыстон','South Ossetia'),
	(204,'South Sudan','South Sudan, Republic of'),
	(205,'ஸ்ரீ லங்க','Sri Lanka'),
	(206,'السودان','Sudan'),
	(207,'Suriname','Suriname'),
	(208,'Svalbard','Svalbard'),
	(209,'Umbuso weSwatini','Swaziland, Kingdom of'),
	(210,'سورية','Syria'),
	(211,'臺灣/台灣','Taiwan'),
	(212,'Тоҷикистон','Tajikistan'),
	(213,'Tanzania, Jamhuri ya Muungano wa ','Tanzania'),
	(214,'เมืองไทย','Thailand'),
	(215,'Togo','Togo'),
	(216,'Tokelau','Tokelau'),
	(217,'Tonga','Tonga'),
	(218,'Trinidad and Tobago','Trinidad and Tobago'),
	(219,'تونس','Tunisia'),
	(220,'Kuzey Kıbrıs Türk Cumhuriyeti','Turkish Republic of Northern Cyprus'),
	(221,'Türkmenistan','Turkmenistan'),
	(222,'Turks and Caicos Islands','Turks and Caicos Islands'),
	(223,'Tuvalu','Tuvalu'),
	(224,'Uganda','Uganda'),
	(225,'الإمارات العربيّة المتّحدة','United Arab Emirates'),
	(226,'República Oriental del Uruguay','Uruguay'),
	(227,'United States or America','USA'),
	(228,'O\'zbekiston','Uzbekistan'),
	(229,'Vanuatu','Vanuatu'),
	(230,'Venezuela','Venezuela'),
	(231,'Việt Nam','Vietnam'),
	(232,'Virgin Islands, British','Virgin Islands, British'),
	(233,'Virgin Islands, US','Virgin Islands, US'),
	(234,'Војводина','Vojvodina, Autonomous Province of '),
	(235,'Wallis-et-Futuna','Wallis and Futuna'),
	(236,'اليمن','Yemen'),
	(237,'Zambia','Zambia'),
	(238,'Zimbabwe','Zimbabwe');



# Dump of table event_invitees
# ------------------------------------------------------------


CREATE TABLE `event_invitees` (
  `event_id_fk` int(11) unsigned NOT NULL,
  `user_id_fk` int(11) unsigned NOT NULL,
  `status` enum('noanswer','attending','not_attending','tentative') NOT NULL DEFAULT 'noanswer',
  `invited_on` datetime DEFAULT NULL,
  KEY `event_id_fk` (`event_id_fk`),
  KEY `user_id_fk` (`user_id_fk`),
  CONSTRAINT `event_invitees_ibfk_1` FOREIGN KEY (`event_id_fk`) REFERENCES `events` (`event_id`) ON DELETE CASCADE,
  CONSTRAINT `event_invitees_ibfk_2` FOREIGN KEY (`user_id_fk`) REFERENCES `users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `event_invitees` (`event_id_fk`, `user_id_fk`, `status`, `invited_on`)
VALUES
	(8,12,'noanswer','2013-02-14 01:01:28'),
	(8,2,'attending','2013-02-14 01:01:28'),
	(8,103,'noanswer','2013-02-14 01:01:28'),
	(9,1,'noanswer','2013-02-18 22:43:56'),
	(9,7,'noanswer','2013-02-18 22:43:56'),
	(10,2,'noanswer','2013-04-17 07:27:27'),
	(11,2,'noanswer','2013-04-17 07:28:42'),
	(12,2,'noanswer','2013-04-17 07:45:05'),
	(13,2,'noanswer','2013-04-17 07:45:53'),
	(14,2,'noanswer','2013-04-17 07:47:26'),
	(15,2,'noanswer','2013-04-17 07:48:11'),
	(16,2,'noanswer','2013-04-18 04:55:50'),
	(17,2,'noanswer','2013-04-18 06:21:53'),
	(18,2,'attending','2013-04-18 06:23:54'),
	(19,2,'noanswer','2013-05-23 23:13:30'),
	(21,2,'noanswer','2013-05-23 23:48:27'),
	(23,2,'noanswer','2013-06-21 10:43:31');



# Dump of table event_types
# ------------------------------------------------------------


CREATE TABLE `event_types` (
  `type_id` smallint(2) unsigned NOT NULL AUTO_INCREMENT,
  `event_type_name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `event_types` (`type_id`, `event_type_name`)
VALUES
	(1,'church'),
	(2,'concert/festival'),
	(3,'conference/symposium'),
	(4,'meetup'),
	(5,'teaching/service'),
	(6,'workshop/seminar'),
	(7,'worship'),
	(8,'other');



# Dump of table events
# ------------------------------------------------------------


CREATE TABLE `events` (
  `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `event_name` varchar(255) NOT NULL,
  `event_type` smallint(2) unsigned NOT NULL,
  `event_description` text NOT NULL,
  `event_start_date` datetime NOT NULL,
  `event_end_date` datetime NOT NULL,
  `event_location` varchar(255) NOT NULL DEFAULT '',
  `event_url` varchar(255) DEFAULT NULL,
  `event_owner` int(11) unsigned NOT NULL,
  `lat` float(7,4) DEFAULT NULL,
  `lng` float(7,4) DEFAULT NULL,
  `event_img` varchar(255) DEFAULT NULL,
  `event_created_on` datetime NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`),
  KEY `event_owner` (`event_owner`),
  KEY `event_type` (`event_type`),
  CONSTRAINT `events_ibfk_1` FOREIGN KEY (`event_owner`) REFERENCES `users` (`user_id`),
  CONSTRAINT `events_ibfk_2` FOREIGN KEY (`event_type`) REFERENCES `event_types` (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `events` (`event_id`, `event_name`, `event_type`, `event_description`, `event_start_date`, `event_end_date`, `event_location`, `event_url`, `event_owner`, `lat`, `lng`, `event_img`, `event_created_on`, `public`)
VALUES
	(8,'Test',8,'Test','2013-02-14 02:45:00','2013-02-15 02:45:00','test',NULL,1,NULL,NULL,NULL,'2013-02-14 01:01:28',0),
	(9,'New event',8,'This is my new event','2013-02-18 00:30:00','2013-02-19 00:30:00','Skype, Meeting',NULL,2,NULL,NULL,NULL,'2013-02-18 22:43:56',0),
	(10,'Test',8,'Test','2013-04-17 13:15:00','2013-04-17 18:15:00','Here',NULL,1,NULL,NULL,NULL,'2013-04-17 07:27:27',0),
	(11,'Just check',1,'Just check','2013-04-30 03:15:00','2013-05-26 11:15:00','yesme',NULL,1,50.4330,8.6627,NULL,'2013-04-17 07:28:42',0),
	(12,'',8,'No','2013-04-17 03:30:00','2013-04-18 03:30:00','No',NULL,1,NULL,NULL,NULL,'2013-04-17 07:45:05',0),
	(13,'',8,'No','2013-04-17 03:45:00','2013-04-17 04:00:00','No',NULL,1,NULL,NULL,NULL,'2013-04-17 07:45:53',0),
	(14,'',8,'Test','2013-04-17 03:45:00','2013-04-17 04:15:00','No',NULL,1,NULL,NULL,NULL,'2013-04-17 07:47:26',0),
	(15,'Another event 2',8,'Test','2013-04-17 03:45:00','2013-04-17 04:00:00','None',NULL,1,NULL,NULL,NULL,'2013-04-17 07:48:11',0),
	(16,'New event',8,'Test','2013-04-19 09:00:00','2013-04-19 09:45:00','No',NULL,1,NULL,NULL,NULL,'2013-04-18 04:55:50',0),
	(17,'New event',8,'test','2013-04-19 10:00:00','2013-04-20 02:30:00','Home',NULL,1,NULL,NULL,NULL,'2013-04-18 06:21:53',0),
	(18,'New concert',2,'Concert','2013-04-20 19:00:00','2013-04-20 22:00:00','Hall of fame',NULL,1,NULL,NULL,NULL,'2013-04-18 06:23:54',0),
	(19,'New test event',1,'Descripton','2013-05-27 05:15:00','2013-05-31 14:30:00','Skype',NULL,1,50.4331,8.6627,'1394c2c8e3b8e1c87adf3878b9519ead.jpg','2013-05-23 23:13:30',0),
	(21,'Avatar event',5,'Test','2013-05-24 10:00:00','2013-05-25 15:00:00','BMW',NULL,1,48.1270,11.5820,'7d7bcf9e94256d08f90c9d43f66e25ee.jpg','2013-05-23 23:48:27',0),
	(22,'My public event',1,'Test','2013-06-06 22:00:00','2013-06-20 19:00:00','None',NULL,1,42.7147,23.3569,NULL,'2013-05-31 19:43:24',1),
	(23,'Name',1,'Description','2013-06-28 14:00:00','2013-06-30 13:00:00','None',NULL,1,0.0000,0.0000,NULL,'2013-06-21 10:43:31',1),
	(24,'Test event',2,'Description','2013-07-01 16:00:00','2013-07-31 13:00:00','None',NULL,1,50.1241,9.0033,'55d59bb01d3e8ec238983a18739e935d.jpg','2013-07-01 14:56:59',1),
	(26,'Test event 2',1,'Test','2013-10-22 22:00:00','2013-10-25 22:00:00','Test','',1,0.0000,0.0000,NULL,'2013-10-21 20:47:30',0),
	(27,'Test event 3',1,'Test','2013-10-23 13:00:00','2013-10-23 21:00:00','Test','',1,0.0000,0.0000,NULL,'2013-10-22 19:09:28',1),
	(28,'Test event 4',5,'Description','2013-10-23 22:00:00','2013-10-31 18:00:00','Test','',1,0.0000,0.0000,NULL,'2013-10-23 19:14:29',1),
	(29,'aa',4,'aa','2013-10-23 22:00:00','2013-10-24 04:00:00','None','',1,0.0000,0.0000,NULL,'2013-10-23 19:18:06',0),
	(30,'Test event 5',4,'Test','2013-10-30 01:00:00','2013-11-30 05:00:00','Test','',2,0.0000,0.0000,NULL,'2013-10-29 23:10:57',1);



# Dump of table group
# ------------------------------------------------------------


CREATE TABLE `group` (
  `group_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) NOT NULL DEFAULT '',
  `group_description` text,
  `group_image_filename` varchar(255) DEFAULT NULL,
  `founder_id` int(11) unsigned NOT NULL,
  `is_public` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `group` (`group_id`, `group_name`, `group_description`, `group_image_filename`, `founder_id`, `is_public`, `created_on`)
VALUES
	(1,'First group','This is the very first group',NULL,2,0,'2012-08-16 23:09:51'),
	(2,'New group','Experimental',NULL,2,0,'2012-08-21 14:22:22'),
	(13,'Admin group','My admin group',NULL,2,0,'2012-10-29 17:10:08'),
	(4,'Group 4','test',NULL,1,0,'2012-08-21 14:50:17'),
	(5,'Group 5','Test',NULL,2,0,'2012-08-21 14:57:31'),
	(3,'Group 3','test','66f261340e3573678546336d79e8d273.jpg',1,0,'2012-08-21 14:50:17'),
	(14,'Another admin group','admin','56f5dc00bfb8835586714ac505c8a4fe.png',2,0,'2012-10-29 17:10:49'),
	(15,'Lets test','',NULL,1,0,'2013-02-02 16:18:01'),
	(16,'Test admission','A test group for admission',NULL,1,0,'2013-04-16 08:49:39'),
	(17,'Test admission','A test group1',NULL,0,0,'2013-05-31 23:43:23'),
	(18,'Test admission','A test group1',NULL,0,0,'2013-05-31 23:43:29'),
	(19,'Test','test','a2a34d87cb8f776e433bef508bf42bce.png',1,0,'2013-06-30 15:38:02'),
	(20,'Testgroup','Test',NULL,2,0,'2013-09-29 20:55:08'),
	(21,'Test 1','',NULL,2,0,'2013-09-29 20:58:31');



# Dump of table group_invitations
# ------------------------------------------------------------


CREATE TABLE `group_invitations` (
  `group_id_fk` int(11) unsigned NOT NULL,
  `user_id_fk` int(11) unsigned NOT NULL,
  `invited_by_user_id` int(11) unsigned DEFAULT NULL,
  `invited_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`group_id_fk`,`user_id_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `group_invitations` (`group_id_fk`, `user_id_fk`, `invited_by_user_id`, `invited_on`)
VALUES
	(1,33,2,'2012-08-21 14:06:43'),
	(1,32,2,'2012-08-21 14:06:43'),
	(1,18,2,'2012-08-21 14:06:43'),
	(1,7,2,'2012-08-21 14:08:24'),
	(2,1,2,'2012-08-21 15:14:58'),
	(4,2,1,'2012-08-21 14:50:30'),
	(5,1,2,'2012-08-21 15:07:50'),
	(1,12,2,'2012-08-21 15:13:13'),
	(10,18,1,'2012-10-10 15:53:29'),
	(13,1,NULL,'2012-10-30 23:48:55'),
	(14,105,NULL,'2012-10-31 14:14:01'),
	(14,1,NULL,'2013-01-19 14:41:13'),
	(14,33,2,'2013-01-19 17:56:11'),
	(16,2,NULL,'2013-04-16 08:50:08'),
	(19,2,1,'2013-06-30 15:38:47'),
	(20,1,2,'2013-09-29 20:55:19'),
	(21,1,2,'2013-09-29 20:58:40'),
	(17,2,NULL,'2013-09-29 21:00:12');



# Dump of table group_members
# ------------------------------------------------------------


CREATE TABLE `group_members` (
  `group_id_fk` int(11) unsigned NOT NULL,
  `user_id_fk` int(11) unsigned NOT NULL,
  `role` enum('founder','member') NOT NULL DEFAULT 'member',
  `notifications` tinyint(1) NOT NULL DEFAULT '1',
  `joined_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`group_id_fk`,`user_id_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `group_members` (`group_id_fk`, `user_id_fk`, `role`, `notifications`, `joined_on`)
VALUES
	(1,2,'founder',0,'2012-08-16 23:22:05'),
	(1,1,'member',0,'2012-08-16 23:23:21'),
	(2,2,'founder',1,'2012-08-21 14:22:22'),
	(2,1,'member',1,'2012-08-21 15:17:01'),
	(3,1,'founder',1,'2012-08-21 14:49:43'),
	(4,1,'founder',1,'2012-08-21 14:50:17'),
	(4,2,'member',1,'2012-08-21 14:50:50'),
	(5,2,'founder',1,'2012-08-21 14:57:31'),
	(5,1,'member',1,'2012-08-21 15:17:10'),
	(14,2,'founder',1,'2012-10-29 17:10:49'),
	(13,2,'founder',1,'2012-10-29 17:10:08'),
	(13,1,'member',1,'2012-10-31 15:56:24'),
	(14,1,'member',1,'2013-01-19 17:56:26'),
	(15,1,'founder',1,'2013-02-02 16:18:01'),
	(16,1,'founder',0,'2013-04-16 08:49:39'),
	(19,1,'founder',1,'2013-06-30 15:38:02'),
	(19,2,'member',1,'2013-06-30 15:41:33'),
	(20,2,'founder',1,'2013-09-29 20:55:08'),
	(20,1,'member',1,'2013-09-29 20:58:10'),
	(21,2,'founder',1,'2013-09-29 20:58:31');



# Dump of table group_message_delivery_state
# ------------------------------------------------------------


CREATE TABLE `group_message_delivery_state` (
  `message_id_fk` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id_fk` int(11) unsigned NOT NULL,
  `delivered_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`message_id_fk`,`user_id_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `group_message_delivery_state` (`message_id_fk`, `user_id_fk`, `delivered_on`)
VALUES
	(1,1,'2012-11-07 00:56:26'),
	(1,2,'2012-11-07 00:56:26'),
	(2,1,'2012-11-07 00:56:26'),
	(2,2,'2012-11-07 00:56:26'),
	(3,1,'2012-11-07 00:56:26'),
	(3,2,'2012-11-07 00:56:26'),
	(4,1,'2012-11-07 00:56:26'),
	(4,2,'2012-11-07 00:56:26'),
	(5,1,'2012-11-07 00:56:26'),
	(5,2,'2012-11-07 00:56:26'),
	(6,1,'2012-11-07 00:56:26'),
	(6,2,'2012-11-07 00:56:26'),
	(7,1,'2012-11-07 00:56:26'),
	(7,2,'2012-11-07 00:56:26'),
	(8,1,'2012-11-07 00:56:26'),
	(8,2,'2012-11-07 00:56:26'),
	(9,1,'2012-11-07 00:56:26'),
	(9,2,'2012-11-07 00:56:26'),
	(10,1,'2012-11-07 00:56:26'),
	(11,1,'2012-11-07 00:56:26'),
	(11,2,'2012-11-07 00:56:26'),
	(12,1,'2012-11-07 00:56:26'),
	(12,2,'2012-11-07 00:56:26'),
	(14,1,'2012-11-07 00:56:26'),
	(14,2,'2012-11-07 00:56:26'),
	(15,1,'2012-11-07 00:56:26'),
	(15,2,'2012-11-07 00:56:26'),
	(16,1,'2012-11-07 00:56:26'),
	(16,2,'2012-11-07 00:56:26'),
	(17,1,'2012-11-07 00:56:26'),
	(17,2,'2012-11-07 00:56:26'),
	(18,1,'2012-11-07 00:56:26'),
	(19,1,'2012-11-07 00:56:26'),
	(19,2,'2012-11-07 00:56:26'),
	(20,1,'2012-11-07 00:56:26'),
	(20,2,'2012-11-07 00:56:26'),
	(21,1,'2012-11-07 00:56:26'),
	(21,2,'2012-11-07 00:56:26'),
	(22,1,'2012-11-07 00:56:37'),
	(22,2,'2012-11-07 00:56:51'),
	(23,1,'2012-11-07 00:59:21'),
	(23,2,'2012-11-07 00:59:38'),
	(24,1,'2012-11-07 00:59:27'),
	(24,2,'2012-11-07 00:59:38'),
	(25,1,'2012-11-07 01:00:01'),
	(25,2,'2012-11-07 00:59:48'),
	(26,1,'2013-01-13 00:51:07'),
	(26,2,'2013-01-13 00:51:20'),
	(27,1,'2013-01-13 23:08:42'),
	(27,2,'2013-01-13 00:51:31'),
	(28,1,'2013-01-18 16:41:06'),
	(28,2,'2013-01-19 18:06:06'),
	(29,1,'2013-01-18 17:15:08'),
	(29,2,'2013-01-19 18:06:06'),
	(30,1,'2013-01-18 17:33:57'),
	(30,2,'2013-01-19 18:06:06'),
	(31,1,'2013-01-19 14:21:56'),
	(32,1,'2013-02-02 16:17:50'),
	(32,2,'2013-01-31 01:46:19'),
	(33,1,'2013-01-31 01:55:00'),
	(33,2,'2013-01-31 01:50:02'),
	(34,1,'2013-01-31 02:02:56'),
	(34,2,'2013-01-31 02:03:05'),
	(35,1,'2013-05-24 23:11:53'),
	(35,2,'2013-06-30 15:38:59'),
	(36,1,'2013-06-30 15:41:00'),
	(36,2,'2013-06-30 15:41:33'),
	(37,1,'2014-01-12 00:52:23');



# Dump of table group_messages
# ------------------------------------------------------------


CREATE TABLE `group_messages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `images` text,
  `sender_id` int(11) unsigned NOT NULL,
  `group_id` int(11) unsigned NOT NULL,
  `sent_on_old` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `sent_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sender_id` (`sender_id`),
  KEY `recipient_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `group_messages` (`id`, `message`, `images`, `sender_id`, `group_id`, `sent_on_old`, `sent_on`)
VALUES
	(1,'test',NULL,2,1,'2012-08-16 23:50:23','2012-08-16 22:50:23'),
	(2,'This is the new group :)',NULL,2,1,'2012-08-16 23:51:18','2012-08-16 22:51:18'),
	(3,'And attach some images','322a6c068711a99f704c8cde9d9d4b2e.JPG',2,1,'2012-08-16 23:51:36','2012-08-16 22:51:36'),
	(4,'check email',NULL,2,1,'2012-08-16 23:56:33','2012-08-16 22:56:33'),
	(5,'email',NULL,2,1,'2012-08-16 23:57:29','2012-08-16 22:57:29'),
	(6,'test my links: http://google.com',NULL,1,1,'2012-08-18 23:59:34','2012-08-18 22:59:34'),
	(7,'test',NULL,1,1,'2012-08-20 15:46:32','2012-08-20 14:46:32'),
	(8,'Test',NULL,2,5,'2012-08-21 15:09:45','2012-08-21 14:09:45'),
	(9,'Test1',NULL,2,5,'2012-08-21 15:11:26','2012-08-21 14:11:26'),
	(10,'Hey :)',NULL,1,3,'2012-08-21 15:16:52','2012-08-21 14:16:52'),
	(11,'test',NULL,2,1,'2012-08-22 22:32:12','2012-08-22 21:32:12'),
	(12,'test',NULL,1,1,'2012-08-30 00:07:51','2012-08-29 23:07:51'),
	(14,'time',NULL,1,1,'2012-10-30 23:12:27','2012-10-30 23:12:27'),
	(15,'time',NULL,1,1,'2012-10-30 23:18:51','2012-10-30 21:18:51'),
	(16,'time',NULL,1,1,'2012-10-30 23:21:46','2012-10-30 21:21:46'),
	(17,'time',NULL,1,1,'2012-10-30 23:22:00','2012-10-30 21:22:00'),
	(18,'test',NULL,1,3,'2012-10-30 23:25:21','2012-10-30 21:25:21'),
	(19,'test',NULL,2,1,'2012-11-04 19:26:16','2012-11-04 17:26:16'),
	(20,'reply',NULL,2,1,'2012-11-04 19:28:59','2012-11-04 17:28:59'),
	(21,'test reply',NULL,1,1,'2012-11-07 00:54:28','2012-11-06 22:54:28'),
	(22,'but test',NULL,1,1,'2012-11-07 00:56:37','2012-11-06 22:56:37'),
	(23,'test',NULL,2,1,'2012-11-07 00:57:01','2012-11-06 22:57:01'),
	(24,'great!',NULL,1,1,'2012-11-07 00:59:26','2012-11-06 22:59:26'),
	(25,'tt',NULL,2,1,'2012-11-07 00:59:47','2012-11-06 22:59:47'),
	(26,'test',NULL,1,1,'2013-01-13 00:51:06','2013-01-12 22:51:06'),
	(27,'from admin',NULL,2,1,'2013-01-13 00:51:31','2013-01-12 22:51:31'),
	(32,'hey you :-)',NULL,2,1,'2013-01-31 01:46:18','2013-01-30 23:46:18'),
	(30,'hello',NULL,1,1,'2013-01-18 17:33:56','2013-01-18 15:33:56'),
	(31,'Hey :)',NULL,1,3,'2013-01-19 14:21:54','2013-01-19 12:21:54'),
	(33,'Test',NULL,2,5,'2013-01-31 01:50:02','2013-01-30 23:50:02'),
	(34,'Yup',NULL,1,5,'2013-01-31 02:02:56','2013-01-31 00:02:56'),
	(35,'Test',NULL,1,5,'2013-05-24 23:11:53','2013-05-24 20:11:53'),
	(36,'test',NULL,1,19,'2013-06-30 15:41:00','2013-06-30 12:41:00'),
	(37,'Check',NULL,1,5,'2014-01-12 00:52:23','2014-01-11 22:52:23');



# Dump of table group_tags
# ------------------------------------------------------------


CREATE TABLE `group_tags` (
  `group_id_fk` int(11) unsigned NOT NULL,
  `tag` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table message
# ------------------------------------------------------------


CREATE TABLE `message` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `message_sha_id` char(40) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `images` text,
  `sender_id` int(11) unsigned NOT NULL,
  `thread_id` int(11) unsigned NOT NULL,
  `sent_on_old` timestamp NULL DEFAULT NULL,
  `sent_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sender_id` (`sender_id`),
  KEY `recipient_id` (`thread_id`),
  CONSTRAINT `message_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `message` (`id`, `message_sha_id`, `subject`, `message`, `images`, `sender_id`, `thread_id`, `sent_on_old`, `sent_on`)
VALUES
	(1,'8dbcb31bfbbe5006b6436eb01e64545cec0b3a8d','No subject...','fd',NULL,1,1,'2012-02-15 18:28:12','2012-02-15 18:28:12'),
	(2,'1c322c179277f0533d5d665bb9994e897512aa48','No subject...','fd',NULL,1,2,'2012-02-15 18:28:27','2012-02-15 18:28:27'),
	(3,'d14042827a683863a275cec3888860840f69c17e','No subject...','Hello world!',NULL,1,3,'2012-02-15 18:29:00','2012-02-15 18:29:00'),
	(4,NULL,'No subject...','Answer to hello world',NULL,2,3,'2012-03-18 16:28:08','2012-03-18 16:28:08'),
	(5,NULL,'No subject...','&quot;Abyssinia, Henry&quot; is the 72nd episode of the M*A*S*H television series, and the final episode of the series&#39; third season. First aired on March 18, 1975, and written by Everett Greenbaum and Jim Fritzell, the highly rated episode was most notable for its shocking and unexpected ending. The plot of the episode centers on the honorable discharge and subsequent departure of the 4077th MASH&#39;s commander, Lieutenant Colonel Henry Blake (played by McLean Stevenson). The highly controversial ending to the episode, which has since been referenced and parodied many times, prompted an estimated 1,000-plus letters to series producers Gene Reynolds and Larry Gelbart, and drew fire from both CBS and 20th Century Fox. After the production of this episode, both Stevenson and Wayne Rogers, who played the character of Trapper John McIntyre, left the series to pursue other interests. These combined departures and their subsequent replacements signaled the beginning of a major shift in focus of the M*A*S*H series as a whole.',NULL,1,4,'2012-03-18 17:16:48','2012-03-18 17:16:48'),
	(6,NULL,'No subject...','One more reply',NULL,1,4,'2012-03-18 17:25:06','2012-03-18 17:25:06'),
	(7,NULL,'No subject...','&quot;Abyssinia, Henry&quot; is the 72nd episode of the M*A*S*H television series, and the final episode of the series&#39; third season. First aired on March 18, 1975, and written by Everett Greenbaum and Jim Fritzell, the highly rated episode was most notable for its shocking and unexpected ending. The plot of the episode centers on the honorable discharge and subsequent departure of the 4077th MASH&#39;s commander, Lieutenant Colonel Henry Blake (played by McLean Stevenson). The highly controversial ending to the episode, which has since been referenced and parodied many times, prompted an estimated 1,000-plus letters to series producers Gene Reynolds and Larry Gelbart, and drew fire from both CBS and 20th Century Fox. After the production of this episode, both Stevenson and Wayne Rogers, who played the character of Trapper John McIntyre, left the series to pursue other interests. These combined departures and their subsequent replacements signaled the beginning of a major shift in focus of the M*A*S*H series as a whole.',NULL,103,5,'2012-03-18 19:30:23','2012-03-18 19:30:23'),
	(8,NULL,'No subject...','Yes I read it',NULL,1,5,'2012-03-18 19:31:03','2012-03-18 19:31:03'),
	(9,NULL,'No subject...','This is my new message!',NULL,103,6,'2012-03-18 20:22:51','2012-03-18 20:22:51'),
	(10,NULL,'No subject...','This is my reply to the new message',NULL,1,6,'2012-03-18 20:23:34','2012-03-18 20:23:34'),
	(11,NULL,'No subject...','Abv.bg',NULL,103,7,'2012-03-18 20:33:45','2012-03-18 20:33:45'),
	(12,NULL,'No subject...','test email',NULL,103,8,'2012-03-18 20:34:22','2012-03-18 20:34:22'),
	(13,NULL,'No subject...','test me',NULL,103,9,'2012-03-18 20:34:43','2012-03-18 20:34:43'),
	(14,NULL,'No subject...','test me',NULL,103,10,'2012-03-18 20:34:50','2012-03-18 20:34:50'),
	(15,NULL,'No subject...','Me?',NULL,103,9,'2012-03-18 20:36:47','2012-03-18 20:36:47'),
	(16,NULL,'No subject...','This message is repaired now',NULL,1,11,'2012-03-19 02:11:19','2012-03-19 02:11:19'),
	(17,NULL,'No subject...','Oh really :) Now it is :)',NULL,103,11,'2012-03-19 02:13:09','2012-03-19 02:13:09'),
	(18,NULL,'No subject...','test',NULL,103,12,'2012-03-19 02:15:03','2012-03-19 02:15:03'),
	(19,NULL,'No subject...','test',NULL,103,13,'2012-03-19 02:17:18','2012-03-19 02:17:18'),
	(20,NULL,'No subject...','test',NULL,103,14,'2012-03-19 02:17:38','2012-03-19 02:17:38'),
	(21,NULL,'No subject...','test',NULL,103,15,'2012-03-19 02:20:09','2012-03-19 02:20:09'),
	(22,NULL,'No subject...','test',NULL,103,16,'2012-03-19 02:20:24','2012-03-19 02:20:24'),
	(23,NULL,'No subject...','test',NULL,103,17,'2012-03-19 02:21:39','2012-03-19 02:21:39'),
	(24,NULL,'No subject...','test',NULL,103,18,'2012-03-19 02:21:55','2012-03-19 02:21:55'),
	(25,NULL,'No subject...','test',NULL,103,19,'2012-03-19 02:22:23','2012-03-19 02:22:23'),
	(26,NULL,'No subject...','test',NULL,103,20,'2012-03-19 02:23:38','2012-03-19 02:23:38'),
	(27,NULL,'No subject...','test',NULL,103,21,'2012-03-19 02:25:40','2012-03-19 02:25:40'),
	(28,NULL,'No subject...','test',NULL,103,22,'2012-03-19 02:26:13','2012-03-19 02:26:13'),
	(29,NULL,'No subject...','test',NULL,103,23,'2012-03-19 02:26:27','2012-03-19 02:26:27'),
	(30,NULL,'No subject...','test',NULL,103,24,'2012-03-19 02:26:39','2012-03-19 02:26:39'),
	(31,NULL,'No subject...','test',NULL,103,25,'2012-03-19 02:26:54','2012-03-19 02:26:54'),
	(32,NULL,'No subject...','test',NULL,103,26,'2012-03-19 02:27:02','2012-03-19 02:27:02'),
	(33,NULL,'No subject...','test',NULL,103,27,'2012-03-19 02:27:22','2012-03-19 02:27:22'),
	(34,NULL,'No subject...','test',NULL,103,28,'2012-03-19 02:29:11','2012-03-19 02:29:11'),
	(35,NULL,'No subject...','Hello',NULL,2,29,'2012-04-06 23:13:26','2012-04-06 23:13:26'),
	(36,NULL,'No subject...','Just test',NULL,2,29,'2012-04-06 23:14:01','2012-04-06 23:14:01'),
	(37,NULL,'No subject...','Another test',NULL,2,29,'2012-04-06 23:14:46','2012-04-06 23:14:46'),
	(38,NULL,'No subject...','One other test',NULL,2,29,'2012-04-06 23:15:19','2012-04-06 23:15:19'),
	(39,NULL,'No subject...','One other test',NULL,2,29,'2012-04-06 23:15:44','2012-04-06 23:15:44'),
	(40,NULL,'No subject...','One other test',NULL,2,29,'2012-04-06 23:17:39','2012-04-06 23:17:39'),
	(41,NULL,'No subject...','Yes, really',NULL,1,11,'2012-04-06 23:53:04','2012-04-06 23:53:04'),
	(42,NULL,'No subject...','Another reply',NULL,103,11,'2012-04-06 23:54:21','2012-04-06 23:54:21'),
	(43,NULL,'No subject...','Repaired?',NULL,1,11,'2012-04-07 00:22:48','2012-04-07 00:22:48'),
	(44,NULL,'No subject...','Test',NULL,103,30,'2012-04-07 00:26:57','2012-04-07 00:26:57'),
	(45,NULL,'No subject...','New test',NULL,103,31,'2012-04-07 00:27:17','2012-04-07 00:27:17'),
	(46,NULL,'No subject...','Reply to you',NULL,2,31,'2012-04-07 00:31:21','2012-04-07 00:31:21'),
	(47,NULL,'No subject...','Another new test',NULL,103,32,'2012-04-07 00:31:51','2012-04-07 00:31:51'),
	(48,NULL,'No subject...','Last test',NULL,103,33,'2012-04-07 00:33:48','2012-04-07 00:33:48'),
	(49,NULL,'This is my subject','And this is the first message with subject',NULL,1,34,'2012-07-16 12:59:37','2012-07-16 12:59:37'),
	(50,NULL,'Hello','This is hello thread',NULL,2,35,'2012-07-16 15:41:34','2012-07-16 15:41:34'),
	(51,NULL,'Hello','This is hello thread',NULL,2,36,'2012-07-16 15:41:44','2012-07-16 15:41:44'),
	(52,NULL,NULL,'Another subject',NULL,2,36,'2012-07-16 15:48:23','2012-07-16 15:48:23'),
	(53,NULL,NULL,'Another subject',NULL,2,36,'2012-07-16 15:49:06','2012-07-16 15:49:06'),
	(54,NULL,NULL,'Another subject',NULL,2,36,'2012-07-16 15:49:13','2012-07-16 15:49:13'),
	(55,NULL,NULL,'Latest thread',NULL,2,32,'2012-07-16 16:47:16','2012-07-16 16:47:16'),
	(56,NULL,NULL,'Test reply',NULL,2,34,'2012-07-16 18:12:22','2012-07-16 18:12:22'),
	(57,NULL,NULL,'Another reply',NULL,2,34,'2012-07-16 18:13:20','2012-07-16 18:13:20'),
	(58,NULL,NULL,'New line\nmessage',NULL,1,36,'2012-07-17 12:41:13','2012-07-17 12:41:13'),
	(59,NULL,NULL,'My reply',NULL,1,36,'2012-07-17 12:48:31','2012-07-17 12:48:31'),
	(60,NULL,NULL,'test',NULL,1,36,'2012-07-19 16:23:09','2012-07-19 16:23:09'),
	(61,NULL,NULL,'This is my reply',NULL,2,36,'2012-07-19 16:35:50','2012-07-19 16:35:50'),
	(62,NULL,'Subject 1','Subject 1',NULL,1,37,'2012-07-25 12:24:24','2012-07-25 12:24:24'),
	(63,NULL,'Subject 1','Test',NULL,1,38,'2012-07-25 12:24:40','2012-07-25 12:24:40'),
	(64,NULL,'Subject 1','test',NULL,1,39,'2012-07-25 12:25:44','2012-07-25 12:25:44'),
	(65,NULL,'Empty','test',NULL,1,40,'2012-07-25 12:32:37','2012-07-25 12:32:37'),
	(66,NULL,'test','test',NULL,1,41,'2012-07-25 12:34:01','2012-07-25 12:34:01'),
	(67,NULL,'test','test',NULL,1,42,'2012-07-25 12:39:03','2012-07-25 12:39:03'),
	(68,NULL,'test','test',NULL,1,43,'2012-07-25 12:47:40','2012-07-25 12:47:40'),
	(69,NULL,'test','test',NULL,1,44,'2012-07-25 12:48:33','2012-07-25 12:48:33'),
	(70,NULL,'test','test',NULL,1,45,'2012-07-25 12:48:59','2012-07-25 12:48:59'),
	(71,NULL,'New message','test timezones',NULL,1,46,'2012-07-26 10:32:20','2012-07-26 10:32:20'),
	(72,NULL,NULL,'my reply',NULL,2,46,'2012-07-26 11:00:54','2012-07-26 11:00:54'),
	(77,NULL,NULL,'test',NULL,1,46,'2012-07-29 22:50:32','2012-07-29 22:50:32'),
	(78,NULL,NULL,'test',NULL,1,46,'2012-07-29 22:51:12','2012-07-29 22:51:12'),
	(79,NULL,'Let me see what will happen with this long long title. Is it long enough to fit this row?','Test',NULL,1,47,'2012-07-31 13:23:38','2012-07-31 13:23:38'),
	(80,NULL,'test','test',NULL,2,48,'2012-07-31 15:40:06','2012-07-31 15:40:06'),
	(81,NULL,NULL,'Seems to be working',NULL,2,47,'2012-07-31 15:40:45','2012-07-31 15:40:45'),
	(82,NULL,'test','test',NULL,2,49,'2012-07-31 15:45:30','2012-07-31 15:45:30'),
	(83,NULL,'test','test',NULL,2,50,'2012-07-31 15:46:13','2012-07-31 15:46:13'),
	(84,NULL,'test1','test',NULL,2,51,'2012-07-31 15:46:27','2012-07-31 15:46:27'),
	(85,NULL,'test2','test',NULL,2,52,'2012-07-31 15:47:33','2012-07-31 15:47:33'),
	(86,NULL,'test2','test',NULL,2,53,'2012-07-31 15:48:31','2012-07-31 15:48:31'),
	(87,NULL,'test2','test',NULL,2,54,'2012-07-31 15:49:23','2012-07-31 15:49:23'),
	(88,NULL,'test2','test',NULL,2,55,'2012-07-31 15:49:43','2012-07-31 15:49:43'),
	(89,NULL,'test2','test',NULL,2,56,'2012-07-31 15:50:00','2012-07-31 15:50:00'),
	(90,NULL,'test2','test',NULL,2,57,'2012-07-31 15:50:19','2012-07-31 15:50:19'),
	(91,NULL,'test2','test',NULL,2,58,'2012-07-31 15:50:37','2012-07-31 15:50:37'),
	(92,NULL,'test2','test',NULL,2,59,'2012-07-31 15:50:44','2012-07-31 15:50:44'),
	(93,NULL,'test2','test',NULL,2,60,'2012-07-31 15:51:39','2012-07-31 15:51:39'),
	(94,NULL,'test2','test',NULL,2,61,'2012-07-31 15:52:25','2012-07-31 15:52:25'),
	(95,NULL,NULL,'Another reply',NULL,2,47,'2012-07-31 15:56:04','2012-07-31 15:56:04'),
	(96,NULL,NULL,'Another reply',NULL,2,47,'2012-07-31 15:56:55','2012-07-31 15:56:55'),
	(97,NULL,NULL,'Another reply',NULL,2,47,'2012-07-31 15:57:23','2012-07-31 15:57:23'),
	(98,NULL,NULL,'Another reply',NULL,2,47,'2012-07-31 15:57:42','2012-07-31 15:57:42'),
	(99,NULL,NULL,'Another reply',NULL,2,47,'2012-07-31 15:58:02','2012-07-31 15:58:02'),
	(100,NULL,NULL,'Another reply',NULL,2,47,'2012-07-31 15:58:35','2012-07-31 15:58:35'),
	(101,NULL,NULL,'what a test :)',NULL,2,47,'2012-07-31 17:32:10','2012-07-31 17:32:10'),
	(102,NULL,NULL,'Test',NULL,2,46,'2012-07-31 17:38:28','2012-07-31 17:38:28'),
	(103,NULL,NULL,'Test',NULL,1,47,'2012-07-31 19:58:16','2012-07-31 19:58:16'),
	(104,NULL,NULL,'test',NULL,1,28,'2012-07-31 20:08:02','2012-07-31 20:08:02'),
	(105,NULL,NULL,'Test',NULL,1,28,'2012-08-01 14:16:32','2012-08-01 14:16:32'),
	(106,NULL,NULL,'I test',NULL,1,28,'2012-08-01 17:18:21','2012-08-01 17:18:21'),
	(107,NULL,NULL,'test',NULL,1,61,'2012-08-03 01:41:07','2012-08-03 01:41:07'),
	(108,NULL,NULL,'test',NULL,2,61,'2012-08-03 02:02:00','2012-08-03 02:02:00'),
	(109,NULL,'My new message','test',NULL,1,62,'2012-08-09 16:21:02','2012-08-09 16:21:02'),
	(110,NULL,'test2t','test',NULL,1,63,'2012-08-11 13:22:44','2012-08-11 13:22:44'),
	(111,NULL,'test','123',NULL,1,64,'2012-08-11 13:27:52','2012-08-11 13:27:52'),
	(112,NULL,'test','test',NULL,1,65,'2012-08-11 13:28:22','2012-08-11 13:28:22'),
	(113,NULL,NULL,'test',NULL,1,61,'2012-08-11 21:02:09','2012-08-11 21:02:09'),
	(114,NULL,NULL,'test',NULL,1,28,'2012-08-11 21:37:53','2012-08-11 21:37:53'),
	(115,NULL,NULL,'test',NULL,1,47,'2012-08-11 21:38:06','2012-08-11 21:38:06'),
	(116,NULL,'Images upload message','Test',NULL,1,66,'2012-08-11 23:07:10','2012-08-11 23:07:10'),
	(117,NULL,NULL,'test',NULL,1,66,'2012-08-13 15:42:42','2012-08-13 15:42:42'),
	(118,NULL,NULL,'test',NULL,1,66,'2012-08-13 15:42:57','2012-08-13 15:42:57'),
	(119,NULL,NULL,'1',NULL,1,66,'2012-08-13 15:43:23','2012-08-13 15:43:23'),
	(120,NULL,NULL,'da',NULL,1,66,'2012-08-13 15:43:38','2012-08-13 15:43:38'),
	(121,NULL,NULL,'1',NULL,1,66,'2012-08-13 15:45:04','2012-08-13 15:45:04'),
	(122,NULL,NULL,'2',NULL,1,66,'2012-08-13 15:45:18','2012-08-13 15:45:18'),
	(123,NULL,NULL,'1',NULL,1,66,'2012-08-13 15:46:35','2012-08-13 15:46:35'),
	(124,NULL,NULL,'2',NULL,1,66,'2012-08-13 15:47:01','2012-08-13 15:47:01'),
	(125,NULL,NULL,'1',NULL,1,66,'2012-08-13 15:47:43','2012-08-13 15:47:43'),
	(126,NULL,NULL,'3',NULL,1,66,'2012-08-13 15:48:20','2012-08-13 15:48:20'),
	(127,NULL,NULL,'2',NULL,1,66,'2012-08-13 15:48:47','2012-08-13 15:48:47'),
	(128,NULL,NULL,'1',NULL,1,66,'2012-08-13 15:49:05','2012-08-13 15:49:05'),
	(129,NULL,NULL,'test','32e5ff2f59262951911369c1fcb9a963.jpg',1,66,'2012-08-13 15:54:57','2012-08-13 15:54:57'),
	(130,NULL,NULL,'Another reply','7d32e2b6897a1e7359b123791964d8d8.jpg,8597067da553ebb97875ebbaf3db04ab.JPG',1,66,'2012-08-13 16:11:30','2012-08-13 16:11:30'),
	(131,NULL,NULL,'test','b1876e1102a437f0a26fd9e6374132ae.JPG',1,66,'2012-08-13 16:18:24','2012-08-13 16:18:24'),
	(132,NULL,NULL,'test',NULL,2,66,'2012-08-14 10:35:27','2012-08-14 10:35:27'),
	(133,NULL,NULL,'test','9a81c0fe5028b5f85af2b049a50dce05.JPG',1,66,'2012-08-16 18:33:25','2012-08-16 18:33:25'),
	(134,NULL,NULL,'test','8bc91efe6b16e49e1695a1eec22d81f1.jpg',1,66,'2012-08-16 18:34:52','2012-08-16 18:34:52'),
	(135,NULL,NULL,'test',NULL,2,66,'2012-08-16 23:40:36','2012-08-16 23:40:36'),
	(136,NULL,NULL,'test external links http://www.google.com',NULL,1,66,'2012-08-19 00:01:39','2012-08-19 00:01:39'),
	(137,NULL,NULL,'test',NULL,1,66,'2012-08-19 17:42:30','2012-08-19 17:42:30'),
	(138,NULL,NULL,'test',NULL,1,66,'2012-08-19 17:42:35','2012-08-19 17:42:35'),
	(139,NULL,NULL,'test',NULL,1,66,'2012-08-20 15:32:17','2012-08-20 15:32:17'),
	(140,NULL,NULL,'test',NULL,1,66,'2012-08-30 00:04:36','2012-08-30 00:04:36'),
	(141,NULL,NULL,'test',NULL,1,66,'2012-08-30 00:07:37','2012-08-30 00:07:37'),
	(142,NULL,'Hey','How&#39;re you admin?',NULL,1,67,'2012-09-14 14:08:29','2012-09-14 14:08:29'),
	(143,NULL,'test','test',NULL,1,68,'2012-09-14 15:04:48','2012-09-14 15:04:48'),
	(144,NULL,NULL,'test',NULL,1,68,'2012-10-24 01:21:01','2012-10-24 01:21:01'),
	(145,NULL,NULL,'test',NULL,1,68,NULL,'0000-00-00 00:00:00'),
	(146,NULL,NULL,'test',NULL,1,68,NULL,'0000-00-00 00:00:00'),
	(147,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-24 19:30:00'),
	(148,NULL,NULL,'another test',NULL,1,68,NULL,'2012-10-24 19:34:00'),
	(149,NULL,NULL,'test',NULL,1,68,NULL,'0000-00-00 00:00:00'),
	(150,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-24 19:35:25'),
	(151,NULL,NULL,'test',NULL,1,68,NULL,'0000-00-00 00:00:00'),
	(152,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-24 19:44:20'),
	(153,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-24 20:00:11'),
	(154,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-24 20:01:20'),
	(155,NULL,NULL,'i',NULL,1,68,NULL,'2012-10-24 20:02:33'),
	(156,NULL,NULL,'a',NULL,1,68,NULL,'2012-10-24 20:04:59'),
	(157,NULL,NULL,'b',NULL,1,68,NULL,'2012-10-24 20:05:38'),
	(158,NULL,NULL,'c',NULL,1,68,NULL,'2012-10-24 20:06:30'),
	(159,NULL,NULL,'d',NULL,1,68,NULL,'2012-10-24 20:09:04'),
	(160,NULL,NULL,'is it working?',NULL,1,68,NULL,'2012-10-24 20:12:37'),
	(161,NULL,NULL,'yes',NULL,1,68,NULL,'2012-10-24 20:22:48'),
	(162,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-24 21:05:29'),
	(163,NULL,NULL,'a new reply',NULL,1,68,NULL,'2012-10-29 12:29:15'),
	(164,NULL,NULL,'really',NULL,1,68,NULL,'2012-10-29 12:29:20'),
	(165,NULL,NULL,'test me',NULL,1,68,NULL,'2012-10-29 12:30:17'),
	(166,NULL,NULL,'does it?',NULL,1,68,NULL,'2012-10-29 12:30:23'),
	(167,NULL,NULL,'test',NULL,1,68,NULL,'2012-10-29 12:30:28'),
	(168,NULL,NULL,'this',NULL,1,68,NULL,'2012-10-29 12:33:24'),
	(169,NULL,NULL,'test again',NULL,1,68,NULL,'2012-10-29 12:33:43'),
	(170,NULL,'From admin','admin',NULL,1,69,NULL,'2012-10-29 14:42:19'),
	(171,NULL,'From admin','admin',NULL,1,70,NULL,'2012-10-29 14:42:39'),
	(172,NULL,'From admin','admin',NULL,1,71,NULL,'2012-10-29 14:42:44'),
	(173,NULL,'From admin','admin',NULL,1,72,NULL,'2012-10-29 14:43:45'),
	(174,NULL,'From admin','admin',NULL,1,73,NULL,'2012-10-29 14:43:51'),
	(175,NULL,'From admin','admin',NULL,1,74,NULL,'2012-10-29 14:49:44'),
	(176,NULL,'From admin','admin',NULL,1,75,NULL,'2012-10-29 14:50:20'),
	(177,NULL,'From admin','admin',NULL,1,76,NULL,'2012-10-29 14:50:36'),
	(178,NULL,'From admin','admin',NULL,1,77,NULL,'2012-10-29 14:51:30'),
	(179,NULL,'From admin','test',NULL,1,78,NULL,'2012-10-29 14:52:49'),
	(180,NULL,'From admin','test',NULL,1,79,NULL,'2012-10-29 14:53:28'),
	(181,NULL,'aa','aa',NULL,1,80,NULL,'2012-10-29 14:56:57'),
	(182,NULL,'msg','msg',NULL,1,81,NULL,'2012-10-29 14:57:28'),
	(183,NULL,NULL,'test',NULL,1,81,NULL,'2012-10-30 21:15:27'),
	(184,NULL,NULL,'aa',NULL,2,78,NULL,'2013-01-19 22:04:13'),
	(185,NULL,NULL,'bb','a508989991c520bcfb1ad56cf2a5f4ec.jpg',2,78,NULL,'2013-01-19 22:04:30'),
	(186,NULL,'Test','Message',NULL,1,93,NULL,'2013-04-18 20:28:52'),
	(187,NULL,'Test 1','Message',NULL,1,94,NULL,'2013-04-18 20:29:09'),
	(188,NULL,NULL,'THis is a long long messagegegegegeee gegeege',NULL,1,94,NULL,'2013-06-01 02:08:22'),
	(189,NULL,NULL,'Test','8e191fbb585b73212d8f04ec321add2b.JPG',1,94,NULL,'2013-06-01 02:24:35'),
	(190,NULL,NULL,'aa',NULL,1,94,NULL,'2013-06-26 08:42:15'),
	(191,NULL,NULL,'aa',NULL,1,94,NULL,'2013-06-26 08:43:23'),
	(192,NULL,NULL,'tt',NULL,1,94,NULL,'2013-06-26 08:43:58'),
	(193,NULL,'Test message','Yesss :)',NULL,1,95,NULL,'2013-09-19 03:04:30');



# Dump of table message_delivery_state
# ------------------------------------------------------------


CREATE TABLE `message_delivery_state` (
  `message_id_fk` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id_fk` int(11) unsigned NOT NULL,
  `delivered_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`message_id_fk`,`user_id_fk`),
  KEY `user_id_fk` (`user_id_fk`),
  CONSTRAINT `message_delivery_state_ibfk_1` FOREIGN KEY (`message_id_fk`) REFERENCES `message` (`id`) ON DELETE CASCADE,
  CONSTRAINT `message_delivery_state_ibfk_2` FOREIGN KEY (`user_id_fk`) REFERENCES `users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `message_delivery_state` (`message_id_fk`, `user_id_fk`, `delivered_on`)
VALUES
	(1,12,'2012-02-15 18:39:50'),
	(2,2,'2012-03-18 19:16:11'),
	(3,2,'2012-03-18 18:59:41'),
	(4,2,'2012-03-18 18:59:41'),
	(5,2,'2012-03-18 17:35:29'),
	(6,2,'2012-03-18 17:35:29'),
	(7,1,'2012-03-18 19:30:49'),
	(8,1,'2012-03-18 19:31:03'),
	(9,1,'2012-03-18 20:23:12'),
	(9,103,'2012-03-18 20:22:56'),
	(10,1,'2012-03-18 20:23:34'),
	(10,103,'2012-03-18 20:23:59'),
	(11,1,'2012-03-19 02:07:46'),
	(11,103,'2012-03-18 20:36:35'),
	(12,1,'2012-03-19 02:10:50'),
	(12,103,'2012-03-18 20:36:39'),
	(13,1,'2012-03-19 02:10:54'),
	(13,103,'2012-03-18 20:36:42'),
	(14,1,'2012-03-19 02:11:00'),
	(14,103,'2012-03-18 20:36:52'),
	(15,1,'2012-03-19 02:10:54'),
	(15,103,'2012-03-18 20:36:47'),
	(16,1,'2012-04-06 20:28:26'),
	(16,103,'2012-03-19 02:12:59'),
	(17,1,'2012-04-06 20:28:26'),
	(17,103,'2012-03-19 02:13:09'),
	(18,1,'2012-04-06 17:32:14'),
	(18,103,'2012-04-07 00:29:32'),
	(19,1,'2012-04-06 17:32:20'),
	(20,103,'2012-04-07 00:29:27'),
	(23,1,'2012-04-06 17:32:23'),
	(27,103,'2012-04-07 00:29:23'),
	(31,1,'2012-07-26 10:15:38'),
	(32,1,'2012-07-16 23:00:03'),
	(33,1,'2012-07-16 22:59:58'),
	(34,1,'2012-07-16 22:59:53'),
	(35,1,'2012-07-16 22:59:43'),
	(35,2,'2012-04-06 23:13:57'),
	(36,1,'2012-07-16 22:59:43'),
	(36,2,'2012-04-06 23:14:01'),
	(37,1,'2012-07-16 22:59:43'),
	(37,2,'2012-04-06 23:14:46'),
	(38,1,'2012-07-16 22:59:43'),
	(38,2,'2012-04-06 23:15:19'),
	(39,1,'2012-07-16 22:59:43'),
	(39,2,'2012-04-06 23:15:44'),
	(40,1,'2012-07-16 22:59:43'),
	(40,2,'2012-04-06 23:17:39'),
	(41,1,'2012-04-06 23:53:04'),
	(41,103,'2012-04-06 23:53:48'),
	(42,1,'2012-04-07 00:22:35'),
	(42,103,'2012-04-06 23:54:21'),
	(43,1,'2012-04-07 00:22:48'),
	(43,103,'2012-04-07 00:23:36'),
	(44,1,'2012-07-16 22:59:39'),
	(44,103,'2012-04-07 00:27:04'),
	(45,2,'2012-04-07 00:31:16'),
	(45,103,'2012-04-07 00:30:53'),
	(46,2,'2012-04-07 00:31:21'),
	(46,103,'2012-04-07 00:31:32'),
	(47,2,'2012-07-16 16:47:12'),
	(47,103,'2012-04-07 00:32:03'),
	(48,1,'2012-07-16 12:47:06'),
	(48,2,'2012-07-16 16:47:07'),
	(48,103,'2012-04-07 00:33:48'),
	(49,2,'2012-07-16 12:59:58'),
	(50,1,'2012-07-16 22:59:34'),
	(51,1,'2012-07-16 22:59:27'),
	(51,2,'2012-07-16 15:41:45'),
	(52,1,'2012-07-16 22:59:27'),
	(52,2,'2012-07-16 15:48:23'),
	(53,1,'2012-07-16 22:59:27'),
	(53,2,'2012-07-16 15:49:06'),
	(54,1,'2012-07-16 22:59:27'),
	(54,2,'2012-07-16 15:49:13'),
	(55,2,'2012-07-16 16:47:19'),
	(56,2,'2012-07-16 18:12:23'),
	(57,2,'2012-07-16 18:13:20'),
	(58,1,'2012-07-17 12:41:14'),
	(58,2,'2012-07-19 16:35:38'),
	(59,1,'2012-07-17 12:48:32'),
	(59,2,'2012-07-19 16:35:38'),
	(60,1,'2012-07-19 16:23:09'),
	(60,2,'2012-07-19 16:35:38'),
	(61,1,'2012-07-25 10:09:55'),
	(61,2,'2012-07-19 16:35:50'),
	(62,1,'2012-07-25 12:24:24'),
	(63,1,'2012-07-25 12:24:40'),
	(64,1,'2012-07-25 12:25:45'),
	(65,1,'2012-07-25 12:32:37'),
	(66,1,'2012-07-25 12:34:01'),
	(67,1,'2012-07-25 12:39:04'),
	(68,1,'2012-07-25 12:47:40'),
	(69,1,'2012-07-25 12:48:33'),
	(70,1,'2012-07-25 12:48:59'),
	(71,1,'2012-07-26 10:32:21'),
	(71,2,'2012-07-26 11:00:49'),
	(72,1,'2012-07-26 11:01:10'),
	(72,2,'2012-07-26 11:00:54'),
	(77,1,'2012-07-29 22:51:08'),
	(77,2,'2012-07-31 17:38:22'),
	(78,1,'2012-07-29 22:51:12'),
	(78,2,'2012-07-31 17:38:22'),
	(79,1,'2012-07-31 13:23:39'),
	(79,2,'2012-07-31 15:40:35'),
	(80,1,'2013-01-17 17:23:07'),
	(80,2,'2012-07-31 15:40:06'),
	(81,1,'2012-07-31 17:38:41'),
	(81,2,'2012-07-31 15:40:45'),
	(82,1,'2012-07-31 20:07:50'),
	(82,2,'2012-07-31 15:45:30'),
	(83,1,'2013-04-24 03:00:52'),
	(83,2,'2012-07-31 15:46:13'),
	(91,1,'2013-04-16 10:03:55'),
	(92,1,'2012-09-12 00:39:54'),
	(93,1,'2012-08-09 16:18:20'),
	(94,1,'2012-08-03 01:41:03'),
	(94,2,'2012-08-03 02:01:56'),
	(95,1,'2012-07-31 17:38:41'),
	(95,2,'2012-07-31 15:57:23'),
	(96,1,'2012-07-31 17:38:41'),
	(96,2,'2012-07-31 15:57:23'),
	(97,1,'2012-07-31 17:38:41'),
	(97,2,'2012-07-31 15:57:42'),
	(98,1,'2012-07-31 17:38:41'),
	(98,2,'2012-07-31 15:58:02'),
	(99,1,'2012-07-31 17:38:41'),
	(99,2,'2012-07-31 15:58:35'),
	(100,1,'2012-07-31 17:38:41'),
	(100,2,'2012-07-31 15:58:35'),
	(101,1,'2012-07-31 17:38:41'),
	(101,2,'2012-07-31 17:32:10'),
	(102,1,'2012-07-31 17:38:50'),
	(102,2,'2012-07-31 17:38:28'),
	(103,1,'2012-07-31 19:58:17'),
	(103,2,'2012-08-01 15:45:25'),
	(104,1,'2012-07-31 20:08:02'),
	(105,1,'2012-08-01 14:16:33'),
	(106,1,'2012-08-01 17:18:22'),
	(107,1,'2012-08-03 01:41:07'),
	(107,2,'2012-08-03 02:01:56'),
	(108,1,'2012-08-09 15:22:02'),
	(108,2,'2012-08-03 02:02:00'),
	(109,1,'2012-08-09 16:21:03'),
	(110,1,'2012-08-11 13:27:17'),
	(111,1,'2012-08-11 13:27:52'),
	(112,1,'2012-08-11 13:28:23'),
	(113,1,'2012-08-11 21:02:09'),
	(114,1,'2012-08-11 21:37:53'),
	(115,1,'2012-08-11 21:38:06'),
	(116,1,'2012-08-11 23:07:10'),
	(116,2,'2012-08-14 10:35:27'),
	(117,1,'2012-08-13 15:42:43'),
	(117,2,'2012-08-14 10:35:27'),
	(118,1,'2012-08-13 15:42:57'),
	(118,2,'2012-08-14 10:35:27'),
	(119,1,'2012-08-13 15:43:24'),
	(119,2,'2012-08-14 10:35:27'),
	(120,1,'2012-08-13 15:43:38'),
	(120,2,'2012-08-14 10:35:27'),
	(121,1,'2012-08-13 15:45:04'),
	(121,2,'2012-08-14 10:35:27'),
	(122,1,'2012-08-13 15:45:18'),
	(122,2,'2012-08-14 10:35:27'),
	(123,1,'2012-08-13 15:46:35'),
	(123,2,'2012-08-14 10:35:27'),
	(124,1,'2012-08-13 15:47:01'),
	(124,2,'2012-08-14 10:35:27'),
	(125,1,'2012-08-13 15:47:43'),
	(125,2,'2012-08-14 10:35:27'),
	(126,1,'2012-08-13 15:48:20'),
	(126,2,'2012-08-14 10:35:27'),
	(127,1,'2012-08-13 15:48:47'),
	(127,2,'2012-08-14 10:35:27'),
	(128,1,'2012-08-13 15:54:47'),
	(128,2,'2012-08-14 10:35:27'),
	(129,1,'2012-08-13 15:54:57'),
	(129,2,'2012-08-14 10:35:27'),
	(130,1,'2012-08-13 16:11:30'),
	(130,2,'2012-08-14 10:35:27'),
	(131,1,'2012-08-13 16:18:24'),
	(131,2,'2012-08-14 10:35:27'),
	(132,1,'2012-08-16 18:25:40'),
	(132,2,'2012-08-14 10:35:27'),
	(133,1,'2012-08-16 18:33:25'),
	(133,2,'2012-08-16 22:27:41'),
	(134,1,'2012-08-16 18:34:52'),
	(134,2,'2012-08-16 22:27:41'),
	(135,1,'2012-08-19 00:01:27'),
	(135,2,'2012-08-16 23:40:37'),
	(136,1,'2012-08-19 00:01:40'),
	(137,1,'2012-08-19 17:42:31'),
	(138,1,'2012-08-19 17:42:35'),
	(139,1,'2012-08-20 15:32:17'),
	(140,1,'2012-08-30 00:04:37'),
	(141,1,'2012-08-30 00:07:37'),
	(142,1,'2012-09-14 14:08:31'),
	(142,2,'2012-10-29 16:38:04'),
	(143,1,'2012-09-14 15:04:49'),
	(143,2,'2012-10-29 16:37:57'),
	(144,1,'2012-10-24 01:21:01'),
	(144,2,'2012-10-29 16:37:57'),
	(145,1,'2012-10-24 22:28:26'),
	(145,2,'2012-10-29 16:37:57'),
	(146,1,'2012-10-24 22:29:19'),
	(146,2,'2012-10-29 16:37:57'),
	(147,1,'2012-10-24 22:30:30'),
	(147,2,'2012-10-29 16:37:57'),
	(148,1,'2012-10-24 22:34:31'),
	(148,2,'2012-10-29 16:37:57'),
	(149,1,'2012-10-24 22:34:47'),
	(149,2,'2012-10-29 16:37:57'),
	(150,1,'2012-10-24 22:35:25'),
	(150,2,'2012-10-29 16:37:57'),
	(151,1,'2012-10-24 22:44:05'),
	(151,2,'2012-10-29 16:37:57'),
	(152,1,'2012-10-24 22:44:20'),
	(152,2,'2012-10-29 16:37:57'),
	(153,1,'2012-10-24 22:46:15'),
	(153,2,'2012-10-29 16:37:57'),
	(154,1,'2012-10-24 23:01:20'),
	(154,2,'2012-10-29 16:37:57'),
	(155,1,'2012-10-24 23:02:33'),
	(155,2,'2012-10-29 16:37:57'),
	(156,1,'2012-10-24 23:04:59'),
	(156,2,'2012-10-29 16:37:57'),
	(157,1,'2012-10-24 23:05:38'),
	(157,2,'2012-10-29 16:37:57'),
	(158,1,'2012-10-24 23:06:31'),
	(158,2,'2012-10-29 16:37:57'),
	(159,1,'2012-10-24 23:09:04'),
	(159,2,'2012-10-29 16:37:57'),
	(160,1,'2012-10-24 23:12:38'),
	(160,2,'2012-10-29 16:37:57'),
	(161,1,'2012-10-24 23:22:49'),
	(161,2,'2012-10-29 16:37:57'),
	(162,1,'2012-10-25 00:05:30'),
	(162,2,'2012-10-29 16:37:57'),
	(163,1,'2012-10-29 14:29:15'),
	(163,2,'2012-10-29 16:37:57'),
	(164,1,'2012-10-29 14:29:20'),
	(164,2,'2012-10-29 16:37:57'),
	(165,1,'2012-10-29 14:30:17'),
	(165,2,'2012-10-29 16:37:57'),
	(166,1,'2012-10-29 14:30:23'),
	(166,2,'2012-10-29 16:37:57'),
	(167,1,'2012-10-29 14:30:28'),
	(167,2,'2012-10-29 16:37:57'),
	(168,1,'2012-10-29 14:33:24'),
	(168,2,'2012-10-29 16:37:57'),
	(169,1,'2012-10-29 14:33:43'),
	(169,2,'2012-10-29 16:37:57'),
	(171,1,'2013-06-01 05:23:18'),
	(178,2,'2012-10-29 16:52:00'),
	(179,1,'2013-01-31 01:39:57'),
	(179,2,'2013-01-20 00:04:11'),
	(180,2,'2013-01-19 23:46:24'),
	(181,1,'2013-01-17 16:29:25'),
	(182,1,'2012-10-30 23:15:21'),
	(183,1,'2012-10-30 23:15:27'),
	(184,1,'2013-01-31 01:39:57'),
	(184,2,'2013-01-20 00:04:13'),
	(185,1,'2013-01-31 01:39:57'),
	(185,2,'2013-01-20 00:04:30'),
	(186,1,'2013-04-18 23:28:52'),
	(187,1,'2013-04-18 23:29:09'),
	(188,1,'2013-06-01 05:08:22'),
	(189,1,'2013-06-01 05:24:35'),
	(190,1,'2013-06-26 11:42:16'),
	(191,1,'2013-06-26 11:43:23'),
	(192,1,'2013-06-30 15:11:57'),
	(193,1,'2013-09-19 06:04:30');



# Dump of table message_participants
# ------------------------------------------------------------


CREATE TABLE `message_participants` (
  `thread_id_fk` int(11) unsigned NOT NULL,
  `recipient_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`thread_id_fk`,`recipient_id`),
  KEY `recipient_id` (`recipient_id`),
  CONSTRAINT `message_participants_ibfk_1` FOREIGN KEY (`recipient_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE,
  CONSTRAINT `message_participants_ibfk_2` FOREIGN KEY (`thread_id_fk`) REFERENCES `message` (`thread_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `message_participants` (`thread_id_fk`, `recipient_id`)
VALUES
	(5,1),
	(6,1),
	(7,1),
	(8,1),
	(9,1),
	(10,1),
	(11,1),
	(12,1),
	(13,1),
	(14,1),
	(15,1),
	(16,1),
	(17,1),
	(18,1),
	(19,1),
	(20,1),
	(21,1),
	(22,1),
	(23,1),
	(24,1),
	(25,1),
	(26,1),
	(27,1),
	(28,1),
	(29,1),
	(30,1),
	(33,1),
	(35,1),
	(36,1),
	(37,1),
	(38,1),
	(39,1),
	(40,1),
	(41,1),
	(42,1),
	(43,1),
	(44,1),
	(45,1),
	(46,1),
	(47,1),
	(48,1),
	(49,1),
	(50,1),
	(52,1),
	(53,1),
	(54,1),
	(55,1),
	(56,1),
	(57,1),
	(58,1),
	(59,1),
	(60,1),
	(61,1),
	(62,1),
	(63,1),
	(64,1),
	(65,1),
	(66,1),
	(67,1),
	(68,1),
	(69,1),
	(70,1),
	(71,1),
	(72,1),
	(73,1),
	(74,1),
	(75,1),
	(76,1),
	(77,1),
	(78,1),
	(79,1),
	(80,1),
	(81,1),
	(93,1),
	(94,1),
	(95,1),
	(2,2),
	(3,2),
	(4,2),
	(29,2),
	(31,2),
	(32,2),
	(33,2),
	(34,2),
	(35,2),
	(36,2),
	(37,2),
	(38,2),
	(42,2),
	(43,2),
	(45,2),
	(46,2),
	(47,2),
	(48,2),
	(49,2),
	(50,2),
	(52,2),
	(53,2),
	(54,2),
	(55,2),
	(56,2),
	(57,2),
	(58,2),
	(59,2),
	(60,2),
	(61,2),
	(62,2),
	(63,2),
	(65,2),
	(66,2),
	(67,2),
	(68,2),
	(69,2),
	(70,2),
	(71,2),
	(72,2),
	(73,2),
	(74,2),
	(75,2),
	(76,2),
	(77,2),
	(78,2),
	(79,2),
	(93,2),
	(94,2),
	(95,2),
	(80,3),
	(2,12),
	(3,12),
	(41,12),
	(47,12),
	(64,12),
	(63,18),
	(64,18),
	(81,28),
	(6,103),
	(7,103),
	(8,103),
	(9,103),
	(10,103),
	(11,103),
	(12,103),
	(13,103),
	(14,103),
	(15,103),
	(16,103),
	(17,103),
	(18,103),
	(19,103),
	(20,103),
	(21,103),
	(22,103),
	(23,103),
	(24,103),
	(25,103),
	(26,103),
	(27,103),
	(28,103),
	(30,103),
	(31,103),
	(32,103),
	(33,103),
	(63,103),
	(64,103);



# Dump of table sequences
# ------------------------------------------------------------


CREATE TABLE `sequences` (
  `seq_name` varchar(20) NOT NULL DEFAULT '',
  `seq_val` int(11) unsigned NOT NULL,
  PRIMARY KEY (`seq_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `sequences` (`seq_name`, `seq_val`)
VALUES
	('MESSAGE_THREAD',95);



# Dump of table sessions
# ------------------------------------------------------------


CREATE TABLE `sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table user_relations
# ------------------------------------------------------------


CREATE TABLE `user_relations` (
  `userA_fk` int(11) unsigned NOT NULL,
  `userB_fk` int(11) unsigned NOT NULL,
  PRIMARY KEY (`userA_fk`,`userB_fk`),
  KEY `userB_fk` (`userB_fk`),
  CONSTRAINT `user_relations_ibfk_1` FOREIGN KEY (`userA_fk`) REFERENCES `users` (`user_id`) ON DELETE CASCADE,
  CONSTRAINT `user_relations_ibfk_2` FOREIGN KEY (`userB_fk`) REFERENCES `users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `user_relations` (`userA_fk`, `userB_fk`)
VALUES
	(2,1),
	(18,1),
	(103,1),
	(110,1),
	(1,2),
	(2,2),
	(12,2),
	(32,2),
	(103,2),
	(2,7),
	(1,12),
	(2,12),
	(1,18),
	(2,18),
	(1,32),
	(2,32),
	(2,33),
	(1,64),
	(1,103);



# Dump of table user_reset_password
# ------------------------------------------------------------


CREATE TABLE `user_reset_password` (
  `user_id_fk` int(11) unsigned NOT NULL,
  `reset_token` varchar(255) NOT NULL DEFAULT '',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `reset_token` (`reset_token`),
  KEY `user_id_fk` (`user_id_fk`),
  CONSTRAINT `user_reset_password_ibfk_1` FOREIGN KEY (`user_id_fk`) REFERENCES `users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `user_reset_password` (`user_id_fk`, `reset_token`, `created_on`)
VALUES
	(1,'e51bc2ca1f3e2ee4a9d62e1109787d23','2013-09-19 03:17:35'),
	(1,'ba28cbb20a2f0fd930557f43e32530fe','2013-09-19 04:56:06'),
	(1,'a648865b6d0b4f55b2696688156def23','2013-09-19 04:57:05');



# Dump of table users
# ------------------------------------------------------------


CREATE TABLE `users` (
  `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL DEFAULT '',
  `password` binary(128) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `email` varchar(255) DEFAULT '',
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `post_code` mediumint(5) unsigned DEFAULT NULL,
  `country_id` smallint(3) unsigned DEFAULT NULL,
  `gender` enum('male','female') DEFAULT NULL,
  `about` text,
  `timezone` char(4) NOT NULL DEFAULT 'UTC',
  `profile_img` varchar(255) DEFAULT NULL,
  `lat` decimal(7,4) DEFAULT NULL,
  `lng` decimal(7,4) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_logged_on` timestamp NULL DEFAULT NULL,
  `role` enum('admin','user') NOT NULL DEFAULT 'user',
  `trusted` tinyint(1) DEFAULT '0',
  `active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `users` (`user_id`, `username`, `password`, `email`, `first_name`, `last_name`, `city`, `post_code`, `country_id`, `gender`, `about`, `timezone`, `profile_img`, `lat`, `lng`, `created_on`, `last_logged_on`, `role`, `active`)
VALUES
	(1,'devismaster',X'3664306362643635376263613262393838373330636534646536366433643337333039666239646661666539363933633465346464336161396331323439343666303237653863613538363331386164613039353563663234376162636637643036613530623238613439373839396161373763366637666663623432626132','devismaster@gmail.com','Georgi','Arabadjiev','Sofia',1582,6,'male','About me','UP2','a5518c74f76e2123b1bf875a968c6de7.jpg',42.6259,23.3769,'2012-01-31 22:28:12','2014-02-11 22:29:13','admin',1),
	(2,'admin',X'6463663834316238353032316665383736313765653832386436373333303539313834363035313861633565653865396331373666303035393937303366373833653434333039663663646633306561663233313865363835653463303665633039646666343030313937346265386164356463363266373131376365356164','admin@cunet.com','Administrator','Admin','Sofia',1732,6,'male','About me','UTC','ba59fdf03f0af746f9addb8a4d8e8574.jpg',42.6542,23.3954,'2012-01-31 22:30:04','2013-10-30 01:22:34','user',1),
	(3,'Taylor',X'6364646134363861353263633962316133643634343833313339663434356335626166643433623135613761346362363263653766623236613664393735336634393266363438373830353861333736633334313630353034396531663761656234333731383636323637366638653738663433313566373837386664666430','','Teegan','Thompson','Sofia',NULL,6,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55','2012-10-31 14:13:02','user',1),
	(4,'Belle',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Unity','Kline',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(5,'Carolyn',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Emmanuel','Mullins',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',0),
	(6,'Vladimir',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Lucy','Dillard',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(7,'Kellie',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Valentine','Bruce',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(8,'Xena',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Ciara','Peck',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(9,'Ulric',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Charles','Huffman',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(10,'Mechelle',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Rhonda','Nieves',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(11,'Clinton',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Yen','Webb',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(12,'Damian',X'6466336634366632636364623161346365643263323633353463646664636566666665313632613232393737343537323663343530656134366338633637613839363963633062626661346238393236373436333261356665396233613263613133363133623332356437653938356364373961363062653962643961313764','','Ella','Whitfield',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55','2013-10-22 21:05:25','user',1),
	(13,'Serina',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Cheryl','Stanton',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(14,'Pamela',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Eliana','Rollins',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(15,'Davis',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Jade','Boyer',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(16,'Teagan',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Heidi','Palmer',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(17,'Cailin',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Vaughan','Mills',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(18,'Deanna',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Tatyana','Sears',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(19,'Xandra',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Rudyard','Anderson',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(20,'Ignatius',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Jerome','Santos',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(21,'Basil',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Myles','Rosales',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(22,'Amela',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Unity','Boone',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(23,'Adara',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Quamar','Farley',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(24,'Stuart',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Justine','Martinez',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(25,'Melyssa',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Philip','Ashley',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(26,'Piper',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','May','Hewitt',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(27,'Jael',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Rhiannon','Gomez',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(28,'Ayanna',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Amy','Douglas',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(29,'Trevor',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Aileen','Berry',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(30,'Vance',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Irene','Lowery',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(31,'Paul',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Keely','Delacruz',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(32,'Kenneth',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Lara','Casey',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(33,'Madonna',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Leandra','Vang',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(34,'Teagan1',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Jamal','Hines',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(35,'Jason',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Brianna','Clay',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(36,'Jolene',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Sybill','Sexton',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(37,'Thor',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Galena','Mitchell',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(38,'Delilah',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Igor','Oconnor',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(39,'Justina',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Gage','Pacheco',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(40,'Lani',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Dexter','Cameron',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(41,'Brendan',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Adria','Nichols',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(42,'Germane',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Kimberly','Dillard',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(43,'Kadeem',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Cedric','Schmidt',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(44,'Iliana',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Aurelia','Ferguson',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(45,'Shannon',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Kiara','Henderson',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(46,'Alec',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Allen','Finley',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(47,'Shoshana',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Vivien','Middleton',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(48,'Joel',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Christian','Bass',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(49,'Caryn',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Neville','Hansen',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(50,'Sonia',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Dorothy','Morton',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(51,'Abbot',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Hedley','Navarro',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(52,'Meredith',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Paul','Crosby',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(53,'Tiger',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Debra','Harding',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(54,'Ora',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Moana','Hyde',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(55,'Adria',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Keane','Allen',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(56,'Ian',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Kimberly','Bartlett',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(57,'Nichole',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Hollee','Woods',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(58,'Francis',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Tanya','Cohen',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(59,'Hamish',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Arden','Sweeney',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(60,'Price',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Valentine','Chaney',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(61,'Honorato',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Vance','Malone',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(62,'Ashely',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Libby','Fox',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(63,'Eagan',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Justina','Maldonado',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(64,'Meredith 1',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Damon','Delgado',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(65,'Bruce',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Daryl','Reynolds',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(66,'Caesar',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Melodie','Frederick',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(67,'Chase',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Guinevere','Perkins',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(68,'Celeste',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Nelle','Mejia',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(69,'Graiden',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Audra','Norris',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(70,'Dean',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Scarlett','Mckinney',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(71,'Hu',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','David','Lester',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(72,'Xerxes',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Felicia','Byrd',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(73,'Driscoll',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Liberty','Montoya',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(74,'Sawyer',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Diana','Stark',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(75,'Asher',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Helen','Bullock',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(76,'Sara',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Kenyon','Roberts',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(77,'Caesar1',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Oprah','Carrillo',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(78,'Skyler',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Theodore','Simon',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(79,'Jenna',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Dillon','Vaughn',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(80,'Callum',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Kaseem','Reilly',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(81,'Philip',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Venus','Aguirre',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(82,'Edan',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Thane','Galloway',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(83,'Hoyt',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Chantale','Vasquez',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(84,'Amethyst',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Aimee','Cole',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(85,'Tyrone',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Barbara','Mcconnell',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(86,'Aline',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Ulric','Burton',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(87,'Ronan',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Arden','Small',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(88,'Wyatt',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Uriel','Reilly',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(89,'Risa',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Henry','Ayers',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(90,'Oren',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Kieran','Lowe',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(91,'Jolie',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Erasmus','Johnson',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-08-29 16:24:51',NULL,'user',1),
	(92,'Josephine',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Leila','Hansen',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(93,'Rudyard',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','acqueline','Martinez',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(94,'Paloma',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Amethyst','Mcclure',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(95,'Ursula',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Wyoming','Noble',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(96,'Kamal',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Zoe','Mcdaniel',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(97,'Mannix',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Robert','Moss',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(98,'John',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Quon','Maynard',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(99,'Davis1',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Lavinia','Wilkinson',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(100,'Dorothy',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Evelyn','Larson',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(101,'Russell',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Rhoda','Schneider',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(102,'Emily',X'6336373866626233393264623933626233356465346436623136653932356139303965656432613162613233656236623533646364356266333566666437393837663365343363353366333632653732353238363439653661316533623466353837363362653065353839313966656431386162633637306630353565373732','','Emerald','Henry',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-02-12 21:27:55',NULL,'user',1),
	(103,'georgi',X'3564633062333564393166663832313537633862613964666331306365323336646561366433656461376135353834333264363565333833383139613663313530316230303066626433333139643835333466623330643834343138323832393332373630646235643261393530373935346139613539303233366662326132','georgi@arabadjiev.com','Georgi','Georgiev','Sofia',1000,6,'male','','UTC',NULL,42.6845,23.3350,'2012-03-18 19:17:47','2013-05-30 02:24:18','user',1),
	(104,'georgi1',X'3462333833663865353364336561323238356430666162633633303732376563666535323466316665346461623335326366653334626561633932643765363565656438623165326339336638313733346138343634666130363733643732396666613037646662636263663831623337303333316238623738323565346433','georgi1@arabadjiev.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-03-18 19:18:20',NULL,'user',1),
	(105,'test',X'3764356661633337663035643533363036386633333562623964333136353161313431393031663662323033646634383263396662306666663630393835373433663762303138333766363335666632393666336538383034323166346239633831393633623962646564333438376131666633663735363539356464316435','test@test.com','Test','Testov',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-07-17 12:29:21','2013-04-16 10:04:34','user',1),
	(106,'test1',X'3064393534636234386131366232626636636431343932623330666366313264316337393866636331393665666164646561633337333732616666323436373933363332373664373933336262376635633066626338376132643964303138303137353165626464373061653536396339616465633833396236336363663463','test1@test.com','Test','Testov',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-08-09 16:14:01',NULL,'user',1),
	(107,'testuser',X'3439316138666134316265333134336665616538663331343934646234333236316563623930636133663431356661306163653162633338613961323765373134336638663336383434356436396132616164313330366435636331363164623630633762363462643261663333636364626164393465613134636264333738','test@arabadjiev.com','Test','Test',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-09-11 23:17:19',NULL,'user',1),
	(108,'test2',X'3762346230353464626630343539636461616366343566353062386665336639353130306431323937306639343636376363303564313164383835356165643631316230323138353632366364356566366664646535653061393365336439376161323833623439663162643237373566643631303361653038643366383530','test2@test.com','Test','Testov',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-09-11 23:19:56',NULL,'user',1),
	(109,'to_delete',X'3235306265616366306362393062386533306530623563633138343337353262393136646437326631366232613838656234663739356535623434336465393961373261383039623431623066623839633161653637663834626335313338313563626239333365356266376664303266653838656238343761623237636330','to_delete@arabadjiev.com','Todelete','Todelete',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2012-09-20 18:55:09','2012-09-20 19:34:10','user',0),
	(110,'test3',X'3638616661326136646334613136636333616336636436393263366239376663333961663834336665643862333739303736653862313230383232373735383664633133663632646234663261363731373564386233326666393963303131323033663239656334613764346266386136356638626336393934643865353736','test3@test.com','Test','Test',NULL,NULL,NULL,NULL,NULL,'UTC',NULL,NULL,NULL,'2013-10-22 21:53:44','2013-10-30 01:14:21','user',1);



# Dump of table users_ban_reasons
# ------------------------------------------------------------


CREATE TABLE `users_ban_reasons` (
  `user_id_fk` int(11) unsigned NOT NULL,
  `reason` varchar(255) NOT NULL DEFAULT '',
  `banned_by` int(11) unsigned NOT NULL,
  `banned_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table users_failed_logins
# ------------------------------------------------------------


CREATE TABLE `users_failed_logins` (
  `user_id` int(11) unsigned DEFAULT NULL,
  `ip_address` varbinary(16) NOT NULL DEFAULT '',
  `login_attempts` smallint(2) unsigned NOT NULL DEFAULT '1',
  `last_login_attempt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `users_failed_logins` (`user_id`, `ip_address`, `login_attempts`, `last_login_attempt`)
VALUES
	(1,X'7F000001',0,'2014-02-11 22:29:13'),
	(103,X'7F000001',3,'2013-10-30 01:22:28'),
	(2,X'7F000001',0,'2013-09-29 21:17:23'),
	(12,X'7F000001',0,'2013-10-22 21:04:25'),
	(110,X'7F000001',0,'2013-10-30 01:14:21');




