﻿-- Table: deployed_file
CREATE TABLE [deployed_file] (
    [deployed_file_id] int NOT NULL,
    [file_id] int NOT NULL,
    [node_name] nvarchar(256) NOT NULL,
    [need_to_delete] int NOT NULL DEFAULT ((0)),
    [is_package_deployed] bit NOT NULL,
    [is_editor_deployed] bit NOT NULL,
    [is_runtime_deployed] bit NOT NULL,
    [is_browser_deployed] bit NOT NULL,
    [file_version] nvarchar(50) NOT NULL DEFAULT (''),
    [file_modified_time] nvarchar(50) NOT NULL DEFAULT (''),
    CONSTRAINT [PK_deployed_file] PRIMARY KEY ([deployed_file_id], [file_id])
);
GO

ALTER TABLE [deployed_file] ADD FOREIGN KEY ([file_id]) REFERENCES [file_table] ([file_id]);
GO

