Ciencias

Base datos
CREATE DATABASE IF NOT EXISTS bdsae;
-------------------------------------------------
USE bdsae;
Table articulos
CREATE TABLE `articulos` (
`id_art` varchar( 25 ) NOT NULL default '',
`descripcion` varchar( 50 ) default NULL ,
`id_pro` int( 3 ) unsigned zerofill default NULL ,
`descripciontp` varchar( 30 ) default NULL ,
`fechacompra` date default '0000-00-00',`fechaventa` date default '0000-00-00',
`existencia` int( 10 ) unsigned default NULL ,
`preciocompra` float( 10, 2 ) default NULL ,
`preciomayoreo` float( 10, 2 ) default NULL ,
`preciominorista` float( 10, 2 ) default NULL ,
`preciodetalle` float( 10, 2 ) default NULL ,
`anulado` char( 2 ) NOT NULL default '',
`exento` char( 2 ) NOT NULL default '',
PRIMARY KEY ( `id_art` )-------------------------------------------------
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
Table bitacora
CREATE TABLE `bitacora` (
`id_bita` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`login` varchar( 25 ) NOT NULL default '',
`fecha` varchar( 10 ) NOT NULL default '',
`hora` varchar( 10 ) NOT NULL default '',
`evento` varchar( 45 ) NOT NULL default '',
KEY `id_bita` ( `id_bita` )-------------------------------------------------
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
Table cardex
CREATE TABLE `cardex` (
`id_art` varchar(25) NOT NULL default '',
`descripcion` varchar(50) NOT NULL default '',
`evento` varchar(45) NOT NULL default '',
`fecha` date default '0000-00-00',
`documento` int(10) unsigned NOT NULL default '0',
`ingreso` int(10) unsigned NOT NULL default '0',`salida` int(10) unsigned NOT NULL default '0',
`saldo` int(10) unsigned NOT NULL default '0',
`valoringreso` float(10,2) NOT NULL default '0.00',
`valorsalida` float(10,2) NOT NULL default '0.00',
`valorsaldo` float(10,2) NOT NULL default '0.00',
`precioc` float(10,2) NOT NULL default '0.00',
`preciocpromedio` float(10,2) NOT NULL default '0.00'-------------------------------------------------
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Table cfinal_cliente
CREATE TABLE `cfinal_cliente` (
`id_fin` int( 10 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
`nfactu` int( 10 ) unsigned zerofill default NULL ,
`fecha` date default NULL ,
`fecha_var` varchar( 10 ) default NULL ,
`cliente` varchar( 50 ) default NULL ,
`direccion` varchar( 50 ) default NULL ,
`documento`varchar( 50 ) default NULL ,
`fpago` varchar( 10 ) default NULL ,
`exentas` float( 10, 2 ) default '0.00',
`gravadas` float( 10, 2 ) default '0.00',
`total` float( 10, 2 ) default '0.00',
`totalvc` float( 10, 2 ) default '0.00',
`anulado` char( 2 ) default NULL ,
`usuario` int( 5 ) unsigned zerofill default NULL ,
`uventa` char( 2 ) NOT NULL default '',
PRIMARY KEY ( `id_fin` )-------------------------------------------------
) ENGINE = MYISAM DEFAULT CHARSET = latin1
Table cfinal_producto
CREATE TABLE `cfinal_producto` (
`id_fin` int( 10 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
`nfactu` int( 10 ) unsigned zerofill default NULL ,
`id_art` varchar( 25 ) NOT NULL default '',
`descripcion` varchar( 50 ) default NULL ,
`cantidad` int( 11 ) default NULL ,
`precio`float( 10, 2 ) default NULL ,
PRIMARY KEY ( `id_fin` )
-------------------------------------------------
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
Table cfinal_producto_temp
CREATE TABLE `cfinal_producto_temp` (
`id_fin` int( 10 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
`nfactu` int( 10 ) unsigned zerofill default NULL ,
`id_art` varchar( 25 ) NOT NULL default '',
`descripcion`varchar( 50 ) default NULL ,
`cantidad` int( 11 ) default NULL ,
`precio` float( 10, 2 ) default NULL ,
`guardada` char( 2 ) NOT NULL default '',
PRIMARY KEY ( `id_fin` )
-------------------------------------------------
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
Table cfiscal_cliente
CREATE TABLE `cfiscal_cliente` (
`id_fis` int(10) unsigned zerofill NOT NULL auto_increment,
`nfactu`...