[PlaneShift-svn] SF.net SVN: planeshift:[7692] trunk/src/server/database/mysql

[<wel...@us...>]

Revision: 7692
          http://planeshift.svn.sourceforge.net/planeshift/?rev=7692&view=rev
Author:   weltall2
Date:     2011-10-29 19:27:01 +0000 (Sat, 29 Oct 2011)
Log Message:
-----------
added password256 as temporary field for new sha256 hash

Modified Paths:
--------------
    trunk/src/server/database/mysql/accounts.sql
    trunk/src/server/database/mysql/upgrade_schema.sql

Modified: trunk/src/server/database/mysql/accounts.sql
===================================================================
--- trunk/src/server/database/mysql/accounts.sql	2011-10-29 19:23:59 UTC (rev 7691)
+++ trunk/src/server/database/mysql/accounts.sql	2011-10-29 19:27:01 UTC (rev 7692)
@@ -23,6 +23,7 @@
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `username` varchar(50) NOT NULL DEFAULT '0',
   `password` varchar(32) NOT NULL DEFAULT '0',
+  `password` varchar(64) NOT NULL DEFAULT '0',
   `last_login` datetime DEFAULT NULL,
   `created_date` datetime DEFAULT NULL,
   `last_login_ip` varchar(16) DEFAULT NULL,

Modified: trunk/src/server/database/mysql/upgrade_schema.sql
===================================================================
--- trunk/src/server/database/mysql/upgrade_schema.sql	2011-10-29 19:23:59 UTC (rev 7691)
+++ trunk/src/server/database/mysql/upgrade_schema.sql	2011-10-29 19:27:01 UTC (rev 7692)
@@ -1624,6 +1624,8 @@
 ALTER TABLE `gm_events` ADD `date_created` TIMESTAMP default current_timestamp AFTER `id`;
 ALTER TABLE `alliances` ADD `date_created` TIMESTAMP default current_timestamp AFTER `id`;
 
+ALTER TABLE `accounts` ADD COLUMN `password256` VARCHAR(64)  NOT NULL DEFAULT 0 AFTER `password`;
+
 # 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

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.