11 lines
382 B
SQL
11 lines
382 B
SQL
CREATE TABLE IF NOT EXISTS orders (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
company_name VARCHAR(255) NOT NULL,
|
|
contact_person VARCHAR(255) NOT NULL,
|
|
email VARCHAR(255) NOT NULL,
|
|
phone VARCHAR(255) NOT NULL,
|
|
quantity INT NOT NULL,
|
|
delivery_address TEXT NOT NULL,
|
|
order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
status VARCHAR(255) DEFAULT 'pending'
|
|
); |