API tools faq
paste
Advertisement
Guest User

tg3793_sope1_2011-02-02_02h20m.Wednesday.sql

a guest
Feb 2nd, 2011
192
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 55.37 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.13  Distrib 5.1.52, for pc-linux-gnu (i686)
  2. --
  3. -- Host: localhost    Database: tg3793_sope1
  4. -- ------------------------------------------------------
  5. -- Server version   5.1.52
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `BLOG_CATEGORY`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `BLOG_CATEGORY`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `BLOG_CATEGORY` (
  26.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  27.   `CATEGORY_NAME` char(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  28.   PRIMARY KEY (`PRIKEY`)
  29. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  30. /*!40101 SET character_set_client = @saved_cs_client */;
  31.  
  32. --
  33. -- Dumping data for table `BLOG_CATEGORY`
  34. --
  35.  
  36. LOCK TABLES `BLOG_CATEGORY` WRITE;
  37. /*!40000 ALTER TABLE `BLOG_CATEGORY` DISABLE KEYS */;
  38. INSERT INTO `BLOG_CATEGORY` VALUES (1,'Latest News'),(2,'Special Promotions');
  39. /*!40000 ALTER TABLE `BLOG_CATEGORY` ENABLE KEYS */;
  40. UNLOCK TABLES;
  41.  
  42. --
  43. -- Table structure for table `BLOG_CONTENT`
  44. --
  45.  
  46. DROP TABLE IF EXISTS `BLOG_CONTENT`;
  47. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  48. /*!40101 SET character_set_client = utf8 */;
  49. CREATE TABLE `BLOG_CONTENT` (
  50.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  51.   `BLOG_SUBJECT` int(11) DEFAULT NULL,
  52.   `BLOG_TITLE` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  53.   `BLOG_DATA` blob,
  54.   `BLOG_DATE` date DEFAULT NULL,
  55.   `timestamp` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  56.   PRIMARY KEY (`PRIKEY`)
  57. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  58. /*!40101 SET character_set_client = @saved_cs_client */;
  59.  
  60. --
  61. -- Dumping data for table `BLOG_CONTENT`
  62. --
  63.  
  64. LOCK TABLES `BLOG_CONTENT` WRITE;
  65. /*!40000 ALTER TABLE `BLOG_CONTENT` DISABLE KEYS */;
  66. /*!40000 ALTER TABLE `BLOG_CONTENT` ENABLE KEYS */;
  67. UNLOCK TABLES;
  68.  
  69. --
  70. -- Table structure for table `PROMO_BOXES`
  71. --
  72.  
  73. DROP TABLE IF EXISTS `PROMO_BOXES`;
  74. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  75. /*!40101 SET character_set_client = utf8 */;
  76. CREATE TABLE `PROMO_BOXES` (
  77.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  78.   `BOX` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  79.   `CONTENT` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  80.   `NUM_DISPLAY` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  81.   `DISP_TITLE` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  82.   `DISP_CONTENT` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  83.   `DISP_DATE` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  84.   `DISP_MORE` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  85.   `FILE` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  86.   `SETTINGS` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  87.   `FUTURE1` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  88.   `content_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  89.   `content_src` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  90.   `style` blob,
  91.   PRIMARY KEY (`PRIKEY`)
  92. ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  93. /*!40101 SET character_set_client = @saved_cs_client */;
  94.  
  95. --
  96. -- Dumping data for table `PROMO_BOXES`
  97. --
  98.  
  99. LOCK TABLES `PROMO_BOXES` WRITE;
  100. /*!40000 ALTER TABLE `PROMO_BOXES` DISABLE KEYS */;
  101. INSERT INTO `PROMO_BOXES` VALUES (1,'box1','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(2,'box2','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(3,'box3','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(4,'box4','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(5,'box5','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(6,'box6','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(7,'box7','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(8,'box8','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(9,'box9','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(10,'box10','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(11,'box11','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(12,'box12','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(13,'box13','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(14,'box14','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(15,'box15','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(16,'box16','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(17,'box17','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(18,'box18','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(19,'box19','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(20,'box20','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(21,'box21','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(22,'box22','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(23,'box23','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(24,'box24','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(25,'box25','a:3:{s:7:\"content\";s:11:\"Latest News\";s:7:\"display\";s:2:\"on\";s:4:\"type\";s:6:\"latest\";}','a:2:{s:4:\"blog\";s:0:\"\";s:5:\"chars\";s:0:\"\";}','a:3:{s:7:\"display\";s:2:\"on\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:4:\"bold\";}','a:1:{s:7:\"display\";s:2:\"on\";}','a:6:{s:7:\"display\";s:2:\"on\";s:9:\"fontStyle\";s:2:\"on\";s:6:\"weight\";s:6:\"normal\";s:6:\"format\";s:4:\"full\";s:8:\"position\";s:8:\"dateLast\";s:5:\"align\";s:4:\"left\";}','a:4:{s:7:\"display\";s:2:\"on\";s:4:\"text\";s:12:\"Read more...\";s:5:\"align\";s:4:\"left\";s:6:\"weight\";s:6:\"normal\";}','','a:1:{s:8:\"template\";s:2:\"on\";}','','blog','Latest News',''),(26,'newsbox','1','','','','','','','','','','',''),(27,'promobox','2','','','','','','','','','','','');
  102. /*!40000 ALTER TABLE `PROMO_BOXES` ENABLE KEYS */;
  103. UNLOCK TABLES;
  104.  
  105. --
  106. -- Table structure for table `STATS_BROWSER`
  107. --
  108.  
  109. DROP TABLE IF EXISTS `STATS_BROWSER`;
  110. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  111. /*!40101 SET character_set_client = utf8 */;
  112. CREATE TABLE `STATS_BROWSER` (
  113.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  114.   `Month` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  115.   `Year` int(4) DEFAULT NULL,
  116.   `Browser` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  117.   `Hits` int(25) DEFAULT NULL,
  118.   `SESSION` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  119.   `Real_Date` date DEFAULT NULL,
  120.   PRIMARY KEY (`PriKey`)
  121. ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  122. /*!40101 SET character_set_client = @saved_cs_client */;
  123.  
  124. --
  125. -- Dumping data for table `STATS_BROWSER`
  126. --
  127.  
  128. LOCK TABLES `STATS_BROWSER` WRITE;
  129. /*!40000 ALTER TABLE `STATS_BROWSER` DISABLE KEYS */;
  130. INSERT INTO `STATS_BROWSER` VALUES (1,'January',2011,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3',38,'a0b4636bfe253c86bd17827a5616ead1','2011-01-19'),(2,'January',2011,'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0)',1,'','2011-01-19'),(3,'January',2011,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)',20,'','2011-01-19'),(4,'January',2011,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',12,'','2011-01-19'),(5,'January',2011,'',8,'','2011-01-21'),(6,'January',2011,'Mozilla/5.0 (compatible; AboutUsBot Johnny5/2.0; +http://www.AboutUs.org/)',1,'','2011-01-22'),(7,'January',2011,'Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)',10,'','2011-01-22'),(8,'January',2011,'Java/1.6.0_23',3,'','2011-01-23'),(9,'January',2011,'Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/534.10 (KHTML, like Gecko) Ubuntu/10.04 Chromium/8.0.552.224 Chrome/8.0.552.224 Safari/534.10',25,'','2011-01-24'),(10,'January',2011,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en; rv:1.9.0.13) Gecko/2009073022 Firefox/3.5.2 (.NET CLR 3.5.30729) SurveyBot/2.3 (DomainTools)',1,'','2011-01-25'),(11,'January',2011,'Mozilla/5.0 (compatible; NetcraftSurveyAgent/1.0; +info@netcraft.com)',1,'','2011-01-25'),(12,'January',2011,'Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.9.1.7) Gecko/20100126 Firefox/3.5.7',1,'','2011-01-26'),(13,'January',2011,'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10',1,'','2011-01-26'),(14,'January',2011,'Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)',1,'','2011-01-28'),(15,'January',2011,'Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)',1,'','2011-01-28'),(16,'January',2011,'Baiduspider+(+http://www.baidu.com/search/spider.htm)',14,'','2011-01-29'),(17,'January',2011,'Mozilla/5.0 (compatible; FireFox 3.6.13 ; GNU/Linux +http://www.archive.org)',14,'','2011-01-30'),(18,'February',2011,'Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)',1,'','2011-02-01'),(19,'February',2011,'Baiduspider+(+http://www.baidu.com/search/spider.htm)',1,'','2011-02-01'),(20,'February',2011,'Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10 ( .NET CLR 3.5.30729; .NET4.0E)',4,'','2011-02-01'),(21,'February',2011,'',3,'','2011-02-01'),(22,'February',2011,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3',3,'a0b4636bfe253c86bd17827a5616ead1','2011-02-01'),(23,'February',2011,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)',1,'','2011-02-01');
  131. /*!40000 ALTER TABLE `STATS_BROWSER` ENABLE KEYS */;
  132. UNLOCK TABLES;
  133.  
  134. --
  135. -- Table structure for table `STATS_BYDAY`
  136. --
  137.  
  138. DROP TABLE IF EXISTS `STATS_BYDAY`;
  139. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  140. /*!40101 SET character_set_client = utf8 */;
  141. CREATE TABLE `STATS_BYDAY` (
  142.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  143.   `Month` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  144.   `Year` int(4) DEFAULT NULL,
  145.   `Day` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  146.   `Hits` int(25) DEFAULT NULL,
  147.   `SESSION` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  148.   `Real_Date` date DEFAULT NULL,
  149.   PRIMARY KEY (`PriKey`)
  150. ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  151. /*!40101 SET character_set_client = @saved_cs_client */;
  152.  
  153. --
  154. -- Dumping data for table `STATS_BYDAY`
  155. --
  156.  
  157. LOCK TABLES `STATS_BYDAY` WRITE;
  158. /*!40000 ALTER TABLE `STATS_BYDAY` DISABLE KEYS */;
  159. INSERT INTO `STATS_BYDAY` VALUES (1,'January',2011,'19',4,'a0b4636bfe253c86bd17827a5616ead1','2011-01-19'),(2,'January',2011,'20',9,'','2011-01-20'),(3,'January',2011,'21',38,'c0484b01e4e52206e6e369fa19a276bf','2011-01-21'),(4,'January',2011,'22',10,'','2011-01-22'),(5,'January',2011,'23',6,'','2011-01-23'),(6,'January',2011,'24',31,'','2011-01-24'),(7,'January',2011,'25',8,'','2011-01-25'),(8,'January',2011,'26',3,'','2011-01-26'),(9,'January',2011,'27',6,'','2011-01-27'),(10,'January',2011,'28',4,'','2011-01-28'),(11,'January',2011,'29',12,'','2011-01-29'),(12,'January',2011,'30',17,'','2011-01-30'),(13,'January',2011,'31',4,'','2011-01-31'),(14,'February',2011,'1',13,'','2011-02-01');
  160. /*!40000 ALTER TABLE `STATS_BYDAY` ENABLE KEYS */;
  161. UNLOCK TABLES;
  162.  
  163. --
  164. -- Table structure for table `STATS_BYHOUR`
  165. --
  166.  
  167. DROP TABLE IF EXISTS `STATS_BYHOUR`;
  168. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  169. /*!40101 SET character_set_client = utf8 */;
  170. CREATE TABLE `STATS_BYHOUR` (
  171.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  172.   `Month` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  173.   `Year` int(4) DEFAULT NULL,
  174.   `Hour` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  175.   `Hits` int(25) DEFAULT NULL,
  176.   `SESSION` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  177.   `Real_Date` date DEFAULT NULL,
  178.   `Min_Users` int(8) DEFAULT NULL,
  179.   `Max_Users` int(8) DEFAULT NULL,
  180.   `Avg_Users` float DEFAULT NULL,
  181.   PRIMARY KEY (`PriKey`)
  182. ) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  183. /*!40101 SET character_set_client = @saved_cs_client */;
  184.  
  185. --
  186. -- Dumping data for table `STATS_BYHOUR`
  187. --
  188.  
  189. LOCK TABLES `STATS_BYHOUR` WRITE;
  190. /*!40000 ALTER TABLE `STATS_BYHOUR` DISABLE KEYS */;
  191. INSERT INTO `STATS_BYHOUR` VALUES (1,'January',2011,'11',1,'a0b4636bfe253c86bd17827a5616ead1','2011-01-19',1,1,1),(2,'January',2011,'14',1,'','2011-01-19',1,1,1),(3,'January',2011,'16',1,'','2011-01-19',1,1,1),(4,'January',2011,'20',1,'','2011-01-19',1,1,1),(5,'January',2011,'04',1,'','2011-01-20',1,1,1),(6,'January',2011,'06',5,'','2011-01-20',1,1,1),(7,'January',2011,'07',1,'','2011-01-20',1,1,1),(8,'January',2011,'11',1,'','2011-01-20',1,1,1),(9,'January',2011,'21',1,'','2011-01-20',1,1,1),(10,'January',2011,'04',6,'c0484b01e4e52206e6e369fa19a276bf','2011-01-21',1,2,1.83333),(11,'January',2011,'05',27,'','2011-01-21',2,2,2),(12,'January',2011,'10',1,'','2011-01-21',1,1,1),(13,'January',2011,'15',1,'','2011-01-21',1,1,1),(14,'January',2011,'20',1,'','2011-01-21',1,1,1),(15,'January',2011,'21',2,'a0b4636bfe253c86bd17827a5616ead1','2011-01-21',1,1,1),(16,'January',2011,'00',1,'','2011-01-22',1,1,1),(17,'January',2011,'02',1,'','2011-01-22',1,1,1),(18,'January',2011,'05',8,'','2011-01-22',1,1,1),(19,'January',2011,'00',1,'','2011-01-23',1,1,1),(20,'January',2011,'09',1,'','2011-01-23',1,1,1),(21,'January',2011,'17',1,'','2011-01-23',1,1,1),(22,'January',2011,'20',3,'','2011-01-23',1,1,1),(23,'January',2011,'02',3,'','2011-01-24',1,2,1.66667),(24,'January',2011,'04',1,'','2011-01-24',1,1,1),(25,'January',2011,'05',25,'','2011-01-24',1,1,1),(26,'January',2011,'09',1,'','2011-01-24',1,1,1),(27,'January',2011,'17',1,'','2011-01-24',1,1,1),(28,'January',2011,'03',1,'','2011-01-25',1,1,1),(29,'January',2011,'05',1,'a0b4636bfe253c86bd17827a5616ead1','2011-01-25',1,1,1),(30,'January',2011,'12',1,'','2011-01-25',1,1,1),(31,'January',2011,'16',2,'','2011-01-25',1,2,1.5),(32,'January',2011,'20',1,'','2011-01-25',1,1,1),(33,'January',2011,'22',2,'a0b4636bfe253c86bd17827a5616ead1','2011-01-25',1,1,1),(34,'January',2011,'04',1,'','2011-01-26',1,1,1),(35,'January',2011,'08',1,'','2011-01-26',1,1,1),(36,'January',2011,'23',1,'','2011-01-26',1,1,1),(37,'January',2011,'08',6,'','2011-01-27',1,1,1),(38,'January',2011,'04',1,'','2011-01-28',1,1,1),(39,'January',2011,'10',1,'','2011-01-28',1,1,1),(40,'January',2011,'12',1,'','2011-01-28',1,1,1),(41,'January',2011,'16',1,'','2011-01-28',1,1,1),(42,'January',2011,'10',1,'','2011-01-29',1,1,1),(43,'January',2011,'22',11,'','2011-01-29',1,8,4.54545),(44,'January',2011,'03',14,'','2011-01-30',1,1,1),(45,'January',2011,'14',1,'','2011-01-30',1,1,1),(46,'January',2011,'16',2,'a0b4636bfe253c86bd17827a5616ead1','2011-01-30',1,1,1),(47,'January',2011,'00',1,'','2011-01-31',1,1,1),(48,'January',2011,'01',2,'','2011-01-31',1,2,1.5),(49,'January',2011,'07',1,'','2011-01-31',1,1,1),(50,'February',2011,'01',1,'','2011-02-01',1,1,1),(51,'February',2011,'13',1,'','2011-02-01',1,1,1),(52,'February',2011,'16',6,'','2011-02-01',1,1,1),(53,'February',2011,'17',1,'','2011-02-01',1,1,1),(54,'February',2011,'18',1,'a0b4636bfe253c86bd17827a5616ead1','2011-02-01',1,1,1),(55,'February',2011,'22',3,'a0b4636bfe253c86bd17827a5616ead1','2011-02-01',1,1,1);
  192. /*!40000 ALTER TABLE `STATS_BYHOUR` ENABLE KEYS */;
  193. UNLOCK TABLES;
  194.  
  195. --
  196. -- Table structure for table `STATS_REFER`
  197. --
  198.  
  199. DROP TABLE IF EXISTS `STATS_REFER`;
  200. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  201. /*!40101 SET character_set_client = utf8 */;
  202. CREATE TABLE `STATS_REFER` (
  203.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  204.   `Month` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  205.   `Year` int(4) DEFAULT NULL,
  206.   `Refer` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  207.   `Hits` int(25) DEFAULT NULL,
  208.   `SESSION` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  209.   `Real_Date` date DEFAULT NULL,
  210.   PRIMARY KEY (`PriKey`)
  211. ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  212. /*!40101 SET character_set_client = @saved_cs_client */;
  213.  
  214. --
  215. -- Dumping data for table `STATS_REFER`
  216. --
  217.  
  218. LOCK TABLES `STATS_REFER` WRITE;
  219. /*!40000 ALTER TABLE `STATS_REFER` DISABLE KEYS */;
  220. INSERT INTO `STATS_REFER` VALUES (1,'January',2011,'(Direct)',84,'a0b4636bfe253c86bd17827a5616ead1','2011-01-19'),(2,'January',2011,'http://www.hk-marketing.eu',1,'','2011-01-19'),(3,'January',2011,'(Internal)',15,'c0484b01e4e52206e6e369fa19a276bf','2011-01-21'),(4,'January',2011,'http://igottcha.com/sohoadmin/program/modules/site_templates/pages/PROFESSIONAL-Cutting_Edge-Blue/custom.css',9,'a0b4636bfe253c86bd17827a5616ead1','2011-01-21'),(5,'January',2011,'http://igottcha.com/',2,'a0b4636bfe253c86bd17827a5616ead1','2011-01-21'),(6,'January',2011,'http://igottcha.com/index.php?pr=About',6,'a0b4636bfe253c86bd17827a5616ead1','2011-01-21'),(7,'January',2011,'http://igottcha.com/index.php?pr=Home_Page',1,'a0b4636bfe253c86bd17827a5616ead1','2011-01-21'),(8,'January',2011,'http://igottcha.com/download/',20,'5c44f13f142720bb8bca849171f74c44','2011-01-24'),(9,'January',2011,'http://whois.domaintools.com/igottcha.com',1,'','2011-01-25'),(10,'January',2011,'http://www.google.com/',1,'','2011-01-26'),(11,'January',2011,'http://igottcha.com/sohoadmin/program/includes/display_elements/window/default.css',12,'263de05a4522a71cfe55447294bd8030','2011-01-30'),(12,'February',2011,'(Direct)',11,'','2011-02-01'),(13,'February',2011,'http://igottcha.com/index.php?pr=About',1,'a0b4636bfe253c86bd17827a5616ead1','2011-02-01'),(14,'February',2011,'(Internal)',1,'c0484b01e4e52206e6e369fa19a276bf','2011-02-01');
  221. /*!40000 ALTER TABLE `STATS_REFER` ENABLE KEYS */;
  222. UNLOCK TABLES;
  223.  
  224. --
  225. -- Table structure for table `STATS_TOP25`
  226. --
  227.  
  228. DROP TABLE IF EXISTS `STATS_TOP25`;
  229. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  230. /*!40101 SET character_set_client = utf8 */;
  231. CREATE TABLE `STATS_TOP25` (
  232.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  233.   `Month` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  234.   `Year` int(4) DEFAULT NULL,
  235.   `Page` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  236.   `Hits` int(25) DEFAULT NULL,
  237.   `SESSION` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  238.   `Real_Date` date DEFAULT NULL,
  239.   PRIMARY KEY (`PriKey`)
  240. ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  241. /*!40101 SET character_set_client = @saved_cs_client */;
  242.  
  243. --
  244. -- Dumping data for table `STATS_TOP25`
  245. --
  246.  
  247. LOCK TABLES `STATS_TOP25` WRITE;
  248. /*!40000 ALTER TABLE `STATS_TOP25` DISABLE KEYS */;
  249. INSERT INTO `STATS_TOP25` VALUES (1,'January',2011,'Home Page',113,'a0b4636bfe253c86bd17827a5616ead1','2011-01-19'),(2,'January',2011,'Clients',9,'','2011-01-20'),(3,'January',2011,'About Us',1,'','2011-01-20'),(4,'January',2011,'Contact Us',4,'','2011-01-20'),(5,'January',2011,'Thank You',4,'','2011-01-20'),(6,'January',2011,'Services',4,'','2011-01-20'),(7,'January',2011,'About',8,'','2011-01-21'),(8,'January',2011,'Company Info',4,'','2011-01-21'),(9,'January',2011,'Partners',5,'','2011-01-22'),(10,'February',2011,'Home Page',12,'','2011-02-01'),(11,'February',2011,'Clients',1,'a0b4636bfe253c86bd17827a5616ead1','2011-02-01');
  250. /*!40000 ALTER TABLE `STATS_TOP25` ENABLE KEYS */;
  251. UNLOCK TABLES;
  252.  
  253. --
  254. -- Table structure for table `STATS_UNIQUE`
  255. --
  256.  
  257. DROP TABLE IF EXISTS `STATS_UNIQUE`;
  258. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  259. /*!40101 SET character_set_client = utf8 */;
  260. CREATE TABLE `STATS_UNIQUE` (
  261.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  262.   `Month` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  263.   `Year` int(4) DEFAULT NULL,
  264.   `IP` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  265.   `Hour` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  266.   `Hits` int(25) DEFAULT NULL,
  267.   `Browser` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  268.   `SESSION` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  269.   `Real_Date` date DEFAULT NULL,
  270.   PRIMARY KEY (`PriKey`)
  271. ) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  272. /*!40101 SET character_set_client = @saved_cs_client */;
  273.  
  274. --
  275. -- Dumping data for table `STATS_UNIQUE`
  276. --
  277.  
  278. LOCK TABLES `STATS_UNIQUE` WRITE;
  279. /*!40000 ALTER TABLE `STATS_UNIQUE` DISABLE KEYS */;
  280. INSERT INTO `STATS_UNIQUE` VALUES (1,'January',2011,'112.201.38.121','11',1,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-01-19'),(2,'January',2011,'178.77.77.40','14',1,'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0)','','2011-01-19'),(3,'January',2011,'72.30.142.249','16',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-19'),(4,'January',2011,'66.249.71.43','20',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-19'),(5,'January',2011,'66.249.71.43','04',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-20'),(6,'January',2011,'67.195.112.24','06',5,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-20'),(7,'January',2011,'67.195.112.24','07',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-20'),(8,'January',2011,'66.249.71.43','11',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-20'),(9,'January',2011,'66.249.71.43','21',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-20'),(10,'January',2011,'112.201.38.121','04',4,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','c0484b01e4e52206e6e369fa19a276bf','2011-01-21'),(11,'January',2011,'174.120.139.92','04',2,'','','2011-01-21'),(12,'January',2011,'174.120.139.92','05',3,'','','2011-01-21'),(13,'January',2011,'112.201.38.121','05',50,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','c0484b01e4e52206e6e369fa19a276bf','2011-01-21'),(14,'January',2011,'67.195.112.24','10',2,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-21'),(15,'January',2011,'67.195.112.24','15',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-21'),(16,'January',2011,'66.249.72.183','20',2,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-21'),(17,'January',2011,'112.201.38.121','21',2,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-01-21'),(18,'January',2011,'184.73.30.110','00',1,'Mozilla/5.0 (compatible; AboutUsBot Johnny5/2.0; +http://www.AboutUs.org/)','','2011-01-22'),(19,'January',2011,'67.195.112.24','02',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-22'),(20,'January',2011,'193.47.80.51','05',8,'Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)','','2011-01-22'),(21,'January',2011,'66.249.72.183','00',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-23'),(22,'January',2011,'193.47.80.51','09',1,'Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)','','2011-01-23'),(23,'January',2011,'67.195.112.24','17',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-23'),(24,'January',2011,'209.190.3.210','20',3,'Java/1.6.0_23','','2011-01-23'),(25,'January',2011,'66.249.72.183','02',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-24'),(26,'January',2011,'112.201.38.121','02',2,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-01-24'),(27,'January',2011,'72.32.122.29','04',1,'','','2011-01-24'),(28,'January',2011,'66.249.72.183','09',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-24'),(29,'January',2011,'66.249.72.183','17',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-24'),(30,'January',2011,'66.249.72.183','03',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-25'),(31,'January',2011,'64.246.165.160','12',1,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en; rv:1.9.0.13) Gecko/2009073022 Firefox/3.5.2 (.NET CLR 3','','2011-01-25'),(32,'January',2011,'66.249.72.183','16',1,'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','','2011-01-25'),(33,'January',2011,'184.72.134.29','16',1,'Mozilla/5.0 (compatible; NetcraftSurveyAgent/1.0; +info@netcraft.com)','','2011-01-25'),(34,'January',2011,'112.201.38.121','22',2,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-01-25'),(35,'January',2011,'69.62.255.118','04',1,'Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.9.1.7) Gecko/20100126 Firefox/3.5.7','','2011-01-26'),(36,'January',2011,'72.32.122.29','08',1,'','','2011-01-26'),(37,'January',2011,'216.110.94.228','23',1,'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10','','2011-01-26'),(38,'January',2011,'67.195.112.24','08',6,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-27'),(39,'January',2011,'77.88.29.246','04',1,'Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)','','2011-01-28'),(40,'January',2011,'207.46.204.231','12',1,'Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)','','2011-01-28'),(41,'January',2011,'67.195.112.24','16',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-28'),(42,'January',2011,'50.18.2.139','10',1,'','','2011-01-29'),(43,'January',2011,'220.181.108.171','22',2,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(44,'January',2011,'220.181.108.183','22',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(45,'January',2011,'220.181.108.179','22',2,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(46,'January',2011,'220.181.108.176','22',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(47,'January',2011,'220.181.108.186','22',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(48,'January',2011,'220.181.108.181','22',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(49,'January',2011,'220.181.108.185','22',2,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(50,'January',2011,'220.181.108.178','22',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-29'),(51,'January',2011,'207.241.232.88','03',14,'Mozilla/5.0 (compatible; FireFox 3.6.13 ; GNU/Linux +http://www.archive.org)','','2011-01-30'),(52,'January',2011,'220.181.108.172','14',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-30'),(53,'January',2011,'112.201.38.121','16',2,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-01-30'),(54,'January',2011,'67.195.112.24','00',1,'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)','','2011-01-31'),(55,'January',2011,'220.181.108.186','01',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-31'),(56,'January',2011,'220.181.108.171','01',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-01-31'),(57,'January',2011,'193.47.80.51','07',1,'Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)','','2011-01-31'),(58,'February',2011,'193.47.80.51','01',1,'Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)','','2011-02-01'),(59,'February',2011,'220.181.108.167','13',1,'Baiduspider+(+http://www.baidu.com/search/spider.htm)','','2011-02-01'),(60,'February',2011,'83.66.228.233','16',6,'Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10 ( .NET CLR 3','','2011-02-01'),(61,'February',2011,'83.66.228.233','17',1,'Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10 ( .NET CLR 3','','2011-02-01'),(62,'February',2011,'112.201.38.121','18',1,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-02-01'),(63,'February',2011,'112.201.38.121','22',2,'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.','a0b4636bfe253c86bd17827a5616ead1','2011-02-01'),(64,'February',2011,'72.94.249.38','22',1,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)','','2011-02-01');
  281. /*!40000 ALTER TABLE `STATS_UNIQUE` ENABLE KEYS */;
  282. UNLOCK TABLES;
  283.  
  284. --
  285. -- Table structure for table `UDT_CONTENT_SEARCH_REPLACE`
  286. --
  287.  
  288. DROP TABLE IF EXISTS `UDT_CONTENT_SEARCH_REPLACE`;
  289. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  290. /*!40101 SET character_set_client = utf8 */;
  291. CREATE TABLE `UDT_CONTENT_SEARCH_REPLACE` (
  292.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  293.   `SEARCH_FOR` char(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  294.   `REPLACE_WITH` blob,
  295.   `AUTO_IMAGE` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  296.   `AUTO_SECURITY_AUTH` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  297.   PRIMARY KEY (`PRIKEY`)
  298. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  299. /*!40101 SET character_set_client = @saved_cs_client */;
  300.  
  301. --
  302. -- Dumping data for table `UDT_CONTENT_SEARCH_REPLACE`
  303. --
  304.  
  305. LOCK TABLES `UDT_CONTENT_SEARCH_REPLACE` WRITE;
  306. /*!40000 ALTER TABLE `UDT_CONTENT_SEARCH_REPLACE` DISABLE KEYS */;
  307. /*!40000 ALTER TABLE `UDT_CONTENT_SEARCH_REPLACE` ENABLE KEYS */;
  308. UNLOCK TABLES;
  309.  
  310. --
  311. -- Table structure for table `cart_comments`
  312. --
  313.  
  314. DROP TABLE IF EXISTS `cart_comments`;
  315. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  316. /*!40101 SET character_set_client = utf8 */;
  317. CREATE TABLE `cart_comments` (
  318.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  319.   `PROD_ID` int(11) DEFAULT NULL,
  320.   `COMMENT_TITLE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  321.   `COMMENT` blob,
  322.   `RATING` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  323.   `NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  324.   `LOCATION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  325.   `COMMENT_DATE` datetime DEFAULT NULL,
  326.   `STATUS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  327.   `COMMENT_HTML` blob,
  328.   `AUTH_KEY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  329.   PRIMARY KEY (`PRIKEY`)
  330. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  331. /*!40101 SET character_set_client = @saved_cs_client */;
  332.  
  333. --
  334. -- Dumping data for table `cart_comments`
  335. --
  336.  
  337. LOCK TABLES `cart_comments` WRITE;
  338. /*!40000 ALTER TABLE `cart_comments` DISABLE KEYS */;
  339. /*!40000 ALTER TABLE `cart_comments` ENABLE KEYS */;
  340. UNLOCK TABLES;
  341.  
  342. --
  343. -- Table structure for table `login`
  344. --
  345.  
  346. DROP TABLE IF EXISTS `login`;
  347. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  348. /*!40101 SET character_set_client = utf8 */;
  349. CREATE TABLE `login` (
  350.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  351.   `Owner` char(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  352.   `First_Name` char(75) COLLATE utf8_unicode_ci DEFAULT NULL,
  353.   `Last_Name` char(75) COLLATE utf8_unicode_ci DEFAULT NULL,
  354.   `Email` char(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  355.   `Username` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  356.   `Password` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  357.   `Rank` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  358.   PRIMARY KEY (`PriKey`)
  359. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  360. /*!40101 SET character_set_client = @saved_cs_client */;
  361.  
  362. --
  363. -- Dumping data for table `login`
  364. --
  365.  
  366. LOCK TABLES `login` WRITE;
  367. /*!40000 ALTER TABLE `login` DISABLE KEYS */;
  368. INSERT INTO `login` VALUES (1,'igottcha.com','WEBMASTER','WEBMASTER','webmaster@igottcha.com','admin','P1cm1n!@','dcbff7c6eb226ff5cdbfd11c098dbacd');
  369. /*!40000 ALTER TABLE `login` ENABLE KEYS */;
  370. UNLOCK TABLES;
  371.  
  372. --
  373. -- Table structure for table `login_attempts`
  374. --
  375.  
  376. DROP TABLE IF EXISTS `login_attempts`;
  377. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  378. /*!40101 SET character_set_client = utf8 */;
  379. CREATE TABLE `login_attempts` (
  380.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  381.   `ip_address` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  382.   `date` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  383.   `time` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  384.   `username` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  385.   `password` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  386.   PRIMARY KEY (`PRIKEY`)
  387. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  388. /*!40101 SET character_set_client = @saved_cs_client */;
  389.  
  390. --
  391. -- Dumping data for table `login_attempts`
  392. --
  393.  
  394. LOCK TABLES `login_attempts` WRITE;
  395. /*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
  396. /*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
  397. UNLOCK TABLES;
  398.  
  399. --
  400. -- Table structure for table `login_bans`
  401. --
  402.  
  403. DROP TABLE IF EXISTS `login_bans`;
  404. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  405. /*!40101 SET character_set_client = utf8 */;
  406. CREATE TABLE `login_bans` (
  407.   `PRIKEY` int(11) NOT NULL AUTO_INCREMENT,
  408.   `ip_address` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  409.   `date` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  410.   `time` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  411.   PRIMARY KEY (`PRIKEY`)
  412. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  413. /*!40101 SET character_set_client = @saved_cs_client */;
  414.  
  415. --
  416. -- Dumping data for table `login_bans`
  417. --
  418.  
  419. LOCK TABLES `login_bans` WRITE;
  420. /*!40000 ALTER TABLE `login_bans` DISABLE KEYS */;
  421. /*!40000 ALTER TABLE `login_bans` ENABLE KEYS */;
  422. UNLOCK TABLES;
  423.  
  424. --
  425. -- Table structure for table `login_history`
  426. --
  427.  
  428. DROP TABLE IF EXISTS `login_history`;
  429. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  430. /*!40101 SET character_set_client = utf8 */;
  431. CREATE TABLE `login_history` (
  432.   `prikey` int(11) NOT NULL AUTO_INCREMENT,
  433.   `ip_address` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  434.   `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  435.   `date` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  436.   `time` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  437.   PRIMARY KEY (`prikey`)
  438. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  439. /*!40101 SET character_set_client = @saved_cs_client */;
  440.  
  441. --
  442. -- Dumping data for table `login_history`
  443. --
  444.  
  445. LOCK TABLES `login_history` WRITE;
  446. /*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
  447. INSERT INTO `login_history` VALUES (1,'112.201.38.121','admin','01/19/2011','1295456191');
  448. /*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
  449. UNLOCK TABLES;
  450.  
  451. --
  452. -- Table structure for table `sec_codes`
  453. --
  454.  
  455. DROP TABLE IF EXISTS `sec_codes`;
  456. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  457. /*!40101 SET character_set_client = utf8 */;
  458. CREATE TABLE `sec_codes` (
  459.   `PriKey` int(11) NOT NULL AUTO_INCREMENT,
  460.   `security_code` char(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  461.   PRIMARY KEY (`PriKey`)
  462. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  463. /*!40101 SET character_set_client = @saved_cs_client */;
  464.  
  465. --
  466. -- Dumping data for table `sec_codes`
  467. --
  468.  
  469. LOCK TABLES `sec_codes` WRITE;
  470. /*!40000 ALTER TABLE `sec_codes` DISABLE KEYS */;
  471. /*!40000 ALTER TABLE `sec_codes` ENABLE KEYS */;
  472. UNLOCK TABLES;
  473.  
  474. --
  475. -- Table structure for table `site_pages`
  476. --
  477.  
  478. DROP TABLE IF EXISTS `site_pages`;
  479. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  480. /*!40101 SET character_set_client = utf8 */;
  481. CREATE TABLE `site_pages` (
  482.   `page_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  483.   `type` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
  484.   `sub_page_of` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  485.   `password` blob,
  486.   `main_menu` int(25) DEFAULT NULL,
  487.   `link` blob,
  488.   `username` varchar(35) COLLATE utf8_unicode_ci DEFAULT NULL,
  489.   `splash` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  490.   `bgcolor` blob,
  491.   `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  492.   `description` blob,
  493.   `template` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  494.   PRIMARY KEY (`page_name`)
  495. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  496. /*!40101 SET character_set_client = @saved_cs_client */;
  497.  
  498. --
  499. -- Dumping data for table `site_pages`
  500. --
  501.  
  502. LOCK TABLES `site_pages` WRITE;
  503. /*!40000 ALTER TABLE `site_pages` DISABLE KEYS */;
  504. INSERT INTO `site_pages` VALUES ('Home Page','Main',' ',' ~~~SEP~~~CON',1,'2459444338','','','','Welcome to www.igottcha.com','www.igottcha.com',''),('About','Main','','~~~SEP~~~CON',3,'8f7f4c1ce7a4f933663d10543562b096','','','','','',''),('Clients','Main','','~~~SEP~~~CON',7,'0f558243fbf45f1cd840fff01957f57b','','','','','',''),('Company Info','Main','','',9,'39ae37fc604ebb25023d2377c8ca4bb1','','','','','',''),('Contact Us','Main','','',11,'561bc7e49a75786cfe20425c27512ff8','','','','','',''),('Partners','Main','','',13,'fd6df34ee4e7642c02ced6012028f6b8','','','','','',''),('Services','Main','','',15,'992a0f0542384f1ee5ef51b7cf4ae6c4','','','','','',''),('Thank You','Main','','',17,'f8dea874866a8f74f34b0a4808f5d974','','','','','','');
  505. /*!40000 ALTER TABLE `site_pages` ENABLE KEYS */;
  506. UNLOCK TABLES;
  507.  
  508. --
  509. -- Table structure for table `site_specs`
  510. --
  511.  
  512. DROP TABLE IF EXISTS `site_specs`;
  513. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  514. /*!40101 SET character_set_client = utf8 */;
  515. CREATE TABLE `site_specs` (
  516.   `df_company` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  517.   `df_address1` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  518.   `df_address2` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  519.   `df_city` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  520.   `df_state` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  521.   `df_zip` char(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  522.   `df_country` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  523.   `df_phone` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  524.   `df_email` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  525.   `df_domain` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  526.   `df_page` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  527.   `df_logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  528.   `df_lang` char(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  529.   `news_cat` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  530.   `promo_cat` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  531.   `copyright` blob,
  532.   `df_misc1` blob,
  533.   `df_misc2` blob,
  534.   `df_hdrtxt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  535.   `df_slogan` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  536.   `dev_mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  537.   `startpage` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  538.   `df_fax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
  539. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  540. /*!40101 SET character_set_client = @saved_cs_client */;
  541.  
  542. --
  543. -- Dumping data for table `site_specs`
  544. --
  545.  
  546. LOCK TABLES `site_specs` WRITE;
  547. /*!40000 ALTER TABLE `site_specs` DISABLE KEYS */;
  548. INSERT INTO `site_specs` VALUES ('Gott IT Dunn','','','','','','PHILIPPINES - PH','09083659051','certainlife@gmail.com','www.igottcha.com','Home Page','','english.php','1','2','2011','','','Gott IT Dunn','','','Home Page','');
  549. /*!40000 ALTER TABLE `site_specs` ENABLE KEYS */;
  550. UNLOCK TABLES;
  551.  
  552. --
  553. -- Table structure for table `smt_userdata`
  554. --
  555.  
  556. DROP TABLE IF EXISTS `smt_userdata`;
  557. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  558. /*!40101 SET character_set_client = utf8 */;
  559. CREATE TABLE `smt_userdata` (
  560.   `prikey` int(10) NOT NULL AUTO_INCREMENT,
  561.   `plugin` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
  562.   `fieldname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  563.   `data` blob,
  564.   PRIMARY KEY (`prikey`)
  565. ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  566. /*!40101 SET character_set_client = @saved_cs_client */;
  567.  
  568. --
  569. -- Dumping data for table `smt_userdata`
  570. --
  571.  
  572. LOCK TABLES `smt_userdata` WRITE;
  573. /*!40000 ALTER TABLE `smt_userdata` DISABLE KEYS */;
  574. INSERT INTO `smt_userdata` VALUES (1,'cart','other_policy_title','Other Policies'),(2,'asense','id','HIDE'),(3,'webmaster_pref','mm_shortcuts','on'),(4,'blog_comment','require_approval','yes'),(5,'page_editor_details','refresh_editor','1'),(6,'page_editor_details','seen','0'),(7,'customfonts','fontfams','Andale Mono=andale mono,times;Arial=arial,helvetica,sans-serif;Arial Black=arial black,avant garde;Book Antiqua=book antiqua,palatino;Comic Sans MS=comic sans ms,sand;Courier New=courier new,courier;Georgia=georgia,palatino;Helvetica=helvetica;Impact=impact,chicago;Symbol=symbol;Tahoma=tahoma,arial,helvetica,sans-serif;Terminal=terminal,monaco;Times New Roman=times new roman,times;Trebuchet MS=trebuchet ms,geneva;Verdana=verdana,geneva;Webdings=webdings;Wingdings=wingdings,zapf dingbats');
  575. /*!40000 ALTER TABLE `smt_userdata` ENABLE KEYS */;
  576. UNLOCK TABLES;
  577. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  578.  
  579. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  580. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  581. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  582. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  583. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  584. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  585. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  586.  
  587. -- Dump completed on 2011-02-02  2:20:46
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!