-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 24, 2008 at 03:52 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
-- 
-- Database: `content`
-- 

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

-- 
-- Table structure for table `content`
-- 

CREATE TABLE `content` (
  `cont_id` int(3) NOT NULL auto_increment,
  `cat_id` int(3) NOT NULL,
  `dt` date NOT NULL,
  `title` varchar(250) NOT NULL,
  `short_dtl` text,
  `dtl` text NOT NULL,
  UNIQUE KEY `cont_id` (`cont_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `content`
-- 

INSERT INTO `content` VALUES (2, 7, '2002-02-07', 'Title here only', 'short description short description short description short description ', 'Full Detail here Full Detail hereFull Detail hereFull Detail here');
INSERT INTO `content` VALUES (3, 6, '2002-05-07', 'Introduction to ASP', 'Learn how to install and use ASP in your website ', 'ASP is only one environment and it mostly uses VBscript as a scripting language. We can handle server side jobs by using ASP. ');
INSERT INTO `content` VALUES (4, 5, '2007-02-28', 'JavaScript tutorial ', 'JavaScript tutorial and other scripts', 'JavaScript is a popular client side tool to handle form inputs, layers and many other tasks. ');
INSERT INTO `content` VALUES (5, 7, '2007-02-28', 'Data display from MySQL table', 'Collecting records from MySQL\r\n', 'First we have to connect to MySQL table and then by applying select query we can get data from MySQL table. ');

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

-- 
-- Table structure for table `content_admin`
-- 

CREATE TABLE `content_admin` (
  `admin_id` varchar(8) NOT NULL,
  `admin_pw` varchar(8) NOT NULL,
  UNIQUE KEY `admin_id` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `content_admin`
-- 

INSERT INTO `content_admin` VALUES ('admin', 'test');

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

-- 
-- Table structure for table `content_cat`
-- 

CREATE TABLE `content_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `name` varchar(250) NOT NULL,
  UNIQUE KEY `cat_id` (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `content_cat`
-- 

INSERT INTO `content_cat` VALUES (5, 'JavaScript tutorial');
INSERT INTO `content_cat` VALUES (6, 'ASP tutorial');
INSERT INTO `content_cat` VALUES (7, 'PHP MySQL tutorail');
INSERT INTO `content_cat` VALUES (8, 'HTML tutorial');
INSERT INTO `content_cat` VALUES (9, 'Search engine Optimization');

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

-- 
-- Table structure for table `content_cmt_post`
-- 

CREATE TABLE `content_cmt_post` (
  `post_id` int(5) NOT NULL auto_increment,
  `p_name` varchar(100) NOT NULL,
  `dt` date NOT NULL default '0000-00-00',
  `name` varchar(25) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `dtl` text NOT NULL,
  `status` varchar(4) NOT NULL default 'ns',
  UNIQUE KEY `post_id` (`post_id`,`p_name`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

-- 
-- Dumping data for table `content_cmt_post`
-- 

