# -----------------------
# Land Down Under v470 > v475 upgrade - 2002/10/02
# Run this script in phpMyAdmin to update tables
# in your MySQL database
# -----------------------

CREATE TABLE ldu_structure (
  structure_id mediumint(8) NOT NULL auto_increment,
  structure_key varchar(8) NOT NULL default '',
  structure_code varchar(16) NOT NULL default '',
  structure_title varchar(32) NOT NULL default '',
  structure_minlevel tinyint(2) NOT NULL default '0',
  structure_icon varchar(128) NOT NULL default '',
  PRIMARY KEY  (structure_id)
) TYPE=MyISAM;

INSERT INTO ldu_structure VALUES (1, 'cat', 'main', 'Put the name of your site here', 0, '');
INSERT INTO ldu_structure VALUES (2, 'cat', 'private', 'Private area', '20', '');
INSERT INTO ldu_structure VALUES (3, 'type', 'art', 'Articles', '0', '');
INSERT INTO ldu_structure VALUES (4, 'type', 'tut', 'Tutorials', '0', '');
INSERT INTO ldu_structure VALUES (5, 'type', 'file', 'Files', '0', '');
INSERT INTO ldu_structure VALUES (6, 'type', 'link', 'Links', '0', '');
INSERT INTO ldu_structure VALUES (7, 'type', 'reports', 'Events reports', '0', '');


