S5BEQBZf

1// AdminTable
2CREATE TABLE IF NOT EXISTS `admin` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `email` varchar(255) NOT NULL,
5  `name` varchar(255) NOT NULL,
6  `password` varchar(255) NOT NULL,
7  PRIMARY KEY (`id`)
8);
9
10// CartTable
11CREATE TABLE IF NOT EXISTS `cart` (
12  `id` int(11) NOT NULL,
13  `email` varchar(255) NOT NULL,
14  `pname` varchar(255) NOT NULL,
15  `bprice` int(11) NOT NULL,
16  `quantity` int(11) NOT NULL,
17  `status` int(11) NOT NULL DEFAULT '0',
18  PRIMARY KEY (`id`)
19);
20
21// OrderTable
22CREATE TABLE IF NOT EXISTS `orders` (
23  `transid` varchar(20) NOT NULL,
24  `id` int(11) NOT NULL,
25  `email` varchar(255) NOT NULL,
26  `pname` varchar(255) NOT NULL,
27  `bprice` int(11) NOT NULL,
28  `quantity` int(11) NOT NULL,
29  `ptotal` int(11) NOT NULL,
30  `ordered_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
31  `order_status` int(11) NOT NULL DEFAULT '0',
32  `checkout_id` varchar(255) NOT NULL,
33  PRIMARY KEY (`transid`)
34);
35
36// ShoppingTable
37CREATE TABLE IF NOT EXISTS `shopping` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `pcategory` varchar(255) NOT NULL,
40  `pname` varchar(255) NOT NULL,
41  `pimg` varchar(255) NOT NULL,
42  `aprice` int(11) NOT NULL,
43  `bprice` int(11) NOT NULL,
44  PRIMARY KEY (`id`)
45);
46
47// UsersTable
48CREATE TABLE IF NOT EXISTS `users` (
49  `id` int(11) NOT NULL AUTO_INCREMENT,
50  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
51  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
52  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
53  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
54  `type` int(11) NOT NULL DEFAULT '0',
55  PRIMARY KEY (`id`),
56  UNIQUE KEY `email` (`email`)
57);
58
59