Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.40, 5.5.41
-
None
-
Ubuntu 14.04
Description
When I'm trying to create such tables server is killed. Logs in attachment
Checked on two computers.
CREATE TABLE orders_products
(
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
orders_id INT UNSIGNED NOT NULL,
products_id TINYINT NOT NULL,
quantity SMALLINT UNSIGNED DEFAULT 0,
base_price DECIMAL(8,2) DEFAULT 0.00 NOT NULL,
amount DECIMAL(8,2) DEFAULT 0.00 NOT NULL,
FOREIGN KEY (orders_id) REFERENCES orders (id) ON DELETE RESTRICT ON UPDATE CASCADE,
FOREIGN KEY (products_id) REFERENCES products (id) ON DELETE RESTRICT ON UPDATE CASCADE
);
CREATE TABLE dashboard
(
id INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
created DATETIME NOT NULL,
createdby MEDIUMINT UNSIGNED NOT NULL,
modified DATETIME NOT NULL,
modifiedby MEDIUMINT UNSIGNED NOT NULL,
profiles_id INT UNSIGNED,
profiles_bookings_id INT UNSIGNED,
status TINYINT DEFAULT 0,
FOREIGN KEY (createdby) REFERENCES users (id) ON UPDATE CASCADE,
FOREIGN KEY (modifiedby) REFERENCES users (id) ON UPDATE CASCADE,
FOREIGN KEY (profiles_id) REFERENCES profiles (id) ON UPDATE CASCADE,
FOREIGN KEY (profiles_bookings_id) REFERENCES profiles_bookings (id) ON UPDATE CASCADE
);
I was trying already to drop database, recreate, etc.