phpProyect/script.sql at master · Moffinguer/phpProyect · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
CREATE DATABASE IF NOT EXISTS TRABAJO;
CREATE TABLE `trabajo`.`disk` (
     `ID`     INT             NOT NULL AUTO_INCREMENT ,
     `NAME`   VARCHAR(30)     NOT NULL ,
     `GENRE`  VARCHAR(30)     NOT NULL ,
     `AUTHOR` VARCHAR(30)     NOT NULL ,
     `SONGS`  VARCHAR(100)    NOT NULL ,
     `PRIZE`  FLOAT           NOT NULL ,
     `STOCK`  INT             NOT NULL ,
     `IMAGE`  VARCHAR(21)     NOT NULL ,
          PRIMARY KEY (`ID`)) ENGINE = InnoDB;
CREATE TABLE `trabajo`.`users` (
     `DNI`      VARCHAR(9)      NOT NULL ,
     `NAME`     VARCHAR(30)     NOT NULL ,
     `SURNAME`  VARCHAR(50)     NOT NULL ,
     `USERNAME` VARCHAR(30)     NOT NULL ,
     `EMAIL`    VARCHAR(50)     NOT NULL ,
     `PASSWORD` VARCHAR(40)     NOT NULL ,
        PRIMARY KEY (`DNI`)) ENGINE = InnoDB;
RENAME TABLE `trabajo`.`disk` TO `trabajo`.`disks`;

INSERT INTO `users` (`DNI`, `NAME`, `SURNAME`, `USERNAME`, `EMAIL`, `PASSWORD`) VALUES
('07807198D', 'Fernando', 'Mateos', 'Fermago11', 'fer@gmail.com', 'pikachufriki14'),
('30696569X', 'Fernando', 'Mateos Gomez', 'Moffinguer', 'fermago11@gmail.com', 'admin1234'),
('53374687J', 'ADADSSA', 'ADASDAAS', 'potito', 'nuria@gmail.com', 'asadadadsa'),
('77826124N', 'Cunt', 'SexyPistolero', 'ChingaTumadre', 'fer@gmail.com', 'lolete');

INSERT INTO `disks` (`ID`, `NAME`, `GENRE`, `AUTHOR`, `SONGS`, `PRIZE`, `STOCK`, `IMAGE`) VALUES
(1, 'INCENSE AND IRON', 'POWER METAL', 'POWERWOLF', 'NO SE QUE PONER', 2000, 5, '../CSS/IMG/err.jpg'),
(2, 'YO', 'MIJO', 'NANAI', 'UWU', 49, 50, '../CSS/IMG/purple.jpg'),
(3, 'Sum41', 'HELL', 'WOLOLO', 'UWU OWO EWE', 30.69, 12, '../CSS/IMG/blue.jpg'),
(4, 'DISCOSTOPEGUAPOS', 'GENEROGENERICO', 'WOLOLO', 'UWU OWO EWE', 30.69, 12, '../CSS/IMG/blue.jpg'),
(5, 'PRUEBA1', 'FOLK', 'NO SE QUE METER', 'LOREM IPSUM A MOGOLLóN', 40.69, 134, '../CSS/IMG/blue.jpg');