|
From: Jon O. <jon...@us...> - 2006-07-03 09:17:31
|
Update of /cvsroot/mxbb/mx_pafiledb In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv22143/modules/mx_pafiledb Modified Files: db_install.php Log Message: Working... Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_pafiledb/db_install.php,v retrieving revision 1.23 retrieving revision 1.24 diff -C2 -d -r1.23 -r1.24 *** db_install.php 27 Jun 2006 21:38:43 -0000 1.23 --- db_install.php 3 Jul 2006 09:17:28 -0000 1.24 *************** *** 59,90 **** "DROP TABLE IF EXISTS " . $mx_table_prefix . "pa_files ", - // Table structure for table `pa_auth` - "CREATE TABLE " . $mx_table_prefix . "pa_auth ( - group_id mediumint(8) DEFAULT '0' NOT NULL, - cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - auth_view tinyint(1) DEFAULT '0' NOT NULL, - auth_read tinyint(1) DEFAULT '0' NOT NULL, - auth_view_file tinyint(1) DEFAULT '0' NOT NULL, - auth_edit_file tinyint(1) DEFAULT '0' NOT NULL, - auth_delete_file tinyint(1) DEFAULT '0' NOT NULL, - auth_upload tinyint(1) DEFAULT '0' NOT NULL, - auth_download tinyint(1) DEFAULT '0' NOT NULL, - auth_rate tinyint(1) DEFAULT '0' NOT NULL, - auth_email tinyint(1) DEFAULT '0' NOT NULL, - auth_view_comment tinyint(1) DEFAULT '0' NOT NULL, - auth_post_comment tinyint(1) DEFAULT '0' NOT NULL, - auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL, - auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL, - auth_approval tinyint(1) DEFAULT '0' NOT NULL, - auth_approval_groups tinyint(1) DEFAULT '0' NOT NULL, - auth_mod tinyint(1) DEFAULT '1' NOT NULL, - auth_search tinyint(1) DEFAULT '1' NOT NULL, - auth_stats tinyint(1) DEFAULT '1' NOT NULL, - auth_toplist tinyint(1) DEFAULT '1' NOT NULL, - auth_viewall tinyint(1) DEFAULT '1' NOT NULL, - KEY group_id (group_id), - KEY cat_id (cat_id) - )", - // Table structure for table `pa_cat` "CREATE TABLE " . $mx_table_prefix . "pa_cat ( --- 59,62 ---- *************** *** 129,133 **** auth_approval tinyint(2) NOT NULL default '0', auth_approval_groups tinyint(2) NOT NULL default '0', ! PRIMARY KEY (cat_id) )", --- 101,107 ---- auth_approval tinyint(2) NOT NULL default '0', auth_approval_groups tinyint(2) NOT NULL default '0', ! ! PRIMARY KEY (cat_id), ! KEY cat_order (cat_order) )", *************** *** 138,141 **** --- 112,158 ---- "INSERT INTO " . $mx_table_prefix . "pa_cat VALUES (2, 'Test Cagegory', 'Just a test category', 1, '', '', 1, '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", + // -------------------------------------------------------- + // Table structure for table `phpbb_pa_files` + "CREATE TABLE " . $mx_table_prefix . "pa_files ( + file_id int(10) NOT NULL auto_increment, + file_name text, + file_desc text, + file_longdesc text, + file_catid int(10) default NULL, + file_approved TINYINT(1) NOT NULL default '1', + + file_size int(20) NOT NULL default '0', + unique_name varchar(255) NOT NULL default '', + real_name VARCHAR(255) NOT NULL, + file_dir VARCHAR(255) NOT NULL, + file_creator text, + file_version text, + file_ssurl text, + file_sshot_link tinyint(2) NOT NULL default '0', + file_dlurl text, + file_posticon text, + file_license int(10) default NULL, + file_docsurl text, + + file_time int(50) default NULL, + user_id mediumint(8) NOT NULL default '0', + poster_ip varchar(8) NOT NULL default '', + file_update_time int(50) NOT NULL default '0', + file_last int(50) default NULL, + file_pin int(2) default NULL, + file_broken TINYINT(1) DEFAULT '0' NOT NULL, + topic_id mediumint(8) unsigned NOT NULL default '0', + file_dls int(10) DEFAULT '0' NOT NULL, + + PRIMARY KEY (file_id) + )", + + // -------------------------------------------------------- + // Table structure for table `phpbb_pa_config` + "CREATE TABLE " . $mx_table_prefix . "pa_config ( + config_name varchar(255) NOT NULL default '', + config_value varchar(255) NOT NULL default '', + PRIMARY KEY (config_name) + )", // -------------------------------------------------------- *************** *** 155,166 **** // -------------------------------------------------------- - // Table structure for table `phpbb_pa_config` - "CREATE TABLE " . $mx_table_prefix . "pa_config ( - config_name varchar(255) NOT NULL default '', - config_value varchar(255) NOT NULL default '', - PRIMARY KEY (config_name) - )", - - // -------------------------------------------------------- // Table structure for table `phpbb_pa_custom` "CREATE TABLE " . $mx_table_prefix . "pa_custom ( --- 172,175 ---- *************** *** 195,231 **** // -------------------------------------------------------- - // Table structure for table `phpbb_pa_files` - "CREATE TABLE " . $mx_table_prefix . "pa_files ( - file_id int(10) NOT NULL auto_increment, - user_id mediumint(8) NOT NULL default '0', - poster_ip varchar(8) NOT NULL default '', - file_name text, - file_size int(20) NOT NULL default '0', - unique_name varchar(255) NOT NULL default '', - real_name VARCHAR(255) NOT NULL, - file_dir VARCHAR(255) NOT NULL, - file_desc text, - file_creator text, - file_version text, - file_longdesc text, - file_ssurl text, - file_sshot_link tinyint(2) NOT NULL default '0', - file_dlurl text, - file_time int(50) default NULL, - file_update_time int(50) NOT NULL default '0', - file_catid int(10) default NULL, - file_posticon text, - file_license int(10) default NULL, - file_dls int(10) DEFAULT '0' NOT NULL, - file_last int(50) default NULL, - file_pin int(2) default NULL, - file_docsurl text, - file_approved TINYINT(1) DEFAULT '1' NOT NULL, - file_broken TINYINT(1) DEFAULT '0' NOT NULL, - topic_id mediumint(8) unsigned NOT NULL default '0', - PRIMARY KEY (file_id) - )", - - // -------------------------------------------------------- "CREATE TABLE " . $mx_table_prefix . "pa_mirrors ( mirror_id mediumint(8) NOT NULL auto_increment, --- 204,207 ---- *************** *** 266,269 **** --- 242,273 ---- )", + // Table structure for table `pa_auth` + "CREATE TABLE " . $mx_table_prefix . "pa_auth ( + group_id mediumint(8) DEFAULT '0' NOT NULL, + cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, + auth_view tinyint(1) DEFAULT '0' NOT NULL, + auth_read tinyint(1) DEFAULT '0' NOT NULL, + auth_view_file tinyint(1) DEFAULT '0' NOT NULL, + auth_edit_file tinyint(1) DEFAULT '0' NOT NULL, + auth_delete_file tinyint(1) DEFAULT '0' NOT NULL, + auth_upload tinyint(1) DEFAULT '0' NOT NULL, + auth_download tinyint(1) DEFAULT '0' NOT NULL, + auth_rate tinyint(1) DEFAULT '0' NOT NULL, + auth_email tinyint(1) DEFAULT '0' NOT NULL, + auth_view_comment tinyint(1) DEFAULT '0' NOT NULL, + auth_post_comment tinyint(1) DEFAULT '0' NOT NULL, + auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL, + auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL, + auth_approval tinyint(1) DEFAULT '0' NOT NULL, + auth_approval_groups tinyint(1) DEFAULT '0' NOT NULL, + auth_mod tinyint(1) DEFAULT '1' NOT NULL, + auth_search tinyint(1) DEFAULT '1' NOT NULL, + auth_stats tinyint(1) DEFAULT '1' NOT NULL, + auth_toplist tinyint(1) DEFAULT '1' NOT NULL, + auth_viewall tinyint(1) DEFAULT '1' NOT NULL, + KEY group_id (group_id), + KEY cat_id (cat_id) + )", + // // Config values |