 -- Estructura de tabla para la tabla `events`
 --
 
-CREATE TABLE `events` (
-  `id` int(11) NOT NULL auto_increment,
-  `title` varchar(60) collate utf8_unicode_ci NOT NULL,
-  `description` varchar(255) collate utf8_unicode_ci NOT NULL,
-  `event_text` text collate utf8_unicode_ci NOT NULL,
-  `creation_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
+CREATE TABLE IF NOT EXISTS `events` (
+`id` int(11) NOT NULL,
+  `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
+  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+  `event_text` text COLLATE utf8_unicode_ci NOT NULL,
+  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `init_date` datetime NOT NULL,
-  `end_date` datetime default NULL,
-  `visits` int(11) NOT NULL default '1',
-  `address` varchar(60) collate utf8_unicode_ci default NULL,
-  `city` int(11) default NULL,
-  `province` int(11) default NULL,
-  `web` varchar(255) collate utf8_unicode_ci default NULL,
-  `email` varchar(255) collate utf8_unicode_ci default NULL,
-  `phone` varchar(12) collate utf8_unicode_ci default NULL,
-  `coordenates` varchar(40) collate utf8_unicode_ci default NULL,
-  `platform` varchar(20) collate utf8_unicode_ci default NULL,
-  `creator` int(11) default NULL,
-  PRIMARY KEY  (`id`),
-  KEY `creator` (`creator`),
-  KEY `city` (`city`),
-  KEY `province` (`province`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+  `end_date` datetime DEFAULT NULL,
+  `visits` int(11) NOT NULL DEFAULT '1',
+  `address` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
+  `city` int(11) DEFAULT NULL,
+  `province` int(11) DEFAULT NULL,
+  `web` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+  `phone` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
+  `coordenates` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
+  `platform` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
+  `creator` int(11) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 -- --------------------------------------------------------
 

-- Estructura de tabla para la tabla `ip_bloq`
--

CREATE TABLE `ip_bloq` (
  `banner` varchar(9) collate utf8_unicode_ci NOT NULL default '',
  `ip` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  `init_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `end_date` datetime default NULL,
  `reason` varchar(200) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`banner`,`ip`,`init_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- Estructura de tabla para la tabla `labels_votes`
--

CREATE TABLE IF NOT EXISTS `labels_votes` (
  `proposal` int(11) NOT NULL DEFAULT '0',
  `label` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sentence` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `n_label` tinyint(4) NOT NULL DEFAULT '0',
  `person` varchar(9) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `vote_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `vote_value` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------
