Page Menu
Home
DevCentral
Search
Configure Global Search
Log In
Files
F3942588
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
692 B
Referenced Files
None
Subscribers
None
View Options
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
Details
Attached
Mime Type
text/x-diff
Expires
Thu, Dec 26, 16:53 (20 h, 22 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2312839
Default Alt Text
(692 B)
Attached To
Mode
rSP ServPulse
Attached
Detach File
Event Timeline
Log In to Comment