Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create user Usuario
- identified by 123
- default tablespace Transfer
- temporary tablespace temp;
- grant resource, connect, create view to Usuario;
- Create table Usuario
- (
- nick varchar2(30) primary key,
- nombre varchar2 (30),
- clave varchar2 (10),
- email nchar(30)
- );
- Create table Comentario
- (
- id int primary key,
- texto varchar2(30),
- fecha date,
- nick varchar2(30) references Usuario
- );
- Create table Foto
- (
- archivo varchar2(30) primary key,
- descripcion varchar2(30)
- );
- Create table Aparicion
- (
- nick varchar2(30) references Usuario,
- archivo varchar2(30) references Foto,
- coord nchar
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement