Thread: [wpdev-commits] xmlscripts wolfpack.sql,1.53,1.54

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-serv16816

Modified Files:
	wolfpack.sql 
Log Message:
sql updates

Index: wolfpack.sql
===================================================================
RCS file: /cvsroot/wpdev/xmlscripts/wolfpack.sql,v
retrieving revision 1.53
retrieving revision 1.54
diff -C2 -d -r1.53 -r1.54
*** wolfpack.sql	2 Jul 2004 00:53:25 -0000	1.53
--- wolfpack.sql	2 Jul 2004 06:28:04 -0000	1.54
***************
*** 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',
--- 1,14 ----

  CREATE TABLE `characters` (
! 	`serial` int(10) unsigned NOT NULL default '0',
  	`name` varchar(255) default NULL,
  	`title` varchar(255) default NULL,
  	`creationdate` varchar(19) default NULL,
! 	`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',
***************
*** 25,38 ****
  	`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',
--- 25,38 ----
  	`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',
! 	`hunger` int(10) unsigned NOT NULL default '0',
  	`poison` tinyint(2) NOT NULL default '-1',
! 	`murderertime` int(10) unsigned NOT NULL default '0',
! 	`criminaltime` int(10) unsigned NOT NULL default '0',
! 	`gender` tinyint(1) unsigned NOT NULL default '0',
  	`propertyflags` int(11) NOT NULL default '0',
! 	`murderer` int(10) unsigned NOT NULL default '0',
! 	`guarding` int(10) unsigned NOT NULL default '0',
  	`hitpointsbonus` smallint(6) NOT NULL default '0',
  	`staminabonus` smallint(6) NOT NULL default '0',
***************
*** 41,83 ****
  	`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 '',
--- 41,83 ----
  	`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` tinyint(1) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `corpses` (
! 	`serial` int(10) unsigned NOT NULL default '0',
! 	`bodyid` smallint(5) unsigned NOT NULL default '0',
! 	`hairstyle` smallint(5) unsigned NOT NULL default '0',
! 	`haircolor` smallint(5) unsigned NOT NULL default '0',
! 	`beardstyle` smallint(5) unsigned NOT NULL default '0',
! 	`beardcolor` smallint(5) unsigned NOT NULL default '0',
! 	`direction` tinyint(1) unsigned NOT NULL default '0',
  	`charbaseid` varchar(64) NOT NULL default '',
! 	`murderer` int(10) unsigned NOT NULL default '0',
! 	`murdertime` int(10) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `corpses_equipment` (
! 	`serial` int(10) unsigned NOT NULL default '0',
! 	`layer` tinyint(3) unsigned NOT NULL default '0',
! 	`item` int(10) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`serial`,`layer`)
  );

  CREATE TABLE `effects` (
! 	`id` int(10) unsigned NOT NULL default '0',
  	`objectid` varchar(64) NOT NULL default '',
! 	`expiretime` int(10) unsigned NOT NULL default '0',
  	`dispellable` tinyint(4) NOT NULL default '0',
! 	`source` int(10) unsigned NOT NULL default '0',
! 	`destination` int(10) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`id`)
  );

  CREATE TABLE `effects_properties` (
! 	`id` int(10) unsigned NOT NULL default '0',
  	`keyname` varchar(64) NOT NULL default '',
  	`type` varchar(64) NOT NULL default '',
***************
*** 87,112 ****

  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',
--- 87,112 ----

  CREATE TABLE `guilds` (
! 	`serial` int(10) 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` tinyint(2) NOT NULL default '0',
! 	`leader` int(10) unsigned NOT NULL default '0',
  	`founded` int(11) NOT NULL default '0',
! 	`guildstone` int(10) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`serial`)
  );

  CREATE TABLE `guilds_canidates` (
! 	`guild` int(10) unsigned NOT NULL default '0',
! 	`player` int(10) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`guild`,`player`)
  );

  CREATE TABLE `guilds_members` (
! 	`guild` int(10) unsigned NOT NULL default '0',
! 	`player` int(10) unsigned NOT NULL default '0',
! 	`showsign` tinyint(1) unsigned NOT NULL default '0',
  	`guildtitle` varchar(255) NOT NULL default '',
  	`joined` int(11) NOT NULL default '0',
***************
*** 115,128 ****

  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',
--- 115,128 ----

  CREATE TABLE `items` (
! 	`serial` int(10) unsigned NOT NULL default '0',
! 	`id` smallint(5) unsigned NOT NULL default '0',
! 	`color` smallint(5) unsigned NOT NULL default '0',
! 	`cont` int(10) unsigned NOT NULL default '0',
! 	`layer` tinyint(3) unsigned 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(10) unsigned NOT NULL default '0',
  	`visible` tinyint(3) NOT NULL default '0',
  	`priv` tinyint(3) NOT NULL default '0',
***************
*** 132,140 ****

  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',
--- 132,140 ----

  CREATE TABLE `npcs` (
! 	`serial` int(10) unsigned NOT NULL default '0',
  	`summontime` int(11) NOT NULL default '0',
  	`additionalflags` int(11) NOT NULL default '0',
! 	`owner` int(10) unsigned NOT NULL default '0',
! 	`stablemaster` int(10) unsigned NOT NULL default '0',
  	`ai` varchar(255) default NULL,
  	`wandertype` smallint(3) NOT NULL default '0',
***************
*** 148,157 ****

  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',
--- 148,157 ----

  CREATE TABLE `players` (
! 	`serial` int(10) unsigned NOT NULL default '0',
! 	`account` varchar(16) default NULL,
  	`additionalflags` int(10) NOT NULL default '0',
! 	`visualrange` tinyint(3) unsigned NOT NULL default '0',
  	`profile` longtext,
! 	`fixedlight` tinyint(3) unsigned NOT NULL default '0',
  	`strlock` tinyint(4) NOT NULL default '0',
  	`dexlock` tinyint(4) NOT NULL default '0',
***************
*** 167,172 ****

  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',
--- 167,172 ----

  CREATE TABLE `skills` (
! 	`serial` int(10) unsigned NOT NULL default '0',
! 	`skill` tinyint(2) unsigned NOT NULL default '0',
  	`value` smallint(6) NOT NULL default '0',
  	`locktype` tinyint(4) default '0',
***************
*** 175,187 ****
  );

- 
  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 '',
--- 175,186 ----
  );

  CREATE TABLE `spawnregions` (
  	`spawnregion` varchar(64) NOT NULL default '',
! 	`serial` int(10) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`spawnregion`,`serial`)
  );

  CREATE TABLE `tags` (
! 	`serial` int(10) unsigned NOT NULL default '0',
  	`name` varchar(64) NOT NULL default '',
  	`type` varchar(6) NOT NULL default '',
***************
*** 192,208 ****
  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`)
--- 191,207 ----
  CREATE TABLE `uobject` (
  	`name` varchar(255) default NULL,
! 	`serial` int(10) unsigned NOT NULL default '0',
! 	`multis` int(10) unsigned NOT NULL default '0',
! 	`pos_x` smallint(6) unsigned NOT NULL default '0',
! 	`pos_y` smallint(6) unsigned NOT NULL default '0',
! 	`pos_z` tinyint(4) NOT NULL default '0',
! 	`pos_map` tinyint(1) unsigned NOT NULL default '0',
  	`events` varchar(255) default NULL,
! 	`havetags` tinyint(1) unsigned NOT NULL default '0',
  	PRIMARY KEY  (`serial`)
  );

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