· 7 years ago · Nov 27, 2018, 11:50 AM
1
2CREATE TABLE IF NOT EXISTS `contacto` (
3 `contacto_id` int(5) unsigned zerofill NOT NULL AUTO_INCREMENT,
4 `paterno` varchar(30) NOT NULL,
5 `materno` varchar(30) NOT NULL,
6 `nombres` varchar(35) NOT NULL,
7 `correo` varchar(100) NOT NULL,
8 `direccion` varchar(100) NOT NULL,
9 `telefono_mobil` varchar(15) NOT NULL,
10 `telefono_fijo` varchar(15) NOT NULL,
11 `fecha_registro` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
12 PRIMARY KEY (`contacto_id`)
13) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;