Muchas gracias Pirruman por las respuestas ;) no usaba constantes por que me imprimo la variable $Mastercreation para ver si toma el nombre de las variables y obtengo este resultado :
CREATE DATABASE gonzalo DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci USE gonzalo; CREATE TABLE IF NOT EXISTS amigos ( user1 char(12) NOT NULL, user2 char(12) NOT NULL, PRIMARY KEY (user1,user2) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS generos ( genero char(25) NOT NULL, PRIMARY KEY (genero) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS peliculas ( Nombre varchar(100) COLLATE utf8_spanish_ci NOT NULL, año varchar(4) COLLATE utf8_spanish_ci NOT NULL, genero varchar(15) COLLATE utf8_spanish_ci NOT NULL, descripcion text COLLATE utf8_spanish_ci NOT NULL, imagen int(11) NOT NULL, ID int(11) NOT NULL, Borrar tinyint(1) NOT NULL, PRIMARY KEY (`Nombre`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci; CREATE TABLE IF NOT EXISTS preferidas ( user char(12) NOT NULL, pelicula char(100) NOT NULL, id_film int(11) NOT NULL, PRIMARY KEY (user,pelicula) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS usuarios ( nombre varchar(20) COLLATE utf8_spanish_ci NOT NULL, apellido char(30) COLLATE utf8_spanish_ci NOT NULL, email char(50) COLLATE utf8_spanish_ci NOT NULL, user char(12) COLLATE utf8_spanish_ci NOT NULL, pass char(32) COLLATE utf8_spanish_ci NOT NULL, sexo char(1) COLLATE utf8_spanish_ci NOT NULL, favorito char(20) COLLATE utf8_spanish_ci NOT NULL, privilegios tinyint(1) NOT NULL COMMENT '1 = administrador 0 = usuario', estado tinyint(1) NOT NULL COMMENT '0 = activo 1 = inactivo', PRIMARY KEY (user) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci; INSERT INTO usuarios (nombre, apellido, email, user, pass, sexo, favorito, privilegios, estado) VALUES ('gonzalo', '202cb962ac59075b964b07152d234b70', '
[email protected]', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'M', 'Acción', 1, 0)
Gracias por sus aportes!