[wpdev-commits] xmlscripts wolfpack.sql,1.52,1.53

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/wpdev/xmlscripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv913

Modified Files:
	wolfpack.sql 
Log Message:
Changes to resolve an unsigned int issue with serials.

Index: wolfpack.sql
===================================================================
RCS file: /cvsroot/wpdev/xmlscripts/wolfpack.sql,v
retrieving revision 1.52
retrieving revision 1.53
diff -C2 -d -r1.52 -r1.53
*** wolfpack.sql	8 Jun 2004 20:33:02 -0000	1.52
--- wolfpack.sql	2 Jul 2004 00:53:25 -0000	1.53
***************
*** 1,20 ****

- CREATE TABLE `settings` (
- 	`option` varchar(255) NOT NULL default '',
- 	`value` varchar(255) NOT NULL default '',
- 	PRIMARY KEY (`option`)
- );
- 
  CREATE TABLE `characters` (
! 	`serial` int(11) NOT NULL default '0',
  	`name` varchar(255) default NULL,
  	`title` varchar(255) default NULL,
  	`creationdate` varchar(19) 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',
--- 1,14 ----

  CREATE TABLE `characters` (
! 	`serial` int(11) unsigned NOT NULL default '0',
  	`name` varchar(255) default NULL,
  	`title` varchar(255) default NULL,
  	`creationdate` varchar(19) 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',
***************
*** 31,100 ****
  	`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',
  	`hunger` int(11) NOT NULL default '0',
  	`poison` tinyint(2) NOT NULL default '-1',
! 	`murderertime` int(11)  NOT NULL default '0',
! 	`criminaltime` int(11)  NOT NULL default '0',
! 	`gender` tinyint(1)  NOT NULL default '0',
! 	`propertyflags` int(11)  NOT NULL default '0',
! 	`murderer` int(11) NOT NULL default '-1',
! 	`guarding` int(11) NOT NULL default '-1',
  	`hitpointsbonus` smallint(6) NOT NULL default '0',
  	`staminabonus` smallint(6) NOT NULL default '0',
  	`manabonus` smallint(6) NOT NULL default '0',
! 	`strcap` tinyint(4)  NOT NULL default '125',
! 	`dexcap` tinyint(4)  NOT NULL default '125',
! 	`intcap` tinyint(4)  NOT NULL default '125',
! 	`statcap` tinyint(4)  NOT NULL default '225',
  	`baseid` varchar(64) NOT NULL default '',
  	`direction` char(1) NOT NULL default '0',
! 	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',
  	`direction` char(1) NOT NULL default '0',
  	`charbaseid` varchar(64) NOT NULL default '',
! 	`murderer` int(11) NOT NULL default '-1',
  	`murdertime` int(11) 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 `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',
! 	`amount` smallint(5)  NOT NULL default '0',
  	`hp` smallint(6) NOT NULL default '0',
  	`maxhp` smallint(6) 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',
! 	`priv` tinyint(3)  NOT NULL default '0',
  	`baseid` varchar(64) NOT NULL default '',
! 	PRIMARY KEY (`serial`)
  );

  CREATE TABLE `npcs` (
! 	`serial` int(11) 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',
! 	`stablemaster` int(11) NOT NULL default '-1',
  	`ai` varchar(255) default NULL,
  	`wandertype` smallint(3) NOT NULL default '0',
--- 25,140 ----
  	`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',
  	`hunger` int(11) NOT NULL default '0',
  	`poison` tinyint(2) NOT NULL default '-1',
! 	`murderertime` int(11) NOT NULL default '0',
! 	`criminaltime` int(11) NOT NULL default '0',
! 	`gender` tinyint(1) NOT NULL default '0',
! 	`propertyflags` int(11) NOT NULL default '0',
! 	`murderer` int(11) unsigned NOT NULL default '4294967295',
! 	`guarding` int(11) unsigned NOT NULL default '4294967295',
  	`hitpointsbonus` smallint(6) NOT NULL default '0',
  	`staminabonus` smallint(6) NOT NULL default '0',
  	`manabonus` smallint(6) NOT NULL default '0',
! 	`strcap` tinyint(4) NOT NULL default '125',
! 	`dexcap` tinyint(4) NOT NULL default '125',
! 	`intcap` tinyint(4) NOT NULL default '125',
! 	`statcap` tinyint(4) NOT NULL default '127',
  	`baseid` varchar(64) NOT NULL default '',
  	`direction` char(1) NOT NULL default '0',
! 	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `corpses` (
! 	`serial` int(11) unsigned 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',
  	`direction` char(1) NOT NULL default '0',
  	`charbaseid` varchar(64) NOT NULL default '',
! 	`murderer` int(11) unsigned NOT NULL default '4294967295',
  	`murdertime` int(11) NOT NULL default '0',
! 	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `corpses_equipment` (
! 	`serial` int(11) unsigned NOT NULL default '0',
! 	`layer` tinyint(3) NOT NULL default '0',
! 	`item` int(11) unsigned NOT NULL default '4294967295',
! 	PRIMARY KEY  (`serial`,`layer`)
! );
! 
! CREATE TABLE `effects` (
! 	`id` int(11) unsigned 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) unsigned NOT NULL default '4294967295',
! 	`destination` int(11) unsigned NOT NULL default '4294967295',
! 	PRIMARY KEY  (`id`)
! );
! 
! CREATE TABLE `effects_properties` (
! 	`id` int(11) NOT NULL default '0',
! 	`keyname` varchar(64) NOT NULL default '',
! 	`type` varchar(64) NOT NULL default '',
! 	`value` text NOT NULL,
! 	PRIMARY KEY  (`id`,`keyname`)
! );
! 
! CREATE TABLE `guilds` (
! 	`serial` int(11) unsigned NOT NULL default '0',
! 	`name` varchar(255) NOT NULL default '',
! 	`abbreviation` varchar(6) NOT NULL default '',
! 	`charta` longtext NOT NULL,
! 	`website` varchar(255) NOT NULL default 'http://www.wpdev.org',
! 	`alignment` int(2) NOT NULL default '0',
! 	`leader` int(11) unsigned NOT NULL default '4294967295',
! 	`founded` int(11) NOT NULL default '0',
! 	`guildstone` int(11) unsigned NOT NULL default '4294967295',
! 	PRIMARY KEY  (`serial`)
! );
! 
! CREATE TABLE `guilds_canidates` (
! 	`guild` int(11) unsigned NOT NULL default '0',
! 	`player` int(11) unsigned NOT NULL default '0',
! 	PRIMARY KEY  (`guild`,`player`)
! );
! 
! CREATE TABLE `guilds_members` (
! 	`guild` int(11) unsigned NOT NULL default '0',
! 	`player` int(11) unsigned NOT NULL default '0',
! 	`showsign` int(1) NOT NULL default '0',
! 	`guildtitle` varchar(255) NOT NULL default '',
! 	`joined` int(11) NOT NULL default '0',
! 	PRIMARY KEY  (`guild`,`player`)
  );

  CREATE TABLE `items` (
! 	`serial` int(11) unsigned NOT NULL default '0',
! 	`id` smallint(5) NOT NULL default '0',
! 	`color` smallint(5) NOT NULL default '0',
! 	`cont` int(11) unsigned NOT NULL default '4294967295',
! 	`layer` tinyint(3) NOT NULL default '0',
! 	`amount` smallint(5) NOT NULL default '0',
  	`hp` smallint(6) NOT NULL default '0',
  	`maxhp` smallint(6) NOT NULL default '0',
! 	`magic` tinyint(3) NOT NULL default '0',
! 	`owner` int(11) unsigned NOT NULL default '4294967295',
! 	`visible` tinyint(3) NOT NULL default '0',
! 	`priv` tinyint(3) NOT NULL default '0',
  	`baseid` varchar(64) NOT NULL default '',
!   PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `npcs` (
! 	`serial` int(11) unsigned NOT NULL default '0',
! 	`summontime` int(11) NOT NULL default '0',
! 	`additionalflags` int(11) NOT NULL default '0',
! 	`owner` int(11) unsigned NOT NULL default '4294967295',
! 	`stablemaster` int(11) unsigned NOT NULL default '4294967295',
  	`ai` varchar(255) default NULL,
  	`wandertype` smallint(3) NOT NULL default '0',
***************
*** 104,208 ****
  	`wandery2` smallint(6) NOT NULL default '0',
  	`wanderradius` smallint(6) 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',
! 	`strlock` tinyint(4)  NOT NULL default '0',
! 	`dexlock` tinyint(4)  NOT NULL default '0',
! 	`intlock` tinyint(4)  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',
! 	`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,
  	`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',
! 	`keyname` varchar(64) NOT NULL default '',
! 	`type` varchar(64) NOT NULL default '',
! 	`value` text NOT NULL,
! 	PRIMARY KEY  (`id`,`keyname`)
! );
! 
! CREATE TABLE `guilds` (
! 	`serial` int(11) NOT NULL default '0',
! 	`name` varchar(255) NOT NULL default '',
! 	`abbreviation` varchar(6) NOT NULL default '',
! 	`charta` LONGTEXT NOT NULL,
! 	`website` varchar(255) NOT NULL default 'http://www.wpdev.org',
! 	`alignment` int(2) NOT NULL default '0',
! 	`leader` int(11) NOT NULL default '-1',
! 	`founded` int(11) NOT NULL default '0',
! 	`guildstone` int(11) NOT NULL default '-1',
! 	PRIMARY KEY(`serial`)
! );
! 
! CREATE TABLE `guilds_members` (
! 	`guild` int(11) NOT NULL default '0',
! 	`player` int(11) NOT NULL default '0',
! 	`showsign` int(1) NOT NULL default '0',
! 	`guildtitle` varchar(255) NOT NULL default '',
! 	`joined` int(11) NOT NULL default '0',
! 	PRIMARY KEY(`guild`,`player`)
! );
! 
! CREATE TABLE `guilds_canidates` (
! 	`guild` int(11) NOT NULL default '0',
! 	`player` int(11) NOT NULL default '0',
! 	PRIMARY KEY(`guild`,`player`)
! );
! 
! CREATE TABLE `spawnregions` (
! 	`spawnregion` varchar(64) NOT NULL,
! 	`serial` int(11) NOT NULL default '0',
! 	PRIMARY KEY (`spawnregion`, `serial`)
  );
--- 144,209 ----
  	`wandery2` smallint(6) NOT NULL default '0',
  	`wanderradius` smallint(6) NOT NULL default '0',
! 	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `players` (
! 	`serial` int(11) unsigned 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',
! 	`strlock` tinyint(4) NOT NULL default '0',
! 	`dexlock` tinyint(4) NOT NULL default '0',
! 	`intlock` tinyint(4) NOT NULL default '0',
! 	PRIMARY KEY  (`serial`)
! );
! 
! CREATE TABLE `settings` (
! 	`option` varchar(255) NOT NULL default '',
! 	`value` varchar(255) NOT NULL default '',
! 	PRIMARY KEY  (`option`)
  );

  CREATE TABLE `skills` (
! 	`serial` int(11) unsigned 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 `spawnregions` (
! 	`spawnregion` varchar(64) NOT NULL default '',
! 	`serial` int(11) unsigned NOT NULL default '0',
! 	PRIMARY KEY  (`spawnregion`,`serial`)
  );

  CREATE TABLE `tags` (
! 	`serial` int(11) unsigned 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) unsigned NOT NULL default '0',
! 	`multis` int(11) unsigned NOT NULL default '4294967295',
! 	`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,
  	`havetags` tinyint(1) NOT NULL default '0',
! 	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `uobjectmap` (
! 	`serial` int(11) unsigned NOT NULL default '0',
! 	`type` varchar(80) NOT NULL default '',
! 	PRIMARY KEY  (`serial`)
  );