]> git.sesse.net Git - pr0n/commit - sql/pr0n.sql
Make some sorely needed changes to the SQL schema, and update the code
authorSteinar H. Gunderson <sesse@debian.org>
Tue, 19 Jun 2007 13:15:53 +0000 (15:15 +0200)
committerSteinar H. Gunderson <sesse@debian.org>
Tue, 19 Jun 2007 13:15:53 +0000 (15:15 +0200)
commit6be9a26e71fc85e69cbbdbc95fc50d3569050921
tree7ae70c398a97a8e18768f41e8ac6bf661647357f
parentc418c8bb8654b7aa1ea16357fe259ef65022cab8
Make some sorely needed changes to the SQL schema, and update the code
accordingly (I really hope I fixed everything; I've done some testing, and
it seems largely OK). The biggest change is that the event primary key is
now (vhost,event) and not just (event), which is rippling through all the
tables; this means the vhosts are finally truly independent. Also clean up
to remove some old length restrictions from the MySQL days.
perl/Sesse/pr0n/Common.pm
perl/Sesse/pr0n/Image.pm
perl/Sesse/pr0n/Index.pm
perl/Sesse/pr0n/Listing.pm
perl/Sesse/pr0n/Rotate.pm
perl/Sesse/pr0n/Select.pm
perl/Sesse/pr0n/WebDAV.pm
sql/pr0n.sql
sql/upgrade-v2.40.sql [new file with mode: 0644]