meshdb-cvs

[<le...@us...>]

Update of /cvsroot/meshdb/src/geo/dist
In directory usw-pr-cvs1:/tmp/cvs-serv32181

Added Files:
	create.sql 
Log Message:
an SQL create script

--- NEW FILE: create.sql ---
# MySQL dump 8.12
#
# Host: bo    Database: mesh
#--------------------------------------------------------
# Server version	3.23.39-log

#
# Table structure for table 'admin'
#

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 'config'
#

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,
  PRIMARY KEY  (nodeid,ifname)
) TYPE=MyISAM;

#
# Table structure for table 'contact'
#

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 'netloc'
#

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 '',
  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 'physaddr'
#

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 'physloc'
#

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 '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)
) TYPE=MyISAM;