SQL

-- 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');