text: /**********************************************************************************************************************
   * Copyright (C) 2005-2022 SplendidCRM Software, Inc. 
   * MIT License
   * 
   * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation 
   * files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, 
   * modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software 
   * is furnished to do so, subject to the following conditions:
   * 
   * The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
   * 
   * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES 
   * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE 
   * LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR 
   * IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
   *********************************************************************************************************************/
  if not exists (select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'RULES' and TABLE_TYPE = 'BASE TABLE')
    begin
  	print 'Create Table dbo.RULES';
  	Create Table dbo.RULES
  		( ID                                 uniqueidentifier not null default(newid()) constraint PK_RULES primary key
  		, DELETED                            bit not null default(0)
  		, CREATED_BY                         uniqueidentifier null
  		, DATE_ENTERED                       datetime not null default(getdate())
  		, MODIFIED_USER_ID                   uniqueidentifier null
  		, DATE_MODIFIED                      datetime not null default(getdate())
  		, DATE_MODIFIED_UTC                  datetime null default(getutcdate())
  
  		, ASSIGNED_USER_ID                   uniqueidentifier null
  		, TEAM_ID                            uniqueidentifier null
  		, TEAM_SET_ID                        uniqueidentifier null
  		, NAME                               nvarchar(150) null
  		, MODULE_NAME                        nvarchar(25) null
  		, RULE_TYPE                          nvarchar(25) null
  		, DESCRIPTION                        nvarchar(max) null
  		, FILTER_SQL                         nvarchar(max) null
  		, FILTER_XML                         nvarchar(max) null
  		, RULES_XML                          nvarchar(max) null
  		, XOML                               nvarchar(max) null
  		)
  
  	-- 10/30/2010 Paul.  Include the name in the index as the NAME is used in vwDETAILVIEWS and vwEDITVIEWS. 
  	create index IDX_RULES_ID_NAME on dbo.RULES (ID, DELETED, NAME)
    end
  GO
  
  