-- Servidor: localhost -- Tiempo de generación: 01-11-2015 a las 18:25:43 -- Versión del servidor: 5.5.46-0ubuntu0.14.04.2 -- Versión de PHP: 5.5.9-1ubuntu4.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8 */;

CREATE TABLE IF NOT EXISTS categoria ( id int(11) NOT NULL AUTO_INCREMENT, categoria varchar(150) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS circunferencias ( id int(11) NOT NULL AUTO_INCREMENT, left varchar(10) COLLATE utf8_unicode_ci NOT NULL, right text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS especie ( id int(11) NOT NULL AUTO_INCREMENT, especie varchar(150) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS ide ( id int(11) NOT NULL AUTO_INCREMENT, especie_id int(11) NOT NULL, cazador_id int(11) NOT NULL, creado timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS longitudvelasapiticas ( id int(11) NOT NULL AUTO_INCREMENT, left text COLLATE utf8_unicode_ci NOT NULL, right text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS longitudvelastipicas ( id int(11) NOT NULL AUTO_INCREMENT, left text COLLATE utf8_unicode_ci NOT NULL, right text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS lugarcaza ( id int(11) NOT NULL AUTO_INCREMENT, rancho varchar(200) COLLATE utf8_unicode_ci NOT NULL, municipio varchar(100) COLLATE utf8_unicode_ci NOT NULL, estado varchar(100) COLLATE utf8_unicode_ci NOT NULL, pais varchar(100) COLLATE utf8_unicode_ci NOT NULL, fecha_casa date NOT NULL, fecha_registro date NOT NULL, cerco varchar(50) COLLATE utf8_unicode_ci NOT NULL, metodo varchar(50) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS mainbeanlargo ( id int(11) NOT NULL AUTO_INCREMENT, left text COLLATE utf8_unicode_ci NOT NULL, right text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS socio ( id int(11) NOT NULL AUTO_INCREMENT, cazador varchar(100) COLLATE utf8_unicode_ci NOT NULL, nombre_socio varchar(200) COLLATE utf8_unicode_ci NOT NULL, num_socio varchar(200) COLLATE utf8_unicode_ci NOT NULL, lic_caza varchar(200) COLLATE utf8_unicode_ci NOT NULL, membresia varchar(150) COLLATE utf8_unicode_ci NOT NULL, num_cintillo varchar(150) COLLATE utf8_unicode_ci NOT NULL, correo varchar(200) COLLATE utf8_unicode_ci NOT NULL, edad int(11) NOT NULL, sexo enum('m','f') COLLATE utf8_unicode_ci NOT NULL, tlf varchar(100) COLLATE utf8_unicode_ci NOT NULL, creado timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;