-- phpMyAdmin SQL Dump
-- version 2.11.6
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 24, 2009 at 10:21 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `lmfao`
--
-- --------------------------------------------------------
--
-- Table structure for table `web_bcomments`
--
CREATE TABLE `web_bcomments` (
`id` int(10) NOT NULL auto_increment,
`bid` int(10) NOT NULL,
`author` varchar(16) NOT NULL,
`feedback` int(1) NOT NULL,
`date` varchar(32) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `web_bcomments`
--
-- --------------------------------------------------------
--
-- Table structure for table `web_ecomments`
--
CREATE TABLE `web_ecomments` (
`id` int(10) NOT NULL auto_increment,
`eid` int(10) NOT NULL,
`author` varchar(16) NOT NULL,
`feedback` int(1) NOT NULL,
`date` varchar(32) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `web_ecomments`
--
-- --------------------------------------------------------
--
-- Table structure for table `web_events`
--
CREATE TABLE `web_events` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`author` varchar(16) NOT NULL,
`date` varchar(32) NOT NULL,
`type` varchar(100) NOT NULL,
`status` varchar(32) NOT NULL,
`content` text NOT NULL,
`views` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `web_events`
--
INSERT INTO `web_events` (`id`, `title`, `author`, `date`, `type`, `status`, `content`, `views`) VALUES
(1, 'There is smth wrong', '', '', '', '', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `web_gmblog`
--
CREATE TABLE `web_gmblog` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`author` varchar(16) NOT NULL,
`date` varchar(32) NOT NULL,
`content` text NOT NULL,
`views` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `web_gmblog`
--
-- --------------------------------------------------------
--
-- Table structure for table `web_ncomments`
--
CREATE TABLE `web_ncomments` (
`id` int(10) NOT NULL auto_increment,
`nid` int(10) NOT NULL,
`author` varchar(16) NOT NULL,
`feedback` int(1) NOT NULL,
`date` varchar(32) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `web_ncomments`
--
-- --------------------------------------------------------
--
-- Table structure for table `web_news`
--
CREATE TABLE `web_news` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`author` varchar(16) NOT NULL,
`date` varchar(32) NOT NULL,
`type` varchar(50) NOT NULL,
`content` text NOT NULL,
`views` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `web_news`
--
INSERT INTO `web_news` (`id`, `title`, `author`, `date`, `type`, `content`, `views`) VALUES
(1, 'LOL IS there smth wrong?', 'UberSango', '01.24', 'ct_news_notice_notice', 'Lmfao.', 3);
-- --------------------------------------------------------
--
-- Table structure for table `web_pcomments`
--
CREATE TABLE `web_pcomments` (
`id` int(10) NOT NULL auto_increment,
`accountid` int(10) NOT NULL,
`commenter` varchar(16) NOT NULL,
`feedback` int(1) NOT NULL,
`date` varchar(32) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `web_pcomments`
--
-- --------------------------------------------------------
--
-- Table structure for table `web_profile`
--
CREATE TABLE `web_profile` (
`id` int(10) NOT NULL auto_increment,
`accountid` int(10) NOT NULL,
`name` varchar(16) NOT NULL,
`mainchar` int(10) NOT NULL,
`realname` varchar(32) NOT NULL,
`age` int(2) NOT NULL,
`country` varchar(100) NOT NULL,
`motto` varchar(255) NOT NULL,
`favjob` varchar(50) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `web_profile`
--
INSERT INTO `web_profile` (`id`, `accountid`, `name`, `mainchar`, `realname`, `age`, `country`, `motto`, `favjob`, `text`) VALUES
(2, 2, 'UberSango', 0, 'Justin', 15, 'SG', 'i love java', 'Hero', 'lmfao');
-- --------------------------------------------------------
--
-- Table structure for table `web_qcomments`
--
CREATE TABLE `web_qcomments` (
`id` int(10) NOT NULL auto_increment,
`nid` int(10) NOT NULL,
`author` varchar(16) NOT NULL,
`feedback` int(1) NOT NULL,
`date` varchar(32) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `web_qcomments`
--
INSERT INTO `web_qcomments` (`id`, `nid`, `author`, `feedback`, `date`, `comment`) VALUES
(1, 1, 'UberSango', 1, '01-24-09 8:32 AM', 'Owned.');
-- --------------------------------------------------------
--
-- Table structure for table `web_qoftheday`
--
CREATE TABLE `web_qoftheday` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`author` varchar(16) NOT NULL,
`date` varchar(32) NOT NULL,
`type` varchar(50) NOT NULL,
`content` text NOT NULL,
`views` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `web_qoftheday`
--
INSERT INTO `web_qoftheday` (`id`, `title`, `author`, `date`, `type`, `content`, `views`) VALUES
(1, 'A sick joke', 'UberSango', '01.24', 'ct_news_notice_notice', 'You serious Sango''s Maplesea IGN is ''x3BangGirls''?', 11);