Code: Select all
<?php
create table Cart
(
CartId int(20) not null AUTO_INCREMENT,
CookieId varchar(50),
StyleID int(20) not null,
UsersID int(50) not null,
qty int,
primary key(CartID),
unique id(CartID)
);
create table Users(
UserID int(50) not null AUTO_INCREMENT,
UserName Varchar(100) not null,
Password Varchar(100) not null,
Location Varchar(100) not null,
Email Varchar(200) not null,
PhoneNumber Int(10) not null,
CreditCardNumber Int(20) not null,
CreditCardVerify Int(10) not null,
PRIMARY KEY (UserID),
UNIQUE(UserName)
)type=innodb;
?>