From: Keith F. <ven...@us...> - 2002-06-06 07:10:02
|
Update of /cvsroot/planeshift/planeshift/src/server/database/mysql In directory usw-pr-cvs1:/tmp/cvs-serv4080 Added Files: export5.sql Log Message: Slight table changes to Players table for NPC support. Added data for two "Orc Pawns" (really dwarfs) in Players table and Objects table. Locs are correct for 'plaza' map, but NPCs will show up black. --- NEW FILE: export5.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) ); # # Dumping data for table 'objects' # INSERT INTO objects VALUES("1","PLAYR","","-13.31","-3.98","-105.14","0","Y","1","0"); INSERT INTO objects VALUES("3","PLAYR","","-11.04","-3.98","-113.10","0","Y","32","0"); INSERT INTO objects VALUES("4","PLAYR","","-15.31","-3.98","-111.14","0","Y","33","0"); # # Table structure for table 'players' # CREATE TABLE players ( id int(10) NOT NULL auto_increment, name varchar(35) NOT NULL DEFAULT '' , gender int(10) NOT NULL DEFAULT '0' , race int(10) NOT NULL DEFAULT '0' , npc_spawn_rule_id int(10) , created_date datetime DEFAULT '0000-00-00 00:00:00' , object_player int(10) DEFAULT '0' , guild_member_of int(10) , acct_id int(8) unsigned NOT NULL DEFAULT '0' , guild_level tinyint(1) unsigned DEFAULT '0' , alive_ind char(1) DEFAULT 'N' , npc_parent_id int(10) unsigned , PRIMARY KEY (id), KEY id (id) ); # # Dumping data for table 'players' # INSERT INTO players VALUES("1","Vengeance","0","0","0","0000-00-00 00:00:00","0","10","1","9","N",""); INSERT INTO players VALUES("2","CelGod","0","0","0","0000-00-00 00:00:00","0","","2","1","N",""); INSERT INTO players VALUES("31","guest","0","0","0","0000-00-00 00:00:00","0","10","3","4","N",""); INSERT INTO players VALUES("32","Orc Pawn","0","0","0","","","","0","","Y",""); INSERT INTO players VALUES("33","Orc Pawn","0","0","0","","","","0","","Y",""); |