File manager - Edit - /home/custbahd/irungikitchen.com/admin/sql/shop-details.sql
Back
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 18, 2024 at 10:00 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `irungi` -- -- -------------------------------------------------------- -- -- Table structure for table `shop` -- CREATE TABLE `shop` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `cat` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `price` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `instock` varchar(255) NOT NULL, `picks` varchar(255) NOT NULL, `recom` varchar(255) NOT NULL, `essential` varchar(255) NOT NULL, `arrivals` varchar(255) NOT NULL, `recent_arrival` varchar(255) NOT NULL, `arrival_time` timestamp NOT NULL DEFAULT current_timestamp(), `trend` varchar(255) NOT NULL, `ingredients` text NOT NULL, `recipe` text NOT NULL, `deleted` varchar(255) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `shop` -- INSERT INTO `shop` (`id`, `name`, `cat`, `type`, `price`, `image`, `instock`, `picks`, `recom`, `essential`, `arrivals`, `recent_arrival`, `arrival_time`, `trend`, `ingredients`, `recipe`, `deleted`, `timestamp`) VALUES (1, 'Vanilla Cake', 'Standard Cake', '', '130000', '1.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:36:26'), (2, 'Mango Cake', 'Standard Cake', '', '130000', '3.png', '1', '', '', '', '1', '1', '2023-06-13 16:27:47', '', '', '', '', '2023-07-13 22:48:28'), (3, 'Mango Coconut Cake', 'Standard Cake', '', '130000', '4.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:37:26'), (4, 'Lemon Cake', 'Standard Cake', '', '130000', '5.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '1', '', '', '', '2023-07-13 21:37:36'), (5, 'Lemon Blueberry Cake', 'Standard Cake', '', '150000', '6.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:37:51'), (6, 'Vanilla Blueberry Cake', 'Standard Cake', '', '150000', '7.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:38:01'), (7, 'Carrot Cake', 'Standard Cake', '', '150000', '8.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:38:09'), (8, 'Mini Cakes', 'Cake', '', '55000', '9.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2024-10-18 16:45:17'), (9, 'Very Berry Cake', 'Standard Cake', '', '140000', '10.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:38:26'), (10, 'Fruit Cake', 'Standard Cake', '', '180000', '11.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:38:36'), (11, 'Tutti Fruit Cake', 'Standard Cake', '', '180000', '12.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:38:43'), (12, 'Chocolate Fudge Cake', 'Standard Cake', '', '170000', '13.png', '1', '', '', '', '', '', '2023-06-12 20:02:04', '', '', '', '', '2023-07-13 21:39:07'), (13, 'Banana Loaf', 'Cake Loaf', '', '35000', '14.png', '1', '', '', '', '1', '', '2023-06-13 14:33:43', '', '', '', '', '2023-07-13 21:39:16'), (14, ' Pinnacco Loaf', 'Cake Loaf', '', '35000', '15.png', '1', '', '', '', '1', '', '2023-06-13 14:33:29', '', '', '', '', '2023-07-13 21:39:22'), (15, 'Mango Coconut Loaf', 'Cake Loaf', '', '35000', '16.png', '1', '', '', '', '1', '', '2023-06-13 14:12:34', '', '', '', '', '2023-07-13 21:39:28'), (16, 'Carrot Loaf', 'Cake Loaf', '', '45000', '17.png', '1', '', '', '', '1', '', '2023-06-13 14:34:46', '', '', '', '', '2023-07-13 21:39:34'), (17, 'Mini Loaves', 'Cake Loaf', '', '10000', '18.png', '1', '', '', '', '', '', '2023-06-29 18:32:11', '', '', '', '', '2024-10-18 16:46:08'), (18, 'Chocolate Loaf', 'Cake Loaf', '', '50000', '19.png', '1', '', '', '', '', '', '2023-06-29 18:35:53', '', '', '', '', '2023-07-13 21:39:47'), (19, 'Fruit Loaf', 'Cake Loaf', '', '50000', '20.png', '1', '', '', '', '', '', '2023-06-29 18:42:47', '', '', '', '', '2023-07-13 21:39:58'), (20, 'Tutti Fruit Loaf', 'Cake Loaf', '', '50000', '21.png', '1', '', '', '', '', '', '2023-06-29 18:43:35', '', '', '', '', '2023-07-13 21:40:03'), (21, 'Lemon Blueberry', 'Cake Loaf', '', '50000', '22.png', '1', '', '', '', '', '', '2023-06-29 18:44:33', '', '', '', '', '2023-07-13 21:40:09'), (22, 'Vanilla Blueberry', 'Cake Loaf', '', '50000', '23.png', '1', '', '', '', '', '', '2023-06-29 18:44:52', '', '', '', '', '2023-07-13 21:40:15'), (23, 'Ginger Snap Cookies', 'Cookies', '', '10000', '24.png', '1', '', '', '', '', '', '2023-06-29 18:49:19', '', '', '', '', '2023-07-13 21:40:22'), (24, 'Lemon Cookies', 'Cookies', '', '10000', '25.png', '1', '', '', '', '', '', '2023-06-29 18:52:00', '', '', '', '', '2023-07-13 21:40:28'), (25, 'Oat Meal Cookies', 'Cookies', '', '10000', '26.png', '1', '', '', '', '', '', '2023-06-29 18:54:23', '', '', '', '', '2023-07-13 21:40:36'), (26, 'Irungi Assorted Pack', 'Cookies', '', '10000', '27.png', '1', '', '', '', '', '', '2023-06-29 18:56:18', '', '', '', '', '2024-10-18 16:46:38'), (27, 'Blue Berry Cookies', 'Cookies', '', '24000', '28.png', '1', '', '', '', '', '', '2023-06-29 18:59:55', '', '', '', '', '2023-07-13 21:41:21'), (28, 'Chocolate Chip Cookies', 'Cookies', '', '24000', '29.png', '1', '', '', '', '', '', '2023-06-29 19:00:49', '', '', '', '', '2023-07-13 21:41:27'), (29, 'Red Velvet Cookies ', 'Cookies', '', '24000', '30.png', '1', '', '', '', '', '', '2023-06-29 19:01:28', '', '', '', '', '2023-07-13 21:41:34'), (30, 'Salted Chocolate Chip', 'Cookies', '', '24000', '31.png', '1', '', '', '', '', '', '2023-06-29 19:02:21', '', '', '', '', '2023-07-13 21:41:42'), (31, 'Irungi Donuts', 'Donuts', '', '3000', '32.png', '1', '', '', '', '', '', '2023-06-29 19:06:17', '1', '', '', '', '2023-07-13 21:41:48'), (32, 'Cinamon Rolls', 'Cinamon Rolls', '', '10000', '33.png', '1', '', '', '', '', '', '2023-06-29 19:09:58', '', '', '', '', '2023-07-13 21:41:54'), (33, 'Large Muffins', 'Large Muffins', '', '30000', '34.png', '1', '', '', '', '', '', '2023-06-29 19:13:17', '', '', '', '', '2023-07-13 21:42:00'), (34, 'Cupcakes', 'Cupcakes', '', '35000', '36.png', '1', '', '', '', '', '', '2023-06-29 19:14:46', '', '', '', '', '2023-07-13 22:32:21'); -- -- Indexes for dumped tables -- -- -- Indexes for table `shop` -- ALTER TABLE `shop` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `shop` -- ALTER TABLE `shop` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; 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 */;
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.84 |
proxy
|
phpinfo
|
Settings