USE [Elyse_DB] GO /****** Object: Table [user_restr].[tag_tree_permissions_flist] Script Date: Wed 21-10-2026 4:50:15 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [user_restr].[tag_tree_permissions_flist]( [tag_tree_id] [bigint] NOT NULL, [function_list_id] [bigint] NOT NULL, [created] [datetime2](7) NOT NULL, [granted_by] [nvarchar](128) NOT NULL, CONSTRAINT [PK_tag_tree_permissions_flist] PRIMARY KEY CLUSTERED ( [tag_tree_id] ASC, [function_list_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [user_restr].[tag_tree_permissions_flist] ADD CONSTRAINT [DF_tag_tree_permissions_flist_created] DEFAULT (sysdatetime()) FOR [created] GO ALTER TABLE [user_restr].[tag_tree_permissions_flist] ADD CONSTRAINT [DF_tag_tree_permissions_flist_granted_by] DEFAULT (original_login()) FOR [granted_by] GO ALTER TABLE [user_restr].[tag_tree_permissions_flist] WITH CHECK ADD CONSTRAINT [FK_tag_tree_permissions_flist_has_flist] FOREIGN KEY([function_list_id]) REFERENCES [people].[function_list_names] ([function_list_id]) ON DELETE CASCADE GO ALTER TABLE [user_restr].[tag_tree_permissions_flist] CHECK CONSTRAINT [FK_tag_tree_permissions_flist_has_flist] GO ALTER TABLE [user_restr].[tag_tree_permissions_flist] WITH CHECK ADD CONSTRAINT [FK_tag_tree_permissions_flist_has_tag_tree] FOREIGN KEY([tag_tree_id]) REFERENCES [tagging].[tag_tree_names] ([tag_tree_id]) ON DELETE CASCADE GO ALTER TABLE [user_restr].[tag_tree_permissions_flist] CHECK CONSTRAINT [FK_tag_tree_permissions_flist_has_tag_tree] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Creates a link between a tag tree and a function list to grant permission for members of a given function list to edit the given tag tree.' , @level0type=N'SCHEMA',@level0name=N'user_restr', @level1type=N'TABLE',@level1name=N'tag_tree_permissions_flist' GO