# -----------------------
# Land Down Under v460 > v470 upgrade
# Run this script in phpMyAdmin to update tables
# in your MySQL database
# -----------------------

CREATE TABLE ldu_config (
  config_cat char(2) NOT NULL default '99',
  config_name varchar(32) NOT NULL default '',
  config_type tinyint(2) NOT NULL default '0',
  config_value text NOT NULL,
  PRIMARY KEY (config_name)
) TYPE=MyISAM;

ALTER TABLE ldu_users ADD COLUMN user_occupation varchar(64) NOT NULL default '' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_location varchar(64) NOT NULL default '' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_timezone decimal(2,0) NOT NULL default '0' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_birthdate varchar(16) NOT NULL default '' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_sex char(1) NOT NULL default 'U' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_irc varchar(128) NOT NULL default '' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_msn varchar(64) NOT NULL default '' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_icq varchar(16) NOT NULL default '' AFTER user_text;
ALTER TABLE ldu_users ADD COLUMN user_website varchar(128) NOT NULL default '' AFTER user_text;

UPDATE ldu_users SET user_extra1='' WHERE 1;
UPDATE ldu_users SET user_extra2='' WHERE 1;
UPDATE ldu_users SET user_extra3='' WHERE 1;
UPDATE ldu_users SET user_extra4='' WHERE 1;
UPDATE ldu_users SET user_extra5='' WHERE 1;





