[mxbb-commits] core/install/schemas mysql_schema_install.sql, 1.39, 1.40 mysql_schema_upgrade_to_2.8.1.sql, 1.2, 1.3 postgres_schema_install.sql, 1.2, 1.3 upgrade_schemas_map.php, 1.18, 1.19

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

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

Modified Files:
	mysql_schema_install.sql mysql_schema_upgrade_to_2.8.1.sql 
	postgres_schema_install.sql upgrade_schemas_map.php 
Log Message:
Added a few portal main settings for disable site
Added blockCP for navigation block

Index: upgrade_schemas_map.php
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** upgrade_schemas_map.php	21 Jul 2007 23:07:37 -0000	1.18
--- upgrade_schemas_map.php	22 Jul 2007 21:00:21 -0000	1.19
***************
*** 19,23 ****
  	array('schema' => 'upgrade_to_2.8_b3'	, 'sql' => "SELECT main_layout FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.8.0'	, 'sql' => "SELECT overall_footer FROM mx_table_portal"),
! 	array('schema' => 'upgrade_to_2.8.1'	, 'sql' => "SELECT menu_icon FROM mx_table_page"),
  );
  
--- 19,23 ----
  	array('schema' => 'upgrade_to_2.8_b3'	, 'sql' => "SELECT main_layout FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.8.0'	, 'sql' => "SELECT overall_footer FROM mx_table_portal"),
! 	array('schema' => 'upgrade_to_2.8.1'	, 'sql' => "SELECT portal_status FROM mx_table_portal"),
  );
  

Index: postgres_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/postgres_schema_install.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** postgres_schema_install.sql	21 Jul 2007 23:07:36 -0000	1.2
--- postgres_schema_install.sql	22 Jul 2007 21:00:21 -0000	1.3
***************
*** 568,571 ****
--- 568,573 ----
    "mod_rewrite" SMALLINT NOT NULL DEFAULT '0',
    "portal_backend" VARCHAR(255) NULL DEFAULT 'phpBB2',
+   "portal_status" SMALLINT NOT NULL DEFAULT '1',
+   "disabled_message" VARCHAR(255) NULL DEFAULT '',
    CONSTRAINT mx_table_portal_pkey PRIMARY KEY ("portal_id")
  );
***************
*** 575,579 ****
  --
  
! -- INSERT INTO "mx_table_portal" VALUES (1,'mxBB-Portal','http://yoursite.com/forum/','http://yoursite.com/','2.8.0',-1,-1,1,'overall_header.tpl','overall_footer.tpl','mx_main_layout.tpl',0,0,1,'1182515561',0,'phpBB2');
  
  --
--- 577,581 ----
  --
  
! -- INSERT INTO "mx_table_portal" VALUES (1,'mxBB-Portal','http://yoursite.com/forum/','http://yoursite.com/','2.8.0',-1,-1,1,'overall_header.tpl','overall_footer.tpl','mx_main_layout.tpl',0,0,1,'1182515561',0,'phpBB2','1','We are currenty upgrading this site with latest mxBB software.');
  
  --

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.39
retrieving revision 1.40
diff -C2 -d -r1.39 -r1.40
*** mysql_schema_install.sql	21 Jul 2007 23:07:36 -0000	1.39
--- mysql_schema_install.sql	22 Jul 2007 21:00:20 -0000	1.40
***************
*** 575,578 ****
--- 575,580 ----
    `mod_rewrite` smallint(2) NOT NULL default '0',
    `portal_backend` varchar(255) default 'phpBB2',
+   `portal_status` smallint(2) NOT NULL default '1',
+   `disabled_message` varchar(255) default 'We are currenty upgrading this site with latest mxBB software.',
    PRIMARY KEY  (`portal_id`)
  ) TYPE=MyISAM;

Index: mysql_schema_upgrade_to_2.8.1.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8.1.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_schema_upgrade_to_2.8.1.sql	21 Jul 2007 23:07:36 -0000	1.2
--- mysql_schema_upgrade_to_2.8.1.sql	22 Jul 2007 21:00:20 -0000	1.3
***************
*** 25,26 ****
--- 25,33 ----
  
  ALTER TABLE mx_table_page ADD page_order smallint(5) default '0' AFTER parents_data;
+ 
+ # ------------------------------------------------------------
+ #
+ # New Fields in Table `mx_portal`
+ #
+ ALTER TABLE mx_table_portal ADD portal_status smallint(2) NOT NULL default '1' AFTER portal_backend;
+ ALTER TABLE mx_table_portal ADD disabled_message varchar(255) default 'We are currenty upgrading this site with latest mxBB software.' AFTER portal_status;