Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create database analisis1;
- use analisis1;
- create table usuario(
- id varchar(15) not null unique primary key,
- paswd text not null,
- email varchar(256) not null unique,
- nombres text not null,
- apellidos text not null,
- creacion tIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP );
- drop table if exists proveedor;
- create table proveedor(
- nombreComercial varchar(128) not null,
- descripcion text not null,
- id_usuario varchar(15) not null
- );
- alter table proveedor add constraint
- fk_usuario_proveedor foreign key (id_usuario) references usuario(id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement