Guia Mysql

drop database proyecto;

create database proyecto;

use proyecto;

create table personal
(idpersonal int primary key,
nombre varchar(20),
app varchar(20),
apm varchar(20),
estadovarchar(10))
engine=innodb;

create table alumnos
(matricula int primary key,
nombre varchar(20),
app varchar(20),
apm varchar(20),
carrera varchar(20),
generacion int,
grupo int,
cuatrimestreint,
estado varchar(10),
imagen varchar(20),
codigo varchar(15) default "AAAAAA00XXXX")
engine=innodb;

create table computadoras
(noserie varchar(15),
marca varchar(20),
modelo varchar(20),imagen varchar(20),
codigo varchar(15) default "AAAAAA00XXXX",
matricula int,
primary key(noserie,matricula),
foreign key (matricula)
references alumnos(matricula))
engine=innodb;

createtable historial
(id int primary key auto_increment,
entrada date,
HoraEn time,
salida date,
HoraSa time,
matricula int,
foreign key(matricula)
references alumnos(matricula))
engine=innodb;create table codigos
(codigo varchar(15) default "AAAAAA00XXXX",
matricula int,
noserie varchar(15),
primary key(matricula,noserie,codigo),
foreign key(matricula)
referencesalumnos(matricula),
foreign key(noserie)
references computadoras(noserie))
engine=innodb;

create table usuarios
(idusuario varchar(10) primary key,
nombre varchar(35),
password varchar(10),
fechaeventodate,
estatus varchar(10));

insert into usuarios values
('1rata','rata','ratota','2014-01-01','si');

insert into alumnos values
(1212130007,"Ismael","Reyes","Degante","Ing.Informatica",13,110501,5,"Inactivo","chabelo.jpg","ISREDE13295C"),
(1212130051,"Berenice","Ambrosio","Garduno","Ing. Informatica",13,110501,5,"Inactivo","bere.jpg","BEAMGA13639Q"),(1212130157,"Christian","Navarro","Pinon","Ing. Informatica",13,110501,5,"Inactivo","cris.jpg","CRNAPI130LT9"),
(1212130002,"Raziel","Hernandez","Arrazola","Ing. Informatica",13,110501,5,"Inactivo","batman.png","RAHEAR1321XW"),...