[mxbb-commits] mx_pafiledb db_install.php,1.38,1.39

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/mxbb/mx_pafiledb
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv17827

Modified Files:
	db_install.php 
Log Message:
schema fix for pafiledb to allow fresh install on mysqli, based on someting I write for phpbb.ro

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_pafiledb/db_install.php,v
retrieving revision 1.38
retrieving revision 1.39
diff -C2 -d -r1.38 -r1.39
*** db_install.php	5 Jul 2008 21:57:31 -0000	1.38
--- db_install.php	14 Oct 2008 11:38:57 -0000	1.39
***************
*** 61,114 ****
  		// Table structure for table `pa_cat`
  		"CREATE TABLE " . $mx_table_prefix . "pa_cat (
! 			  cat_id int(10) NOT NULL auto_increment,
! 			  cat_name text,
! 			  cat_desc text,
! 			  cat_parent int(50) default NULL,
! 			  parents_data text NOT NULL default '',
! 			  cat_order int(50) default NULL,
! 			  cat_allow_file tinyint(2) NOT NULL default '0',
! 
! 			  cat_allow_comments tinyint(2) NOT NULL default '-1',
! 			  internal_comments tinyint(2) NOT NULL default '-1',
! 			  autogenerate_comments tinyint(2) NOT NULL default '-1',
! 			  comments_forum_id mediumint(8) NOT NULL DEFAULT '-1',
! 
! 		      cat_allow_ratings tinyint(2) NOT NULL default '-1',
! 
! 		      show_pretext tinyint(2) NOT NULL default '-1',
! 
! 			  notify tinyint(2) NOT NULL default '-1',
! 			  notify_group mediumint(8) NOT NULL default '-1',
! 
! 			  cat_files mediumint(8) NOT NULL default '-1',
! 			  cat_last_file_id mediumint(8) unsigned NOT NULL default '0',
! 			  cat_last_file_name varchar(255) NOT NULL default '',
! 			  cat_last_file_time INT(50) UNSIGNED NOT NULL default '0',
! 
! 			  auth_view tinyint(2) NOT NULL default '0',
! 			  auth_read tinyint(2) NOT NULL default '0',
! 			  auth_view_file tinyint(2) NOT NULL default '0',
! 			  auth_edit_file tinyint(2) NOT NULL default '0',
! 			  auth_delete_file tinyint(2) NOT NULL default '2',
! 			  auth_upload tinyint(2) NOT NULL default '0',
! 			  auth_download tinyint(2) NOT NULL default '0',
! 			  auth_rate tinyint(2) NOT NULL default '0',
! 			  auth_email tinyint(2) NOT NULL default '0',
! 			  auth_view_comment tinyint(2) NOT NULL default '0',
! 			  auth_post_comment tinyint(2) NOT NULL default '0',
! 			  auth_edit_comment tinyint(2) NOT NULL default '0',
! 			  auth_delete_comment tinyint(2) NOT NULL default '0',
! 			  auth_approval tinyint(2) NOT NULL default '0',
! 			  auth_approval_edit tinyint(2) NOT NULL default '0',
! 
! 			  PRIMARY KEY  (cat_id),
! 			  KEY cat_order (cat_order)
!  		)",
  
  		//
  		// Insert
  		//
! 		"INSERT INTO " . $mx_table_prefix . "pa_cat VALUES (1, 'My Category', '',                      '', '', '', 0, '-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)",
! 		"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)",
  
  		// --------------------------------------------------------
--- 61,106 ----
  		// Table structure for table `pa_cat`
  		"CREATE TABLE " . $mx_table_prefix . "pa_cat (
! 		  `cat_id` int(10) NOT NULL auto_increment,
! 		  `cat_name` mediumtext,
! 		  `cat_desc` mediumtext,
! 		  `cat_parent` int(50) default NULL,
! 		  `parents_data` mediumtext,
! 		  `cat_order` int(50) default NULL,
! 		  `cat_allow_file` tinyint(2) NOT NULL default '0',
! 		  `cat_allow_ratings` tinyint(2) NOT NULL default '-1',
! 		  `cat_allow_comments` tinyint(2) NOT NULL default '-1',
! 		  `cat_files` mediumint(8) NOT NULL default '-1',
! 		  `cat_last_file_id` mediumint(8) unsigned NOT NULL default '0',
! 		  `cat_last_file_name` varchar(255) default NULL,
! 		  `cat_last_file_time` int(50) unsigned NOT NULL default '0',
! 		  `auth_view` tinyint(2) NOT NULL default '0',
! 		  `auth_read` tinyint(2) NOT NULL default '0',
! 		  `auth_view_file` tinyint(2) NOT NULL default '0',
! 		  `auth_edit_file` tinyint(2) NOT NULL default '0',
! 		  `auth_delete_file` tinyint(2) NOT NULL default '2',
! 		  `auth_upload` tinyint(2) NOT NULL default '0',
! 		  `auth_download` tinyint(2) NOT NULL default '0',
! 		  `auth_rate` tinyint(2) NOT NULL default '0',
! 		  `auth_email` tinyint(2) NOT NULL default '0',
! 		  `auth_view_comment` tinyint(2) NOT NULL default '0',
! 		  `auth_post_comment` tinyint(2) NOT NULL default '0',
! 		  `auth_edit_comment` tinyint(2) NOT NULL default '0',
! 		  `auth_delete_comment` tinyint(2) NOT NULL default '0',
! 		  `auth_approval` tinyint(2) NOT NULL default '0',
! 		  `internal_comments` tinyint(2) NOT NULL default '-1',
! 		  `autogenerate_comments` tinyint(2) NOT NULL default '-1',
! 		  `comments_forum_id` mediumint(8) NOT NULL default '-1',
! 		  `show_pretext` tinyint(2) NOT NULL default '-1',
! 		  `notify` tinyint(2) NOT NULL default '-1',
! 		  `notify_group` mediumint(8) NOT NULL default '-1',
! 		  `auth_approval_edit` tinyint(2) NOT NULL default '0',
! 		  PRIMARY KEY  (`cat_id`)
! 		) ENGINE=MyISAM", 
  
  		//
  		// Insert
  		//
! 		"INSERT INTO " . $mx_table_prefix . "pa_cat (`cat_id`, `cat_name`, `cat_desc`, `cat_parent`, `parents_data`, `cat_order`, `cat_allow_file`, `cat_allow_ratings`, `cat_allow_comments`, `cat_files`, `cat_last_file_id`, `cat_last_file_name`, `cat_last_file_time`, `auth_view`, `auth_read`, `auth_view_file`, `auth_edit_file`, `auth_delete_file`, `auth_upload`, `auth_download`, `auth_rate`, `auth_email`, `auth_view_comment`, `auth_post_comment`, `auth_edit_comment`, `auth_delete_comment`, `auth_approval`, `internal_comments`, `autogenerate_comments`, `comments_forum_id`, `show_pretext`, `notify`, `notify_group`, `auth_approval_edit`) VALUES(1, 'My Category', '', 0, '', 0, 0, -1, -1, -1, 0, '-1', 0, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)",
! 		"INSERT INTO " . $mx_table_prefix . "pa_cat (`cat_id`, `cat_name`, `cat_desc`, `cat_parent`, `parents_data`, `cat_order`, `cat_allow_file`, `cat_allow_ratings`, `cat_allow_comments`, `cat_files`, `cat_last_file_id`, `cat_last_file_name`, `cat_last_file_time`, `auth_view`, `auth_read`, `auth_view_file`, `auth_edit_file`, `auth_delete_file`, `auth_upload`, `auth_download`, `auth_rate`, `auth_email`, `auth_view_comment`, `auth_post_comment`, `auth_edit_comment`, `auth_delete_comment`, `auth_approval`, `internal_comments`, `autogenerate_comments`, `comments_forum_id`, `show_pretext`, `notify`, `notify_group`, `auth_approval_edit`) VALUES(2, 'Test Cagegory', 'Just a test category', 1, '', 0, 1, -1, -1, -1, 0, '-1', 0, -1, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)",		
  
  		// --------------------------------------------------------
***************
*** 161,188 ****
  		// Table structure for table `phpbb_pa_comments`
  		"CREATE TABLE " . $mx_table_prefix . "pa_comments (
! 			  comments_id int(10) NOT NULL auto_increment,
! 			  file_id int(10) NOT NULL default '0',
! 			  comments_text text NOT NULL,
! 			  comments_title text NOT NULL,
! 			  comments_time int(50) NOT NULL default '0',
! 			  comment_bbcode_uid varchar(10) default NULL,
! 			  poster_id mediumint(8) NOT NULL default '0',
! 			  PRIMARY KEY  (comments_id),
! 			  KEY comments_id (comments_id),
! 			  FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid)
! 		)",
! 
! 		// --------------------------------------------------------
! 		// Table structure for table `phpbb_pa_custom`
! 		"CREATE TABLE " . $mx_table_prefix . "pa_custom (
! 			  custom_id int(50) NOT NULL auto_increment,
! 			  custom_name text NOT NULL,
! 			  custom_description text NOT NULL,
! 			  data text NOT NULL,
! 			  field_order int(20) NOT NULL default '0',
! 			  field_type tinyint(2) NOT NULL default '0',
! 			  regex varchar(255) NOT NULL default '',
! 			  PRIMARY KEY  (custom_id)
! 		)",
  
  		// --------------------------------------------------------
--- 153,167 ----
  		// Table structure for table `phpbb_pa_comments`
  		"CREATE TABLE " . $mx_table_prefix . "pa_comments (
! 			  `comments_id` int(10) NOT NULL auto_increment,
! 			  `file_id` int(10) NOT NULL default '0',
! 			  `comments_text` mediumtext,
! 			  `comments_title` mediumtext,
! 			  `comments_time` int(50) NOT NULL default '0',
! 			  `comment_bbcode_uid` varchar(10) default NULL,
! 			  `poster_id` mediumint(8) NOT NULL default '0',
! 			  PRIMARY KEY  (`comments_id`),
! 			  KEY `comments_id` (`comments_id`),
! 			  FULLTEXT KEY `comment_bbcode_uid` (`comment_bbcode_uid`)
! 		) ENGINE=MyISAM",
  
  		// --------------------------------------------------------