src/server/plugins/postgresql/test/postgresql_vfs.sql

changeset 385
a1f4cb076d2f
parent 288
7dd45173f68a
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/server/plugins/postgresql/test/postgresql_vfs.sql	Sat Sep 24 16:26:10 2022 +0200
@@ -0,0 +1,16 @@
+
+create table Resource (
+    resource_id       serial    primary key,
+    parent_id         int       references Resource(resource_id),
+    nodename          text      not null,
+    iscollection      boolean   not null default false,
+	
+    lastmodified      timestamp not null default current_date,
+    creationdate      timestamp not null default current_date,
+    contentlength     bigint    not null default 0,
+
+    resoid            oid,
+    
+    unique(parent_id, nodename)
+);
+

mercurial