[Yafdotnet-cvs] yafsrc/install procedures.sql, 1.3.2.9, 1.3.2.10 tables.sql, 1.2.2.2, 1.2.2.3

[Jaben C. <ja...@us...>]

Update of /cvsroot/yafdotnet/yafsrc/install
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv25282/yafsrc/install

Modified Files:
      Tag: v1_0_2_NETv2
	procedures.sql tables.sql 
Log Message:
updates and fixes!

Index: tables.sql
===================================================================
RCS file: /cvsroot/yafdotnet/yafsrc/install/tables.sql,v
retrieving revision 1.2.2.2
retrieving revision 1.2.2.3
diff -C2 -d -r1.2.2.2 -r1.2.2.3
*** tables.sql	13 Sep 2006 11:03:26 -0000	1.2.2.2
--- tables.sql	8 Feb 2007 00:48:14 -0000	1.2.2.3
***************
*** 354,358 ****
  		RegistryID		int IDENTITY(1, 1) NOT NULL,
  		Name			nvarchar(50) NOT NULL,
! 		Value			nvarchar(400),
  		BoardID			int,
  		CONSTRAINT PK_Registry PRIMARY KEY (RegistryID)
--- 354,358 ----
  		RegistryID		int IDENTITY(1, 1) NOT NULL,
  		Name			nvarchar(50) NOT NULL,
! 		Value			ntext,
  		BoardID			int,
  		CONSTRAINT PK_Registry PRIMARY KEY (RegistryID)
***************
*** 605,608 ****
--- 605,612 ----
  GO
  
+ if not exists(select 1 from syscolumns where id=object_id(N'yaf_Registry') and name=N'Value' and xtype<>99)
+ 	alter table yaf_Registry alter column Value ntext null
+ GO
+ 
  if not exists(select 1 from syscolumns where id=object_id('yaf_PMessage') and name='Flags')
  begin

Index: procedures.sql
===================================================================
RCS file: /cvsroot/yafdotnet/yafsrc/install/procedures.sql,v
retrieving revision 1.3.2.9
retrieving revision 1.3.2.10
diff -C2 -d -r1.3.2.9 -r1.3.2.10
*** procedures.sql	7 Feb 2007 23:42:09 -0000	1.3.2.9
--- procedures.sql	8 Feb 2007 00:48:14 -0000	1.3.2.10
***************
*** 2841,2845 ****
  create procedure [dbo].[yaf_registry_save](
  	@Name nvarchar(50),
! 	@Value nvarchar(400) = NULL,
  	@BoardID int = null
  ) AS
--- 2841,2845 ----
  create procedure [dbo].[yaf_registry_save](
  	@Name nvarchar(50),
! 	@Value ntext = NULL,
  	@BoardID int = null
  ) AS