# -----------------------
# Land Down Under - Website engine
# Copyright (C) 2002 Neocrome
# http://ldu.neocrome.net
# File : docs/ldu-upgrade-502-to-503.sql
# Updated : 2002-nov-30
# -----------------------

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

ALTER TABLE ldu_users ADD COLUMN user_lastvisit int(11) NOT NULL default '0' AFTER user_lastlog;
ALTER TABLE ldu_users MODIFY COLUMN user_lastlog int(11) NOT NULL default '0';

CREATE TABLE ldu_referers (
  ref_url varchar(255) NOT NULL default '',
  ref_count int(11) NOT NULL default '1',
  PRIMARY KEY  (ref_url)
) TYPE=MyISAM;









