Comments (4)
hey did you got the sql file?
from shopping-cart.
from shopping-cart.
please check the readme.md file of this project @jatinraju @rashi2017
https://github.com/shashirajraja/shopping-cart
from shopping-cart.
create database shopping;
use shopping;
create table user(name varchar(20),mobile bigint(12),email varchar(40) primary key, address varchar(150),pincode integer(6),password varchar(20));
create table admin(username varchar(30) primary key, password varchar(30));
create table product(pid varchar(16) primary key,pname varchar(20),ptype varchar(20),pinfo varchar(150),pprice decimal(12,2),pquantity int(10),image blob);
create table usercart(username varchar(40), prodid varchar(16),quantity int(4));
create table admin(company varchar(30), email varchar(30), username varchar(30), password varchar(30));
alter table usercart add foreign key (prodid) references product(pid) on delete cascade;
alter table usercart add foreign key (username) references user(email) on delete cascade;
create table transactions(transid varchar(16) primary key,username varchar(40) references user(email) on delete cascade,time datetime, amount decimal(10,2));
create table orders(transid varchar(16) references transactions(transid) on delete cascade, prodid varchar(16) references product(pid) on delete cascade,quantity int(4), amount decimal(10,2), primary key(transid,prodid));
create table user_demand(username varchar(40) references user(email) on delete cascade, prodid varchar(16) references product(pid) on delete cascade, quantity int(4), primary key(username,prodid));
from shopping-cart.
Related Issues (10)
- where is the sql file dear.. i wanna try it HOT 1
- Security Bug(Cross Site Scripting)
- Malicious code vunerability HOT 1
- conn null HOT 1
- page not loading properly and content not loading // http status 404 HOT 2
- Issue HOT 1
- Permission to shashirajraja/shopping-cart.git denied to Nani6318 I want to use this project in my github portal HOT 1
- Possible null pointer dereference of conn in com.shashi.service.impl.UserServiceImpl.registerUser(UserBean)
- sendRedirect potnetial IOExcpetion thrown with no try-catch
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from shopping-cart.