[wpdev-commits] xmlscripts wolfpack.sql,1.24,1.25
Brought to you by:
rip,
thiagocorrea
Menu
▾
▴
[wpdev-commits] xmlscripts wolfpack.sql,1.24,1.25
|
From: <xs...@us...> - 2003-08-29 11:22:01
|
Update of /cvsroot/wpdev/xmlscripts In directory sc8-pr-cvs1:/tmp/cvs-serv20004 Modified Files: wolfpack.sql Log Message: Index: wolfpack.sql =================================================================== RCS file: /cvsroot/wpdev/xmlscripts/wolfpack.sql,v retrieving revision 1.24 retrieving revision 1.25 diff -C2 -d -r1.24 -r1.25 *** wolfpack.sql 22 Aug 2003 17:09:34 -0000 1.24 --- wolfpack.sql 29 Aug 2003 11:21:54 -0000 1.25 *************** *** 1,95 **** - # phpMyAdmin MySQL-Dump - # version 2.3.0-rc2 - # http://phpwizard.net/phpMyAdmin/ - # http://www.phpmyadmin.net/ (download page) - # - # Host: localhost:3306 - # Generation Time: Jun 12, 2003 at 04:44 PM - # Server version: 4.00.12 - # PHP Version: 4.3.1 - # Database : `wolfpack` - # -------------------------------------------------------- - - # - # Table structure for table `boats` - # - CREATE TABLE boats ( serial int(11) NOT NULL default '0', ! autosail tinyint(1) unsigned NOT NULL default '0', ! boatdir tinyint(1) unsigned NOT NULL default '0', itemserial1 int(11) NOT NULL default '-1', itemserial2 int(11) NOT NULL default '-1', itemserial3 int(11) NOT NULL default '-1', itemserial4 int(11) NOT NULL default '-1', ! multi1 smallint(6) unsigned default '0', ! multi2 smallint(6) unsigned default '0', ! multi3 smallint(6) unsigned default '0', ! multi4 smallint(6) unsigned default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cBoat'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `boats_itemids` ! # CREATE TABLE boats_itemids ( serial int(11) NOT NULL default '0', ! a tinyint(1) unsigned NOT NULL default '0', ! b tinyint(1) unsigned NOT NULL default '0', ! id smallint(6) unsigned default '0', ! KEY serial (serial) ! ) TYPE=MyISAM COMMENT='ItemIDs of cBoat Components'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `boats_itemoffsets` ! # CREATE TABLE boats_itemoffsets ( serial int(11) NOT NULL default '0', ! a tinyint(1) unsigned NOT NULL default '0', ! b tinyint(1) unsigned NOT NULL default '0', ! c tinyint(1) unsigned NOT NULL default '0', offset smallint(6) default '0', ! KEY serial (serial) ! ) TYPE=MyISAM COMMENT='Itemoffsets of cBoat Components'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `bookpages` ! # CREATE TABLE bookpages ( serial int(11) NOT NULL default '0', ! page tinyint(3) unsigned NOT NULL default '0', ! text varchar(255) binary NOT NULL default '', ! KEY page (page), ! KEY serial (serial) ! ) TYPE=MyISAM; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `books` ! # CREATE TABLE books ( serial int(11) NOT NULL default '0', ! title varchar(255) binary default NULL, ! author varchar(255) binary NOT NULL default '', readonly tinyint(1) NOT NULL default '0', predefined tinyint(1) NOT NULL default '0', ! section varchar(255) binary NOT NULL default '', ! pages smallint(5) unsigned NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='cBook class'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `characters` ! # CREATE TABLE characters ( --- 1,51 ---- CREATE TABLE boats ( serial int(11) NOT NULL default '0', ! autosail tinyint(1) NOT NULL default '0', ! boatdir tinyint(1) NOT NULL default '0', itemserial1 int(11) NOT NULL default '-1', itemserial2 int(11) NOT NULL default '-1', itemserial3 int(11) NOT NULL default '-1', itemserial4 int(11) NOT NULL default '-1', ! multi1 smallint(6) default '0', ! multi2 smallint(6) default '0', ! multi3 smallint(6) default '0', ! multi4 smallint(6) default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE boats_itemids ( serial int(11) NOT NULL default '0', ! a tinyint(1) NOT NULL default '0', ! b tinyint(1) NOT NULL default '0', ! id smallint(6) default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE boats_itemoffsets ( serial int(11) NOT NULL default '0', ! a tinyint(1) NOT NULL default '0', ! b tinyint(1) NOT NULL default '0', ! c tinyint(1) NOT NULL default '0', offset smallint(6) default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE bookpages ( serial int(11) NOT NULL default '0', ! page tinyint(3) NOT NULL default '0', ! text varchar(255) NOT NULL default '', ! PRIMARY KEY (serial,page) ! ); CREATE TABLE books ( serial int(11) NOT NULL default '0', ! title varchar(255) NOT NULL default '', ! author varchar(255) NOT NULL default '', readonly tinyint(1) NOT NULL default '0', predefined tinyint(1) NOT NULL default '0', ! section varchar(255) NOT NULL default '', ! pages smallint(5) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE characters ( *************** *** 98,108 **** title varchar(255) default NULL, creationdate varchar(255) default NULL, ! dir char(1) NOT NULL default '', ! body smallint(5) unsigned NOT NULL default '0', ! orgbody smallint(5) unsigned NOT NULL default '0', ! skin smallint(5) unsigned NOT NULL default '0', ! orgskin smallint(5) unsigned NOT NULL default '0', ! saycolor smallint(5) unsigned NOT NULL default '0', ! emotecolor smallint(5) unsigned NOT NULL default '0', strength smallint(6) NOT NULL default '0', strengthmod smallint(6) NOT NULL default '0', --- 54,63 ---- title varchar(255) default NULL, creationdate varchar(255) default NULL, ! body smallint(5) NOT NULL default '0', ! orgbody smallint(5) NOT NULL default '0', ! skin smallint(5) NOT NULL default '0', ! orgskin smallint(5) NOT NULL default '0', ! saycolor smallint(5) NOT NULL default '0', ! emotecolor smallint(5) NOT NULL default '0', strength smallint(6) NOT NULL default '0', strengthmod smallint(6) NOT NULL default '0', *************** *** 119,173 **** karma int(11) NOT NULL default '0', fame int(11) NOT NULL default '0', ! kills int(10) unsigned NOT NULL default '0', ! deaths int(10) unsigned NOT NULL default '0', ! def int(10) unsigned NOT NULL default '0', hunger int(11) NOT NULL default '0', poison int(11) NOT NULL default '0', ! poisoned int(10) unsigned NOT NULL default '0', ! murderertime int(11) unsigned NOT NULL default '0', ! criminaltime int(11) unsigned NOT NULL default '0', ! nutriment int(10) unsigned NOT NULL default '0', ! stealthsteps int(11) unsigned NOT NULL default '0', ! gender tinyint(1) unsigned NOT NULL default '0', ! propertyflags int(11) unsigned NOT NULL default '0', attacker int(11) NOT NULL default '-1', combattarget int(11) NOT NULL default '-1', murderer int(11) NOT NULL default '-1', guarding int(11) NOT NULL default '-1', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='cBaseChar'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `corpses` ! # CREATE TABLE corpses ( serial int(11) NOT NULL default '0', ! bodyid smallint(6) unsigned NOT NULL default '0', ! hairstyle smallint(6) unsigned NOT NULL default '0', ! haircolor smallint(6) unsigned NOT NULL default '0', ! beardstyle smallint(6) unsigned NOT NULL default '0', ! beardcolor smallint(6) unsigned NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cCorpse'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `corpses_equipment` ! # CREATE TABLE corpses_equipment ( serial int(11) NOT NULL default '0', ! item int(11) NOT NULL default '-1', ! layer tinyint(3) unsigned NOT NULL default '0' ! ) TYPE=MyISAM COMMENT='Equipment of corpses.'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `guildstones` ! # CREATE TABLE guildstones ( --- 74,111 ---- karma int(11) NOT NULL default '0', fame int(11) NOT NULL default '0', ! kills int(10) NOT NULL default '0', ! deaths int(10) NOT NULL default '0', ! def int(10) NOT NULL default '0', hunger int(11) NOT NULL default '0', poison int(11) NOT NULL default '0', ! poisoned int(10) NOT NULL default '0', ! murderertime int(11) NOT NULL default '0', ! criminaltime int(11) NOT NULL default '0', ! nutriment int(10) NOT NULL default '0', ! gender tinyint(1) NOT NULL default '0', ! propertyflags int(11) NOT NULL default '0', attacker int(11) NOT NULL default '-1', combattarget int(11) NOT NULL default '-1', murderer int(11) NOT NULL default '-1', guarding int(11) NOT NULL default '-1', ! PRIMARY KEY (serial) ! ); CREATE TABLE corpses ( serial int(11) NOT NULL default '0', ! bodyid smallint(6) NOT NULL default '0', ! hairstyle smallint(6) NOT NULL default '0', ! haircolor smallint(6) NOT NULL default '0', ! beardstyle smallint(6) NOT NULL default '0', ! beardcolor smallint(6) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE corpses_equipment ( serial int(11) NOT NULL default '0', ! layer tinyint(3) NOT NULL default '0', ! item int(11) NOT NULL default '-1', ! PRIMARY KEY (serial,layer) ! ); CREATE TABLE guildstones ( *************** *** 180,221 **** master int(11) NOT NULL default '-1', priv int(11) NOT NULL default '-1', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cGuildStone'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `guildstones_members` ! # CREATE TABLE guildstones_members ( serial int(11) NOT NULL default '0', ! member int(11) NOT NULL default '-1' ! ) TYPE=MyISAM COMMENT='Members in this guild.'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `guildstones_recruits` ! # CREATE TABLE guildstones_recruits ( serial int(11) NOT NULL default '0', ! recruit int(11) NOT NULL default '-1' ! ) TYPE=MyISAM COMMENT='Recruitees of this guild.'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `guildstones_war` ! # CREATE TABLE guildstones_war ( serial int(11) NOT NULL default '0', ! enemy int(11) NOT NULL default '-1' ! ) TYPE=MyISAM COMMENT='Other guildstones this guild is at war with.'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `houses` ! # CREATE TABLE houses ( --- 118,141 ---- master int(11) NOT NULL default '-1', priv int(11) NOT NULL default '-1', ! PRIMARY KEY (serial) ! ); CREATE TABLE guildstones_members ( serial int(11) NOT NULL default '0', ! member int(11) NOT NULL default '-1', ! PRIMARY KEY (serial,member) ! ); CREATE TABLE guildstones_recruits ( serial int(11) NOT NULL default '0', ! recruit int(11) NOT NULL default '-1', ! PRIMARY KEY (serial,recruit) ! ); CREATE TABLE guildstones_war ( serial int(11) NOT NULL default '0', ! enemy int(11) NOT NULL default '-1', ! PRIMARY KEY (serial,enemy) ! ); CREATE TABLE houses ( *************** *** 225,306 **** charpos_y smallint(6) NOT NULL default '0', charpos_z smallint(6) NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cHouse'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `items` ! # CREATE TABLE items ( serial int(11) NOT NULL default '0', ! id smallint(5) unsigned NOT NULL default '0', ! name varchar(255) binary default NULL, ! name2 varchar(255) binary default NULL, ! creator varchar(255) binary default NULL, ! sk_name tinyint(3) unsigned NOT NULL default '0', ! color smallint(5) unsigned NOT NULL default '0', cont int(11) NOT NULL default '-1', ! layer tinyint(3) unsigned NOT NULL default '0', ! type smallint(5) unsigned NOT NULL default '0', ! type2 smallint(5) unsigned NOT NULL default '0', ! offspell tinyint(3) unsigned NOT NULL default '0', ! more1 tinyint(3) unsigned NOT NULL default '0', ! more2 tinyint(3) unsigned NOT NULL default '0', ! more3 tinyint(3) unsigned NOT NULL default '0', ! more4 tinyint(3) unsigned NOT NULL default '0', ! moreb1 tinyint(3) unsigned NOT NULL default '0', ! moreb2 tinyint(3) unsigned NOT NULL default '0', ! moreb3 tinyint(3) unsigned NOT NULL default '0', ! moreb4 tinyint(3) unsigned NOT NULL default '0', ! morex int(10) unsigned NOT NULL default '0', ! morey int(10) unsigned NOT NULL default '0', ! morez int(10) unsigned NOT NULL default '0', ! amount smallint(5) unsigned NOT NULL default '0', ! doordir tinyint(3) unsigned NOT NULL default '0', ! dye tinyint(3) unsigned NOT NULL default '0', ! decaytime int(10) unsigned NOT NULL default '0', ! att int(10) unsigned NOT NULL default '0', ! def int(10) unsigned NOT NULL default '0', hidamage smallint(6) NOT NULL default '0', lodamage smallint(6) NOT NULL default '0', ! st smallint(6) NOT NULL default '0', ! time_unused int(10) unsigned NOT NULL default '0', weight int(11) NOT NULL default '0', hp smallint(6) NOT NULL default '0', maxhp smallint(6) NOT NULL default '0', - rank int(11) NOT NULL default '0', - st2 smallint(6) NOT NULL default '0', - dx smallint(6) NOT NULL default '0', - dx2 smallint(6) NOT NULL default '0', - intelligence smallint(6) NOT NULL default '0', - intelligence2 smallint(6) NOT NULL default '0', speed int(11) NOT NULL default '0', ! poisoned int(10) unsigned NOT NULL default '0', ! magic tinyint(3) unsigned NOT NULL default '0', owner int(11) NOT NULL default '-1', ! visible tinyint(3) unsigned NOT NULL default '0', spawn int(11) NOT NULL default '-1', ! dir tinyint(3) unsigned NOT NULL default '0', ! priv tinyint(3) unsigned NOT NULL default '0', sellprice int(11) NOT NULL default '0', buyprice int(11) NOT NULL default '0', ! price int(11) NOT NULL default '0', ! restock smallint(5) unsigned NOT NULL default '0', ! disabled int(10) unsigned NOT NULL default '0', ! spawnregion varchar(255) binary default NULL, ! good int(11) NOT NULL default '0', ! description varchar(255) default NULL, ! carve varchar(255) default NULL, ! accuracy smallint(5) unsigned NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='cItem'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `multis` ! # CREATE TABLE multis ( --- 145,180 ---- charpos_y smallint(6) NOT NULL default '0', charpos_z smallint(6) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE items ( serial int(11) NOT NULL default '0', ! id smallint(5) NOT NULL default '0', ! color smallint(5) NOT NULL default '0', cont int(11) NOT NULL default '-1', ! layer tinyint(3) NOT NULL default '0', ! type smallint(5) NOT NULL default '0', ! type2 smallint(5) NOT NULL default '0', ! amount smallint(5) NOT NULL default '0', ! decaytime int(10) NOT NULL default '0', ! def int(10) NOT NULL default '0', hidamage smallint(6) NOT NULL default '0', lodamage smallint(6) NOT NULL default '0', ! time_unused int(10) NOT NULL default '0', weight int(11) NOT NULL default '0', hp smallint(6) NOT NULL default '0', maxhp smallint(6) NOT NULL default '0', speed int(11) NOT NULL default '0', ! poisoned int(10) NOT NULL default '0', ! magic tinyint(3) NOT NULL default '0', owner int(11) NOT NULL default '-1', ! visible tinyint(3) NOT NULL default '0', spawn int(11) NOT NULL default '-1', ! priv tinyint(3) NOT NULL default '0', sellprice int(11) NOT NULL default '0', buyprice int(11) NOT NULL default '0', ! restock smallint(5) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE multis ( *************** *** 308,349 **** coowner int(11) NOT NULL default '-1', deedsection varchar(255) NOT NULL default '', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cMulti'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `multis_bans` ! # CREATE TABLE multis_bans ( serial int(11) NOT NULL default '0', ban int(11) NOT NULL default '-1', ! KEY serial (serial) ! ) TYPE=MyISAM COMMENT='Bans of cMulti'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `multis_friends` ! # CREATE TABLE multis_friends ( serial int(11) NOT NULL default '0', friend int(11) NOT NULL default '-1', ! KEY serial (serial) ! ) TYPE=MyISAM COMMENT='Friends of cMulti'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `npcs` ! # CREATE TABLE npcs ( serial int(11) NOT NULL default '0', ! mindamage smallint(6) unsigned NOT NULL default '0', ! maxdamage smallint(6) unsigned NOT NULL default '0', ! tamingminskill smallint(6) unsigned NOT NULL default '0', ! summontime int(11) unsigned NOT NULL default '0', ! additionalflags int(11) unsigned NOT NULL default '0', owner int(11) NOT NULL default '-1', carve varchar(255) default NULL, --- 182,207 ---- coowner int(11) NOT NULL default '-1', deedsection varchar(255) NOT NULL default '', ! PRIMARY KEY (serial) ! ); CREATE TABLE multis_bans ( serial int(11) NOT NULL default '0', ban int(11) NOT NULL default '-1', ! PRIMARY KEY (serial,ban) ! ); CREATE TABLE multis_friends ( serial int(11) NOT NULL default '0', friend int(11) NOT NULL default '-1', ! PRIMARY KEY (serial,friend) ! ); CREATE TABLE npcs ( serial int(11) NOT NULL default '0', ! mindamage smallint(6) NOT NULL default '0', ! maxdamage smallint(6) NOT NULL default '0', ! tamingminskill smallint(6) NOT NULL default '0', ! summontime int(11) NOT NULL default '0', ! additionalflags int(11) NOT NULL default '0', owner int(11) NOT NULL default '-1', carve varchar(255) default NULL, *************** *** 358,431 **** wandery2 smallint(6) NOT NULL default '0', wanderradius smallint(6) NOT NULL default '0', ! fleeat smallint(3) unsigned NOT NULL default '10', ! spellslow int(11) unsigned NOT NULL default '0', ! spellshigh int(11) unsigned NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='cNPC'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `pages` ! # ! ! CREATE TABLE pages ( ! charserial int(11) NOT NULL default '-1', ! pagetype tinyint(4) NOT NULL default '0', ! pagetime varchar(64) NOT NULL default '', ! pagepos varchar(32) NOT NULL default '0,0,0,0', ! content mediumtext NOT NULL, ! category int(11) NOT NULL default '0', ! pageorder int(11) NOT NULL default '0' ! ) TYPE=MyISAM COMMENT='class cPage'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `players` ! # CREATE TABLE players ( serial int(11) NOT NULL default '0', account varchar(255) default NULL, ! additionalflags int(10) unsigned NOT NULL default '0', ! visualrange tinyint(3) unsigned NOT NULL default '0', profile longtext, ! fixedlight tinyint(3) unsigned NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='cPlayer'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `skills` ! # CREATE TABLE skills ( serial int(11) NOT NULL default '0', ! skill tinyint(3) unsigned NOT NULL default '0', value smallint(6) NOT NULL default '0', locktype tinyint(4) default '0', cap smallint(6) default '0', ! KEY skill (skill), ! KEY serial (serial) ! ) TYPE=MyISAM PACK_KEYS=0 COMMENT='Skills from characters'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `spellbooks` ! # ! ! CREATE TABLE spellbooks ( ! serial int(11) NOT NULL default '0', ! spells1 int(11) unsigned NOT NULL default '0', ! spells2 int(11) unsigned NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cSpellBook'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `tags` ! # CREATE TABLE tags ( --- 216,243 ---- wandery2 smallint(6) NOT NULL default '0', wanderradius smallint(6) NOT NULL default '0', ! fleeat smallint(3) NOT NULL default '10', ! spellslow int(11) NOT NULL default '0', ! spellshigh int(11) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE players ( serial int(11) NOT NULL default '0', account varchar(255) default NULL, ! additionalflags int(10) NOT NULL default '0', ! visualrange tinyint(3) NOT NULL default '0', profile longtext, ! fixedlight tinyint(3) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE skills ( serial int(11) NOT NULL default '0', ! skill tinyint(3) NOT NULL default '0', value smallint(6) NOT NULL default '0', locktype tinyint(4) default '0', cap smallint(6) default '0', ! PRIMARY KEY (serial,skill) ! ); CREATE TABLE tags ( *************** *** 433,443 **** name varchar(64) NOT NULL default '', type varchar(6) NOT NULL default '', ! value longtext NOT NULL ! ) TYPE=MyISAM COMMENT='class cCustomTags'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `uobject` ! # CREATE TABLE uobject ( --- 245,251 ---- name varchar(64) NOT NULL default '', type varchar(6) NOT NULL default '', ! value longtext NOT NULL, ! PRIMARY KEY (serial,name) ! ); CREATE TABLE uobject ( *************** *** 445,471 **** serial int(11) NOT NULL default '0', multis int(11) NOT NULL default '-1', - pos_x smallint(6) unsigned NOT NULL default '0', - pos_y smallint(6) unsigned NOT NULL default '0', - pos_z smallint(6) NOT NULL default '0', - pos_map tinyint(4) NOT NULL default '0', direction char(1) NOT NULL default '0', events varchar(255) default NULL, bindmenu varchar(255) default NULL, havetags tinyint(1) NOT NULL default '0', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM COMMENT='class cUObject'; ! # -------------------------------------------------------- ! ! # ! # Table structure for table `uobjectmap` ! # CREATE TABLE uobjectmap ( serial int(11) NOT NULL default '0', ! type varchar(80) binary NOT NULL default '', ! PRIMARY KEY (serial), ! UNIQUE KEY serial (serial) ! ) TYPE=MyISAM; --- 253,273 ---- serial int(11) NOT NULL default '0', multis int(11) NOT NULL default '-1', direction char(1) NOT NULL default '0', + pos_x smallint(6) NOT NULL default '0', + pos_y smallint(6) NOT NULL default '0', + pos_z smallint(6) NOT NULL default '0', + pos_map tinyint(4) NOT NULL default '0', events varchar(255) default NULL, bindmenu varchar(255) default NULL, havetags tinyint(1) NOT NULL default '0', ! PRIMARY KEY (serial) ! ); CREATE TABLE uobjectmap ( serial int(11) NOT NULL default '0', ! type varchar(80) NOT NULL default '', ! PRIMARY KEY (serial) ! ); ! |
