/*
SQLyog Ultimate v8.71 
MySQL - 5.0.95 : Database - DB_Kombi
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`DB_Kombi` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `DB_Kombi`;

/*Table structure for table `actividades` */

DROP TABLE IF EXISTS `actividades`;

CREATE TABLE `actividades` (
  `IdActividad` int(11) NOT NULL auto_increment,
  `CodActividad` char(2) NOT NULL,
  `Actividad` varchar(50) NOT NULL,
  `FechaManual` int(11) NOT NULL default '0',
  PRIMARY KEY  (`IdActividad`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

/*Data for the table `actividades` */

/*Table structure for table `w_alter` */

DROP TABLE IF EXISTS `w_alter`;

CREATE TABLE `w_alter` (
  `alt_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `alt_nom` varchar(50) default NULL,
  `alt_cdeval` tinyint(3) unsigned NOT NULL default '0',
  `alt_cdpreg` tinyint(3) unsigned NOT NULL default '0',
  `alt_tipo` int(2) default NULL,
  `alt_desc` text NOT NULL,
  `alt_val` text,
  `alt_cusu` mediumint(8) NOT NULL,
  `alt_freg` int(11) default NULL,
  PRIMARY KEY  (`alt_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

/*Data for the table `w_alter` */

insert  into `w_alter`(`alt_cod`,`alt_nom`,`alt_cdeval`,`alt_cdpreg`,`alt_tipo`,`alt_desc`,`alt_val`,`alt_cusu`,`alt_freg`) values (26,'alter test',0,0,2,'<span id=\"spanetiq0\">sadas: </span><select id=\"control0\" name=\"control0\"><option value=\"ccc\">ccc</option><option value=\"444\">444</option></select>','ccc|444',1,1566202491),(27,'check opciones',0,0,3,'<span id=\"spanetiq0\">opcion1</span><input name=\"control0\" type=\"checkbox\" value=\"opcion1\">|<span id=\"spanetiq1\">opcion2</span><input name=\"control1\" type=\"checkbox\" value=\"opcion2\">|<span id=\"spanetiq2\">opcion3</span><input name=\"control2\" type=\"checkbox\" value=\"opcion3\">','opcion1|opcion2|opcion3',1,1566209115),(28,'alter 4',0,0,3,'<span id=\"spanetiq0\">a</span><input name=\"control0\" type=\"checkbox\" value=\"a\">|<span id=\"spanetiq1\">b</span><input name=\"control1\" type=\"checkbox\" value=\"b\">|<span id=\"spanetiq2\">c</span><input name=\"control2\" type=\"checkbox\" value=\"c\">|<span id=\"spanetiq3\">d</span><input name=\"control3\" type=\"checkbox\" value=\"d\">|<span id=\"spanetiq4\">e</span><input name=\"control4\" type=\"checkbox\" value=\"e\">','a|b|c|d|e|',1,1566332084);

/*Table structure for table `w_area` */

DROP TABLE IF EXISTS `w_area`;

CREATE TABLE `w_area` (
  `ar_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `ar_nom` varchar(50) NOT NULL,
  `ar_des` varchar(100) NOT NULL,
  `ar_cusu` mediumint(8) NOT NULL,
  `ar_est` int(1) NOT NULL,
  `ar_freg` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ar_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `w_area` */

insert  into `w_area`(`ar_cod`,`ar_nom`,`ar_des`,`ar_cusu`,`ar_est`,`ar_freg`) values (2,'VENTAS','VENTAS',1,1,1564591200),(3,'CONTABILIDAD','VENTAS',1,1,1564591200),(4,'asdas','asdas',1,1,1566012848),(6,'dddddd','dddddd',1,1,1566013086);

/*Table structure for table `w_autadm` */

DROP TABLE IF EXISTS `w_autadm`;

CREATE TABLE `w_autadm` (
  `aut_cdadm` mediumint(8) unsigned NOT NULL auto_increment,
  `aut_cusadm` mediumint(8) unsigned NOT NULL,
  `aut_fcradm` int(10) unsigned NOT NULL,
  `aut_tcadm` tinyint(3) unsigned NOT NULL,
  `aut_nusadm` varchar(30) NOT NULL,
  `aut_cntadm` varchar(30) character set utf8 collate utf8_bin NOT NULL,
  `aut_ce_adm` varchar(80) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`aut_cdadm`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `w_autadm` */

/*Table structure for table `w_auten` */

DROP TABLE IF EXISTS `w_auten`;

CREATE TABLE `w_auten` (
  `aut_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `aut_cusu` mediumint(8) unsigned NOT NULL,
  `aut_freg` int(10) unsigned NOT NULL,
  `aut_cest` tinyint(3) unsigned NOT NULL,
  `aut_priv` smallint(2) unsigned NOT NULL,
  `aut_nusu` varchar(30) NOT NULL,
  `aut_cntr` varchar(30) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`aut_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

/*Data for the table `w_auten` */

insert  into `w_auten`(`aut_cod`,`aut_cusu`,`aut_freg`,`aut_cest`,`aut_priv`,`aut_nusu`,`aut_cntr`) values (26,1,1565913600,1,1,'admin','admin'),(29,2,1565913600,1,1,'usuario2','ffff');

/*Table structure for table `w_cat` */

DROP TABLE IF EXISTS `w_cat`;

CREATE TABLE `w_cat` (
  `cat_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_cdcli` varchar(23) NOT NULL,
  `cat_rgcli` varchar(23) NOT NULL,
  `cat_cdcar` mediumint(8) NOT NULL,
  `cat_doi` varchar(20) NOT NULL,
  `cat_id_ac` varchar(20) NOT NULL,
  `cat_f_cmp` int(10) unsigned default NULL,
  `cat_f_vnt` int(10) unsigned default NULL,
  PRIMARY KEY  (`cat_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=latin1;

/*Data for the table `w_cat` */

/*Table structure for table `w_cdet` */

DROP TABLE IF EXISTS `w_cdet`;

CREATE TABLE `w_cdet` (
  `cdet_cod` mediumint(8) NOT NULL auto_increment,
  `cdet_cprg` mediumint(8) default NULL,
  `cdet_acod` mediumint(8) default NULL,
  `cdet_oval` varchar(255) default NULL,
  `cdet_punt` int(10) default NULL,
  PRIMARY KEY  (`cdet_cod`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `w_cdet` */

/*Table structure for table `w_cuest` */

DROP TABLE IF EXISTS `w_cuest`;

CREATE TABLE `w_cuest` (
  `cnf_codsis` mediumint(8) unsigned NOT NULL auto_increment,
  `cnf_nomsis` varchar(20) NOT NULL,
  `cnf_dscsis` varchar(60) NOT NULL,
  `cnf_npreg` tinyint(3) unsigned NOT NULL,
  `cnf_tpreg` int(10) unsigned NOT NULL,
  `cnf_rtmp_exp` int(10) unsigned NOT NULL,
  `cnf_dexp_acu` int(10) unsigned NOT NULL,
  `cnf_dexp_cmp` int(10) unsigned NOT NULL,
  `cnf_coetau` varchar(10) NOT NULL,
  `cnf_coenau` varchar(10) NOT NULL,
  `cnf_coetenc` varchar(10) NOT NULL,
  `cnf_coesrv` varchar(50) NOT NULL,
  `cnf_coeprt` int(10) unsigned NOT NULL,
  `cnf_coeusu` varchar(50) NOT NULL,
  `cnf_coecnt` varchar(50) NOT NULL,
  `cnf_coecc` varchar(70) NOT NULL,
  `cnf_t_cdsms` int(10) unsigned NOT NULL,
  `cnf_ndsms` tinyint(3) unsigned NOT NULL,
  `cnf_encf` varchar(100) NOT NULL,
  PRIMARY KEY  (`cnf_codsis`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `w_cuest` */

/*Table structure for table `w_cuestd` */

DROP TABLE IF EXISTS `w_cuestd`;

CREATE TABLE `w_cuestd` (
  `col_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `col_cusu` mediumint(8) default NULL,
  `col_eval` mediumint(8) default NULL,
  `col_ini` int(11) default NULL,
  `col_venc` int(11) default NULL,
  `col_rend` int(11) default NULL,
  `col_punt` int(11) default NULL,
  `col_est` int(1) default NULL,
  PRIMARY KEY  (`col_cod`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `w_cuestd` */

/*Table structure for table `w_eval` */

DROP TABLE IF EXISTS `w_eval`;

CREATE TABLE `w_eval` (
  `eval_cod` int(10) NOT NULL auto_increment,
  `eval_nom` varchar(255) default NULL,
  `eval_cdar` int(10) default NULL,
  `eval_cdprf` int(11) default NULL,
  `eval_idusu` int(11) default NULL,
  `eval_cdad` int(3) default NULL,
  `eval_cusu` int(11) default NULL,
  `eval_freg` int(11) default NULL,
  PRIMARY KEY  (`eval_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `w_eval` */

insert  into `w_eval`(`eval_cod`,`eval_nom`,`eval_cdar`,`eval_cdprf`,`eval_idusu`,`eval_cdad`,`eval_cusu`,`eval_freg`) values (1,'EvaluaciÃ³n Recepcionistas',2,5,2,20,1,1567706387),(2,'EvaluaciÃ³n Recepcionistas',2,5,2,20,1,1567706387);

/*Table structure for table `w_evaldet` */

DROP TABLE IF EXISTS `w_evaldet`;

CREATE TABLE `w_evaldet` (
  `w_evaldet` int(11) NOT NULL auto_increment,
  `eval_cod` int(11) default NULL,
  `prg_cod` int(11) default NULL,
  `w_nota` int(3) default NULL,
  PRIMARY KEY  (`w_evaldet`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

/*Data for the table `w_evaldet` */

insert  into `w_evaldet`(`w_evaldet`,`eval_cod`,`prg_cod`,`w_nota`) values (1,1,3,100),(2,1,9,100),(3,1,6,100),(4,1,15,100),(5,1,12,100),(6,1,10,100),(7,1,11,100),(8,1,1,100),(9,1,7,100),(10,1,13,100),(11,1,2,100),(12,1,14,100),(13,2,3,100),(14,2,9,100),(15,2,13,100),(16,2,2,100),(17,2,7,100),(18,2,12,100),(19,2,6,100),(20,2,10,100),(21,2,14,100),(22,2,11,100),(23,2,15,100),(24,2,1,100),(25,3,6,100),(26,3,10,100),(27,3,9,100),(28,3,13,100),(29,3,12,100),(30,3,11,100),(31,3,1,100),(32,3,15,100),(33,3,14,100),(34,3,3,100),(35,3,7,100),(36,3,2,100);

/*Table structure for table `w_modsis` */

DROP TABLE IF EXISTS `w_modsis`;

CREATE TABLE `w_modsis` (
  `sis_cdmod` mediumint(8) unsigned NOT NULL auto_increment,
  `sis_idmod` mediumint(8) unsigned NOT NULL,
  `sis_fcrmod` int(10) unsigned NOT NULL,
  `sis_tcmod` tinyint(3) unsigned NOT NULL,
  `sis_nvmod` tinyint(3) unsigned NOT NULL,
  `sis_mdisp` tinyint(3) unsigned NOT NULL,
  `sis_nsismod` varchar(30) NOT NULL,
  `sis_nommod` varchar(30) NOT NULL,
  `sis_desmod` varchar(90) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`sis_cdmod`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

/*Data for the table `w_modsis` */

/*Table structure for table `w_objt` */

DROP TABLE IF EXISTS `w_objt`;

CREATE TABLE `w_objt` (
  `obj_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `obj_tp` tinyint(3) unsigned NOT NULL default '0',
  `obj_nom` varchar(30) NOT NULL,
  `obj_des` varchar(60) NOT NULL,
  PRIMARY KEY  (`obj_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `w_objt` */

/*Table structure for table `w_perfil` */

DROP TABLE IF EXISTS `w_perfil`;

CREATE TABLE `w_perfil` (
  `prf_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `prf_nom` varchar(50) NOT NULL,
  `prf_des` varchar(100) NOT NULL,
  `prf_cusu` mediumint(8) NOT NULL,
  `prf_est` int(1) NOT NULL,
  `prf_freg` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`prf_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `w_perfil` */

insert  into `w_perfil`(`prf_cod`,`prf_nom`,`prf_des`,`prf_cusu`,`prf_est`,`prf_freg`) values (1,'SISTEMAS','SISTEMAS',1,1,1564591200),(2,'VENTAS','VENTAS',1,1,1564591200),(3,'CONTABILIDAD','VENTAS',1,1,1564591200),(5,'asdasd','asdasd',1,0,1566017124);

/*Table structure for table `w_pisos` */

DROP TABLE IF EXISTS `w_pisos`;

CREATE TABLE `w_pisos` (
  `pso_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `pso_id` mediumint(8) unsigned NOT NULL,
  `pso_nom` varchar(50) NOT NULL,
  `pso_des` varchar(100) NOT NULL,
  `pso_sedid` mediumint(8) unsigned NOT NULL,
  `pso_cusu` mediumint(8) NOT NULL,
  `pso_est` int(1) NOT NULL,
  `pso_freg` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`pso_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `w_pisos` */

/*Table structure for table `w_preg` */

DROP TABLE IF EXISTS `w_preg`;

CREATE TABLE `w_preg` (
  `prg_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `prg_nomb` varchar(255) default NULL,
  `prg_preg` text NOT NULL,
  `prg_rpt_tip` int(2) default NULL,
  `prg_rpt_ctrl` text,
  `prg_rpt_vals` text,
  `prg_rpt_acert` varchar(255) default NULL,
  `prg_cusu` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `prg_freg` int(11) NOT NULL,
  PRIMARY KEY  (`prg_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

/*Data for the table `w_preg` */

insert  into `w_preg`(`prg_cod`,`prg_nomb`,`prg_preg`,`prg_rpt_tip`,`prg_rpt_ctrl`,`prg_rpt_vals`,`prg_rpt_acert`,`prg_cusu`,`prg_freg`) values (1,'pregunta1','cuanto es 5 +5',4,'<span id=\"spanetiq0\">9</span><input type=\"radio\" name=\"control0\" value=\"9\">|<span id=\"spanetiq1\">20</span><input type=\"radio\" name=\"control0\" value=\"20\">|<span id=\"spanetiq2\">11</span><input type=\"radio\" name=\"control0\" value=\"11\">|<span id=\"spanetiq3\">10</span><input type=\"radio\" name=\"control0\" value=\"10\">|<span id=\"spanetiq4\">5</span><input type=\"radio\" name=\"control0\" value=\"5\">','9|20|11|10|5','10','1',1566424153),(2,'pregunta2','cuanto es 20 - 15',4,'<span id=\"spanetiq0\">10</span><input type=\"radio\" name=\"control0\" value=\"10\">|<span id=\"spanetiq1\">15</span><input type=\"radio\" name=\"control0\" value=\"15\">|<span id=\"spanetiq2\">5</span><input type=\"radio\" name=\"control0\" value=\"5\">|<span id=\"spanetiq3\">0</span><input type=\"radio\" name=\"control0\" value=\"0\">|<span id=\"spanetiq4\">12</span><input type=\"radio\" name=\"control0\" value=\"12\">','10|15|5|0|12','5','1',1566424296),(3,'preg 1','como se llama el primer filoso griego',4,'<span id=\"spanetiq0\">Tales de mileto</span><input type=\"radio\" name=\"control0\" value=\"Tales de mileto\">|<span id=\"spanetiq1\">Platon</span><input type=\"radio\" name=\"control0\" value=\"Platon\">|<span id=\"spanetiq2\">Heraclito</span><input type=\"radio\" name=\"control0\" value=\"Heraclito\">|<span id=\"spanetiq3\">Descartes</span><input type=\"radio\" name=\"control0\" value=\"Descartes\">|<span id=\"spanetiq4\">Aristoteles</span><input type=\"radio\" name=\"control0\" value=\"Aristoteles\">','Tales de mileto|Platon|Heraclito|Descartes|Aristoteles','Tales de mileto','1',1567538749),(7,'preg3','cuando es la composiciÃ³n quimica del agua',2,'<span id=\"spanetiq0\">seleccione: </span><select id=\"control0\" name=\"control0\"><option value=\"co2\">co2</option><option value=\"NH4\">NH4</option><option value=\"H2O\">H2O</option></select>','co2|NH4|H2O','H2O','1',1567540064),(6,'preg 2','cuales son los 3 colores primarios',3,'<span id=\"spanetiq0\">verde</span><input name=\"control0\" type=\"checkbox\" value=\"verde\">|<span id=\"spanetiq1\">rojo</span><input name=\"control1\" type=\"checkbox\" value=\"rojo\">|<span id=\"spanetiq2\">blanco</span><input name=\"control2\" type=\"checkbox\" value=\"blanco\">|<span id=\"spanetiq3\">azul</span><input name=\"control3\" type=\"checkbox\" value=\"azul\">|<span id=\"spanetiq4\">amarillo</span><input name=\"control4\" type=\"checkbox\" value=\"amarillo\">','verde|rojo|blanco|azul|amarillo','rojo','1',1567539505),(9,'preg 4','Cual es la capita de El Salvador',1,'<span id=\"spanetiq0\">respuesta: </span><input style=\"width:80px;height:18px\" type=\"text\" name=\"control0\">','','','1',1567540297),(10,'preg 5','Cuantos oceanos existen en la tierra',4,'<span id=\"spanetiq0\">6</span><input type=\"radio\" name=\"control0\" value=\"6\">|<span id=\"spanetiq1\">4</span><input type=\"radio\" name=\"control0\" value=\"4\">|<span id=\"spanetiq2\">5</span><input type=\"radio\" name=\"control0\" value=\"5\">|<span id=\"spanetiq3\">9</span><input type=\"radio\" name=\"control0\" value=\"9\">','6|4|5|9','5','1',1567540385),(11,'preg 6','Cual es el padre de la historia',1,'<span id=\"spanetiq0\">la respuesta es:</span><input style=\"width:80px;height:18px\" type=\"text\" name=\"control0\">','','','1',1567540450),(12,'preg 7','cuantos huesos tiene una persona adulta',2,'<span id=\"spanetiq0\">seleccione: </span><select id=\"control0\" name=\"control0\"><option value=\"209\">209</option><option value=\"225\">225</option><option value=\"206\">206</option><option value=\"214\">214</option></select>','209|225|206|214','206','1',1567540670),(13,'preg 8','cual es la capital de Peru',3,'<span id=\"spanetiq0\">Trujillo</span><input name=\"control0\" type=\"checkbox\" value=\"Trujillo\">|<span id=\"spanetiq1\">Arequipa</span><input name=\"control1\" type=\"checkbox\" value=\"Arequipa\">|<span id=\"spanetiq2\">Lima</span><input name=\"control2\" type=\"checkbox\" value=\"Lima\">','Trujillo|Arequipa|Lima','Lima','1',1567540722),(14,'pregunta numero 1','cuanto es 2+1',1,'<span id=\"spanetiq0\">seleccione:</span><input style=\"width:80px;height:18px\" type=\"text\" name=\"control0\">','','','1',1567544751),(15,'pregunta numero 2','cuantos es 3 +4',2,'<span id=\"spanetiq0\">seleccione:</span><select id=\"control0\" name=\"control0\"><option value=\"8\">8</option><option value=\"5\">5</option><option value=\"5\">5</option><option value=\"7\">7</option></select>','8|5|5|7','7','1',1567544836);

/*Table structure for table `w_priv` */

DROP TABLE IF EXISTS `w_priv`;

CREATE TABLE `w_priv` (
  `prv_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `prv_id` mediumint(8) unsigned NOT NULL,
  `prv_fcreg` int(10) unsigned NOT NULL,
  `prv_nomb` varchar(30) NOT NULL,
  `prv_desc` varchar(90) character set utf8 collate utf8_bin NOT NULL,
  KEY `prv_cod` (`prv_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `w_priv` */

/*Table structure for table `w_refe` */

DROP TABLE IF EXISTS `w_refe`;

CREATE TABLE `w_refe` (
  `ref_cod` mediumint(8) unsigned NOT NULL default '0',
  `ref_tip` char(2) character set utf8 collate utf8_bin NOT NULL default '',
  `ref_des` varchar(15) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`ref_cod`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `w_refe` */

/*Table structure for table `w_regval` */

DROP TABLE IF EXISTS `w_regval`;

CREATE TABLE `w_regval` (
  `rvl_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `rvl_scod` varchar(50) NOT NULL,
  `rvl_paso0` varchar(20) NOT NULL,
  `rvl_f_paso0` int(10) unsigned NOT NULL,
  `rvl_doi` varchar(20) NOT NULL,
  `rvl_blq` tinyint(3) unsigned default NULL,
  `rvl_paso1` varchar(20) default NULL,
  `rvl_f_paso1` int(10) unsigned default NULL,
  `rvl_o_prg` varchar(20) default NULL,
  `rvl_c_prg0` tinyint(3) unsigned default NULL,
  `rvl_f_prg0` int(10) unsigned default NULL,
  `rvl_t_prg0` varchar(150) default NULL,
  `rvl_r_p_prg0` varchar(50) default NULL,
  `rvl_a_r_prg0` varchar(250) default NULL,
  `rvl_c_r_prg0` tinyint(3) unsigned default NULL,
  `rvl_f_r_prg0` int(10) unsigned default NULL,
  `rvl_t_r_prg0` varchar(50) default NULL,
  `rvl_c_prg1` tinyint(3) unsigned default NULL,
  `rvl_f_prg1` int(10) unsigned default NULL,
  `rvl_t_prg1` varchar(150) default NULL,
  `rvl_r_p_prg1` varchar(50) default NULL,
  `rvl_a_r_prg1` varchar(250) default NULL,
  `rvl_c_r_prg1` tinyint(3) unsigned default NULL,
  `rvl_f_r_prg1` int(10) unsigned default NULL,
  `rvl_t_r_prg1` varchar(50) default NULL,
  `rvl_c_prg2` tinyint(3) unsigned default NULL,
  `rvl_f_prg2` int(10) unsigned default NULL,
  `rvl_t_prg2` varchar(150) default NULL,
  `rvl_r_p_prg2` varchar(50) default NULL,
  `rvl_a_r_prg2` varchar(250) default NULL,
  `rvl_c_r_prg2` tinyint(3) unsigned default NULL,
  `rvl_f_r_prg2` int(10) unsigned default NULL,
  `rvl_t_r_prg2` varchar(50) default NULL,
  `rvl_c_prg3` tinyint(3) unsigned default NULL,
  `rvl_f_prg3` int(10) unsigned default NULL,
  `rvl_t_prg3` varchar(150) default NULL,
  `rvl_r_p_prg3` varchar(50) default NULL,
  `rvl_a_r_prg3` varchar(250) default NULL,
  `rvl_c_r_prg3` tinyint(3) unsigned default NULL,
  `rvl_f_r_prg3` int(10) unsigned default NULL,
  `rvl_t_r_prg3` varchar(50) default NULL,
  `rvl_c_prg4` tinyint(3) unsigned default NULL,
  `rvl_f_prg4` int(10) unsigned default NULL,
  `rvl_t_prg4` varchar(150) default NULL,
  `rvl_r_p_prg4` varchar(50) default NULL,
  `rvl_a_r_prg4` varchar(250) default NULL,
  `rvl_c_r_prg4` tinyint(3) unsigned default NULL,
  `rvl_f_r_prg4` int(10) unsigned default NULL,
  `rvl_t_r_prg4` varchar(50) default NULL,
  `rvl_r_paso1` varchar(20) default NULL,
  `rvl_f_r_paso1` int(10) unsigned default NULL,
  `rvl_paso2` varchar(20) default NULL,
  `rvl_f_paso2` int(10) unsigned default NULL,
  `rvl_nc_cli` varchar(90) default NULL,
  `rvl_fc_cli` int(10) unsigned default NULL,
  `rvl_ub_cli` varchar(6) default NULL,
  `rvl_dr_cli` varchar(120) default NULL,
  `rvl_tl_cli` varchar(40) default NULL,
  `rvl_rt_cli` varchar(10) default NULL,
  `rvl_tm_cli` varchar(40) default NULL,
  `rvl_nm_usu` varchar(20) default NULL,
  `rvl_cn_usu` varchar(30) default NULL,
  `rvl_ce_usu` varchar(50) default NULL,
  `rvl_f_c_paso2` int(10) unsigned default NULL,
  `rvl_paso3` varchar(20) default NULL,
  `rvl_f_paso3` int(10) unsigned default NULL,
  `rvl_r_paso3` varchar(20) default NULL,
  `rvl_f_r_paso3` int(10) unsigned default NULL,
  `rvl_cc_usu` varchar(600) default NULL,
  PRIMARY KEY  (`rvl_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=905 DEFAULT CHARSET=latin1;

/*Data for the table `w_regval` */

/*Table structure for table `w_rpriv` */

DROP TABLE IF EXISTS `w_rpriv`;

CREATE TABLE `w_rpriv` (
  `rprv_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `rprv_idmod` mediumint(8) unsigned NOT NULL,
  `rprv_idusu` mediumint(8) unsigned NOT NULL,
  `rprv_perm` tinyint(3) unsigned NOT NULL,
  `rprv_cusu` mediumint(8) unsigned NOT NULL,
  `rprv_fcreg` int(10) unsigned NOT NULL,
  KEY `rprv_cod` (`rprv_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;

/*Data for the table `w_rpriv` */

/*Table structure for table `w_sedexusu` */

DROP TABLE IF EXISTS `w_sedexusu`;

CREATE TABLE `w_sedexusu` (
  `sdxus_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `sdxus_idsed` mediumint(8) unsigned NOT NULL,
  `sdxus_idusu` mediumint(8) unsigned NOT NULL,
  `sdxus_cusu` mediumint(8) unsigned NOT NULL,
  `sdxus_fcreg` int(10) unsigned NOT NULL,
  KEY `sdxus_cod` (`sdxus_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

/*Data for the table `w_sedexusu` */

/*Table structure for table `w_ubigeo` */

DROP TABLE IF EXISTS `w_ubigeo`;

CREATE TABLE `w_ubigeo` (
  `ubi_cod` varchar(6) NOT NULL,
  `ubi_dpto` varchar(2) NOT NULL,
  `ubi_prov` varchar(2) default NULL,
  `ubi_dist` varchar(2) default NULL,
  `ubi_ndpto` varchar(14) default NULL,
  `ubi_nprov` varchar(25) default NULL,
  `ubi_ndist` varchar(30) default NULL,
  PRIMARY KEY  (`ubi_cod`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `w_ubigeo` */

/*Table structure for table `w_usua` */

DROP TABLE IF EXISTS `w_usua`;

CREATE TABLE `w_usua` (
  `usu_cod` mediumint(8) unsigned NOT NULL auto_increment,
  `usu_cusu` mediumint(8) unsigned NOT NULL,
  `usu_nomb` varchar(75) character set utf8 collate utf8_bin default NULL,
  `usu_doc` varchar(20) NOT NULL,
  `usu_fnac` int(10) unsigned default NULL,
  `usu_dpto` char(2) default NULL,
  `usu_prov` char(2) default NULL,
  `usu_dist` char(2) default NULL,
  `usu_dir` varchar(100) character set utf8 collate utf8_bin default NULL,
  `usu_ctelf` mediumint(8) unsigned default NULL,
  `usu_cor_e` varchar(200) default NULL,
  PRIMARY KEY  (`usu_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `w_usua` */

insert  into `w_usua`(`usu_cod`,`usu_cusu`,`usu_nomb`,`usu_doc`,`usu_fnac`,`usu_dpto`,`usu_prov`,`usu_dist`,`usu_dir`,`usu_ctelf`,`usu_cor_e`) values (5,2,'hgola','3423423',1565913600,NULL,NULL,NULL,NULL,123123,'sdfsdfsd@sdfsdf.sdf'),(6,1,'asdad','asda',1565913600,NULL,NULL,NULL,NULL,123,'dasda');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
