-- phpMyAdmin SQL Dump -- version 4.7.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 23, 2018 at 03:41 AM -- Server version: 10.1.24-MariaDB -- PHP Version: 7.1.6 SET 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: `spares` -- -- -------------------------------------------------------- -- -- Table structure for table `cart` -- CREATE TABLE `cart` ( `id` int(11) NOT NULL, `tr_id` varchar(250) NOT NULL, `pro_id` varchar(150) NOT NULL, `qty` int(11) NOT NULL, `price` decimal(10,2) NOT NULL, `status` varchar(30) NOT NULL DEFAULT 'cartadd' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` int(12) NOT NULL, `cat_name` varchar(80) NOT NULL, `status` varchar(30) NOT NULL DEFAULT 'active', `cat_Desc` varchar(880) NOT NULL, `path` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `cat_name`, `status`, `cat_Desc`, `path`) VALUES (1, 'Brearings', 'active', ' Bearings section ', 'uploads/category/365all-product2.png'); -- -------------------------------------------------------- -- -- Table structure for table `login` -- CREATE TABLE `login` ( `id` int(11) NOT NULL, `name` varchar(60) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(30) NOT NULL, `rights` varchar(20) NOT NULL, `phone` varchar(30) NOT NULL, `email` varchar(80) NOT NULL, `status` varchar(30) NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `login` -- INSERT INTO `login` (`id`, `name`, `username`, `password`, `rights`, `phone`, `email`, `status`) VALUES (1, 'SPARES', 'admin', 'admin', 'admin', '', '', 'active'); -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `id` int(12) NOT NULL, `cat_id` int(30) NOT NULL, `scat_id` varchar(250) NOT NULL, `pro_name` varchar(250) NOT NULL, `status` varchar(30) NOT NULL, `path` varchar(550) NOT NULL, `pro_desc` text NOT NULL, `price` decimal(10,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `sub_category` -- CREATE TABLE `sub_category` ( `id` int(250) NOT NULL, `cat_id` varchar(250) NOT NULL, `scat_name` varchar(250) NOT NULL, `scat_img` varchar(250) NOT NULL, `scat_desc` text NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `uid` int(250) NOT NULL, `uname` varchar(250) NOT NULL, `uusername` varchar(250) NOT NULL, `upassword` varchar(250) NOT NULL, `urights` varchar(30) NOT NULL DEFAULT 'user', `ucontact` varchar(250) NOT NULL, `uemail` varchar(250) NOT NULL, `ustatus` varchar(40) NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`uid`, `uname`, `uusername`, `upassword`, `urights`, `ucontact`, `uemail`, `ustatus`) VALUES (1, 'user', 'user', 'user123', 'user', '9688852551', '', 'active'), (2, 'mani', 'laxman', 'LAXMAN', 'user', '9688854551', 'dlakshmananbe@gmail.com', 'active'), (3, 'kumar', 'kumar', 'kumar', 'user', '9688834334', 'kumar@gmail.com', 'active'); -- -------------------------------------------------------- -- -- Table structure for table `user_login` -- CREATE TABLE `user_login` ( `id` int(250) NOT NULL, `name` varchar(250) NOT NULL, `useremail` varchar(250) NOT NULL, `password` varchar(250) NOT NULL, `rights` varchar(90) NOT NULL DEFAULT 'user', `phone` varchar(90) NOT NULL, `address` text NOT NULL, `status` varchar(90) NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_login` -- INSERT INTO `user_login` (`id`, `name`, `useremail`, `password`, `rights`, `phone`, `address`, `status`) VALUES (1, 'laxman', 'laxman@gmail.com', 'laxman123', 'user', '9688852551', 'erode', 'active'), (7, 'demo', 'demo@gmail.com', 'demo123', 'user', '256794', 'qwefqjskf', 'active'); -- -------------------------------------------------------- -- -- Table structure for table `wish_list` -- CREATE TABLE `wish_list` ( `id` int(250) NOT NULL, `tr_id` varchar(250) NOT NULL, `pro_id` varchar(250) NOT NULL, `status` varchar(250) NOT NULL DEFAULT 'addwish' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `wish_list` -- INSERT INTO `wish_list` (`id`, `tr_id`, `pro_id`, `status`) VALUES (25, '7', '1', 'addwish'); -- -- Indexes for dumped tables -- -- -- Indexes for table `cart` -- ALTER TABLE `cart` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `login` -- ALTER TABLE `login` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_category` -- ALTER TABLE `sub_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`uid`); -- -- Indexes for table `user_login` -- ALTER TABLE `user_login` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wish_list` -- ALTER TABLE `wish_list` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `cart` -- ALTER TABLE `cart` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `login` -- ALTER TABLE `login` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sub_category` -- ALTER TABLE `sub_category` MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `uid` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `user_login` -- ALTER TABLE `user_login` MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `wish_list` -- ALTER TABLE `wish_list` MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;