9/3/2008 10:53:45 AM
v1.1854 - Command text was not set for the command object

Continue or restart VDM - This error was queued for analysis, we apologize.


ExecuteSQL
AutoUpdate
DoOnTimer
CheckFileChanges

6/5/2008 9:53:33 AM
v1.1854 - Line 39: Incorrect syntax near 'max'

Continue or restart VDM - This error was queued for analysis, we apologize.




-- OLD and OBSOLETE now split into VDM_Tables and VDM_Fixes


-----------
-- WebSites
-----------

if NOT exists ( select * from sysobjects where [Name] = 'WebSites' AND [Type] = 'U' ) 
create table dbo.WebSites (
	ID             int identity( 1, 1 ) NOT Null,
  GUID             uniqueidentifier Null default( NewID() ) rowguidcol,
	Template_ID      int Null,
	Default_Template_ID int Null,
	Version          int Null default( 0 ),
	Date_Created     datetime default GetDate(),
	Date_Modified    datetime Null,
	Date_Verified    datetime Null,
	Date_Uploaded    datetime Null,
  ServerName       varchar( 100 ) Null default( @@ServerName ),
  WorkStation      varchar( 100 ) Null default( App_Name()  ),
  UserName         varchar( 100 ) Null default( System_User ),
	Title            varchar(  50 ) NOT Null default( NewID() ),
	Title_Languages  varchar( 500 ) Null,
  Meta_Description varchar( 1000 ) Null,
  Meta_Keywords    varchar( 1000 ) Null,
	Template_Name         varchar( 50 ) Null,
	Default_Template_Name varchar( 50 ) Null,
	Destination_URL  varchar(  100 ) Null,
	Destination_Path varchar(  100 ) Null,
	Local_Path       varchar(  100 ) Null,
	Original_URL     varchar(  100 ) Null,