Menu
▾
▴
[Witrack-svn] SF.net SVN: witrack: [36] trunk/witrack_create_db.sql
|
From: <th...@us...> - 2008-06-17 02:44:26
|
Revision: 36
http://witrack.svn.sourceforge.net/witrack/?rev=36&view=rev
Author: thibnes
Date: 2008-06-16 19:44:24 -0700 (Mon, 16 Jun 2008)
Log Message:
-----------
Removed Paths:
-------------
trunk/witrack_create_db.sql
Deleted: trunk/witrack_create_db.sql
===================================================================
--- trunk/witrack_create_db.sql 2008-06-17 02:17:35 UTC (rev 35)
+++ trunk/witrack_create_db.sql 2008-06-17 02:44:24 UTC (rev 36)
@@ -1,229 +0,0 @@
--- 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.
|
