/*
Navicat MySQL Data Transfer

Source Server         : SAB conecction
Source Server Version : 50626
Source Host           : 192.168.0.101:3306
Source Database       : SAX_DB

Target Server Type    : MYSQL
Target Server Version : 50199
File Encoding         : 65001

Date: 2015-10-06 10:45:51
*/

SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE IF NOT EXISTS `SAX_DB` DEFAULT CHARACTER SET utf8;
USE `SAX_DB`;
-- ----------------------------
-- Table structure for SAX_HEADER
-- ----------------------------
DROP TABLE IF EXISTS `SAX_HEADER`;
CREATE TABLE `SAX_HEADER` (
`ID`  int(11) NOT NULL AUTO_INCREMENT ,
`onoff`  int(11) NULL DEFAULT 1 ,
`Nombre_Empresa`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NULL DEFAULT NULL ,
`tel1`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`tel2`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`email_contact`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
PRIMARY KEY (`ID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_spanish_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of SAX_HEADER
-- ----------------------------
BEGIN;
INSERT INTO `SAX_HEADER` VALUES ('1', '1', 'ALQUIMAQ', '65894172', '04242047393', 'reinaldo@daoutel.net');
COMMIT;

-- ----------------------------
-- Table structure for SAX_MENU
-- ----------------------------
DROP TABLE IF EXISTS `SAX_MENU`;
CREATE TABLE `SAX_MENU` (
`ID`  int(11) NOT NULL AUTO_INCREMENT ,
`onoff`  int(11) NULL DEFAULT 1 ,
`Nombre_Menu`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NULL DEFAULT NULL ,
`fa_icon`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`Ruta`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NULL DEFAULT NULL ,
PRIMARY KEY (`ID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_spanish_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of SAX_MENU
-- ----------------------------
BEGIN;
INSERT INTO `SAX_MENU` VALUES ('1', '1', 'Setup', ' fa-cog', 'config'), ('2', '1', 'Inventario', ' fa-list-ul', 'modules/inventory/inventario');
COMMIT;

-- ----------------------------
-- Table structure for SAX_SMTP
-- ----------------------------
DROP TABLE IF EXISTS `SAX_SMTP`;
CREATE TABLE `SAX_SMTP` (
`ID`  int(11) NOT NULL AUTO_INCREMENT ,
`smtp_server`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`port`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`onoff`  int(11) NOT NULL DEFAULT 1 ,
`user_smtp`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`pass_smtp`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
PRIMARY KEY (`ID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_spanish_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of SAX_SMTP
-- ----------------------------
BEGIN;
INSERT INTO `SAX_SMTP` VALUES ('1', '', '25', '1', '', '');
COMMIT;

-- ----------------------------
-- Table structure for SAX_SUBMENU_PROCESOS
-- ----------------------------
DROP TABLE IF EXISTS `SAX_SUBMENU_PROCESOS`;
CREATE TABLE `SAX_SUBMENU_PROCESOS` (
`ID`  int(11) NOT NULL AUTO_INCREMENT ,
`onoff`  int(11) NULL DEFAULT 1 ,
`Nombre_Proceso`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NULL DEFAULT NULL ,
`fa_icon`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NULL DEFAULT NULL ,
`Menu_ID`  int(11) NOT NULL ,
PRIMARY KEY (`ID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_spanish_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of SAX_SUBMENU_PROCESOS
-- ----------------------------
BEGIN;
INSERT INTO `SAX_SUBMENU_PROCESOS` VALUES ('1', '1', 'Reservas', null, '0'), ('2', '1', 'Entrada de materiales', null, '0'), ('3', '1', 'Salida de Materiales', null, '0'), ('4', '1', 'Reportes', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for SAX_USER
-- ----------------------------
DROP TABLE IF EXISTS `SAX_USER`;
CREATE TABLE `SAX_USER` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`lastname`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`pass`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`onoff`  int(11) NOT NULL DEFAULT 1 ,
`role`  varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_spanish_ci
AUTO_INCREMENT=28

;

-- ----------------------------
-- Records of SAX_USER
-- ----------------------------
BEGIN;
INSERT INTO `SAX_USER` VALUES ('25', 'admin', 'admin', 'info@daoutel.net', 'admin', '1', 'admin');
COMMIT;

-- ----------------------------
-- Auto increment value for SAX_HEADER
-- ----------------------------
ALTER TABLE `SAX_HEADER` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for SAX_MENU
-- ----------------------------
ALTER TABLE `SAX_MENU` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for SAX_SMTP
-- ----------------------------
ALTER TABLE `SAX_SMTP` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for SAX_SUBMENU_PROCESOS
-- ----------------------------
ALTER TABLE `SAX_SUBMENU_PROCESOS` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for SAX_USER
-- ----------------------------
ALTER TABLE `SAX_USER` AUTO_INCREMENT=28;