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

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

CREATE TABLE ldu_banlist (
  banlist_id int(11) NOT NULL auto_increment,
  banlist_ip varchar(15) NOT NULL default '',
  banlist_email varchar(64) NOT NULL default '',
  banlist_reason varchar(64) NOT NULL default '',
  PRIMARY KEY  (banlist_id),
  KEY banlist_ip (banlist_ip)
) TYPE=MyISAM;

CREATE TABLE ldu_smilies (
  smilie_id int(11) NOT NULL auto_increment,
  smilie_code varchar(16) NOT NULL default '',
  smilie_image varchar(128) NOT NULL default '',
  smilie_text varchar(32) NOT NULL default '',
  PRIMARY KEY  (smilie_id)
) TYPE=MyISAM;

INSERT INTO ldu_smilies VALUES (1, ':D', 'system/smilies/icon_biggrin.gif', 'Mister grin');
INSERT INTO ldu_smilies VALUES (2, ':blush', 'system/smilies/icon_blush.gif', 'Blush');
INSERT INTO ldu_smilies VALUES (3, ':con', 'system/smilies/icon_confused.gif', 'Confused');
INSERT INTO ldu_smilies VALUES (4, ':)', 'system/smilies/icon_smile.gif', 'Smile');
INSERT INTO ldu_smilies VALUES (5, ':cry', 'system/smilies/icon_cry.gif', 'Cry');
INSERT INTO ldu_smilies VALUES (6, ':dontgetit', 'system/smilies/icon_dontgetit.gif', 'Don\'t get it');
INSERT INTO ldu_smilies VALUES (7, ':dozingoff', 'system/smilies/icon_dozingoff.gif', 'Dozing off');
INSERT INTO ldu_smilies VALUES (8, ':love', 'system/smilies/icon_love.gif', 'Love');
INSERT INTO ldu_smilies VALUES (9, ':((', 'system/smilies/icon_mad.gif', 'Mad');
INSERT INTO ldu_smilies VALUES (10, ':|', 'system/smilies/icon_neutral.gif', 'Neutral');
INSERT INTO ldu_smilies VALUES (11, ':no', 'system/smilies/icon_no.gif', 'No');
INSERT INTO ldu_smilies VALUES (12, ':O_o', 'system/smilies/icon_o_o.gif', 'Suspicious');
INSERT INTO ldu_smilies VALUES (13, ':o_o', 'system/smilies/icon_o_o.gif', 'Suspicious');
INSERT INTO ldu_smilies VALUES (14, ':o_O', 'system/smilies/icon_o_o.gif', 'Suspicious');
INSERT INTO ldu_smilies VALUES (15, ':ow', 'system/smilies/icon_ow.gif', 'Ow...');
INSERT INTO ldu_smilies VALUES (16, ':plain', 'system/smilies/icon_plain.gif', 'Plain');
INSERT INTO ldu_smilies VALUES (17, ':p', 'system/smilies/icon_razz.gif', 'Razz');
INSERT INTO ldu_smilies VALUES (18, ':(', 'system/smilies/icon_sad.gif', 'Sad');
INSERT INTO ldu_smilies VALUES (19, ':satisfied', 'system/smilies/icon_satisfied.gif', 'Satisfied');
INSERT INTO ldu_smilies VALUES (20, ':sly', 'system/smilies/icon_sly.gif', 'Sly');
INSERT INTO ldu_smilies VALUES (21, '8)', 'system/smilies/icon_cool.gif', 'Cool');
INSERT INTO ldu_smilies VALUES (22, ':o', 'system/smilies/icon_surprised.gif', 'Surprised');
INSERT INTO ldu_smilies VALUES (23, ';)', 'system/smilies/icon_wink.gif', 'Wink');
INSERT INTO ldu_smilies VALUES (24, ':yes', 'system/smilies/icon_yes.gif', 'Yes');

ALTER TABLE ldu_users ADD COLUMN user_lastip varchar(16) NOT NULL default '' AFTER user_lastvisit;
ALTER TABLE ldu_forum_sections ADD COLUMN fs_category varchar(64) NOT NULL default '' AFTER fs_title;
INSERT INTO ldu_config VALUES ('10', 'timedout', 2, '1200');
INSERT INTO ldu_config VALUES ('28', 'hottopictrigger', 2, '20');
UPDATE ldu_stats SET stat_value='510' WHERE stat_name='version';


