Menu
▾
▴
[Witrack-svn] SF.net SVN: witrack: [34] trunk/Server/witrack_create_db.sql
|
From: <th...@us...> - 2008-06-17 02:16:38
|
Revision: 34
http://witrack.svn.sourceforge.net/witrack/?rev=34&view=rev
Author: thibnes
Date: 2008-06-16 19:16:33 -0700 (Mon, 16 Jun 2008)
Log Message:
-----------
Added Paths:
-----------
trunk/Server/witrack_create_db.sql
Added: trunk/Server/witrack_create_db.sql
===================================================================
--- trunk/Server/witrack_create_db.sql (rev 0)
+++ trunk/Server/witrack_create_db.sql 2008-06-17 02:16:33 UTC (rev 34)
@@ -0,0 +1,229 @@
+-- phpMyAdmin SQL Dump
+-- version 2.11.4
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Jun 07, 2008 at 04:32 PM
+-- Server version: 5.0.51
+-- PHP Version: 5.2.5
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- Database: `witrack`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ap`
+--
+
+CREATE TABLE IF NOT EXISTS `ap` (
+ `ap_id` int(10) unsigned NOT NULL auto_increment,
+ `ap_macaddr` varchar(17) default NULL,
+ `ap_modelref` varchar(30) default NULL,
+ `ap_label` varchar(20) default NULL,
+ `ap_protocol` varchar(15) default NULL,
+ `ap_ssid` varchar(30) default NULL,
+ `ap_ipaddress` varchar(25) default NULL,
+ `ap_x` double NOT NULL default '0',
+ `ap_y` double NOT NULL default '0',
+ `map_id` int(11) NOT NULL default '0',
+ `ap_strength` double NOT NULL default '0',
+ `ap_description` text NOT NULL,
+ PRIMARY KEY (`ap_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
+
+--
+-- Dumping data for table `ap`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `areas`
+--
+
+CREATE TABLE IF NOT EXISTS `areas` (
+ `area_id` int(11) NOT NULL auto_increment,
+ `area_name` varchar(45) NOT NULL default '',
+ PRIMARY KEY (`area_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
+
+--
+-- Dumping data for table `areas`
+--
+
+INSERT INTO `areas` (`area_id`, `area_name`) VALUES
+(1, 'School');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `buildings`
+--
+
+CREATE TABLE IF NOT EXISTS `buildings` (
+ `building_id` int(11) NOT NULL auto_increment,
+ `building_name` varchar(45) NOT NULL default '',
+ `area_id` int(11) NOT NULL default '0',
+ PRIMARY KEY (`building_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
+
+--
+-- Dumping data for table `buildings`
+--
+
+INSERT INTO `buildings` (`building_id`, `building_name`, `area_id`) VALUES
+(1, 'Building1', 1);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `devices`
+--
+
+CREATE TABLE IF NOT EXISTS `devices` (
+ `dev_id` int(10) unsigned NOT NULL auto_increment,
+ `dev_macaddr` varchar(17) default NULL,
+ `dev_passkey` varchar(80) default NULL,
+ `dev_label` varchar(20) default NULL,
+ `dev_type` char(1) default NULL,
+ `dev_modelref` varchar(30) default NULL,
+ `dev_protocol` varchar(15) default NULL,
+ `dev_emitpower` float default NULL,
+ `dev_antenna_gain` float default NULL,
+ `dev_antenna_polarization` char(1) default NULL,
+ `dev_antenna_direction` char(1) default NULL,
+ PRIMARY KEY (`dev_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+
+--
+-- Dumping data for table `devices`
+--
+
+INSERT INTO `devices` (`dev_id`, `dev_macaddr`, `dev_passkey`, `dev_label`, `dev_type`, `dev_modelref`, `dev_protocol`, `dev_emitpower`, `dev_antenna_gain`, `dev_antenna_polarization`, `dev_antenna_direction`) VALUES
+(1, 'FF:FF:FF:FF:FF:FF', '-128:108:15:62:12:-89:45:-56:100:-63:74:99:-47:20:-30:-105', 'Hawyire', 'N', 'Laptop Core Duo', '802.11g', 42.5, 12.2, 'P', 'V'),
+(2, '00:0C:41:FB:85:A0', '-128:108:15:62:12:-89:45:-56:100:-63:74:99:-47:20:-30:-105', 'Linksys', 'N', 'WRT54GS', '802', 42, 51, 'P', 'V');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `floors`
+--
+
+CREATE TABLE IF NOT EXISTS `floors` (
+ `floor_id` int(11) NOT NULL auto_increment,
+ `floor_name` varchar(45) NOT NULL default '',
+ `building_id` int(11) NOT NULL default '0',
+ PRIMARY KEY (`floor_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `floors`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `histo`
+--
+
+CREATE TABLE IF NOT EXISTS `histo` (
+ `hst_id` int(10) unsigned NOT NULL auto_increment,
+ `device_id` int(10) unsigned NOT NULL default '0',
+ `map_id` int(10) unsigned NOT NULL default '0',
+ `hst_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
+ `hst_xpos` int(10) unsigned default NULL,
+ `hst_ypos` int(10) unsigned default NULL,
+ PRIMARY KEY (`hst_id`),
+ KEY `HISTO_FKIndex1` (`map_id`),
+ KEY `HISTO_FKIndex2` (`device_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
+
+--
+-- Dumping data for table `histo`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `loc`
+--
+
+CREATE TABLE IF NOT EXISTS `loc` (
+ `ap_id` int(11) NOT NULL default '0',
+ `loc_x` int(11) NOT NULL default '0',
+ `loc_y` int(11) NOT NULL default '0',
+ `loc_power` double NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `loc`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `maps`
+--
+
+CREATE TABLE IF NOT EXISTS `maps` (
+ `map_id` int(10) unsigned NOT NULL auto_increment,
+ `map_version` int(11) NOT NULL default '0',
+ `map_scale` double NOT NULL default '0',
+ `building_id` int(11) NOT NULL default '0',
+ `map_name` varchar(45) NOT NULL default '',
+ PRIMARY KEY (`map_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
+
+--
+-- Dumping data for table `maps`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `serverconfig`
+--
+
+CREATE TABLE IF NOT EXISTS `serverconfig` (
+ `srv_key` varchar(79) NOT NULL default '',
+ `srv_max_blocks` int(11) NOT NULL default '0',
+ `srv_max_size_block` int(11) NOT NULL default '0',
+ `srv_max_files` int(11) NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `serverconfig`
+--
+
+INSERT INTO `serverconfig` (`srv_key`, `srv_max_blocks`, `srv_max_size_block`, `srv_max_files`) VALUES
+('-107:-104:78:87:-117:91:55:111:-27:65:96:-23:63:-100:-87:61', 10, 500000, 10);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `users`
+--
+
+CREATE TABLE IF NOT EXISTS `users` (
+ `usr_id` int(10) unsigned NOT NULL auto_increment,
+ `usr_login` varchar(20) default NULL,
+ `usr_password` varchar(80) default NULL,
+ `usr_description` varchar(200) default NULL,
+ PRIMARY KEY (`usr_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
+--
+-- Dumping data for table `users`
+--
+
+INSERT INTO `users` (`usr_id`, `usr_login`, `usr_password`, `usr_description`) VALUES
+(1, 'user1', '-40:-84:-10:8:-60:119:-85:119:-87:-46:-37:55:-37:-119:-29:123', 'Test Account');
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
