﻿-- Table: file_primitive_definition_link
CREATE TABLE [file_primitive_definition_link] (
    [primitive_definition_id] int NOT NULL,
    [file_id] int NOT NULL,
    [is_needed_for_package] bit NOT NULL DEFAULT ((0)),
    [is_needed_for_runtime] bit NOT NULL DEFAULT ((0)),
    [is_needed_for_editor] bit NOT NULL DEFAULT ((0)),
    [is_needed_for_browser] bit NOT NULL DEFAULT ((0)),
    CONSTRAINT [PK_file_primitive_definition_link] PRIMARY KEY ([primitive_definition_id], [file_id], [file_id], [primitive_definition_id])
);
GO

ALTER TABLE [file_primitive_definition_link] ADD FOREIGN KEY ([primitive_definition_id]) REFERENCES [primitive_definition] ([primitive_definition_id]);
GO

