FEFQpMqj

1-- Adminer 3.5.0 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `gew_statistics_activity`;
9CREATE TABLE `gew_statistics_activity` (
10  `aid` int(11) NOT NULL,
11  `nid` int(11) NOT NULL,
12  `title` varchar(255) COLLATE utf8_bin NOT NULL,
13  `description` longtext COLLATE utf8_bin,
14  `phone` blob,
15  `participantsCount` int(11) DEFAULT NULL,
16  `urlCw` varchar(255) COLLATE utf8_bin DEFAULT NULL,
17  `url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
18  `dateStart` int(11) DEFAULT NULL,
19  `dateEnd` int(11) DEFAULT NULL,
20  `time` varchar(255) COLLATE utf8_bin DEFAULT NULL,
21  `town` varchar(255) COLLATE utf8_bin DEFAULT NULL,
22  `province` varchar(255) COLLATE utf8_bin DEFAULT NULL,
23  `country` varchar(255) COLLATE utf8_bin DEFAULT NULL,
24  `profileLink` varchar(255) COLLATE utf8_bin DEFAULT NULL,
25  `organization` varchar(255) COLLATE utf8_bin DEFAULT NULL,
26  `gewYear` int(11) NOT NULL,
27  `featured` int(11) DEFAULT NULL,
28  PRIMARY KEY (`aid`,`nid`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
30
31
32DROP TABLE IF EXISTS `gew_statistics_country_queue`;
33CREATE TABLE `gew_statistics_country_queue` (
34  `order_number` int(11) NOT NULL,
35  `entity_id` int(11) NOT NULL,
36  `time_successful` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
37  `time_last_try` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
39
40
41DROP TABLE IF EXISTS `gew_statistics_partner`;
42CREATE TABLE `gew_statistics_partner` (
43  `pid` int(11) NOT NULL,
44  `nid` int(11) NOT NULL,
45  `name` varchar(255) COLLATE utf8_bin NOT NULL,
46  `phone` blob NOT NULL,
47  `email` varchar(255) COLLATE utf8_bin NOT NULL,
48  `url` varchar(255) COLLATE utf8_bin NOT NULL,
49  `activities_count` int(11) NOT NULL,
50  PRIMARY KEY (`pid`,`nid`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
52
53
54-- 2012-10-11 14:47:28