-- phpMyAdmin SQL Dump -- version 4.9.0.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Aug 26, 2020 at 04:18 PM -- Server version: 10.4.6-MariaDB -- PHP Version: 7.1.31 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: `pharmastore` -- -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `clients` -- CREATE TABLE `clients` ( `client_id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `last_name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `country` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `city` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `zip` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `address` text COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `discounts` -- CREATE TABLE `discounts` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` int(11) NOT NULL, `client_id` int(11) DEFAULT NULL, `type` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `categories` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `amount` double(8,2) NOT NULL, `minPurchase` double(8,2) NOT NULL DEFAULT 0.00, `description` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `image` varchar(191) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `generic_names` -- CREATE TABLE `generic_names` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `payload` longtext COLLATE utf8_unicode_ci NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `medicine_groups` -- CREATE TABLE `medicine_groups` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `order_id` bigint(20) UNSIGNED NOT NULL, `order_number` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `customer_id` int(11) DEFAULT NULL, `payment_type` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `subtotal` double(8,2) NOT NULL, `total_discount` double(8,2) DEFAULT NULL, `tax_pct` double(8,2) DEFAULT NULL, `total_tax` double(8,2) DEFAULT NULL, `delivery_charge` double(8,2) DEFAULT NULL, `grandtotal` double(8,2) NOT NULL, `status` tinyint(4) NOT NULL, `payment_status` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `order_by` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `payment_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_policy` -- CREATE TABLE `order_policy` ( `id` bigint(20) UNSIGNED NOT NULL, `policy` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `slug` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_products` -- CREATE TABLE `order_products` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `qty` int(11) NOT NULL, `price` double(8,2) NOT NULL, `total` double(8,2) NOT NULL, `discount_type` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `discount` double(8,2) DEFAULT NULL, `grand_total` double(8,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `token` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payments` -- CREATE TABLE `payments` ( `payment_id` bigint(20) UNSIGNED NOT NULL, `card_customer` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `card_charge_id` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `card_paid` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `card_payment_method` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_methods` -- CREATE TABLE `payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `type` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `image` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `group_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `image` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `purchasePrice` double(8,2) NOT NULL, `sellingPrice` double(8,2) NOT NULL, `storeBox` int(11) NOT NULL, `itemsNumber` int(11) NOT NULL, `itemsSaleCount` int(11) DEFAULT NULL, `generic_id` int(11) NOT NULL, `supplier_id` int(11) NOT NULL, `description` text COLLATE utf8_unicode_ci DEFAULT NULL, `status` tinyint(4) NOT NULL, `totalPurchedItem` int(11) NOT NULL, `expireDate` date NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `website` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `address` text COLLATE utf8_unicode_ci NOT NULL, `delivery_charge` int(11) NOT NULL, `currency_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `currency_symbol` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `shipping_methods` -- CREATE TABLE `shipping_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `type` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier` -- CREATE TABLE `supplier` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `address` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier_invoices` -- CREATE TABLE `supplier_invoices` ( `id` bigint(20) UNSIGNED NOT NULL, `invoice_no` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `company_id` int(11) NOT NULL, `sum_subtotal` double(8,2) NOT NULL, `sum_discount` double(8,2) NOT NULL, `sum_grandtotal` double(8,2) NOT NULL, `tax_percent` int(11) NOT NULL, `tax_amount` double(8,2) NOT NULL, `created_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `supplier_invoice_productinfo` -- CREATE TABLE `supplier_invoice_productinfo` ( `id` bigint(20) UNSIGNED NOT NULL, `invoice_id` int(11) NOT NULL, `invoice_no` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `product_id` int(11) NOT NULL, `qty_product` int(11) NOT NULL, `unit_price` double(8,2) NOT NULL, `subtotal_product` double(8,2) NOT NULL, `discount_type` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `discount_product` double(8,2) NOT NULL, `grandtotal_product` double(8,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `test2s` -- CREATE TABLE `test2s` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `users_role_id` int(11) NOT NULL, `isAdmin` tinyint(4) DEFAULT NULL, `firstname` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `lastname` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `phone` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `dob` date DEFAULT NULL, `postcode` text COLLATE utf8_unicode_ci DEFAULT NULL, `address` text COLLATE utf8_unicode_ci DEFAULT NULL, `city` text COLLATE utf8_unicode_ci DEFAULT NULL, `country` text COLLATE utf8_unicode_ci DEFAULT NULL, `image` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `status` tinyint(4) DEFAULT NULL, `created_by` int(11) DEFAULT NULL, `updated_by` int(11) DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users_roles` -- CREATE TABLE `users_roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `slug` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wish_lists` -- CREATE TABLE `wish_lists` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `is_delete` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `categories_name_unique` (`name`); -- -- Indexes for table `clients` -- ALTER TABLE `clients` ADD PRIMARY KEY (`client_id`), ADD UNIQUE KEY `clients_email_unique` (`email`); -- -- Indexes for table `discounts` -- ALTER TABLE `discounts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `generic_names` -- ALTER TABLE `generic_names` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `generic_names_name_unique` (`name`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `medicine_groups` -- ALTER TABLE `medicine_groups` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `medicine_groups_name_unique` (`name`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`order_id`); -- -- Indexes for table `order_policy` -- ALTER TABLE `order_policy` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_products` -- ALTER TABLE `order_products` ADD PRIMARY KEY (`id`), ADD KEY `order_products_order_id_foreign` (`order_id`), ADD KEY `order_products_product_id_foreign` (`product_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payments` -- ALTER TABLE `payments` ADD PRIMARY KEY (`payment_id`); -- -- Indexes for table `payment_methods` -- ALTER TABLE `payment_methods` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `payment_methods_type_unique` (`type`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `product_name_unique` (`name`), ADD KEY `product_category_id_foreign` (`category_id`), ADD KEY `product_group_id_foreign` (`group_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `settings_name_unique` (`name`), ADD UNIQUE KEY `settings_email_unique` (`email`); -- -- Indexes for table `shipping_methods` -- ALTER TABLE `shipping_methods` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `shipping_methods_type_unique` (`type`); -- -- Indexes for table `supplier` -- ALTER TABLE `supplier` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `supplier_name_unique` (`name`); -- -- Indexes for table `supplier_invoices` -- ALTER TABLE `supplier_invoices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `supplier_invoice_productinfo` -- ALTER TABLE `supplier_invoice_productinfo` ADD PRIMARY KEY (`id`); -- -- Indexes for table `test2s` -- ALTER TABLE `test2s` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `users_roles` -- ALTER TABLE `users_roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wish_lists` -- ALTER TABLE `wish_lists` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `clients` -- ALTER TABLE `clients` MODIFY `client_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `discounts` -- ALTER TABLE `discounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `generic_names` -- ALTER TABLE `generic_names` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `medicine_groups` -- ALTER TABLE `medicine_groups` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `order_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_policy` -- ALTER TABLE `order_policy` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_products` -- ALTER TABLE `order_products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payments` -- ALTER TABLE `payments` MODIFY `payment_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment_methods` -- ALTER TABLE `payment_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shipping_methods` -- ALTER TABLE `shipping_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier` -- ALTER TABLE `supplier` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier_invoices` -- ALTER TABLE `supplier_invoices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supplier_invoice_productinfo` -- ALTER TABLE `supplier_invoice_productinfo` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `test2s` -- ALTER TABLE `test2s` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users_roles` -- ALTER TABLE `users_roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wish_lists` -- ALTER TABLE `wish_lists` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `order_products` -- ALTER TABLE `order_products` ADD CONSTRAINT `order_products_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`order_id`), ADD CONSTRAINT `order_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`); -- -- Constraints for table `product` -- ALTER TABLE `product` ADD CONSTRAINT `product_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `product_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `medicine_groups` (`id`) ON DELETE CASCADE; 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 */;