SHARE
TWEET

Untitled

a guest Aug 18th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create database analisis1;
  2. use analisis1;
  3.  
  4. create table usuario(
  5.     id varchar(15) not null unique primary key,
  6.     paswd text  not null,
  7.     email  varchar(256) not null unique,
  8.     nombres text not null,
  9.     apellidos text not null,
  10.     creacion tIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP );
  11.  
  12. drop table if exists proveedor;
  13. create table proveedor(
  14.     nombreComercial varchar(128) not null,
  15.     descripcion    text not null,
  16.     id_usuario varchar(15) not null
  17.    
  18.  
  19. );
  20.  
  21.  
  22. alter table proveedor add constraint
  23. fk_usuario_proveedor foreign key (id_usuario) references usuario(id);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top