CREATE TEMPORARY TABLE order (
item_name VARCHAR(50) NOT NULL,
price DECIMAL(7,2) NOT NULL DEFAULT 0.00,
quantity INT UNSIGNED NOT NULL DEFAULT 0
);
DROP TABLE order;