# -----------------------
# Land Down Under v430, v437 > v450 upgrade
# Run this script in phpMyAdmin to update tables
# in your MySQL database
# -----------------------

CREATE TABLE ldu_plugins (
  plugin_id int(11) NOT NULL auto_increment,
  plugin_name varchar(32) NOT NULL default '',
  plugin_value text,
  PRIMARY KEY (plugin_id),
  KEY plugin_name (plugin_name)
) TYPE=MyISAM; 

ALTER TABLE ldu_users ADD COLUMN user_lang varchar(16) NOT NULL default '' AFTER user_skin;
ALTER TABLE ldu_stats MODIFY COLUMN stat_value int(11);
UPDATE ldu_users SET user_logcount='0', user_lastlog='0000-00-00 00:00' where 1;
