notes

CREATE DATABASE onlyphones;

use onlyphones;

CREATE TABLE `mobile_dtls` (
  `mobileId` INT NOT NULL AUTO_INCREMENT,
  `mobileName` VARCHAR(100) DEFAULT NULL,
  `brand` VARCHAR(100) DEFAULT NULL,
  `price` DECIMAL(10,2) DEFAULT NULL,
  `mobileCategory` VARCHAR(45) DEFAULT NULL,
  `status` VARCHAR(45) DEFAULT NULL,
  `photo` MEDIUMBLOB DEFAULT NULL,
  `user_email` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`mobileId`)
);

CREATE TABLE `cart` (
  `cid` int NOT NULL AUTO_INCREMENT,
  `mid` int DEFAULT NULL,
  `uid` int DEFAULT NULL,
  `mobileName` varchar(45) DEFAULT NULL,
  `brand` varchar(45) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `total_price` double DEFAULT NULL,
  PRIMARY KEY (`cid`)
);

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `phno` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `address` varchar(45) DEFAULT NULL,
  `landmark` varchar(45) DEFAULT NULL,
  `city` varchar(45) DEFAULT NULL,
  `state` varchar(45) DEFAULT NULL,
  `pincode` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `onlyphones`.`mobile_order` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `order_id` VARCHAR(45) NULL,
  `user_name` VARCHAR(45) NULL,
  `email` VARCHAR(45) NULL,
  `address` VARCHAR(45) NULL,
  `phno` VARCHAR(45) NULL,
  `mobile_name` VARCHAR(45) NULL,
  `brand` VARCHAR(45) NULL,
  `price` VARCHAR(45) NULL,
  `payment` VARCHAR(45) NULL,
  PRIMARY KEY (`id`)
);