[mxbb-commits] core/install/schemas mysql_3_schema_install.sql, 1.1, 1.2 mysql_41_schema_install.sql, 1.11, 1.12 mysql_61_schema_install.sql, 1.1, 1.2 mysql_schema_install.sql, 1.59, 1.60 mysql_schema_upgrade_to_2.9.2.sql, 1.1, 1.2 mysql_schema_upgrade_to_3.0.0.sql, 1.1, 1.2

[Florin C B. <ory...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory vz-cvs-4.sog:/tmp/cvs-serv30006

Modified Files:
	mysql_3_schema_install.sql mysql_41_schema_install.sql 
	mysql_61_schema_install.sql mysql_schema_install.sql 
	mysql_schema_upgrade_to_2.9.2.sql 
	mysql_schema_upgrade_to_3.0.0.sql 
Log Message:
fixes mx_parameter

Index: mysql_3_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_3_schema_install.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_3_schema_install.sql	30 Sep 2008 07:04:47 -0000	1.1
--- mysql_3_schema_install.sql	23 Jan 2012 03:51:59 -0000	1.2
***************
*** 402,406 ****
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` varchar(150),
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',
--- 402,406 ----
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` text,
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',

Index: mysql_schema_upgrade_to_2.9.2.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.9.2.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_schema_upgrade_to_2.9.2.sql	13 Sep 2007 09:13:04 -0000	1.1
--- mysql_schema_upgrade_to_2.9.2.sql	23 Jan 2012 03:51:59 -0000	1.2
***************
*** 56,59 ****
--- 56,64 ----
  INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
  
+ # ------------------------------------------------------------
+ #
+ # New Fields in Table `mx_parameter`
+ #
+ ALTER TABLE mx_table_parameter MODIFY parameter_default text default '';
  
  # --------------------------------------------------------

Index: mysql_schema_upgrade_to_3.0.0.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_3.0.0.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_schema_upgrade_to_3.0.0.sql	27 Jul 2011 19:44:58 -0000	1.1
--- mysql_schema_upgrade_to_3.0.0.sql	23 Jan 2012 03:51:59 -0000	1.2
***************
*** 8,10 ****
  #
  # New Fields in Table `mx_portal`
! #
\ No newline at end of file
--- 8,16 ----
  #
  # New Fields in Table `mx_portal`
! #
! 
! # ------------------------------------------------------------
! #
! # New Fields in Table `mx_parameter`
! #
! ALTER TABLE mx_table_parameter MODIFY parameter_default text default '';

Index: mysql_61_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_61_schema_install.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_61_schema_install.sql	17 Sep 2008 08:24:28 -0000	1.1
--- mysql_61_schema_install.sql	23 Jan 2012 03:51:59 -0000	1.2
***************
*** 402,406 ****
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` varchar(150),
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',
--- 402,406 ----
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` text,
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',
***************
*** 409,414 ****
  ) CHARACTER SET `utf8` COLLATE `utf8mb3_bin`;
  
- 
- 
  #
  # Dumping data for table 'mx_table_parameter'
--- 409,412 ----

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.59
retrieving revision 1.60
diff -C2 -d -r1.59 -r1.60
*** mysql_schema_install.sql	6 Oct 2008 22:47:16 -0000	1.59
--- mysql_schema_install.sql	23 Jan 2012 03:51:59 -0000	1.60
***************
*** 402,406 ****
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` varchar(150),
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',
--- 402,406 ----
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` text,
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',

Index: mysql_41_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_41_schema_install.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** mysql_41_schema_install.sql	6 Oct 2008 22:47:16 -0000	1.11
--- mysql_41_schema_install.sql	23 Jan 2012 03:51:59 -0000	1.12
***************
*** 402,406 ****
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` varchar(150),
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',
--- 402,406 ----
    `parameter_name` varchar(150),
    `parameter_type` varchar(30),
!   `parameter_default` text,
    `parameter_function` varchar(255),
    `parameter_auth` tinyint(2) NOT NULL DEFAULT '0',