# phpMyAdmin SQL Dump # version 2.5.5-pl1 # http://www.phpmyadmin.net # # Host: localhost # Generation Time: Jan 27, 2004 at 01:53 PM # Server version: 3.23.47 # PHP Version: 4.1.1 # # Database : `sitestrux_3` # # -------------------------------------------------------- # # Table structure for table `admingroups` # CREATE TABLE `admingroups` ( `groupID` int(11) NOT NULL auto_increment, `groupName` varchar(50) NOT NULL default '', `groupDesc` text, `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`groupID`), UNIQUE KEY `groupID` (`groupID`), KEY `groupID_2` (`groupID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `admingroups` # INSERT INTO `admingroups` VALUES (1, 'Everything', 'All Managers and more and more', 1); INSERT INTO `admingroups` VALUES (2, 'Files', 'Just Files', 1); # -------------------------------------------------------- # # Table structure for table `adminpages` # CREATE TABLE `adminpages` ( `apID` int(11) NOT NULL auto_increment, `apType` varchar(50) NOT NULL default '', `pages` text, `apCreate` tinyint(1) NOT NULL default '0', `apSubPages` tinyint(1) NOT NULL default '0', `apDelete` tinyint(1) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', PRIMARY KEY (`apID`), UNIQUE KEY `apID` (`apID`), KEY `apID_2` (`apID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `adminpages` # INSERT INTO `adminpages` VALUES (1, 'all', '0', 0, 0, 0, 3); INSERT INTO `adminpages` VALUES (2, 'some', '7,47,48,29,54,', 1, 1, 1, 4); # -------------------------------------------------------- # # Table structure for table `adminrights` # CREATE TABLE `adminrights` ( `arID` int(11) NOT NULL auto_increment, `f_adminID` int(11) NOT NULL default '0', `f_groupID` int(11) NOT NULL default '0', PRIMARY KEY (`arID`), UNIQUE KEY `arID` (`arID`), KEY `arID_2` (`arID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `adminrights` # INSERT INTO `adminrights` VALUES (1, 4, 1); # -------------------------------------------------------- # # Table structure for table `admins` # CREATE TABLE `admins` ( `adminID` int(11) NOT NULL auto_increment, `adminEmail` varchar(100) NOT NULL default '', `adminPassword` varchar(25) NOT NULL default '', `adminFname` varchar(50) NOT NULL default '', `adminLname` varchar(50) NOT NULL default '', `adminNname` varchar(50) default NULL, `adminType` varchar(50) NOT NULL default 'Admin', `adminDate` tinyint(3) unsigned NOT NULL default '0', `adminStart` int(15) default NULL, `adminEnd` int(15) default NULL, `adminSince` int(11) NOT NULL default '0', `adminActive` tinyint(3) unsigned NOT NULL default '1', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`adminID`), UNIQUE KEY `adminID` (`adminID`), KEY `adminID_2` (`adminID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `admins` # INSERT INTO `admins` VALUES (2, 'info@sitestrux.com', 'ofniss', 'Site', 'Strux', 'SiteStrux', 'super', 0, 0, 0, 1011759182, 1, 1); INSERT INTO `admins` VALUES (1, 'rbg@50units.com', 'rabdoog', 'b', 'g', 'bg', 'super', 0, 0, 0, 1005194716, 1, 2); INSERT INTO `admins` VALUES (3, 'demo@sitestrux.com', 'demo', 'Demo', 'Guest', 'demo', 'super', 0, NULL, NULL, 1042072140, 1, 1); INSERT INTO `admins` VALUES (4, 'test@sitestrux.com', 'test', 'test', 'test', 'test', 'admin', 0, NULL, NULL, 1049588700, 1, 1); # -------------------------------------------------------- # # Table structure for table `articlegroups` # CREATE TABLE `articlegroups` ( `agID` int(10) unsigned NOT NULL auto_increment, `agName` varchar(255) default NULL, `agTitle` varchar(255) default NULL, `agDesc` text, `agShow` tinyint(3) unsigned NOT NULL default '1', `agSort` int(4) NOT NULL default '0', `agStart` int(11) default NULL, `agEnd` int(11) default NULL, `f_adminID` int(11) default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`agID`), UNIQUE KEY `agID` (`agID`), KEY `agID_2` (`agID`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; # # Dumping data for table `articlegroups` # INSERT INTO `articlegroups` VALUES (10, 'How to build a website', 'How to build a website', 'This group of articles will describe how to build a website. This is the group description.', 1, 0, NULL, NULL, 2, 59, 1); # -------------------------------------------------------- # # Table structure for table `articlepages` # CREATE TABLE `articlepages` ( `apID` int(10) unsigned NOT NULL auto_increment, `apName` tinytext NOT NULL, `apTitle` tinytext NOT NULL, `apHead` varchar(50) NOT NULL default '', `apBody` longtext NOT NULL, `apShow` tinyint(3) unsigned NOT NULL default '1', `apSort` int(11) NOT NULL default '0', `f_imgBodyID` int(12) NOT NULL default '0', `f_artID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`apID`), UNIQUE KEY `apID` (`apID`), KEY `apID_2` (`apID`) ) TYPE=MyISAM AUTO_INCREMENT=11 ; # # Dumping data for table `articlepages` # INSERT INTO `articlepages` VALUES (8, 'Page 2', 'Page 2', '', 'test', 1, 2, 0, 7, 1); INSERT INTO `articlepages` VALUES (9, 'Target', 'Finding the Target', 'Find the Target Head', 'The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. \r\n\r\nThe first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. \r\n\r\nThe first thing you need to do is find a target. The first thing you need to do is find a target. ', 1, 1, 68, 9, 1); INSERT INTO `articlepages` VALUES (7, 'Page 1', 'Page 1', '', 'Test', 1, 1, 0, 7, 1); INSERT INTO `articlepages` VALUES (10, 'Hook', 'Hook the Target', '', 'After you\\\'ve found your target, you need to convince them that you have the product they need.', 1, 2, 0, 9, 1); # -------------------------------------------------------- # # Table structure for table `articles` # CREATE TABLE `articles` ( `artID` int(10) unsigned NOT NULL auto_increment, `artName` tinytext NOT NULL, `artTitle` tinytext NOT NULL, `artAuthor` varchar(100) default NULL, `artEmail` varchar(100) default NULL, `artDate` int(11) default '0', `artDesc` text, `artIntro` text, `artSort` int(11) NOT NULL default '0', `artShow` tinyint(3) unsigned NOT NULL default '1', `f_agID` int(10) unsigned NOT NULL default '0', `f_adminID` int(10) unsigned NOT NULL default '0', `f_clientID` int(12) default NULL, PRIMARY KEY (`artID`), KEY `artID` (`artID`) ) TYPE=MyISAM AUTO_INCREMENT=10 ; # # Dumping data for table `articles` # INSERT INTO `articles` VALUES (7, 'Php Magic', 'Php Magic', '', '', 1069563600, '', '', 1, 1, 5, 2, 1); INSERT INTO `articles` VALUES (9, 'Selling a website', 'Selling a website', 'Brandon Griggs', 'rbg@50units.com', 1072587600, 'This is the article description. This article will tell you how to sell a website.', 'Selling a website is not easy. You need to convince people of lots of stuff.', 1, 1, 10, 2, 1); # -------------------------------------------------------- # # Table structure for table `block_groups` # CREATE TABLE `block_groups` ( `bgID` int(11) NOT NULL auto_increment, `bgName` varchar(255) NOT NULL default '', `bgTitle` varchar(255) default NULL, `bgDesc` text, `bgShow` tinyint(4) NOT NULL default '1', `bgLocation` varchar(50) NOT NULL default 'main', `bgPageType` varchar(50) NOT NULL default 'some', `bgDisplay` varchar(50) NOT NULL default 'rows', `bgColumns` int(11) NOT NULL default '0', `f_pageID` varchar(255) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`bgID`), UNIQUE KEY `bgID` (`bgID`), KEY `bgID_2` (`bgID`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; # # Dumping data for table `block_groups` # INSERT INTO `block_groups` VALUES (9, 'Block Group', 'Block Group Title', 'This bg is on one page and in the main body.', 1, 'body', 'some', 'rows', 0, '2,', 2, 1); INSERT INTO `block_groups` VALUES (10, 'test', '', '', 1, 'body', 'some', 'rows', 0, '59,', 2, 1); INSERT INTO `block_groups` VALUES (11, 'test', '', '', 1, 'body', 'some', 'rows', 0, '60,', 2, 1); INSERT INTO `block_groups` VALUES (12, 'Columns', '', '', 1, 'body', 'some', 'columns', 2, '63,', 2, 1); # -------------------------------------------------------- # # Table structure for table `block_links` # CREATE TABLE `block_links` ( `blID` int(11) NOT NULL auto_increment, `blName` varchar(255) NOT NULL default '', `blType` varchar(50) NOT NULL default 'url', `blUrl` text, `blDesc` text, `blPop` tinyint(1) NOT NULL default '0', `blShow` tinyint(4) NOT NULL default '1', `blSort` int(11) NOT NULL default '0', `f_pageID` int(11) default '0', `f_blockID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`blID`), UNIQUE KEY `blID` (`blID`), KEY `blID_2` (`blID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `block_links` # INSERT INTO `block_links` VALUES (4, 'Test Link', 'url', 'http://www.50units.com', 'this is the description', 1, 1, 1, NULL, 11, 1); # -------------------------------------------------------- # # Table structure for table `block_lists` # CREATE TABLE `block_lists` ( `blID` int(11) NOT NULL auto_increment, `blName` varchar(255) NOT NULL default '', `blDesc` text, `blShow` tinyint(4) NOT NULL default '1', `blSort` int(11) NOT NULL default '0', `f_blockID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`blID`), UNIQUE KEY `blID` (`blID`), KEY `blID_2` (`blID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `block_lists` # INSERT INTO `block_lists` VALUES (1, 'Test', 'test', 1, 1, 12, 1); # -------------------------------------------------------- # # Table structure for table `block_pages` # CREATE TABLE `block_pages` ( `bpID` int(11) NOT NULL auto_increment, `bpSub` varchar(255) default NULL, `bpBody` text, `f_imgHeadID` int(12) NOT NULL default '0', `f_imgBodyID` int(12) NOT NULL default '0', `f_blockID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`bpID`), UNIQUE KEY `bpID` (`bpID`), KEY `bpID_2` (`bpID`) ) TYPE=MyISAM AUTO_INCREMENT=16 ; # # Dumping data for table `block_pages` # INSERT INTO `block_pages` VALUES (9, 'test', 'test', 0, 0, 10, 1); INSERT INTO `block_pages` VALUES (10, NULL, NULL, 0, 0, 12, 1); INSERT INTO `block_pages` VALUES (8, NULL, NULL, 0, 0, 9, 1); INSERT INTO `block_pages` VALUES (11, 'Part 1: A test', 'This is a test of the body', 0, 73, 13, 1); INSERT INTO `block_pages` VALUES (12, NULL, NULL, 0, 0, 14, 1); INSERT INTO `block_pages` VALUES (13, NULL, NULL, 0, 0, 15, 1); INSERT INTO `block_pages` VALUES (14, '', 'This is the body.\r\nTHis is the body.\r\nThis is the body.', 0, 0, 16, 1); INSERT INTO `block_pages` VALUES (15, '', 'This is block 2', 0, 0, 17, 1); # -------------------------------------------------------- # # Table structure for table `blocks` # CREATE TABLE `blocks` ( `blockID` int(11) NOT NULL auto_increment, `blockName` varchar(255) default NULL, `blockTitle` varchar(255) default NULL, `blockDesc` text NOT NULL, `blockType` varchar(50) NOT NULL default 'page', `blockShow` tinyint(4) NOT NULL default '1', `blockSort` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_ID` int(12) NOT NULL default '0', `f_modID` int(12) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`blockID`), UNIQUE KEY `blockID` (`blockID`), KEY `blockID_2` (`blockID`) ) TYPE=MyISAM AUTO_INCREMENT=18 ; # # Dumping data for table `blocks` # INSERT INTO `blocks` VALUES (9, 'test', '', 'This is a news block', 'page', 1, 1, 2, 3, 19, 1); INSERT INTO `blocks` VALUES (6, 'Block', 'Block', '', 'page', 1, 1, 2, 8, 13, 1); INSERT INTO `blocks` VALUES (10, 'Page Block', 'Page Block', '', 'page', 1, 1, 2, 9, 13, 1); INSERT INTO `blocks` VALUES (11, 'Link Block', 'Link Block', '', 'links', 1, 2, 2, 9, 13, 1); INSERT INTO `blocks` VALUES (12, 'List Block', 'List Block', 'This is the list block description', 'list', 1, 3, 2, 9, 13, 1); INSERT INTO `blocks` VALUES (13, 'Block Name', '', '', 'page', 1, 1, 2, 4, 19, 1); INSERT INTO `blocks` VALUES (14, 'test', '', '', 'page', 1, 1, 2, 20, 17, 1); INSERT INTO `blocks` VALUES (15, 'test', '', '', 'page', 1, 4, 2, 9, 13, 1); INSERT INTO `blocks` VALUES (16, 'test', 'test', 'tests', 'page', 1, 1, 2, 12, 13, 1); INSERT INTO `blocks` VALUES (17, 'Block 2', 'Block 2', '', 'page', 1, 2, 2, 12, 13, 1); # -------------------------------------------------------- # # Table structure for table `blogentries` # CREATE TABLE `blogentries` ( `beID` int(11) NOT NULL auto_increment, `beName` tinytext NOT NULL, `beHead` tinytext, `beEntry` text NOT NULL, `beShow` tinyint(1) unsigned NOT NULL default '1', `beDate` int(11) NOT NULL default '0', `f_imgBodyID` int(12) default NULL, `f_blogID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`beID`), UNIQUE KEY `beID` (`beID`), KEY `beID_2` (`beID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `blogentries` # INSERT INTO `blogentries` VALUES (4, 'Intro', '', 'This is the entry.', 1, 1072727700, NULL, 11, 2, 1); INSERT INTO `blogentries` VALUES (6, 'Old Entry', '', 'This is an old entry, eh?', 1, 1067461740, NULL, 11, 2, 1); # -------------------------------------------------------- # # Table structure for table `blogformat` # CREATE TABLE `blogformat` ( `bfID` int(11) NOT NULL auto_increment, `bfDate` tinyint(1) unsigned NOT NULL default '1', `bfTime` tinyint(1) unsigned NOT NULL default '1', `bfDateFormat` text, `bfAuthor` tinyint(1) unsigned NOT NULL default '1', `bfArchives` tinyint(1) unsigned NOT NULL default '1', `bfNumber` int(11) NOT NULL default '5', `bfLink` tinyint(3) unsigned default '0', `f_blogID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`bfID`), UNIQUE KEY `bfID` (`bfID`), KEY `bfID_2` (`bfID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `blogformat` # INSERT INTO `blogformat` VALUES (2, 1, 1, NULL, 1, 1, 5, 0, 12, 1); # -------------------------------------------------------- # # Table structure for table `blogs` # CREATE TABLE `blogs` ( `blogID` int(11) NOT NULL auto_increment, `blogName` tinytext NOT NULL, `blogShow` tinyint(1) unsigned NOT NULL default '1', `blogTitle` tinytext, `blogDesc` text NOT NULL, `blogLocation` varchar(50) NOT NULL default 'body', `f_pageID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`blogID`), UNIQUE KEY `blogID` (`blogID`), KEY `blogID_2` (`blogID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; # # Dumping data for table `blogs` # INSERT INTO `blogs` VALUES (12, 'test', 1, '', '', 'body', 60, 2, 1); # -------------------------------------------------------- # # Table structure for table `calendar_categories` # CREATE TABLE `calendar_categories` ( `ccID` int(11) NOT NULL auto_increment, `ccName` varchar(255) NOT NULL default '', `ccShow` tinyint(1) NOT NULL default '1', `ccSort` int(11) NOT NULL default '1', `f_calID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`ccID`), UNIQUE KEY `fiID` (`ccID`), KEY `fiID_2` (`ccID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `calendar_categories` # # -------------------------------------------------------- # # Table structure for table `calendar_repeat` # CREATE TABLE `calendar_repeat` ( `repeatID` int(11) NOT NULL auto_increment, `repeatName` varchar(50) NOT NULL default '', PRIMARY KEY (`repeatID`), UNIQUE KEY `repeatID` (`repeatID`), KEY `repeatID_2` (`repeatID`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; # # Dumping data for table `calendar_repeat` # INSERT INTO `calendar_repeat` VALUES (1, 'None'); INSERT INTO `calendar_repeat` VALUES (2, 'Daily'); INSERT INTO `calendar_repeat` VALUES (3, 'Weekly'); INSERT INTO `calendar_repeat` VALUES (4, 'Bi-Weekly'); INSERT INTO `calendar_repeat` VALUES (5, 'Monthly by day of week'); INSERT INTO `calendar_repeat` VALUES (6, 'Monthly by day of month'); INSERT INTO `calendar_repeat` VALUES (7, 'Yearly by day of week'); INSERT INTO `calendar_repeat` VALUES (8, 'Yearly by day of month'); # -------------------------------------------------------- # # Table structure for table `calendar_sharing` # CREATE TABLE `calendar_sharing` ( `csID` int(12) NOT NULL auto_increment, `f_parentID` int(12) NOT NULL default '0', `f_childID` int(12) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`csID`), UNIQUE KEY `csID` (`csID`), KEY `csID_2` (`csID`) ) TYPE=MyISAM AUTO_INCREMENT=11 ; # # Dumping data for table `calendar_sharing` # INSERT INTO `calendar_sharing` VALUES (10, 10, 9, 1); # -------------------------------------------------------- # # Table structure for table `calendarentries` # CREATE TABLE `calendarentries` ( `ceID` int(11) NOT NULL auto_increment, `ceDate` int(11) NOT NULL default '0', `ceDateEnd` int(11) NOT NULL default '0', `ceDateExclude` text, `ceTimeFrom` int(11) default NULL, `ceTimeTo` int(11) default NULL, `ceHead` varchar(100) NOT NULL default '', `ceSub` varchar(100) NOT NULL default '', `ceEntry` text NOT NULL, `ceShow` int(10) unsigned NOT NULL default '0', `ceGlobal` tinyint(1) NOT NULL default '0', `f_repeatID` int(11) NOT NULL default '1', `f_ccID` text NOT NULL, `f_adminID` int(11) NOT NULL default '0', `f_calID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`ceID`), UNIQUE KEY `ceID` (`ceID`), KEY `ceID_2` (`ceID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `calendarentries` # INSERT INTO `calendarentries` VALUES (2, 1072740480, 0, '', 1072740480, 0, 'Header', '', 'This is the entry', 1, 1, 1, '', 2, 9, 1); INSERT INTO `calendarentries` VALUES (3, 1071260940, 0, '', 1071260940, 0, 'Test', '', 'Test', 1, 1, 1, '', 2, 9, 1); INSERT INTO `calendarentries` VALUES (4, 1070495100, 1070667900, '', 1070495100, 0, 'Original Header', '', 'Original Entry', 1, 1, 2, '', 2, 9, 1); INSERT INTO `calendarentries` VALUES (5, 1072656060, 0, '', 1072656060, 0, 'multi entry', '', 'multi entry', 1, 0, 1, '', 2, 10, 1); INSERT INTO `calendarentries` VALUES (6, 1072829700, 0, '', 1072829700, 0, 'Local Entry', '', 'Local Entry', 1, 0, 1, '', 2, 9, 1); # -------------------------------------------------------- # # Table structure for table `calendarformat` # CREATE TABLE `calendarformat` ( `cfID` int(11) NOT NULL auto_increment, `cfView` varchar(50) default 'day', `cfSize` varchar(50) NOT NULL default 'small', `cfFixed` tinyint(3) unsigned NOT NULL default '0', `cfDefault` int(11) default NULL, `cfPrintable` tinyint(3) unsigned NOT NULL default '0', `cfQuickNav` tinyint(3) unsigned NOT NULL default '0', `cfCategories` tinyint(1) NOT NULL default '0', `cfGlobal` tinyint(1) NOT NULL default '0', `f_calID` int(11) NOT NULL default '0', `f_clientID` varchar(12) NOT NULL default '', PRIMARY KEY (`cfID`), UNIQUE KEY `cfID` (`cfID`), KEY `cfID_2` (`cfID`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; # # Dumping data for table `calendarformat` # INSERT INTO `calendarformat` VALUES (10, 'month', 'large', 0, NULL, 0, 1, 0, 1, 10, '1'); INSERT INTO `calendarformat` VALUES (9, 'month', 'small', 0, NULL, 0, 1, 0, 1, 9, '1'); INSERT INTO `calendarformat` VALUES (11, 'day', 'small', 0, NULL, 0, 0, 0, 0, 11, '1'); # -------------------------------------------------------- # # Table structure for table `calendars` # CREATE TABLE `calendars` ( `calID` int(11) NOT NULL auto_increment, `calName` varchar(50) NOT NULL default '', `calTitle` varchar(50) default NULL, `calDesc` text NOT NULL, `calShow` tinyint(3) unsigned NOT NULL default '0', `f_adminID` int(12) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`calID`), UNIQUE KEY `calID` (`calID`), KEY `calID_2` (`calID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; # # Dumping data for table `calendars` # INSERT INTO `calendars` VALUES (10, 'Mutli Calendar', 'Multi Calendar', 'test', 1, 2, 62, 1); INSERT INTO `calendars` VALUES (9, 'Calendar Events', 'Calendar Events', 'This is a Calendar', 1, 2, 61, 1); INSERT INTO `calendars` VALUES (11, 'Calendar', 'Title', '', 1, 2, 72, 1); # -------------------------------------------------------- # # Table structure for table `cat_catalogs` # CREATE TABLE `cat_catalogs` ( `catID` int(11) NOT NULL auto_increment, `catName` varchar(255) NOT NULL default '', `catTitle` varchar(255) default NULL, `catRef` varchar(255) default NULL, `catDesc` text, `catSearch` tinyint(1) NOT NULL default '1', `catInventory` tinyint(1) NOT NULL default '0', `catSortable` tinyint(1) NOT NULL default '1', `catLimit` int(4) NOT NULL default '0', `catDisplay` varchar(50) NOT NULL default 'row', `catColumns` tinyint(9) NOT NULL default '0', `catShow` tinyint(1) NOT NULL default '1', `f_adminID` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`catID`), UNIQUE KEY `formID` (`catID`), KEY `formID_2` (`catID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `cat_catalogs` # INSERT INTO `cat_catalogs` VALUES (4, 'Furniture', 'Furniture', NULL, 'Lots of furniture.', 1, 1, 1, 4, 'columns', 2, 1, 2, 29, 1); INSERT INTO `cat_catalogs` VALUES (5, 'Animals', 'Animals', NULL, 'Catalog', 1, 0, 1, 0, 'row', 0, 1, 2, 76, 1); # -------------------------------------------------------- # # Table structure for table `cat_itemblocks` # CREATE TABLE `cat_itemblocks` ( `iblockID` int(11) NOT NULL auto_increment, `iblockName` varchar(255) NOT NULL default '', `iblockTitle` varchar(255) default NULL, `iblockRef` varchar(255) default NULL, `iblockDesc` text, `iblockShow` tinyint(1) NOT NULL default '1', `iblockSort` int(11) NOT NULL default '1', `iblockImage` varchar(255) NOT NULL default '', `iblockImageShow` tinyint(1) NOT NULL default '1', `iblockImageAlign` varchar(10) NOT NULL default 'left', `iblockImageHead` varchar(255) NOT NULL default '', `iblockImageHeadShow` tinyint(1) NOT NULL default '1', `iblockImageHeadAlign` varchar(10) NOT NULL default 'left', `f_catID` int(11) NOT NULL default '0', `f_itemID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`iblockID`), UNIQUE KEY `formID` (`iblockID`), KEY `formID_2` (`iblockID`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; # # Dumping data for table `cat_itemblocks` # INSERT INTO `cat_itemblocks` VALUES (6, 'test', 'test', NULL, NULL, 1, 1, '', 1, 'left', '', 1, 'left', 4, 7, 1); INSERT INTO `cat_itemblocks` VALUES (4, 'Finish', 'Finish', NULL, '', 1, 1, 'sohoMirror_finish.jpg', 1, 'left', 'sohoMirror_finishThumb.jpg', 1, 'left', 4, 8, 1); INSERT INTO `cat_itemblocks` VALUES (8, 'test', 'test', NULL, NULL, 1, 1, 'mayfair_extra.jpg', 1, 'left', 'mayfair_extra.jpg', 1, 'left', 4, 13, 1); # -------------------------------------------------------- # # Table structure for table `cat_items` # CREATE TABLE `cat_items` ( `itemID` int(11) NOT NULL auto_increment, `itemName` varchar(255) NOT NULL default '', `itemTitle` varchar(255) default NULL, `itemRef` varchar(255) default NULL, `itemDesc` text, `itemBody` text, `itemPrice` double NOT NULL default '0', `itemPriceFeatured` double NOT NULL default '0', `itemFeatured` tinyint(4) NOT NULL default '0', `itemInventory` int(11) NOT NULL default '0', `itemWeight` double NOT NULL default '0', `itemShow` tinyint(1) NOT NULL default '1', `itemSort` int(11) NOT NULL default '1', `f_imgBodyID` int(12) NOT NULL default '0', `f_imgPreviewID` int(12) NOT NULL default '0', `f_catID` int(11) NOT NULL default '0', `f_levelID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`itemID`), UNIQUE KEY `formID` (`itemID`), KEY `formID_2` (`itemID`) ) TYPE=MyISAM AUTO_INCREMENT=21 ; # # Dumping data for table `cat_items` # INSERT INTO `cat_items` VALUES (13, 'Mayfair', 'Mayfair', NULL, 'Mayfair', 'Collection: Mayfair \r\nPiece: King Bed \r\nStyle Family: Traditional \r\nMaterial: Oak \r\nFinish: Medium Oak \r\n', '1100', '900', 0, 11, '4', 1, 1, 0, 0, 4, 9, 1); INSERT INTO `cat_items` VALUES (14, 'Hutch', 'Hutch', NULL, 'The Hutch is great', 'The Hutch is great', '600', '0', 0, 0, '88', 1, 1, 0, 0, 4, 8, 1); INSERT INTO `cat_items` VALUES (15, 'Bed 2', 'Bed 2', NULL, 'Bed 2', 'Bed 2', '0', '0', 0, 0, '0', 1, 2, 0, 0, 4, 9, 1); INSERT INTO `cat_items` VALUES (16, 'Bed 3', 'Bed 3', NULL, 'Bed 3', 'Bed 3', '66', '55', 1, 0, '0', 1, 3, 0, 0, 4, 9, 1); INSERT INTO `cat_items` VALUES (17, 'Bed 4', 'Bed 4', NULL, 'Bed 4', 'Bed 4', '0', '0', 0, 0, '0', 1, 4, 0, 0, 4, 9, 1); INSERT INTO `cat_items` VALUES (18, 'Bed 5', 'Bed 5', NULL, 'Bed 5', 'Bed 5', '0', '0', 0, 0, '0', 1, 5, 0, 0, 4, 9, 1); INSERT INTO `cat_items` VALUES (19, 'Bed 6', 'Bed 6', NULL, 'Bed 6', 'Bed 6', '44', '42', 1, 0, '0', 1, 6, 0, 0, 4, 9, 1); INSERT INTO `cat_items` VALUES (20, 'Vulture', 'Vultures', NULL, '', 'This is the body of the item.', '0', '0', 1, 0, '0', 1, 1, 0, 0, 5, 2, 1); # -------------------------------------------------------- # # Table structure for table `cat_levels` # CREATE TABLE `cat_levels` ( `levelID` int(11) NOT NULL auto_increment, `levelName` varchar(255) NOT NULL default '', `levelTitle` varchar(255) default NULL, `levelRef` varchar(255) default NULL, `levelDesc` text NOT NULL, `levelShow` tinyint(1) NOT NULL default '1', `levelSort` int(11) NOT NULL default '1', `f_imgBodyID` int(12) NOT NULL default '0', `f_imgPreviewID` int(12) NOT NULL default '0', `f_catID` int(11) NOT NULL default '0', `f_levelID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`levelID`), UNIQUE KEY `formID` (`levelID`), KEY `formID_2` (`levelID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `cat_levels` # INSERT INTO `cat_levels` VALUES (1, 'Mammals', 'Mammals', NULL, 'This is the description', 1, 2, 0, 0, 5, 0, 1); INSERT INTO `cat_levels` VALUES (2, 'Birds', 'Birds', NULL, '', 1, 1, 74, 75, 5, 0, 1); INSERT INTO `cat_levels` VALUES (3, 'Dogs', 'Dogs', NULL, '', 1, 1, 0, 0, 5, 1, 1); # -------------------------------------------------------- # # Table structure for table `cat_optiongroups` # CREATE TABLE `cat_optiongroups` ( `opgroupID` int(11) NOT NULL auto_increment, `opgroupName` varchar(255) NOT NULL default '', `opgroupTitle` varchar(255) default NULL, `opgroupRef` varchar(255) default NULL, `opgroupDesc` text, `opgroupShow` tinyint(1) NOT NULL default '1', `opgroupSort` int(11) NOT NULL default '1', `f_catID` int(11) NOT NULL default '0', `f_itemID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`opgroupID`), UNIQUE KEY `formID` (`opgroupID`), KEY `formID_2` (`opgroupID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `cat_optiongroups` # INSERT INTO `cat_optiongroups` VALUES (1, 'Colors', 'Colors', NULL, 'test1', 1, 2, 4, 14, 1); INSERT INTO `cat_optiongroups` VALUES (3, 'Species', 'Species', NULL, '', 1, 1, 5, 20, 1); # -------------------------------------------------------- # # Table structure for table `cat_options` # CREATE TABLE `cat_options` ( `optionID` int(11) NOT NULL auto_increment, `optionName` varchar(255) NOT NULL default '', `optionTitle` varchar(255) default NULL, `optionRef` varchar(255) default NULL, `optionDesc` text, `optionShow` tinyint(1) NOT NULL default '1', `optionSort` int(11) NOT NULL default '1', `f_opgroupID` int(12) NOT NULL default '0', `f_catID` int(11) NOT NULL default '0', `f_itemID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`optionID`), UNIQUE KEY `formID` (`optionID`), KEY `formID_2` (`optionID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `cat_options` # INSERT INTO `cat_options` VALUES (4, 'Green on White', '', NULL, '', 1, 1, 1, 4, 14, 1); # -------------------------------------------------------- # # Table structure for table `clients` # CREATE TABLE `clients` ( `clientID` int(11) NOT NULL auto_increment, `clientName` varchar(100) NOT NULL default '', `clientUser` varchar(255) default NULL, `clientPass` varchar(255) default NULL, `clientEmail` varchar(255) NOT NULL default '', `clientUrl` varchar(255) NOT NULL default '', `clientFTP` varchar(255) default NULL, `firstEntered` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`clientID`), UNIQUE KEY `clientID` (`clientID`), KEY `clientID_2` (`clientID`) ) TYPE=MyISAM AUTO_INCREMENT=33 ; # # Dumping data for table `clients` # INSERT INTO `clients` VALUES (1, 'SiteStrux', 'strux', 'ssss09', 'info@sitestrux.com', 'http://www.sitestrux.com', 'www.sitestrux.com', 1010169600, 1); INSERT INTO `clients` VALUES (2, '50units', 'sstrux', 'xurtss', 'rbg@50units.com', 'http://www.50units.com', 'www.50units.com', 1010169600, 1); INSERT INTO `clients` VALUES (3, 'The Jawbone', 'jawbone', 'ssjb03', 'andrew@thejawbone.com', 'http://www.thejawbone.com', 'www.thejawbone.com', 1015498140, 1); INSERT INTO `clients` VALUES (4, 'Hope Family Ministry', 'hfm', 'xurts200', 'priscabob@yahoo.com', 'http://www.hopefamilyministry.com', 'www.hopefamilyministry.com', 1015498140, 1); INSERT INTO `clients` VALUES (5, 'BerneseMD', 'bernese', 'ssbm07', 'nate@bernesemd.com', 'http://www.bernesemd.com', 'www.bernesemd.com', 1015498140, 1); INSERT INTO `clients` VALUES (6, 'Sara K Martin', 'sarakmd', 'sssm06', 'sara@sarakmartin.com', 'http://www.sarakmartin.com', 'www.sarakmartin.com', 1015494140, 1); INSERT INTO `clients` VALUES (7, 'Spooks', NULL, NULL, '', '', NULL, 1015504140, 1); INSERT INTO `clients` VALUES (8, 'DemoLand', 'strux', 'ssss09', 'info@sitestrux.com', 'http://www.sitestrux.com/demoland', NULL, 1015504140, 1); INSERT INTO `clients` VALUES (9, 'DerekLand.com', NULL, NULL, '', '', NULL, 1015504140, 1); INSERT INTO `clients` VALUES (10, 'TimothyPNG', 'timpng', 'sstp08', 'reason12@juno.com', 'http://www.timothypng.com', 'www.timothypng.com', 1015594140, 1); INSERT INTO `clients` VALUES (11, 'First United', 'fumc', 'ssfu11', 'hank@deemer.com', 'http://www.fumclancasterpa.com', 'www.fumclancasterpa.com', 1015594140, 1); INSERT INTO `clients` VALUES (12, 'atrio-inc.com', 'atrio', 'ssat13', 'mew@atrio-inc.com', 'http://www.atrio-inc.com', NULL, 1015594140, 1); INSERT INTO `clients` VALUES (13, 'Atrio Extranet', 'atrio', 'ssat13', 'mew@atrio-inc.com', 'http://www.atrio-inc.com/extranet', NULL, 1015594140, 1); INSERT INTO `clients` VALUES (14, 'SiteStrux Demo', NULL, NULL, '', '', NULL, 1015594140, 1); INSERT INTO `clients` VALUES (15, 'Landis Woods', 'artshow', 'sslw16', 'res@atrio-inc.com', 'http://www.landiswoodsartshow.com', NULL, 1015594140, 1); INSERT INTO `clients` VALUES (16, 'Lancaster Aluminum', NULL, NULL, '', '', NULL, 1015594140, 1); INSERT INTO `clients` VALUES (17, 'The AutoButler', 'autobtlr', 'ssab05', 'travis@theautobutler.com', 'http://www.theautobutler.com', 'www.theautobutler.com', 1115594140, 1); INSERT INTO `clients` VALUES (18, 'Atrio Support', 'atrio', 'ssat13', 'mew@atrio-inc.com', 'http://www.atrio-inc.com/support', NULL, 1115594140, 1); INSERT INTO `clients` VALUES (19, 'SiteStrux Extranet', NULL, NULL, '', '', NULL, 1115594140, 1); INSERT INTO `clients` VALUES (20, 'LightHouse Baptist Church', NULL, NULL, '', '', NULL, 1115594140, 1); INSERT INTO `clients` VALUES (21, 'DJ Freez', 'djfrz', 'ssdj10', 'dj@djfreez.com', 'http://www.djfreez.com', 'www.djfreez.com', 1115594140, 1); INSERT INTO `clients` VALUES (22, 'typeface.org', 'typeface', 'sstf04', 'andy@typeface.org', 'http://www.typeface.org', 'www.typeface.org', 1115594140, 1); INSERT INTO `clients` VALUES (24, 'AliZubik', 'jawbone', 'ssjb03', 'andrew@thejawbone.com', 'http://www.thejawbone.com', NULL, 0, 1); INSERT INTO `clients` VALUES (23, 'presentation', NULL, NULL, '', '', NULL, 0, 1); INSERT INTO `clients` VALUES (25, 'ChurchStrux', 'churchs', 'sscs19', 'info@sitestrux.com', 'http://www.churchstrux.com', 'www.churchstrux.com', 0, 1); INSERT INTO `clients` VALUES (26, 'Ryan Miller', 'rmill', 'ssrm17', 'ryan@millersnowboards.com', 'http://www.millersnowboards.com', 'www.millersnowboards.com', 0, 1); INSERT INTO `clients` VALUES (27, 'Ruthies Tee Co', 'rteeco', 'ssrt18', 'info@ruthiesteeco.com', 'http://www.ruthiesteeco.com', 'www.ruthiesteeco.com', 0, 1); INSERT INTO `clients` VALUES (28, 'The Leffews', 'leffews', 'sstl22', 'leffewk@gsicommerce.com', 'www.theleffews.com', NULL, 1044596040, 1); INSERT INTO `clients` VALUES (29, 'The Leffews', 'leffews', 'sstl22', 'leffewk@gsicommerce.com', 'www.theleffews.com', NULL, 1044596040, 1); INSERT INTO `clients` VALUES (30, 'The Leffews', 'leffews', 'sstl22', 'leffewk@gsicommerce.com', 'www.theleffews.com', NULL, 1044596160, 1); INSERT INTO `clients` VALUES (31, 'The Leffews', 'leffews', 'sstl22', 'leffewk@gsicommerce.com', 'www.theleffews.com', NULL, 1044596160, 1); INSERT INTO `clients` VALUES (32, 'The Leffews', 'leffews', 'sstl22', 'leffewk@gsicommerce.com', 'www.theleffews.com', NULL, 1044596340, 1); # -------------------------------------------------------- # # Table structure for table `contact_thanks` # CREATE TABLE `contact_thanks` ( `ctID` int(11) NOT NULL auto_increment, `ctHead` varchar(255) default NULL, `ctThanks` text, `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`ctID`), UNIQUE KEY `ctID` (`ctID`), KEY `ctID_2` (`ctID`,`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `contact_thanks` # INSERT INTO `contact_thanks` VALUES (1, 'Thanks', 'Thanks', 1); # -------------------------------------------------------- # # Table structure for table `contactdata` # CREATE TABLE `contactdata` ( `formID` int(11) NOT NULL auto_increment, `formName` varchar(50) NOT NULL default '', `formEmail` varchar(100) NOT NULL default '', `formMessage` text NOT NULL, `f_contactID` int(11) NOT NULL default '0', `formDate` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`formID`), UNIQUE KEY `formID` (`formID`), KEY `formID_2` (`formID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=10 ; # # Dumping data for table `contactdata` # INSERT INTO `contactdata` VALUES (1, 'test', 'test@test.com', 'test', 1, 1050536220, 1); INSERT INTO `contactdata` VALUES (2, 'Brandon Griggs', 'brandon@sitestrux.com', 'test', 1, 1050536280, 1); INSERT INTO `contactdata` VALUES (3, 'Brandon Griggs', 'brandon@sitestrux.com', 'test', 1, 1050536400, 1); INSERT INTO `contactdata` VALUES (4, 'Brandon Griggs', 'andy@sitestrux.com', 'test', 1, 1050536400, 1); INSERT INTO `contactdata` VALUES (5, 'test', 'rbg@50units.com', 'test', 1, 1051898820, 1); INSERT INTO `contactdata` VALUES (6, 'test', 'rbg@50units.com', 'test', 1, 1074501540, 1); INSERT INTO `contactdata` VALUES (7, 'Brandon', 'rbg@50units.com', 'Another test', 2, 1074501600, 1); INSERT INTO `contactdata` VALUES (8, 'test', 'rbg@50units.com', 'sales', 1, 1074501720, 1); INSERT INTO `contactdata` VALUES (9, 'test', 'rbg@50units.com', 'sales', 1, 1074501840, 1); # -------------------------------------------------------- # # Table structure for table `contactforms` # CREATE TABLE `contactforms` ( `contactID` int(11) NOT NULL auto_increment, `contactName` varchar(50) NOT NULL default '', `contactEmail` varchar(50) NOT NULL default '', `contactShow` int(11) NOT NULL default '1', `contactSort` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`contactID`), UNIQUE KEY `contactID` (`contactID`), KEY `contactID_2` (`contactID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `contactforms` # INSERT INTO `contactforms` VALUES (1, 'Sales', 'rbg@50units.com', 1, 1, 1); INSERT INTO `contactforms` VALUES (2, 'Technical', 'info@sitestrux.com', 1, 2, 1); # -------------------------------------------------------- # # Table structure for table `content` # CREATE TABLE `content` ( `contentID` int(11) NOT NULL auto_increment, `contentName` varchar(100) default NULL, `contentScript` varchar(255) NOT NULL default '', `contentSort` int(11) NOT NULL default '0', `contentLocation` varchar(50) default 'body', `f_pageID` int(11) NOT NULL default '0', `f_modID` int(11) NOT NULL default '0', `f_ID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`contentID`), UNIQUE KEY `contentID` (`contentID`), KEY `contentID_2` (`contentID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=279 ; # # Dumping data for table `content` # INSERT INTO `content` VALUES (143, 'Content Block Group- Block Group', 'blocks/act_placeBlock.php', 1, 'body', 2, 13, 9, 1); INSERT INTO `content` VALUES (139, 'Blog- test', 'blogs/act_placeBlog.php', 1, 'body', 60, 5, 12, 1); INSERT INTO `content` VALUES (138, 'Content Block Group- test', 'blocks/act_placeBlock.php', 2, 'body', 60, 13, 11, 1); INSERT INTO `content` VALUES (2, 'Contact Form', 'contact/frm_contact.php', 1, 'body', 3, 4, 1, 1); INSERT INTO `content` VALUES (116, 'PageBlock- Copy Block', 'pages/act_placeBlock.php', 1, 'body', 55, 21, 44, 1); INSERT INTO `content` VALUES (117, 'PageBlock- Block 2', 'pages/act_placeBlock.php', 2, 'body', 55, 21, 45, 1); INSERT INTO `content` VALUES (118, 'Article Group- How to build a website', 'articles/act_placeArticle.php', 1, 'body', 59, 6, 10, 1); INSERT INTO `content` VALUES (277, 'Content Block Group- Columns', 'blocks/act_placeBlock.php', 1, 'body', 63, 13, 12, 1); INSERT INTO `content` VALUES (120, 'Calendar- Calendar Events', 'calendars/act_placeCalendar.php', 1, 'body', 61, 9, 9, 1); INSERT INTO `content` VALUES (121, 'Calendar- Mutli Calendar', 'calendars/act_placeCalendar.php', 1, 'body', 62, 9, 10, 1); INSERT INTO `content` VALUES (123, 'Display Gallery- Image Gallery', 'displays/act_placeDisplay.php', 1, 'body', 64, 7, 5, 1); INSERT INTO `content` VALUES (124, 'FAQ Group- FAQ Name', 'faqs/act_placeFaq.php', 1, 'body', 65, 15, 1, 1); INSERT INTO `content` VALUES (278, 'Search Form- test', 'search/act_placeSearch.php', 1, 'body', 73, 14, 4, 1); INSERT INTO `content` VALUES (126, 'Form- Form', 'forms/act_placeForm.php', 1, 'body', 68, 16, 6, 1); INSERT INTO `content` VALUES (128, 'Message Board- Message Board', 'msgboards/act_placeMsgBoard.php', 1, 'body', 70, 12, 4, 1); INSERT INTO `content` VALUES (129, 'News Group- News', 'news/act_placeNews.php', 1, 'body', 71, 19, 3, 1); INSERT INTO `content` VALUES (130, 'Poll- Survey Poll', 'polls/act_placePoll.php', 1, 'body', 72, 20, 2, 1); INSERT INTO `content` VALUES (134, 'Catalog- Animals', 'catalogs/act_placeCatalog.php', 1, 'body', 76, 17, 5, 1); INSERT INTO `content` VALUES (135, 'Calendar- Calendar', 'calendars/act_placeCalendar.php', 2, 'body', 72, 9, 11, 1); INSERT INTO `content` VALUES (1, 'Site Index', 'siteindex/dsp_siteIndex.php', 1, 'body', 1, 1, 1, 1); # -------------------------------------------------------- # # Table structure for table `content_allpages` # CREATE TABLE `content_allpages` ( `contentID` int(11) NOT NULL auto_increment, `contentName` varchar(100) default NULL, `contentScript` varchar(255) NOT NULL default '', `contentSort` int(11) NOT NULL default '0', `contentLocation` varchar(50) default 'body', `f_pageID` int(11) NOT NULL default '0', `f_modID` int(11) NOT NULL default '0', `f_ID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`contentID`), UNIQUE KEY `contentID` (`contentID`), KEY `contentID_2` (`contentID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; # # Dumping data for table `content_allpages` # # -------------------------------------------------------- # # Table structure for table `displayformat` # CREATE TABLE `displayformat` ( `dfID` int(11) NOT NULL auto_increment, `dfThumbs` tinyint(3) unsigned NOT NULL default '0', `dfDisplay` varchar(50) NOT NULL default 'row', `dfColumns` int(11) default '0', `dfNumber` int(11) default NULL, `dfDate` tinyint(3) unsigned NOT NULL default '0', `f_dgID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`dfID`), UNIQUE KEY `dfID` (`dfID`), KEY `dfID_2` (`dfID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `displayformat` # INSERT INTO `displayformat` VALUES (5, 0, 'columns', 2, 1, 0, 5, 1); # -------------------------------------------------------- # # Table structure for table `displaygroups` # CREATE TABLE `displaygroups` ( `dgID` int(11) NOT NULL auto_increment, `dgName` varchar(50) default NULL, `dgTitle` varchar(255) default NULL, `dgDesc` text, `dgShow` tinyint(3) unsigned NOT NULL default '1', `f_pageID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`dgID`), UNIQUE KEY `dgID` (`dgID`), KEY `dgID_2` (`dgID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `displaygroups` # INSERT INTO `displaygroups` VALUES (5, 'Image Gallery', 'Image Gallery', 'This is an image gallery', 1, 64, 2, 1); # -------------------------------------------------------- # # Table structure for table `displays` # CREATE TABLE `displays` ( `disID` int(11) NOT NULL auto_increment, `disName` varchar(50) NOT NULL default '', `disTitle` varchar(50) NOT NULL default '', `disDesc` text, `disShow` tinyint(3) unsigned NOT NULL default '1', `disSort` int(11) NOT NULL default '0', `f_imgBodyID` int(12) NOT NULL default '0', `f_dgID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`disID`), UNIQUE KEY `disID` (`disID`), KEY `disID_2` (`disID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `displays` # INSERT INTO `displays` VALUES (4, 'Number 2', 'Number 2', 'Another Description', 1, 2, 71, 5, 2, 1); INSERT INTO `displays` VALUES (3, 'Test', 'Test', 'Test Description', 1, 1, 70, 5, 2, 1); INSERT INTO `displays` VALUES (5, 'test3', '', '', 1, 3, 72, 5, 2, 1); # -------------------------------------------------------- # # Table structure for table `ecom_orderitems` # CREATE TABLE `ecom_orderitems` ( `oiID` int(12) NOT NULL auto_increment, `oiName` text NOT NULL, `oiNumber` varchar(50) NOT NULL default '', `oiPrice` double NOT NULL default '0', `oiQuantity` int(12) NOT NULL default '0', `f_orderID` int(12) NOT NULL default '0', `f_itemID` int(12) NOT NULL default '0', `f_ecomID` int(12) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`oiID`), UNIQUE KEY `oiID` (`oiID`), KEY `oiID_2` (`oiID`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; # # Dumping data for table `ecom_orderitems` # INSERT INTO `ecom_orderitems` VALUES (1, '', '', '900', 1, 4, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (2, '', '', '900', 1, 5, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (3, '', '', '900', 1, 6, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (4, '', '', '900', 1, 7, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (5, '', '', '900', 1, 8, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (6, '', '', '900', 1, 9, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (7, '', '', '900', 1, 10, 13, 1, 1); INSERT INTO `ecom_orderitems` VALUES (8, '', '', '900', 1, 11, 13, 1, 1); # -------------------------------------------------------- # # Table structure for table `ecom_orders` # CREATE TABLE `ecom_orders` ( `orderID` int(12) NOT NULL auto_increment, `orderRef` varchar(255) NOT NULL default '', `orderSubTotal` double NOT NULL default '0', `orderShipping` double NOT NULL default '0', `orderTaxes` double NOT NULL default '0', `orderTotal` double NOT NULL default '0', `orderShipType` varchar(255) NOT NULL default '', `orderDate` int(12) NOT NULL default '0', `f_userID` int(12) NOT NULL default '0', `f_ecomID` int(12) NOT NULL default '0', `f_shippingID` int(12) NOT NULL default '0', `f_billingID` int(12) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`orderID`), UNIQUE KEY `orderID` (`orderID`), KEY `orderID_2` (`orderID`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; # # Dumping data for table `ecom_orders` # INSERT INTO `ecom_orders` VALUES (7, '', '900', '0', '54', '954', 'none', 1050536520, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (6, '', '900', '0', '54', '954', 'none', 1050536160, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (5, '', '900', '0', '54', '954', 'none', 1050536100, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (4, '', '900', '0', '54', '954', 'none', 1050534960, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (8, '', '900', '0', '54', '954', 'none', 1050536580, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (9, '', '900', '0', '54', '954', 'none', 1050536640, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (10, '', '900', '0', '54', '954', 'none', 1050537060, 1, 1, 7, 7, 1); INSERT INTO `ecom_orders` VALUES (11, '', '900', '0', '54', '954', 'none', 1050537060, 1, 1, 7, 7, 1); # -------------------------------------------------------- # # Table structure for table `ecom_shipmatrix` # CREATE TABLE `ecom_shipmatrix` ( `matrixID` int(11) NOT NULL auto_increment, `matrixFee` double NOT NULL default '0', `matrixLow` double NOT NULL default '0', `matrixHigh` double NOT NULL default '0', `f_shipID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`matrixID`), UNIQUE KEY `matrixID` (`matrixID`), KEY `matrixID_2` (`matrixID`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; # # Dumping data for table `ecom_shipmatrix` # INSERT INTO `ecom_shipmatrix` VALUES (1, '2.46', '0.01', '5', 4, 1); INSERT INTO `ecom_shipmatrix` VALUES (2, '2.46', '5.01', '25', 4, 1); INSERT INTO `ecom_shipmatrix` VALUES (3, '4.46', '25.01', '100', 4, 1); INSERT INTO `ecom_shipmatrix` VALUES (5, '4.55', '0.01', '10000', 1, 1); INSERT INTO `ecom_shipmatrix` VALUES (6, '1.99', '0.01', '10000', 2, 1); INSERT INTO `ecom_shipmatrix` VALUES (7, '6.46', '100.01', '100000', 4, 1); # -------------------------------------------------------- # # Table structure for table `ecom_shipping` # CREATE TABLE `ecom_shipping` ( `shipID` int(11) NOT NULL auto_increment, `shipName` varchar(255) NOT NULL default '', `shipFlatFee` double NOT NULL default '0', `shipTotalFee` double NOT NULL default '0', `shipShow` tinyint(1) NOT NULL default '1', `shipSort` int(11) NOT NULL default '0', `f_ecomID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`shipID`), UNIQUE KEY `shipID` (`shipID`), KEY `shipID_2` (`shipID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `ecom_shipping` # INSERT INTO `ecom_shipping` VALUES (1, 'UPS Ground', '4.75', '0.05', 1, 1, 1, 1); INSERT INTO `ecom_shipping` VALUES (2, 'USPS', '5.25', '0.01', 1, 1, 1, 1); INSERT INTO `ecom_shipping` VALUES (4, 'FedEx', '5.55', '0.08', 1, 1, 1, 1); # -------------------------------------------------------- # # Table structure for table `ecom_shiptypes` # CREATE TABLE `ecom_shiptypes` ( `shipTypeID` int(11) NOT NULL auto_increment, `shipTypeTitle` varchar(255) NOT NULL default '', PRIMARY KEY (`shipTypeID`), UNIQUE KEY `shipTypeID` (`shipTypeID`), KEY `shipTypeID_2` (`shipTypeID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `ecom_shiptypes` # INSERT INTO `ecom_shiptypes` VALUES (1, 'None'); INSERT INTO `ecom_shiptypes` VALUES (2, 'Flat Fee'); INSERT INTO `ecom_shiptypes` VALUES (3, 'Flat Flee + Weight Fee'); INSERT INTO `ecom_shiptypes` VALUES (4, 'Percentage of Total'); INSERT INTO `ecom_shiptypes` VALUES (5, 'Price Matrix'); INSERT INTO `ecom_shiptypes` VALUES (6, 'Weight Matrix'); # -------------------------------------------------------- # # Table structure for table `ecom_systems` # CREATE TABLE `ecom_systems` ( `ecomID` int(11) NOT NULL auto_increment, `ecomName` varchar(255) NOT NULL default '', `ecomTitle` varchar(255) default NULL, `ecomEmails` varchar(255) NOT NULL default '', `ecomRef` varchar(255) default NULL, `ecomDesc` text, `ecomThanks` text NOT NULL, `ecomShow` tinyint(1) NOT NULL default '1', `f_shipTypeID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_catID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`ecomID`), UNIQUE KEY `formID` (`ecomID`), KEY `formID_2` (`ecomID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `ecom_systems` # INSERT INTO `ecom_systems` VALUES (1, 'test2', NULL, 'rbg@50units.com, test@test.com', NULL, NULL, 'Thanks for your order.', 0, 1, 2, 4, 1); # -------------------------------------------------------- # # Table structure for table `ecom_taxes` # CREATE TABLE `ecom_taxes` ( `taxID` int(12) NOT NULL auto_increment, `taxRate` double NOT NULL default '0', `taxShipping` tinyint(1) NOT NULL default '0', `taxShow` tinyint(1) NOT NULL default '1', `f_stateID` int(12) NOT NULL default '0', `f_ecomID` int(12) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`taxID`), UNIQUE KEY `taxID` (`taxID`), KEY `taxID_2` (`taxID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `ecom_taxes` # INSERT INTO `ecom_taxes` VALUES (1, '0.06', 0, 1, 39, 1, 1); # -------------------------------------------------------- # # Table structure for table `faq_faq` # CREATE TABLE `faq_faq` ( `faqID` int(11) NOT NULL auto_increment, `faqName` varchar(255) NOT NULL default '0', `faqDesc` varchar(255) default '0', `faqIntro` varchar(255) default '0', `faqShow` int(1) NOT NULL default '1', `faqSort` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_fgID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`faqID`), KEY `faqID_2` (`faqID`) ) TYPE=MyISAM AUTO_INCREMENT=81 ; # # Dumping data for table `faq_faq` # INSERT INTO `faq_faq` VALUES (80, 'What is a website', 'This FAQ answers common questions concerning the Web Site.', 'This is the introduction the FAQ about websites', 1, 1, 2, 1, 1); # -------------------------------------------------------- # # Table structure for table `faq_groups` # CREATE TABLE `faq_groups` ( `fgID` int(11) NOT NULL auto_increment, `fgName` text NOT NULL, `fgTitle` text, `fgDesc` text, `fgShow` tinyint(1) NOT NULL default '1', `f_adminID` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`fgID`), UNIQUE KEY `fgID` (`fgID`), KEY `fgID_2` (`fgID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `faq_groups` # INSERT INTO `faq_groups` VALUES (1, 'Faq', NULL, NULL, 1, 2, 65, 1); # -------------------------------------------------------- # # Table structure for table `faq_questions` # CREATE TABLE `faq_questions` ( `fqID` int(11) NOT NULL auto_increment, `fqQuestion` text NOT NULL, `fqAnswer` text NOT NULL, `fqShow` tinyint(1) NOT NULL default '1', `fqSort` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_faqID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`fqID`), UNIQUE KEY `fqID` (`fqID`), KEY `fqID_2` (`fqID`) ) TYPE=MyISAM AUTO_INCREMENT=328 ; # # Dumping data for table `faq_questions` # INSERT INTO `faq_questions` VALUES (327, 'What is a website', 'A website is a permanent location on the Internet.', 1, 1, 0, 80, 1); # -------------------------------------------------------- # # Table structure for table `file_format` # CREATE TABLE `file_format` ( `ffID` int(11) NOT NULL auto_increment, `ffName` tinyint(1) unsigned NOT NULL default '1', `ffSize` tinyint(1) unsigned NOT NULL default '1', `ffNumber` int(11) NOT NULL default '5', `f_fgID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`ffID`), UNIQUE KEY `bfID` (`ffID`), KEY `bfID_2` (`ffID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `file_format` # # -------------------------------------------------------- # # Table structure for table `file_stats` # CREATE TABLE `file_stats` ( `fsID` int(11) NOT NULL auto_increment, `fsDate` int(11) NOT NULL default '0', `f_fileID` int(11) NOT NULL default '0', PRIMARY KEY (`fsID`), UNIQUE KEY `fsID` (`fsID`), KEY `fsID_2` (`fsID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `file_stats` # # -------------------------------------------------------- # # Table structure for table `filegroups` # CREATE TABLE `filegroups` ( `fgID` int(11) NOT NULL auto_increment, `fgName` varchar(255) NOT NULL default '', `fgTitle` varchar(255) default NULL, `fgDesc` text, `fgShow` tinyint(4) NOT NULL default '1', `f_pageID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`fgID`), UNIQUE KEY `fgID` (`fgID`), KEY `fgID_2` (`fgID`,`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `filegroups` # INSERT INTO `filegroups` VALUES (4, 'Files', 'Files', 'This is a file group. Download at will.', 1, 66, 2, 1); # -------------------------------------------------------- # # Table structure for table `files` # CREATE TABLE `files` ( `fileID` int(11) NOT NULL auto_increment, `fileName` varchar(255) NOT NULL default '', `fileFile` varchar(255) NOT NULL default '', `fileDesc` text, `fileType` char(3) default NULL, `fileShow` tinyint(3) unsigned NOT NULL default '1', `fileSort` int(11) NOT NULL default '0', `f_fgID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`fileID`), UNIQUE KEY `fileID` (`fileID`), KEY `fileID_2` (`fileID`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; # # Dumping data for table `files` # # -------------------------------------------------------- # # Table structure for table `form_groups` # CREATE TABLE `form_groups` ( `formID` int(11) NOT NULL auto_increment, `formName` varchar(255) NOT NULL default '', `formTitle` varchar(255) default NULL, `formEmails` varchar(255) NOT NULL default '', `formRef` varchar(255) default NULL, `formDesc` text, `formThanks` text NOT NULL, `formShow` tinyint(1) NOT NULL default '1', `f_adminID` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`formID`), UNIQUE KEY `formID` (`formID`), KEY `formID_2` (`formID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `form_groups` # INSERT INTO `form_groups` VALUES (6, 'Form', 'Form', 'rbg@50units.com', NULL, '', 'Thanks for submitting', 1, 2, 68, 1); # -------------------------------------------------------- # # Table structure for table `form_inputs` # CREATE TABLE `form_inputs` ( `fiID` int(11) NOT NULL auto_increment, `fiName` varchar(255) NOT NULL default '', `fiTitle` varchar(255) NOT NULL default '', `fiDesc` text NOT NULL, `fiRequire` tinyint(1) NOT NULL default '1', `fiValidate` varchar(50) default NULL, `fiShow` tinyint(1) NOT NULL default '1', `fiSort` int(11) NOT NULL default '1', `f_typeID` int(11) NOT NULL default '0', `f_formID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`fiID`), UNIQUE KEY `fiID` (`fiID`), KEY `fiID_2` (`fiID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `form_inputs` # INSERT INTO `form_inputs` VALUES (4, 'Name', 'Name', '', 1, NULL, 1, 1, 5, 6, 1); INSERT INTO `form_inputs` VALUES (5, 'Occupation', 'Occupation', '', 0, NULL, 1, 2, 3, 6, 1); # -------------------------------------------------------- # # Table structure for table `form_submissions` # CREATE TABLE `form_submissions` ( `subID` int(11) NOT NULL auto_increment, `subSubmission` text NOT NULL, `subDate` int(11) NOT NULL default '0', `f_formID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`subID`), UNIQUE KEY `subID` (`subID`), KEY `subID_2` (`subID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `form_submissions` # INSERT INTO `form_submissions` VALUES (1, 'The following form was submitted from SiteStrux on 12/31/03\n\n - found - Name: Brandon Griggs\n\n - found - Occupation: Three\n\n', 1072918800, 6, 1); INSERT INTO `form_submissions` VALUES (2, 'The form Form was submitted from SiteStrux on 12/31/03\n\nName: Brandon Griggs\n\nOccupation: off\n\n', 1072919220, 6, 1); # -------------------------------------------------------- # # Table structure for table `form_types` # CREATE TABLE `form_types` ( `typeID` int(11) NOT NULL auto_increment, `typeName` varchar(255) NOT NULL default '', `typeMulti` tinyint(4) NOT NULL default '0', PRIMARY KEY (`typeID`), UNIQUE KEY `typeID` (`typeID`), KEY `typeID_2` (`typeID`) ) TYPE=MyISAM AUTO_INCREMENT=9 ; # # Dumping data for table `form_types` # INSERT INTO `form_types` VALUES (1, 'Check Box', 0); INSERT INTO `form_types` VALUES (2, 'Radio Button', 1); INSERT INTO `form_types` VALUES (3, 'Select Box', 1); INSERT INTO `form_types` VALUES (4, 'Text Area', 0); INSERT INTO `form_types` VALUES (5, 'Text Input- Long', 0); INSERT INTO `form_types` VALUES (6, 'Text Input- Short', 0); INSERT INTO `form_types` VALUES (7, 'Text Input- Medium', 0); INSERT INTO `form_types` VALUES (8, 'HTML Block', 0); # -------------------------------------------------------- # # Table structure for table `form_values` # CREATE TABLE `form_values` ( `fvID` int(11) NOT NULL auto_increment, `fvName` varchar(255) NOT NULL default '', `fvShow` tinyint(1) NOT NULL default '1', `fvSort` int(11) NOT NULL default '1', `f_fiID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`fvID`), UNIQUE KEY `fvID` (`fvID`), KEY `fvID_2` (`fvID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `form_values` # INSERT INTO `form_values` VALUES (6, 'Three', 1, 3, 5, 1); INSERT INTO `form_values` VALUES (5, 'Two', 1, 2, 5, 1); INSERT INTO `form_values` VALUES (4, 'One', 1, 1, 5, 1); # -------------------------------------------------------- # # Table structure for table `image_content` # CREATE TABLE `image_content` ( `icID` int(12) NOT NULL auto_increment, `icName` varchar(255) NOT NULL default '', `icShow` tinyint(1) NOT NULL default '1', `icAlign` varchar(12) NOT NULL default 'left', `icLinkType` varchar(15) NOT NULL default 'none', `icLinkUrl` varchar(255) NOT NULL default '', `icLinkImage` varchar(255) NOT NULL default '', `icCaption` text NOT NULL, `icAlt` varchar(255) NOT NULL default '', `f_imgID` int(12) NOT NULL default '0', `f_linkImgID` int(12) NOT NULL default '0', `f_modID` int(12) NOT NULL default '0', `f_ID` int(12) NOT NULL default '0', `f_ref` varchar(25) NOT NULL default '', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`icID`), UNIQUE KEY `icID` (`icID`), KEY `icID_2` (`icID`) ) TYPE=MyISAM AUTO_INCREMENT=79 ; # # Dumping data for table `image_content` # INSERT INTO `image_content` VALUES (21, 'Page- Welcome', 1, 'left', 'none', '', '', '', '', 53, 0, 2, 2, 'head', 1); INSERT INTO `image_content` VALUES (41, 'Page- Welcome', 1, 'left', 'none', '', '', '', '', 83, 0, 2, 2, 'head', 1); INSERT INTO `image_content` VALUES (13, '', 1, 'left', 'none', '', '', 'test', '', 37, 0, 2, 6, 'head', 1); INSERT INTO `image_content` VALUES (65, 'Page- Test', 1, 'center', 'url', 'http://www.50units.com', '', 'This is a caption', 'This is the alt', 111, 0, 2, 9, 'head', 1); INSERT INTO `image_content` VALUES (44, 'Page- Welcome', 1, 'left', 'none', '', '', '', '', 86, 0, 2, 2, 'head', 1); INSERT INTO `image_content` VALUES (66, 'Page- Test', 1, 'right', 'none', '', '', 'test', '', 113, 0, 2, 9, 'body', 1); INSERT INTO `image_content` VALUES (67, 'PageBlock- Copy Block', 1, 'left', 'none', '', '', '', '', 114, 0, 21, 15, 'head', 1); INSERT INTO `image_content` VALUES (68, 'Article Page- Target', 1, 'left', 'none', '', '', 'This is a caption', '', 115, 0, 6, 9, 'body', 1); INSERT INTO `image_content` VALUES (70, 'Display Image- Test', 1, 'left', 'none', '', '', '', '', 117, 0, 7, 3, 'body', 1); INSERT INTO `image_content` VALUES (71, 'Display Image- Number 2', 1, 'left', 'none', '', '', '', '', 118, 0, 7, 4, 'body', 1); INSERT INTO `image_content` VALUES (72, 'Display Image- test3', 1, '', 'none', '', '', '', '', 119, 0, 7, 5, 'body', 1); INSERT INTO `image_content` VALUES (73, 'Block- Block Name', 1, 'right', 'none', '', '', 'caption', '', 120, 0, 19, 11, 'body', 1); INSERT INTO `image_content` VALUES (74, 'Catalog Level- Birds', 1, 'right', 'none', '', '', '', '', 121, 0, 17, 2, 'body', 1); INSERT INTO `image_content` VALUES (75, 'Catalog Level- Birds', 1, 'left', 'none', '', '', '', 'test', 122, 0, 17, 2, 'preview', 1); # -------------------------------------------------------- # # Table structure for table `images` # CREATE TABLE `images` ( `imgID` int(12) NOT NULL auto_increment, `imgName` varchar(255) NOT NULL default '', `imgSave` tinyint(1) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`imgID`), UNIQUE KEY `imgID` (`imgID`), KEY `imgID_2` (`imgID`) ) TYPE=MyISAM AUTO_INCREMENT=126 ; # # Dumping data for table `images` # INSERT INTO `images` VALUES (86, 'twinlocust.jpg', 0, 1); INSERT INTO `images` VALUES (83, 'typeface.jpg', 0, 1); INSERT INTO `images` VALUES (53, 'thesharpguyntr.jpg', 0, 1); INSERT INTO `images` VALUES (37, 'rachellejanell.jpg', 0, 1); INSERT INTO `images` VALUES (115, 'pro_thumb_trimax.jpg', 0, 1); INSERT INTO `images` VALUES (95, '4.jpg', 0, 1); INSERT INTO `images` VALUES (114, 'pro_thumb_trimax2.jpg', 0, 1); INSERT INTO `images` VALUES (103, '130b.jpg', 0, 1); INSERT INTO `images` VALUES (111, 'trimax_body.jpg', 0, 1); INSERT INTO `images` VALUES (113, 'pro_thumb_dock.jpg', 0, 1); INSERT INTO `images` VALUES (117, 'peoplesway.jpg', 0, 1); INSERT INTO `images` VALUES (118, 'millersville.jpg', 0, 1); INSERT INTO `images` VALUES (119, 'covfel.jpg', 0, 1); INSERT INTO `images` VALUES (120, 'employeefraud.jpg', 0, 1); INSERT INTO `images` VALUES (121, 'comingsoon.gif', 0, 1); INSERT INTO `images` VALUES (122, 'djfreez.jpg', 0, 1); # -------------------------------------------------------- # # Table structure for table `mailinglistemails` # CREATE TABLE `mailinglistemails` ( `emID` int(11) NOT NULL auto_increment, `emEmail` varchar(100) NOT NULL default '', `emDate` int(11) NOT NULL default '0', `f_listID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`emID`), UNIQUE KEY `emID` (`emID`,`emEmail`), KEY `emID_2` (`emID`,`emEmail`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `mailinglistemails` # # -------------------------------------------------------- # # Table structure for table `mailinglistentries` # CREATE TABLE `mailinglistentries` ( `meID` int(11) NOT NULL auto_increment, `meSubject` varchar(100) NOT NULL default '', `meBody` text NOT NULL, `meDate` int(11) NOT NULL default '0', `meStatus` varchar(50) NOT NULL default 'edit', `meCount` int(11) NOT NULL default '0', `f_listID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`meID`), UNIQUE KEY `meID` (`meID`), KEY `meID_2` (`meID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `mailinglistentries` # # -------------------------------------------------------- # # Table structure for table `mailinglists` # CREATE TABLE `mailinglists` ( `listID` int(11) NOT NULL auto_increment, `listName` varchar(50) NOT NULL default '', `listTitle` varchar(50) default NULL, `listEmail` varchar(100) default NULL, `listDesc` text, `listWelcome` text, `listWelcomeWeb` text, `listGoodbye` text, `listGoodbyeWeb` text, `listShow` tinyint(3) unsigned default '1', `listLocation` varchar(50) NOT NULL default 'body', `listPageType` varchar(10) NOT NULL default 'some', `f_pageID` text NOT NULL, `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) default '1', PRIMARY KEY (`listID`), UNIQUE KEY `mlID` (`listID`), KEY `mlID_2` (`listID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=17 ; # # Dumping data for table `mailinglists` # INSERT INTO `mailinglists` VALUES (16, 'test', 'test', '', NULL, NULL, NULL, NULL, NULL, 1, 'body', 'some', '1,', 2, 1); # -------------------------------------------------------- # # Table structure for table `moduleclients` # CREATE TABLE `moduleclients` ( `mcID` int(11) NOT NULL auto_increment, `f_modID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`mcID`), UNIQUE KEY `mcID` (`mcID`), KEY `mcID_2` (`mcID`,`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=183 ; # # Dumping data for table `moduleclients` # INSERT INTO `moduleclients` VALUES (178, 101, 1); INSERT INTO `moduleclients` VALUES (177, 20, 1); INSERT INTO `moduleclients` VALUES (176, 16, 1); INSERT INTO `moduleclients` VALUES (175, 14, 1); INSERT INTO `moduleclients` VALUES (174, 13, 1); INSERT INTO `moduleclients` VALUES (173, 12, 1); INSERT INTO `moduleclients` VALUES (172, 11, 1); INSERT INTO `moduleclients` VALUES (171, 10, 1); INSERT INTO `moduleclients` VALUES (170, 9, 1); INSERT INTO `moduleclients` VALUES (169, 8, 1); INSERT INTO `moduleclients` VALUES (168, 7, 1); INSERT INTO `moduleclients` VALUES (167, 6, 1); INSERT INTO `moduleclients` VALUES (166, 5, 1); INSERT INTO `moduleclients` VALUES (165, 4, 1); INSERT INTO `moduleclients` VALUES (164, 3, 1); INSERT INTO `moduleclients` VALUES (163, 2, 1); INSERT INTO `moduleclients` VALUES (162, 1, 1); INSERT INTO `moduleclients` VALUES (15, 15, 1); INSERT INTO `moduleclients` VALUES (180, 17, 1); INSERT INTO `moduleclients` VALUES (182, 19, 1); # -------------------------------------------------------- # # Table structure for table `modulerights` # CREATE TABLE `modulerights` ( `mrID` int(11) NOT NULL auto_increment, `f_modID` int(11) NOT NULL default '0', `f_groupID` int(11) NOT NULL default '0', PRIMARY KEY (`mrID`), UNIQUE KEY `mrID` (`mrID`), KEY `mrID_2` (`mrID`) ) TYPE=MyISAM AUTO_INCREMENT=60 ; # # Dumping data for table `modulerights` # INSERT INTO `modulerights` VALUES (59, 17, 2); INSERT INTO `modulerights` VALUES (58, 15, 2); INSERT INTO `modulerights` VALUES (57, 4, 2); INSERT INTO `modulerights` VALUES (56, 11, 2); INSERT INTO `modulerights` VALUES (52, 19, 1); INSERT INTO `modulerights` VALUES (51, 17, 1); INSERT INTO `modulerights` VALUES (50, 15, 1); INSERT INTO `modulerights` VALUES (49, 5, 1); INSERT INTO `modulerights` VALUES (48, 9, 1); INSERT INTO `modulerights` VALUES (47, 11, 1); INSERT INTO `modulerights` VALUES (46, 20, 1); # -------------------------------------------------------- # # Table structure for table `modules` # CREATE TABLE `modules` ( `modID` int(11) NOT NULL auto_increment, `modName` varchar(50) NOT NULL default '', `modLink` varchar(100) NOT NULL default '', `modContentTable` varchar(30) NOT NULL default '', `modContentVar` varchar(10) NOT NULL default '', `modContentScript` varchar(100) NOT NULL default '', `modContentName` varchar(30) NOT NULL default '', `modContentDelete` varchar(50) NOT NULL default '', `modDelete` tinyint(1) NOT NULL default '1', `modAdmin` tinyint(1) unsigned NOT NULL default '1', `modPublic` tinyint(1) unsigned NOT NULL default '1', `modTitle` varchar(50) NOT NULL default '', `modDesc` text NOT NULL, `modShow` tinyint(1) unsigned NOT NULL default '1', `modType` varchar(50) NOT NULL default 'module', PRIMARY KEY (`modID`), UNIQUE KEY `modID` (`modID`), KEY `modID_2` (`modID`) ) TYPE=MyISAM AUTO_INCREMENT=102 ; # # Dumping data for table `modules` # INSERT INTO `modules` VALUES (1, 'siteindex', '', '', '', '', '', '', 0, 0, 0, '', '', 0, 'base'); INSERT INTO `modules` VALUES (2, 'page', '/admin/pagemanager/index.php', '', '', '', '', '', 1, 1, 1, 'Pages', 'Add, Edit, and Delete your User Pages', 1, 'base'); INSERT INTO `modules` VALUES (3, 'admin', '/admin/adminmanager/index.php', '', '', '', '', '', 1, 1, 1, 'Admins', 'Add, edit and delete site administrators and groups', 1, 'admin'); INSERT INTO `modules` VALUES (4, 'contactForm', '/contactmanager', '', '', 'contact/frm_contact.php', '', '', 0, 1, 0, 'Contact Form', 'Edit your site\'s contact form.', 1, 'base'); INSERT INTO `modules` VALUES (5, 'blog', '/blogmanager', 'blogs', 'blog', 'blogs/act_placeBlog.php', 'Blog', '/act_deleteBlog.php', 1, 1, 1, 'Blogs', 'Edit your web logs and make blog entries', 1, 'module'); INSERT INTO `modules` VALUES (6, 'articles', '/articlemanager', 'articlegroups', 'ag', 'articles/act_placeArticle.php', 'Article', '/act_deleteGroup.php', 1, 1, 1, 'Articles', 'Compose and edit your articles', 1, 'module'); INSERT INTO `modules` VALUES (7, 'display', '/displaymanager', 'displaygroups', 'dg', 'displays/act_placeDisplay.php', 'Display Gallery', '/act_deleteGroup.php', 1, 1, 1, 'Displays', 'Manage your Displays and Images', 1, 'module'); INSERT INTO `modules` VALUES (8, 'password', '/admin/passwordmanager/index.php', '', '', '', '', '', 1, 1, 1, 'Passwords', 'Assign and edit page passwords.', 0, 'module'); INSERT INTO `modules` VALUES (9, 'calendar', '/calendarmanager', 'calendars', 'cal', 'calendars/act_placeCalendar.php', 'Calendar', '/act_deleteCalendar.php', 1, 1, 1, 'Calendars', 'Create and Edit calendars and events.', 1, 'module'); INSERT INTO `modules` VALUES (10, 'mailingList', '/mailinglistmanager', 'mailinglists', 'list', 'mailinglists/act_placeList.php', 'Mailing List', '/act_deleteList.php', 1, 1, 1, 'Mailing Lists', 'Create mailing lists and send emails.', 1, 'module'); INSERT INTO `modules` VALUES (11, 'files', '/filemanager', 'filegroups', 'fg', 'files/act_placeFiles.php', 'Files', '/act_deleteGroup.php', 1, 1, 1, 'File Downloads', 'Upload, manage, and display Files of any kind.', 1, 'module'); INSERT INTO `modules` VALUES (12, 'msgboards', '/msgboardmanager', 'msg_boards', 'brd', 'msgboards/act_placeMsgBoard.php', 'Message Board', '/act_deleteBoard.php', 1, 1, 1, 'Message Boards', 'Edit and maintain your message boards, categories, and messages.', 1, 'module'); INSERT INTO `modules` VALUES (13, 'blocks', '/blockmanager', 'block_groups', 'bg', 'contentblocks/act_placeBlock.php', 'Content Block', '/act_deleteGroup.php', 1, 1, 1, 'Content Blocks', 'Add content -links, tables, and text- anywhere on your site.', 1, 'module'); INSERT INTO `modules` VALUES (14, 'search', '/searchmanager', 'search', 'search', 'search/act_placeSearch.php', 'Search', '/act_deleteSearch.php', 1, 1, 1, 'Search', 'Place and edit your search forms.', 1, 'module'); INSERT INTO `modules` VALUES (15, 'faq', '/faqmanager', 'faq_groups', 'fg', 'faqs/act_placeFaq.php', 'FAQ', '/act_deleteGroup.php', 1, 1, 1, 'FAQs', 'Compile lists of Frequently Asked Questions ', 1, 'module'); INSERT INTO `modules` VALUES (16, 'forms', '/formsmanager', 'form_groups', 'form', 'forms/act_placeForm.php', 'Form', 'formsmanager/act_deleteForm.php', 1, 1, 1, 'Forms', 'Place and\r\nedit dynamic forms.', 1, 'module'); INSERT INTO `modules` VALUES (101, 'Clients', '/admin/clientsmanager/index.php', '', '', '', '', '', 1, 1, 0, 'Clients', 'Manage Clients.', 1, 'admin'); INSERT INTO `modules` VALUES (17, 'catalogs', '/catalogmanager', 'cat_catalogs', 'cat', 'catalogs/act_placeCatalog.php', 'Catalog', '/act_deleteCatalog.php', 1, 1, 1, 'Catalogs', 'Place and\r\nedit catalogs.', 1, 'module'); INSERT INTO `modules` VALUES (20, 'polls', '/pollmanager', 'polls', 'poll', 'polls/act_placePoll.php', 'Polls', '/act_deletePoll.php', 1, 1, 1, 'Polls', 'Add and edit Polls', 1, 'module'); INSERT INTO `modules` VALUES (21, 'pageBlocks', '/pagemanager/blocks', 'page_blocks', 'block', 'pages/act_placeBlocks.php', 'Page Blocks', '/act_deleteBlock.php', 1, 0, 0, 'PageBlocks', '', 0, 'module'); INSERT INTO `modules` VALUES (19, 'news', '/newsmanager', 'news_groups', 'ng', 'news/act_placeNews.php', 'News', '/act_deleteGroup.php', 1, 1, 1, 'News', 'Add and edit News Stories', 1, 'module'); # -------------------------------------------------------- # # Table structure for table `msg_boards` # CREATE TABLE `msg_boards` ( `brdID` int(11) NOT NULL auto_increment, `brdName` varchar(255) NOT NULL default '', `brdTitle` varchar(255) default NULL, `brdDesc` text, `brdShow` smallint(1) NOT NULL default '1', `brdLocation` varchar(50) NOT NULL default 'main', `f_pageID` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`brdID`), UNIQUE KEY `brdID` (`brdID`), KEY `brdID_2` (`brdID`,`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `msg_boards` # INSERT INTO `msg_boards` VALUES (4, 'Message Board', 'Message Board', '', 1, 'main', 70, 2, 1); # -------------------------------------------------------- # # Table structure for table `msg_categories` # CREATE TABLE `msg_categories` ( `mcID` int(11) NOT NULL auto_increment, `mcName` varchar(255) NOT NULL default '', `mcDesc` text, `mcShow` tinyint(1) NOT NULL default '0', `mcSort` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_brdID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`mcID`), UNIQUE KEY `mcID` (`mcID`), KEY `mcID_2` (`mcID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `msg_categories` # INSERT INTO `msg_categories` VALUES (3, 'Category 1', 'This is the category description', 1, 1, 0, 4, 1); # -------------------------------------------------------- # # Table structure for table `msg_messages` # CREATE TABLE `msg_messages` ( `msgID` int(11) NOT NULL auto_increment, `msgDate` int(11) NOT NULL default '0', `msgName` varchar(100) default NULL, `msgEmail` varchar(75) default NULL, `msgUrl` varchar(255) default NULL, `msgTitle` varchar(100) NOT NULL default '', `msgShow` int(1) unsigned NOT NULL default '1', `msgMessage` longtext, `msgSort` int(11) NOT NULL default '0', `f_mcID` int(11) NOT NULL default '0', `f_msgID` int(11) NOT NULL default '0', `f_muID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', `pageChildren` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`msgID`), UNIQUE KEY `pageID` (`msgID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `msg_messages` # INSERT INTO `msg_messages` VALUES (3, 1073027640, 'test', 'rbg@50units.com', 'http://www.50units.com', 'test', 1, 'test2', 0, 3, 0, 0, 1, 0); INSERT INTO `msg_messages` VALUES (4, 1073038740, 'Brandon Griggs', '', '', 'Message Title', 1, 'This is the message, bay-bee. Message boards are neat because they aren\\\'t stupid. I asked Mailing List what he thought, but he referred me to Forms. \r\n\r\nWhat a jerk.', 0, 3, 0, 0, 1, 0); # -------------------------------------------------------- # # Table structure for table `news_blocks` # CREATE TABLE `news_blocks` ( `nbID` int(11) NOT NULL auto_increment, `nbName` varchar(255) NOT NULL default '', `nbSub` varchar(255) default NULL, `nbBody` text, `nbImage` varchar(255) default NULL, `nbImageShow` tinyint(4) NOT NULL default '1', `nbImageAlign` varchar(50) NOT NULL default 'left', `nbImageCaption` text NOT NULL, `f_clientID` int(11) NOT NULL default '1', `f_nsID` int(11) NOT NULL default '0', `nbSort` int(11) unsigned NOT NULL default '0', `nbShow` int(11) unsigned NOT NULL default '0', `nbHead` varchar(255) default NULL, PRIMARY KEY (`nbID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `news_blocks` # # -------------------------------------------------------- # # Table structure for table `news_groups` # CREATE TABLE `news_groups` ( `ngID` int(10) unsigned NOT NULL auto_increment, `ngName` varchar(255) default NULL, `ngTitle` varchar(255) default NULL, `ngDesc` text, `ngShow` tinyint(3) unsigned NOT NULL default '1', `ngShowDesc` tinyint(4) NOT NULL default '0', `ngShowAuthor` tinyint(4) NOT NULL default '0', `ngShowDate` tinyint(4) NOT NULL default '0', `ngShowArchives` tinyint(4) NOT NULL default '0', `ngLimit` int(11) NOT NULL default '0', `ngLocation` varchar(10) NOT NULL default '', `f_adminID` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`ngID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `news_groups` # INSERT INTO `news_groups` VALUES (3, 'News', 'News Articles', 'News Article Description', 1, 1, 1, 1, 1, 8, 'body', 2, 71, 1); # -------------------------------------------------------- # # Table structure for table `news_stories` # CREATE TABLE `news_stories` ( `nsID` int(10) unsigned NOT NULL auto_increment, `nsName` varchar(255) default NULL, `nsAuthor` varchar(255) default NULL, `nsEmail` varchar(100) NOT NULL default '', `nsDate` int(11) NOT NULL default '0', `nsDesc` text, `nsIntro` text, `nsSort` int(11) NOT NULL default '0', `nsShow` tinyint(3) unsigned NOT NULL default '0', `f_ngID` int(10) unsigned NOT NULL default '0', `f_adminID` int(10) unsigned NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`nsID`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; # # Dumping data for table `news_stories` # INSERT INTO `news_stories` VALUES (5, 'Happy New Years', '', '', 1072933200, '', '', 2, 1, 3, 2, 1); INSERT INTO `news_stories` VALUES (4, 'First Story', 'Brandon Griggs', '', 1073019600, 'Story Description', 'Story Introduction', 3, 1, 3, 2, 1); INSERT INTO `news_stories` VALUES (6, 'Old News', '', '', 1070341200, '', '', 0, 1, 3, 2, 1); # -------------------------------------------------------- # # Table structure for table `page_blocklinks` # CREATE TABLE `page_blocklinks` ( `blID` int(11) NOT NULL auto_increment, `blName` varchar(255) NOT NULL default '', `blType` varchar(50) NOT NULL default 'url', `blUrl` text, `blDesc` text, `blPop` tinyint(1) NOT NULL default '0', `blShow` tinyint(4) NOT NULL default '1', `blSort` int(11) NOT NULL default '0', `f_pageID` int(11) default '0', `f_blockID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`blID`), UNIQUE KEY `blID` (`blID`), KEY `blID_2` (`blID`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; # # Dumping data for table `page_blocklinks` # INSERT INTO `page_blocklinks` VALUES (3, 'test2', 'page', '', '', 1, 1, 2, 11, 4, 1); INSERT INTO `page_blocklinks` VALUES (4, 'test2', 'page', '', '', 0, 1, 1, 6, 4, 1); INSERT INTO `page_blocklinks` VALUES (14, 'Link Number One', 'url', 'http://www.50units.com', 'A nice link', 1, 1, 1, NULL, 45, 1); INSERT INTO `page_blocklinks` VALUES (13, 'test2', 'page', '', '', 0, 1, 1, 30, 40, 1); # -------------------------------------------------------- # # Table structure for table `page_blocklists` # CREATE TABLE `page_blocklists` ( `blID` int(11) NOT NULL auto_increment, `blName` varchar(255) NOT NULL default '', `blDesc` text, `blShow` tinyint(4) NOT NULL default '1', `blSort` int(11) NOT NULL default '0', `f_blockID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`blID`), UNIQUE KEY `blID` (`blID`), KEY `blID_2` (`blID`) ) TYPE=MyISAM AUTO_INCREMENT=17 ; # # Dumping data for table `page_blocklists` # INSERT INTO `page_blocklists` VALUES (4, 'test', 'test', 1, 2, 6, 1); INSERT INTO `page_blocklists` VALUES (3, 'test', 'test', 1, 1, 6, 1); INSERT INTO `page_blocklists` VALUES (15, 'List Name', 'List description.', 1, 1, 12, 1); INSERT INTO `page_blocklists` VALUES (14, 'ttest', '', 1, 1, 3, 1); INSERT INTO `page_blocklists` VALUES (16, 'Another item', '', 1, 2, 12, 1); # -------------------------------------------------------- # # Table structure for table `page_blockpages` # CREATE TABLE `page_blockpages` ( `bpID` int(11) NOT NULL auto_increment, `bpSub` varchar(255) default NULL, `bpBody` text, `f_imgHeadID` int(12) NOT NULL default '0', `f_imgBodyID` int(12) NOT NULL default '0', `f_blockID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`bpID`), UNIQUE KEY `bpID` (`bpID`), KEY `bpID_2` (`bpID`) ) TYPE=MyISAM AUTO_INCREMENT=19 ; # # Dumping data for table `page_blockpages` # INSERT INTO `page_blockpages` VALUES (2, 'test', 'This is the body for the test', 0, 0, 3, 1); INSERT INTO `page_blockpages` VALUES (4, NULL, NULL, 0, 0, 11, 1); INSERT INTO `page_blockpages` VALUES (8, NULL, NULL, 0, 0, 21, 1); INSERT INTO `page_blockpages` VALUES (11, 'test sub', 'test body\r\ntest', 0, 0, 38, 1); INSERT INTO `page_blockpages` VALUES (12, 'test', 'test', 0, 0, 41, 1); INSERT INTO `page_blockpages` VALUES (13, NULL, NULL, 37, 0, 42, 1); INSERT INTO `page_blockpages` VALUES (14, NULL, NULL, 39, 0, 43, 1); INSERT INTO `page_blockpages` VALUES (15, 'Sub Head', 'This is the body of the block', 67, 0, 44, 1); INSERT INTO `page_blockpages` VALUES (16, NULL, NULL, 0, 0, 45, 1); INSERT INTO `page_blockpages` VALUES (17, NULL, NULL, 0, 0, 46, 1); INSERT INTO `page_blockpages` VALUES (18, NULL, NULL, 0, 0, 47, 1); # -------------------------------------------------------- # # Table structure for table `page_blocks` # CREATE TABLE `page_blocks` ( `blockID` int(11) NOT NULL auto_increment, `blockName` varchar(255) default NULL, `blockTitle` varchar(255) default NULL, `blockType` varchar(50) NOT NULL default 'page', `blockShow` tinyint(4) NOT NULL default '1', `blockSort` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`blockID`), UNIQUE KEY `blockID` (`blockID`), KEY `blockID_2` (`blockID`) ) TYPE=MyISAM AUTO_INCREMENT=48 ; # # Dumping data for table `page_blocks` # INSERT INTO `page_blocks` VALUES (44, 'Copy Block', 'Copy Block Title', 'page', 1, 1, 2, 55, 1); INSERT INTO `page_blocks` VALUES (40, 'Links Block', 'links', 'links', 1, 5, 2, 2, 1); INSERT INTO `page_blocks` VALUES (45, 'Block 2', 'Another Block', 'links', 1, 2, 2, 55, 1); # -------------------------------------------------------- # # Table structure for table `page_stats` # CREATE TABLE `page_stats` ( `psID` int(11) NOT NULL auto_increment, `psReferer` char(255) default 'none', `psIP` char(50) default NULL, `psBrowser` char(255) default NULL, `psDate` int(16) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`psID`), UNIQUE KEY `psID` (`psID`), KEY `psID_2` (`psID`), KEY `f_clientID` (`f_clientID`), KEY `f_pageID` (`f_pageID`) ) TYPE=MyISAM AUTO_INCREMENT=14 ; # # Dumping data for table `page_stats` # INSERT INTO `page_stats` VALUES (1, 'none', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926460, 2, 1); INSERT INTO `page_stats` VALUES (2, 'http://localhost/fusebox/50units/', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926460, 5, 1); INSERT INTO `page_stats` VALUES (3, 'http://localhost/fusebox/50units/pages/index.php?pageID=5', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926460, 4, 1); INSERT INTO `page_stats` VALUES (4, 'http://localhost/fusebox/50units/pages/index.php?pageID=4', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926460, 8, 1); INSERT INTO `page_stats` VALUES (5, 'http://localhost/fusebox/50units/pages/index.php?pageID=8', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926460, 9, 1); INSERT INTO `page_stats` VALUES (6, 'http://localhost/fusebox/50units/pages/index.php?pageID=9', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 11, 1); INSERT INTO `page_stats` VALUES (7, 'http://localhost/fusebox/50units/pages/index.php?fuseAction=page&pageID=11', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 12, 1); INSERT INTO `page_stats` VALUES (8, 'http://localhost/fusebox/50units/pages/index.php?fuseAction=page&pageID=12', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 10, 1); INSERT INTO `page_stats` VALUES (9, 'http://localhost/fusebox/50units/pages/index.php?fuseAction=page&pageID=10', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 13, 1); INSERT INTO `page_stats` VALUES (10, 'http://localhost/fusebox/50units/msgboards/index.php?mcID=1', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 2, 1); INSERT INTO `page_stats` VALUES (11, 'http://localhost/fusebox/50units/pages/index.php?fuseAction=page&pageID=10', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 13, 1); INSERT INTO `page_stats` VALUES (12, 'http://localhost/fusebox/50units/pages/index.php?fuseAction=page&pageID=12', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 10, 1); INSERT INTO `page_stats` VALUES (13, 'http://localhost/fusebox/50units/pages/index.php?fuseAction=page&pageID=11', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130', 1041926520, 12, 1); # -------------------------------------------------------- # # Table structure for table `pages` # CREATE TABLE `pages` ( `pageID` int(11) NOT NULL auto_increment, `pageNumber` int(12) NOT NULL default '0', `pageType` varchar(22) NOT NULL default 'page', `pageName` varchar(100) default NULL, `pageTitle` varchar(100) NOT NULL default '', `pageShow` int(1) unsigned NOT NULL default '1', `pageSub` varchar(255) default NULL, `pageHead` varchar(255) default NULL, `pageBody` longtext, `pageBodyShow` tinyint(1) NOT NULL default '1', `pageLinkType` varchar(22) NOT NULL default '', `pageLinkLocation` varchar(22) NOT NULL default '', `pageLinkSort` int(11) NOT NULL default '0', `pageLinkShow` tinyint(1) NOT NULL default '1', `pageLinkPop` tinyint(4) NOT NULL default '0', `pageLinkUrl` text NOT NULL, `pageLinkPageID` int(11) NOT NULL default '0', `pageMetaKeys` text NOT NULL, `pageMetaTitle` varchar(255) NOT NULL default '', `pageMetaDesc` text NOT NULL, `pagePass` tinyint(1) NOT NULL default '0', `pagePassWord` varchar(255) NOT NULL default '', `pagePassCookie` tinyint(4) NOT NULL default '0', `f_imgBodyID` int(12) default '0', `f_imgHeadID` int(12) default '0', `pageIsModule` int(1) unsigned NOT NULL default '0', `pageSort` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', `pageChildren` tinyint(1) unsigned NOT NULL default '0', `pageNavChildren` tinyint(1) NOT NULL default '0', PRIMARY KEY (`pageID`), UNIQUE KEY `pageID` (`pageID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=89 ; # # Dumping data for table `pages` # INSERT INTO `pages` VALUES (1, 1, 'page', 'siteIndex', 'Site Index', 1, 'lost?', 'SiteIndex', 'Can\'t find what your looking for? Here\'s our whole site mapped\r\nout in one convenient page.', 1, '', 'minor', 1, 1, 0, '', 0, 'test2', '', 'test3', 0, '', 0, 0, 0, 1, 2, 0, 1, 0, 0); INSERT INTO `pages` VALUES (2, 2, 'page', 'homePage', 'Welcome', 1, 'test', '', 'Welcome!', 1, '', 'major', 1, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 47, 1, 1, 0, 1, 0, 0); INSERT INTO `pages` VALUES (3, 3, 'page', 'contactForm', 'Contact', 1, 'don\\\'t be shy...', 'Contact Us', 'Here at SiteStrux we understand the importance of communication. Feel free to contact us- we need your comments and suggestions to make SiteStrux even better.', 1, '', 'minor', 2, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 1, 3, 0, 1, 0, 0); INSERT INTO `pages` VALUES (4, 4, 'page', NULL, 'Content', 1, 'SiteStrux', 'Content', 'This area will display and test all the content. \r\n\r\nClick on the sub pages to the left to test.', 1, '', 'major', 2, 1, 0, '', 0, '', 'test', '', 0, '', 0, NULL, NULL, 0, 4, 0, 1, 1, 1); INSERT INTO `pages` VALUES (9, 7, 'page', NULL, 'Pages', 1, 'SiteStrux', 'Test', 'Hello and welcome to the new and comprehensive test page from SiteStrux.com. This first paragraph is testing a full length paragraph that should fill the entire body area. If it doesn\\\'t, please log in to the admin area and type some more into this area.\r\n\r\nThis paragraph is testing HTML. Does the following appear in italics? I\\\'m in italics wheee.\r\n\r\nThis paragraph is testing the special SiteStrux HTML keys. The following is a table that should display without a whole bunch of spaces.\r\n\r\n<$$\r\n\r\n\r\n\r\n\r\n
I\\\'m a table, yeah.
\r\n$$>', 1, '', 'major', 4, 1, 0, '', 0, 'Meta Keywords', 'Meta Title', '', 0, '', 0, 66, 65, 0, 5, 0, 1, 1, 0); INSERT INTO `pages` VALUES (69, 0, 'page', NULL, 'Mailing List', 1, '', 'Mailing LIst', 'Mailing List below.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 2, 67, 1, 0, 0); INSERT INTO `pages` VALUES (70, 0, 'page', NULL, 'Message Board', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 3, 67, 1, 0, 0); INSERT INTO `pages` VALUES (55, 0, 'page', NULL, 'Blocks', 1, '', 'Blocks', 'This page is testing blocks. This paragraph is the page body field.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 1, 56, 1, 0, 0); INSERT INTO `pages` VALUES (56, 0, 'page', NULL, 'Sub Page', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 1, 9, 1, 1, 0); INSERT INTO `pages` VALUES (57, 0, 'page', NULL, 'Password', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 1, 'New', 1, 0, 0, 0, 1, 9, 1, 1, 1); INSERT INTO `pages` VALUES (58, 0, 'link', NULL, 'Test Link', 1, NULL, NULL, NULL, 1, 'url', '', 0, 1, 1, 'http://www.50units.com', 0, '', '', '', 0, '', 0, 0, 0, 0, 2, 9, 1, 0, 0); INSERT INTO `pages` VALUES (68, 0, 'page', NULL, 'Forms', 1, 'sub head', 'header', 'body text in this area', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 1, 67, 1, 0, 0); INSERT INTO `pages` VALUES (59, 0, 'page', NULL, 'Articles', 1, 'SiteStrux', 'Page Head', 'The article content will start below. This is the page Body area.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 1, 4, 1, 0, 0); INSERT INTO `pages` VALUES (60, 0, 'page', NULL, 'Blogs', 1, '', 'Blogs', 'This page is for blogs.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 2, 4, 1, 0, 0); INSERT INTO `pages` VALUES (61, 0, 'page', NULL, 'Calendar', 1, '', 'Calendars', 'This page will show Calendars.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 3, 4, 1, 1, 1); INSERT INTO `pages` VALUES (62, 0, 'page', NULL, 'Multi Calendar', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 1, 61, 1, 0, 0); INSERT INTO `pages` VALUES (63, 0, 'page', NULL, 'Content Blocks', 1, '', 'Content Blocks', 'This is the page body, below are the content blocks.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 4, 4, 1, 0, 0); INSERT INTO `pages` VALUES (64, 0, 'page', NULL, 'Image Galleries', 1, NULL, NULL, NULL, 1, '', 'major', 5, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 5, 4, 1, 0, 0); INSERT INTO `pages` VALUES (65, 0, 'page', NULL, 'FAQ', 1, '', 'FAQ\\\'s', 'Faq\\\'s below.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 6, 4, 1, 0, 0); INSERT INTO `pages` VALUES (66, 0, 'page', NULL, 'Files', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 7, 4, 1, 0, 0); INSERT INTO `pages` VALUES (67, 0, 'page', NULL, 'More Content', 1, NULL, NULL, NULL, 1, '', 'major', 3, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 6, 0, 1, 1, 1); INSERT INTO `pages` VALUES (71, 0, 'page', NULL, 'News', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 76, 0, 4, 67, 1, 0, 0); INSERT INTO `pages` VALUES (72, 0, 'page', NULL, 'Polls', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 5, 67, 1, 0, 0); INSERT INTO `pages` VALUES (73, 0, 'page', NULL, 'Search', 1, 'SiteStrux', 'Search', 'Below is a search form.', 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 6, 67, 1, 0, 0); INSERT INTO `pages` VALUES (76, 0, 'page', NULL, 'Catalog', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 0, '', 0, 0, 0, 0, 7, 67, 1, 0, 0); INSERT INTO `pages` VALUES (75, 0, 'page', NULL, 'Sub Pass', 1, NULL, NULL, NULL, 1, '', '', 0, 1, 0, '', 0, '', '', '', 1, 'New', 1, 0, 0, 0, 1, 57, 1, 0, 0); # -------------------------------------------------------- # # Table structure for table `passwordlog` # CREATE TABLE `passwordlog` ( `plID` int(11) NOT NULL auto_increment, `plEmail` varchar(100) NOT NULL default '', `plDate` int(11) NOT NULL default '0', `f_passID` int(11) NOT NULL default '0', PRIMARY KEY (`plID`), UNIQUE KEY `plID` (`plID`), KEY `plID_2` (`plID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `passwordlog` # INSERT INTO `passwordlog` VALUES (1, 'rbg@50units.com', 1041108240, 1); INSERT INTO `passwordlog` VALUES (2, 'rbg@50units.com', 1041108240, 1); # -------------------------------------------------------- # # Table structure for table `passwords` # CREATE TABLE `passwords` ( `passID` int(11) NOT NULL auto_increment, `passWord` varchar(50) NOT NULL default '', `passCookie` tinyint(1) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `firstEntered` int(11) NOT NULL default '0', `lastUpdated` int(11) NOT NULL default '0', `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`passID`), UNIQUE KEY `passID` (`passID`), KEY `passID_2` (`passID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `passwords` # # -------------------------------------------------------- # # Table structure for table `poll_options` # CREATE TABLE `poll_options` ( `poID` int(11) NOT NULL auto_increment, `poName` varchar(255) default NULL, `poValue` int(11) default '0', `poSort` int(11) NOT NULL default '0', `poShow` tinyint(1) NOT NULL default '1', `f_pollID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`poID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; # # Dumping data for table `poll_options` # INSERT INTO `poll_options` VALUES (4, 'Wicked cool functionality', 6, 2, 1, 2, 1); INSERT INTO `poll_options` VALUES (3, 'Sexy Design', 12, 1, 1, 2, 1); INSERT INTO `poll_options` VALUES (5, 'Hot Hot office', 4, 3, 1, 2, 1); # -------------------------------------------------------- # # Table structure for table `polls` # CREATE TABLE `polls` ( `pollID` int(11) NOT NULL auto_increment, `pollName` varchar(255) default NULL, `pollTitle` varchar(255) default NULL, `pollDesc` text, `pollQuestion` text, `pollShow` tinyint(1) NOT NULL default '1', `pollLocation` varchar(15) NOT NULL default 'body', `pollThanks` text NOT NULL, `f_adminID` int(11) NOT NULL default '0', `f_pageID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`pollID`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; # # Dumping data for table `polls` # INSERT INTO `polls` VALUES (2, 'Survey Poll', 'Survey Poll', 'This is a cool poll description.', 'What is the coolest thing about SiteStrux?', 1, 'body', '', 2, 72, 1); # -------------------------------------------------------- # # Table structure for table `search` # CREATE TABLE `search` ( `searchID` int(11) NOT NULL auto_increment, `searchName` varchar(50) NOT NULL default '', `searchTitle` varchar(50) default NULL, `searchDesc` text, `searchShow` tinyint(3) unsigned default '1', `searchDate` int(12) NOT NULL default '0', `searchLocation` varchar(50) NOT NULL default 'body', `searchPageType` varchar(10) NOT NULL default 'some', `searchIndexType` varchar(10) NOT NULL default 'some', `searchIndexID` text NOT NULL, `f_pageID` text NOT NULL, `f_adminID` int(11) NOT NULL default '0', `f_clientID` int(11) default '1', PRIMARY KEY (`searchID`), UNIQUE KEY `mlID` (`searchID`), KEY `mlID_2` (`searchID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; # # Dumping data for table `search` # INSERT INTO `search` VALUES (4, 'test', '', '', 1, 1075239060, 'body', 'some', 'all', '', '73,', 2, 1); # -------------------------------------------------------- # # Table structure for table `search_index` # CREATE TABLE `search_index` ( `searchID` int(11) NOT NULL auto_increment, `searchTitle` varchar(255) default NULL, `searchBody` text, `searchOther` text, `searchLink` varchar(255) NOT NULL default '', `searchDate` int(11) NOT NULL default '0', `f_searchID` int(12) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`searchID`), UNIQUE KEY `searchID` (`searchID`), KEY `searchID_2` (`searchID`) ) TYPE=MyISAM AUTO_INCREMENT=182 ; # # Dumping data for table `search_index` # INSERT INTO `search_index` VALUES (173, 'What is a website', 'A website is a permanent location on the Internet. ', 'What is a website ', '/fusebox/_sitestrux_3/faqs/index.php?fuseAction=faq&fgID=1&faqID=80', 0, 4, 1); INSERT INTO `search_index` VALUES (174, 'Happy New Years', '', 'Happy New Years ', '/fusebox/_sitestrux_3/news/?fuseAction=story&archives=&ngID=3&nsID=5', 0, 4, 1); INSERT INTO `search_index` VALUES (172, 'What is a website', 'This FAQ answers common questions concerning the Web Site. ', 'This is the introduction the FAQ about websites ', '/fusebox/_sitestrux_3/faqs/index.php?fuseAction=faq&fgID=1&faqID=80', 0, 4, 1); INSERT INTO `search_index` VALUES (170, 'Block 2', 'This is block 2 ', 'Block 2 ', '/fusebox/_sitestrux_3/pages/index.php?pageID=63,', 0, 4, 1); INSERT INTO `search_index` VALUES (171, 'FAQ', 'Faq\\\'s below. ', 'FAQ\\\'s FAQ ', '/fusebox/_sitestrux_3/pages/index.php?pageID=65', 0, 4, 1); INSERT INTO `search_index` VALUES (165, 'Blogs', '', '', '/fusebox/_sitestrux_3/pages/index.php?pageID=60,', 0, 4, 1); INSERT INTO `search_index` VALUES (166, 'Calendar', 'This page will show Calendars. ', 'Calendars Calendar ', '/fusebox/_sitestrux_3/pages/index.php?pageID=61', 0, 4, 1); INSERT INTO `search_index` VALUES (167, 'Content Blocks', 'This is the page body, below are the content blocks. ', 'Content Blocks Content Blocks ', '/fusebox/_sitestrux_3/pages/index.php?pageID=63', 0, 4, 1); INSERT INTO `search_index` VALUES (168, 'Content Blocks', '', '', '/fusebox/_sitestrux_3/pages/index.php?pageID=63,', 0, 4, 1); INSERT INTO `search_index` VALUES (169, 'test', 'This is the body.\r\nTHis is the body.\r\nThis is the body. tests ', 'test ', '/fusebox/_sitestrux_3/pages/index.php?pageID=63,', 0, 4, 1); INSERT INTO `search_index` VALUES (164, 'Blogs', 'This page is for blogs. ', 'Blogs Blogs ', '/fusebox/_sitestrux_3/pages/index.php?pageID=60', 0, 4, 1); INSERT INTO `search_index` VALUES (163, 'Hook the Target', 'After you\\\'ve found your target, you need to convince them that you have the product they need. ', '', '/fusebox/_sitestrux_3/articles/index.php?fuseAction=page&apID=10&agID=10&artID=9', 0, 4, 1); INSERT INTO `search_index` VALUES (162, 'Finding the Target', 'The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. \r\n\r\nThe first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. The first thing you need to do is find a target. \r\n\r\nThe first thing you need to do is find a target. The first thing you need to do is find a target. ', 'Find the Target Head ', '/fusebox/_sitestrux_3/articles/index.php?fuseAction=page&apID=9&agID=10&artID=9', 0, 4, 1); INSERT INTO `search_index` VALUES (158, 'Another Block', 'A nice link ', 'Link Number One Another Block ', '/fusebox/_sitestrux_3/pages/index.php?pageID=55', 0, 4, 1); INSERT INTO `search_index` VALUES (159, 'Forms', 'body text in this area ', 'header sub head Forms ', '/fusebox/_sitestrux_3/pages/index.php?pageID=68', 0, 4, 1); INSERT INTO `search_index` VALUES (160, 'Articles', 'The article content will start below. This is the page Body area. ', 'Page Head SiteStrux Articles ', '/fusebox/_sitestrux_3/pages/index.php?pageID=59', 0, 4, 1); INSERT INTO `search_index` VALUES (161, 'Selling a website', 'This is the article description. This article will tell you how to sell a website. ', 'Selling a website is not easy. You need to convince people of lots of stuff. Selling a website ', '/fusebox/_sitestrux_3/articles/index.php?fuseAction=article&agID=10&artID=9', 0, 4, 1); INSERT INTO `search_index` VALUES (157, 'Another Block', '', 'Another Block ', '/fusebox/_sitestrux_3/pages/index.php?pageID=55', 0, 4, 1); INSERT INTO `search_index` VALUES (156, 'Copy Block Title', 'This is the body of the block ', 'Sub Head Copy Block Title ', '/fusebox/_sitestrux_3/pages/index.php?pageID=55', 0, 4, 1); INSERT INTO `search_index` VALUES (155, 'Blocks', 'This page is testing blocks. This paragraph is the page body field. ', 'Blocks Blocks ', '/fusebox/_sitestrux_3/pages/index.php?pageID=55', 0, 4, 1); INSERT INTO `search_index` VALUES (154, 'Mailing List', 'Mailing List below. ', 'Mailing LIst Mailing List ', '/fusebox/_sitestrux_3/pages/index.php?pageID=69', 0, 4, 1); INSERT INTO `search_index` VALUES (153, 'Pages', 'Hello and welcome to the new and comprehensive test page from SiteStrux.com. This first paragraph is testing a full length paragraph that should fill the entire body area. If it doesn\\\'t, please log in to the admin area and type some more into this area.\r\n\r\nThis paragraph is testing HTML. Does the following appear in italics? I\\\'m in italics wheee.\r\n\r\nThis paragraph is testing the special SiteStrux HTML keys. The following is a table that should display without a whole bunch of spaces.\r\n\r\n<$$\r\n\r\n\r\nI\\\'m a table, yeah.\r\n\r\n\r\n$$> ', 'Test SiteStrux Pages ', '/fusebox/_sitestrux_3/pages/index.php?pageID=9', 0, 4, 1); INSERT INTO `search_index` VALUES (152, 'Content', 'This area will display and test all the content. \r\n\r\nClick on the sub pages to the left to test. ', 'Content SiteStrux Content ', '/fusebox/_sitestrux_3/pages/index.php?pageID=4', 0, 4, 1); INSERT INTO `search_index` VALUES (151, 'Contact', 'Here at SiteStrux we understand the importance of communication. Feel free to contact us- we need your comments and suggestions to make SiteStrux even better. ', 'Contact Us don\\\'t be shy... Contact ', '/fusebox/_sitestrux_3/pages/index.php?pageID=3', 0, 4, 1); INSERT INTO `search_index` VALUES (150, 'Link Block', 'this is the description ', 'Test Link Link Block ', '/fusebox/_sitestrux_3/pages/index.php?pageID=2,', 0, 4, 1); INSERT INTO `search_index` VALUES (149, 'Welcome', '', '', '/fusebox/_sitestrux_3/pages/index.php?pageID=2,', 0, 4, 1); INSERT INTO `search_index` VALUES (148, 'List Block', 'This is the list block description ', 'List Block ', '/fusebox/_sitestrux_3/pages/index.php?pageID=2,', 0, 4, 1); INSERT INTO `search_index` VALUES (147, 'Page Block', 'test ', 'test Page Block ', '/fusebox/_sitestrux_3/pages/index.php?pageID=2,', 0, 4, 1); INSERT INTO `search_index` VALUES (146, 'Block Group Title', 'This bg is on one page and in the main body. ', 'Block Group Title ', '/fusebox/_sitestrux_3/pages/index.php?pageID=2,', 0, 4, 1); INSERT INTO `search_index` VALUES (145, 'List Block', 'test ', 'This is the list block description List Block ', '/fusebox/_sitestrux_3/pages/index.php?pageID=2,', 0, 4, 1); INSERT INTO `search_index` VALUES (144, 'Welcome', 'Welcome! ', 'test Welcome ', '/fusebox/_sitestrux_3/pages/index.php?pageID=2', 0, 4, 1); INSERT INTO `search_index` VALUES (143, 'Site Index', 'Can\'t find what your looking for? Here\'s our whole site mapped\r\nout in one convenient page. ', 'SiteIndex lost? Site Index ', '/fusebox/_sitestrux_3/pages/index.php?pageID=1', 0, 4, 1); INSERT INTO `search_index` VALUES (175, 'First Story', 'Story Description ', 'Story Introduction First Story ', '/fusebox/_sitestrux_3/news/?fuseAction=story&archives=&ngID=3&nsID=4', 0, 4, 1); INSERT INTO `search_index` VALUES (176, 'Old News', '', 'Old News ', '/fusebox/_sitestrux_3/news/?fuseAction=story&archives=&ngID=3&nsID=6', 0, 4, 1); INSERT INTO `search_index` VALUES (177, 'Happy New Years', 'This is a news block ', '', '/fusebox/_sitestrux_3/news/?fuseAction=story&archives=&ngID=3&nsID=5', 0, 4, 1); INSERT INTO `search_index` VALUES (178, 'First Story', 'This is a news block ', '', '/fusebox/_sitestrux_3/news/?fuseAction=story&archives=&ngID=3&nsID=4', 0, 4, 1); INSERT INTO `search_index` VALUES (179, 'Old News', 'This is a news block ', '', '/fusebox/_sitestrux_3/news/?fuseAction=story&archives=&ngID=3&nsID=6', 0, 4, 1); INSERT INTO `search_index` VALUES (180, 'Survey Poll', 'What is the coolest thing about SiteStrux? ', 'This is a cool poll description. Survey Poll ', '/fusebox/_sitestrux_3/pages/index.php?pageID=72', 0, 4, 1); INSERT INTO `search_index` VALUES (181, 'Search', 'Below is a search form. ', 'Search SiteStrux Search ', '/fusebox/_sitestrux_3/pages/index.php?pageID=73', 0, 4, 1); # -------------------------------------------------------- # # Table structure for table `search_modules` # CREATE TABLE `search_modules` ( `smID` int(12) NOT NULL auto_increment, `smQuery` text NOT NULL, `smBody` text NOT NULL, `smOther` text NOT NULL, `smTitle` varchar(255) NOT NULL default '', `smLink` varchar(255) NOT NULL default '', `f_modID` int(12) NOT NULL default '0', PRIMARY KEY (`smID`), UNIQUE KEY `smID` (`smID`), KEY `smID_2` (`smID`) ) TYPE=MyISAM AUTO_INCREMENT=19 ; # # Dumping data for table `search_modules` # INSERT INTO `search_modules` VALUES (1, 'SELECT pageID, pageHead, pageSub, pageTitle, pageBody\r\n FROM pages\r\n WHERE f_clientID = $client_ID\r\n AND pageShow = 1\r\n AND pageID =$f_ID\r\n AND (pageBody <> \'\' OR pageSub <> \'\' or pageHead <> \'\')', 'pageBody', 'pageHead,pageSub,pageTitle', 'pageTitle,pageHead', '$site_webPath/pages/index.php?pageID=$searchRow[pageID]', 2); INSERT INTO `search_modules` VALUES (2, 'SELECT blogName, beHead, blogID, beID, beEntry\r\nFROM blogs g, blogentries \r\n WHERE blogID = $f_ID\r\n AND f_blogID = blogID\r\n AND blogShow = 1\r\n AND beShow = 1\r\n AND beDate <= " . currentTime() . "\r\n AND g.f_clientID = $client_ID', 'beEntry', 'beHead', 'beHead', '$site_webPath/blogs/index.php?beID=$searchRow[beID]', 5); INSERT INTO `search_modules` VALUES (3, 'SELECT agID, artID, artName, artTitle, artDesc, artIntro\r\nFROM articlegroups g, articles\r\n WHERE agID = $f_ID\r\n AND f_agID = agID\r\n AND agShow = 1\r\n AND artShow = 1\r\n AND g.f_clientID = $client_ID', 'artDesc', 'artIntro,artTitle', 'artTitle,artName', '$site_webPath/articles/index.php?fuseAction=article&agID=$searchRow[agID]&artID=$searchRow[artID]', 6); INSERT INTO `search_modules` VALUES (4, 'SELECT agID, artID, apID, apTitle, apHead, apBody\r\n FROM articlegroups g, articles, articlepages\r\n WHERE agID = $f_ID\r\n AND f_agID = agID\r\n AND f_artID = artID\r\n AND agShow = 1\r\n AND artShow = 1\r\n AND apShow = 1\r\n AND g.f_clientID = $client_ID', 'apBody', 'apHead', 'apTitle', '$site_webPath/articles/index.php?fuseAction=page&apID=$searchRow[apID]&agID=$searchRow[agID]&artID=$searchRow[artID]', 6); INSERT INTO `search_modules` VALUES (13, 'SELECT g.f_pageID, pageTitle, blockTitle, blName, blDesc\r\n FROM pages, page_blocks g, page_blocklists\r\n WHERE blockID = $f_ID\r\n AND g.f_pageID = pageID\r\n AND pageShow = 1\r\n AND blockID = $f_ID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'blDesc', 'blName,blockTitle', 'blockTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[f_pageID]', 21); INSERT INTO `search_modules` VALUES (7, 'SELECT g.f_pageID, pageTitle, blockTitle, blockDesc blName, blDesc FROM pages, block_groups g, blocks, block_lists\r\n WHERE bgID = $f_ID\r\n AND bgShow = 1\r\n AND g.f_pageID = pageID\r\n AND f_ID = $f_ID\r\nAND f_modID = $f_modID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'blDesc', 'blName,blockTitle', 'blockTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[f_pageID]', 13); INSERT INTO `search_modules` VALUES (5, 'SELECT g.f_pageID, pageTitle, bgDesc, bgTitle FROM block_groups g, pages\r\n WHERE bgID = $f_ID\r\n AND bgShow = 1\r\n AND g.f_pageID = pageID\r\n AND pageShow = 1\r\n AND g.f_clientID = $client_ID', 'bgDesc', 'bgTitle', 'bgTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[f_pageID]', 13); INSERT INTO `search_modules` VALUES (6, 'SELECT g.f_pageID, pageTitle, blockTitle, blockDesc, bpSub, bpBody FROM block_groups g, pages, blocks, block_pages\r\n WHERE bgID = $f_ID\r\n AND bgShow = 1\r\n AND g.f_pageID = pageID\r\n AND pageShow = 1\r\n AND f_ID = $f_ID\r\nAND f_modID = $f_modID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'bpBody,blockDesc', 'bpSub,blockTitle', 'bpTitle,blockTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[f_pageID]', 13); INSERT INTO `search_modules` VALUES (8, 'SELECT g.f_pageID, pageTitle, blockTitle, blockDesc, blName, blDesc FROM block_groups g, pages, blocks, block_links\r\n WHERE bgID = $f_ID\r\n AND bgShow = 1\r\n AND g.f_pageID = pageID\r\n AND pageShow = 1\r\n AND f_ID = $f_ID\r\nAND f_modID = $f_modID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'blDesc,blockDesc', 'blName,blockTitle', 'blockTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[f_pageID]', 13); INSERT INTO `search_modules` VALUES (9, 'SELECT fgID, faqID, faqName, faqDesc, faqIntro\r\nFROM faq_groups g, faq_faq\r\n WHERE fgID = $f_ID\r\n AND f_fgID = fgID\r\n AND fgShow = 1\r\n AND faqShow = 1\r\n AND g.f_clientID = $client_ID', 'faqDesc', 'faqIntro,faqTitle', 'faqName', '$site_webPath/faqs/index.php?fuseAction=faq&fgID=$searchRow[fgID]&faqID=$searchRow[faqID]', 15); INSERT INTO `search_modules` VALUES (10, 'SELECT fgID, faqID, fqID, fqQuestion, fqAnswer FROM faq_groups g, faq_faq, faq_questions\r\n WHERE fgID = $f_ID\r\n AND f_fgID = fgID\r\n AND fgShow = 1\r\n AND faqShow = 1\r\n AND f_faqID = faqID\r\n AND fqShow = 1\r\n AND g.f_clientID = $client_ID', 'fqAnswer', 'fqQuestion', 'fqQuestion', '$site_webPath/faqs/index.php?fuseAction=faq&fgID=$searchRow[fgID]&faqID=$searchRow[faqID]', 15); INSERT INTO `search_modules` VALUES (11, 'SELECT pageID, pageTitle, pollTitle, pollDesc, pollQuestion\r\nFROM polls g, pages\r\n WHERE pollID = $f_ID\r\n AND g.f_pageID=pageID\r\n AND pollShow = 1\r\n AND g.f_clientID = $client_ID', 'pollQuestion', 'pollDesc,pollTitle', 'pollTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[pageID]', 20); INSERT INTO `search_modules` VALUES (12, 'SELECT pageID, pageTitle, blockTitle, bpSub, bpBody\r\nFROM pages, page_blocks g, page_blockpages\r\nWHERE blockID = $f_ID\r\n AND blockShow = 1\r\n AND g.f_pageID = pageID\r\n AND pageShow = 1\r\n AND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'bpBody', 'bpSub,blockTitle', 'bpTitle,blockTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[pageID]', 21); INSERT INTO `search_modules` VALUES (14, 'SELECT g.f_pageID, pageTitle, blockTitle, blName, blDesc FROM page_blocks g, pages, page_blocklinks\r\n WHERE blockID = $f_ID\r\n AND blockShow = 1\r\n AND g.f_pageID = pageID\r\n AND pageShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'blDesc,blockDesc', 'blName,blockTitle', 'blockTitle,pageTitle', '$site_webPath/pages/index.php?pageID=$searchRow[f_pageID]', 21); INSERT INTO `search_modules` VALUES (15, 'SELECT ngID, nsID, nsName, nsDesc, nsIntro\r\n FROM news_groups g, news_stories\r\nWHERE ngID = $f_ID\r\n AND f_ngID = ngID\r\n AND nsShow = 1\r\n AND ngShow = 1\r\n AND g.f_clientID = $client_ID', 'nsDesc', 'nsIntro,nsName', 'nsName', '$site_webPath/news/?fuseAction=story&archives=&ngID=$searchRow[ngID]&nsID=$searchRow[nsID]', 19); INSERT INTO `search_modules` VALUES (16, 'SELECT nsID, f_ngID, nsName, blockTitle, blockDesc, bpSub, bpBody FROM news_stories g, blocks, block_pages\r\n WHERE f_ngID = $f_ID\r\n AND nsShow = 1\r\n AND f_ID = $f_ID\r\nAND f_modID = $f_modID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'bpBody,blockDesc', 'bpSub,blockTitle', 'bpTitle,blockTitle,nsName', '$site_webPath/news/?fuseAction=story&archives=&ngID=$searchRow[f_ngID]&nsID=$searchRow[nsID]', 19); INSERT INTO `search_modules` VALUES (17, 'SELECT nsID, f_ngID, nsName, blockTitle, blockDesc, blName, blDesc FROM news_stories g, blocks, block_lists\r\n WHERE nsID = $f_ID\r\n AND nsShow = 1\r\n AND f_ID = $f_ID\r\nAND f_modID = $f_modID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'blDesc', 'blName,blockTitle', 'blockTitle,nsName', '$site_webPath/news/?fuseAction=story&archives=&ngID=$searchRow[f_ngID]&nsID=$searchRow[nsID]', 19); INSERT INTO `search_modules` VALUES (18, 'SELECT f_ngID, nsID, nsName, blockTitle, blockDesc, blName, blDesc FROM news_stories g, blocks, block_links\r\n WHERE nsID = $f_ID\r\n AND nsShow= 1\r\n AND f_ID = $f_ID\r\nAND f_modID = $f_modID\r\nAND blockShow = 1\r\nAND f_blockID = blockID\r\n AND g.f_clientID = $client_ID', 'blDesc,blockDesc', 'blName,blockTitle', 'blockTitle,nsName', '$site_webPath/news/?fuseAction=story&archives=&ngID=$searchRow[f_ngID]&nsID=$searchRow[nsID]', 19); # -------------------------------------------------------- # # Table structure for table `states` # CREATE TABLE `states` ( `stateID` int(11) NOT NULL auto_increment, `stateName` varchar(100) NOT NULL default '', `stateAbbreviation` char(3) NOT NULL default '', PRIMARY KEY (`stateID`), UNIQUE KEY `stateID` (`stateID`), KEY `stateID_2` (`stateID`) ) TYPE=MyISAM AUTO_INCREMENT=52 ; # # Dumping data for table `states` # INSERT INTO `states` VALUES (1, 'Alabama', 'AL'); INSERT INTO `states` VALUES (2, 'Alaska', 'AK'); INSERT INTO `states` VALUES (3, 'Arizona', 'AZ'); INSERT INTO `states` VALUES (4, 'Arkansas', 'AR'); INSERT INTO `states` VALUES (5, 'California', 'CA'); INSERT INTO `states` VALUES (6, 'Colorado', 'CO'); INSERT INTO `states` VALUES (7, 'Connecticut', 'CT'); INSERT INTO `states` VALUES (8, 'Delaware', 'DE'); INSERT INTO `states` VALUES (9, 'District of Columbia', 'DC'); INSERT INTO `states` VALUES (10, 'Florida', 'FL'); INSERT INTO `states` VALUES (11, 'Georgia', 'GA'); INSERT INTO `states` VALUES (12, 'Hawaii', 'HI'); INSERT INTO `states` VALUES (13, 'Idaho', 'ID'); INSERT INTO `states` VALUES (14, 'Illinois', 'IL'); INSERT INTO `states` VALUES (15, 'Indiana', 'IN'); INSERT INTO `states` VALUES (16, 'Iowa', 'IA'); INSERT INTO `states` VALUES (17, 'Kansas', 'KS'); INSERT INTO `states` VALUES (18, 'Kentucky', 'KY'); INSERT INTO `states` VALUES (19, 'Louisiana', 'LA'); INSERT INTO `states` VALUES (20, 'Maine', 'ME'); INSERT INTO `states` VALUES (21, 'Maryland', 'MD'); INSERT INTO `states` VALUES (22, 'Massachusetts', 'MA'); INSERT INTO `states` VALUES (23, 'Michigan', 'MI'); INSERT INTO `states` VALUES (24, 'Minnesota', 'MN'); INSERT INTO `states` VALUES (25, 'Mississippi', 'MS'); INSERT INTO `states` VALUES (26, 'Missouri', 'MO'); INSERT INTO `states` VALUES (27, 'Montana', 'MT'); INSERT INTO `states` VALUES (28, 'Nebraska', 'NE'); INSERT INTO `states` VALUES (29, 'Nevada', 'NV'); INSERT INTO `states` VALUES (30, 'New Hampshire', 'NH'); INSERT INTO `states` VALUES (31, 'New Jersey', 'NJ'); INSERT INTO `states` VALUES (32, 'New Mexico', 'NM'); INSERT INTO `states` VALUES (33, 'New York', 'NY'); INSERT INTO `states` VALUES (34, 'North Carolina', 'NC'); INSERT INTO `states` VALUES (35, 'North Dakota', 'ND'); INSERT INTO `states` VALUES (36, 'Ohio', 'OH'); INSERT INTO `states` VALUES (37, 'Oklahoma', 'OK'); INSERT INTO `states` VALUES (38, 'Oregon', 'OR'); INSERT INTO `states` VALUES (39, 'Pennsylvania', 'PA'); INSERT INTO `states` VALUES (40, 'Rhode Island', 'RI'); INSERT INTO `states` VALUES (41, 'South Carolina', 'SC'); INSERT INTO `states` VALUES (42, 'South Dakota', 'SD'); INSERT INTO `states` VALUES (43, 'Tennessee', 'TN'); INSERT INTO `states` VALUES (44, 'Texas', 'TX'); INSERT INTO `states` VALUES (45, 'Utah', 'UT'); INSERT INTO `states` VALUES (46, 'Vermont', 'VT'); INSERT INTO `states` VALUES (47, 'Virginia', 'VA'); INSERT INTO `states` VALUES (48, 'Washington', 'WA'); INSERT INTO `states` VALUES (49, 'West Virginia', 'WV'); INSERT INTO `states` VALUES (50, 'Wisconsin', 'WI'); INSERT INTO `states` VALUES (51, 'Wyoming', 'WY'); # -------------------------------------------------------- # # Table structure for table `user_addresses` # CREATE TABLE `user_addresses` ( `addID` int(11) NOT NULL auto_increment, `addName` varchar(255) NOT NULL default '', `addStreet1` varchar(255) NOT NULL default '', `addStreet2` varchar(255) NOT NULL default '', `addCity` varchar(100) NOT NULL default '', `f_stateID` int(12) NOT NULL default '0', `addZip` varchar(100) NOT NULL default '', `addCountry` varchar(100) NOT NULL default '', `addPhone` varchar(100) NOT NULL default '', `addShipping` tinyint(1) NOT NULL default '0', `addBilling` tinyint(1) NOT NULL default '0', `f_userID` int(11) NOT NULL default '0', `f_clientID` int(11) NOT NULL default '0', PRIMARY KEY (`addID`), UNIQUE KEY `addID` (`addID`), KEY `addID_2` (`addID`) ) TYPE=MyISAM AUTO_INCREMENT=10 ; # # Dumping data for table `user_addresses` # INSERT INTO `user_addresses` VALUES (7, 'Brandon Griggs', '355 W Chestnut', '#08', 'Lancaster', 39, '17603', 'United States', '717.299.4237', 1, 0, 1, 1); INSERT INTO `user_addresses` VALUES (9, 'Brandon Griggs', '355 W Chestnut', '09', 'Lancaster', 39, '17603', 'United States', '717.299.4237', 0, 1, 1, 1); INSERT INTO `user_addresses` VALUES (5, 'Andrew Martin', '227 lowry rd', '', 'new holland', 39, '17557', 'United States', '717 475 8472', 1, 1, 3, 1); # -------------------------------------------------------- # # Table structure for table `user_payments` # CREATE TABLE `user_payments` ( `payID` int(12) NOT NULL auto_increment, `payName` varchar(100) NOT NULL default '', `payNumber` int(11) NOT NULL default '0', `payCard` varchar(50) NOT NULL default '', `payMonth` int(2) NOT NULL default '0', `payYear` int(4) NOT NULL default '0', `f_userID` int(12) NOT NULL default '0', `f_clientID` int(12) NOT NULL default '0', PRIMARY KEY (`payID`), UNIQUE KEY `payID` (`payID`), KEY `payID_2` (`payID`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Dumping data for table `user_payments` # INSERT INTO `user_payments` VALUES (1, 'Brandon Griggs', 0, 'Visa', 1, 2006, 1, 1); # -------------------------------------------------------- # # Table structure for table `users` # CREATE TABLE `users` ( `userID` int(11) NOT NULL auto_increment, `userEmail` varchar(100) NOT NULL default '', `userPassword` varchar(25) NOT NULL default '', `userFname` varchar(50) NOT NULL default '', `userLname` varchar(50) NOT NULL default '', `userNname` varchar(50) default NULL, `userStatus` varchar(50) NOT NULL default 'New', `userDate` tinyint(3) unsigned NOT NULL default '0', `userStart` int(15) default NULL, `userEnd` int(15) default NULL, `userSince` int(11) NOT NULL default '0', `userActive` tinyint(3) unsigned NOT NULL default '1', `f_clientID` int(11) NOT NULL default '1', PRIMARY KEY (`userID`), UNIQUE KEY `adminID` (`userID`), KEY `adminID_2` (`userID`), KEY `f_clientID` (`f_clientID`) ) TYPE=MyISAM AUTO_INCREMENT=20 ; # # Dumping data for table `users` # INSERT INTO `users` VALUES (1, 'rbg@50units.com', 'rabdoog', 'Brandon', 'Griggs', NULL, 'new', 0, NULL, NULL, 1049030400, 1, 1); INSERT INTO `users` VALUES (3, 'andrew@sitestrux.com', 'redfirefly', 'andrew', 'martin', NULL, 'new', 0, NULL, NULL, 1049163180, 1, 1); INSERT INTO `users` VALUES (19, 'rbg@atrio-inc.com', 'aftersdeft', 'Brandon', 'Griggs', NULL, 'new', 0, NULL, NULL, 1049772600, 1, 1);