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 plan for new software development project.");
INSERT INTO "Documents" VALUES ("2", "Meeting Minutes", "Summary of discussions and decisions from the weekly team meeting.");
INSERT INTO "Documents" VALUES ("3", "User Manual", "Comprehensive guide for using the new application.");
INSERT INTO "Documents" VALUES ("4", "Financial Report", "Quarterly financial performance analysis.");
INSERT INTO "Documents" VALUES ("5", "Marketing Strategy", "Plan for promoting the new product launch.");
INSERT INTO "Documents" VALUES ("6", "Employee Handbook", "Guidelines and policies for all company employees.");
INSERT INTO "Documents" VALUES ("7", "Technical Specification", "Detailed technical requirements for system architecture.");
INSERT INTO "Documents" VALUES ("8", "Contract Agreement", "Legal agreement between company and client.");
INSERT INTO "Documents" VALUES ("9", "Research Paper", "Academic paper on artificial intelligence advancements.");
INSERT INTO "Documents" VALUES ("10", "Training Material", "Content for new employee onboarding program.");
INSERT INTO "Paragraphs" VALUES ("101", "Introduction to the project scope and objectives.");
INSERT INTO "Paragraphs" VALUES ("102", "Key decisions made regarding feature implementation.");
INSERT INTO "Paragraphs" VALUES ("103", "Step-by-step instructions for installation.");
INSERT INTO "Paragraphs" VALUES ("104", "Revenue and expenditure breakdown for Q1.");
INSERT INTO "Paragraphs" VALUES ("105", "Target audience analysis and marketing channels.");
INSERT INTO "Paragraphs" VALUES ("106", "Company values and code of conduct.");
INSERT INTO "Paragraphs" VALUES ("107", "Database schema and API endpoints.");
INSERT INTO "Paragraphs" VALUES ("108", "Terms and conditions of service.");
INSERT INTO "Paragraphs" VALUES ("109", "Methodology and experimental results.");
INSERT INTO "Paragraphs" VALUES ("110", "Module 1: Company history and mission.");
INSERT INTO "Templates" VALUES ("1", "Standard Project Proposal Template");
INSERT INTO "Templates" VALUES ("2", "Meeting Minutes Template v2.0");
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", "HR Employee Handbook Template");
INSERT INTO "Templates" VALUES ("7", "Technical Design Document Template");
INSERT INTO "Templates" VALUES ("8", "Client Service Agreement Template");
INSERT INTO "Templates" VALUES ("9", "Academic Research Paper Template");
INSERT INTO "Templates" VALUES ("10", "New Hire Training Program Template");