rendered paste body-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 30, 2006 at 05:23 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `derek_vb36`
--
-- --------------------------------------------------------
--
-- Table structure for table `cblogs_blogread`
--
CREATE TABLE `cblogs_blogread` (
`userid` int(10) unsigned NOT NULL default '0',
`blogid` smallint(5) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`blogid`,`userid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `cblogs_blogread`
--
INSERT INTO `cblogs_blogread` VALUES (5, 1, 1162159968);
INSERT INTO `cblogs_blogread` VALUES (1, 1, 1161901535);
-- --------------------------------------------------------
--
-- Table structure for table `cblogs_blogs`
--
CREATE TABLE `cblogs_blogs` (
`blogid` int(10) unsigned NOT NULL auto_increment,
`blogname` varchar(255) collate latin1_general_ci NOT NULL default '',
`blogdescription` mediumtext collate latin1_general_ci NOT NULL,
`bloggerid` int(10) unsigned NOT NULL default '0',
`blogger` varchar(100) collate latin1_general_ci NOT NULL default '',
`blogdate` int(10) unsigned NOT NULL default '0',
`blogtype` int(1) unsigned NOT NULL default '1',
`blogurl` varchar(255) collate latin1_general_ci NOT NULL default '',
`totalentries` int(10) unsigned NOT NULL default '0',
`totalviews` int(10) unsigned NOT NULL default '0',
`totalcomments` int(10) unsigned NOT NULL default '0',
`lastentry_title` varchar(255) collate latin1_general_ci NOT NULL default '',
`lastentry_date` int(10) unsigned NOT NULL default '0',
`lastentryid` int(10) unsigned NOT NULL default '0',
`lastcomment_title` varchar(255) collate latin1_general_ci NOT NULL default '',
`lastcomment_date` int(10) unsigned NOT NULL default '0',
`lastcommentid` int(10) unsigned NOT NULL default '0',
`private` tinyint(1) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '0',
`allowedusers` mediumtext collate latin1_general_ci NOT NULL,
`viewableby` tinyint(1) unsigned NOT NULL default '0',
`votenum` int(10) unsigned NOT NULL default '0',
`votetotal` int(10) unsigned NOT NULL default '0',
`blockdata` mediumtext collate latin1_general_ci NOT NULL,
PRIMARY KEY (`blogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `cblogs_blogs`
--
INSERT INTO `cblogs_blogs` VALUES (1, 'Derek Blog', 'This is a test blog... Here is the description.', 1, 'Derek', 1161649489, 1, '', 0, 0, 0, '', 0, 0, '', 0, 0, 0, 1, '', 0, 0, 0, '');
INSERT INTO `cblogs_blogs` VALUES (2, 'Testing....', 'This is just a test.', 1, 'Derek', 1162006178, 1, '', 0, 0, 0, '', 0, 0, '', 0, 0, 0, 0, '1,5,2,3', 3, 0, 0, '');
INSERT INTO `cblogs_blogs` VALUES (3, 'Cole''s Sweet Blog1', 'Teh sweetness is sweetness.', 5, 'Cole', 1162006245, 1, '', 0, 0, 0, '', 0, 0, '', 0, 0, 0, 0, '1', 3, 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `cblogs_comments`
--
CREATE TABLE `cblogs_comments` (
`commentid` int(10) unsigned NOT NULL auto_increment,
`subject` varchar(255) collate latin1_general_ci NOT NULL default '',
`comment` mediumtext collate latin1_general_ci NOT NULL,
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) collate latin1_general_ci NOT NULL default '',
`entryid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`commentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cblogs_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `cblogs_entries`
--
CREATE TABLE `cblogs_entries` (
`entryid` int(10) unsigned NOT NULL auto_increment,
`entrytitle` varchar(255) collate latin1_general_ci NOT NULL default '',
`entrytext` mediumtext collate latin1_general_ci NOT NULL,
`categoryid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) collate latin1_general_ci NOT NULL default '',
`viewableby` tinyint(1) unsigned NOT NULL default '0',
`blogid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`entryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cblogs_entries`
--