PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "Documents" (
"Document_ID" INT UNIQUE,
"Document_Name" VARCHAR(255),
"Document_Description" VARCHAR(255),
PRIMARY KEY ("Document_ID")
);

CREATE TABLE "Paragraphs" (
"Paragraph_ID" INT,
"Paragraph_Text" VARCHAR(255),
PRIMARY KEY ("Paragraph_ID")
);

CREATE TABLE "Templates" (
"Template_ID" INT,
"Template_Details" VARCHAR(255),
PRIMARY KEY ("Template_ID")
);





INSERT INTO "Documents" VALUES ("1", "Project Proposal", "Detailed proposal for new software project");
INSERT INTO "Documents" VALUES ("2", "Meeting Minutes", "Summary of weekly team meeting");
INSERT INTO "Documents" VALUES ("3", "User Manual", "Guide for using the new application");
INSERT INTO "Documents" VALUES ("4", "Financial Report", "Quarterly financial performance overview");
INSERT INTO "Documents" VALUES ("5", "Marketing Plan", "Strategy for product launch campaign");
INSERT INTO "Documents" VALUES ("6", "Employee Handbook", "Company policies and procedures");
INSERT INTO "Documents" VALUES ("7", "Research Paper", "Academic paper on AI advancements");
INSERT INTO "Documents" VALUES ("8", "Contract Agreement", "Legal agreement between parties");
INSERT INTO "Documents" VALUES ("9", "Training Material", "Slides and notes for new employee training");
INSERT INTO "Documents" VALUES ("10", "Bug Report", "Description of a critical software bug");
INSERT INTO "Paragraphs" VALUES ("101", "Introduction to the project scope and objectives.");
INSERT INTO "Paragraphs" VALUES ("102", "Discussion on key decisions made during the meeting.");
INSERT INTO "Paragraphs" VALUES ("103", "Step-by-step instructions for installation.");
INSERT INTO "Paragraphs" VALUES ("104", "Overview of revenue and expenditure.");
INSERT INTO "Paragraphs" VALUES ("105", "Target audience analysis and marketing channels.");
INSERT INTO "Paragraphs" VALUES ("106", "Guidelines for remote work policy.");
INSERT INTO "Paragraphs" VALUES ("107", "Methodology used for data collection.");
INSERT INTO "Paragraphs" VALUES ("108", "Terms and conditions of the agreement.");
INSERT INTO "Paragraphs" VALUES ("109", "Module 1: Company Culture.");
INSERT INTO "Paragraphs" VALUES ("110", "Steps to reproduce the reported issue.");
INSERT INTO "Templates" VALUES ("1", "Standard Project Proposal Template");
INSERT INTO "Templates" VALUES ("2", "Weekly Meeting Minutes Template");
INSERT INTO "Templates" VALUES ("3", "Software User Manual Template");
INSERT INTO "Templates" VALUES ("4", "Quarterly Financial Report Template");
INSERT INTO "Templates" VALUES ("5", "Product Launch Marketing Plan Template");
INSERT INTO "Templates" VALUES ("6", "General Employee Handbook Template");
INSERT INTO "Templates" VALUES ("7", "Academic Research Paper Template");
INSERT INTO "Templates" VALUES ("8", "Legal Contract Agreement Template");
INSERT INTO "Templates" VALUES ("9", "New Employee Training Material Template");
INSERT INTO "Templates" VALUES ("10", "Software Bug Report Template");