-- phpMyAdmin SQL Dump
-- version 2.8.2.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 07, 2007 at 10:44 PM
-- Server version: 5.0.24
-- PHP Version: 4.4.3
-- 
-- Database: `pg340`
-- 

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

-- 
-- Table structure for table `articles`
-- 

CREATE TABLE `articles` (
  `articleId` mediumint(8) unsigned NOT NULL auto_increment,
  `title` char(150) NOT NULL,
  `article` text NOT NULL,
  `categoryId` mediumint(8) unsigned NOT NULL,
  `added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`articleId`),
  KEY `categoryId` (`categoryId`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `articles`
-- 

INSERT INTO `articles` (`articleId`, `title`, `article`, `categoryId`, `added`) VALUES (1, 'test ersafkk', 'asdjjjkk', 1, '2007-10-07 14:21:20'),
(2, 'asles', 'asdfa', 2, '2007-10-07 14:21:38');

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

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `categoryId` mediumint(8) unsigned NOT NULL auto_increment,
  `title` char(100) NOT NULL,
  PRIMARY KEY  (`categoryId`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` (`categoryId`, `title`) VALUES (1, 'PHP'),
(2, 'MySQL'),
(3, 'Privat'),
(4, 'Moro');