[wpdev-commits] xmlscripts wolfpack.sql,1.29,1.30

[<co...@us...>]

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

Modified Files:
	wolfpack.sql 
Log Message:
baseid added

Index: wolfpack.sql
===================================================================
RCS file: /cvsroot/wpdev/xmlscripts/wolfpack.sql,v
retrieving revision 1.29
retrieving revision 1.30
diff -C2 -d -r1.29 -r1.30
*** wolfpack.sql	23 Nov 2003 15:10:59 -0000	1.29
--- wolfpack.sql	23 Nov 2003 22:01:49 -0000	1.30
***************
*** 119,148 ****
  
  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`)
  );
--- 119,148 ----
  
  CREATE TABLE `items` (
!   `amount` smallint(5)  NOT NULL default '0',
!   `baseid` varchar(32) NOT NULL default '',
!   `buyprice` int(11) NOT NULL default '0',
    `color` smallint(5)  NOT NULL default '0',
    `cont` int(11) NOT NULL default '-1',
    `decaytime` int(10)  NOT NULL default '0',
    `def` int(10)  NOT NULL default '0',
    `hidamage` smallint(6) NOT NULL default '0',
    `hp` smallint(6) NOT NULL default '0',
!   `id` smallint(5)  NOT NULL default '0',
!   `layer` tinyint(3)  NOT NULL default '0',
!   `lodamage` smallint(6) NOT NULL default '0',
    `magic` tinyint(3)  NOT NULL default '0',
+   `maxhp` smallint(6) NOT NULL default '0',
    `owner` int(11) NOT NULL default '-1',
!   `poisoned` int(10)  NOT NULL default '0',
    `priv` tinyint(3)  NOT NULL default '0',
    `restock` smallint(5)  NOT NULL default '0',
+   `sellprice` int(11) NOT NULL default '0',
+   `serial` int(11) NOT NULL default '0',
+   `spawnregion` varchar(255) default NULL,
+   `speed` int(11) NOT NULL default '0',
+   `type2` smallint(5)  NOT NULL default '0',
+   `type` smallint(5)  NOT NULL default '0',
+   `visible` tinyint(3)  NOT NULL default '0',
+   `weight` int(11) NOT NULL default '0',
    PRIMARY KEY (`serial`)
  );