install/mysql/tables.php

<?php
$create[user] = "CREATE TABLE $user (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate latin1_general_ci NOT NULL default '',
  `password` varchar(255) collate latin1_general_ci NOT NULL default '',
  `email` varchar(255) collate latin1_general_ci NOT NULL default '',
  `level` int(11) NOT NULL default '0',
  `autologin` int(1) NOT NULL default '0',
  `location` varchar(30) collate latin1_general_ci NOT NULL default '',
  `interests` varchar(100) collate latin1_general_ci NOT NULL default '',
  `icq_nr` varchar(12) NOT NULL default '0',
  `job` varchar(30) collate latin1_general_ci NOT NULL default '',
  `ban` int(1) NOT NULL default '0',
  `session_time` varchar(25) collate latin1_general_ci NOT NULL,
  `time` varchar(5) collate latin1_general_ci NOT NULL,
  `active` char(1) collate latin1_general_ci NOT NULL default '',
  `act_key` varchar(255) collate latin1_general_ci NOT NULL default '',
  `ice` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1";

$create[sessions] = "CREATE TABLE $sessions (
  `id` int(11) NOT NULL auto_increment,
  `session_time` varchar(30) collate latin1_general_ci NOT NULL,
  `session_ip` varchar(30) collate latin1_general_ci NOT NULL,
  `time` varchar(30) collate latin1_general_ci NOT NULL,
  `name` varchar(14) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1";

$create[config] = "CREATE TABLE $config (
  `menu_title` varchar(20) collate latin1_general_ci NOT NULL default '',
  `default_style` varchar(35) collate latin1_general_ci NOT NULL default '',
  `default_language` varchar(28) collate latin1_general_ci NOT NULL default '',
  `footer_title` varchar(255) collate latin1_general_ci NOT NULL default '',
  `path` varchar(55) collate latin1_general_ci NOT NULL default '',
  `domain_name` varchar(255) collate latin1_general_ci NOT NULL default '',
  `website_name` varchar(90) collate latin1_general_ci NOT NULL default '',
  `logo_url` varchar(255) collate latin1_general_ci NOT NULL default '',
  `email` varchar(255) collate latin1_general_ci NOT NULL default '',
  `gb_entries_per_site` int(11) NOT NULL,
  `comments_per_site` int(11) NOT NULL,
  `frontpage` varchar(31) collate latin1_general_ci NOT NULL default '',
  `gb_wait` int(11) NOT NULL,
  `gb_on` int(11) NOT NULL,
  `contact_form_on` int(1) NOT NULL,
  `change_of_name` int(1) NOT NULL,
  `wio_on` int(1) NOT NULL,
  `max_pms` int(11) NOT NULL,
  `disable` int(1) NOT NULL,
  `editor_on` int(1) NOT NULL,
  `website_title` varchar(56) collate latin1_general_ci NOT NULL,
  `v_ai` int(1) NOT NULL,
  `v_hpi` int(1) NOT NULL,
  `v_so` int(1) NOT NULL,
  `v_ans` int(1) NOT NULL,
  `v_co` int(1) NOT NULL,
  `v_anc` int(1) NOT NULL,
  `v_mo` int(1) NOT NULL,
  `v_anm` int(1) NOT NULL,
  `v_cc` int(1) NOT NULL,
  `v_cot` int(1) NOT NULL,
  `v_cu` int(1) NOT NULL,
  `v_trash` int(1) NOT NULL,
  `comments` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci";
?>