-
Notifications
You must be signed in to change notification settings - Fork 0
/
sql.txt
68 lines (56 loc) · 1.44 KB
/
sql.txt
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
mysql -u root
create database charliestore;
use charliestore;
create table customers
(
customerid int not null auto_increment,
firstname varchar(50),
middlename varchar(50),
lastname varchar(50),
dateofbirth date,
gender varchar(20),
phone varchar(20),
email varchar(100),
address1 varchar(200),
address2 varchar(200),
pincode varchar(15),
city varchar(100),
statename varchar(100),
country varchar(100),
payment varchar(100),
userpassword varchar(255),
primary key (customerid)
);
create table products
(
productid int not null auto_increment,
productname varchar(75),
productimage varchar(255),
manufacturingdate date,
inventoryquantity int,
priceperunit decimal(10, 3),
tags varchar(200),
primary key (productid)
);
create table admin
(
adminid int not null auto_increment,
adminname varchar(200),
adminpassword varchar(255),
primary key (adminid)
);
insert into admin (adminname, adminpassword) values ('mihika', 'mihika831');
insert into admin (adminname, adminpassword) values ('dheeraj', 'dheeraj1234');
create table feedback
(
feedbackid int not null auto_increment,
name varchar(200),
email varchar(200),
phone varchar(50),
orderid varchar(100),
deliveryspeed varchar(100),
delieveryexp varchar(100),
packaging varchar(100),
quality varchar(100),
primary key (feedbackid)
);