#
# Table structure for table `authors`
#

DROP TABLE IF EXISTS authors;
CREATE TABLE authors (
  authorid int(11) NOT NULL auto_increment,
  login varchar(20) NOT NULL default '',
  userpassword varchar(32) NOT NULL default '',
  authorname varchar(50) default NULL,
  authoremail varchar(255) default NULL,
  regdate datetime default NULL,
  usergroup varchar(32) NOT NULL default '',
  countrycode char(2) default NULL,
  language char(2) default NULL,
  phone varchar(20) default NULL,
  fax varchar(20) default NULL,
  address varchar(100) default NULL,
  city varchar(50) default NULL,
  state varchar(50) default NULL,
  zip varchar(20) default NULL,
  website varchar(255) default NULL,
  comments text,
  newsletter char(1) default 'N',
  privateemail char(1) default 'N',
  disuser char(1) default 'N',
  PRIMARY KEY  (authorid),
  UNIQUE KEY login (login)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `banners`
#

DROP TABLE IF EXISTS banners;
CREATE TABLE banners (
  bannerid int(11) NOT NULL auto_increment,
  bannerimage varchar(255) default NULL,
  bannerurl varchar(255) default NULL,
  banneralt varchar(255) default NULL,
  publishdate datetime default NULL,
  expiredate datetime default NULL,
  impressions int(11) default NULL,
  clicks int(11) default NULL,
  banneractive char(1) default NULL,
  bannerhtml text,
  authorid int(11) NOT NULL default '1',
  PRIMARY KEY  (bannerid)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `contents`
#

DROP TABLE IF EXISTS contents;
CREATE TABLE contents (
  contentid int(11) unsigned NOT NULL auto_increment,
  groupname varchar(32) default NULL,
  title varchar(255) default NULL,
  body text,
  publishdate datetime default NULL,
  expiredate datetime default NULL,
  contentactive char(1) default 'Y',
  teaser text,
  orderid int(10) NOT NULL default '0',
  authorid int(11) default '1',
  updatedate datetime default NULL,
  subgroupname varchar(32) default NULL,
  imagealign char(1) default NULL,
  image varchar(255) default NULL,
  headervisible char(1) default 'Y',
  authorvisible char(1) default 'Y',
  updatedatevisible char(1) default 'Y',
  headerimage varchar(255) default NULL,
  imagedetails varchar(255) default NULL,
  imagedetailsalign char(1) default 'L',
  leftright char(1) default 'L',
  contentname varchar(32) default NULL,
  language char(2) default NULL,
  canrate char(1) default NULL,
  cancomment char(1) default NULL,
  ratingtotal int(11) NOT NULL default '0',
  ratingvotes int(11) NOT NULL default '0',
  cbody text,
  cteaser text,
  printerfriendly char(1) default 'N',
  PRIMARY KEY  (contentid),
  UNIQUE KEY contentref (contentname,language),
  KEY parentref (groupname,subgroupname,leftright,language)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `continents`
#

DROP TABLE IF EXISTS continents;
CREATE TABLE continents (
  continentcode varchar(4) NOT NULL default '',
  continentname varchar(32) NOT NULL default '',
  PRIMARY KEY  (continentcode)
) TYPE=MyISAM;

#
# Data for table `continents`
#
INSERT INTO continents (continentcode, continentname) VALUES ('01', 'Africa');
INSERT INTO continents (continentcode, continentname) VALUES ('0101', 'Eastern Africa');
INSERT INTO continents (continentcode, continentname) VALUES ('0102', 'Middle Africa');
INSERT INTO continents (continentcode, continentname) VALUES ('0103', 'Northern Africa');
INSERT INTO continents (continentcode, continentname) VALUES ('0104', 'Southern Africa');
INSERT INTO continents (continentcode, continentname) VALUES ('0105', 'Western Africa');
INSERT INTO continents (continentcode, continentname) VALUES ('02', 'Americas');
INSERT INTO continents (continentcode, continentname) VALUES ('0201', 'Caribbean');
INSERT INTO continents (continentcode, continentname) VALUES ('0202', 'Central America');
INSERT INTO continents (continentcode, continentname) VALUES ('0203', 'South America');
INSERT INTO continents (continentcode, continentname) VALUES ('0204', 'Northern America');
INSERT INTO continents (continentcode, continentname) VALUES ('03', 'Asia');
INSERT INTO continents (continentcode, continentname) VALUES ('0301', 'Eastern Asia');
INSERT INTO continents (continentcode, continentname) VALUES ('0302', 'South-central Asia');
INSERT INTO continents (continentcode, continentname) VALUES ('0304', 'South-eastern Asia');
INSERT INTO continents (continentcode, continentname) VALUES ('0305', 'Western Asia');
INSERT INTO continents (continentcode, continentname) VALUES ('04', 'Europe');
INSERT INTO continents (continentcode, continentname) VALUES ('0401', 'Eastern Europe');
INSERT INTO continents (continentcode, continentname) VALUES ('0402', 'Northern Europe');
INSERT INTO continents (continentcode, continentname) VALUES ('0403', 'Southern Europe');
INSERT INTO continents (continentcode, continentname) VALUES ('0404', 'Western Europe');
INSERT INTO continents (continentcode, continentname) VALUES ('05', 'Oceania');
INSERT INTO continents (continentcode, continentname) VALUES ('0501', 'Australia and New Zealand');
INSERT INTO continents (continentcode, continentname) VALUES ('0502', 'Melanesia');
INSERT INTO continents (continentcode, continentname) VALUES ('0503', 'Micronesia');
INSERT INTO continents (continentcode, continentname) VALUES ('0504', 'Polynesia');
INSERT INTO continents (continentcode, continentname) VALUES ('06', 'Antartica');


# --------------------------------------------------------
#
# Table structure for table `countries`
#

DROP TABLE IF EXISTS countries;
CREATE TABLE countries (
  countrycode char(2) NOT NULL default '',
  countryname varchar(48) NOT NULL default '',
  continent varchar(4) NOT NULL default '',
  flag varchar(32) default NULL,
  PRIMARY KEY  (countrycode),
  KEY countryname (countryname),
  KEY continent (continent,countrycode)
) TYPE=MyISAM;

#
# Data for table `countries`
#
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('af', 'Afghanistan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('al', 'Albania', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('dz', 'Algeria', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('as', 'American Samoa', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ad', 'Andorra', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ao', 'Angola', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ai', 'Anguilla', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('aq', 'Antarctica', '06', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ag', 'Antigua & Barbuda', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ar', 'Argentina', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('am', 'Armenia', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('aw', 'Aruba', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('au', 'Australia', '0501', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('at', 'Austria', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('az', 'Azerbaijan', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bs', 'Bahamas', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bh', 'Bahrain', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bd', 'Bangladesh', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bb', 'Barbados', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('by', 'Belarus', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('be', 'Belgium', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bz', 'Belize', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bj', 'Benin', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bm', 'Bermuda', '0204', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bt', 'Bhutan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bo', 'Bolivia', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ba', 'Bosnia and Herzegovina', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bw', 'Botswana', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bv', 'Bouvet Island', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('br', 'Brazil', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('io', 'British Indian Ocean Territory', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bn', 'Brunei Darussalam', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bg', 'Bulgaria', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bf', 'Burkina Faso', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('bi', 'Burundi', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kh', 'Cambodia', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cm', 'Cameroon', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ca', 'Canada', '0204', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cv', 'Cape Verde', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ky', 'Cayman Islands', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cf', 'Central African Republic', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('td', 'Chad', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cl', 'Chile', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cn', 'China', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cx', 'Christmas Island', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cc', 'Cocos (Keeling) Island', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('co', 'Columbia', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('km', 'Comoros', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ck', 'Cook Islands', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cr', 'Costa Rica', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ci', 'Cote d\'Ivoire', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('hr', 'Croatia', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cu', 'Cuba', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cy', 'Cyprus', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cz', 'Czech Republic', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('cg', 'Democratic Republic of Congo', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('dk', 'Denmark', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('dj', 'Djibouti', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('dm', 'Dominica', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('do', 'Dominican Republic', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tp', 'East Timor', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ec', 'Ecuador', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('eg', 'Egypt', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sv', 'El Salvador', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gq', 'Equatorial Guinea', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('er', 'Eritrea', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ee', 'Estonia', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('et', 'Ethiopia', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fk', 'Falkland Islands', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fo', 'Faroe Islands', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fm', 'Federated States of Micronesia', '0503', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fj', 'Fiji', '0502', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fi', 'Finland', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fr', 'France', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('fx', 'France, Metropolitan', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gf', 'French Guiana', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pf', 'French Polynesia', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tf', 'French Southern Territories', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ga', 'Gabon', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gm', 'Gambia', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ge', 'Georgia', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('de', 'Germany', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gh', 'Ghana', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gi', 'Gibraltar', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gr', 'Greece', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gl', 'Greenland', '0204', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gd', 'Grenada', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gp', 'Guadeloupe', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gt', 'Guatemala', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gn', 'Guinea', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gw', 'Guinea Bissau', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('gy', 'Guyana', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ht', 'Haiti', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('hm', 'Heard & McDonald Isles', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('hn', 'Honduras', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('hk', 'Hong Kong', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('hu', 'Hungary', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('is', 'Iceland', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('in', 'India', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('id', 'Indonesia', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ir', 'Iran', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('iq', 'Iraq', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ie', 'Ireland', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('il', 'Israel', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('it', 'Italy', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('jm', 'Jamaica', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('jp', 'Japan', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('jo', 'Jordan', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kz', 'Kazakhstan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ke', 'Kenya', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ki', 'Kiribati', '0503', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kp', 'Korea (Democratic People\'s Republic)', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kr', 'Korea (Republic of)', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kw', 'Kuwait', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kg', 'Kyrgyzstan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('la', 'Laos', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lv', 'Latvia', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lb', 'Lebanon', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ls', 'Lesotho', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lr', 'Liberia', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ly', 'Libya', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('li', 'Liechtenstein', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lt', 'Lithuania', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lu', 'Luxembourg', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mo', 'Macao', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mk', 'Macedonia', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mg', 'Madagascar', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mw', 'Malawi', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('my', 'Malaysia', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mv', 'Maldives', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ml', 'Mali', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mt', 'Malta', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mh', 'Marshall Islands', '0503', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mq', 'Martinique', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mr', 'Mauritania', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mu', 'Mauritius', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mx', 'Mexico', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('md', 'Moldova', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mc', 'Monaco', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mn', 'Mongolia', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ms', 'Montserrat', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ma', 'Morocco', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mz', 'Mozambique', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mm', 'Myanmar', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('na', 'Namibia', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('nr', 'Nauru', '0503', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('np', 'Nepal', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('nl', 'Netherlands', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('an', 'Netherlands Antilles', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('nc', 'New Caledonia', '0502', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('nz', 'New Zealand', '0501', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ni', 'Nicaragua', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ne', 'Niger', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ng', 'Nigeria', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('nu', 'Niue', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('nf', 'Norfolk Island', '0501', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('mp', 'Northern Mariana Islands', '0503', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('no', 'Norway', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('om', 'Oman', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pk', 'Pakistan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pw', 'Palau', '0503', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pa', 'Panama', '0202', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pg', 'Papua New Guinea', '0502', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('py', 'Paraguay', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pe', 'Peru', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ph', 'Philippines', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pn', 'Pitcairn', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pl', 'Poland', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pt', 'Portugal', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pr', 'Puerto Rico', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('qa', 'Qatar', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('re', 'Reunion', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ro', 'Romania', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ru', 'Russian Federation', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('rw', 'Rwanda', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('kn', 'Saint Kitts & Nevis', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lc', 'Saint Lucia', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('vc', 'Saint Vincent & the Grenadines', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sm', 'San Marino', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('st', 'Sao Tome e Principe', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sa', 'Saudi Arabia', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sn', 'Senegal', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sc', 'Seychelles', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sl', 'Sierra Leone', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sg', 'Singapore', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sk', 'Slovakia', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('si', 'Slovenia', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sb', 'Solomon Islands', '0502', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('so', 'Somalia', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('za', 'South Africa', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('es', 'Spain', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('lk', 'Sri Lanka', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sh', 'St. Helena', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('pm', 'St. Pierre and Miquelon', '0204', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sd', 'Sudan', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sr', 'Suriname', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sj', 'Svalbard and Jan Mayen Islands', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sz', 'Swaziland', '0104', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('se', 'Sweden', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ch', 'Switzerland', '0404', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('sy', 'Syria', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tw', 'Taiwan', '0301', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tj', 'Tajikistan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tz', 'Tanzania', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('th', 'Thailand', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tg', 'Togo', '0105', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tk', 'Tokelau', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('to', 'Tonga', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tt', 'Trinidad & Tobago', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tn', 'Tunisia', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tr', 'Turkey', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tm', 'Turkmenistan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tc', 'Turks and Caicos Islands', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('tv', 'Tuvala', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ug', 'Uganda', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ua', 'Ukraine', '0401', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ae', 'United Arab Emirates', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('uk', 'United Kingdom', '0402', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('us', 'USA', '0204', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('uy', 'Uruguay', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('uz', 'Uzbekistan', '0302', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('vu', 'Vanuatu', '0502', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('va', 'Vatican City State', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ve', 'Venezuela', '0203', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('vn', 'Vietnam', '0304', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('vg', 'Virgin Islands (British)', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('vi', 'Virgin Islands (US)', '0201', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('wf', 'Wallis and Fortuna Islands', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ws', 'Western Samoa', '0504', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('eh', 'Western Sahara', '0103', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('ye', 'Yemen', '0305', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('yu', 'Yugoslavia', '0403', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('zr', 'Zaire', '0102', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('zm', 'Zambia', '0101', NULL);
INSERT INTO countries (countrycode, countryname, continent, flag) VALUES ('zw', 'Zimbabwe', '0101', NULL);


# --------------------------------------------------------
#
# Table structure for table `filetypes`
#

DROP TABLE IF EXISTS filetypes;
CREATE TABLE filetypes (
  filetypeid int(11) NOT NULL auto_increment,
  filetype varchar(8) NOT NULL default '',
  mimetype varchar(255) NOT NULL default '',
  authorid int(11) NOT NULL default '1',
  filecat varchar(12) NOT NULL default '',
  fileicon varchar(255) default NULL,
  PRIMARY KEY  (filetypeid),
  UNIQUE KEY fileref (filecat,filetype)
) TYPE=MyISAM;

#
# Data for table `filetypes`
#
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('gif','image/gif','1','Image','');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('jpg','image/jpeg;image/pjpeg','1','Image','');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('jpeg','image/jpeg;image/pjpeg','1','Image','');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('png','image/x-png','1','Image','');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('swf','application/x-shockwave-flash','1','Image','');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('zip','application/x-zip-compressed','1','Download','icons/filetypes/zip.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('gz','application/x-gzip-compressed','1','Download','icons/filetypes/zip.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('txt','text/plain','1','Download','icons/filetypes/text.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('pdf','application/pdf','1','Download','icons/filetypes/pdf.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('doc','application/msword','1','Download','icons/filetypes/doc.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('xls','application/msexcel;application/vnd.ms-excel','1','Download','icons/filetypes/xls.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('ppt','application/mspowerpoint','1','Download','icons/filetypes/ppt.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('gz','application/x-gzip-compressed','1','Backup','icons/filetypes/zip.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('sql','text/plain','1','Backup','icons/filetypes/text.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('php','application/octet-stream','1','Script','icons/filetypes/php.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('php3','application/octet-stream','1','Script','icons/filetypes/php.gif');
INSERT INTO filetypes (filetype, mimetype, authorid, filecat, fileicon) VALUES('js','text/html','1','Script','');


# --------------------------------------------------------


#
# Table structure for table `functiongroups`
#

DROP TABLE IF EXISTS functiongroups;
CREATE TABLE functiongroups (
  groupname varchar(32) NOT NULL default '',
  grouporderid int(4) NOT NULL default '0',
  controlvar varchar(32) default NULL,
  controltype char(2) default NULL,
  controlvalue varchar(16) default NULL,
  PRIMARY KEY  (groupname,grouporderid)
) TYPE=MyISAM;

#
# Data for table `functiongroups`
#
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('access', 1, NULL, '', '');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('menus', 2, NULL, '', '');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('templates', 3, NULL, '', '');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('contents', 4, NULL, '', '');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('languages', 5, 'gsMultiLanguage', '==', 'Y');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('styles', 6, NULL, '', '');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('statistics', 7, 'gsVisitorStats', '==', 'Y');
INSERT INTO functiongroups (groupname, grouporderid, controlvar, controltype, controlvalue) VALUES ('banners', 8, 'gsShowBanners', '!=', 'N');


# --------------------------------------------------------
#
# Table structure for table `functions`
#

DROP TABLE IF EXISTS functions;
CREATE TABLE functions (
  functionname varchar(32) NOT NULL default '',
  groupname varchar(32) NOT NULL default '',
  functionorderid int(4) NOT NULL default '0',
  controlvar varchar(32) default NULL,
  controltype char(2) default NULL,
  controlvalue varchar(16) default NULL,
  PRIMARY KEY  (groupname,functionorderid,functionname)
) TYPE=MyISAM;

#
# Data for table `functions`
#
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('privileges', 'access', 1, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('authors', 'access', 2, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('setregister', 'access', 3, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('backup', 'access', 4, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('sites', 'access', 5, 'gsMultiSite', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('filetypes', 'access', 6, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('menusettings', 'menus', 1, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('topgroups', 'menus', 2, 'gsShowTopMenu', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('groups', 'menus', 3, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('subgroups', 'menus', 4, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('tags', 'templates', 1, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('sidebars', 'templates', 2, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('imageformats', 'templates', 3, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('ratings', 'contents', 1, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('content', 'contents', 2, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('subcontent', 'contents', 3, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('images', 'contents', 4, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('scripts', 'contents', 5, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('downloads', 'contents', 6, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('languages', 'languages', 1, 'gsMultiLanguage', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('tusergroups', 'languages', 2, 'gsMultiLanguage', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('ttagcategories', 'languages', 3, 'gsMultiLanguage', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('serversettings', 'styles', 1, NULL, NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('sitesettings', 'styles', 2, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('themes', 'styles', 3, 'gsMultiTheme', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('colorsform', 'styles', 4, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('setgraphics', 'styles', 5, '', NULL, NULL);
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('userdata', 'styles', 6, 'gsUserdataFrame', '!=', 'N');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('viewstatistics', 'statistics', 1, 'gsVisitorStats', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('prunestatistics', 'statistics', 2, 'gsVisitorStats', '==', 'Y');
INSERT INTO functions (functionname, groupname, functionorderid, controlvar, controltype, controlvalue) VALUES ('banners', 'banners', 1, 'gsShowBanners', '!=', 'N');


# --------------------------------------------------------
#
# Table structure for table `groups`
#

DROP TABLE IF EXISTS groups;
CREATE TABLE groups (
  groupid int(11) unsigned NOT NULL auto_increment,
  groupdesc varchar(100) default NULL,
  grouplink varchar(255) default NULL,
  grouporderid int(10) NOT NULL default '0',
  menuimage1 varchar(255) default NULL,
  menuimage2 varchar(255) default NULL,
  menuvisible char(1) default 'Y',
  menuorderby char(1) default '1',
  menuorderdir char(1) default 'A',
  hovertitle varchar(255) default NULL,
  openinpage char(1) default NULL,
  topgroupname varchar(32) default NULL,
  loginreq char(1) default NULL,
  usergroups varchar(255) default NULL,
  groupname varchar(32) default NULL,
  language char(2) NOT NULL default '',
  menuimage3 varchar(255) default NULL,
  menuimage4 varchar(255) default NULL,
  authorid int(11) NOT NULL default '0',
  subgroupcount int(11) NOT NULL default '0',
  PRIMARY KEY  (groupid),
  UNIQUE KEY groupref (groupname,language),
  KEY parentref (topgroupname,language)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `imageformattemplates`
#

DROP TABLE IF EXISTS imageformattemplates;
CREATE TABLE imageformattemplates (
  imageformatid int(11) NOT NULL auto_increment,
  imageformatname varchar(255) NOT NULL default '',
  ifalign char(1) default 'L',
  ifborder int(2) default '1',
  ifbgcolor varchar(255) default NULL,
  authorid int(11) NOT NULL default '0',
  PRIMARY KEY  (imageformatid),
  UNIQUE KEY imageformatname (imageformatname)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `languages`
#

DROP TABLE IF EXISTS languages;
CREATE TABLE languages (
  languagecode char(2) NOT NULL default '',
  languagename varchar(24) NOT NULL default '',
  charset varchar(32) default NULL,
  enabled char(1) default 'N',
  direction varchar(3) default 'ltr',
  translationby varchar(255),
  PRIMARY KEY  (languagecode),
  KEY languagecode (enabled,languagecode)
) TYPE=MyISAM;

#
# Data for table `languages`
#
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('nl', 'Nederlands', 'iso-8859-1, windows-1252', 'N', 'ltr','Marek Lyczba');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('en', 'English', 'iso-8859-1, windows-1252', 'N', 'ltr', 'Mark Baker');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('fr', 'Fran&ccedil;ais', 'iso-8859-1, windows-1252', 'N', 'ltr', 'Diablo');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('de', 'Deutsch', 'iso-8859-1, windows-1252', 'N', 'ltr', 'Sascha Zindel');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('es', 'Espa&ntilde;ol', 'iso-8859-1, windows-1252', 'N', 'ltr', 'root-axis');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('aa', 'Afar', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ab', 'Abkhazian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('af', 'Afrikaans', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('am', 'Amharic', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ar', 'Arabic', 'iso-8859-6', 'N', 'rtl');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('as', 'Assamese', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ay', 'Aymara', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('az', 'Azerbaijani', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ba', 'Bashkir', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('be', 'Byelorussian', 'iso-8859-5', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('bg', 'Bulgarian', 'iso-8859-5', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('bh', 'Bihari', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('bi', 'Bislama', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('bn', 'Bengali; Bangla', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('bo', 'Tibetan', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('br', 'Breton', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ca', 'Catalan', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('co', 'Corsican', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('cs', 'Czech', 'iso-8859-2', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('cy', 'Welsh', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('da', 'Dansk', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('dz', 'Bhutani', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('el', 'Greek', 'iso-8859-7', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('eo', 'Esperanto', 'iso-8859-3', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('et', 'Estonian', 'iso-8859-15', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('eu', 'Basque', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('fa', 'Persian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('fi', 'Suomi', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('fj', 'Fiji', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('fo', 'Faeroese', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('fy', 'Frisian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ga', 'Irish', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('gd', 'Scots Gaelic', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('gl', 'Galician', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('gn', 'Guarani', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('gu', 'Gujarati', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ha', 'Hausa', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('hi', 'Hindi', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('hr', 'Croatian', 'iso-8859-2, windows-1250', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('hu', 'Hungarian', 'iso-8859-2', 'N', 'ltr', 'Moshu');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('hy', 'Armenian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ia', 'Interlingua', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ie', 'Interlingue', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ik', 'Inupiak', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('in', 'Indonesian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('is', 'Icelandic', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('it', 'Italiano', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('iw', 'Hebrew', 'iso-8859-8', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ja', 'Japanese', 'shift_jis, iso-2022-jp, euc-jp', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ji', 'Yiddish', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('jw', 'Javanese', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ka', 'Georgian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('kk', 'Kazakh', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('kl', 'Greenlandic', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('km', 'Cambodian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('kn', 'Kannada', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ko', 'Korean', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ks', 'Kashmiri', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ku', 'Kurdish', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ky', 'Kirghiz', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('la', 'Latin', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ln', 'Lingala', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('lo', 'Laothian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('lt', 'Lithuanian', 'iso-8859-13, windows-1257', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('lv', 'Latvian, Lettish', 'iso-8859-13, windows-1257', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mg', 'Malagasy', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mi', 'Maori', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mk', 'Macedonian', 'iso-8859-5, windows-1251', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ml', 'Malayalam', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mn', 'Mongolian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mo', 'Moldavian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mr', 'Marathi', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ms', 'Malay', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('mt', 'Maltese', 'iso-8859-3', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('my', 'Burmese', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('na', 'Nauru', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ne', 'Nepali', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('no', 'Norwegian', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('oc', 'Occitan', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('om', '(Afan) Oromo', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('or', 'Oriya', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('pa', 'Punjabi', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('pl', 'Polish', 'iso-8859-2', 'N', 'ltr', 'Jaroslaw Gilewski');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ps', 'Pashto, Pushto', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('pt', 'Portuguese', 'iso-8859-1, windows-1252', 'N', 'ltr', 'Marcelo Yoshiro');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('qu', 'Quechua', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('rm', 'Rhaeto-Romance', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('rn', 'Kirundi', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ro', 'Romanian', 'iso-8859-2', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('ru', 'Russian', 'koi8-r, iso-8859-5', 'N', 'ltr', 'Nick Stankevich');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('rw', 'Kinyarwanda', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sa', 'Sanskrit', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sd', 'Sindhi', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sg', 'Sangro', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sh', 'Serbo-Croatian', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('si', 'Singhalese', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sk', 'Slovak', 'iso-8859-2', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sl', 'Slovenian', 'iso-8859-2, windows-1250', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sm', 'Samoan', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sn', 'Shona', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('so', 'Somali', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sq', 'Albanian', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sr', 'Serbian', 'iso-8859-2, windows-1250', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ss', 'Siswati', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('st', 'Sesotho', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('su', 'Sudanese', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sv', 'Svenska', 'iso-8859-1, windows-1252', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('sw', 'Swahili', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ta', 'Tamil', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('te', 'Telugu', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tg', 'Tajik', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('th', 'Thai', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ti', 'Tigrinya', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tk', 'Turkmen', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tl', 'Tagalog', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tn', 'Setswana', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('to', 'Tonga', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tr', 'Turkish', 'iso-8859-9, windows-1254', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ts', 'Tsonga', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tt', 'Tatar', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('tw', 'Twi', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('uk', 'Ukrainian', 'iso-8859-5', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('ur', 'Urdu', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('uz', 'Uzbek', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('vi', 'Vietnamese', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('vo', 'Volapuk', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('wo', 'Wolof', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('xh', 'Xhosa', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('yo', 'Yoruba', '', 'N', 'ltr');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction, translationby) VALUES ('zh', 'Chinese (b5)', 'big5', 'N', 'ltr', 'Steven Wu');
INSERT INTO languages (languagecode, languagename, charset, enabled, direction) VALUES ('zu', 'Zulu', '', 'N', 'ltr');


# --------------------------------------------------------
#
# Table structure for table `modules`
#

DROP TABLE IF EXISTS modules;
CREATE TABLE modules (
  moduleid int(11) NOT NULL auto_increment,
  modulename varchar(32) NOT NULL default '',
  extin char(1) NOT NULL default 'E',
  moduledirectory varchar(255) NOT NULL default '',
  modulescript varchar(255) NOT NULL default '',
  modulesubmit char(1) default 'N',
  PRIMARY KEY  (moduleid),
  UNIQUE KEY module (extin,modulename)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `modulesettings`
#

DROP TABLE IF EXISTS modulesettings;
CREATE TABLE modulesettings (
  modulename varchar(32) NOT NULL default '',
  settingname varchar(50) NOT NULL default '',
  settingvalue text,
  PRIMARY KEY ( modulename, settingname )
) TYPE = MyISAM;


# --------------------------------------------------------
#
# Table structure for table `ratings`
#

DROP TABLE IF EXISTS ratings;
CREATE TABLE ratings (
  ratingid int(11) NOT NULL auto_increment,
  authorid varchar(32) NOT NULL default '',
  contentname varchar(32) NOT NULL default '',
  rating int(2) NOT NULL default '99',
  comments text,
  PRIMARY KEY  (ratingid),
  UNIQUE KEY rated (authorid,contentname)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `sessions`
#

DROP TABLE IF EXISTS sessions;
CREATE TABLE sessions (
  SID varchar(32) NOT NULL default '',
  expiration int(11) NOT NULL default '0',
  sessvalue text NOT NULL,
  PRIMARY KEY  (SID)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `settings`
#

DROP TABLE IF EXISTS settings;
CREATE TABLE settings (
  settingname varchar(50) NOT NULL default '',
  cssentry char(1) default NULL,
  settingvalue text,
  PRIMARY KEY  (settingname)
) TYPE=MyISAM;

#
# Data for table `settings`
#
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('version', '', '2.0.1');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_main', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_cnttbl', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_headercnt', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_header', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_footer', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_menu', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_header', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_ahref', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_ahref_hover', 'Y', 'Green');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_ahref_visited', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menu_color_ahref', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menu_color_ahref_hover', 'Y', 'Green');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menu_color_ahref_visited', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenu_color_ahref', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenu_color_ahref_hover', 'Y', 'Green');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenu_color_ahref_visited', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_ahref_small', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_ahref_small_hover', 'Y', 'Green');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_ahref_small_visited', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_td', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_h1', 'Y', 'FFFFFF');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('homepagelogo', '', 'bgtop.jpg');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('headerbg', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menubg', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topbg', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('mainbg', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenuborder', '', '0');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenualign', '', 'L');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenuseparator', '', '[ ? | ? ]');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menuborder', '', '0');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menudistance1', '', '8');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menudistance2', '', '8');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menudistance3', '', '4');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menudistance4', '', '12');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('privatemenus', '', 'L');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('useframes', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('font1', 'Y', 'Verdana');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('fontsize1', 'Y', '12px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('fontsize2', 'Y', '24px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('sitetitle', '', 'Visual Shapers - Developers Resource');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('sitedesc', '', 'ezContents is an easy website content management system. You can maintain menus and submenus, add authors and maintain the entire contents of a website.');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('sitekeywords', '', 'CMS, ezcontents, content management system, php, mysql, apache');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('headerbgrep', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menubgrep', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topbgrep', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('mainbgrep', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('fontsize3', 'Y', '11px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('fontstyle1', 'Y', 'None');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('fontstyle3', 'Y', 'None');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topframe_height', '', '120');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('leftframe_width', '', '180');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('expandmenus', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('showbanners', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('use_compression', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('timegen_display', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('default_language', '', 'en');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('timezone', '', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('tophtml', '', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('showtopmenu', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenuframe_height', '', '46');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_topmenu', 'Y', 'LightBlue');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenu_fontsize', 'Y', '13px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenu_fontstyle', 'Y', 'None');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('userdataframe', '', 'T');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('userdataframewidth', '', '350');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('hoverdisplay', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('lrcontentframe', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rightcolumnwidth', '', '250');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('imagecolumnbreak', '', 'column_separator.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_tsrtbl', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bgcolor_headertsr', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_tsrheader', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('color_tsrtd', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('smallfontsize', 'Y', '9px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bottomframe', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bottomframe_height', '', '32');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('footer', '', '<CENTER><FONT COLOR="YELLOW">ezContents CMS Version 2.0.0</FONT></CENTER>');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('homepagetopgroup', '', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('visitorstats', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('secureserver', '', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenurows', '', '3');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menuframealign', '', 'L');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('allowratings', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('allowcomments', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('ratingmin', '', '1');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('ratingmax', '', '5');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('ratingimage1', '', 'icons/star.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('ratingimage2', '', 'icons/nostar.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('vetcomments', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('dateformat', '', '%A %B %d, %Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('ratingicon', '', 'icons/rateicon.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('printicon', '', 'icons/printer.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('commenticon', '', 'icons/commenticon2.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('secureicon', '', 'icons/private.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('homepagegroup', '', 'Welcome');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('privdefault', '', 'probationer');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('printerfriendly', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_color_ahref', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcolfontsize', 'Y', '10px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_color_ahref_hover', 'Y', 'Green');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_color_ahref_visited', 'Y', 'Red');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_headerfontsize', 'Y', '18px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_fontstyle', 'Y', 'Underline');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_bgcolor_headercnt', 'Y', 'LightBlue');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_bgcolor_cnttbl', 'Y', 'White');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_color_header', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('rcol_color_td', 'Y', 'Black');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('serveruseremail', '', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('phone_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('fax_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('address_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('city_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('state_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('zip_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('website_status', '', 'O');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('comments_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('errform_font_color', 'Y', 'blue');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('newsletter_status', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('show_helptexts', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('country_status', '', 'O');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenu_bgimage', '', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('sendconfirmationmail', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('helptext_fontsize', 'Y', '10px');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('language_status', '', 'O');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('helptext_color', 'Y', 'Gray');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('firstpageicon', '', 'first_button.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('prevpageicon', '', 'prev_button.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('nextpageicon', '', 'next_button.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('lastpageicon', '', 'last_button.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('sectionsecurity', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('sitewidth', '', '800');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('siteheight', '', '600');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('adminprivgroup', '', 'administrator');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('collapsemenus', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('expandicon', '', 'icons/plus.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('collapseicon', '', 'icons/minus.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('noexpandicon', '', 'icons/blank.gif');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('multisite', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('multilanguage', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('multisiteauthors', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('multitheme', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('teaserwithdetails', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('breadcrumb', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('breadcrumbseparator', '', '&nbsp;>&nbsp;');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('bookmark', '', 'Y');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('mainbgfix', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('menubgfix', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topbgfix', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenubg', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenubgrep', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('topmenubgfix', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('footerbg', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('footerbgrep', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('footerbgfix', 'Y', '');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('registration_hash', '', '23ba851805e7f2b0cb31c94051c8ed60');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('registration_details', '', '<-- BEGIN REGISTRATION BLOCK -->\nezContents CMS Version 2.0.0\nPublic Beta Release\nBeta Test License\n<a href="http://www.ezcontents.org/" target="_blank">http://www.ezcontents.org/</a>\n<-- END REGISTRATION BLOCK -->');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('registration_date', '', '2004-01-01');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('WYSIWYG_Version', '', '3 Beta');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('WYSIWYG_TableManager', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('WYSIWYG_SpellChecker', '', 'N');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('PoweredByEZC', '', 'M');
INSERT INTO settings (settingname, cssentry, settingvalue) VALUES ('favicon', '', '');


# --------------------------------------------------------
#
# Table structure for table `sidebartemplates`
#

DROP TABLE IF EXISTS sidebartemplates;
CREATE TABLE sidebartemplates (
  sidebarid int(11) NOT NULL auto_increment,
  sidebarname varchar(255) NOT NULL default '',
  sbalign char(1) default 'L',
  sbborder int(2) default '1',
  sbbgcolor varchar(255) default NULL,
  sbwidth varchar(4) NOT NULL default '50%',
  authorid int(11) NOT NULL default '0',
  PRIMARY KEY  (sidebarid),
  UNIQUE KEY sidebarname (sidebarname)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `sites`
#

DROP TABLE IF EXISTS sites;
CREATE TABLE sites (
  sitecode varchar(16) NOT NULL default '',
  sitename varchar(64) NOT NULL default '',
  sitedescription text,
  siteenabled char(1) default NULL,
  PRIMARY KEY  (sitecode)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `specialcontents`
#

DROP TABLE IF EXISTS specialcontents;
CREATE TABLE specialcontents (
  scid int(11) NOT NULL auto_increment,
  scname varchar(32) NOT NULL default '',
  sctitle varchar(255) NOT NULL default '',
  scdb varchar(32) NOT NULL default '',
  screg char(1) default 'Y',
  scvalid char(1) default 'Y',
  stextdisplay char(1) default 'Y',
  stext varchar(255) default NULL,
  sgraphicdisplay char(1) default 'Y',
  sgraphic varchar(255) default NULL,
  usergroups varchar(255) default NULL,
  scuseprefix char(1) default 'N',
  scusecategories char(1) default 'N',
  orderby char(1) default 'D',
  showpostedby char(1) default 'N',
  showposteddate char(1) default 'N',
  perpage int(4) default '1',
  PRIMARY KEY  (scid),
  UNIQUE KEY scname (scname)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `subgroups`
#

DROP TABLE IF EXISTS subgroups;
CREATE TABLE subgroups (
  subgroupid int(11) unsigned NOT NULL auto_increment,
  groupname varchar(32) NOT NULL default '',
  subgroupdesc varchar(100) default NULL,
  subgrouplink varchar(255) default NULL,
  subgrouporderid int(10) NOT NULL default '0',
  submenuimage1 varchar(255) default NULL,
  submenuimage2 varchar(255) default NULL,
  submenuvisible char(1) default 'Y',
  submenuorderby char(1) default '1',
  submenuorderdir char(1) default 'A',
  hovertitle varchar(255) default NULL,
  openinpage char(1) default NULL,
  loginreq char(1) default NULL,
  usergroups varchar(255) default NULL,
  subgroupname varchar(32) default NULL,
  language char(2) NOT NULL default '',
  submenuimage3 varchar(255) default NULL,
  submenuimage4 varchar(255) default NULL,
  authorid int(11) NOT NULL default '0',
  PRIMARY KEY  (subgroupid),
  UNIQUE KEY subgroupref (language,subgroupname),
  KEY parentref (groupname,language)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `tagcategories`
#

DROP TABLE IF EXISTS tagcategories;
CREATE TABLE tagcategories (
  catid int(11) unsigned NOT NULL auto_increment,
  catdesc varchar(48) NOT NULL default '',
  catname varchar(32) NOT NULL default '',
  language char(2) NOT NULL default '',
  authorid int(11) NOT NULL default '1',
  PRIMARY KEY  (catid),
  UNIQUE KEY catref (language,catname)
) TYPE=MyISAM;

#
# Data for table `tagcategories`
#
# This data is dynamically loaded by the install script dependent on the languages being installed


# --------------------------------------------------------
#
# Table structure for table `tags`
#

DROP TABLE IF EXISTS tags;
CREATE TABLE tags (
  tagid int(11) NOT NULL auto_increment,
  tag varchar(32) NOT NULL default '',
  canedit char(1) default NULL,
  candelete char(1) default NULL,
  translation text NOT NULL,
  authorid int(11) NOT NULL default '1',
  cat varchar(32) NOT NULL default '',
  PRIMARY KEY  (tagid),
  UNIQUE KEY tagref (cat,tag)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `themes`
#

DROP TABLE IF EXISTS themes;
CREATE TABLE themes (
  themecode varchar(16) NOT NULL default '',
  themename varchar(64) NOT NULL default '',
  themedescription text,
  themeenabled char(1) default NULL,
  PRIMARY KEY  (themecode)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `topgroups`
#

DROP TABLE IF EXISTS topgroups;
CREATE TABLE topgroups (
  topgroupid int(11) unsigned NOT NULL auto_increment,
  topgroupdesc varchar(100) default NULL,
  topgrouplink varchar(255) default NULL,
  topgrouporderid int(10) NOT NULL default '0',
  topmenuimage1 varchar(255) default NULL,
  topmenuimage2 varchar(255) default NULL,
  tophovertitle varchar(255) default NULL,
  topmenuvisible char(1) default 'Y',
  topmenuorderby char(1) default '1',
  topmenuorderdir char(1) default 'A',
  topopeninpage char(1) default NULL,
  loginreq char(1) default NULL,
  usergroups varchar(255) default NULL,
  topgroupname varchar(32) default NULL,
  language char(2) NOT NULL default '',
  topmenuimage3 varchar(255) default NULL,
  topmenuimage4 varchar(255) default NULL,
  authorid int(11) NOT NULL default '0',
  PRIMARY KEY  (topgroupid),
  UNIQUE KEY topgroupref (language,topgroupname)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table `userdata`
#

DROP TABLE IF EXISTS userdata;
CREATE TABLE userdata (
  userdataname varchar(32) NOT NULL default '',
  userdataenabled char(1) default NULL,
  userdataorderid int(2) NOT NULL default '0',
  userdatavar varchar(32) NOT NULL default '',
  userdatatype char(2) NOT NULL default '',
  userdatavalue varchar(16) NOT NULL default '',
  PRIMARY KEY  (userdataname),
  KEY userdataorderid (userdataorderid,userdataname)
) TYPE=MyISAM;

#
# Data for table `userdata`
#
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('loginmessage', '1', 1, '', '', '');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('loginlogout', '1', 2, '', '', '');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('adminfunctions', '1', 3, '', '', '');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('preferences', '1', 4, '', '', '');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('memberlist', '1', 5, '', '', '');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('language', '0', 6, 'gsMultiLanguage', '==', 'Y');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('selectlanguage', '1', 7, 'gsMultiLanguage', '==', 'Y');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('selectsite', '0', 9, 'gsMultiSite', '==', 'Y');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('site', '0', 8, 'gsMultiSite', '==', 'Y');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('selecttheme', '1', 11, 'gsMultiSite', '==', 'Y');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('theme', '0', 10, 'gsMultiTheme', '==', 'Y');
INSERT INTO userdata (userdataname, userdataenabled, userdataorderid, userdatavar, userdatatype, userdatavalue) VALUES ('homesite', '0', 12, 'gsMultiSite', '==', 'Y');


# --------------------------------------------------------
#
# Table structure for table `usergroups`
#

DROP TABLE IF EXISTS usergroups;
CREATE TABLE usergroups (
  usergroupid int(11) unsigned NOT NULL auto_increment,
  usergroupdesc varchar(48) NOT NULL default '',
  usergroupname varchar(32) NOT NULL default '',
  language char(2) NOT NULL default '',
  authorid int(11) NOT NULL default '1',
  PRIMARY KEY  (usergroupid),
  UNIQUE KEY usergroupref (language,usergroupname)
) TYPE=MyISAM;

#
# Data for table `usergroups`
#
# This data is dynamically loaded by the install script dependent on the languages being installed


# --------------------------------------------------------
#
# Table structure for table `userprivileges`
#

DROP TABLE IF EXISTS userprivileges;
CREATE TABLE userprivileges (
  refid int(11) unsigned NOT NULL auto_increment,
  usergroupname varchar(32) NOT NULL default '',
  functionname varchar(32) NOT NULL default '',
  accessview char(1) default NULL,
  accessedit char(1) default NULL,
  accessadd char(1) default NULL,
  accessdelete char(1) default NULL,
  accesstranslate char(1) default NULL,
  PRIMARY KEY  (refid),
  UNIQUE KEY privilege (usergroupname,functionname)
) TYPE=MyISAM;

#
# Data for table `userprivileges`
#
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'privileges', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'authors', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'setregister', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'backup', 'Y', 'X', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'sites', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'filetypes', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'menusettings', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'topgroups', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'groups', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'subgroups', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'tags', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'sidebars', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'imageformats', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'ratings', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'content', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'subcontent', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'images', 'Y', 'X', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'scripts', 'Y', 'X', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'downloads', 'Y', 'X', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'languages', 'Y', 'Y', 'Y', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'tusergroups', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'ttagcategories', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'serversettings', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'sitesettings', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'themes', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'colorsform', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'setgraphics', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'userdata', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'viewstatistics', 'Y', 'X', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'prunestatistics', 'X', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('administrator', 'banners', 'Y', 'Y', 'Y', 'Y', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'privileges', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'authors', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'setregister', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'backup', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'sites', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'filetypes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'menusettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'topgroups', 'Y', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'groups', 'Y', '', 'Y', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'subgroups', 'Y', '', 'Y', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'tags', 'Y', '', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'sidebars', 'Y', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'imageformats', 'Y', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'ratings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'content', 'Y', '', 'Y', '', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'subcontent', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'images', 'Y', 'X', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'scripts', 'Y', 'X', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'downloads', 'Y', 'X', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'languages', 'Y', '', '', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'tusergroups', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'ttagcategories', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'serversettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'sitesettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'themes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'colorsform', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'setgraphics', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'userdata', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'viewstatistics', 'Y', 'X', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'prunestatistics', 'X', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('contributor', 'banners', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'privileges', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'authors', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'setregister', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'backup', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'sites', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'filetypes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'menusettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'topgroups', 'Y', '', '', '', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'groups', 'Y', '', '', '', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'subgroups', 'Y', '', '', '', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'tags', 'Y', '', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'sidebars', 'Y', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'imageformats', 'Y', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'ratings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'content', 'Y', '', '', '', 'Y');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'subcontent', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'images', 'Y', 'X', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'scripts', 'Y', 'X', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'downloads', 'Y', 'X', 'Y', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'languages', 'Y', 'Y', 'Y', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'tusergroups', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'ttagcategories', 'Y', 'Y', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'serversettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'sitesettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'themes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'colorsform', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'setgraphics', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'userdata', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'viewstatistics', '', 'X', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'prunestatistics', 'X', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('translator', 'banners', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'privileges', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'authors', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'setregister', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'backup', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'sites', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'filetypes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'menusettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'topgroups', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'groups', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'subgroups', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'tags', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'sidebars', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'imageformats', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'ratings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'content', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'subcontent', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'images', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'scripts', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'downloads', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'languages', '', '', '', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'tusergroups', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'ttagcategories', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'serversettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'sitesettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'themes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'colorsform', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'setgraphics', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'userdata', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'viewstatistics', 'Y', 'X', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'prunestatistics', 'X', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('member', 'banners', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'privileges', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'authors', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'setregister', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'backup', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'sites', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'filetypes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'menusettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'topgroups', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'groups', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'subgroups', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'tags', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'sidebars', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'imageformats', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'ratings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'content', '', '', '', '', '');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'subcontent', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'images', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'scripts', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'downloads', '', 'X', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'languages', '', '', '', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'tusergroups', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'ttagcategories', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'serversettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'sitesettings', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'themes', '', '', '', '', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'colorsform', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'setgraphics', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'userdata', '', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'viewstatistics', '', 'X', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'prunestatistics', 'X', '', 'X', 'X', 'X');
INSERT INTO userprivileges (usergroupname, functionname, accessview, accessedit, accessadd, accessdelete, accesstranslate) VALUES ('probationer', 'banners', '', '', '', '', 'X');


# --------------------------------------------------------
#
# Table structure for table `visitorstats`
#

DROP TABLE IF EXISTS visitorstats;
CREATE TABLE visitorstats (
  statid int(11) unsigned NOT NULL auto_increment,
  site varchar(16) NOT NULL default 'ALL',
  visitdate datetime NOT NULL default '2000-02-01 00:00:00',
  visitorip varchar(16) default NULL,
  visitoragent varchar(128) default NULL,
  visitoros varchar(32) default NULL,
  visitorbrowser varchar(32) default NULL,
  visitorreferrer varchar(128) default NULL,
  country varchar(32) default NULL,
  countnumber int(11) unsigned NOT NULL default '1',
  PRIMARY KEY  (statid),
  KEY site (site,visitdate)
) TYPE=MyISAM;
