Dumping data for table 'ORDER' - mysql dump

Added on - 21 Sep 2019

  • 12

    pages

  • 2020

    words

  • 819

    views

  • 0

    downloads

Showing pages 4 of 12
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET AUTOCOMMIT = 0;START TRANSACTION;SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */;---- Database: `shopping`---- ------------------------------------------------------------ Table structure for table `admin`--CREATE TABLE `admin` (`id` int(11) NOT NULL,`username` varchar(255) NOT NULL,`password` varchar(255) NOT NULL,`creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2`updationDate` varchar(255) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Dumping data for table `admin`--INSERT INTO `admin` (`id`, `username`, `password`, `creationDate`, `updationDate`) VALUES(1, 'admin', 'f925916e2754e5e03f75dd58a5733251', '2017-01-18 16:21:18', '21-06-2019 08:27:55PM');-- ------------------------------------------------------------ Table structure for table `category`--CREATE TABLE `category` (`id` int(11) NOT NULL,`categoryName` varchar(255) DEFAULT NULL,`categoryDescription` longtext,`creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`updationDate` varchar(255) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;--
3-- Dumping data for table `category`--INSERT INTO `category` (`id`, `categoryName`, `categoryDescription`, `creationDate`,`updationDate`) VALUES(3, 'T-shirts', 'Testtees', '2018-01-10 19:17:37', '30-01-2020 12:22:24 AM'),(4, 'Full T-shirt', 'Electron like', '2017-01-08 19:19:32', '');-- ------------------------------------------------------------ Table structure for table `orders`--CREATE TABLE `orders` (`id` int(11) NOT NULL,`userId` int(11) DEFAULT NULL,`productId` varchar(255) DEFAULT NULL,`quantity` int(11) DEFAULT NULL,`orderDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`paymentMethod` varchar(50) DEFAULT NULL,`orderStatus` varchar(55) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Dumping data for table `orders`
4--INSERT INTO `orders` (`id`, `userId`, `productId`, `quantity`, `orderDate`, `paymentMethod`,`orderStatus`) VALUES(9, 4, '21', 1, '2019-08-15 05:12:16', 'Internet Banking', NULL);-- ------------------------------------------------------------ Table structure for table `ordertrackhistory`--CREATE TABLE `ordertrackhistory` (`id` int(11) NOT NULL,`orderId` int(11) DEFAULT NULL,`status` varchar(255) DEFAULT NULL,`remark` mediumtext,`postingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------------------------------------ Table structure for table `productreviews`--