[wpdev-commits] xmlscripts wolfpack.sql,1.27,1.28

[<dr...@us...>]

Update of /cvsroot/wpdev/xmlscripts
In directory sc8-pr-cvs1:/tmp/cvs-serv2845

Modified Files:
	wolfpack.sql 
Log Message:
Using  prevents errors with mysql :)

Index: wolfpack.sql
===================================================================
RCS file: /cvsroot/wpdev/xmlscripts/wolfpack.sql,v
retrieving revision 1.27
retrieving revision 1.28
diff -C2 -d -r1.27 -r1.28
*** wolfpack.sql	23 Sep 2003 15:37:13 -0000	1.27
--- wolfpack.sql	26 Sep 2003 03:22:33 -0000	1.28
***************
*** 1,259 ****
! 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 (
!   serial int(11) NOT NULL default '0',
!   name varchar(255) default NULL,
!   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',
!   dexterity smallint(6) NOT NULL default '0',
!   dexteritymod smallint(6) NOT NULL default '0',
!   intelligence smallint(6) NOT NULL default '0',
!   intelligencemod smallint(6) NOT NULL default '0',
!   maxhitpoints smallint(6) NOT NULL default '0',
!   hitpoints smallint(6) NOT NULL default '0',
!   maxstamina smallint(6) NOT NULL default '0',
!   stamina smallint(6) NOT NULL default '0',
!   maxmana smallint(6) default NULL,
!   mana smallint(6) default NULL,
!   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 houses (
!   serial int(11) NOT NULL default '0',
!   nokey tinyint(1) NOT NULL default '0',
!   charpos_x smallint(6) NOT NULL default '0',
!   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',
!   spawnregion varchar(255) default NULL,
!   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 (
!   serial int(11) NOT NULL default '0',
!   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,
!   spawnregion varchar(255) default NULL,
!   stablemaster int(11) NOT NULL default '-1',
!   lootlist varchar(255) default NULL,
!   ai varchar(255) default NULL,
!   wandertype smallint(3) NOT NULL default '0',
!   wanderx1 smallint(6) NOT NULL default '0',
!   wanderx2 smallint(6) NOT NULL default '0',
!   wandery1 smallint(6) NOT NULL default '0',
!   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 (
!   serial int(11) NOT NULL default '0',
!   name varchar(64) NOT NULL default '',
!   type varchar(6) NOT NULL default '',
!   value longtext NOT NULL,
!   PRIMARY KEY (serial,name)
  );
  
! CREATE TABLE uobject (
!   name varchar(255) default NULL,
!   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)
  );
  
! CREATE TABLE effects (
!   id int(11) NOT NULL default '0',
!   objectid varchar(64) NOT NULL default '',
!   expiretime int(11) NOT NULL default '0',
!   dispellable tinyint(4) NOT NULL default '0',
!   source int(11) NOT NULL default '-1',
!   destination int(11) NOT NULL default '-1',
!   PRIMARY KEY  (id)
  );
  
! CREATE TABLE effects_properties (
!   id int(11) NOT NULL default '0',
!   key varchar(64) NOT NULL default '',
!   type varchar(64) NOT NULL default '',
!   value text NOT NULL,
!   PRIMARY KEY  (id,key)
  );
  
--- 1,259 ----
! 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` (
!   `serial` int(11) NOT NULL default '0',
!   `name` varchar(255) default NULL,
!   `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',
!   `dexterity` smallint(6) NOT NULL default '0',
!   `dexteritymod` smallint(6) NOT NULL default '0',
!   `intelligence` smallint(6) NOT NULL default '0',
!   `intelligencemod` smallint(6) NOT NULL default '0',
!   `maxhitpoints` smallint(6) NOT NULL default '0',
!   `hitpoints` smallint(6) NOT NULL default '0',
!   `maxstamina` smallint(6) NOT NULL default '0',
!   `stamina` smallint(6) NOT NULL default '0',
!   `maxmana` smallint(6) default NULL,
!   `mana` smallint(6) default NULL,
!   `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 `houses` (
!   `serial` int(11) NOT NULL default '0',
!   `nokey` tinyint(1) NOT NULL default '0',
!   `charpos_x` smallint(6) NOT NULL default '0',
!   `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',
!   `spawnregion` varchar(255) default NULL,
!   `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` (
!   `serial` int(11) NOT NULL default '0',
!   `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,
!   `spawnregion` varchar(255) default NULL,
!   `stablemaster` int(11) NOT NULL default '-1',
!   `lootlist` varchar(255) default NULL,
!   `ai` varchar(255) default NULL,
!   `wandertype` smallint(3) NOT NULL default '0',
!   `wanderx1` smallint(6) NOT NULL default '0',
!   `wanderx2` smallint(6) NOT NULL default '0',
!   `wandery1` smallint(6) NOT NULL default '0',
!   `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` (
!   `serial` int(11) NOT NULL default '0',
!   `name` varchar(64) NOT NULL default '',
!   `type` varchar(6) NOT NULL default '',
!   `value` longtext NOT NULL,
!   PRIMARY KEY (`serial`,`name`)
  );
  
! CREATE TABLE `uobject` (
!   `name` varchar(255) default NULL,
!   `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`)
  );
  
! CREATE TABLE `effects` (
!   `id` int(11) NOT NULL default '0',
!   `objectid` varchar(64) NOT NULL default '',
!   `expiretime` int(11) NOT NULL default '0',
!   `dispellable` tinyint(4) NOT NULL default '0',
!   `source` int(11) NOT NULL default '-1',
!   `destination` int(11) NOT NULL default '-1',
!   PRIMARY KEY  (`id`)
  );
  
! CREATE TABLE `effects_properties` (
!  `id` int(11) NOT NULL default '0',
!  `key` varchar(64) NOT NULL default '',
!  `type` varchar(64) NOT NULL default '',
!  `value` text NOT NULL,
!   PRIMARY KEY  (`id`,`key`)
  );