-- MySQL dump 8.22
--
-- Host: localhost    Database: rdf
---------------------------------------------------------
-- Server version	3.23.55-nt

--
-- Table structure for table 'airports'
--
use foaf;

CREATE TABLE airports (
  id char(3) NOT NULL default '',
  country char(2) NOT NULL default '',
  latitude double NOT NULL default '0',
  longitude double NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  timezone varchar(32) NOT NULL default '',
  shortname varchar(64) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'airports'
----
-- Table structure for table 'deletetable'
--

CREATE TABLE deletetable (
  id int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'deletetable'
--
--
-- Table structure for table 'deletetable2'
--

CREATE TABLE deletetable2 (
  id int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'deletetable2'
--
--
-- Table structure for table 'detectors'
--

CREATE TABLE detectors (
  id varchar(64) NOT NULL default '',
  x float default NULL,
  y float default NULL,
  z float default NULL,
  stamp timestamp(14) NOT NULL,
  range float NOT NULL default '0',
  mapID varchar(64) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table 'detectors'
----
-- Table structure for table 'devices'
--

CREATE TABLE devices (
  id varchar(64) NOT NULL default '',
  stamp timestamp(14) NOT NULL,
  type int(11) NOT NULL default '0',
  BTID varchar(32) NOT NULL default '',
  detector varchar(64) NOT NULL default '',
  mapid varchar(32) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table 'devices'
--
--
-- Table structure for table 'meta'
--

CREATE TABLE meta (
  status int(11) NOT NULL default '0',
  stamp timestamp(14) NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'meta'
--

--
-- Table structure for table 'provenance'
--

CREATE TABLE provenance (
  id int(11) NOT NULL default '0',
  txt varchar(255) NOT NULL default '',
  PRIMARY KEY  (id,txt)
) TYPE=MyISAM;

--
-- Dumping data for table 'provenance'
--
--
-- Table structure for table 'rdf3'
--

CREATE TABLE rdf3 (
  subj varchar(255) NOT NULL default '',
  pred varchar(255) NOT NULL default '',
  obj text NOT NULL,
  type tinyint(4) NOT NULL default '0',
  source int(11) NOT NULL default '0',
  KEY source (source),
  KEY subj (subj),
  KEY obj (obj(100)),
  KEY pred (pred),
  KEY subjpred (subj(117),pred(117)),
  KEY predobj (pred(117),obj(117))
) TYPE=MyISAM;

--
-- Dumping data for table 'rdf3'
----
-- Table structure for table 'rdf3b'
--

CREATE TABLE rdf3b (
  subj varchar(255) NOT NULL default '',
  pred varchar(255) NOT NULL default '',
  obj text NOT NULL,
  type tinyint(4) NOT NULL default '0',
  source int(11) NOT NULL default '0',
  PRIMARY KEY  (subj(120),pred(120),obj(120),source),
  KEY source (source),
  KEY subj (subj),
  KEY obj (obj(100)),
  KEY pred (pred),
  KEY subjpred (subj(117),pred(117)),
  KEY predobj (pred(117),obj(117))
) TYPE=MyISAM;

--
-- Dumping data for table 'rdf3b'
----
-- Table structure for table 'robots'
--

CREATE TABLE robots (
  domain text NOT NULL,
  localcache text NOT NULL,
  stamp timestamp(14) NOT NULL,
  ok tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'robots'
--

--
-- Table structure for table 'routes'
--

CREATE TABLE routes (
  carrier varchar(32) NOT NULL default '',
  fromAirport varchar(4) NOT NULL default '',
  toAirport varchar(4) NOT NULL default '',
  miles int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table 'routes'
--

--
-- Table structure for table 'urlsnew'
--

CREATE TABLE urlsnew (
  url text NOT NULL,
  localcache text NOT NULL,
  stamp timestamp(14) NOT NULL,
  status tinyint(4) NOT NULL default '0',
  error text NOT NULL,
  triples int(11) NOT NULL default '0',
  ref int(11) NOT NULL auto_increment,
  assurance varchar(255) NOT NULL default '',
  PRIMARY KEY  (url(255)),
  UNIQUE KEY ref (ref)
) TYPE=MyISAM;

--
-- Dumping data for table 'urlsnew'
--