-- https://www.phpmyadmin.net/
--
-- Servidor: db5000310060.hosting-data.io
-- Tiempo de generación: 16-06-2020 a las 18:52:36
-- Versión del servidor: 5.7.28-log
-- Versión de PHP: 7.0.33-0+deb9u7

START TRANSACTION;



--
-- Base de datos: `bolsa_empleo`
--

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

--
-- Estructura de tabla para la tabla `applications`
--

CREATE TABLE `applications` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_job` int(11) NOT NULL,
  `date` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `offdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `category` varchar(250) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Volcado de datos para la tabla `categories`
--

INSERT INTO `categories` (`id`, `category`) VALUES
(1, 'Administrativos'),
(2, 'Biología'),
(3, 'Comunicaciones'),
(4, 'Contabilidad'),
(5, 'Construcción'),
(6, 'Diseño'),
(7, 'Derecho y Leyes'),
(8, 'Educación'),
(9, 'Ingeniería'),
(10, 'Logística, Transportación y Distribución '),
(11, 'Manufactura, Producción y Operación '),
(12, 'Mercadotecnia y Publicidad'),
(13, 'Recursos Humanos '),
(14, 'Salud y Belleza'),
(15, 'Sector Salud'),
(16, 'Tecnologías de la Información / Sistemas'),
(17, 'Turismo'),
(18, 'Gastronomía'),
(19, 'Ventas'),
(20, 'Relaciones Públicas'),
(21, 'Chofer');

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

--
-- Estructura de tabla para la tabla `company_category`
--

CREATE TABLE `company_category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(250) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Volcado de datos para la tabla `company_category`
--

INSERT INTO `company_category` (`id`, `category_name`) VALUES
(1, 'Servicios'),
(2, 'Alimentos'),
(3, 'Producción'),
(4, 'Construcción');

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

--
-- Estructura de tabla para la tabla `company_data`
--

CREATE TABLE `company_data` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_category` int(11) NOT NULL,
  `branch` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `state` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `location` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `phone` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `address1` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `address2` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `description` varchar(2500) COLLATE utf8_spanish_ci NOT NULL,
  `social_fb` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_tw` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_ln` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_gplus` varchar(250) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `employee_data`
--

CREATE TABLE `employee_data` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `phone` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `state` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `location` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `address` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `date_birth` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `sex` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
  `marital` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `education` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `cv` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_fb` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_tw` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_ln` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `social_gplus` varchar(250) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `employee_professional`
--

CREATE TABLE `employee_professional` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `title` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `period` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `comment` varchar(1500) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `employee_skills`
--

CREATE TABLE `employee_skills` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `skill` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `porcent` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `jobs`
--

CREATE TABLE `jobs` (
  `id` int(11) NOT NULL,
  `title` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `id_category` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `salary` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `description` mediumtext COLLATE utf8_spanish_ci NOT NULL,
  `requirements` mediumtext COLLATE utf8_spanish_ci NOT NULL,
  `date` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `offdate` date NOT NULL,
  `status` int(11) NOT NULL,
  `finalized` int(20) NOT NULL,
  `data_graf` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `userdata`
--

CREATE TABLE `userdata` (
  `id` int(11) NOT NULL,
  `id_user` int(250) NOT NULL,
  `name` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `lastname` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `img` varchar(250) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Volcado de datos para la tabla `userdata`
--

INSERT INTO `userdata` (`id`, `id_user`, `name`, `lastname`, `img`) VALUES
(1, 1, 'Apkee', 'Apkee', '0'),
(3, 3, 'Desarrollo ', 'Económico', '0'),
(8, 9, 'Admin', 'Admin', '0');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `company_category`
--
ALTER TABLE `company_category`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `company_data`
--
ALTER TABLE `company_data`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `employee_data`
--
ALTER TABLE `employee_data`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `employee_professional`
--
ALTER TABLE `employee_professional`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `employee_skills`
--
ALTER TABLE `employee_skills`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `userdata`
--
ALTER TABLE `userdata`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `applications`
--
ALTER TABLE `applications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT de la tabla `company_category`
--
ALTER TABLE `company_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `company_data`
--
ALTER TABLE `company_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `employee_data`
--
ALTER TABLE `employee_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `employee_professional`
--
ALTER TABLE `employee_professional`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT de la tabla `employee_skills`
--
ALTER TABLE `employee_skills`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT de la tabla `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT de la tabla `userdata`
--
ALTER TABLE `userdata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

