-- http://www.phpmyadmin.net
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 07-10-2019 a las 20:41:04
-- Versión del servidor: 5.6.26
-- Versión de PHP: 5.5.28




--
-- Base de datos: `anaseguros`
--

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

--
-- Estructura de tabla para la tabla `as_landingpage`
--

CREATE TABLE IF NOT EXISTS `as_landingpage` (
  `as_landingpage_id` int(10) unsigned NOT NULL,
  `as_landingpage_url` varchar(256) NOT NULL,
  `as_landingpage_titulo` varchar(256) NOT NULL,
  `as_landingpage_estatus` tinyint(1) unsigned NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='Landing Pages';

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

INSERT INTO `as_landingpage` (`as_landingpage_id`, `as_landingpage_url`, `as_landingpage_titulo`, `as_landingpage_estatus`) VALUES
(1, 'parabrisas-promo-descuentos.html', 'Parabrisas Promo', 1),
(2, 'mi-nueva-promo.html', 'Titulo de mi nueva promo', 1),
(3, 'mi-nueva-promo.html', 'Titulo de mi nueva promo', 1),
(4, 'sdfg', 'dsg', 0),
(5, 'sdf', 'sdf', 0),
(6, 'sdf', 'sdf', 0),
(7, 'dfsgdh', 'kuykyuk', 0),
(8, 'sfsdf', 'gertetertet', 0),
(9, 'sfsdf', 'gertetertetSDF', 0),
(10, 'khjkhjk', 'hjkhjkhk', 0),
(11, 'qeqwe', 'qwe', 0),
(12, 'piopiopi', 'iopiopi', 0),
(13, 'piopiopi', 'iopiopi', 0),
(14, '234234', '243', 0),
(15, 'gjghj', 'gfhj', 0),
(16, 'gjghj', 'gfhj', 0),
(17, 'sfsf', 'sdf', 0),
(18, '7567', '57', 0),
(19, 'adasdasdasd', 'asdasdasd', 0),
(20, 'adasdasdasd', 'asdasdasd', 0),
(21, 'fghfgh', 'fgh', 0);

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

--
-- Estructura de tabla para la tabla `va_permissions`
--

CREATE TABLE IF NOT EXISTS `va_permissions` (
  `va_permissions_id` int(11) unsigned NOT NULL,
  `va_roles_id` int(11) unsigned NOT NULL,
  `va_rules_id` int(11) unsigned NOT NULL,
  `va_permissions_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `va_permissions_status` tinyint(1) unsigned NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `va_permissions` (`va_permissions_id`, `va_roles_id`, `va_rules_id`, `va_permissions_updated`, `va_permissions_status`) VALUES
(1, 1, 1, '2017-07-26 20:24:43', 1);

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

--
-- Estructura de tabla para la tabla `va_roles`
--

CREATE TABLE IF NOT EXISTS `va_roles` (
  `va_roles_id` int(11) unsigned NOT NULL,
  `va_roles_name` varchar(100) NOT NULL,
  `va_roles_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `va_roles_status` tinyint(1) unsigned NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

INSERT INTO `va_roles` (`va_roles_id`, `va_roles_name`, `va_roles_updated`, `va_roles_status`) VALUES
(1, 'Super Admin', '2017-07-26 20:24:31', 1),
(2, 'Florista', '2017-07-27 23:08:46', 1);

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

--
-- Estructura de tabla para la tabla `va_rules`
--

CREATE TABLE IF NOT EXISTS `va_rules` (
  `va_rules_id` int(11) unsigned NOT NULL,
  `va_rules_str` varchar(150) NOT NULL,
  `va_rules_name` varchar(150) DEFAULT NULL,
  `va_rules_status` tinyint(1) unsigned NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

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

INSERT INTO `va_rules` (`va_rules_id`, `va_rules_str`, `va_rules_name`, `va_rules_status`) VALUES
(1, 'todo', 'Todo', 1),
(2, 'nada', 'Nada', 1),
(3, 'web_orders_production2', 'Producción', 1),
(4, 'web_dispatch_index', 'Despachador', 1),
(5, 'web_delivery_report', 'Reportes', 1),
(6, 'web_logisticsrate_index', 'Tarifas', 1),
(7, 'web_permissions_user', 'Usuarios', 1),
(8, 'web_permissions_role', 'Roles', 1);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `as_landingpage`
--
ALTER TABLE `as_landingpage`
  ADD PRIMARY KEY (`as_landingpage_id`);

--
-- Indices de la tabla `va_permissions`
--
ALTER TABLE `va_permissions`
  ADD PRIMARY KEY (`va_permissions_id`),
  ADD KEY `nj_roles_id_idx` (`va_roles_id`),
  ADD KEY `nj_rules_id_idx` (`va_rules_id`);

--
-- Indices de la tabla `va_roles`
--
ALTER TABLE `va_roles`
  ADD PRIMARY KEY (`va_roles_id`);

--
-- Indices de la tabla `va_rules`
--
ALTER TABLE `va_rules`
  ADD PRIMARY KEY (`va_rules_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `as_landingpage`
--
ALTER TABLE `as_landingpage`
  MODIFY `as_landingpage_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT de la tabla `va_permissions`
--
ALTER TABLE `va_permissions`
  MODIFY `va_permissions_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `va_roles`
--
ALTER TABLE `va_roles`
  MODIFY `va_roles_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `va_rules`
--
ALTER TABLE `va_rules`
  MODIFY `va_rules_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
