Código HTML:
--
-- Estructura de tabla para la tabla `personal`
--
CREATE TABLE `personal` (
`id_ode` varchar(4) collate latin1_spanish_ci NOT NULL default '',
`id_personal` int(11) NOT NULL auto_increment,
`usuario` varchar(50) collate latin1_spanish_ci default NULL,
`password` varchar(50) collate latin1_spanish_ci default NULL,
`paterno` varchar(100) collate latin1_spanish_ci default NULL,
`materno` varchar(100) collate latin1_spanish_ci default NULL,
`nombres` varchar(100) collate latin1_spanish_ci default NULL,
`dni` varchar(8) collate latin1_spanish_ci default NULL,
`fec_nac` date default '0000-00-00',
`sexo` char(1) collate latin1_spanish_ci default NULL,
`direccion` varchar(200) collate latin1_spanish_ci default NULL,
`id_departamento` int(11) default '0',
`id_provincia` int(11) default '0',
`id_distrito` int(11) default '0',
`telefono` varchar(20) collate latin1_spanish_ci default NULL,
`celular` varchar(20) collate latin1_spanish_ci default NULL,
`email` varchar(100) collate latin1_spanish_ci default NULL,
`profesion` varchar(100) collate latin1_spanish_ci default NULL,
`nombre_banco` varchar(100) collate latin1_spanish_ci default NULL,
`nro_cuenta` varchar(50) collate latin1_spanish_ci default NULL,
`fec_registro` datetime default '0000-00-00 00:00:00',
`ult_modificacion` datetime default '0000-00-00 00:00:00',
`num_logeadas` int(11) default '0',
`ult_acceso` datetime default '0000-00-00 00:00:00',
`ind_personal` char(1) collate latin1_spanish_ci default NULL,
`usuario_registro` int(11) default '0',
`usuario_ult_modificacion` int(11) default '0',
`tipo_user` char(1) collate latin1_spanish_ci default NULL,
`ip_acceso` varchar(15) collate latin1_spanish_ci default NULL,
`img_personal` varchar(50) collate latin1_spanish_ci default NULL,
`ind_gasto` char(1) collate latin1_spanish_ci default NULL,
`tipo_user_gasto` char(1) collate latin1_spanish_ci default NULL,
`usuario_gastos` varchar(50) collate latin1_spanish_ci default NULL,
`password_gastos` varchar(50) collate latin1_spanish_ci default NULL,
PRIMARY KEY (`id_ode`,`id_personal`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=310 ;