Add a concept where an image can be a rendering of another, which means it is not...

[pr0n] / sql / upgrade-v3.11.sql

diff --git a/sql/upgrade-v3.11.sql b/sql/upgrade-v3.11.sql
new file mode 100644 (file)
index 0000000..7996fea
--- /dev/null
+++ b/sql/upgrade-v3.11.sql
@@ -0,0 +1,8 @@
+alter table images add column is_render boolean NOT NULL DEFAULT false;
+alter table images add column render_id integer;
+CREATE UNIQUE INDEX unique_id_for_render ON images USING btree (vhost, event, id);
+alter table images add foreign key (render_id,vhost,event) REFERENCES images (id,vhost,event);
+alter table images add check (NOT (is_render AND (render_id IS NOT NULL)));
+
+alter table deleted_images add column is_render boolean NOT NULL DEFAULT false;
+alter table deleted_images add column render_id integer;