Mantenimiento de Empleados - Mysql.

 Mantenimiento de Empleados - Mysql.

CREATE TABLE `empleado` (

`ced_emp` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,

`nom_emp` varchar(35) COLLATE utf8_spanish2_ci NOT NULL,

`ape_emp` varchar(35) COLLATE utf8_spanish2_ci NOT NULL,

`cel_emp` varchar(12) COLLATE utf8_spanish2_ci NOT NULL,

`email_emp` varchar(70) COLLATE utf8_spanish2_ci NOT NULL,

`dire_emp` varchar(250) COLLATE utf8_spanish2_ci NOT NULL,

`fec_ing` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,

`cargo` varchar(20) COLLATE utf8_spanish2_ci NOT NULL,

`sueldo` decimal(10,2) NOT NULL,

`foto` blob NOT NULL,

`ruta` varchar(100) COLLATE utf8_spanish2_ci NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

ALTER TABLE `empleado`

ADD PRIMARY KEY (`ced_emp`);

Si desea adquirir el codigo fuente y el script de la base de datos escribir a:

cgprognet@gmail.com

cgcg2006@gmail.com