base de datos

4
+++++++++++++++++++++++++++++++++++++++++ + inserts act_min +++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++ + inserts actividades +++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++ + inserts bitacora +++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++ + inserts calles +++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++ + inserts cargos +++++++++++++++++++++++++++++++++++++++++ INSERT INTO cargors(id_cargo,cargo,status_cargo) VALUES(1,'coordinador',1), (2,'coordinador',1), (3,'director',1), (4,'subdirector',1), (5,'calidad',1), (6,'administrador',1), (7,'programador',1), (8,'diseñador',1), (9,'analitico',1), (10,'secretaria',1); +++++++++++++++++++++++++++++++++++++++++ + inserts cargos_personas +++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++ + inserts colonias +++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++ + inserts departamentos +++++++++++++++++++++++++++++++++++++++++ INSERT INTO departamentos(id_departamento,departamento,status,dep) VALUES(1,'trafico',1), (1,'trafico',1), (2,'logistica',1), (3,'diseño',1), (4,'administracion',1), (5,'recursos financieros',1), (6,'analisis',1),

Upload: berenice-barcena

Post on 05-Dec-2015

1 views

Category:

Documents


0 download

DESCRIPTION

Base de datos

TRANSCRIPT

Page 1: Base de Datos

++++++++++++++++++++++++++++++++++++++++++ inserts act_min+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts actividades+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts bitacora+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts calles+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts cargos+++++++++++++++++++++++++++++++++++++++++INSERT INTO cargors(id_cargo,cargo,status_cargo)

VALUES(1,'coordinador',1),(2,'coordinador',1),(3,'director',1),(4,'subdirector',1),(5,'calidad',1),(6,'administrador',1),(7,'programador',1),(8,'diseñador',1),(9,'analitico',1),(10,'secretaria',1);

++++++++++++++++++++++++++++++++++++++++++ inserts cargos_personas+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts colonias+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts departamentos+++++++++++++++++++++++++++++++++++++++++INSERT INTO departamentos(id_departamento,departamento,status,dep)

VALUES(1,'trafico',1),(1,'trafico',1),(2,'logistica',1),(3,'diseño',1),(4,'administracion',1),(5,'recursos financieros',1),(6,'analisis',1),(7,'direccion',1),(8,'marketing',1),(9,'ensamblado',1),(10,'free',1);

+++++++++++++++++++++++++++++++++++++++++

Page 2: Base de Datos

+ inserts direccion+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts empresas+++++++++++++++++++++++++++++++++++++++++INSERT INTO empresas(id_empresa,razsoc,logo,emp_act,status_emp)

VALUES(1,'lucrativa','la dedicacion',1,1),(2,'lucrativa','la dedicacion',2,1),(3,'lucrativa','que haces',3,1),(4,'lucrativa','el valor',4,1),(5,'lucrativa','satisfaccion',5,1),(6,'lucrativa','logistics',6,1),(7,'lucrativa','el mejor reto',7,1),(8,'lucrativa','tu lo sabes',8,1),(9,'lucrativa','ganame si puedes',9,1),(10,'lucrativa','lo que te mueve',10,1);

++++++++++++++++++++++++++++++++++++++++++ inserts estados+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts grupos+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts medios_comunicacion+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts minutas+++++++++++++++++++++++++++++++++++++++++

insert into minutas(id_min,id_per,fec_min,tema,obj_min,fec_pro_reu,id_min_ant,id_min_seg,cierre)

values(1,1,'1-09-2015','aulas','mejoramiento de aulas','2-09-2015',1,2,'2-09-2015'),(2,1,'2-09-2015','congreso','organizar el congreso','3-09-2015',1,3,'3-09-2015'),(3,1,'3-09-2015','visitas','establecer visitas a empresas','4-09-2015',2,4,'4-09-

2015'),(4,3,'4-09-2015','materias','organizar las materias','5-09-2015',3,5,'5-09-2015'),(5,1,'5-09-2015','horarios','organizar horarios','6-09-2015',4,6,'6-09-2015'),(6,2,'6-09-2015','aulas','organizar aulas para horarios','7-09-2015',5,7,'7-09-2015'),(7,4,'7-09-2015','veranos','crear grupos para veranos','8-09-2015',6,8,'8-09-2015'),(8,1,'8-09-2015','reinscripciones','organizar procesos de reinscripciones','9-09-

2015',1,2,'9-09-2015'),(9,4,'9-09-2015','maestros','organizar maestros para materias','10-09-

2015',7,9,'10-09-2015'),(10,6,'10-09-2015','creditos','organizar talleres para creditos','11-09-

2015',8,10,'11-09-2015';++++++++++++++++++++++++++++++++++++++++++ inserts motivo_termino_act+++++++++++++++++++++++++++++++++++++++++

Page 3: Base de Datos

++++++++++++++++++++++++++++++++++++++++++ inserts municipios+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts obs_min+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts orden_dia+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts per_min+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts personas+++++++++++++++++++++++++++++++++++++++++insert into personas(id_persona,nom_per,ape_pat_per,ape_mat_per,status_per)

values(1,'dany','fifo','fida',0),(2,'dany','flores','garduño',0),(3,'fer','ramos','bustamante',0),(4,'jushe','garcia','ramirez',0),(5,'sosa','hernandez','valdez',0),(6,'fany','camacho','hernandez',0),(7,'deisi','correa','sanchez',0),(8,'rosa','camacho','hernandez',0),(9,'denise','camacho','hernandez',0),(10,'cheess','camacho','hernandez',0);

++++++++++++++++++++++++++++++++++++++++++ inserts priv_gru+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts privilegios+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts seguimiento_actividades+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts tablas+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts usu_gru+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ inserts usuarios+++++++++++++++++++++++++++++++++++++++++

insert into usuarios(id_usuario,usuario,password,id_persona,status_usu,fec_clave)values(121,'fol','dawr',1,1,'LocalTime'),

(22,'tel','dawr',2,1,'LocalTime'),

Page 4: Base de Datos

(33,'rty','dawr',3,1,'LocalTime'),(44,'tel','dawr',2,1,'LocalTime'),(55,'res','dawr',4,1,'LocalTime'),(66,'fol','dawr',2,1,'LocalTime'),(77,'tte','dawr',5,1,'LocalTime'),(88,'ttel','dawr',1,1,'LocalTime')(99,'ttele','dawr',8,1,'LocalTime'),(100,'tteles','dawr',9,1,'LocalTime');

++++++++++++++++++++++++++++++++++++++++++ inserts comunicacion personas+++++++++++++++++++++++++++++++++++++++++