projects.sql

gistfile1.txt

-- Table Definition
CREATE SEQUENCE IF NOT EXISTS projects_id_seq;
CREATE TABLE "projects" (
    "id" int4 NOT NULL DEFAULT nextval('projects_id_seq'::regclass),
    "name" varchar(255) NOT NULL,
    "description" text NOT NULL,
    "status" varchar(50) NOT NULL,
    "start_date" date,
    "end_date" date,
    "created_at" timestamp(0) DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp(0) DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY ("id")
);


-- Fake project data
INSERT INTO "projects" ("name", "description", "status", "start_date", "end_date", "created_at", "updated_at") VALUES
('Project Alpha', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', 'In Progress', '2023-01-01', '2023-03-01', '2023-11-16 14:00:00', '2023-11-16 14:00:00'),
('Project Beta', 'Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Completed', '2023-02-01', '2023-04-01', '2023-11-16 14:05:00', '2023-11-16 14:05:00'),
('Project Gamma', 'Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris.', 'Planned', '2023-03-01', '2023-06-01', '2023-11-16 14:10:00', '2023-11-16 14:10:00'),
('Project Delta', 'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore.', 'In Progress', '2023-04-01', '2023-08-01', '2023-11-16 14:15:00', '2023-11-16 14:15:00'),
('Project Epsilon', 'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'Planned', '2023-05-01', '2023-10-01', '2023-11-16 14:20:00', '2023-11-16 14:20:00');