-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 15, 2006 at 11:42 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
-- 
-- Database: `noddybo_nbsql`
-- 
CREATE DATABASE `noddybo_nbsql`;
USE noddybo_nbsql;

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

-- 
-- Table structure for table `download`
-- 

CREATE TABLE `download` (
  `name` varchar(255) NOT NULL default '',
  `count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `download`
-- 

INSERT INTO `download` VALUES ('Shockwave-1.1.zip', 1);
INSERT INTO `download` VALUES ('CSFTP-V1.0.zip', 3);
INSERT INTO `download` VALUES ('CSFTP-src-V1.0.zip', 1);
INSERT INTO `download` VALUES ('gbagfx-src-v0.2p1.zip', 1);
INSERT INTO `download` VALUES ('gbagfx-v0.2p1.zip', 1);
INSERT INTO `download` VALUES ('gba-example.zip', 2);
INSERT INTO `download` VALUES ('noddybox.V2.1.mod.zip', 1);
INSERT INTO `download` VALUES ('lunar-X11-V1.4.tar.gz', 2);
INSERT INTO `download` VALUES ('noddybox.V2.2.mod.zip', 2);
INSERT INTO `download` VALUES ('gbagfx-help-v0.2p1.zip', 2);
INSERT INTO `download` VALUES ('gba-example-bin.zip', 1);
INSERT INTO `download` VALUES ('BitmapSpriteEd-V1.0.zip', 1);
INSERT INTO `download` VALUES ('viDOOM-src-0.02.zip', 2);
INSERT INTO `download` VALUES ('viDOOM-djgpp-0.02.zip', 2);
INSERT INTO `download` VALUES ('noddybox.mod-2.3.zip', 1);
INSERT INTO `download` VALUES ('MissileLock-1.0.zip', 2);
INSERT INTO `download` VALUES ('MissileLock-src-1.0.zip', 1);

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

-- 
-- Table structure for table `message`
-- 

CREATE TABLE `message` (
  `from` mediumtext NOT NULL,
  `ip` varchar(20) NOT NULL default '',
  `message` mediumtext NOT NULL,
  `when` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `IP_INDEX` (`ip`),
  KEY `DATE_INDEX` (`when`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `message`
-- 


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

-- 
-- Table structure for table `news`
-- 

CREATE TABLE `news` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `item` mediumtext NOT NULL,
  PRIMARY KEY  (`time`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `news`
-- 

