[mxbb-commits] core/install/schemas mysql_schema_install.sql,1.8,1.9 mysql_schema_upgrade_to_2.8_rc7.sql,1.2,1.3

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31135/install/schemas

Modified Files:
	mysql_schema_install.sql mysql_schema_upgrade_to_2.8_rc7.sql 
Log Message:
- Security patch for 2.0.18
- added custom cache (eg for portal_configs etc)
- minor fixes

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** mysql_schema_install.sql	22 Oct 2005 23:18:27 -0000	1.8
--- mysql_schema_install.sql	8 Dec 2005 14:41:48 -0000	1.9
***************
*** 17,26 ****
    `function_id` smallint(5) unsigned default NULL,
    `auth_view` tinyint(2) NOT NULL default '0',
!   `auth_edit` tinyint(2) default '0',
!   `auth_delete` tinyint(2) default '0',
!   `auth_view_group` varchar(255) NOT NULL default '0',
!   `auth_edit_group` varchar(255) NOT NULL default '0',
!   `auth_delete_group` varchar(255) NOT NULL default '0',
!   `auth_moderator_group` varchar(255) NOT NULL default '0',
    `show_title` tinyint(2) unsigned NOT NULL default '1',
    `show_block` tinyint(2) unsigned NOT NULL default '1',
--- 17,26 ----
    `function_id` smallint(5) unsigned default NULL,
    `auth_view` tinyint(2) NOT NULL default '0',
!   `auth_edit` tinyint(2) NOT NULL default '0',
!   `auth_delete` tinyint(2) NOT NULL default '0',
!   `auth_view_group` smallint(5) NOT NULL default '0',
!   `auth_edit_group` smallint(5) NOT NULL default '0',
!   `auth_delete_group` smallint(5) NOT NULL default '0',
!   `auth_moderator_group` smallint(5) NOT NULL default '0',
    `show_title` tinyint(2) unsigned NOT NULL default '1',
    `show_block` tinyint(2) unsigned NOT NULL default '1',
***************
*** 389,394 ****
    `page_icon` varchar(255) default NULL,
    `auth_view` tinyint(2) NOT NULL default '0',
!   `auth_view_group` varchar(255) NOT NULL default '0',
!   `auth_moderator_group` varchar(255) NOT NULL default '0',
    `page_header` varchar(255) default 'overall_header.tpl',
    `page_graph_border` varchar(255) NOT NULL default '',
--- 389,394 ----
    `page_icon` varchar(255) default NULL,
    `auth_view` tinyint(2) NOT NULL default '0',
!   `auth_view_group` smallint(5) NOT NULL default '0',
!   `auth_moderator_group` smallint(5) NOT NULL default '0',
    `page_header` varchar(255) default 'overall_header.tpl',
    `page_graph_border` varchar(255) NOT NULL default '',

Index: mysql_schema_upgrade_to_2.8_rc7.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc7.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_schema_upgrade_to_2.8_rc7.sql	15 Oct 2005 22:26:21 -0000	1.2
--- mysql_schema_upgrade_to_2.8_rc7.sql	8 Dec 2005 14:41:48 -0000	1.3
***************
*** 15,17 ****
  # New Fields in Table `mx_portal`
  #
! ALTER TABLE mx_table_portal ADD mod_rewrite VARCHAR(255) NOT NULL DEFAULT '0';
\ No newline at end of file
--- 15,44 ----
  # New Fields in Table `mx_portal`
  #
! ALTER TABLE mx_table_portal ADD mod_rewrite VARCHAR(255) NOT NULL DEFAULT '0';
! 
! # ------------------------------------------------------------
! #
! # Changed Fields in Table `mx_block` (updated type)
! #
! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
! 
! ALTER TABLE mx_table_block MODIFY auth_view_group smallint(5) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_edit_group smallint(5) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_delete_group smallint(5) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_moderator_group smallint(5) NOT NULL default '0';
! 
! # ------------------------------------------------------------
! #
! # Changed Fields in Table `mx_page` (updated type)
! #
! ALTER TABLE mx_table_page MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_page MODIFY auth_view_group smallint(5) NOT NULL default '0';
! 
! # ------------------------------------------------------------
! #
! # Changed Fields in Table `mx_menu_nav` (updated type)
! #
! ALTER TABLE mx_table_menu_nav MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_menu_nav MODIFY auth_view_group smallint(5) NOT NULL default '0';
\ No newline at end of file