Zapytanie: 

CREATE TABLE voip_tariffs ( id int(11) AUTO_INCREMENT, groupid int(11) NOT NULL, tariffid int(11) NOT NULL, price decimal(12,5) NOT NULL, unitsize smallint NOT NULL, FOREIGN KEY (groupid) REFERENCES voip_prefix_groups(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (tariffid) REFERENCES tariffs(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) ) ENGINE=InnoDB; 

Błąd: Can't create table 'lms.voip_tariffs' (errno: 150)

Zapytanie: 

CREATE TABLE voip_tariff_rules ( id int(11) AUTO_INCREMENT, groupid int(11) NOT NULL, tariffid int(11) NOT NULL, description text NULL, rule_settings text NULL, FOREIGN KEY (groupid) REFERENCES voip_prefix_groups(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (tariffid) REFERENCES tariffs(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) ) ENGINE=InnoDB

Błąd: Can't create table 'lms.voip_tariff_rules' (errno: 150)

Wystąpiły błędy w obsłudze bazy danych!

Zapytanie: 

CREATE TABLE voip_rules ( id int(11) NOT NULL AUTO_INCREMENT, name text NOT NULL, description text NULL, PRIMARY KEY (id) ) ENGINE=InnoDB; CREATE TABLE voip_group_rule_assignments ( id int(11) NOT NULL AUTO_INCREMENT, ruleid int(11) NOT NULL, groupid int(11) NOT NULL, rule_settings text NULL, FOREIGN KEY (ruleid) REFERENCES voip_rules(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (groupid) REFERENCES voip_prefix_groups(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) ) ENGINE=InnoDB; 

DROP TABLE IF EXISTS voip_tariff_rules; 

CREATE TABLE voip_tariff_rules ( id int(11) NOT NULL AUTO_INCREMENT, tarifid int(11) NOT NULL, ruleid int(11) NULL, FOREIGN KEY (tarifid) REFERENCES tariffs(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (ruleid) REFERENCES voip_rules(id) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (id) ) ENGINE=InnoDB;

Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE voip_group_rule_assignments ( id int(11) NOT NULL AUTO_INCREM' at line 8