Here is the table create SQL
for a version without html download this
# Connection: antz database # Host: antz_db
# Saved: 2003-07-05 23:26:54
#
--drop database antz_main;
--enable both lines to replace an existing database
--create database antz_main;
--enable this line to create a new database
#____________________________________________________
# Creates the structure of the antz_main database
# Connection: antz database
# Host: antz_db
# Created by: James Jones, www.sw-robotics.com
# Created: 2003-07-05 21:50:24
#____________________________________________________
use antz_main;
CREATE TABLE bots (bot_name varchar(20),bot_id
int, bot_group_id int,
bot_ip1 int, bot_ip2 int,
bot_ip3 int, bot_ip4 int,
bot_model_id int, bot_version_id int);
CREATE TABLE
bot_group(bot_group_name varchar(20),bot_group_id
int);
CREATE TABLE bot_model (bot_model_name varchar(20),bot_model_id
int);
CREATE TABLE bot_version (bot_version_name varchar(20),bot_version_id
int);
CREATE TABLE projects(project_id int,project_name
char(20),project_description
varchar(200),project_start
datetime,project_end datetime);
CREATE TABLE project_detail(project_id int,sub_project_id
int,poly_id int,poly_node
int,total_nodes int,latitude
int,longitude int,range
int);
