Menu
▾
▴
[Meshdb-cvs] src/geo/dist create.sql,1.3,1.4
|
From: <il...@sc...> - 2006-12-27 07:19:13
|
Update of /cvsroot/meshdb/src/geo/dist In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv3041 Modified Files: create.sql Log Message: Updated format to that produced by more recenty mysqldump. Index: create.sql =================================================================== RCS file: /cvsroot/meshdb/src/geo/dist/create.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- create.sql 16 Feb 2005 11:17:34 -0000 1.3 +++ create.sql 27 Dec 2006 07:19:03 -0000 1.4 @@ -1,123 +1,138 @@ -# MySQL dump 8.12 -# -# Host: bo Database: mesh -#-------------------------------------------------------- -# Server version 3.23.39-log +-- MySQL dump 10.9 +-- +-- Host: bo Database: mesh +-- ------------------------------------------------------ +-- Server version 4.1.20-log -# -# Table structure for table 'admin' -# +/*!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' */; -DROP TABLE IF EXISTS admin; -CREATE TABLE admin ( - nodeid int(11) NOT NULL auto_increment, - nodename tinytext, - created datetime default NULL, - updated datetime default NULL, - url mediumtext NOT NULL, - comment text NOT NULL, - policy text, - status tinytext, - mailonupdate tinyint(4) default '0', - updatedip tinytext, - PRIMARY KEY (nodeid) -) TYPE=MyISAM; +-- +-- Table structure for table `admin` +-- -# -# Table structure for table 'config' -# +DROP TABLE IF EXISTS `admin`; +CREATE TABLE `admin` ( + `nodeid` int(11) NOT NULL auto_increment, + `nodename` tinytext, + `created` datetime default NULL, + `updated` datetime default NULL, + `url` mediumtext NOT NULL, + `comment` text NOT NULL, + `policy` text, + `status` tinytext, + `mailonupdate` tinyint(4) default '0', + `updatedip` tinytext, + PRIMARY KEY (`nodeid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS config; -CREATE TABLE config ( - nodeid int(11) NOT NULL default '0', - carddesc tinytext, - cardurl tinytext, - antdesc tinytext, - anturl tinytext, - imageurl tinytext, - estgain double default NULL, - protocol tinytext, - antspread double default NULL, - channel tinyint(4) default NULL, - ifname varchar(16) NOT NULL default '', - direction double default NULL, - polarisation tinytext, - PRIMARY KEY (nodeid,ifname) -) TYPE=MyISAM; +-- +-- Table structure for table `config` +-- -# -# Table structure for table 'contact' -# +DROP TABLE IF EXISTS `config`; +CREATE TABLE `config` ( + `nodeid` int(11) NOT NULL default '0', + `carddesc` tinytext, + `cardurl` tinytext, + `antdesc` tinytext, + `anturl` tinytext, + `imageurl` tinytext, + `estgain` double default NULL, + `protocol` tinytext, + `antspread` double default NULL, + `channel` tinyint(4) default NULL, + `ifname` varchar(16) NOT NULL default '', + `direction` double default NULL, + `polarisation` tinytext, + PRIMARY KEY (`nodeid`,`ifname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS contact; -CREATE TABLE contact ( - nodeid int(11) NOT NULL default '0', - contactname tinytext, - contactemail tinytext, - contactphone tinytext, - PRIMARY KEY (nodeid) -) TYPE=MyISAM; +-- +-- Table structure for table `contact` +-- -# -# Table structure for table 'netloc' -# +DROP TABLE IF EXISTS `contact`; +CREATE TABLE `contact` ( + `nodeid` int(11) NOT NULL default '0', + `contactname` tinytext, + `contactemail` tinytext, + `contactphone` tinytext, + PRIMARY KEY (`nodeid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS netloc; -CREATE TABLE netloc ( - nodeid int(11) NOT NULL default '0', - family tinytext, - address tinytext, - peerid int(11) default NULL, - mac mediumtext, - ifname varchar(16) NOT NULL default '', - status tinytext, - active tinyint(4) NOT NULL default '0', - comment mediumtext, - channel tinyint(4) default NULL, - PRIMARY KEY (nodeid,ifname), - KEY nodeid (nodeid) -) TYPE=MyISAM; +-- +-- Table structure for table `netloc` +-- -# -# Table structure for table 'physaddr' -# +DROP TABLE IF EXISTS `netloc`; +CREATE TABLE `netloc` ( + `nodeid` int(11) NOT NULL default '0', + `family` tinytext, + `address` tinytext, + `peerid` int(11) default NULL, + `mac` mediumtext, + `ifname` varchar(16) NOT NULL default '', + `status` tinytext, + `active` tinyint(4) NOT NULL default '0', + `comment` mediumtext, + `channel` tinyint(4) default NULL, + PRIMARY KEY (`nodeid`,`ifname`), + KEY `nodeid` (`nodeid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS physaddr; -CREATE TABLE physaddr ( - nodeid int(11) NOT NULL default '0', - streetno tinytext, - suburb tinytext, - state tinytext, - country char(2) default NULL, - postcode tinytext, - imageurl tinytext, - PRIMARY KEY (nodeid) -) TYPE=MyISAM; +-- +-- Table structure for table `physaddr` +-- -# -# Table structure for table 'physloc' -# +DROP TABLE IF EXISTS `physaddr`; +CREATE TABLE `physaddr` ( + `nodeid` int(11) NOT NULL default '0', + `streetno` tinytext, + `suburb` tinytext, + `state` tinytext, + `country` char(2) default NULL, + `postcode` tinytext, + `imageurl` tinytext, + PRIMARY KEY (`nodeid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS physloc; -CREATE TABLE physloc ( - nodeid int(11) NOT NULL default '0', - e double default NULL, - n double default NULL, - h double default NULL, - error double default NULL, - PRIMARY KEY (nodeid) -) TYPE=MyISAM; +-- +-- Table structure for table `physloc` +-- -# -# Table structure for table 'imgcache' -# +DROP TABLE IF EXISTS `physloc`; +CREATE TABLE `physloc` ( + `nodeid` int(11) NOT NULL default '0', + `e` double default NULL, + `n` double default NULL, + `h` double default NULL, + `error` double default NULL, + PRIMARY KEY (`nodeid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -DROP TABLE IF EXISTS imgcache; -CREATE TABLE imgcache ( - url varchar(255) NOT NULL default '', - img mediumblob, - cached datetime default NULL, - retreived datetime default NULL, - PRIMARY KEY (url) -) TYPE=MyISAM; +-- +-- Table structure for table `imgcache` +-- + +DROP TABLE IF EXISTS `imgcache`; +CREATE TABLE `imgcache` ( + `url` varchar(255) NOT NULL default '', + `img` mediumblob, + `cached` datetime default NULL, + `retreived` datetime default NULL, + PRIMARY KEY (`url`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +/*!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 */; |
