-
Notifications
You must be signed in to change notification settings - Fork 1
/
database.sql
46 lines (40 loc) · 1.77 KB
/
database.sql
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
DROP DATABASE supplement_shop;
CREATE DATABASE IF NOT EXISTS supplement_shop;
USE supplement_shop;
-- CREATE TABLE user(
-- user_email VARCHAR (255) NOT NULL,
-- full_name VARCHAR (255),
-- billing_address VARCHAR (255),
-- shipping_address VARCHAR (255),
-- zip_code INT ,
-- country VARCHAR (255),
-- city VARCHAR (255),
-- user_password VARCHAR (255) NOT NULL,
-- permission_type VARCHAR (255) NOT NULL,
-- CONSTRAINT PRIMARY KEY (user_email)
-- )ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE users(
user_id INT (20) NOT NULL AUTO_INCREMENT,
full_name VARCHAR (255),
user_email VARCHAR (255) NOT NULL,
address VARCHAR (255),
zip_code INT ,
city VARCHAR (255),
user_password VARCHAR (255) NOT NULL,
permission_type VARCHAR (255) NOT NULL,
CONSTRAINT PRIMARY KEY (user_id)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- INSERT INTO user VALUES ('[email protected]','Jamith Nimantha','No 150,Kanamptiya Road',null ,80000,'Sri Lanka','Galle','123456','admin');
INSERT INTO users VALUES (1,''Jamith Nimantha','[email protected]','No 150,Kanamptiya Road',80000,'Galle','123456','admin');
-- SELECT * FROM users WHERE user_email='[email protected]' AND user_password='123456' AND permission_type='admin';'
CREATE TABLE products(
product_id INT (255) NOT NULL AUTO_INCREMENT,
product_name VARCHAR (255),
product_description VARCHAR (255),
product_qty INT ,
product_price DECIMAL,
product_image_path VARCHAR (255),
CONSTRAINT PRIMARY KEY (product_id)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO products(product_name,product_description,product_qty,product_price,product_image_path) VALUES('Anchor','milk powder',234,234.45,"path");
-- INSERT INTO products(product_name,product_description,product_qty,product_price,product_image_path) VALUES('{}','{}',{},{},"{}")