SQLize | PHPize | SQLtest

create database BD_pedidos; use BD_pedidos; create table tb_Cliente( Nume_cliente bigint unsigned not null primary key auto_increment, direccion varchar (20) not null, saldo double(100,20) not null, limiteCredito double(202,00) not null, descuento int(10) not null ); create table tb_Articulo( Num_Articulo bigint unsigned not null primary key auto_increment, descripcion varchar (20) not null ); create table tb_fabrica( num_Fabrica bigint unsigned not null primary key auto_increment, telefono int (10) not null, total_Articulo double(100,20) ); create table tb_Pedidos( num_pedido bigint unsigned not null primary key auto_increment, fecha date not null, direccion varchar (20) not null, Nume_cliente bigint unsigned not null ); create table tb_detalle_Articulo( num_Detalle bigint unsigned not null primary key auto_increment, Num_Articulo bigint unsigned not null, num_pedido bigint unsigned not null, cantidad double(100,20) not null ); create table articulo_Fabrica( nume_Articulo bigint unsigned not null primary key auto_increment, Num_Articulo bigint unsigned not null, num_Fabrica bigint unsigned not null, existencia int (10) not null );