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,
"Template_ID" INT,
"Document_Name" VARCHAR(255),
PRIMARY KEY ("Document_ID")
);

CREATE TABLE "Paragraphs" (
"Paragraph_ID" INT,
"Document_ID" INT,
"Paragraph_Text" VARCHAR(255),
PRIMARY KEY ("Paragraph_ID"),
FOREIGN KEY ("Document_ID") REFERENCES "Documents"("Document_ID")
);





INSERT INTO "Documents" VALUES ("1", "101", "Meeting Minutes 2023-01-15");
INSERT INTO "Documents" VALUES ("2", "102", "Project Proposal Alpha");
INSERT INTO "Documents" VALUES ("3", "101", "Meeting Minutes 2023-01-22");
INSERT INTO "Documents" VALUES ("4", "103", "Research Paper Draft");
INSERT INTO "Documents" VALUES ("5", "104", "Contract Agreement v1.0");
INSERT INTO "Documents" VALUES ("6", "101", "Meeting Minutes 2023-01-29");
INSERT INTO "Documents" VALUES ("7", "105", "User Manual Beta");
INSERT INTO "Documents" VALUES ("8", "102", "Project Proposal Beta");
INSERT INTO "Documents" VALUES ("9", "106", "Marketing Plan Q1");
INSERT INTO "Documents" VALUES ("10", "107", "Employee Handbook");
INSERT INTO "Paragraphs" VALUES ("1", "1", "Attendees: John Doe, Jane Smith, Bob Johnson.");
INSERT INTO "Paragraphs" VALUES ("2", "1", "Discussion: Q4 performance review.");
INSERT INTO "Paragraphs" VALUES ("3", "1", "Action Items: Follow up on sales figures.");
INSERT INTO "Paragraphs" VALUES ("4", "2", "Introduction to Project Alpha.");
INSERT INTO "Paragraphs" VALUES ("5", "2", "Proposed budget and timeline.");
INSERT INTO "Paragraphs" VALUES ("6", "2", "Expected outcomes and deliverables.");
INSERT INTO "Paragraphs" VALUES ("7", "3", "Attendees: John Doe, Jane Smith.");
INSERT INTO "Paragraphs" VALUES ("8", "3", "Discussion: Next steps for Project Alpha.");
INSERT INTO "Paragraphs" VALUES ("9", "4", "Abstract of the research paper.");
INSERT INTO "Paragraphs" VALUES ("10", "4", "Methodology used in the study.");
INSERT INTO "Paragraphs" VALUES ("11", "4", "Preliminary results and findings.");
INSERT INTO "Paragraphs" VALUES ("12", "4", "Conclusion and future work.");
INSERT INTO "Paragraphs" VALUES ("13", "5", "Terms and conditions of the agreement.");
INSERT INTO "Paragraphs" VALUES ("14", "5", "Signatures of involved parties.");
INSERT INTO "Paragraphs" VALUES ("15", "6", "Attendees: All team members.");
INSERT INTO "Paragraphs" VALUES ("16", "6", "Discussion: Brainstorming new ideas.");
INSERT INTO "Paragraphs" VALUES ("17", "7", "Getting started with the software.");
INSERT INTO "Paragraphs" VALUES ("18", "7", "Troubleshooting common issues.");
INSERT INTO "Paragraphs" VALUES ("19", "8", "Revised budget for Project Beta.");
INSERT INTO "Paragraphs" VALUES ("20", "9", "Target audience analysis.");
INSERT INTO "Paragraphs" VALUES ("21", "9", "Marketing strategies for Q1.");
INSERT INTO "Paragraphs" VALUES ("22", "10", "Company policies and procedures.");
INSERT INTO "Paragraphs" VALUES ("23", "10", "Employee benefits and compensation.");
INSERT INTO "Paragraphs" VALUES ("24", "10", "Code of conduct.");
INSERT INTO "Paragraphs" VALUES ("25", "10", "Safety guidelines.");
INSERT INTO "Paragraphs" VALUES ("26", "10", "Contact information.");