Codigo bd

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

CREATESCHEMA IF NOT EXISTS `la_mas_fashion` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;

-- -----------------------------------------------------
-- Table `la_mas_fashion`.`ASISTENCIA`
-------------------------------------------------------
DROP TABLE IF EXISTS `la_mas_fashion`.`ASISTENCIA` ;

CREATE TABLE IF NOT EXISTS `la_mas_fashion`.`ASISTENCIA` (
`IDA` INT UNSIGNED NOT NULLAUTO_INCREMENT ,
`FECHA` VARCHAR(45) NOT NULL ,
`HORA` VARCHAR(45) NOT NULL ,
`IDP` INT NOT NULL ,
`IDC` VARCHAR(45) NOT NULL ,
PRIMARY KEY (`IDA`) )
ENGINE = InnoDB;

-------------------------------------------------------
-- Table `la_mas_fashion`.`Participantes`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `la_mas_fashion`.`Participantes` ;CREATE TABLE IF NOT EXISTS `la_mas_fashion`.`Participantes` (
`IDP` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`NOMBRE` VARCHAR(45) NOT NULL ,
`APATERNO` VARCHAR(45) NOT NULL ,
`EMAIL`VARCHAR(45) NOT NULL ,
`ESTADO` TINYINT(1) NULL ,
`ASISTENCIA_IDA` INT NOT NULL ,
PRIMARY KEY (`IDP`, `ASISTENCIA_IDA`) ,
CONSTRAINT `fk_Participantes_ASISTENCIA`
FOREIGN KEY(`ASISTENCIA_IDA` )
REFERENCES `la_mas_fashion`.`ASISTENCIA` (`IDA` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

CREATE INDEX `fk_Participantes_ASISTENCIA` ON`la_mas_fashion`.`Participantes` (`ASISTENCIA_IDA` ASC) ;

-- -----------------------------------------------------
-- Table `la_mas_fashion`.`CONFERENCIAS`
-- -----------------------------------------------------DROP TABLE IF EXISTS `la_mas_fashion`.`CONFERENCIAS` ;

CREATE TABLE IF NOT EXISTS `la_mas_fashion`.`CONFERENCIAS` (
`IDC` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`NOMBRE` VARCHAR(45) NOT...