Ensayo

drop database if exists ventaymantenimiento;
create database ventaymantenimiento;
use ventaymantenimiento;

create table cliente (id_cliente tinyint not null,
nit varchar(15) not null,
nombrevarchar(50) not null,
telefono varchar(15) not null,
direccion varchar (30) not null,
ciudad varchar (32) not null,
primary key (id_cliente));

insert into cliente values(1,'1032384426','MARISOL MENDOZA','4050100','CRR 73 N° 78-95','BOGOTA'),
(2,'1032386291','WILLIAM AMAYA','2211001','CLL 56 N°88_70','BOGOTA'),
(3,'1030543323','CAROLINA RUIZ','6200125','CLL 25 N° 40-95','BOGOTA');create table articulo(id_articulo tinyint not null,
articulo varchar (30) not null,
valorunitario int not null,
primary key (id_articulo));

insert into articulo values (1,'SAMSUNGSTAR','220000'),
(2,'SAMSUNG GALAXY ACE','540000'),
(3,'NOKIA C3','490000');

create table salida(id_salida tinyint not null,
numerosalida tinyint not null,
fechaventa date not null,
valortotal int notnull,
cod_cliente smallint not null,
primary key (id_salida),
foreign key (cod_cliente)
references cliente(id_cliente));

insert into salida values (1,'0001','2012/07/10','440000',1),(2,'0002','2012/07/17','1620000',2),
(3,'0003','2012/07/26','2450000',3);

create table detallesalida(id_detallesalida tinyint not null,
cantidadventa smallint not null,
cod_articulo tinyint not null,cod_salida tinyint not null,
primary key (id_detallesalida),
foreign key (cod_articulo)
references articulo(id_articulo),
foreign key (cod_salida)
references salida(id_salida));

insert intodetallesalida values (1,'1',1,1),
(2,'2',2,2),
(3,'3',3,3);

create table servicio(id_servicio tinyint not null,
numerodeorden smallint not null,
fecharegistro date not null,
valortotalservicioint not null,
fechaentrega date not null,

cod_cliente smallint not null,
primary key (id_servicio),
foreign key (cod_cliente)
references cliente(id_cliente));

insert into servicio values...