CREATE TABLE ibf_files (
 id mediumint(8) unsigned NOT NULL auto_increment,
 cat tinyint(3) unsigned NOT NULL default '0',
 sname varchar(70) NOT NULL default '',
 sdesc text NOT NULL,
 author varchar(75) NOT NULL default '',
 poster varchar(75) NOT NULL default '',
 mid mediumint(8) unsigned NOT NULL default '0',
 date varchar(13) NOT NULL default '',
 updated varchar(13) NOT NULL default '',
 views smallint(5) unsigned NOT NULL default '0',
 downloads smallint(6) NOT NULL default '0',
 topic mediumint(8) NOT NULL default '0',
 open tinyint(1) NOT NULL default '0',
 screenshot varchar(250) NOT NULL default '',
 screenshot1 varchar(250) NOT NULL default '',
 votes tinyint(4) NOT NULL default '0',
 total tinyint(4) NOT NULL default '0',
 rating tinyint(4) NOT NULL default '0',
 url varchar(250) NOT NULL default '',
 link varchar(250) NOT NULL default '',
 current tinyint(1) NOT NULL default '1',
 ipaddress varchar(32) NOT NULL default '0',
 UNIQUE KEY id (id)
) TYPE=MyISAM;



CREATE TABLE ibf_files_cats (
 cid tinyint(3) unsigned NOT NULL default '0',
 sub tinyint(3) NOT NULL default '0',
 cname varchar(50) NOT NULL default '',
 cdesc tinytext NOT NULL,
 copen tinyint(1) unsigned NOT NULL default '1',
 dis_screen tinyint(1) unsigned NOT NULL default '0',
 dis_screen_cat tinyint(1) unsigned NOT NULL default '0',
 screen_req tinyint(1) unsigned NOT NULL default '0',
 authorize tinyint(1) unsigned NOT NULL default '0',
 fordaforum smallint(5) unsigned NOT NULL default '0',
 position tinyint(4) NOT NULL auto_increment,
 show_notes tinyint(1) NOT NULL default '0',
 cnotes tinytext NOT NULL,
 group_perm varchar(250) NOT NULL default '*',
 UNIQUE KEY id (cid),
 KEY position (position),
 KEY sub (sub)
) TYPE=MyISAM;



CREATE TABLE ibf_files_comments (
 id mediumint(8) NOT NULL auto_increment,
 file_id mediumint(8) unsigned NOT NULL default '0',
 mem_id mediumint(8) unsigned NOT NULL default '0',
 name varchar(75) NOT NULL default '',
 date varchar(13) NOT NULL default '0',
 comment mediumtext NOT NULL,
 PRIMARY KEY  (id)
) TYPE=MyISAM;



CREATE TABLE ibf_files_custentered (
 file_id mediumint(8) NOT NULL default '0',
 PRIMARY KEY  (file_id)
) TYPE=MyISAM;


CREATE TABLE ibf_files_custfields (
 fid smallint(5) NOT NULL auto_increment,
 ftitle varchar(200) NOT NULL default '',
 fcontent text,
 ftype varchar(250) default 'text',
 freq tinyint(1) NOT NULL default '0',
 fshow tinyint(1) NOT NULL default '0',
 fmaxinput smallint(6) default '250',
 ftopic tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (fid)
) TYPE=MyISAM;



CREATE TABLE ibf_files_downloads (
 m_id mediumint(8) unsigned NOT NULL default '0',
 member_name varchar(75) NOT NULL default '',
 downloaded varchar(13) NOT NULL default '0',
 file_id mediumint(8) NOT NULL default '0',
 file_name varchar(70) NOT NULL default '',
 KEY id (m_id),
 KEY script_id (file_id)
) TYPE=MyISAM;




CREATE TABLE ibf_files_favorites (
 id mediumint(8) NOT NULL default '0',
 mid mediumint(8) NOT NULL default '0',
 mname varchar(50) NOT NULL default '',
 fid mediumint(8) NOT NULL default '0',
 fname varchar(75) NOT NULL default '',
 date varchar(13) NOT NULL default '',
 PRIMARY KEY  (id)
) TYPE=MyISAM;



CREATE TABLE ibf_files_votes (
 mid mediumint(8) NOT NULL default '0',
 rating tinyint(1) NOT NULL default '0',
 did mediumint(8) NOT NULL default '0'
) TYPE=MyISAM;



ALTER TABLE `ibf_groups` ADD `g_d_add_files` TINYINT (1) DEFAULT '0' AFTER `g_calendar_post` ,
                        ADD `g_d_ibcode_files` TINYINT (1) DEFAULT '0' AFTER `g_d_add_files` ,
                        ADD `g_d_html_files` TINYINT (1) DEFAULT '0' AFTER `g_d_ibcode_files` ,
                        ADD `g_do_download` TINYINT (1) DEFAULT '0' AFTER `g_d_html_files` ,
                        ADD `g_d_edit_files` TINYINT (1) DEFAULT '0' AFTER `g_do_download` ,
                        ADD `g_d_manage_files` TINYINT (1) DEFAULT '0' AFTER `g_d_edit_files`,
                        ADD `g_d_allow_dl_offline` TINYINT(1) UNSIGNED DEFAULT '0' AFTER `g_d_manage_files`,
                        ADD `g_d_post_comments` TINYINT (1) DEFAULT '0' AFTER `g_d_allow_dl_offline` ,
                        ADD `g_d_approve_down` TINYINT (1) DEFAULT '0' AFTER `g_d_post_comments` ,
                        ADD `g_d_eofs` TINYINT (1) DEFAULT '0' AFTER `g_d_approve_down`,
                        ADD `g_d_optimize_db` TINYINT(1) UNSIGNED DEFAULT '0' AFTER `g_d_eofs`,
                        ADD `g_d_check_links` TINYINT (1) DEFAULT '0' AFTER `g_d_optimize_db` ,
                        ADD `g_d_check_topics` TINYINT (1) DEFAULT '0' AFTER `g_d_check_links`,
    ADD `g_d_max_dls` TINYINT (4) NOT NULL DEFAULT '0' AFTER `g_d_check_topics`,
    ADD `g_d_manage_coms` TINYINT (4) NOT NULL DEFAULT '0' AFTER `g_d_max_dls`;



ALTER TABLE `ibf_members` ADD `files` tinyint (4) DEFAULT '0',
    ADD `downloads` tinyint(4) DEFAULT '0';