-- MySQL dump 10.13  Distrib 5.1.54, for redhat-linux-gnu (i686)
--
-- Host: localhost    Database: iwantthatsmile
-- ------------------------------------------------------
-- Server version	5.1.54

/*!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 utf8 */;
/*!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 `cms_additional_htmlblob_users`
--

DROP TABLE IF EXISTS `cms_additional_htmlblob_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_additional_htmlblob_users` (
  `additional_htmlblob_users_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `htmlblob_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`additional_htmlblob_users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_additional_htmlblob_users`
--

LOCK TABLES `cms_additional_htmlblob_users` WRITE;
/*!40000 ALTER TABLE `cms_additional_htmlblob_users` DISABLE KEYS */;
INSERT INTO `cms_additional_htmlblob_users` VALUES (6,1,5),(42,1,1),(41,1,2);
/*!40000 ALTER TABLE `cms_additional_htmlblob_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_additional_htmlblob_users_seq`
--

DROP TABLE IF EXISTS `cms_additional_htmlblob_users_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_additional_htmlblob_users_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_additional_htmlblob_users_seq`
--

LOCK TABLES `cms_additional_htmlblob_users_seq` WRITE;
/*!40000 ALTER TABLE `cms_additional_htmlblob_users_seq` DISABLE KEYS */;
INSERT INTO `cms_additional_htmlblob_users_seq` VALUES (42);
/*!40000 ALTER TABLE `cms_additional_htmlblob_users_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_additional_users`
--

DROP TABLE IF EXISTS `cms_additional_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_additional_users` (
  `additional_users_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`additional_users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_additional_users`
--

LOCK TABLES `cms_additional_users` WRITE;
/*!40000 ALTER TABLE `cms_additional_users` DISABLE KEYS */;
INSERT INTO `cms_additional_users` VALUES (29,0,NULL,52),(36,0,NULL,15),(37,0,NULL,53);
/*!40000 ALTER TABLE `cms_additional_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_additional_users_seq`
--

DROP TABLE IF EXISTS `cms_additional_users_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_additional_users_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_additional_users_seq`
--

LOCK TABLES `cms_additional_users_seq` WRITE;
/*!40000 ALTER TABLE `cms_additional_users_seq` DISABLE KEYS */;
INSERT INTO `cms_additional_users_seq` VALUES (43);
/*!40000 ALTER TABLE `cms_additional_users_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_admin_bookmarks`
--

DROP TABLE IF EXISTS `cms_admin_bookmarks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_admin_bookmarks` (
  `bookmark_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bookmark_id`),
  KEY `index_admin_bookmarks_by_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_admin_bookmarks`
--

LOCK TABLES `cms_admin_bookmarks` WRITE;
/*!40000 ALTER TABLE `cms_admin_bookmarks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_admin_bookmarks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_admin_bookmarks_seq`
--

DROP TABLE IF EXISTS `cms_admin_bookmarks_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_admin_bookmarks_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_admin_bookmarks_seq`
--

LOCK TABLES `cms_admin_bookmarks_seq` WRITE;
/*!40000 ALTER TABLE `cms_admin_bookmarks_seq` DISABLE KEYS */;
INSERT INTO `cms_admin_bookmarks_seq` VALUES (0);
/*!40000 ALTER TABLE `cms_admin_bookmarks_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_admin_recent_pages`
--

DROP TABLE IF EXISTS `cms_admin_recent_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_admin_recent_pages` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `access_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_admin_recent_pages`
--

LOCK TABLES `cms_admin_recent_pages` WRITE;
/*!40000 ALTER TABLE `cms_admin_recent_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_admin_recent_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_admin_recent_pages_seq`
--

DROP TABLE IF EXISTS `cms_admin_recent_pages_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_admin_recent_pages_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_admin_recent_pages_seq`
--

LOCK TABLES `cms_admin_recent_pages_seq` WRITE;
/*!40000 ALTER TABLE `cms_admin_recent_pages_seq` DISABLE KEYS */;
INSERT INTO `cms_admin_recent_pages_seq` VALUES (0);
/*!40000 ALTER TABLE `cms_admin_recent_pages_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_adminlog`
--

DROP TABLE IF EXISTS `cms_adminlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_adminlog` (
  `timestamp` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `username` varchar(25) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(50) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_adminlog`
--

LOCK TABLES `cms_adminlog` WRITE;
/*!40000 ALTER TABLE `cms_adminlog` DISABLE KEYS */;
INSERT INTO `cms_adminlog` VALUES (1228876824,0,'',0,'File Manager','FileManager version 0.4.3 installed'),(1228876824,0,'',0,'Module Manager','Module version 1.2.1 installed.'),(1228876824,0,'',0,'nuSOAP','Installed'),(1228876825,0,'',0,'Theme Manager','Module version 1.0.8 installed.'),(1228876825,0,'',0,'TinyMCE WYSIWYG','Module version 2.4.10 installed.'),(1228876833,1,'admin',1,'admin','User Login'),(1228876858,1,'admin',28,'User-defined tags (4.2.2) -- 28','Deleted Content'),(1228876858,1,'admin',26,'Tags in the core (4.2.1) -- 26','Deleted Content'),(1228876858,1,'admin',25,'Tags (4.2) -- 25','Deleted Content'),(1228876858,1,'admin',50,'Module Manager (4.1.6) -- 50','Deleted Content'),(1228876858,1,'admin',43,'Search (4.1.5) -- 43','Deleted Content'),(1228876858,1,'admin',42,'TinyMCE (4.1.4) -- 42','Deleted Content'),(1228876858,1,'admin',41,'Theme Manager (4.1.3) -- 41','Deleted Content'),(1228876858,1,'admin',40,'Menu Manager (4.1.2) -- 40','Deleted Content'),(1228876858,1,'admin',39,'News (4.1.1) -- 39','Deleted Content'),(1228876858,1,'admin',20,'Modules (4.1) -- 20','Deleted Content'),(1228876858,1,'admin',24,'Default Extensions (4) -- 24','Deleted Content'),(1228876858,1,'admin',44,'Minimal template (3.6) -- 44','Deleted Content'),(1228876858,1,'admin',18,'CSSMenu left + 1 column (3.5) -- 18','Deleted Content'),(1228876858,1,'admin',16,'CSSMenu top + 2 columns (3.4) -- 16','Deleted Content'),(1228876858,1,'admin',22,'Top simple navigation + left subnavigation + 1 col','Deleted Content'),(1228876858,1,'admin',13,'Left simple navigation + 1 column (3.2) -- 13','Deleted Content'),(1228876858,1,'admin',49,'CMSMS tags in the templates (3.1) -- 49','Deleted Content'),(1228876858,1,'admin',19,'Default Templates Explained (3) -- 19','Deleted Content'),(1228876858,1,'admin',47,'Where do I get help? (2.8) -- 47','Deleted Content'),(1228876858,1,'admin',38,'Workflow (2.7) -- 38','Deleted Content'),(1228876858,1,'admin',45,'Events Manager (2.6) -- 45','Deleted Content'),(1228876858,1,'admin',46,'Extensions (2.5) -- 46','Deleted Content'),(1228876858,1,'admin',30,'Menu Manager (2.4) -- 30','Deleted Content'),(1228876858,1,'admin',29,'Content (2.3) -- 29','Deleted Content'),(1228876858,1,'admin',37,'Pages and navigation (2.2) -- 37','Deleted Content'),(1228876858,1,'admin',36,'Templates and stylesheets (2.1) -- 36','Deleted Content'),(1228876858,1,'admin',34,'How CMSMS Works (2) -- 34','Deleted Content'),(1228876926,1,'admin',15,'Home','Edited Content'),(1228876934,1,'admin',15,'Home','Edited Content'),(1228876977,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877005,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877412,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877445,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877489,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877570,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228877572,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228877600,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877635,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228877679,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228877913,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228878186,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228878263,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228878292,1,'admin',15,'Home','Edited Content'),(1228878324,1,'admin',15,'Home','Edited Content'),(1228878350,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228878368,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228879029,1,'admin',15,'Home','Edited Content'),(1228879054,1,'admin',15,'Home','Edited Content'),(1228879154,1,'admin',15,'Home','Edited Content'),(1228879169,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228879256,1,'admin',15,'Home','Edited Content'),(1228879334,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228879354,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228879393,1,'admin',15,'Home','Edited Content'),(1228879561,1,'admin',15,'Home','Edited Content'),(1228879604,1,'admin',15,'Home','Edited Content'),(1228879664,1,'admin',15,'Home','Edited Content'),(1228879920,1,'admin',15,'Home','Edited Content'),(1228879944,1,'admin',15,'Home','Edited Content'),(1228880016,1,'admin',15,'Home','Edited Content'),(1228880034,1,'admin',15,'Home','Edited Content'),(1228880070,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880109,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880150,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880161,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880397,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880411,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880465,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880536,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880555,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228880570,1,'admin',15,'Home','Edited Content'),(1228880594,1,'admin',15,'Home','Edited Content'),(1228880863,1,'admin',51,'About Us','Added Content'),(1228881046,1,'admin',51,'About Us','Edited Content'),(1228881080,1,'admin',51,'About Us','Edited Content'),(1228881096,1,'admin',51,'About Us','Edited Content'),(1228881189,1,'admin',51,'About Us','Edited Content'),(1228881215,1,'admin',51,'About Us','Edited Content'),(1228881555,1,'admin',51,'About Us','Edited Content'),(1228881561,1,'admin',51,'About Us','Edited Content'),(1228881594,1,'admin',51,'About Us','Edited Content'),(1228881621,1,'admin',51,'About Us','Edited Content'),(1228881640,1,'admin',15,'Home','Edited Content'),(1228881643,1,'admin',15,'Home','Edited Content'),(1228882062,1,'admin',2,'vicmenu','Added Html Blob'),(1228882140,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228882157,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228882197,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228882324,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882331,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882334,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882335,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882404,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882413,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882487,1,'admin',2,'vicmenu','Edited Html Blob'),(1228882542,1,'admin',15,'Home','Edited Content'),(1228882558,1,'admin',15,'Home','Edited Content'),(1228882578,1,'admin',15,'Home','Edited Content'),(1228882631,1,'admin',15,'Home','Edited Content'),(1228882696,1,'admin',52,'Contact Us','Added Content'),(1228882745,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228882747,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228882765,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228882777,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228882813,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228882830,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228882840,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228882908,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228882930,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228882963,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228883011,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228883718,1,'admin',52,'Contact Us','Edited Content'),(1228883755,1,'admin',52,'Contact Us','Edited Content'),(1228883833,1,'admin',52,'Contact Us','Edited Content'),(1228883846,1,'admin',52,'Contact Us','Edited Content'),(1228883860,1,'admin',52,'Contact Us','Edited Content'),(1228883934,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228884016,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228884017,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228884055,1,'admin',-1,'','Edited Site Preferences'),(1228934745,1,'admin',1,'admin','User Login'),(1228934795,1,'admin',2,'vicmenu','Edited Html Blob'),(1228934835,1,'admin',2,'vicmenu','Edited Html Blob'),(1228934884,1,'admin',2,'vicmenu','Edited Html Blob'),(1228934901,1,'admin',2,'vicmenu','Edited Html Blob'),(1228934985,1,'admin',2,'vicmenu','Edited Html Blob'),(1228935004,1,'admin',2,'vicmenu','Edited Html Blob'),(1228935086,1,'admin',2,'vicmenu','Edited Html Blob'),(1228935155,1,'admin',2,'vicmenu','Edited Html Blob'),(1228935205,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1228935304,1,'admin',1,'admin','User Login'),(1228935323,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228935324,1,'admin',32,'Layout: Left sidebar + 1 column','Edited CSS'),(1228935412,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1228935444,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1228939240,1,'admin',1,'admin','User Login'),(1228939274,1,'admin',15,'Home','Edited Content'),(1228939338,1,'admin',51,'About Us','Edited Content'),(1228939383,1,'admin',51,'About Us','Edited Content'),(1228939394,1,'admin',51,'About Us','Edited Content'),(1228947902,1,'admin',1,'admin','User Login'),(1228947991,1,'admin',15,'Home','Edited Content'),(1228948017,1,'admin',15,'Home','Edited Content'),(1228948067,1,'admin',15,'Home','Edited Content'),(1228948326,1,'admin',15,'Home','Edited Content'),(1229121906,1,'admin',1,'admin','User Login'),(1229122038,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122103,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122146,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122181,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122215,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122233,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122265,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1229122346,1,'admin',39,'Layout: Top menu + 2 columns','Edited CSS'),(1242828963,1,'admin',1,'admin','User Login'),(1242828977,1,'admin',1,'admin','User Login'),(1242829027,1,'admin',53,'Privacy Policy','Added Content'),(1242829100,1,'admin',53,'Privacy Policy','Edited Content'),(1242829255,1,'admin',53,'Privacy Policy','Edited Content'),(1242829577,1,'admin',53,'Privacy Policy','Edited Content'),(1242829729,1,'admin',53,'Privacy Policy','Edited Content'),(1242830237,1,'admin',53,'Privacy Policy','Edited Content'),(1242830347,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830409,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830440,1,'admin',42,'custom','Added CSS'),(1242830449,1,'admin',16,'CSSMenu top + 2 columns','Added Stylesheet Association'),(1242830490,1,'admin',42,'custom','Edited CSS'),(1242830521,1,'admin',42,'custom','Edited CSS'),(1242830566,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830602,1,'admin',42,'custom','Edited CSS'),(1242830626,1,'admin',42,'custom','Edited CSS'),(1242830627,1,'admin',42,'custom','Edited CSS'),(1242830670,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830671,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830728,1,'admin',42,'custom','Edited CSS'),(1242830747,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830757,1,'admin',42,'custom','Edited CSS'),(1242830841,1,'admin',54,'Terms and Conditions of Use','Added Content'),(1242830865,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242830898,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242830946,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831028,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831363,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831498,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831525,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831680,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831682,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831732,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242831772,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242831784,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1242831787,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1242831788,1,'admin',15,'CSSMenu left + 1 column','Added Stylesheet Association'),(1242831880,1,'admin',1,'footer','Edited Html Blob'),(1242831896,1,'admin',16,'CSSMenu top + 2 columns','Edited Template'),(1242831906,1,'admin',15,'CSSMenu left + 1 column','Edited Template'),(1242831927,1,'admin',2,'custom_copyright','Edited User Defined Tag'),(1242831955,1,'admin',42,'custom','Edited CSS'),(1242831956,1,'admin',42,'custom','Edited CSS'),(1242832443,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242832913,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242832945,1,'admin',1,'admin','User Login'),(1242832998,1,'admin',54,'Terms and Conditions of Use','Edited Content'),(1242834052,1,'admin',1,'admin','User Login'),(1242835007,1,'admin',1,'admin','User Login');
/*!40000 ALTER TABLE `cms_adminlog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_content`
--

DROP TABLE IF EXISTS `cms_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_content` (
  `content_id` int(11) NOT NULL,
  `content_name` varchar(255) DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `item_order` int(11) DEFAULT NULL,
  `hierarchy` varchar(255) DEFAULT NULL,
  `default_content` tinyint(4) DEFAULT NULL,
  `menu_text` varchar(255) DEFAULT NULL,
  `content_alias` varchar(255) DEFAULT NULL,
  `show_in_menu` tinyint(4) DEFAULT NULL,
  `collapsed` tinyint(4) DEFAULT NULL,
  `markup` varchar(25) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `cachable` tinyint(4) DEFAULT NULL,
  `id_hierarchy` varchar(255) DEFAULT NULL,
  `hierarchy_path` text,
  `prop_names` text,
  `metadata` text,
  `titleattribute` varchar(255) DEFAULT NULL,
  `tabindex` varchar(10) DEFAULT NULL,
  `accesskey` varchar(5) DEFAULT NULL,
  `last_modified_by` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`content_id`),
  KEY `index_content_by_content_alias_active` (`content_alias`,`active`),
  KEY `index_content_by_default_content` (`default_content`),
  KEY `index_content_by_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_content`
--

LOCK TABLES `cms_content` WRITE;
/*!40000 ALTER TABLE `cms_content` DISABLE KEYS */;
INSERT INTO `cms_content` VALUES (15,'Home','content',1,-1,16,1,'00001',1,'Home','home',1,1,'html',1,1,'15','home','target,pagedata,extra1,extra2,extra3,image,thumbnail,searchable,Sidebar,content_en','','Home Page, shortcut key=1','','1',1,'2006-07-25 21:22:31','2008-12-10 16:32:05'),(51,'About Us','content',1,-1,16,2,'00002',0,'About Us','about-us',1,NULL,'html',1,1,'51','about-us','target,pagedata,extra1,extra2,extra3,image,thumbnail,searchable,Sidebar,content_en','','','','',1,'2008-12-09 21:47:43','2008-12-10 14:03:14'),(52,'Contact Us','content',1,-1,15,3,'00003',0,'Contact Us','contact-us',1,NULL,'html',1,1,'52','contact-us','content_en,target,pagedata,extra1,extra2,extra3,image,thumbnail,searchable','','','','',1,'2008-12-09 22:18:16','2008-12-09 22:37:40'),(53,'Privacy Policy','content',1,-1,16,4,'00004',0,'Privacy Policy','privacy-policy',1,NULL,'html',1,1,'53','privacy-policy','target,pagedata,extra1,extra2,extra3,image,thumbnail,searchable,Sidebar,content_en','','','','',1,'2009-05-20 10:17:07','2009-05-20 10:37:17'),(54,'Terms and Conditions of Use','content',1,-1,16,5,'00005',0,'Terms and Conditions of Use','terms-and-conditions-of-use',1,NULL,'html',1,1,'54','terms-and-conditions-of-use','target,pagedata,extra1,extra2,extra3,image,thumbnail,searchable,Sidebar,content_en','','','','',1,'2009-05-20 10:47:21','2009-05-20 11:23:18');
/*!40000 ALTER TABLE `cms_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_content_props`
--

DROP TABLE IF EXISTS `cms_content_props`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_content_props` (
  `content_id` int(11) DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `prop_name` varchar(255) DEFAULT NULL,
  `param1` varchar(255) DEFAULT NULL,
  `param2` varchar(255) DEFAULT NULL,
  `param3` varchar(255) DEFAULT NULL,
  `content` text,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  KEY `index_content_props_by_content_id` (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_content_props`
--

LOCK TABLES `cms_content_props` WRITE;
/*!40000 ALTER TABLE `cms_content_props` DISABLE KEYS */;
INSERT INTO `cms_content_props` VALUES (52,'string','content_en','','','','<p style=\"text-align: center;\"><img src=\"uploads/images/contactdetail1.png\" alt=\"\" width=\"315\" height=\"150\" /></p>\n<p style=\"text-align: center;\">Â </p>\n<p style=\"text-align: center;\"><img src=\"uploads/images/contactdetail.png\" alt=\"\" width=\"503\" height=\"124\" /></p>\n<p style=\"text-align: center;\">Â </p>\n<p style=\"text-align: center;\">Â </p>\n<p style=\"text-align: center;\">Â </p>\n<p style=\"text-align: center;\">Â </p>',NULL,'2008-12-09 22:37:40'),(52,'string','target','','','','',NULL,'2008-12-09 22:37:40'),(52,'string','pagedata','','','','',NULL,'2008-12-09 22:37:40'),(52,'string','extra1','','','','',NULL,'2008-12-09 22:37:40'),(52,'string','extra2','','','','',NULL,'2008-12-09 22:37:40'),(52,'string','extra3','','','','',NULL,'2008-12-09 22:37:40'),(52,'string','image','','','','-1',NULL,'2008-12-09 22:37:40'),(52,'string','thumbnail','','','','',NULL,'2008-12-09 22:37:40'),(52,'string','searchable','','','','1',NULL,'2008-12-09 22:37:40'),(15,'string','target','','','','',NULL,'2008-12-10 16:32:05'),(15,'string','pagedata','','','','',NULL,'2008-12-10 16:32:05'),(15,'string','extra1','','','','',NULL,'2008-12-10 16:32:05'),(15,'string','extra2','','','','',NULL,'2008-12-10 16:32:05'),(15,'string','extra3','','','','',NULL,'2008-12-10 16:32:05'),(15,'string','image','','','','logo1.gif',NULL,'2008-12-10 16:32:05'),(15,'string','thumbnail','','','','',NULL,'2008-12-10 16:32:05'),(15,'string','searchable','','','','1',NULL,'2008-12-10 16:32:05'),(15,'string','Sidebar','','','','<p><img src=\"uploads/images/sidebarcom.png\" alt=\"\" width=\"315\" height=\"231\" /></p>\n<p>Â </p>\n<img src=\"uploads/images/ifyou.png\" alt=\"\" width=\"112\" height=\"45\" /><br /><br style=\"line-height:5px;\" /> \n<ul>\n<li>Are attending an important event and hope to dazzle everyone with your amazing smile</li>\n<li>Are planning job interviews and want to make a great first impression</li>\n<li>Look at pictures of yourself and only see your yellowing teeth</li>\n<li>Want to look as young as you feel</li>\n<li>Understand the importance of a first impression</li>\n<li>Have found yourself thinking â€œI Want That Smile!â€</li>\n</ul>\n<p><br /> <strong>Allow us to introduce you to the easiest, fastest, most cost-effective teeth whitening process you will ever need!</strong></p>',NULL,'2008-12-10 16:32:05'),(51,'string','target','','','','',NULL,'2008-12-10 14:03:14'),(51,'string','pagedata','','','','',NULL,'2008-12-10 14:03:14'),(51,'string','extra1','','','','',NULL,'2008-12-10 14:03:14'),(51,'string','extra2','','','','',NULL,'2008-12-10 14:03:14'),(51,'string','extra3','','','','',NULL,'2008-12-10 14:03:14'),(51,'string','image','','','','-1',NULL,'2008-12-10 14:03:14'),(51,'string','thumbnail','','','','',NULL,'2008-12-10 14:03:14'),(51,'string','searchable','','','','1',NULL,'2008-12-10 14:03:14'),(51,'string','Sidebar','','','','<p><img src=\"uploads/images/sidebarcom.png\" alt=\"\" width=\"315\" height=\"231\" /></p>\r\n<p><img src=\"uploads/images/aboutussidebar.jpg\" alt=\"\" width=\"293\" height=\"268\" /></p>',NULL,'2008-12-10 14:03:14'),(51,'string','content_en','','','','<img src=\"uploads/images/aboutus.png\" alt=\"\" width=\"174\" height=\"35\" /><br /> <br />\r\n<p>Appearance matters, letâ€™s be honest. First impressions can determine everything from a successful job interview to a successful first date. And nothing makes a better first impression than a beautiful smile. Unfortunately, over the years, our smiles lose some of their lusterâ€”the bright, white teeth we once took for granted have started to yellow and age.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>I Want That Smile!</strong></span> was developed as a simple, safe and painless method of teeth whitening that is far less expensive and time consuming than what dentists offer, and far more effective than the over-the-counter products on the market today.</p>\r\n<p><strong><span style=\"color: #0663ba;\">The I Want That Smile!</span></strong> revolutionary teeth whitening system is completely self-administered. Once you make yourself comfortable in our reclining chairs, our trained assistants will guide you through the process of whitening your teeth from start to finish. Our whitening products are first quality, carbamide peroxide solutions specially formulated to increase whitening performance and decrease tooth sensitivity. To further promote the process you will have the added benefit of our LED whitening light which is completely safe for your teeth, gums and skin. At the end of the 20-minute session you can expect to see anywhere from three to eight shades of improvement, depending on the condition of your teeth.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>I</strong><strong> Want That Smile!</strong></span> is a division of Twin Towers Trading, Inc. (<a href=\"http://www.twintowerstrading.com\">www.twintowerstrading.com</a>), a company long dedicated to providing unparalleled service to its clientele. It is our hope that when you visit us you will be thoroughly satisfied.</p>\r\n<p>Â </p>\r\n<p><img src=\"uploads/images/aboutusdetails.png\" alt=\"\" width=\"504\" height=\"155\" /></p>\r\n<p>Â </p>',NULL,'2008-12-10 14:03:14'),(15,'string','content_en','','','','<p align=\"center\"><img src=\"uploads/images/in20minutes.png\" alt=\"\" width=\"416\" height=\"39\" /><br /><br /><img src=\"uploads/images/picbefore.png\" alt=\"\" width=\"250\" height=\"245\" /> <img src=\"uploads/images/picafter.png\" alt=\"\" width=\"250\" height=\"245\" /></p>\n<table cellspacing=0 cellpadding=0 border=0 >\n<tr>\n<td width=\"306\" valign=\"top\">\n<img style=\"float: left;\" src=\"uploads/images/details.jpg\" alt=\"\" width=\"306\"  />\n</td>\n<td valign=\"top\"><p>\nâ€œI Want That Smile!â€ is a tray-based, self-administered, chairside teeth whitening system. In 20 minutes you will experience results anywhere from 3-8 shades lighter. With an additional process of 20 minutes, results can increase up to 12 shades lighter!<br/><br/>\nâ€œI Want That Smile!â€ is a revolutionary process with proven results that will cost you a fraction of what a dentist would charge, in a fraction of the time.<br/><br/>\nThis is the ideal solution for busy people with little time and a strong desire to improve their appearance. It is an easy, painless, safe, low-cost cosmetic procedure that will improve your self-esteem and increase your self-confidence.</p></td></tr></table>',NULL,'2008-12-10 16:32:05'),(53,'string','target','','','','',NULL,'2009-05-20 10:37:17'),(53,'string','pagedata','','','','',NULL,'2009-05-20 10:37:17'),(53,'string','extra1','','','','',NULL,'2009-05-20 10:37:17'),(53,'string','extra2','','','','',NULL,'2009-05-20 10:37:17'),(53,'string','extra3','','','','',NULL,'2009-05-20 10:37:17'),(53,'string','image','','','','-1',NULL,'2009-05-20 10:37:17'),(53,'string','thumbnail','','','','',NULL,'2009-05-20 10:37:17'),(53,'string','searchable','','','','1',NULL,'2009-05-20 10:37:17'),(53,'string','Sidebar','','','','<p><img src=\"uploads/images/sidebarcom.png\" alt=\"\" width=\"315\" height=\"231\" /></p>\n<p><img src=\"uploads/images/aboutussidebar.jpg\" alt=\"\" width=\"293\" height=\"268\" /></p>',NULL,'2009-05-20 10:37:17'),(53,'string','content_en','','','','<p><img src=\"uploads/images/privacy-policy.png\" alt=\"\" width=\"300\" height=\"39\" /> <br /><br /> Welcome to TTTâ€™s (as defined herein) website (â€œSite(s)â€). This Site is offered as a service to our customers.  Twin Towers Trading, Inc. and its affiliates, including, without limitation, Twin Towers Trading Site Management, LLC, and Twin Towers Trading Distribution Company, LLC, (collectively, \"TTT\") are committed to the protection of consumer privacy.</p>\n<p>TTT has created this privacy policy in order to demonstrate TTTâ€™s commitment to the privacy and protection of your information.  As part of the normal operation of services, we may collect and disclose certain information about you.  To better protect your privacy, TTT provides this notice explaining our information practices and the choices you can make about the way your information is collected and used.</p>\n<p><span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>1. Personal Information Collection </strong></span></span><br /><br /> TTT may collect personal information such as name, telephone number, email address, social security number, and home or mailing address when you access certain areas of the Site that require registration for certain services.  If you decide to purchase any products or services, or marketing related materials offered by TTT, we will need to collect certain additional information, like your credit card number, credit card expiration date, shipping and billing address. <br /><br /> At other times, TTT may collect information that cannot be used to identify you.  For example, we may aggregate non-personal information about you and other customers who visit our Site. Aggregated information will not contain any information that can be linked directly back to you. <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>2. How TTT Collects Personal Information </strong></span></span><br /><br /> TTT may use any number of tools to collect information about you, your computer, and the web browser that you use to connect to our Site.  For example, cookies are tiny text files that we place on your computerâ€™s hard drive when you visit our Site.  We may use cookies to personalize your Site experience.  You do not have to accept our cookies and you may delete them after they have been placed on your hard drive.  If you do not accept or delete our cookies, some areas of our Site that you access may not function properly. <br /><br /> TTT may also collect additional information from your web browser each time you visit our Site.  We may collect information on the pages that you visit, the advertisements that you click, and other actions that you take while using our Site.  This information may include your Internet Protocol (â€œIPâ€) address, the type of browser, the time that your browser was used to access our Site, and the referring website address. <br /><br /> We may also use other standard web-based technologies to analyze your movements while accessing our Site.  The technologies include web â€œbeacons,â€ â€œpixel tags,â€ and â€œclear gifs.â€ These technologies help us ascertain the effectiveness of our advertising campaigns and marketing programs, allow us to customize the services offered on or through our Site, and help determine the best use for Site content and programming.  Some of this information, including the IP address that we obtain from your browser, may be stored on our server logs, and may be available for extended periods of time.  <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>3. Our Use and Disclosure of Your Personal Information</strong></span></span> <br /><br /> TTT uses the personally identifiable information that you provide about yourself or your business when placing an order only to complete that order.  We do not share personally identifiable information with outside parties without your consent, except to the extent necessary to complete your order or to provide the services offered on this Site.  For example, we may provide your personal information to our service providers that may handle our credit card processing or shipping services. <br /><br /> TTT may use your personal information to contact you via mail, email, or telephone in order to give you updates about TTT products, order status or changes, and other promotional events that may be of interest to you.  We use return e-mail addresses to answer the e-mail we receive; they are not used for any other purpose or shared with outside parties for marketing purposes.  We may also use your IP address to help protect TTT and our partners from fraud. <br /><br /> Additional uses of your personal information will allow us to tailor products and services specific to your needs, to help organize and manage your customer relationship and our business, to conduct business, to provide you with customer support, to perform functions that are described to you at the time of collection, and to enforce our Terms and Conditions of Use. <br /><br /> We use non-personal cumulative information to improve our Site.  We may, for example, report to an affiliate that there were a particular number of visitors to a certain area of our Site, or that X number of men and Y number of women completed our registration form, but we would not offer any information that could be used to identify those individuals.  Such information may also be used to analyze the effectiveness of our business and advertising models. <br /><br /> If you are seeking an independent contractor relationship with TTT, or seeking to fulfill other TTT business needs as may be posted from time to time, we will use that information solely in connection with your application for current or future TTT business needs, and we may also share your application information with our business partners or affiliates that have business needs that you may be qualified for. <br /><br /> TTT may also disclose your personal information as is necessary to: (a) comply with a subpoena or court order; (b) cooperate with law enforcement or other government agency; (c) establish or exercise our legal rights; (d) protect the property or safety of our company and employees, contractors, vendors and suppliers; (e) defend against legal claims; (f) help with internal and external investigations; or (g) as otherwise required by law or permitted by law.  We may disclose your information in connection with the sale or merger of TTT or any transaction that involves the sale or assignment of some or all of our assets. <br /><br /> Notwithstanding the foregoing, to the extent TTT collects any of your personal information that is subject to the laws of any jurisdiction outside of the United States including but not limited to the EU Data Protection Directive or Canadian Privacy Law, then TTT shall use that personal information solely in compliance with such laws. <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>4. Data Storage and Security </strong></span></span><br /><br /> TTT has implemented physical, electronic, and procedural security measures to assist with safeguarding your personal information, and to help protect against unauthorized access and disclosure.  Only our authorized personnel and service providers who are performing legitimate business functions for TTT are permitted to access your personal information.  We also use secure sockets layer (â€œSSLâ€) and other forms of encryption to protect any sensitive personal information that is transmitted or authorized to be transmitted by TTT, and we also use electronic firewalls to help prevent unauthorized individuals from gaining access to your personal data. <br /><br /> Notwithstanding our efforts, the Internet has inherent security risks.  TTT cannot promise, and you should not expect, that your personal information, personal searches, and other communications will always remain secure.  You should take care with regard to how you handle and disclose your personal information. <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>5. Children and Data Collection </strong></span></span><br /><br /> TTT Sites are general audience Sites.  But TTT content is neither directed toward minors nor children who are under the age of 13.  We do not knowingly collect personal information from children under the age of 13 without parental consent.  If TTT becomes aware that a child under the age of 13 has provided us with personal information without the parental consent, that information will be deleted from our databases.  Parents who have questions about personal information that may have been submitted by a child under the age of 13 should email us at <a href=\"mailto:childrensprivacy@tttradingnj.com\">childrensprivacy@tttradingnj.com</a>.  <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>6. Your California Privacy Rights </strong></span></span><br /><br /> TTT will not share any personal information about you with our third-party affiliates for our direct marketing purposes to the extent prohibited by California law, unless you agree otherwise as authorized by your prior written consent. <br /><br /> California residents have the right to request information from TTT regarding the manner that we may share personal information with affiliated companies and other third parties for their direct marketing purposes.  To find out what and how we share such information, you may send us an email request at <a href=\"mailto:californiaprivacy@tttradingnj.com\">californiaprivacy@tttradingnj.com</a> or mail a request to:  Privacy Officer, Twin Towers Trading, Inc., 1880 North Congress Avenue, Suite 215 Boynton Beach, Florida, 33426, and receive the following information: <br /><br /> A. The categories of information we disclosed to third parties for their direct marketing purposes during the preceding calendar year; <br /><br /> B. The names and addresses of the third parties who received information for their direct marketing purposes; and <br /><br /> C. Examples of the products and services subject to the third-partiesâ€™ direct marketing programs, if the nature of the third partiesâ€™ business cannot be determined from their names. <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>7. How You May Access and Change the Information that TTT Collects </strong></span></span><br /><br /> The first time that you provide us with registration information through our Site, you may be offered the opportunity to subscribe to receive additional information regarding TTTâ€™s products and services.  After your first use, you can change your initial choices by contacting the customer service email at <a href=\"mailto:ecommercesupport@tttradingnj.com\">ecommercesupport@tttradingnj.com</a>. Each commercial email that we send to you, will offer you the opportunity to opt-out of continuing to receive such messages.  We may take up to 10 business days to process your opt-out requests.  In some instances, we may have already shared your information with one of our authorized third parties before you changed your information preferences.  In those cases, you may have to directly contact those third parties to opt-out of receiving their communications. <br /><br /> FTC email compliance guidance allows us to send you transactional and relationship email without offering you the opportunity to opt-out of receiving those types of email. <br /><br /> <span style=\"color: #0663ba;\"><span style=\"text-decoration: underline;\"><strong>8. General Contact Information Privacy Support </strong></span></span><br /><br /> If you require additional information about TTTâ€™s privacy commitment, please contact us at <a href=\"mailto:privacyquestions@tttradingnj.com\">privacyquestions@tttradingnj.com</a></p>',NULL,'2009-05-20 10:37:17'),(54,'string','target','','','','',NULL,'2009-05-20 11:23:18'),(54,'string','pagedata','','','','',NULL,'2009-05-20 11:23:18'),(54,'string','extra1','','','','',NULL,'2009-05-20 11:23:18'),(54,'string','extra2','','','','',NULL,'2009-05-20 11:23:18'),(54,'string','extra3','','','','',NULL,'2009-05-20 11:23:18'),(54,'string','image','','','','-1',NULL,'2009-05-20 11:23:18'),(54,'string','thumbnail','','','','',NULL,'2009-05-20 11:23:18'),(54,'string','searchable','','','','1',NULL,'2009-05-20 11:23:18'),(54,'string','Sidebar','','','','<p><img src=\"uploads/images/sidebarcom.png\" alt=\"\" width=\"315\" height=\"231\" /></p>\r\n<p><img src=\"uploads/images/aboutussidebar.jpg\" alt=\"\" width=\"293\" height=\"268\" /></p>',NULL,'2009-05-20 11:23:18'),(31,'string','content_en',NULL,NULL,NULL,'asdf','2006-07-25 21:22:31','2006-07-25 21:22:31'),(31,'string','target',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(31,'string','pagedata',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(31,'string','extra1',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(31,'string','extra2',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(31,'string','extra3',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(32,'string','content_en',NULL,NULL,NULL,'asdf','2006-07-25 21:22:31','2006-07-25 21:22:31'),(32,'string','target',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(32,'string','pagedata',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(32,'string','extra1',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(32,'string','extra2',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(32,'string','extra3',NULL,NULL,NULL,'','2008-10-12 11:22:31','2008-10-12 11:22:31'),(54,'string','content_en','','','','<img src=\"uploads/images/terms-of-use.png\" alt=\"\" width=\"520\" height=\"39\" />\r\n<p><br />Effective Date: May 13,2009<br /><br />Welcome to TTTâ€™s (as defined herein) website(s) (â€œSite(s)â€).  This website is offered as a service to our customers. Twin Towers Trading Inc. and its affiliates, including, without limitation, Twin Towers Trading Site Management, LLC, and Twin Towers Trading Distribution Company, LLC (collectively \"TTT\") appreciate your interest in our company and your visit to this Site.  The following terms and conditions of use (â€œTOUâ€) set forth the basic rules that govern your use of the Sites.</p>\r\n<p><strong><span style=\"color: #0663ba;\">1.	Introduction.</span></strong><br /> PLEASE READ THESE TERMS AND CONDITIONS OF USE CAREFULLY BEFORE USING THIS SITE.  THEY GOVERN YOUR USE OF THE SITE.  IF YOU DO NOT AGREE TO THE TERMS STATED BELOW, YOU MAY NOT USE THE SITE.  Your use of this Site constitutes your knowledge, understanding, and acceptance of the TOU, and your agreement to be bound by the TOU.  TTT may change, edit, modify, delete, revise, or update the TOU from time to time without notice, and your use of this Site after any changes, edits, modifications, deletions, revisions, or updates are posted to the Site constitutes your agreement to comply with the posted TOU.</p>\r\n<p><strong><span style=\"color: #0663ba;\">2.	Trademarks.</span></strong><br /> The trademarks, trade names, trade dress, logos, and service marks (collectively, the \"Trademarks\") displayed on this Site are the registered and/or unregistered Trademarks of TTT, or such third party licensors that may own the displayed Trademarks.  Nothing contained on this Site or in the TOU serves to grant to you, by implication or otherwise, any license or right to use any Trademarks displayed on this Site without the written permission of TTT or such third party licensors that may own the displayed Trademarks</p>\r\n<p><span style=\"color: #0663ba;\"><strong>3.	Site Contents and Copyright.</strong></span><br /> The text, Trademarks, logos, images, graphics, photos, video files, application functionality, or any other digital media, and their arrangement on this Site (â€œContentâ€) are all subject to patent, copyright, trademark and other intellectual property protection.  Content may not be copied for commercial use or distribution, nor may Content be modified, processed, or reposted to other websites.  Access to and use of this Site are allowed solely for your purchase of TTT products or services, information, education, entertainment, and communication with TTT.  You may download, copy or print the Content of this Site for your non-commercial limited use only.  No right, title, or interest in any of the Content of this Site is transferred to you as a result of any downloading, copying, printing or use of this Site.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>4.	User Comments and Other Submissions.</strong></span><br /> While TTT desires to receive feedback from its customers, please do not send TTT any unsolicited creative or original concepts, ideas, materials or products, confidential or proprietary information, or the like (â€œSubmission(s)â€).  TTT is under no obligation to use or compensate you for your Submissions.  TTT will not respond to you regarding your Submissions, and your Submissions will not be returned to you and will not be treated as confidential information.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>5.	License to Use Submissions.</strong></span><br /> This Site may provide you with the opportunity to submit user-generated or third-party Submissions.  By submitting items to this Site, you represent that you own or have unencumbered, transferable rights and permissions, including, without limitation, the right of publicity, to the Submissions that you submit.  If your Submission contains photographs or digital or video images that depict a child that is under the age of majority in their state of residence, you represent that you have written permission from the child\'s parent or guardian to provide the photo, digital, or video image.  If you make a Submission to this Site, you automatically grant TTT a perpetual, worldwide, unlimited, irrevocable, transferable, assignable, royalty-free license for TTT to use that Submission for any lawful purpose whatsoever, including, without limitation, the right to sublicense that Submission to third parties for their lawful uses and purposes.  Subject to existing laws, you waive any moral rights that you or your licensors may have in any Submission.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>6.	No Endorsement or Liability for User-Generated or Third-Party Content.</strong></span><br /> Although third-party or user-generated Submissions may be posted on this Site, the posting of those Submissions does not constitute TTTâ€™s endorsement of those Submissions.  TTT is not responsible or liable for any claim, including, without limitation, loss or injury to real, tangible, or intellectual property, violations of personal privacy or privacy rights, actual, consequential or punitive damages, personal injury, or wrongful death in connection with third-party or user-generated Submissions.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>7.	Third-Party Links.</strong></span><br /> To the extent that the Sites may allow third-party links, those links may direct you to third-party websites that are not affiliated with TTT.  TTT is not liable for any harm or damages related to the purchase or use of goods, services, resources, content, or any other transactions (â€œThird-Party Productsâ€) made in connection with any third-party websites.  Please review carefully the third party\'s policies and practices and make sure you understand them before you engage in any transaction.  Complaints, claims, concerns, or questions regarding Third-Party Products should be directed to the third party.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>8.	Copyrights and Digital Millennium Copyright Agents.</strong></span><br /> Pursuant to our rights under the Digital Millennium Copyright Act (â€œDMCAâ€), 17 U.S.C. Â§ 512, we have designated a copyright agent to receive copyright infringement notices for claims of infringement related to materials found on this Site.  Our copyright agent is TTTâ€™s Administrative Assistant. The agent can be reached at (732) - 786-8010, <a href=\"mailto:copyrightalert@tttradingnj.com\">copyrightalert@tttradingnj.com</a>, or via U.S. Mail at 10 Station Street, Manalapan, NJ 07726.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>9.	DMCA Infringement Notification.</strong></span><br /> To be effective, your infringement notification must include the following:</p>\r\n<ol>\r\n<li>A physical or electronic signature of a person authorized to act on behalf of the owner of an exclusive right that is allegedly infringed; </li>\r\n<li>Identification of the copyrighted work claimed to have been infringed, or, if multiple copyrighted works at a single online site are covered by a single notification, a representative list of such works at that site; </li>\r\n<li>Identification of the material or content that is claimed to be infringing or to be the subject of infringing activity and that is to be removed or have access disabled, and information reasonably sufficient to permit us to locate the material; </li>\r\n<li>Information reasonably sufficient to permit us to contact the complaining party, including address, telephone number and email address where the complaining party may be contacted; </li>\r\n<li>The following statement:  â€œI have a good faith belief that use of the material in the manner complained of is not authorized by the copyright owner, its agent, or the law;â€ and </li>\r\n<li>The following statement:  â€œThe information in this notification is accurate, and under penalty of perjury, I swear that I am the copyright owner or that I am authorized to act on behalf of the owner of an exclusive right that is allegedly infringed.â€ </li>\r\n</ol>\r\n<p>Upon receipt of the written notification containing the information as outlined in 1 through 6 above:</p>\r\n<ol>\r\n<li>TTT will remove or disable access to the content that is alleged to be infringing; </li>\r\n<li>TTT will forward the written notification to the alleged infringer; and </li>\r\n<li>TTT will take reasonable steps to promptly notify the alleged infringer that we have removed or disabled access to the content.</li>\r\n</ol>\r\n<p>DMCA Infringement Counter Notification.<br /> Pursuant to the DMCA, after the alleged infringer receives a notice of infringement from TTT, the alleged infringer will have the opportunity to respond to TTT with a counter notification (â€œCounter Notificationâ€).  To be effective, a Counter Notification must be a written communication provided to TTTâ€™s designated copyright agent, and must include the following:</p>\r\n<ol>\r\n<li>A physical or electronic signature of the subscriber; </li>\r\n<li>Identification of the material that has been removed or to which access has been disabled and the location at which the material appeared before it was removed or access disabled; </li>\r\n<li>The following statement:  â€œI swear under penalty of perjury that it is my good faith belief that the material identified above was removed or disabled as a result of mistake or misidentification of the material to be removed or disabled;â€ and </li>\r\n<li>The subscriberâ€™s name, address, and telephone number, and a statement that the subscriber consents to the jurisdiction of the federal district court for the judicial district in which the subscriber address is located, or if the subscriberâ€™s address is outside of the United States, or any judicial district in which TTT may be found, and that the subscriber will accept service of process from the person who provided notification or an agent of such person. </li>\r\n</ol>\r\n<p>Upon the copyright agentâ€™s receipt of a Counter Notification containing the information as outlined in 1 through 4 above, the DMCA provides that the removed material will be restored or access re-enabled and we will comply with this requirement as required by law, provided that the designated agent has not received notice from the original complaining party that an action has been filed seeking a court order to restrain the subscriber from engaging in infringing activity relating to the material on our network.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>10.	Prohibited Uses.</strong></span><br /> In addition to other prohibitions as set forth in the TOU, you are prohibited from using the Site or its Content:  (a) for any unlawful purpose; (b) to solicit others to perform or participate in any unlawful acts; (c) to violate any international, federal, or state regulations, rules, laws, or local ordinances; (d) to infringe upon or violate our intellectual property rights or the intellectual property rights of others; (e) to harass, abuse, insult, harm, defame, slander, disparage, intimidate, or discriminate based on gender, sexual orientation, religion, ethnicity, race, age, national origin, or disability; (f) to submit false or misleading information; (g) to upload or transmit viruses or any other type of malicious code that will or may be used in any way that will affect the functionality or operation of this Site, other websites, or the Internet; (h) to collect or track the personal information of others; (i) to spam, phish (email fraud), pharm (web traffic redirection fraud), pretext, spider, crawl, or scrape; (j) for any obscene or immoral purpose; or (k) to interfere with or circumvent the security features of this Site, other websites, or the Internet.  We reserve the right to terminate your use of the Site for violating any of the prohibited uses.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>11.	Registration, Accounts and Passwords.</strong></span><br /> You are responsible for the personal protection and security of any password or username that you may use to access this Site.  You are responsible for all direct or indirect damages and liable for all activity conducted on this Site that can be linked or traced back to any prohibited uses of the Sites conducted under your username or password.  You are obligated to immediately report a lost or stolen password or username to TTT.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>12.	Site Updates.</strong></span><br /> TTT undertakes no obligation to update, amend or clarify information on this Site, including, without limitation, pricing information, except as required by law.  No specified update or refresh date applied on this Site should be taken to indicate that all information on the Site has been modified or updated.  Please remember when reviewing information on this Site that such information may not represent the complete information available on a subject.  In addition, subsequent events or changes in circumstances may cause existing information on this Site to become inaccurate or incomplete. <br /> On occasion, information on this Site may contain errors, including, without limitation, typographical errors, inaccuracies, or omissions related to product availability, special offers, product promotions, pricing information, product descriptions, or product shipping charges and transit times.  TTT reserves the right to, at any time without prior notice, correct any errors, inaccuracies or omissions and to change or update information or cancel orders if any information on the Site is inaccurate (including after you have submitted your order).</p>\r\n<p><span style=\"color: #0663ba;\"><strong>13.	Product and Pricing Information.</strong></span><br /> This Site, Content, product information, and any products sold through the Site are intended to comply with U.S. laws and regulations.  If you are a non-U.S. based user, be advised that other countries may have laws, regulatory requirements, and product safety requirements that are different than those in the U.S. <br /><br /> TTT reserves the right, but is not obligated, to limit the sales of its products or services to any person, geographic region or jurisdiction.  We may exercise this right on a case-by-case basis.  We reserve the right to limit the quantities of any products or services that we offer.  All descriptions of products or product pricing are subject to change at any time without notice at the sole discretion of TTT.  TTT reserves the right to discontinue any product at any time.  Any offer for any product or service made on this Site is void where prohibited.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>14.	Graphical Depiction of Products.</strong></span><br /> TTT, and in some cases, TTTâ€™s licensors have used their best efforts to display, as accurately as possible, the colors of the products displayed on the Sites.  But the colors you actually see will depend on the capabilities or technical limitations of the equipment that you use to access the Sites.  As such, TTT cannot guarantee that your monitor\'s display of any color will be accurate.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>15.	Limitations on Liability.</strong></span><br /> YOU ACKNOWLEDGE, BY YOUR USE OF THIS SITE:  (1) THAT YOUR USE OF THIS SITE IS AT YOUR SOLE RISK; (2) THAT YOU ASSUME FULL RESPONSIBILITY FOR ALL COSTS ASSOCIATED WITH ALL NECESSARY SERVICING OR REPAIRS OF ANY EQUIPMENT THAT YOU USE IN CONNECTION WITH YOUR USE OF THIS SITE; AND (3) THAT TTT WILL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND RELATED TO YOUR USE OF OR INABILITY TO USE OUR SITE, INCLUDING, WITHOUT LIMITATION, FAILURE OF PERFORMANCE, ERROR, OMISSION, INTERRUPTION, COMPUTER VIRUS, OR NETWORK OR INTERNET FAILURE, OR INCLUDING, WITHOUT LIMITATION, DIRECT, INDIRECT, SPECIAL, COMPENSATORY OR CONSEQUENTIAL DAMAGES, LOST PROFITS AND/OR LOSS OF OR DAMAGE TO PROPERTY WHETHER THE ALLEGED LIABILITY IS BASED ON CONTRACT, TORT, NEGLIGENCE STRICT LIABILITY OR ANY OTHER BASIS, EVEN IF TTT HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.  IN NO EVENT WILL TTTâ€™S TOTAL LIABILITY FOR ANY CLAIMS RELATED TO THIS SITE EXCEED FIFTY ($50) DOLLARS. <br /><br /> BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, TTTâ€™S, ITS AFFILIATESâ€™, AGENTSâ€™, LICENSORSâ€™ AND SUPPLIERSâ€™ DAMAGES IN SUCH JURISDICTIONS SHALL BE LIMITED TO THE EXTENT PERMITTED BY LAW.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>16.	Disclaimer.</strong></span><br /> THE CONTENT PROVIDED ON THIS SITE IS PROVIDED â€œAS ISâ€ AND â€œWITH ALL FAULTS.â€  TTT MAKES NO WARRANTY OR REPRESENTATION, EITHER EXPRESS OR IMPLIED, AS TO ITS USE, AVAILABILITY, CONTENT ACCURACY, APPROPRIATENESS OR PERFORMANCE OF THIS SITE.  AS A USER, YOU ASSUME ALL RISKS AND RESPONSIBILITIES FOR ITS USE OR NON-USE, AND TTT MAKES NO REPRESENTATION THAT THE CONTENT APPEARING ON OR DOWNLOADED FROM THIS SITE IS COMPATIBLE WITH YOUR COMPUTER OR FREE FROM ERROR OR VIRUSES.  NO TTT EMPLOYEE, AGENT OR REPRESENTATIVE IS AUTHORIZED TO MODIFY OR AMEND THIS WARRANTY.  TO THE EXTENT ALLOWABLE BY EXISTING LAW, TTT DISCLAIMS ALL OTHER WARRANTIES, EITHER EXPRESSED OR IMPLIED, INCLUDING, WITHOUT LIMITATION, TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THIS SITE AND ITS CONTENT.  SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, OR LIMITATION ON HOW LONG AN IMPLIED WARRANTY LASTS, SO THE ABOVE LIMITATIONS OR EXCLUSIONS MAY NOT APPLY TO YOU. <br /><br /> TTT RESERVES THE RIGHT TO ALTER OR REMOVE SITE CONTENT, OR SUSPEND OR TERMINATE YOUR USE IN ANY WAY, AT ANY TIME, FOR ANY REASON, WITHOUT PRIOR NOTIFICATION, AND TTT WILL NOT BE LIABLE IN ANY WAY FOR POSSIBLE CONSEQUENCES OF THAT ACTION.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>17.	Indemnification.</strong></span><br /> YOU AGREE TO INDEMNIFY AND HOLD TTT, ITS DIRECTORS, OFFICERS, EMPLOYEES, AGENTS, CONTRACTORS, AND AFFILIATES HARMLESS FROM AND AGAINST ANY AND ALL CLAIMS, DAMAGES, COSTS AND EXPENSE, INCLUDING ATTORNEY FEES, ARISING FROM OR RELATED TO YOUR USE OF THIS SITE OR BREACH OF THESE TOU.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>18.	Termination.</strong></span><br /> TTT may terminate the TOU at any time and may do so immediately without notice, and accordingly deny you access to this Site, if in TTT\'s sole discretion, you fail to comply with any term or provision of the TOU.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>19.	Choice of Law and Forum.</strong></span><br /> These TOU will be governed and construed in accordance with the laws of the State of Florida, without regard to its conflicts of law rules.  For all disputes arising out of or relating to this Site or TOU, you submit to the exclusive personal jurisdiction and venue of the state and federal courts located in Palm Beach County, Florida.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>20.	Notice and Consent to Electronic Communications.</strong></span><br /> When you visit this Site or send e-mails to us, you are communicating with us electronically.  You consent to receive communications from us electronically.  We will communicate with you by e-mail or by posting notices on this Site.  You agree that all agreements, notices, disclosures and other communications that we provide to you electronically satisfy any legal requirement that such communications be in writing.</p>\r\n<p><span style=\"color: #0663ba;\"><strong>21.	Privacy Statement.</strong></span><br /> TTT is committed to protecting the privacy of the visitors to this Site.  For information on how information is collected, used, or disclosed by TTT in connection with your use of this Site, please consult our {cms_selflink page=\"privacy-policy\" text=\"Privacy Policy\"} which is incorporated into the TOU by reference.</p>\r\n<p><strong><span style=\"color: #0663ba;\">22.	No other Agreements.</span></strong><br /> By agreeing to the TOU, you represent that you are at least the age of majority in your state of residence, or that you are the age of majority in your state of residence and you have given TTT your consent to allow any of your minor dependents to use this Site.  The provisions and conditions of the TOU constitute the entire agreement between you and TTT related to the use of the Site and supersedes any prior agreements or understandings not incorporated in the TOU.  The TOU are effective as of the Effective Date. Continued use of the Site by you after the Effective Date constitutes your acceptance of the TOU after the Effective Date.</p>\r\n<p>Should you have any questions concerning the TOU, or if you desire to contact TTT for any reason, please contact our <a href=\"mailto:sandy@tttradingnj.com\">Webmaster</a>.</p>',NULL,'2009-05-20 11:23:18');
/*!40000 ALTER TABLE `cms_content_props` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_content_props_seq`
--

DROP TABLE IF EXISTS `cms_content_props_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_content_props_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_content_props_seq`
--

LOCK TABLES `cms_content_props_seq` WRITE;
/*!40000 ALTER TABLE `cms_content_props_seq` DISABLE KEYS */;
INSERT INTO `cms_content_props_seq` VALUES (50);
/*!40000 ALTER TABLE `cms_content_props_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_content_seq`
--

DROP TABLE IF EXISTS `cms_content_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_content_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_content_seq`
--

LOCK TABLES `cms_content_seq` WRITE;
/*!40000 ALTER TABLE `cms_content_seq` DISABLE KEYS */;
INSERT INTO `cms_content_seq` VALUES (54);
/*!40000 ALTER TABLE `cms_content_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_crossref`
--

DROP TABLE IF EXISTS `cms_crossref`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_crossref` (
  `child_type` varchar(100) DEFAULT NULL,
  `child_id` int(11) DEFAULT NULL,
  `parent_type` varchar(100) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  KEY `index_crossref_by_child_type_child_id` (`child_type`,`child_id`),
  KEY `index_crossref_by_parent_type_parent_id` (`parent_type`,`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_crossref`
--

LOCK TABLES `cms_crossref` WRITE;
/*!40000 ALTER TABLE `cms_crossref` DISABLE KEYS */;
INSERT INTO `cms_crossref` VALUES ('global_content',2,'template',15,'2009-05-20 11:05:06','2009-05-20 11:05:06'),('global_content',1,'template',16,'2009-05-20 11:04:56','2009-05-20 11:04:56'),('global_content',1,'template',17,'2006-07-25 21:22:32','2006-07-25 21:22:32'),('global_content',1,'template',18,'2006-07-25 21:22:32','2006-07-25 21:22:32'),('global_content',1,'template',15,'2009-05-20 11:05:06','2009-05-20 11:05:06');
/*!40000 ALTER TABLE `cms_crossref` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_css`
--

DROP TABLE IF EXISTS `cms_css`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_css` (
  `css_id` int(11) NOT NULL,
  `css_name` varchar(255) DEFAULT NULL,
  `css_text` text,
  `media_type` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`css_id`),
  KEY `index_css_by_css_name` (`css_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_css`
--

LOCK TABLES `cms_css` WRITE;
/*!40000 ALTER TABLE `cms_css` DISABLE KEYS */;
INSERT INTO `cms_css` VALUES (41,'Handheld','/*********************************************\r\nSample stylesheet for mobile and small screen handheld devices\r\n\r\nJust a simple layout suitable for smaller screens with less \r\nstyling cabapilities and minimal css\r\n\r\nNote: If you dont want to support mobile devices you can\r\nsafely remove this stylesheet.\r\n*********************************************/\r\n/* remove all padding and margins and set width to 100%. This should be default for handheld devices but its good to set these explicitly */\r\nbody {\r\nmargin:0;\r\npadding:0;\r\nwidth:100%;\r\n}\r\n\r\n/* hide accessibility noprint and definition */\r\n.accessibility,\r\n.noprint,\r\ndfn {\r\ndisplay:none;\r\n}\r\n\r\n/* dont want to download image for header so just set bg color */\r\ndiv#header,\r\ndiv#footer {\r\nbackground-color: #385C72;  \r\ncolor: #fff;\r\ntext-align:center;\r\n}\r\n\r\n/* text colors for header and footer */\r\ndiv#header a,\r\ndiv#footer a {\r\ncolor: #fff;\r\n}\r\n\r\n/* this doesnt look as nice, but takes less space */\r\ndiv#menu_vert ul li,\r\ndiv#menu_horiz ul li {\r\ndisplay:inline;\r\n}\r\n\r\n/* small border at the bottom to have some indicator */\r\ndiv#menu_vert ul,\r\ndiv#menu_horiz ul {\r\nborder-bottom:1px solid #fff;\r\n}\r\n\r\n/* save some space */\r\ndiv.breadcrumbs {\r\ndisplay:none;\r\n}','handheld','2006-07-25 21:22:32','2006-07-25 21:22:32'),(30,'Print','/*\r\nSections that are hidden when printing the page. We only want the content printed.\r\n*/\r\n\r\n\r\nbody {\r\ncolor: #000 !important; /* we want everything in black */\r\nbackground-color:#fff !important; /* on white background */\r\nfont-family:arial; /* arial is nice to read ;) */\r\nborder:0 !important; /* no borders thanks */\r\n}\r\n\r\n/* This affects every tag */\r\n* {\r\nborder:0 !important; /* again no borders on printouts */\r\n}\r\n\r\n/* \r\nno need for accessibility on printout. \r\nMark all your elements in content you \r\ndont want to get printed with class=\"noprint\"\r\n*/\r\n.accessibility,\r\n.noprint\r\n {\r\ndisplay:none !important; \r\n}\r\n\r\n/* \r\nremove all width constraints from content area\r\n*/\r\ndiv#content,\r\ndiv#main {\r\ndisplay:block !important;\r\nwidth:100% !important;\r\nborder:0 !important;\r\npadding:1em !important;\r\n}\r\n\r\n/* hide everything else! */\r\ndiv#header,\r\ndiv#header h1 a,\r\ndiv.breadcrumbs,\r\ndiv#search,\r\ndiv#footer,\r\ndiv#menu_vert,\r\ndiv#news,\r\ndiv.right49,\r\ndiv.left49,\r\ndiv#sidebar  {\r\n   display: none !important;\r\n}\r\n\r\nimg {\r\nfloat:none; /* this makes images couse a pagebreak if it doesnt fit on the page */\r\n}','print','2006-07-25 21:22:32','2006-07-25 21:22:32'),(31,'Accessibility and cross-browser tools','/* accessibility */\r\n\r\n/* \r\nmenu links accesskeys \r\n*/\r\nspan.accesskey {\r\n   text-decoration:none;\r\n}\r\n\r\n/* \r\naccessibility divs are hidden by default \r\ntext, screenreaders and such will show these \r\n*/\r\n.accessibility, hr {\r\n   position: absolute;\r\n   top: -999em;\r\n   left: -999em;\r\n}\r\n\r\n/* \r\ndefinition tags are also hidden \r\nthese are also used for menu links    \r\n*/\r\ndfn {\r\n   position: absolute;\r\n   left: -1000px;\r\n   top: -1000px;\r\n   width: 0;\r\n   height: 0;\r\n   overflow: hidden;\r\n   display: inline;\r\n}\r\n/* end accessibility */\r\n\r\n\r\n/* wiki style external links */\r\n/* external links will have \"(external link)\" text added, lets hide it */\r\na.external span {\r\n  position: absolute;\r\n  left: -5000px;\r\n  width: 4000px;\r\n}\r\n\r\n/* make some room for the image */\r\na.external {\r\n/* css shorthand rules, read: first top padding 0 then right padding 12px then bottom then right */\r\n  padding: 0 12px 0 0;\r\n}\r\n/* colors for external links */\r\na.external:link {\r\n  color: #18507C;\r\n/* background image for the link to show wiki style arrow */\r\n  background: url(images/cms/external.gif) no-repeat 100% 0;\r\n}\r\na.external:visited {\r\n  color: #18507C; /* a different color can be used for visited external links */\r\n\r\n/* \r\nSet the last 0 to -100px to use that part of the external.gif image for different color for active links \r\nexternal.gif is actually 300px tall, we can use different positions of the image to simulate rollover image changes.\r\n*/\r\n  background: url(images/cms/external.gif) no-repeat 100% 0; \r\n}\r\n\r\na.external:hover {\r\n  color: #18507C;\r\n/* Set the last 0 to -200px to use that part of the external.gif image for different color on hover */\r\n  background: url(images/cms/external.gif) no-repeat 100% 0; \r\n  background-color: #C3D4DF;\r\n}\r\n/* end wiki style external links */\r\n\r\n\r\n/* clearing */\r\n/* \r\nclearfix is a hack for divs that hold floated elements. it will force the holding div to span all the way down to last floated item.\r\nWe strongly recommend against using this as it is a hack and might not render correctly but it is included here for convenience.\r\nDo not edit if you dont know what you are doing\r\n*/\r\n	.clearfix:after {\r\n		content: \".\"; \r\n		display: block; \r\n		height: 0; \r\n		clear: both; \r\n		visibility: hidden;\r\n	}\r\n	* html>body .clearfix {\r\n		display: inline-block; \r\n		width: 100%;\r\n	}\r\n	\r\n	* html .clearfix {\r\n		/* Hides from IE-mac \\*/\r\n		height: 1%;\r\n		/* End hide from IE-mac */\r\n	}\r\n\r\n/* end clearing */','screen','2006-07-25 21:22:32','2006-07-25 21:22:32'),(32,'Layout: Left sidebar + 1 column','/*****************\r\nbrowsers interpret margin and padding a little differently, \r\nwe\'ll remove all default padding and margins and\r\nset them later on\r\n******************/\r\n* {\r\nmargin:0;\r\npadding:0;\r\n}\r\n\r\n/*\r\nSet initial font styles\r\n*/\r\nbody {\r\n   text-align: left;\r\n   font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;\r\n   font-size: 75.01%;\r\n   line-height: 1em;\r\n}\r\n\r\n/*\r\nset font size for all divs,\r\nthis overrides some body rules\r\n*/\r\ndiv {\r\n   font-size: 1em;\r\n}\r\n\r\n/*\r\nif img is inside \"a\" it would have \r\nborders, we don\'t want that\r\n*/\r\nimg {\r\n   border: 0;\r\n}\r\n\r\n/*\r\ndefault link styles\r\n*/\r\n/* set all links to have underline and bluish color */\r\na,\r\na:link \r\na:active {\r\n   text-decoration: underline;\r\n/* css validation will give a warning if color is set without background color. this will explicitly tell this element to inherit bg colour from parent element */\r\n   background-color: inherit; \r\n   color: #18507C; \r\n}\r\n\r\na:visited {\r\n   text-decoration: underline;\r\n   background-color: inherit;\r\n  color: #18507C;                /* a different color can be used for visited links */\r\n}\r\n\r\n\r\n/* remove underline on hover and change color */\r\na:hover {\r\n   text-decoration: none;\r\n   /*background-color: #C3D4DF;*/\r\n   color: #385C72;\r\n}\r\n\r\n/*****************\r\nbasic layout \r\n*****************/\r\nbody {\r\n   background-color: #98c7e6;\r\n   color: #333;\r\n   margin:47px;    /* gives some air for the pagewrapper */\r\n}\r\n\r\n/* center wrapper, min max width */\r\ndiv#pagewrapper {\r\n   border-left: 1px solid #ffffff;\r\n   border-right: 1px solid #ffffff;\r\n   margin: 0 auto;       /* this centers wrapper */\r\n   max-width: 978px;   /* IE wont understand these, so we will use javascript magick */\r\n   min-width: 978px;\r\n   background: url(images/bgpage.jpg) repeat-x #ffffff;\r\n   color: black;\r\n}\r\n\r\n\r\n/*** header ***\r\nwe will hide text and replace it with a image\r\nwe need to assign a height for it so that the image wont cut off\r\n*/\r\ndiv#header {\r\n   height: 80px;    /* adjust according your image size */\r\n   background: #385C72;           \r\n}\r\n\r\ndiv#header h1 a {\r\n/* you can set your own image here */\r\n   background: #385C72 url(images/cms/logo1.gif) no-repeat 0 12px; \r\n   display: block;\r\n   height: 80px;             /* adjust according your image size */\r\n   text-indent: -999em;  /* this hides the text */\r\n   text-decoration:none; /* old firefox would have shown underline for the link, this explicitly hides it */\r\n}\r\n\r\n/* position for the search box */\r\ndiv#search {\r\n   float: right;\r\n   width: 27em;    /* enough width for the search input box */\r\n   text-align: right;\r\n   padding: 0.6em 0 0.2em 0;\r\n   margin: 0 1em;\r\n}\r\n\r\ndiv.breadcrumbs {\r\n   padding: 1em 0 1.2em 0; /* CSS short hand rule first value is top then right, bottom and left */\r\n   font-size: 90%;        /* its good to set fontsizes to be relative, this way viewer can change his/her fontsize */\r\n   margin: 0 1em;        /* css shorthand rule will be opened to be \"0 1em 0 1em\" */\r\n   border-bottom: 1px dotted #000;\r\n}\r\n\r\n div.breadcrumbs span.lastitem { \r\n   font-weight:bold; \r\n } \r\n\r\n div#content {\r\n   margin:0 auto 0 0;   /* some air above and under menu and content */\r\n}\r\n\r\n\r\ndiv#main {\r\n   margin-left: 40px; /* this will give room for sidebar to be on the left side, make sure this space is bigger than sidebar width */\r\n   margin-right: 40px; /* and some air on the right */\r\n}\r\n\r\ndiv#sidebar {\r\n   float: left;        /* set sidebar on the left side. Change to right to float it right instead. */\r\n   width: 26%;     /* sidebar width, if you change this please also change #main margins */\r\n   display: inline;  /* FIX IE double margin bug */\r\n   margin-left: 0;\r\n}\r\n\r\ndiv#footer {\r\n   clear: both;       /* keep footer below content and menu */\r\n   color: #fff;\r\n   background-color: #385C72; /* same bg color as in header */\r\n}\r\n\r\ndiv#footer p {\r\n   font-size: 0.8em;\r\n   padding: 1.5em;       /* some air for footer */\r\n   text-align: center;  /* centered text */\r\n   margin: 0;\r\n}\r\n\r\ndiv#footer p a {\r\n   color: #fff; /* needed becouse footer link would be same color as background otherwise */\r\n}\r\n\r\n/* as we hid all hr for accessibility we create new hr with extra div element */\r\ndiv.hr {\r\n   height: 1px;\r\n   padding: 1em;\r\n   border-bottom: 1px dotted black;\r\n   margin: 1em;\r\n}\r\n\r\n/* relational links under content */\r\ndiv.left49 {\r\n  width: 49%; /* 50% for both left and right might lead to rounding error on some browser */\r\n}\r\n\r\ndiv.right49 {\r\n  float: right;\r\n  width: 49%;\r\n  text-align: right;\r\n}\r\n\r\n\r\n\r\n\r\n/********************\r\nCONTENT STYLING\r\n*********************/\r\ndiv#content {\r\n\r\n}\r\n\r\n/* HEADINGS */\r\ndiv#content h1 {\r\n   font-size: 2em; /* font size for h1 */\r\n   line-height: 1em;\r\n   margin: 0;\r\n}\r\ndiv#content h2 {\r\n	color: #294B5F; \r\n	font-size: 1.5em; \r\n	text-align: left; \r\n/* some air around the text */\r\n	padding-left: 0.5em;\r\n	padding-bottom: 1px;\r\n/* set borders around header */\r\n	border-bottom: 1px solid #e7ab0b; \r\n	border-left: 1.1em solid #e7ab0b; \r\n        line-height: 1.5em;\r\n/* and some air under the border */\r\n        margin: 0 0 0.5em 0;\r\n}\r\ndiv#content h3 {\r\n   color: #294B5F; \r\n   font-size: 1.3em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.5em 0;\r\n}\r\ndiv#content h4 {\r\n   color: #294B5F; \r\n   font-size: 1.2em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.25em 0;\r\n}\r\ndiv#content h5 {\r\n   color: #294B5F; \r\n   font-size: 1.1em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.25em 0;\r\n}\r\nh6 {\r\n   color: #294B5F; \r\n   font-size: 1em;\r\n   line-height: 1.3em;\r\n   margin: 0 0 0.25em 0;\r\n}\r\n/* END HEADINGS */\r\n\r\n/* TEXT */\r\np {\r\n   font-size: 1em;\r\n   margin: 0 0 1.5em 0; /* some air around p elements */\r\n   line-height: 1.4em;\r\n   padding: 0;\r\n}\r\n\r\nblockquote {\r\n   border-left: 10px solid #ddd;\r\n   margin-left: 10px;\r\n}\r\nstrong, b {\r\n/* explicit setting for these */\r\n   font-weight: bold;\r\n}\r\nem, i {\r\n/* explicit setting for these */\r\n   font-style:italic;\r\n}\r\n\r\n/* Wrapping text in <code> tags. Makes CSS not validate */\r\ncode, pre {\r\n white-space: pre-wrap;       /* css-3 */\r\n white-space: -moz-pre-wrap;  /* Mozilla, since 1999 */\r\n white-space: -pre-wrap;      /* Opera 4-6 */\r\n white-space: -o-pre-wrap;    /* Opera 7 */\r\n word-wrap: break-word;       /* Internet Explorer 5.5+ */\r\n font-family: \"Courier New\", Courier, monospace;\r\n font-size: 1em;\r\n}\r\n\r\npre {\r\n   border: 1px solid #000;  /* black border for pre blocks */\r\n   background-color: #ddd;\r\n   margin: 0 1em 1em 1em;\r\n   padding: 0.5em;\r\n   line-height: 1.5em;\r\n   font-size: 90%;\r\n\r\n\r\n}\r\n\r\n/* Separating the divs on the template explanation page, with some bottom-border */\r\ndiv.templatecode {\r\n  margin: 0 0 2.5em;\r\n}\r\n\r\n/* END TEXT */\r\n\r\n/* LISTS */\r\n/* lists in content need some margins to look nice */\r\ndiv#main ul,\r\ndiv#main ol,\r\ndiv#main dl {\r\n   font-size: 1.0em;\r\n   line-height: 1.4em;\r\n   margin: 0 0 1.5em 0;\r\n}\r\n\r\ndiv#main ul li,\r\ndiv#main ol li {\r\n   margin: 0 0 0.25em 3em;\r\n}\r\n\r\n/* definition lists topics on bold */\r\ndiv#main dl dt {\r\n   font-weight: bold;\r\n   margin: 0 0 0 1em;\r\n}\r\ndiv#main dl dd {\r\n   margin: 0 0 1em 1em;\r\n}\r\n\r\ndiv#main dl {\r\n  margin-bottom: 2em;\r\n  padding-bottom: 1em;\r\n  border-bottom: 1px solid #c0c0c0;\r\n}\r\n\r\n\r\n/* END LISTS */','screen','2006-07-25 21:22:32','2008-12-10 12:55:24'),(33,'Navigation: CSSMenu - Vertical','/* Vertical menu for the CMS CSS Menu Module */\r\n/* by Alexander Endresen */\r\n\r\n\r\n/* The wrapper determines the width of the menu elements */\r\n#menuwrapper { \r\n   width: 100%; \r\n}\r\n\r\n\r\n/* Unless you know what you do, do not touch this */ \r\n#primary-nav, #primary-nav ul { \r\n   list-style: none; \r\n   margin: 0px; \r\n   padding: 0px; \r\n   width: 100%; \r\n   margin-left: -1px;\r\n}\r\n#primary-nav ul { \r\n   position: absolute; \r\n   top: 0; \r\n   left: 100%; \r\n   display: none; \r\n}\r\n#primary-nav li { \r\n   margin-bottom: -1px; \r\n   position: relative; \r\n}\r\n\r\n\r\n/* Styling the basic apperance of the menu elements */\r\n#primary-nav a { \r\n   border: 1px solid #006699; \r\n   display: block; \r\n   margin: 0px; \r\n   padding: 5px 10px; \r\n   color: #006699;\r\n   text-decoration: none; \r\n   background: transparent; \r\n   min-height:1em; /* Fixes IE7 whitespace bug*/ \r\n}\r\n#primary-nav li, #primary-nav li.menuparent { \r\n   background-color: #ececec; \r\n   min-height:1em; /* Fixes IE7 bug*/\r\n}\r\n\r\n\r\n/* Styling the basic apperance of the active page elements (shows what page in the menu is being displayed) */\r\n#primary-nav li.menuactive { \r\n   background-color: #C7C7C7; \r\n}\r\n\r\n/* Styling the basic apperance of the menuparents - here styled the same on hover (fixes IE bug) */\r\n#primary-nav li.menuparent, \r\n#primary-nav li.menuparent:hover, \r\n#primary-nav li.menuparenth { \r\n   background-image: url(images/cms/arrow.gif); \r\n   background-position: center right; \r\n   background-repeat: no-repeat; \r\n}\r\n\r\n\r\n/* Styling the apperance of menu items on hover */\r\n#primary-nav li:hover, \r\n#primary-nav li.menuh, \r\n#primary-nav li.menuparenth, \r\n#primary-nav li.menuactiveh { \r\n   background-color: #E7AB0B; \r\n}\r\n\r\n\r\n/* The magic - set to work for up to a 3 level menu, but can be increased unlimited */\r\n#primary-nav ul, \r\n#primary-nav li:hover ul, \r\n#primary-nav li:hover ul ul, \r\n#primary-nav li.menuparenth ul, \r\n#primary-nav li.menuparenth ul ul { \r\n   display: none; \r\n}\r\n#primary-nav li:hover ul, \r\n#primary-nav ul li:hover ul, \r\n#primary-nav ul ul li:hover ul, \r\n#primary-nav li.menuparenth ul, \r\n#primary-nav ul li.menuparenth ul, \r\n#primary-nav ul ul li.menuparenth ul { \r\n   display: block; \r\n}\r\n\r\n\r\n/* IE Hack, will cause the css to not validate */\r\n\r\n#primary-nav li, #primary-nav li.menuparenth { _float: left; _height: 1%; }\r\n#primary-nav li a { _height: 1%; }\r\n\r\n\r\n/* section header */\r\n#primary-nav li.sectionheader {\r\n   border-left: 1px solid #006699; \r\n   border-top: 1px solid #006699; \r\n   font-size: 130%;\r\n   font-weight: bold;\r\n   padding: 1.5em 0 0.8em 0.5em;\r\n   background-color: #fff;\r\n   margin: 0;\r\n   width: 100%;\r\n}\r\n\r\n\r\n/* separator */\r\n#primary-nav li hr.separator {\r\n   display:block;\r\n   height: 0.5em;\r\n   color: #abb0b6;\r\n   background-color: #abb0b6;\r\n   width: 100%;\r\n   border:0;\r\n   margin:0;\r\n   padding:0;   \r\n   border-top: 1px solid #006699;\r\n   border-right: 1px solid #006699;\r\n}\r\n','screen','2006-07-25 21:22:32','2006-07-25 21:22:32'),(34,'Navigation: CSSMenu - Horizontal','/* Horizontal menu for the CMS CSS Menu Module */\r\n/* by Alexander Endresen */\r\n\r\n#menu_vert {\r\n   margin-left: 1px;\r\n   margin-right: 1px;\r\n}\r\n\r\n/* The wrapper clears the floating elements of the menu */\r\n\r\n/* Fix for Opera 8 */\r\n.clearb { clear: both; }\r\n#menuwrapper { \r\n   /* Fix for Opera 8 */ \r\n   /*   overflow: hidden;  */ \r\n   background-color: #ECECEC;\r\n   border-bottom: 1px solid #C0C0C0;\r\n   width: 100%;\r\n}\r\n\r\n/* Set the width of the menu elements at second level. Leaving first level flexible. */\r\n#primary-nav li li { \r\n   width: 200px; \r\n}\r\n\r\n\r\n/* Unless you know what you do, do not touch this */ \r\n#primary-nav, #primary-nav ul { \r\n   list-style: none; \r\n   margin: 0px; \r\n   padding: 0px; \r\n}\r\n#primary-nav ul { \r\n   position: absolute; \r\n   top: auto; \r\n   display: none; \r\n}\r\n#primary-nav ul ul { \r\n   margin-top: 1px;\r\n   margin-left: -1px;\r\n   left: 100%; \r\n   top: 0px; \r\n}\r\n	\r\n#primary-nav li { \r\n   margin-left: -1px;\r\n   float: left; \r\n}\r\n#primary-nav li li { \r\n   margin-left: 0px;\r\n   margin-top: -1px;\r\n   float: none; \r\n   position: relative; \r\n}\r\n\r\n/* Styling the basic apperance of the menu elements */\r\n#primary-nav a { \r\n   display: block; \r\n   margin: 0px; \r\n   padding: 5px 10px; \r\n   text-decoration: none; \r\n   color: #006699;\r\n}\r\n#primary-nav li a { \r\n   border-right: 1px solid #C0C0C0;\r\n   border-left: 1px solid #C0C0C0;\r\n}\r\n#primary-nav li li a { \r\n   border: 1px solid #C0C0C0;\r\n}	\r\n#primary-nav li, #primary-nav li.menuparent { \r\n   background-color: #ececec; \r\n}\r\n\r\n/* Styling the basic apperance of the active page elements (shows what page in the menu is being displayed) */\r\n\r\n#primary-nav li.menuactive { \r\n   background-color: #C7C7C7; \r\n}\r\n\r\n\r\n/* Styling the basic apperance of the menuparents - here styled the same on hover (fixes IE bug) */\r\n#primary-nav ul li.menuparent, \r\n#primary-nav ul li.menuparent:hover, \r\n#primary-nav ul li.menuparenth { \r\n/* arrow for menuparents */\r\n   background-image: url(images/cms/arrow.gif); \r\n   background-position: center right; \r\n   background-repeat: no-repeat; \r\n}\r\n\r\n\r\n/* Styling the apperance of menu items on hover */\r\n\r\n#primary-nav li:hover, \r\n#primary-nav li.menuh, \r\n#primary-nav li.menuparenth, \r\n#primary-nav li.menuactiveh { \r\n   background-color: #E7AB0B; \r\n}\r\n\r\n\r\n/* The magic - set to work for up to a 3 level menu, but can be increased unlimited */\r\n\r\n/* \r\njust add \r\n#primary-nav li:hover ul ul, \r\n#primary-nav li.menuparenth ul ul ul,\r\nfor fourth level \r\n*/\r\n#primary-nav ul, \r\n#primary-nav li:hover ul, \r\n#primary-nav li:hover ul ul, \r\n#primary-nav li.menuparenth ul, \r\n#primary-nav li.menuparenth ul ul { \r\n   display: none; \r\n}\r\n\r\n/* add \r\n#primary-nav ul ul ul li:hover ul, \r\n#primary-nav ul ul ul li.menuparenth ul,\r\nfor fourth level\r\n*/\r\n#primary-nav li:hover ul, \r\n#primary-nav ul li:hover ul, \r\n#primary-nav ul ul li:hover ul, \r\n#primary-nav li.menuparenth ul, \r\n#primary-nav ul li.menuparenth ul, \r\n#primary-nav ul ul li.menuparenth ul { \r\n   display: block; \r\n}\r\n\r\n\r\n/* IE Hacks */\r\n#primary-nav li li { \r\n   float: left; \r\n   clear: both; \r\n}\r\n#primary-nav li li a { \r\n   height: 1%; \r\n}','','2006-07-25 21:22:32','2006-07-25 21:22:32'),(35,'Module: News','div#news {\r\n  margin: 2em 0 1em 1em;  /* margin for the entire div surrounding the news list */\r\n  border: 1px solid #000; \r\n  background: #FFE9AF; \r\n}\r\n\r\ndiv#news h2 {\r\n   line-height: 2em;\r\n   background: #fff;\r\n}\r\n\r\n.NewsSummary {\r\n    padding: 0.5em 0.5em 1em; /* padding for the news article summary */\r\n    margin: 0 0.5em 1em 0.5em; /* margin to the bottom of the news article summary */\r\n    border-bottom: 1px solid #ccc; \r\n}\r\n\r\n.NewsSummaryPostdate {\r\n  font-size: 90%;\r\n  font-weight: bold;\r\n }\r\n\r\n.NewsSummaryLink {\r\n    font-weight: bold;\r\n    padding-top: 0.2em;\r\n}\r\n\r\n.NewsSummaryCategory {\r\n  font-style: italic;\r\n  margin: 5px 0;\r\n }\r\n\r\n.NewsSummaryAuthor {\r\n  font-style: italic;\r\n  padding-bottom: 0.5em;\r\n}\r\n\r\n.NewsSummarySummary, .NewsSummaryContent {\r\n  line-height: 140%;\r\n }\r\n\r\n.NewsSummaryMorelink {\r\n  padding-top: 0.5em;\r\n}\r\n\r\n#NewsPostDetailDate {\r\n  font-size: 90%;\r\n  margin-bottom: 5px;\r\n  font-weight: bold;\r\n  }\r\n\r\n#NewsPostDetailSummary {\r\n   line-height: 150%;\r\n   }\r\n\r\n#NewsPostDetailCategory {\r\n  font-style: italic;\r\n  border-top: 1px solid #ccc;\r\n  margin-top: 0.5em;\r\n  padding: 0.2em 0;\r\n}\r\n\r\n#NewsPostDetailContent {\r\n  margin-bottom: 15px;\r\n  line-height: 150%;\r\n  }\r\n\r\n#NewsPostDetailAuthor {\r\n\r\n  padding-bottom: 1.5em;\r\n  font-style: italic;\r\n}\r\n\r\n\r\n/* to add specific style to the below divs, uncomment them. */\r\n\r\n/* \r\n#NewsPostDetailTitle {}\r\n#NewsPostDetailHorizRule {}\r\n#NewsPostDetailPrintLink {}\r\n#NewsPostDetailReturnLink {}\r\n*/','screen','2006-07-25 21:22:32','2006-07-25 21:22:32'),(36,'Navigation: Simple - Vertical','/********************\r\nMENU\r\n*********************/\r\n#menu_vert {\r\n   padding-left: 0;\r\n   margin-left: 1em;\r\n}\r\n\r\n\r\n/* third level has some padding to have it stand out */\r\ndiv#menu_vert ul ul ul {\r\n   padding-bottom: 0.5em;\r\n}\r\n\r\n/* menu li block */\r\n#menu_vert li {\r\n   list-style: none;\r\n   margin: 0;\r\n   border-bottom: 1px solid #c0c0c0;\r\n   display: block;\r\n}\r\n\r\n#menu_vert ul ul li {\r\n   border: none;\r\n}\r\n\r\n/** fix stupid ie bug with display:block; **/\r\n* html #menu_vert li a { height: 1%; } \r\n* html #menu_vert li hr { height: 1%; }\r\n/** end fix **/\r\n\r\n/* first level links */\r\ndiv#menu_vert a {\r\n   text-decoration:none; /* no underline for links */\r\n   display: block; /* IE has problems with this, fixed above */\r\n   padding: 0.8em 0.5em 0.8em 1.5em; /* some air for it */\r\n   color: #18507C; /* this will be link color for all levels */\r\n   background: url(images/cms/arrow-right.gif) no-repeat 0.5em center; \r\n   min-height:1em; /* Fixes IE7 whitespace bug */ \r\n}\r\n\r\n/* next level links, more padding and smaller font */\r\ndiv#menu_vert ul ul a {\r\n   font-size: 90%;\r\n   padding: 0.5em 0.5em 0.5em 2.8em;\r\n   background-position: 1.5em center;\r\n}\r\n\r\n/* third level links, more padding */\r\ndiv#menu_vert ul ul ul a {\r\n   padding: 0.3em 0.5em 0.3em 4.3em;\r\n   background: url(images/cms/dash.gif) no-repeat 2.8em center; \r\n}\r\n\r\n/* hover state for all links */\r\ndiv#menu_vert a:hover {\r\n   background-color: #C3D4DF;\r\n}\r\ndiv#menu_vert a.activeparent:hover {\r\n   background-color: #C3D4DF;\r\n   color: #18507C;\r\n}\r\n\r\n/* \r\nactive parent, that is the first-level parent \r\nof a child page that is the current page \r\n*/\r\ndiv#menu_vert li a.activeparent {\r\n   background: url(images/cms/arrow-down.gif) no-repeat 0.4em center; \r\n   background-color: #385C72;\r\n   color: #fff;\r\n}\r\n\r\ndiv#menu_vert ul ul li a.activeparent {\r\n   background-position: 1.5em center; \r\n   background-color: transparent;\r\n   color: #18507C;\r\n}\r\n\r\n\r\n/* \r\ncurrent pages in the default Menu Manager \r\ntemplate are unclickable. This is for current page on first level \r\n*/\r\ndiv#menu_vert ul h3 {\r\n   background: url(images/cms/arrow-right-active.gif) no-repeat 0.4em center;\r\n   background-color: #385C72;\r\n   display: block; \r\n   padding: 0.8em 0.5em 0.8em 1.5em;  /* some air for it */\r\n   color: #fff;                                 /* this will be link color for all levels */\r\n   font-size: 1em;                           /* instead of the normal font size for <h3> */\r\n   margin: 0;                                  /* as <h3> normally has some margin by default */\r\n}\r\n\r\n/* \r\nnext level current pages, more padding, \r\nsmaller font and no background color or bottom border \r\n*/\r\ndiv#menu_vert ul ul h3 {\r\n   font-size: 90%;\r\n   padding: 0.3em 0.5em 0.3em 2.8em;\r\n   background-position: 1.4em center;\r\n   background-color: transparent;\r\n   border-bottom: none;\r\n   color: #000;     \r\n}\r\n\r\n/* current page on third level, more padding */\r\ndiv#menu_vert ul ul ul h3 {\r\n   padding: 0.3em 0.5em 0.3em 4.3em;\r\n   background: url(images/cms/arrow-right-active.gif) no-repeat 2.7em center; \r\n}\r\n\r\n/* section header */\r\ndiv#menu_vert li.sectionheader {\r\n   border-right: none;\r\n   font-size: 130%;\r\n   font-weight: bold;\r\n   padding: 1.5em 0 0.8em 0;\r\n   background-color: #fff;\r\n   line-height: 1em;\r\n   margin: 0;\r\n   text-align:center;\r\n}\r\n\r\n\r\n\r\n/* separator */\r\ndiv#menu_vert li.separator {\r\n   height: 1px !important;\r\n   margin-top: -1px;\r\n   margin-bottom: 0;\r\n   padding:2px 0 2px 0;\r\n   background-color: #000;\r\n   overflow:hidden !important;\r\n   line-height:1px !important;\r\n   font-size:1px; /* for ie */\r\n}\r\n\r\ndiv#menu_vert li.separator hr {\r\n   display: none; /* this is for accessibility */\r\n}','screen','2006-07-25 21:22:32','2006-07-25 21:22:32'),(38,'Navigation: Simple - Horizontal','/********************\r\nMENU\r\n*********************/\r\n\r\n/* hack for Internet Explorer */\r\n* html div#menu_horiz {\r\n   /* hide ie/mac \\*/\r\n   height: 1%;\r\n   /* end hide */\r\n}\r\n\r\n/* \r\nbackground-color for the entire menu row, \r\ncovering 100% of the width and text center-aligned \r\n*/\r\ndiv#menu_horiz {\r\n   background-color: #ECECEC;  /* background color for the entire menu row */\r\n   width: 100%;\r\n   margin: 0;\r\n}\r\n\r\n/* \r\nthe menu ul box has top and left border, \r\nright border is provided by the li elements \r\n*/\r\ndiv#menu_horiz ul {\r\n   margin: 0;\r\n   padding: 0;\r\n   border-bottom: 1px solid #C0C0C0;\r\n   border-left:  1px solid #C0C0C0;\r\n   height:2.2em;\r\n}\r\n\r\n\r\n/* menu list items */\r\ndiv#menu_horiz li {\r\n   float: left; /* makes the list horizontal */\r\n   list-style: none; /* hides the list bullet */ \r\n   margin: 0 ;\r\n   border-right: 1px solid #C0C0C0;\r\n}\r\n\r\n\r\n/* the links, that is each list item */\r\ndiv#menu_horiz a {\r\n   padding: .6em 1em .6em 1.4em; /* padding inside the list item box */\r\n   margin: 0; /* margin outside each list item box */\r\n   text-decoration: none; /* no underline for links */\r\n   color: #18507C;\r\n   background: url(images/cms/arrow-right.gif) no-repeat 0.5em center; ;\r\n   display: block; /* IE has problems with this, fixed above */\r\n}\r\n\r\n\r\n/* hover state for links */\r\ndiv#menu_horiz li a:hover {\r\n   background-color: #C3D4DF;\r\n}\r\ndiv#menu_horiz a.activeparent:hover {\r\n   background-color: #C3D4DF;\r\n   color: #18507C;\r\n}\r\n\r\n/* active parent, that is the first-level parent of a child page that is the current page */\r\ndiv#menu_horiz li.activeparent a {\r\n   background: #385C72 url(images/cms/arrow-down.gif) no-repeat 0.4em center; \r\n   color: #fff;\r\n}\r\n\r\ndiv#menu_horiz h3 {\r\n   padding: .6em 1em .6em 1.4em; /* padding inside the list item box */\r\n   margin: 0; /* margin outside each list item box */\r\n   text-decoration: none; /* no underline for links */\r\n   color: #fff;\r\n   background: #385C72 url(images/cms/arrow-right-active.gif) no-repeat 0.4em center; ;\r\n   display: block; /* IE has problems with this, fixed above */\r\n   font-size: 1em;                           /* instead of the normal font size for <h3> */\r\n}\r\n','screen','2006-07-25 21:22:32','2006-07-25 21:22:32'),(39,'Layout: Top menu + 2 columns','/*****************\nbrowsers interpret margin and padding a little differently, \nwe\'ll remove all default padding and margins and\nset them later on\n******************/\n* {\nmargin:0;\npadding:0;\n}\n\n/*\nSet initial font styles\n*/\nbody {\n   text-align: left;\n   font-family: Arial, Helvetica, sans-serif;\n   font-size: 75.01%;\n   line-height: 1em;\n}\n\n/*\nset font size for all divs,\nthis overrides some body rules\n*/\ndiv {\n   font-size: 1em;\n}\n\n/*\nif img is inside \"a\" it would have \nborders, we don\'t want that\n*/\nimg {\n   border: 0;\n}\n\n/*\ndefault link styles\n*/\n/* set all links to have underline and bluish color */\na,\na:link \na:active {\n   text-decoration: underline;\n/* css validation will give a warning if color is set without background color. this will explicitly tell this element to inherit bg colour from parent element */\n   background-color: inherit; \n   color: #18507C; \n}\n\na:visited {\n   text-decoration: underline;\n   background-color: inherit;\n  color: #18507C;                /* a different color can be used for visited links */\n}\n\n\n/* remove underline on hover and change color */\na:hover {\n   text-decoration: none;\n   /*background-color: #C3D4DF;*/\n   color: #385C72;\n}\n\n/*****************\nbasic layout \n*****************/\nbody {\n   background-color: #98c7e6;\n   color: #333;\n   margin:47px; /* gives some air for the pagewrapper */\n}\n\n/* center wrapper, min max width */\ndiv#pagewrapper {\n   border-left: 1px solid #ffffff;\n   border-right: 1px solid #ffffff;\n   margin: 0 auto;     /* this centers wrapper */\n   max-width: 978px; /* IE wont understand these, so we will use javascript magick */\n   min-width: 978px;\n   background: url(images/bgpage.jpg) repeat-x #ffffff;\n   color: black;\n}\n\n\n/*** header ***\nwe will hide text and replace it with a image\nwe need to assign a height for it\n*/\n\ndiv#header {\n   height: 80px; /* adjust according your image size */\n   background: #385C72;           \n}\n\ndiv#header h1 a {\n/* you can set your own image here */\n   background: #385C72 url(images/cms/logo1.gif) no-repeat 0 12px; \n   display: block; \n   height: 80px;             /* adjust according your image size */\n   text-indent: -999em;  /* this hides the text */\n   text-decoration:none; /* old firefox would have shown underline for the link, this explicitly hides it */\n}\n\ndiv#search {\n   float: right;\n   width: 27em;     /* enough width for the search input box */\n   text-align: right;\n   padding: 0.6em 0 0.2em 0;\n   margin: 0 1em;\n}\n\ndiv.breadcrumbs {\n   padding: 1em 0 1.2em 0; /* CSS short hand rule first value is top then right, bottom and left */\n   font-size: 90%;             /* its good to set fontsizes to be relative, this way viewer can change his/her fontsize */\n   margin: 0 1em;              /* css shorthand rule will be opened to be \"0 1em 0 1em\" */\n   border-bottom: 1px dotted #000;\n}\n\n div.breadcrumbs span.lastitem { \n   font-weight:bold; \n }\n\n\ndiv#content {\n   margin: 0px auto 0 0; /* some air above and under menu and content */\n}\n\ndiv#main {\n   margin-left: 400px; /* this will give room for sidebar to be on the left side, make sure this space is bigger than sidebar width */\n   margin-right: 40px; /* and some air on the right */\n}\n\n\ndiv#sidebar {\n   float: left;  /* set sidebar on the left side. Change to right to float it right instead. */\n   width: 360px;    /* sidebar width, if you change this please also change #main margins */\n   display: inline;  /* FIX ie doublemargin bug */\n   margin-left: 40px;\n}\n\ndiv#sidebar li{\n  font-size: 11px;\n  line-height:16px;\n  color:#656565;  \n  background:url(images/bullet.jpg) no-repeat 0 5px ;\n  padding-left:15px;\n}\n\ndiv#sidebar ul {\n	/*list-style: disc url(images/bullet.jpg);*/\n   list-style-image:none;\n   list-style-position:outside;\n   list-style-type:none;\n}\n\n\n\n/* if sidebar doesnt include menu but content add class=\"hascontent\" */\ndiv#sidebar.hascontent {\n   padding: 0;\n   width: 360px;  /* make width smaller if there\'s padding, or it will get too wide for the floated divs in IE */\n}\n\ndiv#footer {\n   clear:both;       /* keep footer below content and menu */\n   color: #fff;\n   background-color: #385C72; /* same bg color as in header */\n}\n\ndiv#footer p {\n   font-size: 0.8em;\n   padding: 1.5em;      /* some air for footer */\n   text-align: center; /* centered text */\n   margin:0;\n}\n\ndiv#footer p a {\n   color: #fff; /* needed becouse footer link would be same color as background otherwise */\n}\n\n/* as we hid all hr for accessibility we create new hr with extra div element */\ndiv.hr {\n   height: 1px;\n   margin: 1em;\n   border-bottom: 1px dotted black;\n}\n\n/* relational links under content */\ndiv.left49 {\n  float: left;\n  width: 49%;  /* 50% for both left and right might lead to rounding error on some browser */\n}\n\ndiv.right49 {\n  float: right;\n  width: 49%;\n  text-align: right;\n}\n\n\n\n\n/********************\nCONTENT STYLING\n*********************/\ndiv#content {\n\n}\n\n/* HEADINGS */\ndiv#content h1 {\n   font-size: 2em;  /* font size for h1 */\n   line-height: 1em;\n   margin: 0;\n}\ndiv#content h2 {\n   color: #294B5F; \n   font-size: 1.5em; \n   text-align: left; \n/* some air around the text */\n   padding-left: 0.5em;\n   padding-bottom: 1px;\n/* set borders around header */\n   border-bottom: 1px solid #e7ab0b; \n   border-left: 1.1em solid #e7ab0b; \n   line-height: 1.5em;\n/* and some air under the border */\n   margin: 0 0 0.5em 0;\n}\ndiv#content h3 {\n   color: #294B5F; \n   font-size: 1.3em;\n   line-height: 1.3em;\n   margin: 0 0 0.5em 0;\n}\ndiv#content h4 {\n   color: #294B5F; \n   font-size: 1.2em;\n   line-height: 1.3em;\n   margin: 0 0 0.25em 0;\n}\ndiv#content h5 {\n   font-size: 1.1em;\n   line-height: 1.3em;\n   margin: 0 0 0.25em 0;\n}\nh6 {\n   font-size: 1em;\n   line-height: 1.3em;\n   margin: 0 0 0.25em 0;\n}\n/* END HEADINGS */\n\n/* TEXT */\np {\n   color:#656565;\n   font-size: 11px;\n   margin: 0 0 1.5em 0;  /* some air around p elements */\n   line-height:1.4em;\n   padding: 0;\n}\nblockquote {\n   border-left: 10px solid #ddd;\n   margin-left: 10px;\n}\npre {\n   font-family: monospace;\n   font-size: 1.0em;\n}\nstrong, b {\n/* explicit setting for these */\n   font-weight: bold;\n}\nem, i {\n/* explicit setting for these */\n   font-style:italic;\n}\n\n/* Wrapping text in <code> tags. Makes CSS not validate */\ncode, pre {\n white-space: pre-wrap;       /* css-3 */\n white-space: -moz-pre-wrap;  /* Mozilla, since 1999 */\n white-space: -pre-wrap;      /* Opera 4-6 */\n white-space: -o-pre-wrap;    /* Opera 7 */\n word-wrap: break-word;       /* Internet Explorer 5.5+ */\n font-family: \"Courier New\", Courier, monospace;\n font-size: 1em;\n}\n\npre {\n   border: 1px solid #000;  /* black border for pre blocks */\n   background-color: #ddd;\n   margin: 0 1em 1em 1em;\n   padding: 0.5em;\n   line-height: 1.5em;\n   font-size: 90%;   /* smaller font size, as these are usually not so important data */\n}\n\n/* END TEXT */\n\n/* LISTS */\ndiv#main ul,\ndiv#main ol,\ndiv#main dl {\n  font-size: 11px;\n  color:#656565;\n   line-height:1.4em;\n   margin: 0 0 1.5em 0;\n}\ndiv#main ul li,\ndiv#main ol li {\n   margin: 0 0 0.25em 3em;\n}\n\ndiv#dl dt {\n   font-weight: bold;\n   margin: 0 0 0.25em 3em;\n}\ndiv#dl dd {\n   margin: 0 0 0 3em;\n}\n/* END LISTS */','screen','2006-07-25 21:22:32','2008-12-12 16:52:26'),(42,'custom','p.flinks {color:#292866;font-size:12px;margin-top:20px;float:center;font-family:Arial;}\r\np.flinks  a{color:#292866; font-family:Arial;}','','2009-05-20 10:40:40','2009-05-20 11:05:56');
/*!40000 ALTER TABLE `cms_css` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_css_assoc`
--

DROP TABLE IF EXISTS `cms_css_assoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_css_assoc` (
  `assoc_to_id` int(11) DEFAULT NULL,
  `assoc_css_id` int(11) DEFAULT NULL,
  `assoc_type` varchar(80) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `assoc_order` int(11) DEFAULT NULL,
  KEY `index_css_assoc_by_assoc_to_id` (`assoc_to_id`),
  KEY `index_css_assoc_by_assoc_css_id` (`assoc_css_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_css_assoc`
--

LOCK TABLES `cms_css_assoc` WRITE;
/*!40000 ALTER TABLE `cms_css_assoc` DISABLE KEYS */;
INSERT INTO `cms_css_assoc` VALUES (17,41,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',1),(16,39,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',1),(18,31,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',1),(18,35,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',2),(18,30,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',3),(18,38,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',4),(18,36,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',5),(18,39,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',6),(16,31,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',2),(16,34,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',3),(16,35,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',4),(16,30,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',5),(15,31,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',1),(15,33,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',2),(15,32,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',3),(15,30,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',4),(15,35,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',5),(17,32,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',2),(17,35,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',3),(17,30,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',4),(17,36,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',5),(17,31,'template','2006-07-25 21:22:32','2006-07-25 21:22:32',6),(16,42,'template','2009-05-20 10:40:49','2009-05-20 10:40:49',6),(15,42,'template','2009-05-20 11:03:08','2009-05-20 11:03:08',6);
/*!40000 ALTER TABLE `cms_css_assoc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_css_seq`
--

DROP TABLE IF EXISTS `cms_css_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_css_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_css_seq`
--

LOCK TABLES `cms_css_seq` WRITE;
/*!40000 ALTER TABLE `cms_css_seq` DISABLE KEYS */;
INSERT INTO `cms_css_seq` VALUES (42);
/*!40000 ALTER TABLE `cms_css_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_event_handler_seq`
--

DROP TABLE IF EXISTS `cms_event_handler_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_event_handler_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_event_handler_seq`
--

LOCK TABLES `cms_event_handler_seq` WRITE;
/*!40000 ALTER TABLE `cms_event_handler_seq` DISABLE KEYS */;
INSERT INTO `cms_event_handler_seq` VALUES (9);
/*!40000 ALTER TABLE `cms_event_handler_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_event_handlers`
--

DROP TABLE IF EXISTS `cms_event_handlers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_event_handlers` (
  `event_id` int(11) DEFAULT NULL,
  `tag_name` varchar(255) DEFAULT NULL,
  `module_name` varchar(160) DEFAULT NULL,
  `removable` int(11) DEFAULT NULL,
  `handler_order` int(11) DEFAULT NULL,
  `handler_id` int(11) NOT NULL,
  PRIMARY KEY (`handler_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_event_handlers`
--

LOCK TABLES `cms_event_handlers` WRITE;
/*!40000 ALTER TABLE `cms_event_handlers` DISABLE KEYS */;
INSERT INTO `cms_event_handlers` VALUES (38,NULL,'Search',0,1,1),(40,NULL,'Search',0,1,2),(22,NULL,'Search',0,1,3),(24,NULL,'Search',0,1,4),(26,NULL,'Search',0,1,5),(30,NULL,'Search',0,1,6),(32,NULL,'Search',0,1,7),(34,NULL,'Search',0,1,8),(48,NULL,'Search',0,1,9);
/*!40000 ALTER TABLE `cms_event_handlers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_events`
--

DROP TABLE IF EXISTS `cms_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_events` (
  `originator` varchar(200) NOT NULL,
  `event_name` varchar(200) NOT NULL,
  `event_id` int(11) NOT NULL,
  PRIMARY KEY (`event_id`),
  KEY `originator` (`originator`),
  KEY `event_name` (`event_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_events`
--

LOCK TABLES `cms_events` WRITE;
/*!40000 ALTER TABLE `cms_events` DISABLE KEYS */;
INSERT INTO `cms_events` VALUES ('Core','LoginPost',1),('Core','LogoutPost',2),('Core','AddUserPre',3),('Core','AddUserPost',4),('Core','EditUserPre',5),('Core','EditUserPost',6),('Core','DeleteUserPre',7),('Core','DeleteUserPost',8),('Core','AddGroupPre',9),('Core','AddGroupPost',10),('Core','EditGroupPre',11),('Core','EditGroupPost',12),('Core','DeleteGroupPre',13),('Core','DeleteGroupPost',14),('Core','AddStylesheetPre',15),('Core','AddStylesheetPost',16),('Core','EditStylesheetPre',17),('Core','EditStylesheetPost',18),('Core','DeleteStylesheetPre',19),('Core','DeleteStylesheetPost',20),('Core','AddTemplatePre',21),('Core','AddTemplatePost',22),('Core','EditTemplatePre',23),('Core','EditTemplatePost',24),('Core','DeleteTemplatePre',25),('Core','DeleteTemplatePost',26),('Core','TemplatePreCompile',27),('Core','TemplatePostCompile',28),('Core','AddGlobalContentPre',29),('Core','AddGlobalContentPost',30),('Core','EditGlobalContentPre',31),('Core','EditGlobalContentPost',32),('Core','DeleteGlobalContentPre',33),('Core','DeleteGlobalContentPost',34),('Core','GlobalContentPreCompile',35),('Core','GlobalContentPostCompile',36),('Core','ContentEditPre',37),('Core','ContentEditPost',38),('Core','ContentDeletePre',39),('Core','ContentDeletePost',40),('Core','AddUserDefinedTagPre',41),('Core','AddUserDefinedTagPost',42),('Core','EditUserDefinedTagPre',43),('Core','EditUserDefinedTagPost',44),('Core','DeleteUserDefinedTagPre',45),('Core','DeleteUserDefinedTagPost',46),('Core','ModuleInstalled',47),('Core','ModuleUninstalled',48),('Core','ModuleUpgraded',49),('Core','ContentStylesheet',50),('Core','ContentPreCompile',51),('Core','ContentPostCompile',52),('Core','ContentPostRender',53),('Core','SmartyPreCompile',54),('Core','SmartyPostCompile',55),('Core','ChangeGroupAssignPre',56),('Core','ChangeGroupAssignPost',57),('News','NewsArticleAdded',58),('News','NewsArticleEdited',59),('News','NewsArticleDeleted',60),('News','NewsCategoryAdded',61),('News','NewsCategoryEdited',62),('News','NewsCategoryDeleted',63),('Search','SearchInitiated',64),('Search','SearchCompleted',65),('Search','SearchItemAdded',66),('Search','SearchItemDeleted',67),('Search','SearchAllItemsDeleted',68);
/*!40000 ALTER TABLE `cms_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_events_seq`
--

DROP TABLE IF EXISTS `cms_events_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_events_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_events_seq`
--

LOCK TABLES `cms_events_seq` WRITE;
/*!40000 ALTER TABLE `cms_events_seq` DISABLE KEYS */;
INSERT INTO `cms_events_seq` VALUES (68);
/*!40000 ALTER TABLE `cms_events_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_group_perms`
--

DROP TABLE IF EXISTS `cms_group_perms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_group_perms` (
  `group_perm_id` int(11) NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  `permission_id` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`group_perm_id`),
  KEY `index_group_perms_by_group_id_permission_id` (`group_id`,`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_group_perms`
--

LOCK TABLES `cms_group_perms` WRITE;
/*!40000 ALTER TABLE `cms_group_perms` DISABLE KEYS */;
INSERT INTO `cms_group_perms` VALUES (151,1,16,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(150,1,24,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(149,1,27,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(148,1,13,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(147,1,32,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(146,1,14,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(145,1,12,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(144,1,11,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(143,1,22,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(142,1,26,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(141,1,21,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(140,1,9,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(138,1,18,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(137,1,31,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(136,1,7,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(135,1,8,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(134,1,20,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(133,1,28,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(132,1,6,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(130,1,29,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(129,1,5,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(128,1,4,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(127,1,23,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(126,1,25,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(125,1,1,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(124,1,30,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(123,1,2,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(166,2,13,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(165,3,32,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(163,3,31,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(162,2,20,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(161,2,28,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(160,2,6,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(114,3,25,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(115,2,31,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(116,3,4,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(117,3,26,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(118,3,30,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(119,3,11,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(120,3,27,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(121,2,32,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(122,3,16,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(152,1,17,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(153,1,37,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(159,2,1,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(158,2,30,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(167,3,22,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(168,1,33,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(169,1,34,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(170,1,35,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(171,2,36,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(172,1,39,'2008-12-09 20:40:24','2008-12-09 20:40:24'),(173,2,39,'2008-12-09 20:40:24','2008-12-09 20:40:24');
/*!40000 ALTER TABLE `cms_group_perms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_group_perms_seq`
--

DROP TABLE IF EXISTS `cms_group_perms_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_group_perms_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_group_perms_seq`
--

LOCK TABLES `cms_group_perms_seq` WRITE;
/*!40000 ALTER TABLE `cms_group_perms_seq` DISABLE KEYS */;
INSERT INTO `cms_group_perms_seq` VALUES (173);
/*!40000 ALTER TABLE `cms_group_perms_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_groups`
--

DROP TABLE IF EXISTS `cms_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_groups` (
  `group_id` int(11) NOT NULL,
  `group_name` varchar(25) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_groups`
--

LOCK TABLES `cms_groups` WRITE;
/*!40000 ALTER TABLE `cms_groups` DISABLE KEYS */;
INSERT INTO `cms_groups` VALUES (1,'Admin',1,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(2,'Editor',1,'2006-07-25 21:22:32','2006-07-25 21:22:32'),(3,'Designer',1,'2006-07-25 21:22:32','2006-07-25 21:22:32');
/*!40000 ALTER TABLE `cms_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_groups_seq`
--

DROP TABLE IF EXISTS `cms_groups_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_groups_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_groups_seq`
--

LOCK TABLES `cms_groups_seq` WRITE;
/*!40000 ALTER TABLE `cms_groups_seq` DISABLE KEYS */;
INSERT INTO `cms_groups_seq` VALUES (3);
/*!40000 ALTER TABLE `cms_groups_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_htmlblobs`
--

DROP TABLE IF EXISTS `cms_htmlblobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_htmlblobs` (
  `htmlblob_id` int(11) NOT NULL,
  `htmlblob_name` varchar(255) DEFAULT NULL,
  `html` text,
  `owner` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`htmlblob_id`),
  KEY `index_htmlblobs_by_htmlblob_name` (`htmlblob_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_htmlblobs`
--

LOCK TABLES `cms_htmlblobs` WRITE;
/*!40000 ALTER TABLE `cms_htmlblobs` DISABLE KEYS */;
INSERT INTO `cms_htmlblobs` VALUES (1,'footer','<center>\r\n<p class=\'flinks\'>\r\nÂ© {custom_copyright} Twin Towers Trading, Inc.All rights reserved.<br/>\r\n<a href=\'index.php?page=privacy-policy\'>Privacy Policy</a> | <a href=\'index.php?page=terms-and-conditions-of-use\'>Terms and Conditions of Use</a>\r\n</p>\r\n</center>',1,'2006-07-25 21:22:32','2009-05-20 11:04:40'),(2,'vicmenu','<table id=\"vicmenu\" style=\"height: 40px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"320\">\r\n<tbody>\r\n<tr>\r\n<td rowspan=\"2\"><a href=\"index.php\" onmouseover=\"img1.src=\'images/menu-over_01.png\'\" onmouseout=\"img1.src=\'images/menu-normal_01.png\'\"><img name=\"img1\" id=\"img1\" src=\"images/menu-normal_01.png\" alt=\"\" width=\"97\" height=\"40\" /></a></td>\r\n<td rowspan=\"2\"><a href=\"index.php?page=about-us\" onmouseover=\"img2.src=\'images/menu-over_02.png\'\" onmouseout=\"img2.src=\'images/menu-normal_02.png\'\"><img name=\"img2\" id=\"img2\" src=\"images/menu-normal_02.png\" alt=\"\" width=\"92\" height=\"40\" /></a></td>\r\n<td><a href=\"index.php?page=contact-us\" onmouseover=\"img3.src=\'images/menu-over_03.png\'\" onmouseout=\"img3.src=\'images/menu-normal_03.png\'\"><img name=\"img3\" id=\"img3\" src=\"images/menu-normal_03.png\" alt=\"\" width=\"104\" height=\"38\" /></a></td>\r\n<td rowspan=\"2\"><img src=\"images/menu-normal_04.png\" border=\"0\" alt=\"\" width=\"27\" height=\"40\" /></td>\r\n</tr>\r\n<tr>\r\n<td><img src=\"images/menu-normal_05.png\" alt=\"\" width=\"104\" height=\"2\" /></td>\r\n</tr>\r\n</tbody>\r\n</table>',1,'2008-12-09 22:07:42','2008-12-10 12:52:35');
/*!40000 ALTER TABLE `cms_htmlblobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_htmlblobs_seq`
--

DROP TABLE IF EXISTS `cms_htmlblobs_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_htmlblobs_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_htmlblobs_seq`
--

LOCK TABLES `cms_htmlblobs_seq` WRITE;
/*!40000 ALTER TABLE `cms_htmlblobs_seq` DISABLE KEYS */;
INSERT INTO `cms_htmlblobs_seq` VALUES (2);
/*!40000 ALTER TABLE `cms_htmlblobs_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_deps`
--

DROP TABLE IF EXISTS `cms_module_deps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_deps` (
  `parent_module` varchar(25) DEFAULT NULL,
  `child_module` varchar(25) DEFAULT NULL,
  `minimum_version` varchar(25) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_deps`
--

LOCK TABLES `cms_module_deps` WRITE;
/*!40000 ALTER TABLE `cms_module_deps` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_module_deps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_news`
--

DROP TABLE IF EXISTS `cms_module_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_news` (
  `news_id` int(11) NOT NULL,
  `news_category_id` int(11) DEFAULT NULL,
  `news_title` varchar(255) DEFAULT NULL,
  `news_data` text,
  `news_date` datetime DEFAULT NULL,
  `summary` text,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` varchar(25) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  `news_extra` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_news`
--

LOCK TABLES `cms_module_news` WRITE;
/*!40000 ALTER TABLE `cms_module_news` DISABLE KEYS */;
INSERT INTO `cms_module_news` VALUES (1,1,'News Module Installed','The news module was installed.  Exciting. This news article is not using the Summary field and therefore there is no link to read more. But you can click on the news heading to read only this article.','2008-12-09 20:40:24',NULL,NULL,NULL,'published',NULL,'2008-12-09 20:40:24','2008-12-09 20:40:24',1,NULL);
/*!40000 ALTER TABLE `cms_module_news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_news_categories`
--

DROP TABLE IF EXISTS `cms_module_news_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_news_categories` (
  `news_category_id` int(11) NOT NULL,
  `news_category_name` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `hierarchy` varchar(255) DEFAULT NULL,
  `long_name` text,
  `create_date` time DEFAULT NULL,
  `modified_date` time DEFAULT NULL,
  PRIMARY KEY (`news_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_news_categories`
--

LOCK TABLES `cms_module_news_categories` WRITE;
/*!40000 ALTER TABLE `cms_module_news_categories` DISABLE KEYS */;
INSERT INTO `cms_module_news_categories` VALUES (1,'General',-1,'00001','General','20:40:24','20:40:24');
/*!40000 ALTER TABLE `cms_module_news_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_news_categories_seq`
--

DROP TABLE IF EXISTS `cms_module_news_categories_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_news_categories_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_news_categories_seq`
--

LOCK TABLES `cms_module_news_categories_seq` WRITE;
/*!40000 ALTER TABLE `cms_module_news_categories_seq` DISABLE KEYS */;
INSERT INTO `cms_module_news_categories_seq` VALUES (1);
/*!40000 ALTER TABLE `cms_module_news_categories_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_news_fielddefs`
--

DROP TABLE IF EXISTS `cms_module_news_fielddefs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_news_fielddefs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `max_length` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `item_order` int(11) DEFAULT NULL,
  `public` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_news_fielddefs`
--

LOCK TABLES `cms_module_news_fielddefs` WRITE;
/*!40000 ALTER TABLE `cms_module_news_fielddefs` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_module_news_fielddefs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_news_fieldvals`
--

DROP TABLE IF EXISTS `cms_module_news_fieldvals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_news_fieldvals` (
  `news_id` int(11) DEFAULT NULL,
  `fielddef_id` int(11) DEFAULT NULL,
  `value` text,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_news_fieldvals`
--

LOCK TABLES `cms_module_news_fieldvals` WRITE;
/*!40000 ALTER TABLE `cms_module_news_fieldvals` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_module_news_fieldvals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_news_seq`
--

DROP TABLE IF EXISTS `cms_module_news_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_news_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_news_seq`
--

LOCK TABLES `cms_module_news_seq` WRITE;
/*!40000 ALTER TABLE `cms_module_news_seq` DISABLE KEYS */;
INSERT INTO `cms_module_news_seq` VALUES (1);
/*!40000 ALTER TABLE `cms_module_news_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_search_index`
--

DROP TABLE IF EXISTS `cms_module_search_index`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_search_index` (
  `item_id` int(11) DEFAULT NULL,
  `word` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  KEY `count` (`count`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_search_index`
--

LOCK TABLES `cms_module_search_index` WRITE;
/*!40000 ALTER TABLE `cms_module_search_index` DISABLE KEYS */;
INSERT INTO `cms_module_search_index` VALUES (124,'privacyquestions@tttradingnj',1),(124,'please',1),(124,'8',1),(124,'types',1),(124,'offering',1),(124,'transactional',1),(124,'allows',1),(100,'1',2),(124,'guidance',1),(124,'ftc',1),(124,'receiving',2),(124,'cases',1),(124,'preferences',1),(124,'changed',1),(124,'already',1),(124,'one',1),(150,'concerning',1),(150,'continued',1),(150,'understandings',1),(150,'supersedes',1),(150,'entire',1),(150,'provisions',1),(150,'dependents',1),(150,'minor',1),(150,'given',1),(150,'least',1),(150,'agreeing',1),(150,'22',1),(150,'reference',1),(150,'incorporated',2),(150,'consult',1),(150,'disclosed',1),(150,'collected',1),(150,'visitors',1),(150,'protecting',1),(150,'committed',1),(150,'21',1),(150,'writing',1),(150,'legal',1),(150,'satisfy',1),(150,'disclosures',1),(150,'agreements',3),(150,'communicate',1),(150,'electronically',3),(150,'communicating',1),(150,'mails',1),(150,'communications',4),(150,'consent',3),(150,'20',1),(150,'county',1),(150,'beach',1),(150,'palm',1),(150,'courts',1),(150,'venue',1),(150,'disputes',1),(150,'conflicts',1),(150,'regard',1),(150,'florida',2),(150,'accordance',1),(150,'construed',1),(150,'governed',1),(150,'forum',1),(150,'choice',1),(150,'19',1),(150,'provision',1),(150,'term',1),(150,'fail',1),(150,'ttt\'s',1),(124,'instances',1),(124,'requests',1),(124,'process',1),(124,'days',1),(124,'10',1),(124,'messages',1),(124,'continuing',1),(124,'opt',4),(124,'commercial',1),(124,'ecommercesupport@tttradingnj',1),(124,'contacting',1),(124,'initial',1),(124,'subscribe',1),(124,'opportunity',3),(124,'first',2),(124,'change',2),(124,'7',1),(124,'nature',1),(150,'deny',1),(150,'accordingly',1),(150,'termination',1),(150,'18',1),(150,'breach',1),(150,'arising',2),(150,'fees',1),(150,'attorney',1),(150,'expense',1),(150,'harmless',1),(150,'contractors',1),(150,'employees',1),(150,'officers',1),(150,'directors',1),(150,'hold',1),(150,'indemnify',1),(150,'indemnification',1),(150,'consequences',1),(150,'reason',2),(150,'suspend',1),(150,'alter',1),(150,'apply',1),(150,'exclusions',1),(150,'lasts',1),(150,'long',1),(5,'name',1),(5,'page',1),(5,'*',1),(5,'}',1),(5,'navigation',1),(5,'news',1),(150,'respect',1),(150,'particular',1),(150,'fitness',1),(150,'merchantability',1),(150,'expressed',1),(150,'warranties',2),(150,'disclaims',1),(150,'allowable',1),(150,'employee',1),(150,'compatible',1),(150,'responsibilities',1),(150,'downloaded',1),(124,'determined',1),(124,'partiesâ€™',2),(124,'examples',1),(124,'received',1),(124,'names',2),(124,'year',1),(124,'calendar',1),(124,'preceding',1),(124,'disclosed',1),(124,'categories',1),(124,'following',1),(124,'33426',1),(124,'florida',1),(124,'beach',1),(124,'boynton',1),(124,'215',1),(124,'suite',1),(124,'avenue',1),(124,'congress',1),(114,'1',2),(114,'Â ',2),(114,'satisfied',1),(114,'thoroughly',1),(114,'visit',1),(114,'hope',1),(114,'clientele',1),(114,'service',1),(114,'unparalleled',1),(114,'providing',1),(114,'dedicated',1),(114,'long',1),(114,'company',1),(114,'com',1),(114,'www',1),(114,'twintowerstrading',1),(100,'Â ',5),(100,'us',4),(100,'contact',4),(124,'north',1),(124,'1880',1),(124,'officer',1),(124,'californiaprivacy@tttradingnj',1),(124,'send',3),(118,'need',1),(118,'ever',1),(118,'effective',1),(118,'fastest',1),(118,'easiest',1),(118,'introduce',1),(118,'us',1),(118,'allow',1),(118,'thinking',1),(118,'found',1),(118,'importance',1),(118,'understand',1),(118,'feel',1),(118,'young',1),(118,'yellowing',1),(118,'see',1),(118,'pictures',1),(118,'look',2),(118,'impression',2),(118,'first',2),(118,'great',1),(118,'make',1),(118,'interviews',1),(118,'job',1),(118,'planning',1),(118,'amazing',1),(118,'everyone',1),(118,'dazzle',1),(118,'hope',1),(118,'event',1),(118,'important',1),(118,'attending',1),(118,'Â ',1),(118,'1',1),(118,'gif',1),(118,'logo1',1),(118,'confidence',1),(118,'procedure',1),(118,'esteem',1),(124,'find',1),(124,'companies',1),(124,'affiliated',1),(124,'manner',1),(124,'regarding',2),(124,'request',3),(124,'right',1),(124,'residents',1),(124,'written',1),(124,'prior',1),(124,'unless',1),(124,'agree',1),(150,'appearing',1),(150,'risks',1),(150,'appropriateness',1),(150,'accuracy',1),(150,'implied',4),(150,'express',1),(150,'either',2),(150,'representation',2),(150,'warranty',3),(150,'makes',2),(150,'faults',1),(150,'â€œwith',1),(150,'isâ€',1),(150,'â€œas',1),(150,'disclaimer',1),(150,'16',1),(150,'permitted',1),(150,'shall',1),(150,'suppliersâ€™',1),(150,'licensorsâ€™',1),(150,'agentsâ€™',1),(150,'affiliatesâ€™',1),(150,'incidental',2),(150,'exclusion',2),(150,'jurisdictions',3),(150,'dollars',1),(150,'$50',1),(150,'fifty',1),(150,'exceed',1),(150,'total',1),(150,'event',1),(150,'possibility',1),(150,'even',1),(150,'strict',1),(150,'negligence',1),(150,'tort',1),(150,'contract',1),(150,'whether',1),(150,'damage',1),(150,'profits',1),(150,'compensatory',1),(150,'virus',1),(150,'computer',2),(150,'interruption',1),(150,'omission',1),(150,'error',2),(150,'performance',2),(150,'failure',2),(150,'inability',1),(150,'kind',1),(150,'repairs',1),(150,'servicing',1),(150,'necessary',1),(150,'associated',1),(150,'costs',2),(150,'responsibility',1),(150,'full',1),(150,'assume',2),(150,'risk',1),(150,'acknowledge',1),(150,'15',1),(150,'color',1),(150,'monitor\'s',1),(150,'guarantee',1),(150,'cannot',1),(150,'equipment',2),(150,'limitations',3),(150,'technical',1),(150,'capabilities',1),(150,'depend',1),(150,'see',1),(150,'actually',1),(150,'colors',2),(150,'possible',2),(150,'accurately',1),(150,'display',2),(150,'efforts',1),(150,'best',1),(150,'cases',1),(150,'depiction',1),(150,'graphical',1),(150,'14',1),(150,'void',1),(150,'discontinue',1),(150,'discretion',2),(150,'sole',3),(150,'offer',2),(150,'quantities',1),(150,'basis',2),(150,'case',2),(150,'exercise',1),(150,'region',1),(150,'geographic',1),(150,'sales',1),(150,'limit',2),(150,'different',1),(150,'safety',1),(150,'requirements',2),(150,'regulatory',1),(150,'countries',1),(150,'advised',2),(150,'intended',1),(150,'sold',1),(150,'submitted',1),(150,'orders',1),(150,'cancel',1),(150,'correct',1),(150,'prior',3),(150,'reserves',4),(150,'times',1),(150,'transit',1),(150,'charges',1),(150,'shipping',1),(150,'descriptions',2),(150,'promotions',1),(150,'offers',1),(150,'special',2),(150,'availability',2),(150,'product',10),(150,'omissions',2),(150,'inaccuracies',2),(150,'typographical',1),(150,'errors',3),(150,'contain',1),(150,'occasion',1),(150,'incomplete',1),(150,'inaccurate',2),(150,'become',1),(150,'cause',1),(150,'circumstances',1),(150,'events',1),(150,'subsequent',1),(150,'available',1),(150,'complete',1),(150,'reviewing',1),(150,'remember',1),(150,'updated',1),(150,'indicate',1),(150,'taken',1),(150,'applied',1),(150,'refresh',1),(150,'specified',1),(150,'except',1),(150,'pricing',4),(150,'clarify',1),(150,'amend',2),(150,'undertakes',1),(150,'12',1),(150,'stolen',1),(150,'lost',2),(150,'report',1),(150,'immediately',2),(150,'obligated',2),(150,'back',1),(150,'traced',1),(150,'linked',1),(150,'conducted',2),(150,'indirect',2),(150,'username',3),(150,'password',3),(150,'passwords',1),(150,'accounts',1),(150,'registration',1),(150,'11',1),(150,'violating',1),(150,'terminate',3),(150,'reserve',2),(150,'features',1),(150,'security',2),(150,'circumvent',1),(150,'interfere',1),(150,'k',1),(150,'immoral',1),(150,'obscene',1),(150,'j',1),(150,'scrape',1),(150,'crawl',1),(150,'spider',1),(150,'pretext',1),(150,'redirection',1),(150,'traffic',1),(124,'prohibited',1),(124,'direct',5),(124,'party',1),(124,'third',8),(124,'california',3),(124,'com',4),(124,'6',1),(124,'childrensprivacy@tttradingnj',1),(124,'submitted',1),(124,'questions',1),(124,'parents',1),(124,'databases',1),(124,'deleted',1),(124,'provided',1),(124,'child',2),(124,'aware',1),(124,'becomes',1),(124,'parental',2),(124,'knowingly',1),(124,'13',4),(124,'age',4),(124,'minors',1),(124,'toward',1),(124,'directed',1),(124,'neither',1),(124,'audience',1),(124,'general',2),(124,'sites',2),(124,'children',3),(124,'5',1),(124,'regard',1),(124,'care',1),(124,'remain',1),(124,'always',1),(124,'communications',2),(124,'searches',1),(124,'expect',1),(124,'should',3),(124,'promise',1),(124,'risks',1),(124,'inherent',1),(124,'efforts',1),(124,'prevent',1),(124,'gaining',1),(124,'firewalls',1),(124,'transmitted',2),(124,'sensitive',1),(124,'encryption',1),(124,'forms',1),(124,'â€œsslâ€',1),(124,'layer',1),(124,'sockets',1),(124,'secure',2),(124,'legitimate',1),(114,'inc',1),(114,'trading',1),(114,'towers',1),(114,'twin',1),(114,'division',1),(114,'condition',1),(114,'depending',1),(114,'improvement',1),(114,'shades',1),(114,'eight',1),(114,'three',1),(114,'anywhere',1),(114,'see',1),(114,'expect',1),(114,'session',1),(114,'minute',1),(114,'skin',1),(114,'end',1),(114,'20',1),(124,'performing',1),(124,'personnel',1),(124,'authorized',4),(124,'unauthorized',2),(124,'safeguarding',1),(124,'assist',1),(124,'measures',1),(124,'procedural',1),(124,'electronic',2),(124,'physical',1),(124,'implemented',1),(124,'storage',1),(124,'4',1),(124,'compliance',2),(124,'shall',1),(124,'canadian',1),(124,'directive',1),(124,'data',4),(124,'eu',1),(124,'limited',1),(124,'states',1),(124,'united',1),(124,'jurisdiction',1),(124,'laws',2),(124,'subject',2),(124,'foregoing',1),(124,'notwithstanding',2),(124,'assets',1),(124,'assignment',1),(114,'gums',1),(114,'light',1),(114,'led',1),(114,'benefit',1),(114,'added',1),(114,'promote',1),(114,'sensitivity',1),(114,'tooth',1),(114,'decrease',1),(114,'performance',1),(114,'increase',1),(114,'formulated',1),(114,'specially',1),(114,'peroxide',1),(118,'cosmetic',1),(118,'low',1),(118,'safe',1),(118,'painless',1),(118,'easy',1),(118,'appearance',1),(118,'improve',2),(118,'desire',1),(118,'strong',1),(118,'little',1),(118,'people',1),(118,'busy',1),(118,'solution',1),(118,'ideal',1),(118,'time',2),(118,'charge',1),(118,'would',1),(118,'dentist',1),(118,'fraction',2),(118,'cost',3),(118,'proven',1),(118,'revolutionary',1),(118,'12',1),(118,'increase',2),(118,'can',1),(118,'process',3),(118,'additional',1),(118,'lighter',2),(118,'shades',2),(118,'8',1),(118,'3',1),(118,'anywhere',1),(118,'results',3),(118,'experience',1),(118,'will',4),(118,'minutes',2),(118,'20',2),(118,'system',1),(118,'whitening',2),(118,'teeth',3),(118,'chairside',1),(118,'administered',1),(118,'self',3),(118,'based',1),(118,'tray',1),(118,'â€',3),(118,'smile',4),(118,'want',5),(118,'â€œi',3),(118,'home',4),(114,'solutions',1),(114,'carbamide',1),(114,'quality',1),(114,'finish',1),(114,'start',1),(114,'process',2),(114,'will',3),(114,'guide',1),(114,'assistants',1),(114,'trained',1),(114,'chairs',1),(114,'reclining',1),(114,'comfortable',1),(114,'make',1),(114,'administered',1),(114,'self',1),(114,'completely',2),(114,'system',1),(114,'revolutionary',1),(114,'today',1),(114,'market',1),(114,'products',2),(114,'counter',1),(114,'effective',1),(114,'offer',1),(114,'dentists',1),(114,'consuming',1),(114,'time',1),(114,'expensive',1),(114,'less',1),(114,'far',2),(114,'whitening',6),(114,'method',1),(114,'painless',1),(114,'safe',2),(114,'simple',1),(114,'developed',1),(114,'want',3),(114,'age',1),(114,'yellow',1),(114,'started',1),(114,'granted',1),(114,'took',1),(114,'teeth',6),(114,'white',1),(114,'bright',1),(114,'lose',1),(114,'lusterâ€”the',1),(114,'smiles',1),(114,'years',1),(114,'unfortunately',1),(114,'smile',4),(114,'beautiful',1),(114,'impression',1),(114,'better',1),(114,'makes',1),(114,'nothing',1),(114,'date',1),(114,'interview',1),(114,'job',1),(114,'successful',2),(114,'everything',1),(114,'determine',1),(114,'can',2),(114,'impressions',1),(114,'first',4),(114,'honest',1),(114,'us',5),(114,'appearance',1),(114,'matters',1),(114,'letâ€™s',1),(124,'involves',1),(124,'transaction',1),(124,'merger',1),(124,'sale',2),(124,'investigations',1),(124,'g',1),(124,'otherwise',2),(124,'required',1),(150,'web',1),(150,'pharm',1),(150,'fraud',2),(150,'phish',1),(150,'spam',1),(150,'track',1),(150,'collect',1),(150,'h',1),(150,'internet',3),(150,'operation',1),(150,'affect',1),(150,'way',3),(150,'used',3),(150,'code',1),(150,'malicious',1),(150,'type',1),(150,'viruses',2),(150,'transmit',1),(150,'upload',1),(150,'g',1),(150,'misleading',1),(150,'false',1),(150,'f',1),(150,'disability',1),(150,'origin',1),(150,'national',1),(150,'race',1),(150,'ethnicity',1),(150,'religion',1),(150,'orientation',1),(150,'sexual',1),(150,'gender',1),(150,'based',3),(150,'discriminate',1),(150,'intimidate',1),(150,'disparage',1),(150,'slander',1),(150,'defame',1),(150,'insult',1),(150,'abuse',1),(150,'harass',1),(150,'e',3),(150,'infringe',1),(150,'d',1),(150,'ordinances',1),(150,'local',1),(150,'regulations',2),(150,'international',1),(150,'violate',2),(150,'acts',1),(150,'participate',1),(150,'perform',1),(150,'others',3),(150,'solicit',1),(150,'b',1),(150,'unlawful',2),(150,'prohibitions',1),(150,'addition',2),(150,'prohibited',5),(150,'network',2),(150,'relating',2),(150,'engaging',1),(150,'restrain',1),(150,'order',2),(150,'seeking',1),(150,'filed',1),(150,'action',2),(150,'received',1),(150,'required',2),(150,'requirement',2),(150,'enabled',1),(150,'re',1),(150,'restored',1),(150,'provides',1),(150,'agentâ€™s',1),(150,'process',1),(150,'accept',1),(150,'states',1),(150,'united',1),(150,'outside',1),(150,'located',2),(150,'judicial',2),(150,'court',2),(150,'district',3),(150,'federal',3),(150,'jurisdiction',3),(150,'consents',1),(150,'name',1),(150,'subscriberâ€™s',2),(150,'misidentification',1),(150,'mistake',1),(150,'identified',1),(150,'appeared',1),(150,'location',1),(150,'subscriber',5),(124,'permitted',2),(124,'external',1),(124,'internal',1),(124,'f',1),(124,'claims',1),(124,'defend',1),(124,'suppliers',1),(124,'vendors',1),(124,'contractors',1),(124,'employees',1),(124,'safety',1),(124,'property',1),(124,'d',1),(124,'rights',2),(124,'exercise',1),(124,'legal',2),(124,'establish',1),(124,'c',2),(124,'agency',1),(124,'government',1),(124,'enforcement',1),(124,'law',5),(124,'cooperate',1),(124,'b',2),(124,'court',1),(124,'subpoena',1),(124,'comply',1),(124,'qualified',1),(124,'future',1),(124,'current',1),(124,'application',2),(124,'connection',2),(124,'solely',2),(124,'posted',1),(124,'fulfill',1),(124,'contractor',1),(124,'independent',1),(124,'seeking',2),(124,'models',1),(124,'individuals',2),(124,'could',1),(124,'offer',2),(124,'would',1),(124,'form',1),(124,'completed',1),(124,'women',1),(124,'y',1),(124,'men',1),(124,'x',1),(124,'area',1),(124,'visitors',1),(124,'particular',1),(124,'affiliate',1),(124,'report',1),(124,'improve',1),(124,'cumulative',1),(124,'conditions',1),(124,'terms',1),(124,'enforce',1),(124,'described',1),(124,'functions',2),(124,'perform',1),(124,'support',2),(124,'conduct',1),(124,'relationship',3),(124,'customer',3),(124,'manage',1),(124,'organize',1),(124,'needs',4),(124,'specific',1),(124,'tailor',1),(124,'fraud',1),(124,'partners',2),(124,'purposes',5),(124,'shared',2),(124,'purpose',1),(124,'receive',4),(124,'answer',1),(124,'e',3),(124,'addresses',2),(124,'return',1),(124,'interest',1),(124,'events',1),(124,'promotional',1),(124,'changes',1),(124,'status',1),(124,'give',1),(124,'updates',1),(124,'mail',4),(124,'via',1),(124,'contact',4),(124,'processing',1),(124,'handle',2),(124,'providers',2),(124,'necessary',2),(124,'extent',3),(124,'except',1),(124,'consent',4),(124,'parties',7),(124,'outside',3),(124,'share',5),(124,'complete',2),(124,'placing',1),(124,'business',11),(124,'provide',5),(124,'identifiable',2),(124,'personally',2),(124,'uses',2),(124,'disclosure',2),(124,'3',1),(124,'periods',1),(124,'extended',1),(124,'available',1),(124,'logs',1),(124,'server',1),(124,'stored',1),(124,'obtain',1),(124,'ip',2),(124,'programming',1),(124,'content',2),(124,'best',1),(124,'determine',1),(124,'customize',1),(124,'programs',2),(124,'allow',2),(124,'advertising',2),(124,'campaigns',1),(124,'effectiveness',2),(124,'ascertain',1),(124,'us',9),(124,'help',7),(124,'gifs',1),(124,'â€œclear',1),(124,'tags',1),(124,'â€œpixel',1),(124,'â€œbeacons',1),(124,'accessing',1),(124,'movements',1),(124,'analyze',2),(124,'technologies',3),(124,'based',1),(124,'standard',1),(124,'referring',1),(124,'type',1),(124,'â€œipâ€',1),(124,'protocol',1),(124,'internet',2),(124,'include',2),(124,'using',1),(124,'take',3),(124,'actions',1),(124,'click',1),(124,'advertisements',1),(124,'pages',1),(124,'time',7),(124,'also',8),(124,'function',1),(124,'properly',1),(150,'provided',5),(150,'notificationâ€',1),(150,'â€œcounter',1),(150,'receives',1),(150,'counter',4),(150,'notify',1),(150,'promptly',1),(150,'steps',1),(150,'reasonable',1),(150,'take',1),(150,'infringer',4),(150,'forward',1),(150,'alleged',6),(150,'disable',1),(150,'remove',2),(150,'outlined',2),(150,'containing',2),(150,'receipt',2),(150,'upon',3),(150,'swear',2),(150,'perjury',2),(150,'penalty',2),(150,'accurate',2),(150,'â€œthe',1),(150,'law',7),(150,'complained',1),(150,'manner',1),(150,'address',5),(150,'telephone',2),(150,'belief',2),(150,'faith',2),(150,'good',2),(150,'â€œi',2),(150,'statement',5),(150,'contacted',1),(146,'}',1),(146,'*',1),(146,'page',1),(124,'delete',2),(124,'placed',1),(124,'accept',2),(124,'experience',1),(124,'personalize',1),(124,'drive',2),(124,'hard',2),(124,'computerâ€™s',1),(124,'place',1),(124,'files',1),(124,'text',1),(124,'tiny',1),(124,'cookies',4),(124,'connect',1),(124,'browser',5),(124,'web',4),(124,'computer',1),(124,'tools',1),(124,'use',16),(124,'collects',3),(124,'2',1),(124,'back',1),(124,'directly',2),(124,'linked',1),(124,'contain',1),(124,'aggregated',1),(124,'visit',4),(124,'non',2),(124,'aggregate',1),(124,'example',4),(124,'identify',2),(124,'cannot',3),(124,'times',1),(124,'billing',1),(124,'shipping',2),(124,'date',1),(124,'expiration',1),(124,'card',3),(124,'credit',3),(124,'like',1),(124,'additional',5),(124,'need',1),(124,'will',8),(124,'materials',1),(124,'related',1),(124,'marketing',8),(124,'products',5),(124,'purchase',1),(124,'decide',1),(124,'registration',3),(124,'require',2),(124,'areas',2),(124,'access',7),(124,'mailing',1),(124,'home',1),(124,'security',4),(124,'social',1),(124,'address',7),(124,'email',9),(124,'number',7),(124,'telephone',2),(124,'name',1),(124,'collection',3),(124,'personal',24),(124,'1',3),(124,'used',6),(124,'collected',1),(124,'way',1),(124,'make',1),(124,'can',3),(124,'choices',2),(124,'practices',1),(124,'explaining',1),(124,'notice',1),(124,'provides',1),(124,'protect',5),(124,'better',1),(124,'certain',5),(124,'disclose',4),(124,'collect',8),(124,'may',34),(124,'services',9),(124,'operation',1),(124,'normal',1),(124,'part',1),(124,'information',55),(124,'commitment',2),(124,'demonstrate',1),(124,'order',7),(124,'created',1),(124,'consumer',1),(124,'protection',3),(124,'committed',1),(124,'ttt',30),(124,'collectively',1),(124,'company',2),(124,'distribution',1),(124,'llc',2),(124,'management',1),(124,'limitation',1),(124,'without',5),(124,'including',3),(124,'affiliates',3),(124,'inc',2),(124,'trading',4),(124,'towers',4),(124,'twin',4),(124,'customers',2),(124,'service',4),(124,'offered',5),(124,'site',18),(124,'â€',4),(124,'s',1),(124,'â€œsite',1),(124,'website',2),(124,'herein',1),(124,'defined',1),(124,'tttâ€™s',4),(124,'privacy',13),(124,'policy',5),(124,'welcome',1),(150,'email',2),(150,'number',2),(150,'complaining',3),(150,'contact',3),(150,'locate',1),(150,'us',5),(150,'permit',2),(150,'sufficient',2),(150,'reasonably',2),(150,'disabled',6),(150,'removed',7),(150,'activity',3),(150,'infringing',4),(150,'material',9),(150,'list',1),(150,'representative',2),(150,'covered',1),(150,'online',1),(150,'single',2),(150,'works',2),(150,'multiple',1),(150,'claimed',2),(150,'work',1),(30,'name',1),(30,'page',1),(30,'*',1),(30,'}',1),(150,'copyrighted',2),(150,'identification',3),(150,'infringed',3),(150,'allegedly',2),(150,'exclusive',3),(150,'owner',4),(150,'behalf',2),(150,'authorized',4),(150,'person',4),(150,'signature',2),(150,'electronic',3),(150,'physical',2),(150,'include',2),(150,'must',3),(150,'notification',12),(150,'dmca',4),(150,'9',1),(150,'07726',1),(150,'nj',1),(32,'name',1),(32,'page',1),(32,'*',1),(32,'}',1),(32,'navigation',2),(32,'sub',1),(150,'manalapan',1),(150,'street',1),(150,'station',1),(150,'10',2),(150,'mail',2),(150,'via',1),(150,'com',1),(150,'copyrightalert@tttradingnj',1),(150,'8010',1),(150,'786',1),(150,'732',1),(150,'reached',1),(150,'can',2),(150,'assistant',1),(150,'administrative',1),(150,'found',2),(150,'notices',3),(150,'infringement',6),(150,'agent',8),(150,'designated',3),(150,'512',1),(150,'Â§',1),(150,'c',2),(150,'u',5),(150,'17',2),(150,'â€œdmcaâ€',1),(150,'act',3),(150,'pursuant',2),(150,'agents',2),(150,'millennium',2),(150,'copyrights',1),(150,'8',1),(150,'directed',1),(150,'should',3),(150,'questions',2),(150,'concerns',1),(150,'claims',4),(150,'complaints',1),(150,'transaction',1),(150,'engage',1),(150,'understand',1),(150,'sure',1),(150,'practices',1),(150,'policies',1),(150,'party\'s',1),(150,'review',1),(150,'made',2),(150,'productsâ€',1),(150,'â€œthird',1),(150,'transactions',1),(150,'resources',1),(150,'goods',1),(34,'news',5),(34,'module',3),(34,'installed',3),(34,'exciting',1),(34,'article',2),(34,'using',1),(34,'summary',1),(34,'field',1),(34,'therefore',1),(34,'link',1),(34,'read',2),(34,'can',1),(34,'click',1),(34,'heading',1),(150,'related',7),(150,'harm',2),(150,'affiliated',1),(150,'direct',3),(150,'allow',4),(150,'extent',3),(150,'links',3),(150,'7',1),(150,'connection',4),(150,'death',1),(150,'wrongful',1),(150,'damages',10),(150,'punitive',1),(150,'consequential',4),(150,'actual',1),(150,'privacy',4),(150,'personal',5),(150,'violations',1),(150,'tangible',1),(150,'real',1),(150,'injury',2),(150,'loss',2),(150,'claim',1),(150,'liable',5),(150,'responsible',3),(150,'constitute',2),(150,'posting',2),(150,'although',1),(150,'liability',5),(150,'endorsement',2),(150,'6',2),(150,'moral',1),(150,'waive',1),(150,'laws',5),(150,'existing',3),(150,'purposes',1),(150,'uses',4),(150,'parties',1),(150,'sublicense',1),(150,'whatsoever',1),(150,'purpose',4),(150,'lawful',2),(150,'free',2),(150,'royalty',1),(150,'assignable',1),(150,'irrevocable',1),(150,'unlimited',1),(150,'worldwide',1),(150,'automatically',1),(150,'perpetual',1),(150,'make',2),(150,'image',1),(150,'photo',1),(150,'guardian',1),(150,'parent',1),(150,'child\'s',1),(150,'residence',3),(150,'state',6),(150,'majority',3),(150,'age',4),(150,'child',1),(150,'depict',1),(150,'photographs',1),(150,'contains',1),(150,'submission',5),(150,'publicity',1),(150,'permissions',1),(150,'rights',6),(150,'transferable',2),(150,'unencumbered',1),(150,'represent',4),(150,'items',1),(150,'submitting',1),(150,'generated',4),(150,'opportunity',2),(150,'submit',4),(150,'provide',3),(150,'5',1),(150,'treated',1),(150,'returned',1),(150,'regarding',2),(150,'respond',2),(150,'will',19),(150,'compensate',1),(150,'obligation',2),(150,'â€œsubmission',1),(150,'like',1),(150,'proprietary',1),(150,'confidential',2),(150,'materials',2),(150,'ideas',1),(150,'concepts',1),(150,'original',2),(150,'creative',1),(150,'unsolicited',1),(150,'send',2),(150,'feedback',1),(150,'receive',3),(150,'desires',1),(150,'submissions',11),(150,'comments',1),(150,'user',7),(150,'4',2),(150,'printing',1),(150,'copying',1),(150,'downloading',1),(150,'result',2),(150,'transferred',1),(150,'title',1),(150,'limited',2),(150,'non',3),(150,'print',1),(150,'copy',1),(150,'download',1),(150,'communication',2),(150,'entertainment',1),(150,'education',1),(150,'information',25),(150,'services',4),(150,'products',9),(150,'purchase',2),(150,'solely',1),(150,'allowed',1),(150,'access',10),(150,'websites',5),(150,'reposted',1),(150,'processed',1),(150,'modified',2),(150,'commercial',2),(150,'copied',1),(150,'content',16),(150,'protection',2),(150,'property',5),(150,'intellectual',4),(150,'trademark',1),(150,'patent',1),(150,'subject',5),(150,'â€œcontentâ€',1),(150,'arrangement',1),(150,'media',1),(150,'digital',5),(150,'functionality',2),(150,'application',1),(150,'files',1),(150,'video',3),(150,'photos',1),(150,'graphics',1),(150,'images',2),(150,'text',1),(150,'copyright',11),(150,'contents',1),(150,'3',2),(150,'permission',2),(150,'written',5),(150,'right',13),(150,'license',3),(150,'otherwise',1),(150,'implication',1),(150,'grant',2),(150,'serves',1),(150,'contained',1),(150,'nothing',1),(150,'licensors',4),(150,'party',16),(150,'third',14),(150,'unregistered',1),(150,'registered',1),(150,'displayed',5),(150,'marks',1),(150,'logos',2),(150,'dress',1),(150,'trade',2),(150,'names',1),(150,'trademarks',8),(150,'2',2),(150,'comply',4),(150,'posted',3),(150,'updates',2),(150,'revisions',1),(150,'deletions',1),(150,'modifications',1),(150,'edits',1),(150,'changes',2),(150,'notice',7),(150,'time',7),(150,'update',4),(150,'revise',1),(150,'delete',1),(150,'modify',2),(150,'edit',1),(150,'change',3),(150,'bound',1),(150,'agreement',3),(150,'tou',18),(150,'acceptance',2),(150,'understanding',1),(150,'knowledge',1),(150,'constitutes',3),(150,'stated',1),(150,'agree',3),(150,'using',2),(150,'carefully',2),(150,'read',1),(150,'please',6),(150,'introduction',1),(150,'1',6),(150,'sites',5),(150,'govern',2),(150,'rules',3),(150,'basic',1),(150,'forth',2),(150,'set',2),(150,'â€œtouâ€',1),(150,'following',6),(150,'visit',2),(150,'interest',2),(150,'appreciate',1),(150,'ttt',44),(150,'collectively',2),(150,'company',2),(150,'distribution',2),(150,'llc',2),(150,'management',1),(150,'site',61),(150,'limitation',12),(150,'without',16),(150,'including',12),(150,'affiliates',2),(150,'inc',1),(150,'trading',3),(150,'towers',3),(150,'twin',3),(150,'customers',2),(150,'service',4),(150,'offered',1),(150,'â€',6),(150,'â€œsite',1),(150,'s',8),(150,'website',2),(150,'herein',1),(150,'defined',1),(150,'tttâ€™s',7),(150,'welcome',1),(150,'2009',1),(150,'13',2),(150,'may',25),(150,'date',5),(146,'name',1),(150,'webmaster',1),(150,'desire',1),(150,'effective',7),(150,'use',39),(150,'conditions',7),(150,'terms',7),(147,'}',1),(147,'*',1),(147,'page',1),(147,'name',1),(145,'Â©',1),(145,'twin',1),(145,'towers',1),(145,'trading',1),(145,'inc',1),(145,'rights',1),(145,'reserved',1),(145,'privacy',1),(145,'policy',1),(145,'|',1),(145,'terms',1),(145,'conditions',1),(145,'use',1);
/*!40000 ALTER TABLE `cms_module_search_index` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_search_items`
--

DROP TABLE IF EXISTS `cms_module_search_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_search_items` (
  `id` int(11) NOT NULL,
  `module_name` varchar(100) DEFAULT NULL,
  `content_id` int(11) DEFAULT NULL,
  `extra_attr` varchar(100) DEFAULT NULL,
  `expires` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `module_name` (`module_name`),
  KEY `content_id` (`content_id`),
  KEY `extra_attr` (`extra_attr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_search_items`
--

LOCK TABLES `cms_module_search_items` WRITE;
/*!40000 ALTER TABLE `cms_module_search_items` DISABLE KEYS */;
INSERT INTO `cms_module_search_items` VALUES (147,'Search',15,'template',NULL),(146,'Search',16,'template',NULL),(5,'Search',17,'template',NULL),(118,'Search',15,'content',NULL),(114,'Search',51,'content',NULL),(108,'Search',2,'global_content',NULL),(100,'Search',52,'content',NULL),(124,'Search',53,'content',NULL),(150,'Search',54,'content',NULL),(145,'Search',1,'global_content',NULL),(30,'Search',19,'template',NULL),(32,'Search',18,'template',NULL),(34,'News',1,'article',NULL);
/*!40000 ALTER TABLE `cms_module_search_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_search_items_seq`
--

DROP TABLE IF EXISTS `cms_module_search_items_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_search_items_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_search_items_seq`
--

LOCK TABLES `cms_module_search_items_seq` WRITE;
/*!40000 ALTER TABLE `cms_module_search_items_seq` DISABLE KEYS */;
INSERT INTO `cms_module_search_items_seq` VALUES (150);
/*!40000 ALTER TABLE `cms_module_search_items_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_search_words`
--

DROP TABLE IF EXISTS `cms_module_search_words`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_search_words` (
  `word` varchar(255) NOT NULL,
  `count` int(11) DEFAULT NULL,
  PRIMARY KEY (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_search_words`
--

LOCK TABLES `cms_module_search_words` WRITE;
/*!40000 ALTER TABLE `cms_module_search_words` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_module_search_words` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_module_templates`
--

DROP TABLE IF EXISTS `cms_module_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_module_templates` (
  `module_name` varchar(160) DEFAULT NULL,
  `template_name` varchar(160) DEFAULT NULL,
  `content` text,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  KEY `index_module_templates_by_module_name_template_name` (`module_name`,`template_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_module_templates`
--

LOCK TABLES `cms_module_templates` WRITE;
/*!40000 ALTER TABLE `cms_module_templates` DISABLE KEYS */;
INSERT INTO `cms_module_templates` VALUES ('News','summarySample','<!-- Start News Display Template -->\n{if $pagecount > 1}\n  <p>\n{if $pagenumber > 1}\n{$firstpage}&nbsp;{$prevpage}&nbsp;\n{/if}\n{$pagetext}&nbsp;{$pagenumber}&nbsp;{$oftext}&nbsp;{$pagecount}\n{if $pagenumber < $pagecount}\n&nbsp;{$nextpage}&nbsp;{$lastpage}\n{/if}\n</p>\n{/if}\n{foreach from=$items item=entry}\n<div class=\"NewsSummary\">\n\n{if $entry->postdate}\n	<div class=\"NewsSummaryPostdate\">\n		{$entry->postdate|cms_date_format}\n	</div>\n{/if}\n\n<div class=\"NewsSummaryLink\">\n	{$entry->titlelink}\n</div>\n\n<div class=\"NewsSummaryCategory\">\n	{$category_label} {$entry->category}\n</div>\n\n{if $entry->author}\n	<div class=\"NewsSummaryAuthor\">\n		{$author_label} {$entry->author}\n	</div>\n{/if}\n\n{if $entry->summary}\n	<div class=\"NewsSummarySummary\">\n		{eval var=$entry->summary}\n	</div>\n\n	<div class=\"NewsSummaryMorelink\">\n		[{$entry->morelink}]\n	</div>\n\n{else if $entry->content}\n\n	<div class=\"NewsSummaryContent\">\n		{eval var=$entry->content}\n	</div>\n{/if}\n\n{if isset($entry->extra)}\n    <div class=\"NewsSummaryExtra\">\n        {eval var=$entry->extra}\n	{* {cms_module module=\'Uploads\' mode=\'simpleurl\' upload_id=$entry->extravalue} *}\n    </div>\n{/if}\n{if isset($entry->fields)}\n  {foreach from=$entry->fields item=\'field\'}\n     <div class=\"NewsSummaryField\">\n        {if $field->type == \'file\'}\n          <img src=\"{$entry->file_location}/{$field->value}\"/>\n        {else}\n          {$field->name}:&nbsp;{eval var=$field->value}\n        {/if}\n     </div>\n  {/foreach}\n{/if}\n\n</div>\n{/foreach}\n<!-- End News Display Template -->\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('News','detailSample','{if $entry->postdate}\n	<div id=\"NewsPostDetailDate\">\n		{$entry->postdate|cms_date_format}\n	</div>\n{/if}\n<h3 id=\"NewsPostDetailTitle\">{$entry->title}</h3>\n\n<hr id=\"NewsPostDetailHorizRule\" />\n\n{if $entry->summary}\n	<div id=\"NewsPostDetailSummary\">\n		<strong>\n			{eval var=$entry->summary}\n		</strong>\n	</div>\n{/if}\n\n{if $entry->category}\n	<div id=\"NewsPostDetailCategory\">\n		{$category_label} {$entry->category}\n	</div>\n{/if}\n{if $entry->author}\n	<div id=\"NewsPostDetailAuthor\">\n		{$author_label} {$entry->author}\n	</div>\n{/if}\n\n<div id=\"NewsPostDetailContent\">\n	{eval var=$entry->content}\n</div>\n\n{if $entry->extra}\n	<div id=\"NewsPostDetailExtra\">\n		{$extra_label} {$entry->extra}\n	</div>\n{/if}\n\n<div id=\"NewsPostDetailPrintLink\">\n	{$entry->printlink}\n</div>\n{if $return_url != \"\"}\n<div id=\"NewsPostDetailReturnLink\">{$return_url}</div>\n{/if}\n\n{if isset($entry->fields)}\n  {foreach from=$entry->fields item=\'field\'}\n     <div class=\"NewsDetailField\">\n        {if $field->type == \'file\'}\n	  {* this template assumes that every file uploaded is an image of some sort, because News doesn\'t distinguish *}\n          <img src=\"{$entry->file_location}/{$field->value}\"/>\n        {else}\n          {$field->name}:&nbsp;{eval var=$field->value}\n        {/if}\n     </div>\n  {/foreach}\n{/if}\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('News','formSample','{* original form template *}\n{if isset($error)}\n  <h3><font color=\"red\">{$error}</font></h3>\n{else}\n  {if isset($message)}\n    <h3>{$message}</h3>\n  {/if}\n{/if}\n{$startform}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">*{$titletext}:</p>\n		<p class=\"pageinput\">{$inputtitle}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$categorytext}:</p>\n		<p class=\"pageinput\">{$inputcategory}</p>\n	</div>\n{if !isset($hide_summary_field) or $hide_summary_field == 0}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$summarytext}:</p>\n		<p class=\"pageinput\">{$inputsummary}</p>\n	</div>\n{/if}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">*{$contenttext}:</p>\n		<p class=\"pageinput\">{$inputcontent}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$extratext}:</p>\n		<p class=\"pageinput\">{$inputextra}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$startdatetext}:</p>\n		<p class=\"pageinput\">{html_select_date prefix=$startdateprefix time=$startdate end_year=\"+15\"} {html_select_time prefix=$startdateprefix time=$startdate}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$enddatetext}:</p>\n		<p class=\"pageinput\">{html_select_date prefix=$enddateprefix time=$enddate end_year=\"+15\"} {html_select_time prefix=$enddateprefix time=$enddate}</p>\n	</div>\n	{if isset($customfields)}\n	   {foreach from=$customfields item=\'onefield\'}\n	      <div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$onefield->name}:</p>\n		<p class=\"pageinput\">{$onefield->field}</p>\n	      </div>\n	   {/foreach}\n	{/if}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">&nbsp;</p>\n		<p class=\"pageinput\">{$hidden}{$submit}{$cancel}</p>\n	</div>\n{$endform}\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('News','browsecatSample','{if $count > 0}\n<ul class=\"list1\">\n{foreach from=$cats item=node}\n{if $node.depth > $node.prevdepth}\n{repeat string=\"<ul>\" times=$node.depth-$node.prevdepth}\n{elseif $node.depth < $node.prevdepth}\n{repeat string=\"</li></ul>\" times=$node.prevdepth-$node.depth}\n</li>\n{elseif $node.index > 0}</li>\n{/if}\n<li class=\"newscategory\">\n{if $node.count > 0}\n	<a href=\"{$node.url}\">{$node.news_category_name}</a> ({$node.count}){else}<span>{$node.news_category_name} (0)</span>{/if}\n{/foreach}\n{repeat string=\"</li></ul>\" times=$node.depth-1}</li>\n</ul>\n{/if}','2008-12-09 20:40:24','2008-12-09 20:40:24'),('News','email_template','A new news article has been posted to your website.  The details are as follows:Title:      {$title}\nIP Address: {$ipaddress}\nSummary:    {$summary|strip_tags}\nPost Date:  {$postdate|date_format}\nStart Date: {$startdate|date_format}\nEnd Date:   {$enddate|date_format}\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('Printing','linktemplate','{if isset($imgsrc)}\n{capture assign=\'image\'}\n  <img src=\"{$imgsrc}\" title=\"{$linktext}\" alt=\"{$linktext}\" {if isset($imgclass) && $imgclass!=\'\'}class=\"{$imgclass}\"{/if} />\n{/capture}\n<a href=\"{$href}\" class=\"{$class}\" {$target} {if isset($more)}{$more}{/if}>{$image}</a>\n{else}\n<a href=\"{$href}\" class=\"{$class}\" {$target} {if isset($more)}{$more}{/if}>{$image}{$linktext}</a>\n{/if}\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('Printing','printtemplate','<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\n  <head>\n    <title>Printing {title}</title>\n    <meta name=\"robots\" content=\"noindex\"></meta>\n    <base href=\"{$rooturl}\" />\n    <meta name=\"Generator\" content=\"CMS Made Simple - Copyright (C) 2004-6 Ted Kulp. All rights reserved.\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n\n    {stylesheet}\n    {if $overridestylesheet!=\'\'}\n    <style type=\"text/css\">\n    {$overridestylesheet}\n    </style>\n    {/if}\n    \n  </head>\n  <body	style=\"background-color: white; color: black; background-image: none; text-align: left;\">	\n    {$content}\n        \n    {$printscript}\n</body>\n</html>\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('Printing','pdftemplate','<h1>{$title}</h1>\n{$content}\n','2008-12-09 20:40:24','2008-12-09 20:40:24'),('Search','displaysearch','{$startform}\n\n    <label for=\"{$search_actionid}searchinput\">{$searchprompt}</label>:&nbsp;<input type=\"text\" id=\"{$search_actionid}searchinput\" name=\"{$search_actionid}searchinput\" size=\"20\" maxlength=\"50\" value=\"{$searchtext}\" {$hogan}/><input name=\"submit\" value=\"{$submittext}\" type=\"submit\" />\n{if isset($hidden)}{$hidden}{/if}\n\n{$endform}','2008-12-09 20:40:24','2008-12-09 20:40:24'),('Search','displayresult','<h3>{$searchresultsfor} &quot;{$phrase}&quot;</h3>\n{if $itemcount > 0}\n<ul>\n  {foreach from=$results item=entry}\n  <li>{$entry->title} - <a href=\"{$entry->url}\">{$entry->urltxt}</a> ({$entry->weight}%)</li>\n  {* \n     You can also instantiate custom behaviour on a module by module basis by looking at\n     the $entry->module and $entry->modulerecord fields in $entry \n      ie: {if $entry->module == \'News\'}{News action=\'detail\' article_id=$entry->modulerecord detailpage=\'News\'} \n  *}\n  {/foreach}\n</ul>\n\n<p>{$timetaken}: {$timetook}</p>\n{else}\n  <p><strong>{$noresultsfound}</strong></p>\n{/if}','2008-12-09 20:40:24','2008-12-09 20:40:24');
/*!40000 ALTER TABLE `cms_module_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_modules`
--

DROP TABLE IF EXISTS `cms_modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_modules` (
  `module_name` varchar(160) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  `admin_only` tinyint(4) DEFAULT '0',
  `active` tinyint(4) DEFAULT NULL,
  KEY `index_modules_by_module_name` (`module_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_modules`
--

LOCK TABLES `cms_modules` WRITE;
/*!40000 ALTER TABLE `cms_modules` DISABLE KEYS */;
INSERT INTO `cms_modules` VALUES ('CMSMailer','installed','1.73.14',0,1),('FileManager','installed','0.4.3',1,1),('MenuManager','installed','1.5.3',0,1),('ModuleManager','installed','1.2.1',1,1),('News','installed','2.9.1',0,1),('nuSOAP','installed','1.0.1',1,1),('Printing','installed','0.2.6',0,1),('Search','installed','1.5.2',0,1),('ThemeManager','installed','1.0.8',1,1),('TinyMCE','installed','2.4.10',0,1);
/*!40000 ALTER TABLE `cms_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_permissions`
--

DROP TABLE IF EXISTS `cms_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_permissions` (
  `permission_id` int(11) NOT NULL,
  `permission_name` varchar(255) DEFAULT NULL,
  `permission_text` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_permissions`
--

LOCK TABLES `cms_permissions` WRITE;
/*!40000 ALTER TABLE `cms_permissions` DISABLE KEYS */;
INSERT INTO `cms_permissions` VALUES (1,'Add Pages','Add Pages','2006-07-25 21:22:33','2006-07-25 21:22:33'),(2,'Add Groups','Add Groups','2006-07-25 21:22:33','2006-07-25 21:22:33'),(4,'Add Templates','Add Templates','2006-07-25 21:22:33','2006-07-25 21:22:33'),(5,'Add Users','Add Users','2006-07-25 21:22:33','2006-07-25 21:22:33'),(6,'Modify Any Page','Modify Any Page','2006-07-25 21:22:33','2006-07-25 21:22:33'),(7,'Modify Groups','Modify Groups','2006-07-25 21:22:33','2006-07-25 21:22:33'),(8,'Modify Group Assignments','Modify Group Assignments','2006-07-25 21:22:33','2006-07-25 21:22:33'),(9,'Modify Permissions','Modify Permissions for Groups','2006-07-25 21:22:33','2006-07-25 21:22:33'),(11,'Modify Templates','Modify Templates','2006-07-25 21:22:33','2006-07-25 21:22:33'),(12,'Modify Users','Modify Users','2006-07-25 21:22:33','2006-07-25 21:22:33'),(13,'Remove Pages','Remove Pages','2006-07-25 21:22:33','2006-07-25 21:22:33'),(14,'Remove Groups','Remove Groups','2006-07-25 21:22:33','2006-07-25 21:22:33'),(16,'Remove Templates','Remove Templates','2006-07-25 21:22:33','2006-07-25 21:22:33'),(17,'Remove Users','Remove Users','2006-07-25 21:22:33','2006-07-25 21:22:33'),(18,'Modify Modules','Modify Modules','2006-07-25 21:22:33','2006-07-25 21:22:33'),(20,'Modify Files','Modify Files','2006-07-25 21:22:33','2006-07-25 21:22:33'),(21,'Modify Site Preferences','Modify Site Preferences','2006-07-25 21:22:33','2006-07-25 21:22:33'),(22,'Modify Stylesheets','Modify Stylesheets','2006-07-25 21:22:33','2006-07-25 21:22:33'),(23,'Add Stylesheets','Add Stylesheets','2006-07-25 21:22:33','2006-07-25 21:22:33'),(24,'Remove Stylesheets','Remove Stylesheets','2006-07-25 21:22:33','2006-07-25 21:22:33'),(25,'Add Stylesheet Assoc','Add Stylesheet Associations','2006-07-25 21:22:33','2006-07-25 21:22:33'),(26,'Modify Stylesheet Assoc','Modify Stylesheet Associations','2006-07-25 21:22:33','2006-07-25 21:22:33'),(27,'Remove Stylesheet Assoc','Remove Stylesheet Associations','2006-07-25 21:22:33','2006-07-25 21:22:33'),(28,'Modify User-defined Tags','Modify User-defined Tags','2006-07-25 21:22:33','2006-07-25 21:22:33'),(29,'Clear Admin Log','Clear Admin Log','2006-07-25 21:22:33','2006-07-25 21:22:33'),(30,'Add Global Content Blocks','Add Global Content Blocks','2006-07-25 21:22:33','2006-07-25 21:22:33'),(31,'Modify Global Content Blocks','Modify Global Content Blocks','2006-07-25 21:22:33','2006-07-25 21:22:33'),(32,'Remove Global Content Blocks','Remove Global Content Blocks','2006-07-25 21:22:33','2006-07-25 21:22:33'),(33,'Modify Page Structure','Modify Page Structure','2006-07-25 21:22:33','2006-07-25 21:22:33'),(35,'Modify Events','Modify Events','2006-01-27 20:06:58','2006-01-27 20:06:58'),(36,'View Tag Help','View Tag Help','2006-01-27 20:06:58','2006-01-27 20:06:58'),(37,'Use FileManager Advanced','Advanced usage of the the File Manager module','2008-12-09 20:40:24','2008-12-09 20:40:24'),(38,'Manage Menu','Manage Menu','2008-12-09 20:40:24','2008-12-09 20:40:24'),(39,'Modify News','Modify News','2008-12-09 20:40:24','2008-12-09 20:40:24'),(40,'Approve News','Approve News For Frontend Display','2008-12-09 20:40:24','2008-12-09 20:40:24'),(41,'Delete News','Delete News Articles','2008-12-09 20:40:24','2008-12-09 20:40:24'),(42,'Manage Themes','Manage Themes','2008-12-09 20:40:25','2008-12-09 20:40:25');
/*!40000 ALTER TABLE `cms_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_permissions_seq`
--

DROP TABLE IF EXISTS `cms_permissions_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_permissions_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_permissions_seq`
--

LOCK TABLES `cms_permissions_seq` WRITE;
/*!40000 ALTER TABLE `cms_permissions_seq` DISABLE KEYS */;
INSERT INTO `cms_permissions_seq` VALUES (42);
/*!40000 ALTER TABLE `cms_permissions_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_siteprefs`
--

DROP TABLE IF EXISTS `cms_siteprefs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_siteprefs` (
  `sitepref_name` varchar(255) NOT NULL,
  `sitepref_value` text,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`sitepref_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_siteprefs`
--

LOCK TABLES `cms_siteprefs` WRITE;
/*!40000 ALTER TABLE `cms_siteprefs` DISABLE KEYS */;
INSERT INTO `cms_siteprefs` VALUES ('enablecustom404','0','2006-07-25 21:22:33','2006-07-25 21:22:33'),('custom404','<p>Page could not be found.</p>','2006-07-25 21:22:33','2006-07-25 21:22:33'),('custom404template','-1','2006-07-25 21:22:33','2006-07-25 21:22:33'),('enablesitedownmessage','0','2006-07-25 21:22:33','2006-07-25 21:22:33'),('sitedownmessage','<p>Site is currently down for maintenance.</p>','2006-07-25 21:22:33','2006-07-25 21:22:33'),('sitedownmessagetemplate','-1','2006-07-25 21:22:33','2006-07-25 21:22:33'),('useadvancedcss','1','2006-07-25 21:22:33','2006-07-25 21:22:33'),('metadata','<meta name=\"Generator\" content=\"CMS Made Simple - Copyright (C) 2004-6 Ted Kulp. All rights reserved.\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n ','2006-07-25 21:22:33','2006-07-25 21:22:33'),('xmlmodulerepository','','2006-07-25 21:22:33','2006-07-25 21:22:33'),('logintheme','NCleanGrey','2006-07-25 21:22:33','2006-07-25 21:22:33'),('sitename','I Want That Smile - Teeth Whitening System',NULL,NULL),('CMSMailer_mapi_pref_mailer','smtp',NULL,NULL),('CMSMailer_mapi_pref_host','localhost',NULL,NULL),('CMSMailer_mapi_pref_port','25',NULL,NULL),('CMSMailer_mapi_pref_from','root@localhost',NULL,NULL),('CMSMailer_mapi_pref_fromuser','CMS Administrator',NULL,NULL),('CMSMailer_mapi_pref_sendmail','/usr/sbin/sendmail',NULL,NULL),('CMSMailer_mapi_pref_timeout','1000',NULL,NULL),('CMSMailer_mapi_pref_smtpauth','0',NULL,NULL),('CMSMailer_mapi_pref_username','',NULL,NULL),('CMSMailer_mapi_pref_password','',NULL,NULL),('FileManager_mapi_pref_iconsize','32px',NULL,NULL),('FileManager_mapi_pref_uploadboxes','5',NULL,NULL),('FileManager_mapi_pref_advancedmode','false',NULL,NULL),('FileManager_mapi_pref_showhiddenfiles','false',NULL,NULL),('ModuleManager_mapi_pref_module_repository','http://modules.cmsmadesimple.org/soap.php?module=ModuleRepository',NULL,NULL),('News_mapi_pref_default_summary_template_contents','<!-- Start News Display Template -->\n{if $pagecount > 1}\n  <p>\n{if $pagenumber > 1}\n{$firstpage}&nbsp;{$prevpage}&nbsp;\n{/if}\n{$pagetext}&nbsp;{$pagenumber}&nbsp;{$oftext}&nbsp;{$pagecount}\n{if $pagenumber < $pagecount}\n&nbsp;{$nextpage}&nbsp;{$lastpage}\n{/if}\n</p>\n{/if}\n{foreach from=$items item=entry}\n<div class=\"NewsSummary\">\n\n{if $entry->postdate}\n	<div class=\"NewsSummaryPostdate\">\n		{$entry->postdate|cms_date_format}\n	</div>\n{/if}\n\n<div class=\"NewsSummaryLink\">\n	{$entry->titlelink}\n</div>\n\n<div class=\"NewsSummaryCategory\">\n	{$category_label} {$entry->category}\n</div>\n\n{if $entry->author}\n	<div class=\"NewsSummaryAuthor\">\n		{$author_label} {$entry->author}\n	</div>\n{/if}\n\n{if $entry->summary}\n	<div class=\"NewsSummarySummary\">\n		{eval var=$entry->summary}\n	</div>\n\n	<div class=\"NewsSummaryMorelink\">\n		[{$entry->morelink}]\n	</div>\n\n{else if $entry->content}\n\n	<div class=\"NewsSummaryContent\">\n		{eval var=$entry->content}\n	</div>\n{/if}\n\n{if isset($entry->extra)}\n    <div class=\"NewsSummaryExtra\">\n        {eval var=$entry->extra}\n	{* {cms_module module=\'Uploads\' mode=\'simpleurl\' upload_id=$entry->extravalue} *}\n    </div>\n{/if}\n{if isset($entry->fields)}\n  {foreach from=$entry->fields item=\'field\'}\n     <div class=\"NewsSummaryField\">\n        {if $field->type == \'file\'}\n          <img src=\"{$entry->file_location}/{$field->value}\"/>\n        {else}\n          {$field->name}:&nbsp;{eval var=$field->value}\n        {/if}\n     </div>\n  {/foreach}\n{/if}\n\n</div>\n{/foreach}\n<!-- End News Display Template -->\n',NULL,NULL),('News_mapi_pref_current_summary_template','Sample',NULL,NULL),('News_mapi_pref_default_detail_template_contents','{if $entry->postdate}\n	<div id=\"NewsPostDetailDate\">\n		{$entry->postdate|cms_date_format}\n	</div>\n{/if}\n<h3 id=\"NewsPostDetailTitle\">{$entry->title}</h3>\n\n<hr id=\"NewsPostDetailHorizRule\" />\n\n{if $entry->summary}\n	<div id=\"NewsPostDetailSummary\">\n		<strong>\n			{eval var=$entry->summary}\n		</strong>\n	</div>\n{/if}\n\n{if $entry->category}\n	<div id=\"NewsPostDetailCategory\">\n		{$category_label} {$entry->category}\n	</div>\n{/if}\n{if $entry->author}\n	<div id=\"NewsPostDetailAuthor\">\n		{$author_label} {$entry->author}\n	</div>\n{/if}\n\n<div id=\"NewsPostDetailContent\">\n	{eval var=$entry->content}\n</div>\n\n{if $entry->extra}\n	<div id=\"NewsPostDetailExtra\">\n		{$extra_label} {$entry->extra}\n	</div>\n{/if}\n\n<div id=\"NewsPostDetailPrintLink\">\n	{$entry->printlink}\n</div>\n{if $return_url != \"\"}\n<div id=\"NewsPostDetailReturnLink\">{$return_url}</div>\n{/if}\n\n{if isset($entry->fields)}\n  {foreach from=$entry->fields item=\'field\'}\n     <div class=\"NewsDetailField\">\n        {if $field->type == \'file\'}\n	  {* this template assumes that every file uploaded is an image of some sort, because News doesn\'t distinguish *}\n          <img src=\"{$entry->file_location}/{$field->value}\"/>\n        {else}\n          {$field->name}:&nbsp;{eval var=$field->value}\n        {/if}\n     </div>\n  {/foreach}\n{/if}\n',NULL,NULL),('News_mapi_pref_current_detail_template','Sample',NULL,NULL),('News_mapi_pref_default_form_template_contents','{* original form template *}\n{if isset($error)}\n  <h3><font color=\"red\">{$error}</font></h3>\n{else}\n  {if isset($message)}\n    <h3>{$message}</h3>\n  {/if}\n{/if}\n{$startform}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">*{$titletext}:</p>\n		<p class=\"pageinput\">{$inputtitle}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$categorytext}:</p>\n		<p class=\"pageinput\">{$inputcategory}</p>\n	</div>\n{if !isset($hide_summary_field) or $hide_summary_field == 0}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$summarytext}:</p>\n		<p class=\"pageinput\">{$inputsummary}</p>\n	</div>\n{/if}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">*{$contenttext}:</p>\n		<p class=\"pageinput\">{$inputcontent}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$extratext}:</p>\n		<p class=\"pageinput\">{$inputextra}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$startdatetext}:</p>\n		<p class=\"pageinput\">{html_select_date prefix=$startdateprefix time=$startdate end_year=\"+15\"} {html_select_time prefix=$startdateprefix time=$startdate}</p>\n	</div>\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$enddatetext}:</p>\n		<p class=\"pageinput\">{html_select_date prefix=$enddateprefix time=$enddate end_year=\"+15\"} {html_select_time prefix=$enddateprefix time=$enddate}</p>\n	</div>\n	{if isset($customfields)}\n	   {foreach from=$customfields item=\'onefield\'}\n	      <div class=\"pageoverflow\">\n		<p class=\"pagetext\">{$onefield->name}:</p>\n		<p class=\"pageinput\">{$onefield->field}</p>\n	      </div>\n	   {/foreach}\n	{/if}\n	<div class=\"pageoverflow\">\n		<p class=\"pagetext\">&nbsp;</p>\n		<p class=\"pageinput\">{$hidden}{$submit}{$cancel}</p>\n	</div>\n{$endform}\n',NULL,NULL),('News_mapi_pref_current_form_template','Sample',NULL,NULL),('News_mapi_pref_default_browsecat_template_contents','{if $count > 0}\n<ul class=\"list1\">\n{foreach from=$cats item=node}\n{if $node.depth > $node.prevdepth}\n{repeat string=\"<ul>\" times=$node.depth-$node.prevdepth}\n{elseif $node.depth < $node.prevdepth}\n{repeat string=\"</li></ul>\" times=$node.prevdepth-$node.depth}\n</li>\n{elseif $node.index > 0}</li>\n{/if}\n<li class=\"newscategory\">\n{if $node.count > 0}\n	<a href=\"{$node.url}\">{$node.news_category_name}</a> ({$node.count}){else}<span>{$node.news_category_name} (0)</span>{/if}\n{/foreach}\n{repeat string=\"</li></ul>\" times=$node.depth-1}</li>\n</ul>\n{/if}',NULL,NULL),('News_mapi_pref_current_browsecat_template','Sample',NULL,NULL),('News_mapi_pref_email_subject','A new News article has been posted',NULL,NULL),('News_mapi_pref_allowed_upload_types','gif,png,jpeg,jpg',NULL,NULL),('News_mapi_pref_auto_create_thumbnails','gif,png,jpeg,jpg',NULL,NULL),('Printing_mapi_pref_overridestyle','/*\nYou can put css stuff here, which will be inserted in the header after calling the cmsms-stylesheets.\nProvided you don\'t remove the {$overridestylesheet} in PrintTemplate, of course.\n\nAny suggestions for default content in this stylesheet?\n\nHave fun!\n*/',NULL,NULL),('Search_mapi_pref_stopwords','i, me, my, myself, we, our, ours, ourselves, you, your, yours, \nyourself, yourselves, he, him, his, himself, she, her, hers, \nherself, it, its, itself, they, them, their, theirs, themselves, \nwhat, which, who, whom, this, that, these, those, am, is, are, \nwas, were, be, been, being, have, has, had, having, do, does, \ndid, doing, a, an, the, and, but, if, or, because, as, until, \nwhile, of, at, by, for, with, about, against, between, into, \nthrough, during, before, after, above, below, to, from, up, down, \nin, out, on, off, over, under, again, further, then, once, here, \nthere, when, where, why, how, all, any, both, each, few, more, \nmost, other, some, such, no, nor, not, only, own, same, so, \nthan, too, very',NULL,NULL),('Search_mapi_pref_usestemming','false',NULL,NULL),('Search_mapi_pref_searchtext','Enter Search...',NULL,NULL),('TinyMCE_mapi_pref_skin','default',NULL,NULL),('TinyMCE_mapi_pref_source_formatting','1',NULL,NULL),('TinyMCE_mapi_pref_showtogglebutton','1',NULL,NULL),('TinyMCE_mapi_pref_editor_width','800',NULL,NULL),('TinyMCE_mapi_pref_editor_width_auto','1',NULL,NULL),('TinyMCE_mapi_pref_editor_width_unit','',NULL,NULL),('TinyMCE_mapi_pref_editor_height','400',NULL,NULL),('TinyMCE_mapi_pref_editor_height_auto','1',NULL,NULL),('TinyMCE_mapi_pref_editor_height_unit','',NULL,NULL),('TinyMCE_mapi_pref_show_path','1',NULL,NULL),('TinyMCE_mapi_pref_striptags','false',NULL,NULL),('TinyMCE_mapi_pref_imagebrowserstyle','both',NULL,NULL),('TinyMCE_mapi_pref_allowupload','1',NULL,NULL),('TinyMCE_mapi_pref_filepickerstyle','both',NULL,NULL),('TinyMCE_mapi_pref_fpwidth','700',NULL,NULL),('TinyMCE_mapi_pref_fpheight','500',NULL,NULL),('TinyMCE_mapi_pref_toolbar1','cut,paste,pastetext,pasteword,copy,separator,justifyleft,justifycenter,justifyright,justifyfull,separator,styleselect,formatselect,fontselect,fontsizeselect',NULL,NULL),('TinyMCE_mapi_pref_toolbar2','bold,italic,underline,strikethrough,advhr,separator,bullist,numlist,separator,outdent,indent,separator,undo,redo,separator,customdropdown,cmslinker,link,unlink,anchor,image,charmap,cleanup,separator,forecolor,backcolor,separator,code,fullscreen,help',NULL,NULL),('TinyMCE_mapi_pref_allow_tables','0',NULL,NULL),('TinyMCE_mapi_pref_front_toolbar1','cut,paste,pastetext,pasteword,copy,separator,justifyleft,justifycenter,justifyright,justifyfull,separator,styleselect,formatselect,fontselect,fontsizeselect',NULL,NULL),('TinyMCE_mapi_pref_front_toolbar2','bold,italic,underline,strikethrough,advhr,separator,bullist,numlist,separator,outdent,indent,separator,undo,redo,separator,cmslinker,link,unlink,anchor,image,charmap,cleanup,separator,forecolor,backcolor,separator,code,fullscreen,help',NULL,NULL),('TinyMCE_mapi_pref_front_allow_tables','0',NULL,NULL),('TinyMCE_mapi_pref_plugins','paste,advimage,advlink,contextmenu,inlinepopups',NULL,NULL),('TinyMCE_mapi_pref_newlinestyle','p',NULL,NULL),('TinyMCE_mapi_pref_usecompression','0',NULL,NULL),('TinyMCE_mapi_pref_entityencoding','raw',NULL,NULL),('TinyMCE_mapi_pref_bodycss','',NULL,NULL),('TinyMCE_mapi_pref_forcedrootblock','false',NULL,NULL),('TinyMCE_mapi_pref_customdropdown','Start expand/collapse-area|{startExpandCollapse id=\\\'expand1\\\' title=\\\'This is my expandable area\\\'}\r\nEnd expand/collapse-area|{stopExpandCollapse}\r\n---|---\r\nInsert CMS version info|{cms_version} {cms_versionname}',NULL,NULL),('TinyMCE_mapi_pref_extraconfig','',NULL,NULL),('TinyMCE_mapi_pref_forcecleanpaste','1',NULL,NULL),('TinyMCE_mapi_pref_startenabled','1',NULL,NULL),('TinyMCE_mapi_pref_loadcmslinker','1',NULL,NULL),('TinyMCE_mapi_pref_cmslinkerstyle','1',NULL,NULL),('TinyMCE_mapi_pref_usestaticconfig','0',NULL,NULL),('TinyMCE_mapi_pref_dropdownblockformats','p,div,h1,h2,h3,h4,h5,h6,div,blockquote,dt,dd,code,samp',NULL,NULL),('global_umask','022',NULL,NULL),('frontendlang','',NULL,NULL),('cms_is_uptodate','0',NULL,NULL),('lastcmsversioncheck','1242878395',NULL,NULL),('TinyMCE_mapi_pref_dateformat','%Y-%m-%d',NULL,NULL),('TinyMCE_mapi_pref_timeformat','%H:%M:%S',NULL,NULL),('frontendwysiwyg','',NULL,NULL),('nogcbwysiwyg','0',NULL,NULL),('urlcheckversion','',NULL,NULL),('defaultdateformat','',NULL,NULL),('css_max_age','0',NULL,NULL),('disablesafemodewarning','0',NULL,NULL),('allowparamcheckwarnings','0',NULL,NULL),('enablenotifications','1',NULL,NULL);
/*!40000 ALTER TABLE `cms_siteprefs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_templates`
--

DROP TABLE IF EXISTS `cms_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_templates` (
  `template_id` int(11) NOT NULL,
  `template_name` varchar(160) DEFAULT NULL,
  `template_content` text,
  `stylesheet` text,
  `encoding` varchar(25) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `default_template` tinyint(4) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`template_id`),
  KEY `index_templates_by_template_name` (`template_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_templates`
--

LOCK TABLES `cms_templates` WRITE;
/*!40000 ALTER TABLE `cms_templates` DISABLE KEYS */;
INSERT INTO `cms_templates` VALUES (19,'Minimal template','{process_pagedata}\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n{* Change lang=\"en\" to the language of your site *}\r\n\r\n<head>\r\n\r\n<title>{sitename} - {title}</title>\r\n{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}\r\n\r\n{metadata}\r\n{* Don\'t remove this! Metadata is entered in Site Admin/Global settings. *}\r\n\r\n{stylesheet}\r\n{* This is how all the stylesheets attached to this template are linked to *}\r\n\r\n</head>\r\n\r\n<body>\r\n\r\n      {* Start Navigation *}\r\n      <div style=\"float: left; width: 25%;\">\r\n         {menu template=\'minimal_menu.tpl\'}\r\n      </div>\r\n      {* End Navigation *}\r\n\r\n      {* Start Content *}\r\n      <div>\r\n         <h2>{title}</h2>\r\n         {content} \r\n      </div>\r\n      {* End Content *}\r\n\r\n</body>\r\n</html>',NULL,NULL,1,0,'2006-07-25 21:22:33','2006-07-25 21:22:33'),(15,'CSSMenu left + 1 column','{process_pagedata}\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n{* Change lang=\"en\" to the language of your site *}\r\n\r\n<head>\r\n\r\n<title>{sitename} - {title}</title>\r\n{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}\r\n\r\n{metadata}\r\n{* Don\'t remove this! Metadata is entered in Site Admin/Global settings. *}\r\n\r\n{stylesheet}\r\n{* This is how all the stylesheets attached to this template are linked to *}\r\n\r\n{cms_selflink dir=\"start\" rellink=1}\r\n{cms_selflink dir=\"prev\" rellink=1}\r\n{cms_selflink dir=\"next\" rellink=1}\r\n{* Relational links for interconnections between pages, good for accessibility and Search Engine Optmization *}\r\n\r\n\r\n{literal}\r\n<script type=\"text/JavaScript\">\r\n<!--\r\n//pass min and max -measured against window width\r\nfunction P7_MinMaxW(a,b){\r\n	var nw=\"auto\",w=document.documentElement.clientWidth;\r\n	if(w>=b){nw=b+\"px\";}if(w<=a){nw=a+\"px\";}return nw;\r\n}\r\n//-->\r\n</script>\r\n<!--[if lte IE 6]>\r\n<style type=\"text/css\">\r\n#pagewrapper {width:expression(P7_MinMaxW(720,950));}\r\n#container {height: 1%;}\r\n</style>\r\n<![endif]-->\r\n{/literal}\r\n{* The min and max page width for Internet Explorer is set here. For other browsers it\'s in the stylesheet \"Layout: Left sidebar + 1 column\" *}\r\n\r\n\r\n<!--[if IE]>\r\n<script type=\"text/javascript\" src=\"modules/MenuManager/CSSMenu.js\"></script>\r\n<![endif]-->\r\n{* The above JavaScript is required for CSSMenu to work in IE *}\r\n\r\n</head>\r\n\r\n<body>\r\n<center><img src=\"images/pageheader.jpg\" alt=\"I want that smile - teeth whitening system\" /></center>\r\n<div id=\"pagewrapper\">\r\n   <div id=\"content\">\r\n      <div id=\"main\">\r\n<center>{global_content name=\'vicmenu\'}</center><br/><br/>\r\n         {content} <br />\r\n     </div>\r\n   </div>\r\n</div>\r\n<center><img src=\"images/pagefooter.jpg\" alt=\"I want that smile - teeth whitening system\"/></center>\r\n	{global_content name=\'footer\'}\r\n\r\n</body>\r\n</html>','','',1,0,'2006-07-25 21:22:33','2009-05-20 11:05:56'),(16,'CSSMenu top + 2 columns','{process_pagedata}\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n{* Change lang=\"en\" to the language of your site *}\r\n\r\n<head>\r\n\r\n<title>{sitename} - {title}</title>\r\n{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}\r\n\r\n{metadata}\r\n{* Don\'t remove this! Metadata is entered in Site Admin/Global settings. *}\r\n\r\n{stylesheet}\r\n{* This is how all the stylesheets attached to this template are linked to *}\r\n\r\n{cms_selflink dir=\"start\" rellink=1}\r\n{cms_selflink dir=\"prev\" rellink=1}\r\n{cms_selflink dir=\"next\" rellink=1}\r\n{* Relational links for interconnections between pages, good for accessibility and Search Engine Optmization *}\r\n\r\n\r\n{literal}\r\n<script type=\"text/JavaScript\">\r\n<!--\r\n//pass min and max -measured against window width\r\nfunction P7_MinMaxW(a,b){\r\n	var nw=\"auto\",w=document.documentElement.clientWidth;\r\n	if(w>=b){nw=b+\"px\";}if(w<=a){nw=a+\"px\";}return nw;\r\n}\r\n//-->\r\n</script>\r\n<!--[if lte IE 6]>\r\n<style type=\"text/css\">\r\n#pagewrapper {width:expression(P7_MinMaxW(720,950));}\r\n#container {height: 1%;}\r\n</style>\r\n<![endif]-->\r\n{/literal}\r\n{* The min and max page width for Internet Explorer is set here. For other browsers it\'s in the stylesheet \"Layout: Top menu + 2 columns\" *}\r\n\r\n\r\n<!--[if IE]>\r\n<script type=\"text/javascript\" src=\"modules/MenuManager/CSSMenu.js\"></script>\r\n<![endif]-->\r\n{* The above JavaScript is required for CSSMenu to work in IE *}\r\n\r\n</head>\r\n\r\n<body>\r\n<center><img src=\'images/pageheader.jpg\' alt=\"I want that smile - teeth whitening system\"/></center>\r\n<div id=\"pagewrapper\">\r\n   <div id=\"content\">\r\n\r\n      {* Start Sidebar *}\r\n      <div id=\"sidebar\" class=\"hascontent\">\r\n         {global_content name=\'vicmenu\'}<br/><br/>\r\n         {content block=\'Sidebar\'}\r\n      </div>\r\n      {* End Sidebar *}\r\n\r\n      {* Start Content Area *}\r\n      <div id=\"main\">\r\n         {content} <br />\r\n     <hr class=\"accessibility\" />\r\n      </div>\r\n	  {* End Content Area *}\r\n\r\n\r\n   </div>\r\n   {* End Content *}\r\n</div>{* end pagewrapper *}\r\n<center><img src=\"images/pagefooter.jpg\" alt=\"I want that smile - teeth whitening system\" /></center>\r\n	{global_content name=\'footer\'}\r\n</body>\r\n</html>','','',1,0,'2006-07-25 21:22:33','2009-05-20 11:05:56'),(17,'Left simple navigation + 1 column','{process_pagedata}\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n{* Change lang=\"en\" to the language of your site *}\r\n\r\n<head>\r\n\r\n<title>{sitename} - {title}</title>\r\n{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}\r\n\r\n{metadata}\r\n{* Don\'t remove this! Metadata is entered in Site Admin/Global settings. *}\r\n\r\n{stylesheet}\r\n{* This is how all the stylesheets attached to this template are linked to *}\r\n\r\n{cms_selflink dir=\"start\" rellink=1}\r\n{cms_selflink dir=\"prev\" rellink=1}\r\n{cms_selflink dir=\"next\" rellink=1}\r\n{* Relational links for interconnections between pages, good for accessibility and Search Engine Optmization *}\r\n\r\n\r\n{literal}\r\n<script type=\"text/JavaScript\">\r\n<!--\r\n//pass min and max -measured against window width\r\nfunction P7_MinMaxW(a,b){\r\n	var nw=\"auto\",w=document.documentElement.clientWidth;\r\n	if(w>=b){nw=b+\"px\";}if(w<=a){nw=a+\"px\";}return nw;\r\n}\r\n//-->\r\n</script>\r\n<!--[if lte IE 6]>\r\n<style type=\"text/css\">\r\n#pagewrapper {width:expression(P7_MinMaxW(720,950));}\r\n#container {height: 1%;}\r\n</style>\r\n<![endif]-->\r\n{/literal}\r\n{* The min and max page width for Internet Explorer is set here. For other browsers it\'s in the stylesheet \"Layout: Left sidebar + 1 column\" *}\r\n\r\n\r\n</head>\r\n\r\n<body>\r\n\r\n<div id=\"pagewrapper\">\r\n\r\n    {* start accessibility skip links *}\r\n    <ul class=\"accessibility\">\r\n      <li>{anchor anchor=\'menu_vert\' title=\'Skip to navigation\' accesskey=\'n\' text=\'Skip to navigation\'}</li>\r\n      <li>{anchor anchor=\'main\' title=\'Skip to content\' accesskey=\'s\' text=\'Skip to content\'}</li>\r\n    </ul>\r\n    {* end accessibility skip links *}\r\n\r\n\r\n    <hr class=\"accessibility\" />\r\n    {* Horizontal ruler that is hidden for visual browsers by CSS *}\r\n\r\n\r\n   {* Start Header, with logo image that links to the default start page. Logo image is changed in the stylesheet  \"For template: Left menu + 1 column\" *}\r\n   <div id=\"header\">\r\n           <h1>{cms_selflink dir=\"start\" text=\"$sitename\"}</h1>\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   {* End Header *}\r\n\r\n\r\n   {* Start Search *}\r\n   <div id=\"search\">\r\n          {search}\r\n   </div>\r\n   {* End Search *}\r\n\r\n\r\n   {* Start Breadcrumbs *}\r\n   <div class=\"breadcrumbs\">\r\n        {breadcrumbs starttext=\'You are here\' root=\'Home\' delimiter=\'&raquo;\'}\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   {* End Breadcrumbs *}\r\n\r\n\r\n   {* Start Content (Navigation and Content columns) *}\r\n   <div id=\"content\">\r\n\r\n      {* Start Sidebar *}\r\n      <div id=\"sidebar\">\r\n\r\n      {* Start Navigation *}\r\n      <div id=\"menu_vert\">\r\n         <h2 class=\"accessibility\">Navigation</h2>\r\n         {menu template=\'simple_navigation.tpl\' collapse=\'1\'}\r\n      </div>\r\n      {* End Navigation *}\r\n\r\n      {* Start News *}\r\n      <div id=\"news\">\r\n         <h2>News</h2>\r\n          {news number=\'3\' detailpage=\'news\'}\r\n      </div>\r\n      {* End News *}\r\n\r\n      </div>\r\n      {* End Sidebar *}\r\n\r\n\r\n      {* Start Content Area *}\r\n      <div id=\"main\">\r\n         <div style=\"float: right;\">{print showbutton=true script=true}</div>\r\n         <h2>{title}</h2>\r\n         {content} <br />\r\n\r\n         {* Start relational links *}\r\n	 <div class=\"hr\"></div>\r\n	 <div class=\"right49\">\r\n	 	<p>{anchor anchor=\'main\' text=\'^ Top\'}</p>\r\n	 </div>\r\n         <div class=\"left49\">\r\n            <p>{cms_selflink dir=\"previous\" label=\"Previous page: \"} <br />\r\n            {cms_selflink dir=\"next\"}</p>\r\n         </div>\r\n         {* The label parameter doesn\'t need to be there if you\'re using English, but is here to show how it\'s used if you don\'t want the English text \"Previous page\" *}\r\n	 {* End relational links *}\r\n\r\n      <hr class=\"accessibility\" />\r\n      </div>\r\n	  {* End Content Area *}\r\n\r\n\r\n   </div>\r\n   {* End Content *}\r\n\r\n\r\n   {* Start Footer. Edit the footer in the Global Content Block called \"footer\" *}\r\n   <div id=\"footer\">\r\n      {global_content name=\'footer\'}\r\n   </div>   \r\n   {* End Footer  *}\r\n\r\n\r\n</div>{* end pagewrapper *}\r\n</body>\r\n</html>',NULL,NULL,1,1,'2006-07-25 21:22:33','2008-12-10 12:55:24'),(18,'Top simple navigation + left subnavigation + 1 column','{process_pagedata}\r\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\r\n\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\r\n{* Change lang=\"en\" to the language of your site *}\r\n\r\n<head>\r\n\r\n<title>{sitename} - {title}</title>\r\n{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}\r\n\r\n{metadata}\r\n{* Don\'t remove this! Metadata is entered in Site Admin/Global settings. *}\r\n\r\n{stylesheet}\r\n{* This is how all the stylesheets attached to this template are linked to *}\r\n\r\n{cms_selflink dir=\"start\" rellink=1}\r\n{cms_selflink dir=\"prev\" rellink=1}\r\n{cms_selflink dir=\"next\" rellink=1}\r\n{* Relational links for interconnections between pages, good for accessibility and Search Engine Optmization *}\r\n\r\n\r\n\r\n{literal}\r\n<script type=\"text/JavaScript\">\r\n<!--\r\n//pass min and max -measured against window width\r\nfunction P7_MinMaxW(a,b){\r\n	var nw=\"auto\",w=document.documentElement.clientWidth;\r\n	if(w>=b){nw=b+\"px\";}if(w<=a){nw=a+\"px\";}return nw;\r\n}\r\n//-->\r\n</script>\r\n<!--[if lte IE 6]>\r\n<style type=\"text/css\">\r\n#pagewrapper {width:expression(P7_MinMaxW(720,950));}\r\n#container {height: 1%;}\r\n</style>\r\n<![endif]-->\r\n{/literal}\r\n{* The min and max page width for Internet Explorer is set here. For other browsers it\'s in the stylesheet \"Layout: Top menu + 2 columns\" *}\r\n\r\n\r\n</head>\r\n\r\n<body>\r\n\r\n<div id=\"pagewrapper\">\r\n\r\n    {* start accessibility skip links *}\r\n    <ul class=\"accessibility\">\r\n      <li>{anchor anchor=\'menu_vert\' title=\'Skip to navigation\' accesskey=\'n\' text=\'Skip to navigation\'}</li>\r\n      <li>{anchor anchor=\'main\' title=\'Skip to content\' accesskey=\'s\' text=\'Skip to content\'}</li>\r\n    </ul>\r\n    {* end accessibility skip links *}\r\n\r\n\r\n    <hr class=\"accessibility\" />\r\n    {* Horizontal ruler that is hidden for visual browsers by CSS *}\r\n\r\n\r\n   {* Start Header, with logo image that links to the default start page. Logo image is changed in the stylesheet  \"For template: Top menu + left submenu + 1 column\" *}\r\n   <div id=\"header\">\r\n           <h1>{cms_selflink dir=\"start\" text=\"$sitename\"}</h1>\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   {* End Header *}\r\n\r\n\r\n   {* Start Navigation *}\r\n   <div id=\"menu_horiz\">\r\n      <h2 class=\"accessibility\">Navigation</h2>\r\n      {menu template=\'simple_navigation.tpl\' number_of_levels=\'1\'}\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   {* End Navigation *}\r\n\r\n\r\n   {* Start Search *}\r\n   <div id=\"search\">\r\n          {search}\r\n   </div>\r\n   {* End Search *}\r\n\r\n   {* Start Breadcrumbs *}\r\n   <div class=\"breadcrumbs\">\r\n        {breadcrumbs starttext=\'You are here\' root=\'Home\' delimiter=\'&raquo;\'}\r\n   <hr class=\"accessibility\" />\r\n   </div>\r\n   {* End Breadcrumbs *}\r\n\r\n\r\n   {* Start Content (Navigation and Content columns) *}\r\n   <div id=\"content\">\r\n\r\n      {* Start Sidebar *}\r\n      <div id=\"sidebar\">\r\n\r\n      {* Start Sub Navigation *}\r\n      <div id=\"menu_vert\">\r\n         <h2 class=\"accessibility\">Sub Navigation</h2>\r\n\r\n          {* NB! The <ul><li> below is only added because several default templates use the same menu stylesheet, to \"force\" the subnavigation to act as if it\'s the second level in a list *}\r\n          <ul><li>{menu template=\'simple_navigation.tpl\' start_level=\'2\' collapse=\'1\'}</li></ul>\r\n      <hr class=\"accessibility\" />\r\n      </div>\r\n      {* End Sub Navigation *}\r\n\r\n      </div>\r\n      {* End Sidebar *}\r\n\r\n\r\n      {* Start Content Area *}\r\n      <div id=\"main\">\r\n         <div style=\"float: right;\">{print showbutton=true script=true}</div>\r\n         <h2>{title}</h2>\r\n         {content} <br />\r\n\r\n         {* Start relational links *}\r\n	 <div class=\"hr\"></div>\r\n	 <div class=\"right49\">\r\n	 	<p>{anchor anchor=\'main\' text=\'^ Top\'}</p>\r\n	 </div>\r\n         <div class=\"left49\">\r\n            <p>{cms_selflink dir=\"previous\" label=\"Previous page: \"} <br />\r\n            {cms_selflink dir=\"next\"}</p>\r\n         </div>\r\n         {* The label parameter doesn\'t need to be there if you\'re using English, but is here to show how it\'s used if you don\'t want the English text \"Previous page\" *}\r\n	 {* End relational links *}\r\n\r\n      <hr class=\"accessibility\" />\r\n      </div>\r\n	  {* End Content Area *}\r\n\r\n\r\n   </div>\r\n   {* End Content *}\r\n\r\n\r\n   {* Start Footer. Edit the footer in the Global Content Block called \"footer\" *}\r\n   <div id=\"footer\">\r\n      {global_content name=\'footer\'}\r\n   </div>   \r\n   {* End Footer  *}\r\n\r\n\r\n</div>{* end pagewrapper *}\r\n</body>\r\n</html>',NULL,NULL,1,0,'2006-07-25 21:22:33','2008-12-12 16:52:26');
/*!40000 ALTER TABLE `cms_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_templates_seq`
--

DROP TABLE IF EXISTS `cms_templates_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_templates_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_templates_seq`
--

LOCK TABLES `cms_templates_seq` WRITE;
/*!40000 ALTER TABLE `cms_templates_seq` DISABLE KEYS */;
INSERT INTO `cms_templates_seq` VALUES (19);
/*!40000 ALTER TABLE `cms_templates_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_user_groups`
--

DROP TABLE IF EXISTS `cms_user_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_user_groups` (
  `group_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_user_groups`
--

LOCK TABLES `cms_user_groups` WRITE;
/*!40000 ALTER TABLE `cms_user_groups` DISABLE KEYS */;
INSERT INTO `cms_user_groups` VALUES (1,1,'2006-07-25 21:22:33','2006-07-25 21:22:33');
/*!40000 ALTER TABLE `cms_user_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_userplugins`
--

DROP TABLE IF EXISTS `cms_userplugins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_userplugins` (
  `userplugin_id` int(11) NOT NULL,
  `userplugin_name` varchar(255) DEFAULT NULL,
  `code` text,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`userplugin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_userplugins`
--

LOCK TABLES `cms_userplugins` WRITE;
/*!40000 ALTER TABLE `cms_userplugins` DISABLE KEYS */;
INSERT INTO `cms_userplugins` VALUES (1,'user_agent','//Code to show the user\'s user agent information.\r\necho $_SERVER[\"HTTP_USER_AGENT\"];','2006-07-25 21:22:33','2006-07-25 21:22:33'),(2,'custom_copyright','//set start to date your site was published\r\n$startCopyRight=\'2005\';\r\n\r\n// check if start year is this year\r\nif(date(\'Y\') == $startCopyRight){\r\n// it was, just print this year\r\n    echo $startCopyRight;\r\n}else{\r\n// it wasnt, print startyear and this year delimited with a dash\r\n    echo $startCopyRight.\'-\'. date(\'Y\');\r\n}','2006-07-25 21:22:33','2009-05-20 11:05:27');
/*!40000 ALTER TABLE `cms_userplugins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_userplugins_seq`
--

DROP TABLE IF EXISTS `cms_userplugins_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_userplugins_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_userplugins_seq`
--

LOCK TABLES `cms_userplugins_seq` WRITE;
/*!40000 ALTER TABLE `cms_userplugins_seq` DISABLE KEYS */;
INSERT INTO `cms_userplugins_seq` VALUES (2);
/*!40000 ALTER TABLE `cms_userplugins_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_userprefs`
--

DROP TABLE IF EXISTS `cms_userprefs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_userprefs` (
  `user_id` int(11) DEFAULT NULL,
  `preference` varchar(50) DEFAULT NULL,
  `value` text,
  `type` varchar(25) DEFAULT NULL,
  KEY `index_userprefs_by_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_userprefs`
--

LOCK TABLES `cms_userprefs` WRITE;
/*!40000 ALTER TABLE `cms_userprefs` DISABLE KEYS */;
INSERT INTO `cms_userprefs` VALUES (1,'use_wysiwyg','1',NULL),(1,'wysiwyg','TinyMCE',NULL),(1,'default_cms_language','en_US',NULL),(1,'date_format_string','%x %X',NULL),(1,'admintheme','NCleanGrey',NULL),(1,'bookmarks','on',NULL),(1,'recent','on',NULL),(1,'indent','on',NULL),(1,'ajax','0',NULL),(1,'paging','0',NULL),(1,'collapse','',NULL),(1,'hide_help_links','0',NULL);
/*!40000 ALTER TABLE `cms_userprefs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_users`
--

DROP TABLE IF EXISTS `cms_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_users` (
  `user_id` int(11) NOT NULL,
  `username` varchar(25) DEFAULT NULL,
  `password` varchar(40) DEFAULT NULL,
  `admin_access` tinyint(4) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_users`
--

LOCK TABLES `cms_users` WRITE;
/*!40000 ALTER TABLE `cms_users` DISABLE KEYS */;
INSERT INTO `cms_users` VALUES (1,'admin','d2fc6b335a0df626aee582be89809cbd',1,'Admin','User','victor@expetecnj.com',1,'2006-07-25 21:22:33','2006-07-25 21:22:33');
/*!40000 ALTER TABLE `cms_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_users_seq`
--

DROP TABLE IF EXISTS `cms_users_seq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_users_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_users_seq`
--

LOCK TABLES `cms_users_seq` WRITE;
/*!40000 ALTER TABLE `cms_users_seq` DISABLE KEYS */;
INSERT INTO `cms_users_seq` VALUES (1);
/*!40000 ALTER TABLE `cms_users_seq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_version`
--

DROP TABLE IF EXISTS `cms_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_version` (
  `version` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_version`
--

LOCK TABLES `cms_version` WRITE;
/*!40000 ALTER TABLE `cms_version` DISABLE KEYS */;
INSERT INTO `cms_version` VALUES (31);
/*!40000 ALTER TABLE `cms_version` 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 2011-04-20 15:58:51

