# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 08, 2003 at 06:14 PM
# Server version: 4.0.13
# PHP Version: 4.2.3
# Database : `nonplus_test`
# --------------------------------------------------------

#
# Table structure for table `mt_category`
#

CREATE TABLE mt_category (
  category_id int(11) NOT NULL auto_increment,
  category_label varchar(100) NOT NULL default '',
  PRIMARY KEY  (category_id),
  UNIQUE KEY category_blog_id (category_label)
) TYPE=MyISAM;

#
# Dumping data for table `mt_category`
#

INSERT INTO mt_category VALUES (1, 'Tips');
INSERT INTO mt_category VALUES (2, 'Templates');
INSERT INTO mt_category VALUES (3, 'Filters');
INSERT INTO mt_category VALUES (4, 'Plugins');
INSERT INTO mt_category VALUES (8, 'Hacks');
INSERT INTO mt_category VALUES (9, 'Downloads');
INSERT INTO mt_category VALUES (19, 'CGIs');
# --------------------------------------------------------

#
# Table structure for table `mt_entry`
#

CREATE TABLE mt_entry (
  entry_id int(11) NOT NULL auto_increment,
  entry_category_id int(11) default NULL,
  entry_title varchar(255) default NULL,
  entry_created_on datetime NOT NULL default '0000-00-00 00:00:00',
  entry_modified_on timestamp(14) NOT NULL,
  PRIMARY KEY  (entry_id),
  KEY entry_created_on (entry_created_on)
) TYPE=MyISAM;

#
# Dumping data for table `mt_entry`
#

INSERT INTO mt_entry VALUES (1, NULL, 'excerpt_words', '2002-12-31 10:10:18', 20030426103241);
INSERT INTO mt_entry VALUES (2, NULL, 'filename', '2002-12-31 11:48:15', 20030507124927);
INSERT INTO mt_entry VALUES (8, NULL, 'Global Listings', '2003-01-03 14:55:32', 20030119164324);
INSERT INTO mt_entry VALUES (530, NULL, 'MTEntryIfComments', '2003-01-08 18:31:51', 20030226111458);
INSERT INTO mt_entry VALUES (541, NULL, 'MTPaginate', '2003-01-12 15:12:55', 20030401183621);
INSERT INTO mt_entry VALUES (542, NULL, 'Dynamic Pages', '2003-01-13 08:00:56', 20030120134513);
INSERT INTO mt_entry VALUES (545, NULL, 'Importing DotComments', '2003-01-15 14:55:46', 20030117093906);
INSERT INTO mt_entry VALUES (548, NULL, 'Perl API', '2003-01-21 12:26:17', 20030304091035);
INSERT INTO mt_entry VALUES (561, NULL, 'MTGrid', '2003-01-28 23:09:20', 20030618092457);
INSERT INTO mt_entry VALUES (569, NULL, 'MTTemplate', '2003-02-05 19:59:01', 20030317100950);
INSERT INTO mt_entry VALUES (576, NULL, 'Unrecognized Tag Warning', '2003-02-19 10:21:51', 20030416204920);
INSERT INTO mt_entry VALUES (577, NULL, 'Multipage Search Results', '2003-02-20 20:59:50', 20030223185612);
INSERT INTO mt_entry VALUES (582, NULL, 'MTElse Fix For Plugins', '2003-02-27 09:40:03', 20030227095523);
INSERT INTO mt_entry VALUES (584, NULL, 'MTCgi', '2003-02-28 22:40:27', 20030228234019);
INSERT INTO mt_entry VALUES (585, NULL, 'General Purpose Search Template', '2003-02-28 23:16:32', 20030228233437);
INSERT INTO mt_entry VALUES (587, NULL, 'Rebuild Entry', '2003-03-05 09:26:42', 20030305103056);
INSERT INTO mt_entry VALUES (595, NULL, 'Custom Dynamic Pages', '2003-03-14 09:10:56', 20030707090320);
INSERT INTO mt_entry VALUES (615, NULL, 'Avoiding Duplicate Comments', '2003-04-09 09:55:13', 20030501095257);
INSERT INTO mt_entry VALUES (619, NULL, 'MTTimer', '2003-04-14 18:24:32', 20030414184119);
INSERT INTO mt_entry VALUES (628, NULL, 'MTObfuscate', '2003-04-24 18:30:01', 20030424184112);
INSERT INTO mt_entry VALUES (629, NULL, 'MTRSSFeedDate', '2003-04-24 18:34:26', 20030424183526);
INSERT INTO mt_entry VALUES (630, NULL, 'MT-Medic', '2003-04-26 10:29:36', 20030623165609);
INSERT INTO mt_entry VALUES (640, NULL, 'MTIncludePlus', '2003-05-10 08:43:17', 20030514201334);
INSERT INTO mt_entry VALUES (641, NULL, 'MTCollate', '2003-05-12 18:24:36', 20030512192334);
INSERT INTO mt_entry VALUES (644, NULL, 'MTRelativeURL', '2003-05-20 15:43:04', 20030520190111);
INSERT INTO mt_entry VALUES (680, NULL, 'Custom Entry Preview', '2003-05-30 18:30:11', 20030707101126);
INSERT INTO mt_entry VALUES (681, NULL, 'Limiting Search To Specific Fields', '2003-05-31 18:02:18', 20030531180932);
INSERT INTO mt_entry VALUES (684, NULL, 'MTFastInclude', '2003-06-04 16:23:06', 20030609122934);
INSERT INTO mt_entry VALUES (685, NULL, 'Limiting Search To Specific Category', '2003-06-04 18:43:37', 20030604184344);
INSERT INTO mt_entry VALUES (686, NULL, 'MTCategoryOfArchive', '2003-06-08 12:49:44', 20030613175157);
INSERT INTO mt_entry VALUES (691, NULL, 'Per-Category Templates', '2003-06-13 18:48:58', 20030613190035);
INSERT INTO mt_entry VALUES (693, NULL, 'MTException', '2003-06-13 21:20:05', 20030613215721);
INSERT INTO mt_entry VALUES (699, NULL, 'MTOptimizeHTML', '2003-06-19 18:47:16', 20030619235643);
INSERT INTO mt_entry VALUES (700, NULL, 'MT-Mail-Entry', '2003-06-23 17:40:15', 20030623182058);
# --------------------------------------------------------

#
# Table structure for table `mt_placement`
#

CREATE TABLE mt_placement (
  placement_id int(11) NOT NULL auto_increment,
  placement_entry_id int(11) NOT NULL default '0',
  placement_category_id int(11) NOT NULL default '0',
  PRIMARY KEY  (placement_id),
  KEY placement_entry_id (placement_entry_id),
  KEY placement_category_id (placement_category_id)
) TYPE=MyISAM;

#
# Dumping data for table `mt_placement`
#

INSERT INTO mt_placement VALUES (1, 1, 4);
INSERT INTO mt_placement VALUES (2, 2, 4);
INSERT INTO mt_placement VALUES (3, 8, 4);
INSERT INTO mt_placement VALUES (4, 530, 4);
INSERT INTO mt_placement VALUES (13, 541, 4);
INSERT INTO mt_placement VALUES (14, 542, 1);
INSERT INTO mt_placement VALUES (15, 545, 1);
INSERT INTO mt_placement VALUES (16, 548, 1);
INSERT INTO mt_placement VALUES (27, 561, 4);
INSERT INTO mt_placement VALUES (28, 569, 4);
INSERT INTO mt_placement VALUES (29, 576, 8);
INSERT INTO mt_placement VALUES (30, 569, 9);
INSERT INTO mt_placement VALUES (31, 561, 9);
INSERT INTO mt_placement VALUES (32, 541, 9);
INSERT INTO mt_placement VALUES (33, 530, 9);
INSERT INTO mt_placement VALUES (34, 8, 9);
INSERT INTO mt_placement VALUES (35, 2, 9);
INSERT INTO mt_placement VALUES (36, 1, 9);
INSERT INTO mt_placement VALUES (37, 577, 1);
INSERT INTO mt_placement VALUES (38, 582, 8);
INSERT INTO mt_placement VALUES (39, 584, 4);
INSERT INTO mt_placement VALUES (40, 585, 1);
INSERT INTO mt_placement VALUES (41, 584, 9);
INSERT INTO mt_placement VALUES (42, 587, 8);
INSERT INTO mt_placement VALUES (43, 595, 8);
INSERT INTO mt_placement VALUES (45, 615, 8);
INSERT INTO mt_placement VALUES (50, 628, 4);
INSERT INTO mt_placement VALUES (49, 619, 9);
INSERT INTO mt_placement VALUES (48, 619, 4);
INSERT INTO mt_placement VALUES (51, 628, 9);
INSERT INTO mt_placement VALUES (52, 629, 4);
INSERT INTO mt_placement VALUES (53, 629, 9);
INSERT INTO mt_placement VALUES (54, 630, 19);
INSERT INTO mt_placement VALUES (55, 630, 9);
INSERT INTO mt_placement VALUES (57, 640, 4);
INSERT INTO mt_placement VALUES (58, 640, 9);
INSERT INTO mt_placement VALUES (59, 641, 9);
INSERT INTO mt_placement VALUES (60, 641, 4);
INSERT INTO mt_placement VALUES (61, 644, 4);
INSERT INTO mt_placement VALUES (62, 644, 9);
INSERT INTO mt_placement VALUES (101, 685, 8);
INSERT INTO mt_placement VALUES (97, 680, 8);
INSERT INTO mt_placement VALUES (98, 681, 8);
INSERT INTO mt_placement VALUES (100, 684, 4);
INSERT INTO mt_placement VALUES (102, 684, 9);
INSERT INTO mt_placement VALUES (103, 686, 4);
INSERT INTO mt_placement VALUES (104, 686, 9);
INSERT INTO mt_placement VALUES (109, 691, 1);
INSERT INTO mt_placement VALUES (110, 693, 4);
INSERT INTO mt_placement VALUES (111, 693, 9);
INSERT INTO mt_placement VALUES (113, 699, 4);
INSERT INTO mt_placement VALUES (114, 699, 9);
INSERT INTO mt_placement VALUES (115, 700, 19);
INSERT INTO mt_placement VALUES (116, 700, 9);