/* ### Atish Pawar - 05-09-19 */ ALTER TABLE `user` CHANGE `userId` `user_id` INT(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `user` CHANGE `otpuser` `otp_user` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `user` CHANGE `c_date` `created` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; ALTER TABLE `user` ADD `last_login` DATETIME NULL DEFAULT NULL AFTER `created`; ALTER TABLE `user` CHANGE `name` `user_name` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; -- -- Host: 127.0.0.1 -- Generation Time: Sep 09, 2019 at 01:23 PM -- Server version: 10.1.32-MariaDB -- PHP Version: 5.6.36 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: `lyngum_web` -- -- -------------------------------------------------------- -- -- Table structure for table `product_images` -- CREATE TABLE `product_images` ( `product_images_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `image_name` varchar(150) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`product_images_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `product_images_id` int(11) NOT NULL AUTO_INCREMENT; 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 */; ALTER TABLE `product_images` ADD FOREIGN KEY (`product_id`) REFERENCES `product`(`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `category` CHANGE `c_date` `created` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; ALTER TABLE `subcategory` CHANGE `c_date` `created` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; ALTER TABLE `product_images` ADD FOREIGN KEY (`product_id`) REFERENCES `product`(`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `cart` ADD FOREIGN KEY (`user_id`) REFERENCES `user`(`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- phpMyAdmin SQL Dump -- version 4.8.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Sep 13, 2019 at 02:57 PM -- Server version: 10.1.32-MariaDB -- PHP Version: 5.6.36 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: `lyngum_web_1` -- -- -------------------------------------------------------- -- -- Table structure for table `wishlish` -- CREATE TABLE `wishlish` ( `cart_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `is_deleted` int(1) NOT NULL DEFAULT '0', `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `wishlish` -- ALTER TABLE `wishlish` ADD PRIMARY KEY (`cart_id`), ADD KEY `product_id` (`product_id`), ADD KEY `user_id` (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `wishlish` -- ALTER TABLE `wishlish` MODIFY `cart_id` int(11) NOT NULL AUTO_INCREMENT; 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 */; ALTER TABLE `wishlish` ADD FOREIGN KEY (`product_id`) REFERENCES `product`(`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `wishlish` ADD FOREIGN KEY (`user_id`) REFERENCES `user`(`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `wishlish` CHANGE `cart_id` `wishlish_id` INT(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `cart` ADD `coupon_code` INT(5) NULL DEFAULT NULL AFTER `quantity`; ALTER TABLE `cart` ADD `coupon_code` INT(11) NULL DEFAULT NULL AFTER `quantity`; -- phpMyAdmin SQL Dump -- version 4.8.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Sep 20, 2019 at 12:10 PM -- Server version: 10.1.32-MariaDB -- PHP Version: 5.6.36 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: `lyngum_web_1` -- -- -------------------------------------------------------- -- -- Table structure for table `coupon` -- CREATE TABLE `coupon` ( `coupon_id` int(11) NOT NULL, `coupon_code` varchar(150) NOT NULL, `is_deleted` int(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `coupon` -- ALTER TABLE `coupon` ADD PRIMARY KEY (`coupon_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `coupon` -- ALTER TABLE `coupon` MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT; 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 */; INSERT INTO `coupon` (`coupon_id`, `coupon_code`, `is_deleted`, `created`) VALUES (NULL, 'LyGM00001', '0', CURRENT_TIMESTAMP), (NULL, 'LyGM00002', '0', CURRENT_TIMESTAMP); INSERT INTO `coupon` (`coupon_id`, `coupon_code`, `is_deleted`, `created`) VALUES (NULL, 'LyGM00003', '0', CURRENT_TIMESTAMP), (NULL, 'LyGM00004', '0', CURRENT_TIMESTAMP); ALTER TABLE `cart` CHANGE `coupon_code` `coupon_id` INT(11) NULL DEFAULT NULL; ALTER TABLE `coupon` ADD `coupon_price` INT(5) NULL DEFAULT '0' AFTER `coupon_code`; ALTER TABLE `address` ADD `mobile_number` INT(11) NULL DEFAULT NULL AFTER `pincode`; /* Atish Pawar 12-10-19 */ ALTER TABLE `payments` CHANGE `product_id` `product_id` VARCHAR(150) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL; ALTER TABLE `orders` CHANGE `order_accepted` `order_accepted` INT(1) NOT NULL DEFAULT '0', CHANGE `is_international` `is_international` INT(1) NOT NULL DEFAULT '0', CHANGE `cgst_id` `cgst_id` INT(2) NULL DEFAULT NULL, CHANGE `sgst_id` `sgst_id` INT(2) NULL DEFAULT NULL, CHANGE `igst_id` `igst_id` INT(2) NULL DEFAULT NULL, CHANGE `cgst_value` `cgst_value` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `sgst_value` `sgst_value` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `igst_value` `igst_value` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `orders` ADD `total_items` INT(3) NULL DEFAULT NULL AFTER `order_date`; ALTER TABLE `orders` CHANGE `coupon_id` `coupon_id` INT(11) NULL DEFAULT NULL, CHANGE `coupon_name` `coupon_name` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `coupon_price` `coupon_price` INT(11) NULL DEFAULT NULL; ALTER TABLE `wishlish` ADD FOREIGN KEY (`product_id`) REFERENCES `product`(`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `product` CHANGE `quantity` `quantity` INT(11) NOT NULL;