create database gente;
use gente;

create table centros(
Id_cap int not null auto_increment,
nombre varchar (30) not null,
localizacion varchar (30) not null,
cve_region int not null,
primary key (Id_cap))
engine=InnoDb;


create table actividad(
Id_ccm int not null auto_increment,
vertiente varchar (20)not null,
tex varchar(100) not null,
actividad varchar (50)not null,
primary key (Id_ccm))
engine=InnoDb;

create table gente(
Id_num_prog int not null auto_increment,
nombre varchar (20) not null,
rfc varchar (15) not null,
sex varchar (1) not null,
nvl_estudio varchar (30) not null,
grupo varchar(10) not null,
mun int not null,
nom_mun float not null,
loc int not null,
Id_cap int not null,
Id_ccm int not null,
nom_loc varchar (20),