# Host     : localhost
# Port     : 3306
# Database : thoga


SET FOREIGN_KEY_CHECKS=0;

DROP DATABASE IF EXISTS `thoga`;

CREATE DATABASE `thoga`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `thoga`;

#
# Structure for the `tbl__menu` table : 
#

DROP TABLE IF EXISTS `tbl__menu`;

CREATE TABLE `tbl__menu` (
  `idMenus` int(11) NOT NULL auto_increment,
  `menu` varchar(50) default NULL,
  `opcion` varchar(50) default NULL,
  `liga` varchar(50) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  UNIQUE KEY `idMenus` (`idMenus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=201 AVG_ROW_LENGTH=162 PACK_KEYS=0 ROW_FORMAT=FIXED;

#
# Data for the `tbl__menu` table  (LIMIT 0,500)
#

INSERT INTO `tbl__menu` (`idMenus`, `menu`, `opcion`, `liga`, `stamp`) VALUES 
  (1,'Barra','Herramientas','Cuentas de Usuarios','2005-08-09 16:55:02'),
  (2,'Barra','Archivo','Grupos','2005-08-09 16:55:02'),
  (3,'Barra','Archivo','Cambio de Grupo','2005-08-09 16:55:02');

COMMIT;

#
# Structure for the `tbl__pagos` table : 
#

DROP TABLE IF EXISTS `tbl__pagos`;

CREATE TABLE `tbl__pagos` (
  `Idpago` int(11) NOT NULL auto_increment,
  `Descripcion` char(50) NOT NULL,
  `IncluirEnCorte` tinyint(4) NOT NULL default '0',
  `IncluirEnEgresos` tinyint(4) NOT NULL default '0',
  `DefaultVentas` tinyint(4) NOT NULL default '0',
  `DefaultCompras` tinyint(4) NOT NULL default '0',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`Idpago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4096 AVG_ROW_LENGTH=4096 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 10240 kB; InnoDB free: 10240 kB';

#
# Data for the `tbl__pagos` table  (LIMIT 0,500)
#

INSERT INTO `tbl__pagos` (`Idpago`, `Descripcion`, `IncluirEnCorte`, `IncluirEnEgresos`, `DefaultVentas`, `DefaultCompras`, `stamp`) VALUES 
  (1,'CHEQUE',-1,-1,0,-1,'2005-09-23 15:03:58'),
  (2,'CONTADO',-1,-1,-1,0,'2005-09-23 15:03:58'),
  (3,'TARJETA',-1,-1,0,0,'2005-09-23 15:03:59'),
  (4,'CREDITO',0,0,0,0,'2005-09-23 15:04:00');

COMMIT;

#
# Structure for the `tbl__seguridadusuarios` table : 
#

DROP TABLE IF EXISTS `tbl__seguridadusuarios`;

CREATE TABLE `tbl__seguridadusuarios` (
  `IDUsuario` int(11) NOT NULL auto_increment,
  `UserNombre` varchar(50) default NULL,
  `UserLogin` varchar(50) default NULL,
  `UserKey` varchar(50) default NULL,
  `UserNivel` tinyint(3) default '0',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `IDUsuario` (`IDUsuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl__seguridadusuarios` table  (LIMIT 0,500)
#

INSERT INTO `tbl__seguridadusuarios` (`IDUsuario`, `UserNombre`, `UserLogin`, `UserKey`, `UserNivel`, `stamp`) VALUES 
  (22,'Administrador','admin','Š�–’—',1,'2005-08-02 11:10:51');

COMMIT;

#
# Structure for the `tbl__tiposclientes` table : 
#

DROP TABLE IF EXISTS `tbl__tiposclientes`;

CREATE TABLE `tbl__tiposclientes` (
  `idTipoCliente` int(11) NOT NULL auto_increment,
  `Tipo` tinyint(3) NOT NULL default '1',
  `CliDescripcion` varchar(70) NOT NULL default 'SIN DESCRIPCION',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`Tipo`),
  UNIQUE KEY `idTipoCliente` (`idTipoCliente`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl__tiposclientes` table  (LIMIT 0,500)
#

INSERT INTO `tbl__tiposclientes` (`idTipoCliente`, `Tipo`, `CliDescripcion`, `stamp`) VALUES 
  (1,0,'PUBLICO','2005-08-02 17:52:07'),
  (2,1,'FRECUENTE','2005-08-02 17:54:00'),
  (3,2,'MAYORISTA','2005-08-02 17:53:36');

COMMIT;

#
# Structure for the `tbl__usuarioaccesos` table : 
#

DROP TABLE IF EXISTS `tbl__usuarioaccesos`;

CREATE TABLE `tbl__usuarioaccesos` (
  `LoginID` tinyint(3) default '0',
  `LoginTimeIN` datetime default NULL,
  `LoginAction` text,
  `idAccesos` int(11) NOT NULL auto_increment,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `idAccesos` (`idAccesos`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl__usuarioaccesos` table  (LIMIT 0,500)
#

INSERT INTO `tbl__usuarioaccesos` (`LoginID`, `LoginTimeIN`, `LoginAction`, `idAccesos`, `stamp`) VALUES 
  (-1,'2004-03-25 20:02:43','INICIO DEL SISTEMA',2684,'2005-08-02 11:12:32'),
  (22,'2005-10-04 14:28:20','Entrada  desde la Computadora LAPTOP como usuario Tony',2685,'2005-10-04 14:28:20'),
  (22,'2005-10-04 14:28:46','Salida desde la Computadora LAPTOP como usuario Tony',2686,'2005-10-04 14:28:46'),
  (22,'2005-10-04 14:37:50','Entrada  desde la Computadora LAPTOP como usuario Tony',2687,'2005-10-04 14:37:50'),
  (22,'2005-10-04 14:38:39','Salida desde la Computadora LAPTOP como usuario Tony',2688,'2005-10-04 14:38:39'),
  (22,'2005-10-04 16:57:54','Entrada Frm_INICIO desde la Computadora LAPTOP como usuario Tony',2689,'2005-10-04 16:57:54'),
  (22,'2005-10-04 17:07:49','Salida desde la Computadora LAPTOP como usuario Tony',2690,'2005-10-04 17:07:49'),
  (22,'2005-10-04 18:47:25','Presto su clave de supervisorsupervisorFrm_Empleados desde la Computadora LAPTOP como usuario Tony',2691,'2005-10-04 18:47:25'),
  (22,'2005-10-04 18:48:29','Entrada Frm_INICIO desde la Computadora LAPTOP como usuario Tony',2692,'2005-10-04 18:48:29'),
  (22,'2005-10-04 19:00:23','Salida desde la Computadora LAPTOP como usuario Tony',2693,'2005-10-04 19:00:23'),
  (22,'2005-10-04 19:01:55','Entrada Frm_INICIO desde la Computadora LAPTOP como usuario Tony',2694,'2005-10-04 19:01:55'),
  (22,'2005-10-19 19:31:52','Salida desde la Computadora LAPTOP como usuario Tony',2695,'2005-10-19 19:31:52'),
  (22,'2005-10-19 20:05:56','Entrada Frm_INICIO desde la Computadora LAPTOP como usuario Tony',2696,'2005-10-19 20:05:56'),
  (22,'2005-10-20 15:26:26','Entrada  desde la Computadora LAPTOP como usuario Tony',2697,'2005-10-20 15:26:26'),
  (22,'2005-10-20 15:29:21','Entrada  desde la Computadora LAPTOP como usuario Tony',2698,'2005-10-20 15:29:21'),
  (22,'2005-10-20 15:29:59','Salida desde la Computadora LAPTOP como usuario Tony',2699,'2005-10-20 15:29:59'),
  (22,'2005-10-25 22:18:07','Entrada  desde la Computadora LAPTOP como usuario Tony',2700,'2005-10-25 22:18:07'),
  (22,'2005-10-25 22:18:21','Entrada  desde la Computadora LAPTOP como usuario Tony',2701,'2005-10-25 22:18:21'),
  (22,'2005-10-10 22:38:24','Entrada  desde la Computadora LAPTOP como usuario Tony',2702,'2005-10-10 22:38:24'),
  (22,'2005-10-10 22:39:36','Salida desde la Computadora LAPTOP como usuario Tony',2703,'2005-10-10 22:39:36'),
  (22,'2005-10-10 23:04:15','Entrada  desde la Computadora LAPTOP como usuario Tony',2704,'2005-10-10 23:04:15'),
  (22,'2005-10-10 23:04:21','Salida desde la Computadora LAPTOP como usuario Tony',2705,'2005-10-10 23:04:21'),
  (22,'2005-10-24 22:21:31','VENTAS: Se CANCELO el documento Nº 0004 desde la Computadora LAPTOP como usuario Tony',2706,'2005-10-24 22:21:31'),
  (22,'2005-10-24 22:24:57','VENTAS: Se CANCELO el documento Nº 0001 desde la Computadora LAPTOP como usuario Tony',2707,'2005-10-24 22:24:57'),
  (22,'2005-10-24 22:28:43','VENTAS: Se CANCELO el documento Nº 0010 desde la Computadora LAPTOP como usuario Tony',2708,'2005-10-24 22:28:43'),
  (22,'2005-10-24 22:32:36','VENTAS: Se CANCELO el documento Nº 0021 desde la Computadora LAPTOP como usuario Tony',2709,'2005-10-24 22:32:36'),
  (22,'2005-10-24 22:34:16','VENTAS: Se CANCELO el documento Nº 0023 desde la Computadora LAPTOP como usuario Tony',2710,'2005-10-24 22:34:16'),
  (22,'2005-10-24 22:38:42','VENTAS: Se CANCELO el documento Nº 0024 desde la Computadora LAPTOP como usuario Tony',2711,'2005-10-24 22:38:42'),
  (22,'2005-10-24 22:41:37','VENTAS: Se CANCELO el documento Nº 0026 desde la Computadora LAPTOP como usuario Tony',2712,'2005-10-24 22:41:37');

COMMIT;

#
# Structure for the `tbl_tipoarticulos` table : 
#

DROP TABLE IF EXISTS `tbl_tipoarticulos`;

CREATE TABLE `tbl_tipoarticulos` (
  `clave` tinyint(3) unsigned NOT NULL auto_increment,
  `nombre` varchar(15) NOT NULL default '',
  `Cantidad` decimal(5,2) NOT NULL default '1.00',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`clave`),
  UNIQUE KEY `clave` (`clave`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_tipoarticulos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_tipoarticulos` (`clave`, `nombre`, `Cantidad`, `stamp`) VALUES 
  (1,'PZ','1.00','2005-08-02 12:17:18'),
  (2,'LT','1.00','2005-08-02 16:46:32');

COMMIT;

#
# Structure for the `tbl_categoria` table : 
#

DROP TABLE IF EXISTS `tbl_categoria`;

CREATE TABLE `tbl_categoria` (
  `cve_categoria` tinyint(3) unsigned NOT NULL default '0',
  `Nombre_Cat` varchar(50) NOT NULL default '',
  `Descripcion` varchar(100) NOT NULL default 'SIN DESCRIPCION',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `idCategoria` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`cve_categoria`),
  UNIQUE KEY `idCategoria` (`idCategoria`),
  KEY `cve_categoria` (`cve_categoria`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_categoria` table  (LIMIT 0,500)
#

INSERT INTO `tbl_categoria` (`cve_categoria`, `Nombre_Cat`, `Descripcion`, `stamp`, `idCategoria`) VALUES 
  (0,'[NO DEFINIDO]','[NO DEFINIDO]','2005-08-02 12:14:03',2),
  (1,'LINEA BLANCA','SIN DESCRIPCION','2005-10-04 18:56:23',3);

COMMIT;

#
# Structure for the `tbl_articulos` table : 
#

DROP TABLE IF EXISTS `tbl_articulos`;

CREATE TABLE `tbl_articulos` (
  `clave_art` varchar(12) NOT NULL,
  `nombre_art` varchar(100) NOT NULL,
  `unidad` tinyint(3) unsigned default NULL,
  `existencia_minima` smallint(6) NOT NULL default '0',
  `precioventa` double(15,2) unsigned NOT NULL default '0.00',
  `preciocompra` double(15,2) unsigned NOT NULL default '0.00',
  `construido` tinyint(2) NOT NULL default '1',
  `ganancia` double(15,2) unsigned NOT NULL default '0.00',
  `cve_categoria` tinyint(3) unsigned NOT NULL default '0',
  `descuento` double(15,2) unsigned NOT NULL default '0.00',
  `unidadCompra` tinyint(3) unsigned default NULL,
  `costopromedio` double(15,2) unsigned NOT NULL default '0.00',
  `idArticulos` int(11) NOT NULL auto_increment,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`clave_art`),
  UNIQUE KEY `idArticulos` (`idArticulos`),
  KEY `unidad` (`unidad`),
  KEY `unidadCompra` (`unidadCompra`),
  KEY `cve_categoria` (`cve_categoria`),
  CONSTRAINT `tbl_articulos_ibfk_76` FOREIGN KEY (`unidadCompra`) REFERENCES `tbl_tipoarticulos` (`clave`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_articulos_ibfk_77` FOREIGN KEY (`cve_categoria`) REFERENCES `tbl_categoria` (`cve_categoria`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_articulos_ibfk_78` FOREIGN KEY (`unidad`) REFERENCES `tbl_tipoarticulos` (`clave`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=2730 AVG_ROW_LENGTH=2730 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; (`unidadCompra`) REFER `thoga/tbl_tip';

#
# Data for the `tbl_articulos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_articulos` (`clave_art`, `nombre_art`, `unidad`, `existencia_minima`, `precioventa`, `preciocompra`, `construido`, `ganancia`, `cve_categoria`, `descuento`, `unidadCompra`, `costopromedio`, `idArticulos`, `stamp`) VALUES 
  ('55555555555','5555555',1,0,0.00,0.00,1,0.00,0,0.00,1,0.00,7,'2005-10-10 22:38:47'),
  ('FINDIA','FIN DIA',1,0,0.00,0.00,1,0.00,0,0.00,1,0.00,3,'2005-08-25 22:05:25'),
  ('L0001','REFRIGERADOR',1,0,0.00,0.00,1,0.00,1,0.00,1,0.00,5,'2005-10-04 18:56:35'),
  ('L0002','LAVADORA',1,0,0.00,0.00,1,0.00,1,0.00,1,0.00,6,'2005-10-04 18:57:11'),
  ('MASIVA','PRODUCTOS VARIOS',1,0,0.00,0.00,1,0.00,0,0.00,1,0.00,4,'2005-08-25 22:05:27');

COMMIT;

#
# Structure for the `tbl_branches` table : 
#

DROP TABLE IF EXISTS `tbl_branches`;

CREATE TABLE `tbl_branches` (
  `id_brach` tinyint(3) NOT NULL auto_increment,
  `Codigo_branch` varchar(10) NOT NULL default '',
  `Nombre_Branch` varchar(50) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id_brach`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_branches` table  (LIMIT 0,500)
#

INSERT INTO `tbl_branches` (`id_brach`, `Codigo_branch`, `Nombre_Branch`, `stamp`) VALUES 
  (1,'[TODAS]','[TODAS LAS SUCURSALES]','2005-09-11 13:30:18'),
  (2,'THVER','VERACRUZ','2005-09-08 21:34:11'),
  (3,'THCOR','CORDOBA','2005-09-08 21:53:50');

COMMIT;

#
# Structure for the `tbl_articulosbranch` table : 
#

DROP TABLE IF EXISTS `tbl_articulosbranch`;

CREATE TABLE `tbl_articulosbranch` (
  `idArticulosBranch` int(11) NOT NULL auto_increment,
  `id_Branch` tinyint(3) NOT NULL default '1',
  `clave_art` varchar(12) NOT NULL default '',
  `disponible` decimal(11,2) unsigned NOT NULL default '0.00',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idArticulosBranch`),
  UNIQUE KEY `uniqua` (`id_Branch`,`clave_art`),
  KEY `id_Branch` (`id_Branch`),
  KEY `clave_art` (`clave_art`),
  CONSTRAINT `tbl_articulosbranch_ibfk_27` FOREIGN KEY (`clave_art`) REFERENCES `tbl_articulos` (`clave_art`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tbl_articulosbranch_ibfk_63` FOREIGN KEY (`id_Branch`) REFERENCES `tbl_branches` (`id_brach`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_articulosbranch` table  (LIMIT 0,500)
#

INSERT INTO `tbl_articulosbranch` (`idArticulosBranch`, `id_Branch`, `clave_art`, `disponible`, `stamp`) VALUES 
  (1,2,'L0001','0.00','2005-10-04 18:56:57'),
  (2,2,'L0002','0.00','2005-10-04 18:57:19'),
  (3,2,'55555555555','0.00','2005-10-10 22:38:48');

COMMIT;

#
# Structure for the `tbl_articulosprecios` table : 
#

DROP TABLE IF EXISTS `tbl_articulosprecios`;

CREATE TABLE `tbl_articulosprecios` (
  `IdArticulosPrecios` int(11) unsigned NOT NULL auto_increment,
  `clave_art` varchar(12) NOT NULL,
  `precio` double(15,2) unsigned NOT NULL default '0.00',
  `tipo` tinyint(2) NOT NULL default '0',
  `porcentaje` float(9,2) unsigned NOT NULL default '0.00',
  `agregariva` tinyint(2) NOT NULL default '0',
  `precioIva` double(15,2) unsigned NOT NULL default '0.00',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`IdArticulosPrecios`),
  UNIQUE KEY `IdArticulosPrecios` (`IdArticulosPrecios`),
  UNIQUE KEY `unico` (`clave_art`,`tipo`),
  KEY `clave_art` (`clave_art`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=16384 MAX_ROWS=16384 AVG_ROW_LENGTH=3276 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; (`clave_art`) REFER `thoga/tbl_articu';

#
# Data for the `tbl_articulosprecios` table  (LIMIT 0,500)
#

INSERT INTO `tbl_articulosprecios` (`IdArticulosPrecios`, `clave_art`, `precio`, `tipo`, `porcentaje`, `agregariva`, `precioIva`, `stamp`) VALUES 
  (1,'L0001',86.96,0,0.00,0,100.00,'2005-10-04 18:56:43'),
  (2,'L0002',869.57,0,0.00,0,1000.00,'2005-10-04 18:57:15'),
  (3,'L0001',106.96,1,0.00,0,123.00,'2005-10-24 21:37:13'),
  (4,'L0001',1070.43,2,0.00,0,1231.00,'2005-10-24 21:37:17');

COMMIT;

#
# Structure for the `tbl_cataestatus` table : 
#

DROP TABLE IF EXISTS `tbl_cataestatus`;

CREATE TABLE `tbl_cataestatus` (
  `idCataEstatus` int(11) NOT NULL auto_increment,
  `ClaveCataEstatus` tinyint(2) NOT NULL default '0',
  `DescripcionCataEstatus` varchar(50) NOT NULL default 'SIN DESCRIPCION',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ClaveCataEstatus`),
  UNIQUE KEY `idCataEstatus` (`idCataEstatus`),
  UNIQUE KEY `ClaveCataEstatus` (`ClaveCataEstatus`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_cataestatus` table  (LIMIT 0,500)
#

INSERT INTO `tbl_cataestatus` (`idCataEstatus`, `ClaveCataEstatus`, `DescripcionCataEstatus`, `stamp`) VALUES 
  (1,0,'[NO DEFINIDO]','2005-08-02 12:11:38'),
  (2,1,'FIRMADO','2005-08-04 15:07:22'),
  (3,2,'CANCELADO','2005-08-04 15:07:25'),
  (4,3,'ACTIVO','2005-08-04 15:07:29'),
  (5,4,'BAJA','2005-08-04 15:07:32'),
  (6,5,'PAGADO','2005-08-04 15:17:50'),
  (7,6,'DESCONTADO','2005-08-04 15:17:55'),
  (8,7,'RECHAZADO','2005-09-08 21:34:02'),
  (9,8,'NO PAGADO','2005-09-26 19:48:18'),
  (10,9,'PEND. FIRMA','2005-09-26 19:56:16');

COMMIT;

#
# Structure for the `tbl_catalogocontratos` table : 
#

DROP TABLE IF EXISTS `tbl_catalogocontratos`;

CREATE TABLE `tbl_catalogocontratos` (
  `idCataContrato` int(11) NOT NULL auto_increment,
  `ClaveCataContrato` tinyint(2) NOT NULL default '0',
  `DescripcionCataContrato` varchar(50) NOT NULL default 'SIN DESCRIPCION',
  `comision` tinyint(2) NOT NULL default '0',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ClaveCataContrato`),
  UNIQUE KEY `idCataContrato` (`idCataContrato`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_catalogocontratos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_catalogocontratos` (`idCataContrato`, `ClaveCataContrato`, `DescripcionCataContrato`, `comision`, `stamp`) VALUES 
  (1,0,'[NO DEFINIDO]',0,'2005-08-02 16:44:45'),
  (2,1,'COMISION',-1,'2005-08-02 16:46:59'),
  (3,2,'SUELDO',0,'2005-08-02 16:47:05'),
  (4,3,'COMISION+SUELDO',-1,'2005-08-02 16:47:14');

COMMIT;

#
# Structure for the `tbl_catalogodepartamentos` table : 
#

DROP TABLE IF EXISTS `tbl_catalogodepartamentos`;

CREATE TABLE `tbl_catalogodepartamentos` (
  `idCataDepa` int(11) NOT NULL auto_increment,
  `ClaveCataDepa` tinyint(2) NOT NULL default '0',
  `DescripcionCataDepa` varchar(50) NOT NULL default 'SIN DESCRIPCION',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ClaveCataDepa`),
  UNIQUE KEY `idCataDepa` (`idCataDepa`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_catalogodepartamentos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_catalogodepartamentos` (`idCataDepa`, `ClaveCataDepa`, `DescripcionCataDepa`, `stamp`) VALUES 
  (1,0,'[NO DEFINIDO]','2005-08-02 12:12:27'),
  (2,1,'ADMINISTRACION','2005-08-05 08:13:04'),
  (3,2,'VENTAS','2005-08-05 08:17:54'),
  (4,3,'COMPRAS','2005-08-15 15:44:29');

COMMIT;

#
# Structure for the `tbl_catalogopuestos` table : 
#

DROP TABLE IF EXISTS `tbl_catalogopuestos`;

CREATE TABLE `tbl_catalogopuestos` (
  `idCataPuesto` int(11) NOT NULL auto_increment,
  `ClaveCataPuesto` tinyint(2) NOT NULL default '0',
  `DescripcionCataPuesto` varchar(50) NOT NULL default 'SIN DESCRIPCION',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ClaveCataPuesto`),
  UNIQUE KEY `idCataPuesto` (`idCataPuesto`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_catalogopuestos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_catalogopuestos` (`idCataPuesto`, `ClaveCataPuesto`, `DescripcionCataPuesto`, `stamp`) VALUES 
  (1,0,'[NO DEFINIDO]','2005-08-02 12:12:34'),
  (2,1,'ADMINISTRADOR','2005-08-05 08:13:14'),
  (3,2,'VENDEDOR','2005-08-05 08:17:59');

COMMIT;

#
# Structure for the `tbl_clientes` table : 
#

DROP TABLE IF EXISTS `tbl_clientes`;

CREATE TABLE `tbl_clientes` (
  `clave_cliente` varchar(5) NOT NULL default '',
  `nombre` varchar(100) NOT NULL default '',
  `direccion` varchar(100) NOT NULL default '>',
  `telefono` varchar(20) NOT NULL default '>',
  `rfc` varchar(20) NOT NULL default '>',
  `cp` varchar(10) NOT NULL default '>',
  `ciudad` varchar(40) NOT NULL default '>',
  `email` varchar(30) NOT NULL default '>',
  `colonia` varchar(30) NOT NULL default '>',
  `tipo` tinyint(2) NOT NULL default '0',
  `tiempoCred` tinyint(3) NOT NULL default '0',
  `IdClientes` int(11) NOT NULL auto_increment,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`clave_cliente`),
  UNIQUE KEY `IdClientes` (`IdClientes`),
  KEY `tipo` (`tipo`),
  CONSTRAINT `tbl_clientes_ibfk_40` FOREIGN KEY (`tipo`) REFERENCES `tbl__tiposclientes` (`Tipo`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_clientes` table  (LIMIT 0,500)
#

INSERT INTO `tbl_clientes` (`clave_cliente`, `nombre`, `direccion`, `telefono`, `rfc`, `cp`, `ciudad`, `email`, `colonia`, `tipo`, `tiempoCred`, `IdClientes`, `stamp`) VALUES 
  ('00000','MOSTRADOR','---------','---------','---------','---------','---------','---------','---------',0,0,1,'2005-08-03 16:15:43'),
  ('00001','PUBLICO EN GENERAL','>','>','>','>','>','>','>',0,0,2,'2005-08-03 18:22:36'),
  ('00002','ANTONIO LEAL','DIRECCION','TELEFONO','RFC','CP','CIUDAD','>','COLONIA',0,0,3,'2005-10-04 18:59:02'),
  ('00003','JUAN LOPEZ','>','>','>','>','>','>','>',0,0,4,'2005-10-04 19:05:42'),
  ('00004','JUAN','>','>','>','>','>','>','>',0,0,5,'2005-10-19 19:16:12'),
  ('00005','345345','>','>','>','>','>','>','>',0,0,6,'2005-10-04 20:35:37'),
  ('00006','JOSE','>','>','>','>','>','>','>',1,0,7,'2005-10-20 15:21:05'),
  ('00007','RAMON','>','>','>','>','>','>','>',0,0,8,'2005-10-20 15:21:13'),
  ('00008','arturo','>','>','>','>','>','>','>',1,0,9,'2005-10-20 15:24:17'),
  ('00009','JOEL','>','>','>','>','>','>','>',1,0,10,'2005-10-20 15:25:24'),
  ('00010','JORGE','>','>','>','>','>','>','>',2,0,11,'2005-10-20 15:27:04'),
  ('00011','ANTONIO LEAL ELIZONDO','>','>','>','>','>','>','>',1,0,12,'2005-10-20 15:29:48'),
  ('00012','555555','>','>','>','>','>','>','>',0,0,13,'2005-10-10 22:38:44'),
  ('00013','yyy','>','>','>','>','>','>','>',0,0,14,'2005-10-24 17:48:59');

COMMIT;

#
# Structure for the `tbl_grupos` table : 
#

DROP TABLE IF EXISTS `tbl_grupos`;

CREATE TABLE `tbl_grupos` (
  `id_grupo` tinyint(3) NOT NULL auto_increment,
  `id_branch` tinyint(3) NOT NULL,
  `Codigo_grupo` varchar(10) NOT NULL default '',
  `Nombre_grupo` varchar(50) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id_grupo`),
  UNIQUE KEY `id_grupo` (`id_grupo`),
  KEY `id_branch` (`id_branch`),
  CONSTRAINT `tbl_grupos_ibfk_26` FOREIGN KEY (`id_branch`) REFERENCES `tbl_branches` (`id_brach`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_grupos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_grupos` (`id_grupo`, `id_branch`, `Codigo_grupo`, `Nombre_grupo`, `stamp`) VALUES 
  (1,2,'THVER01','VERACRUZ UNO','2005-09-08 22:35:13'),
  (2,3,'THCOR01','CORDOBA 1','2005-09-08 22:44:55'),
  (3,2,'THVER02','VERACRUZ DOS','2005-09-08 23:14:28');

COMMIT;

#
# Structure for the `tbl_empleados` table : 
#

DROP TABLE IF EXISTS `tbl_empleados`;

CREATE TABLE `tbl_empleados` (
  `clave_empleado` varchar(6) NOT NULL,
  `nombre` varchar(80) NOT NULL,
  `fechaIngreso` date default NULL,
  `NoIMSS` varchar(15) NOT NULL default '0',
  `direccion` varchar(50) NOT NULL default '>',
  `telefono` varchar(30) NOT NULL default '>',
  `FechaNacimiento` date default NULL,
  `ClaveCataEstatus` tinyint(2) NOT NULL default '0',
  `fechabaja` datetime default NULL,
  `ClaveCataContrato` tinyint(2) NOT NULL default '0',
  `sueldo` double(15,2) unsigned NOT NULL default '0.00',
  `Comision` double(15,2) unsigned NOT NULL default '0.00',
  `ClaveCataDepa` tinyint(2) NOT NULL default '0',
  `ClaveCataPuesto` tinyint(2) NOT NULL default '0',
  `tipoEmpleado` tinyint(1) unsigned NOT NULL default '1',
  `MinimaCuotaCredito` tinyint(4) unsigned NOT NULL default '0',
  `idEmpleados` int(11) NOT NULL auto_increment,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id_grupo` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`clave_empleado`),
  UNIQUE KEY `idEmpleados` (`idEmpleados`),
  KEY `ClaveCataPuesto` (`ClaveCataPuesto`),
  KEY `ClaveCataEstatus` (`ClaveCataEstatus`),
  KEY `ClaveCataContrato` (`ClaveCataContrato`),
  KEY `ClaveCataDepa` (`ClaveCataDepa`),
  KEY `id_grupo` (`id_grupo`),
  CONSTRAINT `tbl_empleados_ibfk_126` FOREIGN KEY (`ClaveCataDepa`) REFERENCES `tbl_catalogodepartamentos` (`ClaveCataDepa`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_empleados_ibfk_127` FOREIGN KEY (`ClaveCataEstatus`) REFERENCES `tbl_cataestatus` (`ClaveCataEstatus`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_empleados_ibfk_128` FOREIGN KEY (`ClaveCataContrato`) REFERENCES `tbl_catalogocontratos` (`ClaveCataContrato`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_empleados_ibfk_129` FOREIGN KEY (`ClaveCataPuesto`) REFERENCES `tbl_catalogopuestos` (`ClaveCataPuesto`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_empleados_ibfk_130` FOREIGN KEY (`id_grupo`) REFERENCES `tbl_grupos` (`id_grupo`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=1489 MAX_ROWS=1489 AVG_ROW_LENGTH=1638 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; (`ClaveCataDepa`) REFER `thoga/tbl_ca';

#
# Data for the `tbl_empleados` table  (LIMIT 0,500)
#

INSERT INTO `tbl_empleados` (`clave_empleado`, `nombre`, `fechaIngreso`, `NoIMSS`, `direccion`, `telefono`, `FechaNacimiento`, `ClaveCataEstatus`, `fechabaja`, `ClaveCataContrato`, `sueldo`, `Comision`, `ClaveCataDepa`, `ClaveCataPuesto`, `tipoEmpleado`, `MinimaCuotaCredito`, `idEmpleados`, `stamp`, `id_grupo`) VALUES 
  ('TH0001','ASESOR COMISION','2005-10-11','0','QQWEQWE','QWEQWEQ','2005-10-04',3,NULL,1,0.00,100.00,2,2,1,0,1,'2005-10-04 18:44:54',3),
  ('TH0002','ASESOR COMISION SUELDO','2005-10-11','0','QEWQWEQWE','QWEQWE','2005-10-04',3,NULL,3,1000.00,20.00,2,2,1,0,2,'2005-10-04 18:48:19',1),
  ('TH0003','ASESOR SUELDO','2005-10-05','0','QWEQWE','QWEQWE','2005-10-04',3,NULL,2,3000.00,0.00,2,2,1,0,3,'2005-10-04 18:49:05',1),
  ('TH0004','SUPERVISOR COMISION','2005-10-04','0','123123','12313','2005-10-04',3,NULL,1,0.00,200.00,1,2,2,6,4,'2005-10-04 18:49:43',1),
  ('TH0005','SUPERVISOR COMISION SUELDO','2005-10-11','0','2342342','234234','2005-10-04',3,NULL,3,35.00,24.00,3,1,2,6,5,'2005-10-04 18:50:14',1),
  ('TH0006','SUPERVISOR SUELDO','2005-10-05','0','QWEQWE','QWEQWE','2005-10-04',3,NULL,2,4000.00,0.00,1,2,2,5,6,'2005-10-04 18:50:38',1),
  ('TH0007','ADMON COMISION','2005-10-05','0','QWEQWE','QWEQWE','2005-10-04',3,NULL,1,0.00,300.00,1,1,3,0,7,'2005-10-04 18:51:14',1),
  ('TH0008','ADMON COMISION SUELDO','2005-10-11','0','123123','123123','2005-10-04',3,NULL,3,5000.00,100.00,1,2,3,0,8,'2005-10-04 18:51:47',1),
  ('TH0009','ADMON SUELDO','2005-10-19','234243','234234','234243','2005-10-04',3,NULL,2,6000.00,0.00,1,1,3,0,9,'2005-10-04 18:52:13',1);

COMMIT;

#
# Structure for the `tbl_comisionan` table : 
#

DROP TABLE IF EXISTS `tbl_comisionan`;

CREATE TABLE `tbl_comisionan` (
  `IdComisiona` int(11) NOT NULL auto_increment,
  `clave_empleado` varchar(6) NOT NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `id_grupo` tinyint(3) NOT NULL,
  PRIMARY KEY  (`IdComisiona`),
  UNIQUE KEY `Uniqua` (`clave_empleado`,`id_grupo`),
  KEY `IdComisiona` (`IdComisiona`),
  KEY `id_grupo` (`id_grupo`),
  CONSTRAINT `tbl_comisionan_ibfk_48` FOREIGN KEY (`id_grupo`) REFERENCES `tbl_grupos` (`id_grupo`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_comisionan_ibfk_49` FOREIGN KEY (`clave_empleado`) REFERENCES `tbl_empleados` (`clave_empleado`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `tbl_comisionan` table  (LIMIT 0,500)
#

INSERT INTO `tbl_comisionan` (`IdComisiona`, `clave_empleado`, `stamp`, `id_grupo`) VALUES 
  (1,'TH0007','2005-10-04 18:53:19',1),
  (2,'TH0007','2005-10-04 18:53:22',3),
  (3,'TH0008','2005-10-04 18:53:29',1),
  (4,'TH0008','2005-10-04 18:53:48',2),
  (5,'TH0004','2005-10-04 18:54:46',3),
  (6,'TH0005','2005-10-04 18:54:53',1);

COMMIT;

#
# Structure for the `tbl_solicitudescredito` table : 
#

DROP TABLE IF EXISTS `tbl_solicitudescredito`;

CREATE TABLE `tbl_solicitudescredito` (
  `idSolicitudesCredito` int(11) unsigned NOT NULL auto_increment,
  `clave_empleado` varchar(6) NOT NULL,
  `clave_cliente` varchar(5) NOT NULL,
  `clave_art` varchar(12) NOT NULL,
  `bonifica` double(15,2) NOT NULL default '0.00',
  `FolioPedido` varchar(10) NOT NULL,
  `fechaIngreso` date default NULL,
  `fechaAutorizacion` date default NULL,
  `FolioContrato` int(11) NOT NULL default '0',
  `ClaveCataEstatus` tinyint(2) NOT NULL default '0',
  `ClaveCataEstatusPago` tinyint(2) NOT NULL default '0',
  `FechaPagoComision` date default NULL,
  `FechaEntrega` date default NULL,
  `clave_empFirmas` varchar(6) default NULL,
  `FechaLimite` date default NULL,
  `Observaciones` varchar(255) NOT NULL default 'SIN OBSERVACION',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `id_grupo` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`idSolicitudesCredito`),
  UNIQUE KEY `idSolicitudesCredito` (`idSolicitudesCredito`),
  KEY `clave_empleado` (`clave_empleado`),
  KEY `clave_cliente` (`clave_cliente`),
  KEY `ClaveCataEstatus` (`ClaveCataEstatus`),
  KEY `ClaveCataEstatusPago` (`ClaveCataEstatusPago`),
  KEY `id_grupo` (`id_grupo`),
  KEY `clave_art` (`clave_art`),
  CONSTRAINT `tbl_solicitudescredito_ibfk_13` FOREIGN KEY (`ClaveCataEstatus`) REFERENCES `tbl_cataestatus` (`ClaveCataEstatus`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_solicitudescredito_ibfk_14` FOREIGN KEY (`ClaveCataEstatusPago`) REFERENCES `tbl_cataestatus` (`ClaveCataEstatus`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_solicitudescredito_ibfk_15` FOREIGN KEY (`clave_cliente`) REFERENCES `tbl_clientes` (`clave_cliente`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_solicitudescredito_ibfk_16` FOREIGN KEY (`clave_art`) REFERENCES `tbl_articulos` (`clave_art`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_solicitudescredito_ibfk_17` FOREIGN KEY (`clave_empleado`) REFERENCES `tbl_empleados` (`clave_empleado`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_solicitudescredito_ibfk_18` FOREIGN KEY (`id_grupo`) REFERENCES `tbl_grupos` (`id_grupo`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=1489 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 10240 kB; (`clave_cliente`) REFER `thoga/tbl_cl';

#
# Data for the `tbl_solicitudescredito` table  (LIMIT 0,500)
#

INSERT INTO `tbl_solicitudescredito` (`idSolicitudesCredito`, `clave_empleado`, `clave_cliente`, `clave_art`, `bonifica`, `FolioPedido`, `fechaIngreso`, `fechaAutorizacion`, `FolioContrato`, `ClaveCataEstatus`, `ClaveCataEstatusPago`, `FechaPagoComision`, `FechaEntrega`, `clave_empFirmas`, `FechaLimite`, `Observaciones`, `stamp`, `id_grupo`) VALUES 
  (1,'TH0002','00002','L0001',0.00,'1','2005-10-04','2005-10-05',12345,1,5,'2005-10-04',NULL,'TH0007','2005-10-10','[SIN OBSERVACION]','2005-10-04 18:57:56',1),
  (2,'TH0001','00002','L0002',-500.00,'2','2005-10-04','2005-10-19',123123,9,5,'2005-10-04',NULL,'0','2005-10-24','[SIN OBSERVACION]','2005-10-04 19:03:24',3),
  (4,'TH0002','00002','L0001',0.00,'3','2005-10-04',NULL,0,9,5,'2005-10-04',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-04 19:05:29',1),
  (5,'TH0001','00003','L0001',0.00,'4','2005-10-04','2005-10-24',88888,9,5,'2005-10-04',NULL,'TH0001','2005-10-29','[SIN OBSERVACION]','2005-10-04 19:05:46',3),
  (6,'TH0004','00003','L0001',0.00,'5','2005-10-04',NULL,0,9,5,'2005-10-04',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-04 19:06:01',1),
  (7,'TH0001','00004','L0002',0.00,'7','2005-10-19',NULL,0,9,5,'2005-10-19',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-19 19:16:16',3),
  (8,'TH0001','00004','L0001',0.00,'8','2005-10-19',NULL,0,9,5,'2005-10-19',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-19 19:16:28',3),
  (9,'TH0002','00002','L0001',-10.00,'12','2005-10-19','2005-10-24',12312,9,5,'2005-10-19',NULL,'0','2005-10-29','[SIN OBSERVACION]','2005-10-19 19:16:44',1),
  (10,'TH0002','00002','L0001',0.00,'234','2005-10-04',NULL,0,9,5,'2005-10-04',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-04 20:28:30',1),
  (11,'TH0004','00005','L0001',0.00,'345345','2005-10-04',NULL,0,9,5,'2005-10-04',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-04 20:35:40',1),
  (12,'TH0007','00005','L0001',0.00,'345345','2005-10-19',NULL,0,9,5,'2005-10-19',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-19 20:36:41',1),
  (13,'TH0009','00002','L0002',0.00,'345345','2005-10-07',NULL,0,9,8,NULL,NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-19 20:38:44',1),
  (14,'TH0002','00002','L0001',0.00,'222222','2005-10-07',NULL,0,9,5,'2005-10-19',NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-19 20:40:04',1),
  (17,'TH0007','00011','L0001',-50.00,'qweqw','2005-10-20','2003-11-23',123123,9,5,'2005-10-22',NULL,'TH0001','2003-11-28','[SIN OBSERVACION]','2005-10-20 15:29:52',1),
  (18,'TH0007','00012','55555555555',0.00,'555555','2005-10-10',NULL,0,9,8,NULL,NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-10 22:38:50',1),
  (19,'TH0001','00013','55555555555',0.00,'FOLIO','2005-10-24',NULL,0,9,8,NULL,NULL,'0',NULL,'[SIN OBSERVACION]','2005-10-24 17:49:17',3);

COMMIT;

#
# Structure for the `tbl_facturassolicitudes` table : 
#

DROP TABLE IF EXISTS `tbl_facturassolicitudes`;

CREATE TABLE `tbl_facturassolicitudes` (
  `idFacturas` int(11) NOT NULL auto_increment,
  `Id_Solicitud` int(11) unsigned NOT NULL default '1',
  `numfact` varchar(10) NOT NULL,
  `fecha_fact` date default NULL,
  `eliva` tinyint(2) NOT NULL default '-1',
  `subtotal` double(15,2) default '0.00',
  `iva` double(15,2) default '0.00',
  `importe` double(15,2) unsigned NOT NULL default '0.00',
  `total` double(15,2) default '0.00',
  `cancelado` tinyint(4) default '0',
  `nota` tinyint(4) unsigned NOT NULL default '0',
  `fechacancelado` date default NULL,
  `observaciones` text,
  `DescuentoPorcentaje` float(9,2) default '0.00',
  `Descuento` double(15,2) default '0.00',
  `ChequeEfectivo` int(11) NOT NULL default '0',
  `extra` varchar(255) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idFacturas`),
  KEY `ChequeEfectivo` (`ChequeEfectivo`),
  KEY `Id_Solicitud` (`Id_Solicitud`),
  CONSTRAINT `tbl_facturassolicitudes_ibfk_19` FOREIGN KEY (`Id_Solicitud`) REFERENCES `tbl_solicitudescredito` (`idSolicitudesCredito`) ON UPDATE CASCADE,
  CONSTRAINT `tbl_facturassolicitudes_ibfk_20` FOREIGN KEY (`ChequeEfectivo`) REFERENCES `tbl__pagos` (`Idpago`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4096 MAX_ROWS=4096 AVG_ROW_LENGTH=16384 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 10240 kB; InnoDB free: 10240 kB; InnoDB free: 1';

#
# Data for the `tbl_facturassolicitudes` table  (LIMIT 0,500)
#

INSERT INTO `tbl_facturassolicitudes` (`idFacturas`, `Id_Solicitud`, `numfact`, `fecha_fact`, `eliva`, `subtotal`, `iva`, `importe`, `total`, `cancelado`, `nota`, `fechacancelado`, `observaciones`, `DescuentoPorcentaje`, `Descuento`, `ChequeEfectivo`, `extra`, `stamp`) VALUES 
  (1,1,'0001','2005-10-04',-1,100.00,0.00,100.00,100.00,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-04 18:58:34'),
  (2,2,'0002','2005-10-19',-1,500.00,0.00,500.00,500.00,0,0,NULL,NULL,0.00,0.00,2,NULL,'2005-10-19 19:15:35'),
  (3,17,'0003','2005-10-24',-1,123.00,0.00,123.00,123.00,0,0,NULL,NULL,0.00,0.00,2,NULL,'2005-10-24 21:36:57'),
  (4,9,'0004','2005-10-24',0,76.96,11.54,76.96,88.50,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-24 21:53:15'),
  (5,9,'0010','2005-10-24',-1,90.00,0.00,90.00,90.00,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-24 22:24:08'),
  (6,1,'0011','2005-10-24',-1,100.00,0.00,100.00,100.00,0,0,NULL,NULL,0.00,0.00,2,NULL,'2005-10-24 22:25:24'),
  (7,9,'0021','2005-10-24',-1,90.00,0.00,90.00,90.00,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-24 22:31:44'),
  (8,9,'0023','2005-10-24',-1,90.00,0.00,90.00,90.00,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-24 22:32:48'),
  (9,9,'0024','2005-10-24',-1,90.00,0.00,90.00,90.00,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-24 22:38:30'),
  (10,9,'0026','2005-10-24',-1,90.00,0.00,90.00,90.00,-1,0,'2005-10-24',NULL,0.00,0.00,2,NULL,'2005-10-24 22:41:29'),
  (11,9,'0029','2005-10-24',-1,90.00,0.00,90.00,90.00,0,0,NULL,NULL,0.00,0.00,2,NULL,'2005-10-24 22:42:08');

COMMIT;

#
# Structure for the `tbl_nominas` table : 
#

DROP TABLE IF EXISTS `tbl_nominas`;

CREATE TABLE `tbl_nominas` (
  `idNomina` int(11) unsigned NOT NULL auto_increment,
  `quincena` tinyint(4) unsigned NOT NULL default '0',
  `mes` tinyint(2) unsigned NOT NULL,
  `year` smallint(6) unsigned NOT NULL,
  `clave_empleado` varchar(6) NOT NULL,
  `creditos` tinyint(4) unsigned NOT NULL default '0',
  `descontadas` tinyint(4) unsigned default '0',
  `comision` double(15,2) unsigned NOT NULL default '0.00',
  `sueldo` double(15,2) unsigned NOT NULL default '0.00',
  `totalcomisiones` double(15,2) unsigned NOT NULL default '0.00',
  `bono` double(15,2) NOT NULL default '0.00',
  `total` double(15,2) NOT NULL default '0.00',
  `modificar` double(15,2) NOT NULL default '0.00',
  `diasdesc` tinyint(4) unsigned NOT NULL default '0',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idNomina`),
  UNIQUE KEY `quincena` (`quincena`,`mes`,`clave_empleado`),
  KEY `clave_empleado` (`clave_empleado`),
  CONSTRAINT `tbl_nominas_ibfk_1` FOREIGN KEY (`clave_empleado`) REFERENCES `tbl_empleados` (`clave_empleado`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1

#
# Data for the `tbl_nominas` table  (LIMIT 0,500)
#

INSERT INTO `tbl_nominas` (`idNomina`, `quincena`, `mes`, `year`, `clave_empleado`, `creditos`, `descontadas`, `comision`, `sueldo`, `totalcomisiones`, `resta`, `bono`, `total`, `stamp`) VALUES 
  (100,2,10,2005,'TH0002',5,NULL,20.00,500.00,100.00,0.00,1000.00,1600.00,'2005-10-19 20:40:50'),
  (101,2,10,2005,'TH0004',4,NULL,70.00,0.00,280.00,-200.00,0.00,80.00,'2005-10-19 20:40:50'),
  (102,2,10,2005,'TH0005',8,NULL,0.00,17.50,0.00,-617.50,3000.00,2400.00,'2005-10-19 20:40:50'),
  (103,2,10,2005,'TH0007',12,NULL,300.00,0.00,3600.00,-2400.00,0.00,1200.00,'2005-10-19 20:40:50'),
  (104,2,10,2005,'TH0008',8,NULL,100.00,2500.00,800.00,-3100.00,0.00,200.00,'2005-10-19 20:40:50'),
  (105,2,10,2005,'TH0001',4,NULL,100.00,0.00,400.00,0.00,1000.00,1400.00,'2005-10-19 20:40:50'),
  (106,2,10,2005,'TH0003',0,0,0.00,1500.00,0.00,0.00,1000.00,2500.00,'2005-10-19 20:40:50'),
  (107,2,10,2005,'TH0006',0,0,0.00,2000.00,0.00,-2000.00,1000.00,1000.00,'2005-10-19 20:40:50'),
  (108,2,10,2005,'TH0009',0,0,0.00,3000.00,0.00,-3000.00,0.00,0.00,'2005-10-19 20:40:50'),
  (109,1,10,2005,'TH0002',4,NULL,20.00,500.00,80.00,0.00,0.00,580.00,'2005-10-10 22:36:44'),
  (110,1,10,2005,'TH0004',2,NULL,100.00,0.00,200.00,0.00,0.00,200.00,'2005-10-10 22:36:44'),
  (111,1,10,2005,'TH0005',6,NULL,100.00,17.50,600.00,0.00,0.00,617.50,'2005-10-10 22:36:44'),
  (112,1,10,2005,'TH0007',8,NULL,300.00,0.00,2400.00,0.00,0.00,2400.00,'2005-10-10 22:36:44'),
  (113,1,10,2005,'TH0008',6,NULL,100.00,2500.00,600.00,0.00,0.00,3100.00,'2005-10-10 22:36:44'),
  (114,1,10,2005,'TH0001',2,NULL,100.00,0.00,200.00,0.00,0.00,200.00,'2005-10-10 22:36:44'),
  (115,1,10,2005,'TH0003',0,0,0.00,1500.00,0.00,0.00,0.00,1500.00,'2005-10-10 22:36:44'),
  (116,1,10,2005,'TH0006',0,0,0.00,2000.00,0.00,0.00,0.00,2000.00,'2005-10-10 22:36:44'),
  (117,1,10,2005,'TH0009',0,0,0.00,3000.00,0.00,0.00,0.00,3000.00,'2005-10-10 22:36:44');

COMMIT;

#
# Structure for the `tbl_reportes` table : 
#

DROP TABLE IF EXISTS `tbl_reportes`;

CREATE TABLE `tbl_reportes` (
  `Id` int(11) NOT NULL auto_increment,
  `Descripcion` varchar(50) default NULL,
  `Formulario` varchar(50) default NULL,
  `Reporte` varchar(50) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `Id` (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=155 MAX_ROWS=159 AVG_ROW_LENGTH=158 PACK_KEYS=0 ROW_FORMAT=FIXED;

#
# Data for the `tbl_reportes` table  (LIMIT 0,500)
#

INSERT INTO `tbl_reportes` (`Id`, `Descripcion`, `Formulario`, `Reporte`, `stamp`) VALUES 
  (1,'Catálogo de Productos',NULL,'Rpt_Articulos','2005-08-09 16:56:51'),
  (2,'Catálogo de Clientes',NULL,'Rpt_Clientes','2005-08-09 16:56:51'),
  (4,'Catálogo de Empleados',NULL,'Rpt_empleados','2005-09-18 20:39:46'),
  (13,'Lista de Precios',NULL,'Rpt_ListaPrecios','2005-08-09 16:56:51');

COMMIT;

#
# Structure for the `tbl_reportesestadisticos` table : 
#

DROP TABLE IF EXISTS `tbl_reportesestadisticos`;

CREATE TABLE `tbl_reportesestadisticos` (
  `Id` int(11) NOT NULL auto_increment,
  `Descripcion` char(50) default NULL,
  `Formulario` char(50) default NULL,
  `Reporte` char(50) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `Id` (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=155 AVG_ROW_LENGTH=155 PACK_KEYS=0 ROW_FORMAT=FIXED;

#
# Data for the `tbl_reportesestadisticos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_reportesestadisticos` (`Id`, `Descripcion`, `Formulario`, `Reporte`, `stamp`) VALUES 
  (1,'Productos',NULL,'Rpt_EstadisticasArticulos','2005-08-09 16:57:20'),
  (2,'Productos Mas Vendidos',NULL,'Rpt_EstadisticasProductosVendidos','2005-08-09 16:57:20'),
  (3,'Ventas Totales',NULL,'Rpt_EstadisticasVentasDocs','2005-08-09 16:57:20'),
  (4,'Ventas a Clientes',NULL,'Rpt_EstadisticasVentasClientes','2005-08-09 16:57:20'),
  (5,'Compras',NULL,'Rpt_EstadisticasComprasProveedores','2005-08-09 16:57:20'),
  (6,'Gastos Diversos',NULL,'Rpt_EstadisticasGastos','2005-08-09 16:57:20'),
  (7,'Ajustes de Inventario',NULL,'Rpt_EstadisticasAjustes','2005-08-09 16:57:20');

COMMIT;

#
# Structure for the `tbl_seguridadnivelesusuarios` table : 
#

DROP TABLE IF EXISTS `tbl_seguridadnivelesusuarios`;

CREATE TABLE `tbl_seguridadnivelesusuarios` (
  `IDGrupo` tinyint(4) NOT NULL auto_increment,
  `NivelKey` tinyint(4) NOT NULL default '0',
  `Nom_Grupo` varchar(50) default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`NivelKey`),
  UNIQUE KEY `IDGrupo` (`IDGrupo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=59 AVG_ROW_LENGTH=54 PACK_KEYS=0 ROW_FORMAT=FIXED;

#
# Data for the `tbl_seguridadnivelesusuarios` table  (LIMIT 0,500)
#

INSERT INTO `tbl_seguridadnivelesusuarios` (`IDGrupo`, `NivelKey`, `Nom_Grupo`, `stamp`) VALUES 
  (1,1,'Supervisor Principal','2005-08-16 15:29:00'),
  (2,2,'Supervisor','2005-08-16 15:29:03'),
  (3,3,'Captura','2005-08-16 15:28:52');

COMMIT;

#
# Structure for the `tbl_solicitudesdecontar` table : 
#

DROP TABLE IF EXISTS `tbl_solicitudesdecontar`;

CREATE TABLE `tbl_solicitudesdecontar` (
  `idSolicitudesDescontar` int(11) unsigned NOT NULL auto_increment,
  `idSolicitudesCredito` int(11) unsigned NOT NULL,
  `descontar` tinyint(2) unsigned NOT NULL default '0',
  `fechadescontar` date default NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idSolicitudesDescontar`),
  KEY `idSolicitudesCredito` (`idSolicitudesCredito`),
  CONSTRAINT `tbl_solicitudesdecontar_ibfk_1` FOREIGN KEY (`idSolicitudesCredito`) REFERENCES `tbl_solicitudescredito` (`idSolicitudesCredito`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=8192 AVG_ROW_LENGTH=8192 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; InnoDB free: 11264 kB';

#
# Structure for the `tbl_tablaasesoresbonos` table : 
#

DROP TABLE IF EXISTS `tbl_tablaasesoresbonos`;

CREATE TABLE `tbl_tablaasesoresbonos` (
  `idAsesorestabla` int(11) unsigned NOT NULL auto_increment,
  `creditos` varchar(20) NOT NULL default '0',
  `bono` double(15,2) unsigned NOT NULL default '0.00',
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idAsesorestabla`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4096 MAX_ROWS=4096 AVG_ROW_LENGTH=5461 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; InnoDB free: 11264 kB; InnoDB free: 1';

#
# Data for the `tbl_tablaasesoresbonos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_tablaasesoresbonos` (`idAsesorestabla`, `creditos`, `bono`, `stamp`) VALUES 
  (1,'Entre 1 y 44',1000.00,'2005-08-25 22:06:11'),
  (2,'Entre 45 y 54',2000.00,'2005-08-25 22:06:11'),
  (3,'>55',3000.00,'2005-08-25 22:06:11');

COMMIT;

#
# Structure for the `tbl_tablasupervisor` table : 
#

DROP TABLE IF EXISTS `tbl_tablasupervisor`;

CREATE TABLE `tbl_tablasupervisor` (
  `idTabla` int(11) unsigned NOT NULL auto_increment,
  `cuota` varchar(20) NOT NULL,
  `comision` double(15,2) unsigned NOT NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idTabla`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4096 AVG_ROW_LENGTH=4096 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; InnoDB free: 11264 kB';

#
# Data for the `tbl_tablasupervisor` table  (LIMIT 0,500)
#

INSERT INTO `tbl_tablasupervisor` (`idTabla`, `cuota`, `comision`, `stamp`) VALUES 
  (1,'Entre 85 y 100',100.00,'2005-08-25 22:06:15'),
  (2,'Entre 70 y 84',80.00,'2005-08-25 22:06:16'),
  (3,'Entre 50 y 69',70.00,'2005-08-25 22:06:16'),
  (4,'<49',50.00,'2005-08-25 22:06:17');

COMMIT;

#
# Structure for the `tbl_tablasupervisorbonos` table : 
#

DROP TABLE IF EXISTS `tbl_tablasupervisorbonos`;

CREATE TABLE `tbl_tablasupervisorbonos` (
  `idTabla` int(11) unsigned NOT NULL auto_increment,
  `cuota` varchar(20) NOT NULL,
  `bono` double(15,2) unsigned NOT NULL,
  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idTabla`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=4096 MAX_ROWS=4096 PACK_KEYS=0 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 11264 kB; InnoDB free: 11264 kB; InnoDB free: 1';

#
# Data for the `tbl_tablasupervisorbonos` table  (LIMIT 0,500)
#

INSERT INTO `tbl_tablasupervisorbonos` (`idTabla`, `cuota`, `bono`, `stamp`) VALUES 
  (1,'entre 110 y 119',1000.00,'2005-10-04 16:54:54'),
  (2,'entre 120 y 129',2000.00,'2005-10-04 16:55:17'),
  (3,'entre 130 y 139',3000.00,'2005-10-04 16:55:41'),
  (4,'entre 140 y 149',4000.00,'2005-10-04 16:57:24'),
  (5,'>149',5000.00,'2005-10-04 16:57:37');

COMMIT;

#
# Definition for the `v_empleados` view : 
#

DROP VIEW `v_empleados`;

CREATE VIEW `v_empleados` AS
  select 
    `tbl_empleados`.`clave_empleado` AS `clave_empleado`,
    `tbl_empleados`.`id_grupo` AS `id_grupo`,
    `tbl_empleados`.`tipoEmpleado` AS `TipoEmpleado`,
    `tbl_empleados`.`MinimaCuotaCredito` AS `MinimaCuotaCredito`,
    `tbl_catalogocontratos`.`DescripcionCataContrato` AS `DescripcionCataContrato`,
    `tbl_catalogocontratos`.`comision` AS `concomision`,
    `tbl_cataestatus`.`DescripcionCataEstatus` AS `DescripcionCataEstatus`,
    `tbl_catalogodepartamentos`.`DescripcionCataDepa` AS `DescripcionCataDepa`,
    `tbl_catalogopuestos`.`DescripcionCataPuesto` AS `DescripcionCataPuesto` 
  from 
    ((((`tbl_empleados` join `tbl_catalogocontratos` on((`tbl_empleados`.`ClaveCataContrato` = `tbl_catalogocontratos`.`ClaveCataContrato`))) join `tbl_cataestatus` on((`tbl_empleados`.`ClaveCataEstatus` = `tbl_cataestatus`.`ClaveCataEstatus`))) join `tbl_catalogodepartamentos` on((`tbl_empleados`.`ClaveCataDepa` = `tbl_catalogodepartamentos`.`ClaveCataDepa`))) join `tbl_catalogopuestos` on((`tbl_empleados`.`ClaveCataPuesto` = `tbl_catalogopuestos`.`ClaveCataPuesto`)));

#
# Definition for the `v_imprimefactsolicitudes` view : 
#

DROP VIEW `v_imprimefactsolicitudes`;

CREATE  VIEW `v_imprimefactsolicitudes` AS 
  select 
    `fs`.`Id_Solicitud` AS `Id_Solicitud`,
    `fs`.`numfact` AS `numfact`,
    `fs`.`idFacturas` AS `idFacturas`,
    `sc`.`clave_cliente` AS `clave_cliente`,
    `sc`.`clave_empleado` AS `clave_empleado`,
    `sc`.`FolioContrato` AS `FolioContrato`,
    `c`.`nombre` AS `nombre`,
    `c`.`direccion` AS `direccion`,
    `c`.`telefono` AS `telefono`,
    `c`.`rfc` AS `rfc`,
    `c`.`cp` AS `cp`,
    `c`.`ciudad` AS `ciudad`,
    `c`.`colonia` AS `colonia`,
    `fs`.`fecha_fact` AS `fecha_fact`,
    `fs`.`subtotal` AS `subtotal`,
    `fs`.`Descuento` AS `Descuento`,
    `fs`.`importe` AS `importe`,
    `fs`.`iva` AS `iva`,
    `fs`.`total` AS `total`,
    `fs`.`eliva` AS `eliva`,
    if((`fs`.`eliva` = 0),
    `ap`.`precio`,
    `ap`.`precioIva`) AS `precio`,
    `sc`.`bonifica` AS `bonifica`,
    `fs`.`ChequeEfectivo` AS `ChequeEfectivo`,
    `a`.`clave_art` AS `clave_art`,
    `a`.`nombre_art` AS `nombre_art`,
    `a`.`unidad` AS `unidad`,
    `fs`.`extra` AS `extra` 
  from 
    ((((`tbl_solicitudescredito` `SC` join `tbl_facturassolicitudes` `FS` on((`sc`.`idSolicitudesCredito` = `fs`.`Id_Solicitud`))) join `tbl_clientes` `C` on((`sc`.`clave_cliente` = `c`.`clave_cliente`))) join `tbl_articulos` `A` on((`sc`.`clave_art` = `a`.`clave_art`))) join `tbl_articulosprecios` `AP` on(((`c`.`tipo` = `ap`.`tipo`) and (`a`.`clave_art` = `ap`.`clave_art`)))) 
  where 
    (`fs`.`cancelado` = 0);

#
# Definition for the `v_rpt_comisiones` view : 
#

DROP VIEW `v_rpt_comisiones`;

CREATE VIEW `v_rpt_comisiones` AS 
  select 
    `sc`.`clave_empleado` AS `clave_empleado`,
    `e`.`nombre` AS `nombre`,
    `sc`.`clave_cliente` AS `clave_cliente`,
    `sc`.`FolioPedido` AS `FolioPedido`,
    `sc`.`clave_art` AS `clave_art`,
    `sc`.`fechaIngreso` AS `fechaIngreso`,
    `sc`.`ClaveCataEstatusPago` AS `ClaveCataEstatusPago`,
    `sc`.`ClaveCataEstatus` AS `ClaveCataEstatus`,
    `fs`.`numfact` AS `numfact`,
    `sc`.`FechaPagoComision` AS `FechaPagoComision`,
    `sc`.`FechaEntrega` AS `FechaEntrega`,
    `g`.`id_branch` AS `id_branch`,
    `b`.`Codigo_branch` AS `Codigo_branch`,
    `g`.`id_grupo` AS `id_grupo`,
    `g`.`Codigo_grupo` AS `Codigo_grupo`,
    `sc`.`FolioContrato` AS `FolioContrato` 
  from 
    ((((`tbl_solicitudescredito` `SC` join `tbl_grupos` `G` on((`sc`.`id_grupo` = `g`.`id_grupo`))) join `tbl_branches` `B` on((`g`.`id_branch` = `b`.`id_brach`))) join `tbl_empleados` `E` on(((`sc`.`clave_empleado` = `e`.`clave_empleado`) and (`g`.`id_grupo` = `e`.`id_grupo`)))) join `tbl_facturassolicitudes` `FS` on((`sc`.`idSolicitudesCredito` = `fs`.`Id_Solicitud`)));

#
# Definition for the `v_solicitudesadescontar` view : 
#

DROP VIEW `v_solicitudesadescontar`;

CREATE VIEW `v_solicitudesadescontar` AS
  select 
    `sc`.`idSolicitudesCredito` AS `idSolicitudesCredito`,
    `sc`.`clave_empleado` AS `clave_empleado`,
    `sc`.`clave_cliente` AS `clave_cliente`,
    `sc`.`FolioPedido` AS `FolioPedido`,
    `sc`.`clave_art` AS `clave_art`,
    `sc`.`fechaIngreso` AS `fechaIngreso`,
    `sc`.`fechaAutorizacion` AS `fechaAutorizacion`,
    `sc`.`FolioContrato` AS `FolioContrato`,
    `sc`.`ClaveCataEstatus` AS `ClaveCataEstatus`,
    `sc`.`ClaveCataEstatusPago` AS `ClaveCataEstatusPago`,
    `sc`.`FechaPagoComision` AS `FechaPagoComision`,
    `sc`.`FechaEntrega` AS `FechaEntrega`,
    `sc`.`clave_empFirmas` AS `clave_empFirmas`,
    `sc`.`FechaLimite` AS `FechaLimite`,
    `sc`.`Observaciones` AS `Observaciones`,
    `sc`.`id_grupo` AS `id_grupo`,
    `sc`.`stamp` AS `stamp`,
    `scd`.`descontar` AS `descontar`,
    `scd`.`fechadescontar` AS `fechadescontar` 
  from 
    (`tbl_solicitudescredito` `SC` join `tbl_solicitudesdecontar` `SCD` on((`sc`.`idSolicitudesCredito` = `scd`.`idSolicitudesCredito`))) 
  where 
    ((`scd`.`descontar` = 1) and (`sc`.`ClaveCataEstatus` <> 4));

#
# Definition for the `v_solicitudescredito` view : 
#

DROP VIEW `v_solicitudescredito`;

CREATE VIEW `v_solicitudescredito` AS 
  select 
    sql_no_cache `s`.`idSolicitudesCredito` AS `idSolicitudesCredito`,
    `s`.`clave_empleado` AS `clave_empleado`,
    `s`.`clave_cliente` AS `clave_cliente`,
    `s`.`FolioPedido` AS `FolioPedido`,
    `s`.`clave_art` AS `clave_art`,
    `s`.`fechaIngreso` AS `fechaIngreso`,
    `s`.`fechaAutorizacion` AS `fechaAutorizacion`,
    `s`.`FolioContrato` AS `FolioContrato`,
    `s`.`ClaveCataEstatus` AS `ClaveCataEstatus`,
    `s`.`ClaveCataEstatusPago` AS `ClaveCataEstatusPago`,
    `s`.`FechaPagoComision` AS `FechaPagoComision`,
    `s`.`clave_empFirmas` AS `clave_empFirmas`,
    `s`.`FechaLimite` AS `FechaLimite`,
    month(`s`.`fechaIngreso`) AS `elmes`,
    if(((`s`.`ClaveCataEstatus` <> 1) and (ifnull((to_days(`s`.`FechaLimite`) - to_days(curdate())),
    0) < 0)),
    abs(ifnull((to_days(`s`.`FechaLimite`) - to_days(curdate())),
    0)),
    0) AS `dias`,
    `s`.`Observaciones` AS `Observaciones`,
    `s`.`id_grupo` AS `id_grupo`,
    `s`.`stamp` AS `stamp` 
  from 
    `tbl_solicitudescredito` `S` 
  order by 
    `s`.`fechaIngreso`;