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.
   *********************************************************************************************************************/
  -- 04/28/2006 Paul.  Added SHORTCUT_MODULE to help with ACL. 
  -- 04/28/2006 Paul.  Added SHORTCUT_ACLTYPE to help with ACL. 
  -- 07/24/2006 Paul.  Increase the DISPLAY_NAME to 150 to allow a fully-qualified (NAME+MODULE_NAME+LIST_NAME) TERMINOLOGY name. 
  -- 10/28/2009 Paul.  Add UTC date to allow this table to sync. 
  if not exists (select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'SHORTCUTS' and TABLE_TYPE = 'BASE TABLE')
    begin
  	print 'Create Table dbo.SHORTCUTS';
  	Create Table dbo.SHORTCUTS
  		( ID                                 uniqueidentifier not null default(newid()) constraint PK_SHORTCUTS 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())
  
  		, MODULE_NAME                        nvarchar( 25) not null
  		, DISPLAY_NAME                       nvarchar(150) not null
  		, RELATIVE_PATH                      nvarchar(255) not null
  		, IMAGE_NAME                         nvarchar( 50) null
  		, SHORTCUT_ENABLED                   bit null default(1)
  		, SHORTCUT_ORDER                     int null
  		, SHORTCUT_MODULE                    nvarchar( 25) null
  		, SHORTCUT_ACLTYPE                   nvarchar(100) null
  		)
  	-- 12/30/2010 Irantha.  Add index for caching. 
  	create index IX_SHORTCUTS_SHORTCUT_ORDER on dbo.SHORTCUTS(DELETED, SHORTCUT_ORDER, SHORTCUT_MODULE)
    end
  GO
  
  
  