HQ8fGxft

1CREATE TABLE IF NOT EXISTS USUARIO( Email varchar(50),Password varchar(50),Nombre varchar(50),Apellidos varchar(50),PRIMARY KEY(Email))engine=innodb;
2    CREATE TABLE IF NOT EXISTS CRIPTOMONEDAS(ID VARCHAR(10),NOMBRE VARCHAR(50) NULL,PRIMARY KEY(ID))engine=innodb;
3    CREATE TABLE IF NOT EXISTS LCRIPTO(ID VARCHAR(10),EMAIL VARCHAR(50),PRIMARY KEY(ID,EMAIL),FOREIGN KEY(ID) REFERENCES CRIPTOMONEDAS(ID) ON DELETE CASCADE,FOREIGN KEY(EMAIL) REFERENCES USUARIO(EMAIL) ON DELETE CASCADE)engine=innodb;
4    CREATE TABLE IF NOT EXISTS PERFILES(EMAIL VARCHAR(50),NOMPERFIL VARCHAR(50),FOTOPERFIL VARCHAR(50), TIPOPERFIL VARCHAR(50),CANTIDAD NUMERIC(9) NULL,PRIMARY KEY(EMAIL,NOMPERFIL), FOREIGN KEY (EMAIL) REFERENCES USUARIO(EMAIL) ON DELETE CASCADE ON UPDATE CASCADE)engine=innodb;
5    CREATE TABLE IF NOT EXISTS PARES(ID VARCHAR(10), BASECURRENCY VARCHAR(10), QUOTECURRENCY VARCHAR(10), PRIMARY KEY(ID))engine=innodb;
6    CREATE TABLE IF NOT EXISTS LPARES(ID VARCHAR(10), NOMPERFIL VARCHAR(50), PRIMARY KEY(ID, NOMPERFIL), FOREIGN KEY(ID) REFERENCES PARES(ID) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY(NOMPERFIL) REFERENCES PERFILES(NOMPERFIL) ON DELETE CASCADE);
7    CREATE TABLE IF NOT EXISTS TRANSACCIONES(EMAIL VARCHAR(50),NOMPERFIL VARCHAR(50),NOMBREPAR VARCHAR(10),TIPOCOMPRA VARCHAR(15),FECHA DATETIME,CANTIDAD DOUBLE,PRECIO DOUBLE,PRIMARY KEY(EMAIL,NOMPERFIL,FECHA),FOREIGN KEY(EMAIL) REFERENCES USUARIO (EMAIL) ON DELETE CASCADE ,FOREIGN KEY (NOMPERFIL) REFERENCES PERFILES(NOMPERFIL) ON DELETE CASCADE);