-- 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`
--