--
-- Host: localhost    Database: fmedia_toko
-- ------------------------------------------------------


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

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;

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

INSERT INTO `banner` VALUES (9,'Water lilies.jpg','www.yahoo.com'),(10,'Winter.jpg','ww.google.com');

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

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;

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

INSERT INTO `category` VALUES (73,'',0,'sada'),(74,'',0,'asdasd'),(75,'',74,'asdad');

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

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;

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

INSERT INTO `contactus` VALUES (59,'asdada','','ss','ss','ss','2012-05-15');

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

CREATE TABLE `meta` (
  `MetaTitle` longtext NOT NULL,
  `MetaKeyword` longtext NOT NULL,
  `MetaDescription` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `meta` VALUES ('test2ewew1','test2','test3');

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

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;

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

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,'','');

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

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;

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

INSERT INTO `product` VALUES (21,'1',123,123,'Winter.jpg',75);


