Create the Necessary Tables:
- Execute the following SQL queries in your SQL Server database to create the required tables:
Create DefaultBranchRepoMetadata Table:
CREATE TABLE DefaultBranchRepoMetadata ( FileName NVARCHAR(255) NOT NULL, FilePath NVARCHAR(500) NOT NULL, ModuleName NVARCHAR(255) NOT NULL, ScrapingDate DATETIME NOT NULL, RepositoryID NVARCHAR(MAX) NULL );
Create DefaultBranchRepoFilesData Table:CREATE TABLE DefaultBranchRepoFilesData ( FileID INT NOT NULL PRIMARY KEY, FileName NVARCHAR(255) NOT NULL, FilePath NVARCHAR(500) NOT NULL, FileContent NVARCHAR(MAX) NULL, ScrapingDate DATETIME NOT NULL );