[Planeshift-cvs] CVS: planeshift/src/server/database/mysql export2.sql,NONE,1.1

[Keith F. <ven...@us...>]

Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory usw-pr-cvs1:/tmp/cvs-serv2425

Added Files:
	export2.sql 
Log Message:
Additional table for objects of any kind, including players.  This table
tracks position and is analogous to "mesh" in CS.  Run this script in
addition to the main export.sql script, if you need the entire db.

--- NEW FILE: export2.sql ---
# MySQL-Front Dump 1.16 beta
#
# Host: localhost Database: planeshift
#--------------------------------------------------------
# Server version 3.23.46-max
#
# Table structure for table 'objects'
#

CREATE TABLE objects (
  id int(11) NOT NULL auto_increment,
  objtype varchar(5) NOT NULL DEFAULT '' ,
  name varchar(40) NOT NULL DEFAULT '' ,
  locx double(10,2) NOT NULL DEFAULT '0.00' ,
  locy double(10,2) NOT NULL DEFAULT '0.00' ,
  locz double(10,2) NOT NULL DEFAULT '0.00' ,
  obj_inside int(10) DEFAULT '0' ,
  visible_ind char(1) NOT NULL DEFAULT '' ,
  player_owner int(10) DEFAULT '0' ,
  zone int(10) DEFAULT '0' ,
  PRIMARY KEY (id),
  KEY id_2 (id),
  UNIQUE id (id)
);