gallery

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/tables/general.gallery.sql b/sql/tables/general.gallery.sql
new file mode 100644
index 0000000..63b3172
--- /dev/null
+++ b/sql/tables/general.gallery.sql
@@ -0,0 +1,11 @@
+drop table general.gallery cascade;
+
+create table general.gallery (
+    id serial8 primary key,
+    description text,
+    filename character varying(255) not null,
+    mime_type character varying(255) not null,
+    content bytea not null,
+    created timestamp without time zone not null default now(),
+    modified timestamp without time zone not null default now()
+);