-- phpMyAdmin SQL Dump -- version 2.11.7.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 11, 2009 at 03:13 PM -- Server version: 5.0.41 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `database_name` -- -- -------------------------------------------------------- -- -- Table structure for table `articles` -- CREATE TABLE `articles` ( `id` int(10) unsigned NOT NULL auto_increment, `body` text, `title` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `articles` -- INSERT INTO `articles` VALUES(1, 'Body Text 1', 'Title Text 1'); INSERT INTO `articles` VALUES(2, 'Body Test 2', 'Title Text 2'); -- -------------------------------------------------------- -- -- Table structure for table `images` -- CREATE TABLE `images` ( `id` int(10) unsigned NOT NULL auto_increment, `table_id` int(10) unsigned NOT NULL, `table_name` varchar(50) NOT NULL, `source` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `images` -- INSERT INTO `images` VALUES(1, 1, 'articles', 'image1a.jpg'); INSERT INTO `images` VALUES(2, 1, 'articles', 'image1b.jpg'); INSERT INTO `images` VALUES(3, 2, 'articles', 'image2a.jpg');