Update of /cvsroot/wpdev/xmlscripts
In directory sc8-pr-cvs1:/tmp/cvs-serv660
Modified Files:
wolfpack.sql
Log Message:
Updates
Index: wolfpack.sql
===================================================================
RCS file: /cvsroot/wpdev/xmlscripts/wolfpack.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -d -r1.25 -r1.26
*** wolfpack.sql 29 Aug 2003 11:21:54 -0000 1.25
--- wolfpack.sql 12 Sep 2003 22:12:41 -0000 1.26
***************
*** 109,142 ****
);
- CREATE TABLE guildstones (
- serial int(11) NOT NULL default '0',
- guildname varchar(255) NOT NULL default '',
- abbreviation varchar(255) NOT NULL default '',
- guildtype tinyint(1) NOT NULL default '0',
- charter longtext NOT NULL,
- webpage varchar(255) NOT NULL default 'http://www.wpdev.org',
- 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 (
serial int(11) NOT NULL default '0',
--- 109,112 ----
***************
*** 270,273 ****
);
-
--- 240,260 ----
);
+ 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`)
+ );
+
|
