From: <eri...@us...> - 2008-04-24 01:18:35
|
Revision: 1381 http://planeshift.svn.sourceforge.net/planeshift/?rev=1381&view=rev Author: eriroley Date: 2008-04-23 18:18:41 -0700 (Wed, 23 Apr 2008) Log Message: ----------- - Added table wc_accessrules in preparation for updated WC - DB VER BUMP Modified Paths: -------------- trunk/docs/history.txt trunk/src/server/database/mysql/create_all.sql trunk/src/server/database/mysql/server_options.sql trunk/src/server/database/mysql/upgrade_schema.sql trunk/src/server/psserver.cpp Added Paths: ----------- trunk/src/server/database/mysql/wc_accessrules.sql Modified: trunk/docs/history.txt =================================================================== --- trunk/docs/history.txt 2008-04-21 13:59:51 UTC (rev 1380) +++ trunk/docs/history.txt 2008-04-24 01:18:41 UTC (rev 1381) @@ -1,3 +1,7 @@ +*** 2008-04-23 by Frank Barton +- Added table wc_accessrules in preparation for updated WC +- DB VER BUMP + *** 2008-04-21 by Dave Bentham - Discard button on Quest/Event window now handles GM's events & new command "/event discard <name>" does same thing. A GM-discarded event removes all traces of the event, including Modified: trunk/src/server/database/mysql/create_all.sql =================================================================== --- trunk/src/server/database/mysql/create_all.sql 2008-04-21 13:59:51 UTC (rev 1380) +++ trunk/src/server/database/mysql/create_all.sql 2008-04-24 01:18:41 UTC (rev 1381) @@ -89,5 +89,6 @@ source introductions.sql; source warnings.sql; source guild_wars.sql; +source wc_accessrules.sql; source create_indexes.sql; Modified: trunk/src/server/database/mysql/server_options.sql =================================================================== --- trunk/src/server/database/mysql/server_options.sql 2008-04-21 13:59:51 UTC (rev 1380) +++ trunk/src/server/database/mysql/server_options.sql 2008-04-24 01:18:41 UTC (rev 1381) @@ -28,7 +28,7 @@ # Dumping data for table server_options # -INSERT INTO `server_options` VALUES ('db_version','1183'); +INSERT INTO `server_options` VALUES ('db_version','1184'); INSERT INTO `server_options` VALUES ('game_time','15:00'); INSERT INTO `server_options` VALUES ('game_date','100-1-1'); INSERT INTO `server_options` VALUES ('standard_motd','This is the message of the day from server_options table.'); Modified: trunk/src/server/database/mysql/upgrade_schema.sql =================================================================== --- trunk/src/server/database/mysql/upgrade_schema.sql 2008-04-21 13:59:51 UTC (rev 1380) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2008-04-24 01:18:41 UTC (rev 1381) @@ -900,6 +900,9 @@ ALTER TABLE item_categories ADD COLUMN identify_min_skill int(8) unsigned; UPDATE `server_options` SET `option_value`='1183' WHERE `option_name`='db_version'; +#### 1184 - Frank Barton - Added wc_accessrules table in prep for updated WC +CREATE TABLE `wc_accessrules` (`id` int(10) NOT NULL auto_increment, `security_level` tinyint(3) NOT NULL, `objecttype` varchar(50) NOT NULL, `access` tinyint(3) default NULL, UNIQUE KEY `id` (`id`)) + # Insert your upgrade before this line. Remember when you set a new db_version # to update the server_options.sql file and update psserver.cpp as well. # This to ensure that everything is working if you use the create_all.sql to Added: trunk/src/server/database/mysql/wc_accessrules.sql =================================================================== --- trunk/src/server/database/mysql/wc_accessrules.sql (rev 0) +++ trunk/src/server/database/mysql/wc_accessrules.sql 2008-04-24 01:18:41 UTC (rev 1381) @@ -0,0 +1,22 @@ +-- +-- Table structure for table `wc_accessrules` +-- + +DROP TABLE IF EXISTS `wc_accessrules`; +CREATE TABLE `wc_accessrules` ( + `id` int(10) NOT NULL auto_increment, + `security_level` tinyint(3) NOT NULL, + `objecttype` varchar(50) NOT NULL, + `access` tinyint(3) default NULL, + UNIQUE KEY `id` (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `wc_accessrules` +-- + + +/*!40000 ALTER TABLE `wc_accessrules` DISABLE KEYS */; +LOCK TABLES `wc_accessrules` WRITE; +INSERT INTO `wc_accessrules` VALUES (1,31,'quests',4),(3,31,'items',4),(4,31,'als',4),(5,31,'npcs',4),(6,30,'quests',1),(7,30,'items',1),(8,30,'als',1),(9,30,'npcs',1); +UNLOCK TABLES; Modified: trunk/src/server/psserver.cpp =================================================================== --- trunk/src/server/psserver.cpp 2008-04-21 13:59:51 UTC (rev 1380) +++ trunk/src/server/psserver.cpp 2008-04-24 01:18:41 UTC (rev 1381) @@ -92,7 +92,7 @@ #include "introductionmanager.h" // Remember to bump this in server_options.sql and add to upgrade_schema.sql! -#define DATABASE_VERSION_STR "1183" +#define DATABASE_VERSION_STR "1184" psCharacterLoader psServer::CharacterLoader; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |