--
-- Table structure for table `nComponent`
--

CREATE TABLE IF NOT EXISTS `nComponent` (
  `nID` int(11) NOT NULL auto_increment,
  `nName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `nDesc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nActive` tinyint(4) NOT NULL default '1',
  `nTypeLimit` enum('Homepage','Content','Search','Link') NOT NULL,
  `nCompFile` varchar(255) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nContent`
--

CREATE TABLE IF NOT EXISTS `nContent` (
  `nID` int(11) NOT NULL auto_increment,
  `nText` text COLLATE utf8_unicode_ci NOT NULL,
  `nTextarea` text COLLATE utf8_unicode_ci NOT NULL,
  `nLinkID` varchar(255) NOT NULL,
  `nImgID` int(255) NOT NULL,
  `nOrderID` int(11) NOT NULL default '1',
  PRIMARY KEY  (`nID`),
  FULLTEXT KEY `nSearchIndex` (`nText`,`nTextarea`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nEditor`
--

CREATE TABLE IF NOT EXISTS `nEditor` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nUser` varchar(50) NOT NULL,
  `nPass` varchar(16) NOT NULL,
  `nAccessPages` tinyint(4) NOT NULL DEFAULT '1',
  `nAccessLibrary` tinyint(4) NOT NULL DEFAULT '0',
  `nAccessSettings` tinyint(4) NOT NULL DEFAULT '0',
  `nAdmin` tinyint(1) NOT NULL DEFAULT '0',
  `nLastLoginDate` datetime DEFAULT NULL,
  `nEmail` varchar(100) NOT NULL,
  `nLoginToken` varchar(64) NOT NULL,
  `nTokenDate` datetime NOT NULL,
  `nUserLang` varchar(50) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nFile`
--

CREATE TABLE IF NOT EXISTS `nFile` (
  `nID` int(11) NOT NULL auto_increment,
  `nPath` varchar(255) NOT NULL,
  `nType` varchar(255) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nImage`
--

CREATE TABLE IF NOT EXISTS `nImage` (
  `nID` int(11) NOT NULL auto_increment,
  `nPath` varchar(255) NOT NULL,
  `nPathOver` varchar(255) NOT NULL,
  `nPathEnlarge` varchar(255) NOT NULL,
  `nRelID` int(11) NOT NULL,
  `nType` varchar(255) NOT NULL DEFAULT 'Content',
  `nTitle` varchar(255) NOT NULL,
  `nCaption` text NOT NULL,
  `nOrderID` int(11) NOT NULL default '1',
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nImageSizingOptions`
--

CREATE TABLE IF NOT EXISTS `nImageSizingOptions` (
  `nID` int(11) NOT NULL auto_increment,
  `nName` varchar(100) NOT NULL,
  `nWidth` smallint(6) NOT NULL default '0',
  `nCropWidth` smallint(6) NOT NULL default '0',
  `nHeight` smallint(6) NOT NULL default '0',
  `nCropHeight` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nLibrary`
--

CREATE TABLE IF NOT EXISTS `nLibrary` (
  `nID` int(11) NOT NULL auto_increment,
  `nName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nType` varchar(50) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nLoginLog`
--

CREATE TABLE IF NOT EXISTS `nLoginLog` (
  `nID` int(11) NOT NULL auto_increment,
  `nIP` varchar(20) NOT NULL default '',
  `nUsr` varchar(50) NOT NULL default '',
  `nPwd` varchar(50) NOT NULL default '',
  `nAccessDate` datetime NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nPage`
--

CREATE TABLE IF NOT EXISTS `nPage` (
  `nID` int(11) NOT NULL auto_increment,
  `nNavTitle` varchar(50) NOT NULL,
  `nTitle` varchar(255) NOT NULL,
  `nBGColor` varchar(7) NOT NULL,
  `nBaseColor` varchar(7) NOT NULL default '#bac870',
  `nBackBGColor` varchar(7) NOT NULL default '#ebefd6',
  `nBGImgID` int(255) NOT NULL,
  `nType` varchar(50) NOT NULL default 'Content',
  `nSectionID` int(11) NOT NULL,
  `nOrderID` int(11) NOT NULL default '1',
  `nLocked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`nID`),
  FULLTEXT KEY `nNavTitle` (`nNavTitle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nPageType`
--

CREATE TABLE IF NOT EXISTS `nPageType` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `nCode` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `nAllowMultiple` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `nPageType`
--

INSERT INTO `nPageType` (`nID`, `nName`, `nCode`, `nAllowMultiple`) VALUES
(1, 'Homepage', 'Homepage', 0),
(2, 'Search', 'Search', 0),
(3, 'Content', 'Content', 1);

-- --------------------------------------------------------

--
-- Table structure for table `nPluginComp`
--

CREATE TABLE IF NOT EXISTS `nPluginComp` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nPluginID` varchar(50) NOT NULL,
  `nCompCode` varchar(255) NOT NULL,
  `nFilePath` varchar(255) NOT NULL,
  `nFunction` varchar(255) NOT NULL,
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nPluginComp`
--


-- --------------------------------------------------------

--
-- Table structure for table `nPluginInclusionPoint`
--

CREATE TABLE IF NOT EXISTS `nPluginInclusionPoint` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nPluginID` varchar(50) NOT NULL,
  `nInclusionType` varchar(50) NOT NULL,
  `nInclusionPoint` varchar(50) NOT NULL,
  `nSetting1` text NOT NULL,
  `nSetting2` text NOT NULL,
  `nSetting3` text NOT NULL,
  `nSetting4` text NOT NULL,
  `nSetting5` text NOT NULL,
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nPluginInclusionPoint`
--


-- --------------------------------------------------------

--
-- Table structure for table `nPluginNav`
--

CREATE TABLE IF NOT EXISTS `nPluginNav` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nPluginID` varchar(50) NOT NULL,
  `nNavName` varchar(255) NOT NULL,
  `nNavPage` varchar(255) NOT NULL,
  `nNavType` varchar(100) NOT NULL,
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nPluginNav`
--


-- --------------------------------------------------------

--
-- Table structure for table `nPlugins`
--

CREATE TABLE IF NOT EXISTS `nPlugins` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nPluginID` varchar(50) NOT NULL,
  `nName` varchar(50) NOT NULL,
  `nDesc` text NOT NULL,
  `nAuthor` varchar(50) NOT NULL,
  `nURL` varchar(255) NOT NULL,
  `nAuthorURL` varchar(255) NOT NULL,
  `nVersion` varchar(16) NOT NULL,
  `nActive` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nPlugins`
--


-- --------------------------------------------------------

--
-- Table structure for table `nPluginSettingsForm`
--

CREATE TABLE IF NOT EXISTS `nPluginSettingsForm` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nPluginID` varchar(50) NOT NULL,
  `nFunction` varchar(255) NOT NULL,
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nPluginSettingsForm`
--


-- --------------------------------------------------------

--
-- Table structure for table `nSection`
--

CREATE TABLE IF NOT EXISTS `nSection` (
  `nID` int(11) NOT NULL auto_increment,
  `nName` varchar(50) NOT NULL,
  `nParentID` int(11) NOT NULL default '0',
  `nLocked` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nSettings`
--

CREATE TABLE IF NOT EXISTS `nSettings` (
  `nID` int(11) NOT NULL auto_increment,
  `nSetting` varchar(50) NOT NULL,
  `nValue` varchar(255) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nSystemEventLog`
--

CREATE TABLE IF NOT EXISTS `nSystemEventLog` (
  `nID` int(11) NOT NULL AUTO_INCREMENT,
  `nEventTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nEventDesc` text COLLATE utf8_unicode_ci NOT NULL,
  `nEditorUser` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nTrackInfo`
--

CREATE TABLE IF NOT EXISTS `nTrackInfo` (
  `nSessionID` varchar(255) NOT NULL,
  `nLastAccessDate` datetime NOT NULL,
  `nLoggedIn` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`nSessionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `nTranslate`
--

CREATE TABLE IF NOT EXISTS `nTranslate` (
  `nID` int(11) NOT NULL auto_increment,
  `nLang` varchar(100) NOT NULL default '',
  `nItemID` int(11) NOT NULL default '0',
  `nType` enum('comp','section','page') NOT NULL default 'comp',
  `nText` text COLLATE utf8_unicode_ci NOT NULL,
  `nTextarea` text COLLATE utf8_unicode_ci NOT NULL,
  `nLinkID` varchar(255) NOT NULL,
  `nImgID` int(255) NOT NULL,
  `nOrderID` int(11) NOT NULL default '1',
  PRIMARY KEY  (`nID`),
  FULLTEXT KEY `nTranslateIndex` (`nText`,`nTextarea`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `nVisitLog`
--

CREATE TABLE IF NOT EXISTS `nVisitLog` (
  `nID` int(11) NOT NULL auto_increment,
  `nIP` varchar(15) NOT NULL,
  `nAccessDate` date NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xComponentPage`
--

CREATE TABLE IF NOT EXISTS `xComponentPage` (
  `nID` int(11) NOT NULL auto_increment,
  `nComponentID` varchar(50) NOT NULL,
  `nPageID` int(11) NOT NULL,
  `nColumnID` int(11) NOT NULL,
  `nOrderID` int(11) NOT NULL default '1',
  `nContentID` int(11) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `xEditorPage`
--

CREATE TABLE IF NOT EXISTS `xEditorPage` (
  `nID` int(11) NOT NULL auto_increment,
  `nEditorID` int(11) NOT NULL,
  `nPageID` int(11) NOT NULL,
  PRIMARY KEY  (`nID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
