Page MenuHomeDevCentral

No OneTemporary

diff --git a/database/scripts/populate_data.sql b/database/scripts/populate_data.sql
new file mode 100644
index 0000000..e5bc234
--- /dev/null
+++ b/database/scripts/populate_data.sql
@@ -0,0 +1,14 @@
+-- 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 *;

File Metadata

Mime Type
text/x-diff
Expires
Thu, Dec 26, 16:53 (1 d, 8 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2312839
Default Alt Text
(692 B)

Event Timeline