forked from pavansolapure/opencodez-samples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschema.sql
More file actions
26 lines (23 loc) · 663 Bytes
/
schema.sql
File metadata and controls
26 lines (23 loc) · 663 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
--
-- MySQL
--
DROP TABLE IF EXISTS products;
CREATE TABLE products (
prd_id INT(10) NOT NULL AUTO_INCREMENT,
prd_name VARCHAR(150),
prd_price FLOAT,
PRIMARY KEY (prd_id)
);
ALTER TABLE orders AUTO_INCREMENT=1001;
DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
ord_id INT(10) NOT NULL AUTO_INCREMENT,
ord_date DATETIME DEFAULT CURRENT_TIMESTAMP,
prd_id INT(10) NOT NULL,
prd_price FLOAT,
PRIMARY KEY (ord_id)
);
ALTER TABLE orders AUTO_INCREMENT=10001;
INSERT INTO products (prd_name, prd_price) VALUES ('Product 1', 1199.95);
INSERT INTO products (prd_name, prd_price) VALUES ('Product 2', 11.95);
COMMIT;