/*!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: fmedia_toko
-- ------------------------------------------------------
-- Server version	10.5.25-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `banner`
--

DROP TABLE IF EXISTS `banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banner` (
  `BannerID` int(11) NOT NULL AUTO_INCREMENT,
  `Image` varchar(150) NOT NULL,
  `Link` varchar(200) NOT NULL,
  PRIMARY KEY (`BannerID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banner`
--

LOCK TABLES `banner` WRITE;
/*!40000 ALTER TABLE `banner` DISABLE KEYS */;
INSERT INTO `banner` VALUES (9,'Water lilies.jpg','www.yahoo.com'),(10,'Winter.jpg','ww.google.com');
/*!40000 ALTER TABLE `banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
  `CatID` int(11) NOT NULL AUTO_INCREMENT,
  `Type` varchar(150) NOT NULL,
  `Sub` int(11) NOT NULL,
  `Category` varchar(200) NOT NULL,
  PRIMARY KEY (`CatID`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (73,'',0,'sada'),(74,'',0,'asdasd'),(75,'',74,'asdad');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contactus`
--

DROP TABLE IF EXISTS `contactus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contactus` (
  `MessageID` int(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(150) NOT NULL,
  `Company` varchar(100) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Phone` varchar(100) NOT NULL,
  `Message` longtext NOT NULL,
  `DateEntry` date NOT NULL,
  PRIMARY KEY (`MessageID`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contactus`
--

LOCK TABLES `contactus` WRITE;
/*!40000 ALTER TABLE `contactus` DISABLE KEYS */;
INSERT INTO `contactus` VALUES (59,'asdada','','ss','ss','ss','2012-05-15');
/*!40000 ALTER TABLE `contactus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `member`
--

DROP TABLE IF EXISTS `member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member` (
  `MemberID` int(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(150) NOT NULL,
  `Birthday` date NOT NULL,
  `Gender` enum('l','p') NOT NULL,
  `City` varchar(50) NOT NULL,
  `Address` longtext NOT NULL,
  `Job` varchar(100) NOT NULL,
  `Company` varchar(100) NOT NULL,
  `Phone` varchar(50) NOT NULL,
  `Type` varchar(50) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `DateEntry` date NOT NULL,
  PRIMARY KEY (`MemberID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member`
--

LOCK TABLES `member` WRITE;
/*!40000 ALTER TABLE `member` DISABLE KEYS */;
INSERT INTO `member` VALUES (1,'Jimmy Rianto','1990-06-19','l','Jakarta','KDP','Web Programmer','Future Mediatrix','1234567','admin','jimmy.rianto@gmail.com','Jimmy','96e79218965eb72c92a549dd5a330112','2012-03-06'),(6,'Gunawan Lim','0000-00-00','l','Tangerang','VTB','Admin','Future Mediatrix','1234567','admin','gunawan0991@gmail.com','gunawan','e10adc3949ba59abbe56e057f20f883e','2012-04-10');
/*!40000 ALTER TABLE `member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meta`
--

DROP TABLE IF EXISTS `meta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta` (
  `MetaTitle` longtext NOT NULL,
  `MetaKeyword` longtext NOT NULL,
  `MetaDescription` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meta`
--

LOCK TABLES `meta` WRITE;
/*!40000 ALTER TABLE `meta` DISABLE KEYS */;
INSERT INTO `meta` VALUES ('test2ewew1','test2','test3');
/*!40000 ALTER TABLE `meta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `post`
--

DROP TABLE IF EXISTS `post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `post` (
  `PostID` int(20) NOT NULL AUTO_INCREMENT,
  `Sub` int(20) NOT NULL,
  `Ordering` int(20) NOT NULL,
  `Title` varchar(200) NOT NULL,
  `ShortDescription` longtext NOT NULL,
  `Description` longtext NOT NULL,
  `Banner` varchar(100) NOT NULL,
  `MetaTitle` longtext NOT NULL,
  `MetaKeyword` longtext NOT NULL,
  `MetaDescription` longtext NOT NULL,
  `DateEntry` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Highlight` int(11) NOT NULL DEFAULT 0,
  `Type` varchar(100) NOT NULL,
  `Prefix` varchar(100) NOT NULL,
  `Activate` int(11) NOT NULL DEFAULT 1,
  `Link` varchar(100) NOT NULL,
  `File` varchar(100) NOT NULL,
  PRIMARY KEY (`PostID`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `post`
--

LOCK TABLES `post` WRITE;
/*!40000 ALTER TABLE `post` DISABLE KEYS */;
INSERT INTO `post` VALUES (86,0,1,'Home','','<p>&nbsp;</p>\r\n<h3>grosir baju murah yang terpercaya, terlengkap tanah abang</h3>\r\n<p><strong>Selamat Datang di tempat pusat grosir dan eceran pakaian atau baju fashion wanita, pria, anak-anak, Import dan busana muslim murah Tanah abang.</strong></p>\r\n<p>&nbsp;</p>\r\n<p><strong><span style=\"color: red;\">SEBELUM MELAKUKAN PEMESANAN SILAHKAN BACA INI TERLEBIH DAHULU</span></strong></p>\r\n<p><strong><span style=\"color: blue;\">Toko-Baju.com adalah tempat berkumpulnya toko grosir atau penjual grosir online, toko-baju.com menyediakan banyak penjual grosir dengan semua jenis pakaian, aksesoris, bedcover, jam tangan, perawatan kecantikan, dan lain-lain. Jadi anda cukup mengunjungi toko-baju.com untuk berbelanja grosir, untuk kebutuhan bisnis anda, toko-baju.com adalah pusat grosir pakaian dan aksesoris terlengkap pertama di Indonesia.</span></strong></p>\r\n<p><strong><span style=\"color: blue;\">Untuk Pemesanan Barang di toko-baju.com, langsung menghubungi masing-masing pemilik toko/iklan, no kontak dapat dilihat disetiap iklan</span></strong></p>\r\n<p>&nbsp;</p>\r\n<p>\r\n<hr />\r\n<table border=\"0\" width=\"100%\">\r\n<tbody>\r\n<tr>\r\n<td><strong><span style=\"color: red;\">KLIK NAMA TOKO DIBAWAH INI UNTUK MELIHAT MASING-MASING ITEM SECARA KHUSUS DARI TOKO GROSIR PILIHAN ANDA:</span></strong></td>\r\n</tr>\r\n<tr>\r\n<td class=\"style20\">\r\n<ul>\r\n<li class=\"title2\"><strong><a class=\"title2\" href=\"http://www.1tanah-abang.com/\" target=\"_blank\">Grosir baju tanah abang by Dewo</a></strong>&nbsp;<span class=\"style16\"><strong>(Owner Toko-Baju.com, Update 5-10 Model Baru Setiap Hari)</strong></span><span class=\"style16\"><strong><br /><span class=\"style49\">Beli Grosir Bisa Campur Model(min 3pcs untuk dapat harga grosir)<br /></span></strong></span><span class=\"style16\">Menjual aneka ragam kaos, dress, kemeja, busana muslim, ledging, atasan pria, celana jeans, hotpants, rok, baju tidur, kimono, kaos bola, jaket, cardigan, baju couple atau pasangan, tas fashion, kaos polos, kaos polo, atasan XL, pakaian dalam wanita (celana dalam &amp; bra), Sandal, sepatu dan pakaian anak-anak</span></li>\r\n<li class=\"title2\"><strong><a href=\"http://www.1jam-tangan.com/\" target=\"_blank\">Grosir Jam Tangan</a></strong><span class=\"style16\"><strong>&nbsp;by dewo (owner toko-baju.com)<br /><span class=\"style49\">Beli Grosir bisa campur model(min 3pcs untuk dapat harga grosir)<br /></span></strong><span class=\"style42\">Menjual segala merek jam original, kw super, kw 1, kw 2, dan jam murah, merek swiss army, guess, casio, alexandre cristie, channel, ferrari, lamborghini, swatch, dll</span></span></li>\r\n<li class=\"title2\"><strong><a href=\"http://olalashopsby.toko-baju.com/\" target=\"_blank\">Olala Shop SBY</a></strong><span class=\"style16\"><strong><br /></strong><span class=\"style42\">Menjual&nbsp;</span></span>dress, gamis,jumpsuit, maxy dress, atasan wanita, celana dan rok wanita,blazer, cardigan, tanktop, bag eceran maupun grosir</li>\r\n<li class=\"title2\"><strong><a href=\"http://ilufashop.toko-baju.com/\" target=\"_blank\">Ilufashop</a>&nbsp;recomended seller by toko-baju.com</strong><span class=\"style16\"><strong><br /></strong><span class=\"style42\">Menjual&nbsp;</span></span>segala tas bermerek LV, Chanel, Gucci, Hermes, Chloe, Bottega KW Super dan lain-lain</li>\r\n<li class=\"title2\"><strong><a href=\"http://lqfashionbags.toko-baju.com/\" target=\"_blank\">Lq Fashion Bags</a>&nbsp;recomended seller by toko-baju.com</strong><span class=\"style16\"><strong><br /></strong><span class=\"style42\">Menjual&nbsp;</span></span>segala tas bermerek LV, Chanel, Gucci, Hermes, Chloe, Bottega KW Super dan lain-lain</li>\r\n<li class=\"title2\"><strong><a href=\"http://yolanda.toko-baju.com/\" target=\"_blank\">Yolanda</a>&nbsp;recomended seller by toko-baju.com</strong><span class=\"style16\"><strong><br /></strong><span class=\"style42\">Menjual&nbsp;</span></span>atasan fashion, dress, baju tidur, baju anak</li>\r\n<li class=\"title2\"><a href=\"http://crown-shop.toko-baju.com/\" target=\"_blank\">Crown Shop</a><br />Crown Shop Menjual Baju<br /></li>\r\n<li class=\"title2\"><a href=\"http://ryshop.toko-baju.com/\" target=\"_blank\">Ry Shop</a><br />Ry Shop Menjual baju import model korea, hongkong, jepang, dress, kemeja, atasan fashion<br /></li>\r\n<li class=\"title2\"><a href=\"http://phebzcollections.toko-baju.com/\" target=\"_blank\">Phebzcollections</a><br />Phebzcollections menjual baju dan tas<br /></li>\r\n<li class=\"title2\"><a href=\"http://abelsfashion.toko-baju.com/\" target=\"_blank\">Abels fashion</a><br />Abels fashion menjual atasan fashion<br /></li>\r\n<li class=\"title2\"><a href=\"http://bigcollection.toko-baju.com/\" target=\"_blank\">Big Collection</a><br />Big collection menjual atasan fashion,kaos,atasan fashion xl, kemeja, blus, celana jeans,hotpants , dress, sprei dan bedcover<br /></li>\r\n<li class=\"title2\"><a href=\"http://bodyandmeshop.toko-baju.com/\" target=\"_blank\">Body And Me Shop</a><br />Body And Me Shop menjual aksesoris kecantikan<br /></li>\r\n<li class=\"title2\"><a href=\"http://tmcollection.toko-baju.com/\" target=\"_blank\">TM Collection</a><br />TM Collection menjual tas,pakaian,jam,tas boneka<br /></li>\r\n<li class=\"title2\"><a href=\"http://lollifashion.toko-baju.com/\" target=\"_blank\">Lollifashion</a><br />Lollifashion menjual barang-barang import (pakaian, aksesoris, baju tidur, dll<br /></li>\r\n<li class=\"title2\"><a href=\"http://lovelyshop.toko-baju.com/\" target=\"_blank\">Lovelyshop</a><br />Lovelyshop menjual baju,tas,acesoris wanita,jam tangan,dll</li>\r\n</ul>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</p>\r\n<p>&nbsp;</p>','','wewewere1212','d','s','2012-05-15 09:01:16',0,'module','main',1,'',''),(87,0,2,'Product','','','','Toko Baju Murah Product','','','2012-05-15 09:01:27',0,'module','Product',1,'',''),(88,0,4,'Contact Us','','','','','','','2012-05-15 09:01:57',0,'module','Contact-Us',1,'',''),(91,0,3,'How To Order','','<p>asdada</p>','','','','','2012-05-15 09:04:00',0,'post','',1,'','');
/*!40000 ALTER TABLE `post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `ProductID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `Eceran` int(50) NOT NULL,
  `Grosir` int(50) NOT NULL,
  `Image` varchar(150) NOT NULL,
  `CatID` int(11) NOT NULL,
  PRIMARY KEY (`ProductID`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (21,'1',123,123,'Winter.jpg',75);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-07-03  4:53:28
