[Meshdb-cvs] www/ipdb mysql_schema.sql,NONE,1.1

[<ma...@pr...>]

Update of /cvsroot/meshdb/www/ipdb
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11801

Added Files:
	mysql_schema.sql 
Log Message:
first basic schema, no not even started (so certainly not finished)


--- NEW FILE: mysql_schema.sql ---
-- MySQL dump 10.7
--
-- Host: localhost    Database: meship
-- ------------------------------------------------------
-- Server version	4.1.3-beta

/*!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 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;

--
-- Table structure for table `auth`
--

DROP TABLE IF EXISTS `auth`;
CREATE TABLE `auth` (
  `nodeid` int(11) NOT NULL default '0',
  `admin` char(1) NOT NULL default 'N',
  `password` char(1) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth`
--


/*!40000 ALTER TABLE `auth` DISABLE KEYS */;
LOCK TABLES `auth` WRITE;
INSERT INTO `auth` VALUES (99,'N','9');
UNLOCK TABLES;
/*!40000 ALTER TABLE `auth` ENABLE KEYS */;

--
-- Table structure for table `node`
--

DROP TABLE IF EXISTS `node`;
CREATE TABLE `node` (
  `nodeid` int(10) unsigned NOT NULL default '0',
  `zoneid` int(11) unsigned NOT NULL default '0',
  `podid` int(11) unsigned NOT NULL default '0',
  `contact` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`nodeid`,`zoneid`,`podid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `node`
--


/*!40000 ALTER TABLE `node` DISABLE KEYS */;
LOCK TABLES `node` WRITE;
INSERT INTO `node` VALUES (1,1,1,'Bob'),(1,2,1,'Joe');
UNLOCK TABLES;
/*!40000 ALTER TABLE `node` ENABLE KEYS */;

--
-- Table structure for table `pod`
--

DROP TABLE IF EXISTS `pod`;
CREATE TABLE `pod` (
  `podid` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `reserved` tinyint(1) NOT NULL default '0',
  `bits` int(11) NOT NULL default '0',
  `contact` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`zoneid`,`podid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pod`
--


/*!40000 ALTER TABLE `pod` DISABLE KEYS */;
LOCK TABLES `pod` WRITE;
INSERT INTO `pod` VALUES (1,1,0,6,'Bob Smith'),(2,1,0,6,'Bill Smith'),(0,1,1,6,'Rojer Bannister'),(1,2,0,6,'Fred');
UNLOCK TABLES;
/*!40000 ALTER TABLE `pod` ENABLE KEYS */;

--
-- Table structure for table `zone`
--

DROP TABLE IF EXISTS `zone`;
CREATE TABLE `zone` (
  `zoneid` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `bits` int(2) unsigned NOT NULL default '8',
  `cidr` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zone`
--


/*!40000 ALTER TABLE `zone` DISABLE KEYS */;
LOCK TABLES `zone` WRITE;
INSERT INTO `zone` VALUES (1,'Temporarily In Use',7,'10.160.0.0/16'),(2,'Brisbane North West',8,'10.161.0.0/16'),(3,'Brisbane North East',8,'10.162.0.0/16'),(4,'Brisbane South East',8,'10.163.0.0/16'),(5,'Brisbane South West',8,'10.164.0.0/16'),(6,'Brisbane CBD',8,'10.165.0.0/16'),(7,'Brisbane Backbone',8,'10.166.0.0/16');
UNLOCK TABLES;
/*!40000 ALTER TABLE `zone` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;