<commit_before>USE [$(DBNAME)]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE SCHEMA [Stardust]
GO;

CREATE TABLE [Stardust].[JobDefinitions](
	[Id] [uniqueidentifier] NOT NULL,
	[Name] [nvarchar](max) NULL,
	[Serialized] [nvarchar](max) NULL,
	[Type] [nvarchar](max) NULL,
	[UserName] nvarchar(500) NOT NULL,
	[AssignedNode] [nvarchar](max) NULL,
	[JobProgress] [nvarchar](max) NULL,
	[Status] [nvarchar](max) NULL,
 CONSTRAINT [PK_JobDefinitions] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
))
GO

CREATE TABLE [Stardust].[WorkerNodes](
	[Id] [uniqueidentifier] NOT NULL,
	[Url] [nvarchar](450) NOT NULL,
 CONSTRAINT [PK_WorkerNodes] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
))

GO
CREATE UNIQUE NONCLUSTERED INDEX [UQ_WorkerNodes_Url] ON [Stardust].[WorkerNodes]
(
	[Url] ASC
)
GO

CREATE TABLE [Stardust].[JobHistory](
	[JobId] [uniqueidentifier] NOT NULL,
	[Name] [nvarchar](max) NULL,
	[CreatedBy] nvarchar(500) NOT NULL,
	[Created] DateTime NOT NULL,
	[Started] DateTime NULL,
	[Ended] DateTime NULL,
	[Serialized] [nvarchar](max) NULL,
	[Type] [nvarchar](max) NULL,
	[SentTo] nvarchar(max) NULL,
	[Result] [nvarchar](max) NULL
CONSTRAINT [PK_JobHistory] PRIMARY KEY CLUSTERED 
(
	[JobId] ASC
))

GO
ALTER TABLE [Stardust].[JobHistory] ADD CONSTRAINT
	DF_JobHistory_Created DEFAULT getutcdate() FOR Created
GO

CREATE TABLE [Stardust].[JobHistoryDetail](
	[Id] int NOT NULL IDENTITY (1, 1),
	[JobId] [uniqueidentifier] NOT NULL,
	[Created] DateTime NOT NULL,
	[Detail] [nvarchar](max) NULL
)

GO
ALTER TABLE [Stardust].[JobHistoryDetail] ADD CONSTRAINT
	DF_JobHistoryDetail_Created DEFAULT getutcdate() FOR Created
GO<commit_msg>primary key on JobHistoryDetail<commit_after>USE [$(DBNAME)]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE SCHEMA [Stardust]
GO;

CREATE TABLE [Stardust].[JobDefinitions](
	[Id] [uniqueidentifier] NOT NULL,
	[Name] [nvarchar](max) NULL,
	[Serialized] [nvarchar](max) NULL,
	[Type] [nvarchar](max) NULL,
	[UserName] nvarchar(500) NOT NULL,
	[AssignedNode] [nvarchar](max) NULL,
	[JobProgress] [nvarchar](max) NULL,
	[Status] [nvarchar](max) NULL,
 CONSTRAINT [PK_JobDefinitions] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
))
GO

CREATE TABLE [Stardust].[WorkerNodes](
	[Id] [uniqueidentifier] NOT NULL,
	[Url] [nvarchar](450) NOT NULL,
 CONSTRAINT [PK_WorkerNodes] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
))

GO
CREATE UNIQUE NONCLUSTERED INDEX [UQ_WorkerNodes_Url] ON [Stardust].[WorkerNodes]
(
	[Url] ASC
)
GO

CREATE TABLE [Stardust].[JobHistory](
	[JobId] [uniqueidentifier] NOT NULL,
	[Name] [nvarchar](max) NULL,
	[CreatedBy] nvarchar(500) NOT NULL,
	[Created] DateTime NOT NULL,
	[Started] DateTime NULL,
	[Ended] DateTime NULL,
	[Serialized] [nvarchar](max) NULL,
	[Type] [nvarchar](max) NULL,
	[SentTo] nvarchar(max) NULL,
	[Result] [nvarchar](max) NULL
CONSTRAINT [PK_JobHistory] PRIMARY KEY CLUSTERED 
(
	[JobId] ASC
))

GO
ALTER TABLE [Stardust].[JobHistory] ADD CONSTRAINT
	DF_JobHistory_Created DEFAULT getutcdate() FOR Created
GO

CREATE TABLE [Stardust].[JobHistoryDetail](
	[Id] int NOT NULL IDENTITY (1, 1),
	[JobId] [uniqueidentifier] NOT NULL,
	[Created] DateTime NOT NULL,
	[Detail] [nvarchar](max) NULL
CONSTRAINT [PK_JobHistoryDetail] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
))

GO
ALTER TABLE [Stardust].[JobHistoryDetail] ADD CONSTRAINT
	DF_JobHistoryDetail_Created DEFAULT getutcdate() FOR Created
GO
{'fraction_non_alphanumeric': 0.1309913664781185, 'fraction_numerical': 0.006549568323905924, 'mean_word_length': 6.11864406779661, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4321756', 'n_tokens_mistral': 1358, 'n_tokens_neox': 1294, 'n_words': 347}