| 1 |
-- phpMyAdmin SQL Dump |
| 2 |
-- version 3.2.3 |
| 3 |
-- http://www.phpmyadmin.net |
| 4 |
-- |
| 5 |
-- Host: localhost |
| 6 |
-- Generation Time: Feb 25, 2010 at 09:31 PM |
| 7 |
-- Server version: 5.1.37 |
| 8 |
-- PHP Version: 5.2.10-2ubuntu6.4 |
| 9 |
|
| 10 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 |
|
| 12 |
-- |
| 13 |
-- Database: `test` |
| 14 |
-- |
| 15 |
CREATE DATABASE `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; |
| 16 |
USE `test`; |
| 17 |
|
| 18 |
-- -------------------------------------------------------- |
| 19 |
|
| 20 |
-- |
| 21 |
-- Table structure for table `node` |
| 22 |
-- |
| 23 |
|
| 24 |
CREATE TABLE IF NOT EXISTS `node` ( |
| 25 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 26 |
`title` varchar(255) DEFAULT NULL, |
| 27 |
`video_url` varchar(255) DEFAULT NULL, |
| 28 |
PRIMARY KEY (`id`) |
| 29 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ; |
| 30 |
|
| 31 |
-- |
| 32 |
-- Dumping data for table `node` |
| 33 |
-- |
| 34 |
|
| 35 |
|
| 36 |
-- -------------------------------------------------------- |
| 37 |
|
| 38 |
-- |
| 39 |
-- Table structure for table `nodes` |
| 40 |
-- |
| 41 |
|
| 42 |
CREATE TABLE IF NOT EXISTS `nodes` ( |
| 43 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 44 |
`title` varchar(255) DEFAULT NULL, |
| 45 |
`body` text, |
| 46 |
PRIMARY KEY (`id`) |
| 47 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; |
| 48 |
|
| 49 |
-- |
| 50 |
-- Dumping data for table `nodes` |
| 51 |
-- |
| 52 |
|
| 53 |
INSERT INTO `nodes` (`id`, `title`, `body`) VALUES |
| 54 |
(1, 'title 1', 'body corresponding to title 1'), |
| 55 |
(2, 'title 2', 'body corresponding to title 2'), |
| 56 |
(3, 'title 3', 'body corresponding to title 3'), |
| 57 |
(4, 'title 4', 'body corresponding to title 4'), |
| 58 |
(5, 'title 5', 'body corresponding to title 5'), |
| 59 |
(6, 'title 6', 'body corresponding to title 6'), |
| 60 |
(7, 'title 7', 'body corresponding to title 7'), |
| 61 |
(8, 'title 8', 'body corresponding to title 8'), |
| 62 |
(9, 'title 9', 'body corresponding to title 9'); |