Page MenuHomeDevCentral
Files F12241487

No OneTemporary
Actions

View Options

diff --git a/database/scripts/populate_data.sql b/database/scripts/populate_data.sql
deleted file mode 100644
index e5bc234..0000000
--- a/database/scripts/populate_data.sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- POPULATE DB
-
----- Create a new group
-INSERT INTO service_group (name, description)
-VALUES ('Group 1', 'This is the first service group.'),
- ('Group 2', 'This is the second service group.')
-RETURNING *;
-
----- Insert data into the service table:
-INSERT INTO service (name, "group", description, status)
-VALUES ('Service A', 1, 'Description A', 'Active'),
- ('Service B', 2, 'Description B', 'Inactive'),
- ('Service C', 1, 'Description C', 'Active')
-RETURNING *;
diff --git a/database/servpulse.sql b/database/servpulse.sql
deleted file mode 100644
index df7cf63..0000000
--- a/database/servpulse.sql
+++ /dev/null
@@ -1,59 +0,0 @@
-CREATE TABLE "service" (
- "id" serial PRIMARY KEY,
- "name" varchar,
- "group" int,
- "description" varchar,
- "status" varchar
-);
-
-CREATE TABLE "service_group" (
- "id" serial PRIMARY KEY,
- "name" varchar,
- "description" varchar
-);
-
-CREATE TABLE "incident" (
- "id" serial PRIMARY KEY,
- "title" varchar,
- "start_date" timestamp,
- "update_date" timestamp,
- "type_id" int,
- "status" varchar
-);
-
-CREATE TABLE "incident_service" (
- "id" serial PRIMARY KEY,
- "incident" int,
- "service" int
-);
-
-CREATE TABLE "incident_type" (
- "id" serial PRIMARY KEY,
- "label" varchar,
- "color" varchar
-);
-
-CREATE TABLE "incident_post" (
- "id" serial PRIMARY KEY,
- "incident_id" int,
- "date" timestamp,
- "step_id" int,
- "note" varchar
-);
-
-CREATE TABLE "incident_post_steps" (
- "id" serial PRIMARY KEY,
- "label" varchar
-);
-
-ALTER TABLE "service" ADD FOREIGN KEY ("group") REFERENCES "service_group" ("id");
-
-ALTER TABLE "incident" ADD FOREIGN KEY ("type_id") REFERENCES "incident_type" ("id");
-
-ALTER TABLE "incident_service" ADD FOREIGN KEY ("incident") REFERENCES "incident" ("id");
-
-ALTER TABLE "incident_service" ADD FOREIGN KEY ("service") REFERENCES "service" ("id");
-
-ALTER TABLE "incident_post" ADD FOREIGN KEY ("incident_id") REFERENCES "incident" ("id");
-
-ALTER TABLE "incident_post" ADD FOREIGN KEY ("step_id") REFERENCES "incident_post_steps" ("id");

File Metadata

Mime Type
text/x-diff
Expires
Sun, Oct 12, 05:22 (13 h, 24 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3060800
Default Alt Text
(2 KB)

Event Timeline

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator