Kod
CREATE TABLE sklep_shedule (
idShedule int(11) NOT NULL auto_increment,
sName varchar(255) default NULL,
idConnection int(11) NOT NULL default '0',
dDateFrom date default NULL,
dDateTo date default NULL,
sStartTime varchar(5) default NULL,
fPrice float(10,2) NOT NULL default '0.00',
bMon enum('0','1') NOT NULL default '0',
bTue enum('0','1') NOT NULL default '0',
bWed enum('0','1') NOT NULL default '0',
bThu enum('0','1') NOT NULL default '0',
bFri enum('0','1') NOT NULL default '0',
bSat enum('0','1') NOT NULL default '0',
bSun enum('0','1') NOT NULL default '0',
PRIMARY KEY (idShedule),
KEY key_idconnection (idConnection),
CONSTRAINT `sklep_shedule_ibfk_1` FOREIGN KEY (`idConnection`) REFERENCES `sklep_connection` (`idConnection`)
) TYPE=InnoDB;
oraz błąd idShedule int(11) NOT NULL auto_increment,
sName varchar(255) default NULL,
idConnection int(11) NOT NULL default '0',
dDateFrom date default NULL,
dDateTo date default NULL,
sStartTime varchar(5) default NULL,
fPrice float(10,2) NOT NULL default '0.00',
bMon enum('0','1') NOT NULL default '0',
bTue enum('0','1') NOT NULL default '0',
bWed enum('0','1') NOT NULL default '0',
bThu enum('0','1') NOT NULL default '0',
bFri enum('0','1') NOT NULL default '0',
bSat enum('0','1') NOT NULL default '0',
bSun enum('0','1') NOT NULL default '0',
PRIMARY KEY (idShedule),
KEY key_idconnection (idConnection),
CONSTRAINT `sklep_shedule_ibfk_1` FOREIGN KEY (`idConnection`) REFERENCES `sklep_connection` (`idConnection`)
) TYPE=InnoDB;
Kod
ERROR 1005 (HY000): Can't create table './et/sklep_connection.frm' (errno: 150)
i
Kod
CREATE TABLE sklep_connection (
idConnection int(11) NOT NULL auto_increment,
idCarrier int(11) NOT NULL default '0',
sName varchar(255) default NULL,
idStartCity int(11) NOT NULL default '0',
sStartPlace varchar(255) default NULL,
idEndCity int(11) NOT NULL default '0',
sEndPlace varchar(255) default NULL,
bTransPlane enum('0','1') default '0',
bTransFerry enum('0','1') default '0',
bTransBus enum('0','1') default '0',
sLuggage varchar(100) default NULL,
bFerry enum('0','1') default '0',
bTunnel enum('0','1') default '0',
PRIMARY KEY (idConnection),
KEY key_idcarrier (idCarrier),
KEY key_idstartcity (idStartCity),
KEY key_idendcity (idEndCity),
CONSTRAINT `sklep_connection_ibfk_1` FOREIGN KEY (`idCarrier`) REFERENCES `sklep_carrier` (`idCarrier`),
CONSTRAINT `sklep_connection_ibfk_2` FOREIGN KEY (`idStartCity`) REFERENCES `sklep_city` (`idCity`),
CONSTRAINT `sklep_connection_ibfk_3` FOREIGN KEY (`idEndCity`) REFERENCES `sklep_city` (`idCity`)
) TYPE=InnoDB;
i błąd idConnection int(11) NOT NULL auto_increment,
idCarrier int(11) NOT NULL default '0',
sName varchar(255) default NULL,
idStartCity int(11) NOT NULL default '0',
sStartPlace varchar(255) default NULL,
idEndCity int(11) NOT NULL default '0',
sEndPlace varchar(255) default NULL,
bTransPlane enum('0','1') default '0',
bTransFerry enum('0','1') default '0',
bTransBus enum('0','1') default '0',
sLuggage varchar(100) default NULL,
bFerry enum('0','1') default '0',
bTunnel enum('0','1') default '0',
PRIMARY KEY (idConnection),
KEY key_idcarrier (idCarrier),
KEY key_idstartcity (idStartCity),
KEY key_idendcity (idEndCity),
CONSTRAINT `sklep_connection_ibfk_1` FOREIGN KEY (`idCarrier`) REFERENCES `sklep_carrier` (`idCarrier`),
CONSTRAINT `sklep_connection_ibfk_2` FOREIGN KEY (`idStartCity`) REFERENCES `sklep_city` (`idCity`),
CONSTRAINT `sklep_connection_ibfk_3` FOREIGN KEY (`idEndCity`) REFERENCES `sklep_city` (`idCity`)
) TYPE=InnoDB;
Kod
ERROR 1005 (HY000): Can't create table './et/sklep_shedule.frm' (errno: 150)
podejrzewam, że coś z kluczami głównymi, ale nie ogarniam tego, może ktoś wie jak temu zaradzić?