gat7ktvs

1DROP DATABASE IF EXISTS cine;
2CREATE DATABASE cine;
3USE cine;
4
5CREATE TABLE pelicula (
6  Titulo char(255) NOT NULL,
7  Director char(255) NOT NULL ,
8  Actores char(255) NOT NULL,
9  Anyo int(4) NOT NULL,
10  Categoria char(255) NOT NULL,
11  PRIMARY KEY  (Titulo)
12);
13
14INSERT INTO pelicula VALUES 
15 ("Underworld","Len Wiseman","Kate Beckinsale, Scott Speedma Michael Sheen, Shane Brolly, Bill Nighy",2003,"Acción"),
16 ("Spiderman 3","Sam Raimi","Tobey Maguire, Kirsten Dunst, James Franco, Thomas Haden Church, Topher Grace, Bryce Dallas Howard",2007,"Acción"),
17 ("Avatar","James Cameron","Sam Worthington, Zoe Saldana, Stephen Lang, Michelle Rodriguez, Sigourney Weaver, Giovanni Ribisi, Joel David Moore, C. C. H. Pounder, Wes Studi, Laz Alonso",2009,"Ciencia ficción");
18
19CREATE TABLE ticket (
20  Titulo char(255) NOT NULL,
21  Butaca char(10) NOT NULL,
22  Sala char(25) NOT NULL,
23  Dia char(100) NOT NULL,
24  Hora char(20),
25 Precio char(10),
26  PRIMARY KEY (Butaca,Sala,Dia,Hora),
27FOREIGN KEY (Titulo) REFERENCES pelicula (Titulo)
28);
29
30INSERT INTO ticket VALUES 
31("Avatar","Butaca1","Sala3","28/01/2012","20-22","15.00");
32
33
34CREATE TABLE usuario (
35  Usuario char(50) NOT NULL,
36  Contrasenya char(50) NOT NULL ,
37  PRIMARY KEY  (Usuario)
38);
39
40INSERT INTO usuario VALUES 
41 ("usuario", "1234"),
42 ("usuario2", "1234"),
43 ("usuario3", "1234"),
44 ("usuario4", "1234");
45
46CREATE TABLE administrador (
47  Administrador char(50) NOT NULL,
48  Contrasenya char(50) NOT NULL ,
49  PRIMARY KEY  (Administrador)
50);
51
52 INSERT INTO administrador VALUES 
53 ("administrador", "1234"),
54 ("administrador2", "1234");