From b335352b0a985e2d90a1edce576e2fe298870860 Mon Sep 17 00:00:00 2001 From: Matthew King Date: Wed, 10 Oct 2007 16:10:55 -0500 Subject: [PATCH] I did most of the initial work without any SCM. I am so bad. --- README | 4 + init.rb | 5 + install.rb | 1 + lib/album.rb | 90 ++ lib/array_case_equality.rb | 37 + lib/mono_slideshow.rb | 40 + spec/album_spec.rb | 216 +++++ spec/array_case_equality_spec.rb | 43 + spec/db/database.yml | 3 + spec/db/mono_slideshow.sqlite3.db | Bin 0 -> 4096 bytes spec/db/schema.rb | 15 + spec/debug.log | 1695 +++++++++++++++++++++++++++++++++++++ spec/slideshow_spec.rb | 71 ++ spec/spec_helper.rb | 16 + tasks/mono_slideshow_tasks.rake | 4 + uninstall.rb | 1 + 16 files changed, 2241 insertions(+) create mode 100644 README create mode 100644 init.rb create mode 100644 install.rb create mode 100644 lib/album.rb create mode 100644 lib/array_case_equality.rb create mode 100644 lib/mono_slideshow.rb create mode 100644 spec/album_spec.rb create mode 100644 spec/array_case_equality_spec.rb create mode 100644 spec/db/database.yml create mode 100644 spec/db/mono_slideshow.sqlite3.db create mode 100644 spec/db/schema.rb create mode 100644 spec/debug.log create mode 100644 spec/slideshow_spec.rb create mode 100644 spec/spec_helper.rb create mode 100644 tasks/mono_slideshow_tasks.rake create mode 100644 uninstall.rb diff --git a/README b/README new file mode 100644 index 0000000..a561f1b --- /dev/null +++ b/README @@ -0,0 +1,4 @@ +MonoSlideshow +============= + +Description goes here \ No newline at end of file diff --git a/init.rb b/init.rb new file mode 100644 index 0000000..0fa2a0f --- /dev/null +++ b/init.rb @@ -0,0 +1,5 @@ +require 'mono_slideshow' +require 'album' +require 'slideshow' +ActiveRecord::Base.send(:include, MonoSlideshow::Album) +ActionController::Base.send(:include, MonoSlideshow::SlideshowXML) \ No newline at end of file diff --git a/install.rb b/install.rb new file mode 100644 index 0000000..f7732d3 --- /dev/null +++ b/install.rb @@ -0,0 +1 @@ +# Install hook code here diff --git a/lib/album.rb b/lib/album.rb new file mode 100644 index 0000000..4cf3707 --- /dev/null +++ b/lib/album.rb @@ -0,0 +1,90 @@ +module MonoSlideshow + module Album + def self.included(base) + base.extend ClassMethods + end + + module ClassMethods + def slideshow_album(*args) + @@mono_album_options = {} + @@mono_slide_options = {} + define_method(:mono_album_options) { @@mono_album_options } + define_method(:mono_slide_options) { @@mono_slide_options } + case args + when [Symbol, Symbol] + @@mono_album_options[:from] = args[0] + @@mono_slide_options[:src] = args[1] + when [Hash] + options = args[0] + @@mono_slide_options = options.delete(:slides) + @@mono_album_options = options + else + raise ArgumentError + end + + define_method(:mono_album_slides) {self.send(mono_album_options[:from])} + + define_method(:mono_album_title) do + self.send(mono_album_options[:title]) if mono_album_options[:title] + end + + define_method(:mono_album_description) do + self.send(mono_album_options[:description]) if mono_album_options[:description] + end + + define_method(:mono_slide_src) { |slide| slide.send mono_slide_options[:src] } + + define_method(:mono_slide_title) do |slide| + slide.send mono_slide_options[:title] if mono_slide_options[:title] + end + + define_method(:mono_slide_description) do |slide| + slide.send mono_slide_options[:description] if mono_slide_options[:description] + end + + define_method(:mono_album_thumbnail) { mono_slide_src(mono_album_slides.first) } + + include InstanceMethods + + # default_options = { :from => :images, + # :title => :title, + # :description => :description, + # :slide => { :title => :title, + # :src => :public_filename, + # :description => :description }} + # + # options = default_options.merge(options) + # @@mono_slide_association = options[:from] + # @@mono_slide_src_method = options[:slide][:src] + # @@mono_slide_description_method = options[:slide][:description] + # @@mono_album_title = options[:title] + # @@mono_album_description = options[:description] + # + # define_method(:mono_slide_src_method) { @@mono_slide_src_method } + # define_method(:mono_slide_description_method) { @@mono_slide_description_method } + # define_method(:mono_album_title) { self.send(@@mono_album_title) } + # define_method(:mono_album_description) { self.send(@@mono_album_description) } + # + end + end + + module InstanceMethods + + def slideshow_album_xml(xml=nil) + xml ||= Builder::XmlMarkup.new(:indent => 4) + album_hash = {:title => mono_album_title, + :description => mono_album_description, + :thumbnail => mono_album_thumbnail}.reject { |k,v| v.blank? } + xml.album(album_hash) do + mono_album_slides.each do |image| + image_hash = {:src => mono_slide_src(image), + :title => mono_slide_title(image), + :description => mono_slide_description(image)}.reject { |k,v| v.blank? } + xml.img(image_hash) + end + end + end + end + + end +end \ No newline at end of file diff --git a/lib/array_case_equality.rb b/lib/array_case_equality.rb new file mode 100644 index 0000000..06f7714 --- /dev/null +++ b/lib/array_case_equality.rb @@ -0,0 +1,37 @@ +class Array + + alias :case_equal? :=== + + def ===(other, counter = [0], my_rec = {}, his_rec = {}) # !> method redefined; discarding old eql? + return true if other.object_id == self.object_id + return false unless other.is_a? Array + return true if other == self + return false unless other.size == self.size + + counter[0] += 1 + my_rec[object_id] = his_rec[other.object_id] = counter[0] + + size.times do |i| + x, y = self[i], other[i] + xid, yid = x.object_id, y.object_id + if x.is_a? Array and y.is_a? Array + recursive = my_rec[xid] || his_rec[yid] + if recursive && my_rec[xid] != his_rec[yid] + return false + elsif recursive # matches because the two arrays have same object_id + next + else # not recursive, just compare normally + return false unless x.===(y, counter, my_rec, his_rec) + end + elsif x.is_a? Array + # if x is an Array, but y is not + return false + else + # general case + return false unless x === y + end + end + + true + end +end diff --git a/lib/mono_slideshow.rb b/lib/mono_slideshow.rb new file mode 100644 index 0000000..fe7c509 --- /dev/null +++ b/lib/mono_slideshow.rb @@ -0,0 +1,40 @@ +require 'album' +require 'array_case_equality' + + +module MonoSlideshow + module SlideshowXML + + DEFAULTS = { :imageScaleMode => :scaleToFit } + + def self.included(base) + + end + + def mono_slideshow_xml(albums, preferences={}) + albums = [albums].flatten + merged_prefs = albums.size == 1 ? {:showAlbumsButton => 'false'} : {} + merged_prefs.merge!(preferences).reverse_merge!(DEFAULTS) + xml = Builder::XmlMarkup.new + xml.instruct! :xml, :version => '1.0', :encoding => 'utf-8' + xml.slideshow do + xml.preferences(merged_prefs) + albums.each do |album| + album.slideshow_album_xml(xml) + end + end + + end + end + +end + +class Hash + def recursive_merge(h) + self.merge(h) {|key, _old, _new| if _old.class == Hash then _old.recursive_merge(_new) else _new end } + end + + def recursive_merge!(h) + self.merge!(h) {|key, _old, _new| if _old.class == Hash then _old.recursive_merge!(_new) else _new end } + end +end \ No newline at end of file diff --git a/spec/album_spec.rb b/spec/album_spec.rb new file mode 100644 index 0000000..bfa9a23 --- /dev/null +++ b/spec/album_spec.rb @@ -0,0 +1,216 @@ +require File.dirname(__FILE__) + '/spec_helper' + +def minimal_slideshow1 + Model.slideshow_album :from => :pictures, :slides => { :src => :absolute_path } +end + +def minimal_slideshow2 + # this form should result in minimal slideshow album attributes + Model.slideshow_album :pictures, :public_filename +end + +def customized_slideshow1 + Model.slideshow_album :from => :pictures, :title => :display_name, :description => :notes, + :slides => { :src => :public_filename, :title => :name, :description => :caption } +end + +# describe "Calling the class method slideshow_album(:from => :images)" do +# +# it "should define #slideshow_album_xml as an instance method" do +# Model.slideshow_album :from => :images +# Model.new.should respond_to :slideshow_album_xml +# end +# +# end + +describe "Calling slideshow_album without arguments" do + it "should raise an error" do + lambda {Model.slideshow_album}.should raise_error ArgumentError + end +end + +describe "Calling slideshow_album with simple arg form" do + before(:each) do + Model.slideshow_album :pictures, :public_filename + @album = Model.new + end + + it "should define Model#slideshow_album_xml" do + @album.should respond_to :slideshow_album_xml + end + + it "should define hash and accessor for the slideshow config" do + @album.mono_album_options[:from].should == :pictures + end + + it "should create a method for accessing the slide collection" do + @album.should_receive(:pictures) + @album.mono_album_slides + end + + it "should create a method for accessing slide src" do + @slide = mock('slide') + @slide.should_receive(:public_filename) + @album.mono_slide_src(@slide) + end + + it "should create an album thumbnail src accessor, using the first slide by default" do + @slide1 = mock('slide') + @slide2 = mock('slide') + @slides = [@slide1, @slide2] + @slide1.should_receive(:public_filename).and_return('file.jpg') + @album.should_receive(:mono_album_slides).and_return(@slides) + @album.mono_album_thumbnail.should == 'file.jpg' + end + +end + +describe "Calling slideshow_album, full form, minimal args" do + before(:each) do + Model.slideshow_album :from => :pictures, :slides => { :src => :public_filename } + @album = Model.new + end + + it "should define Model#slideshow_album_xml" do + @album.should respond_to :slideshow_album_xml + end + + it "should define hash and accessor for the slideshow config" do + @album.mono_album_options[:from].should == :pictures + end + + it "should create a method for accessing the slide collection" do + @album.should_receive(:pictures) + @album.mono_album_slides + end + + it "should create a method for accessing slide src" do + @slide = mock('slide') + @slide.should_receive(:public_filename) + @album.mono_slide_src(@slide) + end + + it "should create an album thumbnail src accessor, using the first slide by default" do + @slide1 = mock('slide') + @slide2 = mock('slide') + @slides = [@slide1, @slide2] + @slide1.should_receive(:public_filename).and_return('file.jpg') + @album.should_receive(:mono_album_slides).and_return(@slides) + @album.mono_album_thumbnail.should == 'file.jpg' + end + +end + +describe "The slideshow_album_xml method, when created with minimal args" do + before(:each) do + Model.slideshow_album :pictures, :public_filename + @album = Model.new + @picture = mock 'picture' + @pictures = [@picture, @picture] + @album.should_receive(:pictures).twice.and_return(@pictures) + @picture.should_receive(:public_filename).exactly(@pictures.size + 1).times.and_return('file.jpg') + @album_xml = @album.slideshow_album_xml + end + it "should return a properly constructed xml doc" do + @album_xml.should be_an_instance_of String + Hash.from_xml(@album_xml).should == { "album" => { + "thumbnail" => "file.jpg", + "img"=> [{"src" => "file.jpg"}, {"src" => "file.jpg"}] } } + end +end + +describe "Calling slideshow_album with title and description args" do + before(:each) do + Model.slideshow_album :from => :pictures, :title => :display_name, :description => :notes, + :slides => { :src => :public_filename, :title => :name, :description => :caption } + @album = Model.new + end + + it "should define Model#slideshow_album_xml" do + @album.should respond_to :slideshow_album_xml + end + + it "should define hash and accessor for the slideshow config" do + @album.mono_album_options[:from].should == :pictures + @album.mono_album_options[:title].should == :display_name + @album.mono_album_options[:description].should == :notes + end + + it "should set the album collection method" do + @album.should_receive(:pictures) + @album.mono_album_slides + end + + it "should set the album title method" do + @album.should_receive(:display_name) + @album.mono_album_title + end + + it "should set the album description method" do + @album.should_receive(:notes) + @album.mono_album_description + end + + it "should set the slide options" do + @album.mono_slide_options[:src].should == :public_filename + @album.mono_slide_options[:title].should == :name + @album.mono_slide_options[:description].should == :caption + end + + it "should create a method for accessing slide src" do + @slide = mock('slide') + @slide.should_receive(:public_filename) + @album.mono_slide_src(@slide) + end + + it "should create a method for accessing slide titles" do + @slide = mock('slide') + @slide.should_receive(:name) + @album.mono_slide_title(@slide) + end + + it "should create a method for accessing slide descriptions" do + @slide = mock('slide') + @slide.should_receive(:caption) + @album.mono_slide_description(@slide) + end + + it "should create an album thumbnail src accessor, using the first slide by default" do + @slide1 = mock('slide') + @slide2 = mock('slide') + @slides = [@slide1, @slide2] + @slide1.should_receive(:public_filename).and_return('file.jpg') + @album.should_receive(:mono_album_slides).and_return(@slides) + @album.mono_album_thumbnail.should == 'file.jpg' + end + +end + +describe "The slideshow_album_xml method, when created with title and description" do + before(:each) do + Model.slideshow_album :from => :pictures, :title => :display_name, :description => :notes, + :slides => { :src => :public_filename, :title => :name, :description => :caption } + @album = Model.new + @picture = mock 'picture' + @pictures = [@picture, @picture] + @album.should_receive(:pictures).twice.and_return(@pictures) + @album.should_receive(:display_name).and_return('Some Photos I took') + @album.should_receive(:notes).and_return('All of these are photos that I took.') + @picture.should_receive(:public_filename).exactly(@pictures.size + 1).times.and_return('file.jpg') + @picture.should_receive(:name).exactly(@pictures.size).times.and_return('A Photo') + @picture.should_receive(:caption).exactly(@pictures.size).times.and_return('I took it') + @album_xml = @album.slideshow_album_xml + end + + it "should return an xml doc with titles and descriptions for albums and slides" do + Hash.from_xml(@album_xml).should == {"album" => { + "title" => "Some Photos I took", + "description" => "All of these are photos that I took.", + "thumbnail" => "file.jpg", + "img"=>[ + {"title" => "A Photo", "src" => "file.jpg", "description" => "I took it"}, + {"title" => "A Photo", "src" => "file.jpg", "description" => "I took it"}]}} + end +end + + diff --git a/spec/array_case_equality_spec.rb b/spec/array_case_equality_spec.rb new file mode 100644 index 0000000..0d22889 --- /dev/null +++ b/spec/array_case_equality_spec.rb @@ -0,0 +1,43 @@ +require File.dirname(__FILE__) + '/spec_helper' + +describe "Aliased Array#=== method" do + before(:each) do + @a1 = [:thing_one, :thing_two] + @a2 = ['thing_one'.to_sym, 'thing_two'.to_sym] + @a3 = [1, 2] + end + + it "should be callable as #case_equal?" do + @a1.case_equal?(@a2).should be_true + @a1.case_equal?(@a3).should be_false + end + +end + +describe "Redefined Array#=== method on flat arrays" do + it "should return true when Array#== is true, even if elements are not case equal" do + [String, String, Fixnum].===([String, String, Fixnum]).should be_true + end + + it "should return true when all elements are case equal" do + [Symbol].===([:one]).should == Symbol.===(:one) + [/one/].===(['one']).should == /one/.===('one') + [(0..2)].===([1]).should == (0..2).===(1) + end +end + +describe "Redefined Array#=== on nested arrays" do + before(:each) do + @other = [1, 'one', [:one, :two, [], [1.0]]] + @matcher = [(0..3), String, [:one, Symbol, [], [Float]]] + @matcher2 = [[]] + @other2 = [[:one]] + end + it "should return true when all elements and subelements are case equal" do + @matcher.===(@other).should be_true + end + + it "should return false when all elements are not case equal" do + @matcher.===(@other2).should be_false + end +end \ No newline at end of file diff --git a/spec/db/database.yml b/spec/db/database.yml new file mode 100644 index 0000000..e96f7dc --- /dev/null +++ b/spec/db/database.yml @@ -0,0 +1,3 @@ +sqlite3: + :adapter: sqlite3 + :dbfile: vendor/plugins/mono_slideshow/spec/db/mono_slideshow.sqlite3.db diff --git a/spec/db/mono_slideshow.sqlite3.db b/spec/db/mono_slideshow.sqlite3.db new file mode 100644 index 0000000000000000000000000000000000000000..e777edbf85afd2f2a74b83fa2c923731fec16a85 GIT binary patch literal 4096 zcwX(3&riZI6vx|bQ7@hedU+WamUxnIG&->o;zXU}z=?EFSd;xAUBT#0;$P%{;6LTb zgM&rGj0iUm^pp0rdGDLF{WkCZ&f${5FcA@zP(ud77@Ywiq`jd6S}hC4QUaq5+0Ukq z-;w^RpJa>T-# zt!vxu!WHR4`^JNI$8nCp98y~Jp5ah@+Y?PP7iz_gO$~Q@lhauFI!@EuyFDDbm1Zm{YjMO zQ7gEZ=QeY3&8sa(-zilpIRCh`AFzn_csxv&wnpLbr2) literal 0 HcwPel00001 diff --git a/spec/db/schema.rb b/spec/db/schema.rb new file mode 100644 index 0000000..e94deed --- /dev/null +++ b/spec/db/schema.rb @@ -0,0 +1,15 @@ +ActiveRecord::Schema.define(:version => 0) do + create_table :albums, :force => true do |t| + t.column :name, :string + end + + create_table :images, :force => true do |t| + t.column "parent_id", :integer + t.column "content_type", :string + t.column "filename", :string + t.column "thumbnail", :string + t.column "size", :integer + t.column "width", :integer + t.column "height", :integer + end +end diff --git a/spec/debug.log b/spec/debug.log new file mode 100644 index 0000000..0fa89f8 --- /dev/null +++ b/spec/debug.log @@ -0,0 +1,1695 @@ +# Logfile created on Thu Oct 04 15:49:18 -0500 2007 by / + SQL (0.000000) SQLite3::SQLException: no such table: albums: DROP TABLE albums + + SQL (0.003362) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: no such table: images: DROP TABLE images + + SQL (0.002113) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.002081) CREATE TABLE schema_info (version integer) + + SQL (0.001826) INSERT INTO schema_info (version) VALUES(0) + + SQL (0.001964) UPDATE schema_info SET version = 0 + + SQL (0.003233) DROP TABLE albums + + SQL (0.002156) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001692) DROP TABLE images + + SQL (0.002310) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002050) UPDATE schema_info SET version = 0 + + SQL (0.003252) DROP TABLE albums + + SQL (0.002241) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002026) DROP TABLE images + + SQL (0.002179) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001944) UPDATE schema_info SET version = 0 + + SQL (0.003172) DROP TABLE albums + + SQL (0.002147) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001931) DROP TABLE images + + SQL (0.002125) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001987) UPDATE schema_info SET version = 0 + + SQL (0.003671) DROP TABLE albums + + SQL (0.002811) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002945) DROP TABLE images + + SQL (0.002936) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002676) UPDATE schema_info SET version = 0 + + SQL (0.003459) DROP TABLE albums + + SQL (0.002578) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002592) DROP TABLE images + + SQL (0.002629) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002476) UPDATE schema_info SET version = 0 + + SQL (0.003274) DROP TABLE albums + + SQL (0.002470) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002029) DROP TABLE images + + SQL (0.002220) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002072) UPDATE schema_info SET version = 0 + + SQL (0.003428) DROP TABLE albums + + SQL (0.002371) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002285) DROP TABLE images + + SQL (0.002444) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002058) UPDATE schema_info SET version = 0 + + SQL (0.003227) DROP TABLE albums + + SQL (0.002234) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001979) DROP TABLE images + + SQL (0.002278) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002180) UPDATE schema_info SET version = 0 + + SQL (0.003238) DROP TABLE albums + + SQL (0.002222) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002024) DROP TABLE images + + SQL (0.002120) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001952) UPDATE schema_info SET version = 0 + + SQL (0.003350) DROP TABLE albums + + SQL (0.002481) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002331) DROP TABLE images + + SQL (0.002361) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002140) UPDATE schema_info SET version = 0 + + SQL (0.003357) DROP TABLE albums + + SQL (0.002335) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002345) DROP TABLE images + + SQL (0.002516) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002351) UPDATE schema_info SET version = 0 + + SQL (0.004183) DROP TABLE albums + + SQL (0.002808) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.003013) DROP TABLE images + + SQL (0.003984) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002582) UPDATE schema_info SET version = 0 + + SQL (0.003240) DROP TABLE albums + + SQL (0.002373) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002281) DROP TABLE images + + SQL (0.002349) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002380) UPDATE schema_info SET version = 0 + + SQL (0.003298) DROP TABLE albums + + SQL (0.002161) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001971) DROP TABLE images + + SQL (0.002025) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001995) UPDATE schema_info SET version = 0 + + SQL (0.003213) DROP TABLE albums + + SQL (0.002123) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001985) DROP TABLE images + + SQL (0.002142) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002050) UPDATE schema_info SET version = 0 + + SQL (0.003144) DROP TABLE albums + + SQL (0.002094) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001922) DROP TABLE images + + SQL (0.002182) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001881) UPDATE schema_info SET version = 0 + + SQL (0.003224) DROP TABLE albums + + SQL (0.002125) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002266) DROP TABLE images + + SQL (0.002115) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001859) UPDATE schema_info SET version = 0 + + SQL (0.005068) DROP TABLE albums + + SQL (0.002864) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002874) DROP TABLE images + + SQL (0.002956) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002991) UPDATE schema_info SET version = 0 + + SQL (0.003560) DROP TABLE albums + + SQL (0.002918) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002799) DROP TABLE images + + SQL (0.002993) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002728) UPDATE schema_info SET version = 0 + + SQL (0.003381) DROP TABLE albums + + SQL (0.002402) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002178) DROP TABLE images + + SQL (0.002296) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002178) UPDATE schema_info SET version = 0 + + SQL (0.003325) DROP TABLE albums + + SQL (0.002221) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001941) DROP TABLE images + + SQL (0.002053) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001970) UPDATE schema_info SET version = 0 + + SQL (0.003985) DROP TABLE albums + + SQL (0.002831) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002954) DROP TABLE images + + SQL (0.003097) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002977) UPDATE schema_info SET version = 0 + + SQL (0.003512) DROP TABLE albums + + SQL (0.002910) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002550) DROP TABLE images + + SQL (0.002792) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002607) UPDATE schema_info SET version = 0 + + SQL (0.003453) DROP TABLE albums + + SQL (0.002640) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002269) DROP TABLE images + + SQL (0.002436) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002274) UPDATE schema_info SET version = 0 + + SQL (0.003400) DROP TABLE albums + + SQL (0.002581) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002278) DROP TABLE images + + SQL (0.002470) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002263) UPDATE schema_info SET version = 0 + + SQL (0.003273) DROP TABLE albums + + SQL (0.002124) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001941) DROP TABLE images + + SQL (0.002095) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002054) UPDATE schema_info SET version = 0 + + SQL (0.003180) DROP TABLE albums + + SQL (0.002314) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002031) DROP TABLE images + + SQL (0.002158) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001895) UPDATE schema_info SET version = 0 + + SQL (0.003933) DROP TABLE albums + + SQL (0.002543) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002654) DROP TABLE images + + SQL (0.002645) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002281) UPDATE schema_info SET version = 0 + + SQL (0.003261) DROP TABLE albums + + SQL (0.002277) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002182) DROP TABLE images + + SQL (0.002163) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002145) UPDATE schema_info SET version = 0 + + SQL (0.003457) DROP TABLE albums + + SQL (0.002584) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002346) DROP TABLE images + + SQL (0.002605) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002294) UPDATE schema_info SET version = 0 + + SQL (0.003143) DROP TABLE albums + + SQL (0.002172) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002026) DROP TABLE images + + SQL (0.002131) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002171) UPDATE schema_info SET version = 0 + + SQL (0.003217) DROP TABLE albums + + SQL (0.002113) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002042) DROP TABLE images + + SQL (0.002237) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001860) UPDATE schema_info SET version = 0 + + SQL (0.004319) DROP TABLE albums + + SQL (0.002917) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.003077) DROP TABLE images + + SQL (0.002986) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002831) UPDATE schema_info SET version = 0 + + SQL (0.004199) DROP TABLE albums + + SQL (0.002589) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001898) DROP TABLE images + + SQL (0.002040) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001850) UPDATE schema_info SET version = 0 + + SQL (0.003157) DROP TABLE albums + + SQL (0.002284) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002138) DROP TABLE images + + SQL (0.002105) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001965) UPDATE schema_info SET version = 0 + + SQL (0.003200) DROP TABLE albums + + SQL (0.002194) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001989) DROP TABLE images + + SQL (0.002220) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001874) UPDATE schema_info SET version = 0 + + SQL (0.003231) DROP TABLE albums + + SQL (0.002118) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001974) DROP TABLE images + + SQL (0.002104) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001900) UPDATE schema_info SET version = 0 + + SQL (0.004225) DROP TABLE albums + + SQL (0.002992) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002915) DROP TABLE images + + SQL (0.002944) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002815) UPDATE schema_info SET version = 0 + + SQL (0.003304) DROP TABLE albums + + SQL (0.002299) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002006) DROP TABLE images + + SQL (0.002020) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001974) UPDATE schema_info SET version = 0 + + SQL (0.003533) DROP TABLE albums + + SQL (0.002720) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002798) DROP TABLE images + + SQL (0.002811) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002596) UPDATE schema_info SET version = 0 + + SQL (0.003480) DROP TABLE albums + + SQL (0.002318) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002272) DROP TABLE images + + SQL (0.002268) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002025) UPDATE schema_info SET version = 0 + + SQL (0.003448) DROP TABLE albums + + SQL (0.002669) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002680) DROP TABLE images + + SQL (0.002574) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002622) UPDATE schema_info SET version = 0 + + SQL (0.003251) DROP TABLE albums + + SQL (0.002183) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002210) DROP TABLE images + + SQL (0.002223) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002164) UPDATE schema_info SET version = 0 + + SQL (0.003259) DROP TABLE albums + + SQL (0.002119) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001979) DROP TABLE images + + SQL (0.002275) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002043) UPDATE schema_info SET version = 0 + + SQL (0.003517) DROP TABLE albums + + SQL (0.002681) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002573) DROP TABLE images + + SQL (0.002796) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002427) UPDATE schema_info SET version = 0 + + SQL (0.004118) DROP TABLE albums + + SQL (0.003158) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002759) DROP TABLE images + + SQL (0.002916) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002881) UPDATE schema_info SET version = 0 + + SQL (0.003531) DROP TABLE albums + + SQL (0.002656) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002296) DROP TABLE images + + SQL (0.002488) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002435) UPDATE schema_info SET version = 0 + + SQL (0.003288) DROP TABLE albums + + SQL (0.002336) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002071) DROP TABLE images + + SQL (0.002146) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002144) UPDATE schema_info SET version = 0 + + SQL (0.004209) DROP TABLE albums + + SQL (0.002847) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002790) DROP TABLE images + + SQL (0.003161) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002839) UPDATE schema_info SET version = 0 + + SQL (0.003495) DROP TABLE albums + + SQL (0.002475) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002273) DROP TABLE images + + SQL (0.002448) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002355) UPDATE schema_info SET version = 0 + + SQL (0.003228) DROP TABLE albums + + SQL (0.002264) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002133) DROP TABLE images + + SQL (0.002263) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001990) UPDATE schema_info SET version = 0 + + SQL (0.002781) DROP TABLE albums + + SQL (0.002077) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001866) DROP TABLE images + + SQL (0.002162) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001910) UPDATE schema_info SET version = 0 + + SQL (0.004186) DROP TABLE albums + + SQL (0.002888) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002807) DROP TABLE images + + SQL (0.002871) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002765) UPDATE schema_info SET version = 0 + + SQL (0.003274) DROP TABLE albums + + SQL (0.002239) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002013) DROP TABLE images + + SQL (0.002296) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001978) UPDATE schema_info SET version = 0 + + SQL (0.003219) DROP TABLE albums + + SQL (0.002147) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002028) DROP TABLE images + + SQL (0.002182) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002225) UPDATE schema_info SET version = 0 + + SQL (0.003324) DROP TABLE albums + + SQL (0.002074) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001982) DROP TABLE images + + SQL (0.002062) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001902) UPDATE schema_info SET version = 0 + + SQL (0.003678) DROP TABLE albums + + SQL (0.002768) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002486) DROP TABLE images + + SQL (0.002572) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002512) UPDATE schema_info SET version = 0 + + SQL (0.003616) DROP TABLE albums + + SQL (0.002766) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002590) DROP TABLE images + + SQL (0.002701) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002667) UPDATE schema_info SET version = 0 + + SQL (0.004184) DROP TABLE albums + + SQL (0.003040) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002735) DROP TABLE images + + SQL (0.002908) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002841) UPDATE schema_info SET version = 0 + + SQL (0.003265) DROP TABLE albums + + SQL (0.002328) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002178) DROP TABLE images + + SQL (0.002387) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002148) UPDATE schema_info SET version = 0 + + SQL (0.004590) DROP TABLE albums + + SQL (0.003031) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002955) DROP TABLE images + + SQL (0.003073) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002739) UPDATE schema_info SET version = 0 + + SQL (0.003208) DROP TABLE albums + + SQL (0.002151) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002069) DROP TABLE images + + SQL (0.002093) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002063) UPDATE schema_info SET version = 0 + + SQL (0.003198) DROP TABLE albums + + SQL (0.002228) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002188) DROP TABLE images + + SQL (0.002129) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001909) UPDATE schema_info SET version = 0 + + SQL (0.003253) DROP TABLE albums + + SQL (0.002146) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001991) DROP TABLE images + + SQL (0.002211) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001941) UPDATE schema_info SET version = 0 + + SQL (0.003233) DROP TABLE albums + + SQL (0.002277) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002181) DROP TABLE images + + SQL (0.002435) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002168) UPDATE schema_info SET version = 0 + + SQL (0.003443) DROP TABLE albums + + SQL (0.002155) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001968) DROP TABLE images + + SQL (0.002073) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001895) UPDATE schema_info SET version = 0 + + SQL (0.003285) DROP TABLE albums + + SQL (0.002034) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001993) DROP TABLE images + + SQL (0.002108) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002158) UPDATE schema_info SET version = 0 + + SQL (0.003640) DROP TABLE albums + + SQL (0.002681) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002654) DROP TABLE images + + SQL (0.002807) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002631) UPDATE schema_info SET version = 0 + + SQL (0.003286) DROP TABLE albums + + SQL (0.002110) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002044) DROP TABLE images + + SQL (0.002101) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001985) UPDATE schema_info SET version = 0 + + SQL (0.003617) DROP TABLE albums + + SQL (0.002750) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002464) DROP TABLE images + + SQL (0.002759) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002415) UPDATE schema_info SET version = 0 + + SQL (0.004152) DROP TABLE albums + + SQL (0.002977) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002796) DROP TABLE images + + SQL (0.003057) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002848) UPDATE schema_info SET version = 0 + + SQL (0.003307) DROP TABLE albums + + SQL (0.002298) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002019) DROP TABLE images + + SQL (0.002181) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001967) UPDATE schema_info SET version = 0 + + SQL (0.003455) DROP TABLE albums + + SQL (0.002645) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002406) DROP TABLE images + + SQL (0.002869) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002212) UPDATE schema_info SET version = 0 + + SQL (0.003311) DROP TABLE albums + + SQL (0.002282) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002172) DROP TABLE images + + SQL (0.002338) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001996) UPDATE schema_info SET version = 0 + + SQL (0.003439) DROP TABLE albums + + SQL (0.002485) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002485) DROP TABLE images + + SQL (0.002529) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002272) UPDATE schema_info SET version = 0 + + SQL (0.004083) DROP TABLE albums + + SQL (0.002988) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002924) DROP TABLE images + + SQL (0.002885) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002651) UPDATE schema_info SET version = 0 + + SQL (0.003905) DROP TABLE albums + + SQL (0.002466) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002345) DROP TABLE images + + SQL (0.002526) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002336) UPDATE schema_info SET version = 0 + + SQL (0.003609) DROP TABLE albums + + SQL (0.002563) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002417) DROP TABLE images + + SQL (0.002533) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002337) UPDATE schema_info SET version = 0 + + SQL (0.003422) DROP TABLE albums + + SQL (0.002438) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002342) DROP TABLE images + + SQL (0.002469) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002281) UPDATE schema_info SET version = 0 + + SQL (0.003104) DROP TABLE albums + + SQL (0.002204) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002060) DROP TABLE images + + SQL (0.002303) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001919) UPDATE schema_info SET version = 0 + + SQL (0.003617) DROP TABLE albums + + SQL (0.002587) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002313) DROP TABLE images + + SQL (0.002498) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002283) UPDATE schema_info SET version = 0 + + SQL (0.003665) DROP TABLE albums + + SQL (0.002659) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002518) DROP TABLE images + + SQL (0.002653) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002321) UPDATE schema_info SET version = 0 + + SQL (0.003405) DROP TABLE albums + + SQL (0.002142) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001956) DROP TABLE images + + SQL (0.002077) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001963) UPDATE schema_info SET version = 0 + + SQL (0.003261) DROP TABLE albums + + SQL (0.002151) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002183) DROP TABLE images + + SQL (0.002124) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001957) UPDATE schema_info SET version = 0 + + SQL (0.004143) DROP TABLE albums + + SQL (0.003150) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002783) DROP TABLE images + + SQL (0.002980) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002817) UPDATE schema_info SET version = 0 + + SQL (0.003356) DROP TABLE albums + + SQL (0.001964) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002031) DROP TABLE images + + SQL (0.002162) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002349) UPDATE schema_info SET version = 0 + + SQL (0.003196) DROP TABLE albums + + SQL (0.002161) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002096) DROP TABLE images + + SQL (0.002277) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002117) UPDATE schema_info SET version = 0 + + SQL (0.003181) DROP TABLE albums + + SQL (0.002206) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002020) DROP TABLE images + + SQL (0.002270) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002140) UPDATE schema_info SET version = 0 + + SQL (0.003286) DROP TABLE albums + + SQL (0.002113) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001862) DROP TABLE images + + SQL (0.002184) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001961) UPDATE schema_info SET version = 0 + + SQL (0.003393) DROP TABLE albums + + SQL (0.002554) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002365) DROP TABLE images + + SQL (0.002624) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002229) UPDATE schema_info SET version = 0 + + SQL (0.003353) DROP TABLE albums + + SQL (0.002287) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002097) DROP TABLE images + + SQL (0.002067) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001895) UPDATE schema_info SET version = 0 + + SQL (0.003722) DROP TABLE albums + + SQL (0.002680) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002725) DROP TABLE images + + SQL (0.002650) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002562) UPDATE schema_info SET version = 0 + + SQL (0.003280) DROP TABLE albums + + SQL (0.002117) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002004) DROP TABLE images + + SQL (0.002299) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002049) UPDATE schema_info SET version = 0 + + SQL (0.003545) DROP TABLE albums + + SQL (0.002744) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002618) DROP TABLE images + + SQL (0.002593) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002447) UPDATE schema_info SET version = 0 + + SQL (0.003439) DROP TABLE albums + + SQL (0.002507) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002342) DROP TABLE images + + SQL (0.002558) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002358) UPDATE schema_info SET version = 0 + + SQL (0.003592) DROP TABLE albums + + SQL (0.002352) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001959) DROP TABLE images + + SQL (0.002053) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002140) UPDATE schema_info SET version = 0 + + SQL (0.003736) DROP TABLE albums + + SQL (0.002771) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002669) DROP TABLE images + + SQL (0.002727) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002668) UPDATE schema_info SET version = 0 + + SQL (0.003319) DROP TABLE albums + + SQL (0.002306) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002215) DROP TABLE images + + SQL (0.002350) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002279) UPDATE schema_info SET version = 0 + + SQL (0.002923) DROP TABLE albums + + SQL (0.002217) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002354) DROP TABLE images + + SQL (0.002210) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001888) UPDATE schema_info SET version = 0 + + SQL (0.003254) DROP TABLE albums + + SQL (0.002322) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002028) DROP TABLE images + + SQL (0.002389) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001959) UPDATE schema_info SET version = 0 + + SQL (0.003223) DROP TABLE albums + + SQL (0.002199) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002041) DROP TABLE images + + SQL (0.002099) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002009) UPDATE schema_info SET version = 0 + + SQL (0.003517) DROP TABLE albums + + SQL (0.002413) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002150) DROP TABLE images + + SQL (0.002451) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002175) UPDATE schema_info SET version = 0 + + SQL (0.003302) DROP TABLE albums + + SQL (0.002125) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001911) DROP TABLE images + + SQL (0.001968) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002026) UPDATE schema_info SET version = 0 + + SQL (0.003587) DROP TABLE albums + + SQL (0.002844) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002517) DROP TABLE images + + SQL (0.002649) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002679) UPDATE schema_info SET version = 0 + + SQL (0.003542) DROP TABLE albums + + SQL (0.002678) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002532) DROP TABLE images + + SQL (0.002804) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002493) UPDATE schema_info SET version = 0 + + SQL (0.004046) DROP TABLE albums + + SQL (0.002938) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002834) DROP TABLE images + + SQL (0.003145) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002817) UPDATE schema_info SET version = 0 + + SQL (0.004097) DROP TABLE albums + + SQL (0.002245) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001947) DROP TABLE images + + SQL (0.002094) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001856) UPDATE schema_info SET version = 0 + + SQL (0.003617) DROP TABLE albums + + SQL (0.002794) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002565) DROP TABLE images + + SQL (0.002758) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002483) UPDATE schema_info SET version = 0 + + SQL (0.003993) DROP TABLE albums + + SQL (0.002973) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002823) DROP TABLE images + + SQL (0.002956) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002793) UPDATE schema_info SET version = 0 + + SQL (0.003429) DROP TABLE albums + + SQL (0.002440) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002326) DROP TABLE images + + SQL (0.002446) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002088) UPDATE schema_info SET version = 0 + + SQL (0.003176) DROP TABLE albums + + SQL (0.002213) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002150) DROP TABLE images + + SQL (0.002291) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002014) UPDATE schema_info SET version = 0 + + SQL (0.003183) DROP TABLE albums + + SQL (0.002088) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001970) DROP TABLE images + + SQL (0.002221) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001965) UPDATE schema_info SET version = 0 + + SQL (0.003615) DROP TABLE albums + + SQL (0.002701) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002426) DROP TABLE images + + SQL (0.002599) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002768) UPDATE schema_info SET version = 0 + + SQL (0.003550) DROP TABLE albums + + SQL (0.002173) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002036) DROP TABLE images + + SQL (0.002141) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002154) UPDATE schema_info SET version = 0 + + SQL (0.004141) DROP TABLE albums + + SQL (0.003176) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002815) DROP TABLE images + + SQL (0.003008) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002776) UPDATE schema_info SET version = 0 + + SQL (0.003121) DROP TABLE albums + + SQL (0.002059) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001918) DROP TABLE images + + SQL (0.002023) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002023) UPDATE schema_info SET version = 0 + + SQL (0.003221) DROP TABLE albums + + SQL (0.002210) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002729) DROP TABLE images + + SQL (0.002057) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002040) UPDATE schema_info SET version = 0 + + SQL (0.003438) DROP TABLE albums + + SQL (0.002586) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002544) DROP TABLE images + + SQL (0.002540) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002508) UPDATE schema_info SET version = 0 + + SQL (0.003309) DROP TABLE albums + + SQL (0.002176) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002024) DROP TABLE images + + SQL (0.002121) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002086) UPDATE schema_info SET version = 0 + + SQL (0.003537) DROP TABLE albums + + SQL (0.002682) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002563) DROP TABLE images + + SQL (0.002650) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002525) UPDATE schema_info SET version = 0 + + SQL (0.003444) DROP TABLE albums + + SQL (0.002254) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002041) DROP TABLE images + + SQL (0.002134) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001887) UPDATE schema_info SET version = 0 + + SQL (0.003657) DROP TABLE albums + + SQL (0.002587) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002564) DROP TABLE images + + SQL (0.002657) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002501) UPDATE schema_info SET version = 0 + + SQL (0.003267) DROP TABLE albums + + SQL (0.002086) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001960) DROP TABLE images + + SQL (0.002264) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002106) UPDATE schema_info SET version = 0 + + SQL (0.003202) DROP TABLE albums + + SQL (0.002230) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002017) DROP TABLE images + + SQL (0.002292) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001994) UPDATE schema_info SET version = 0 + + SQL (0.003147) DROP TABLE albums + + SQL (0.002114) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001955) DROP TABLE images + + SQL (0.002293) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001907) UPDATE schema_info SET version = 0 + + SQL (0.003468) DROP TABLE albums + + SQL (0.002453) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002238) DROP TABLE images + + SQL (0.002518) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002287) UPDATE schema_info SET version = 0 + + SQL (0.003274) DROP TABLE albums + + SQL (0.002164) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002115) DROP TABLE images + + SQL (0.002152) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001973) UPDATE schema_info SET version = 0 + + SQL (0.003615) DROP TABLE albums + + SQL (0.002689) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002549) DROP TABLE images + + SQL (0.002666) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002343) UPDATE schema_info SET version = 0 + + SQL (0.003277) DROP TABLE albums + + SQL (0.002136) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002021) DROP TABLE images + + SQL (0.002134) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001774) UPDATE schema_info SET version = 0 + + SQL (0.003212) DROP TABLE albums + + SQL (0.002268) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001969) DROP TABLE images + + SQL (0.002068) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001959) UPDATE schema_info SET version = 0 + + SQL (0.005116) DROP TABLE albums + + SQL (0.001726) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001946) DROP TABLE images + + SQL (0.002047) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001625) UPDATE schema_info SET version = 0 + + SQL (0.003999) DROP TABLE albums + + SQL (0.002838) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.001932) DROP TABLE images + + SQL (0.002044) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002046) UPDATE schema_info SET version = 0 + + SQL (0.003169) DROP TABLE albums + + SQL (0.001976) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002054) DROP TABLE images + + SQL (0.002050) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001855) UPDATE schema_info SET version = 0 + + SQL (0.003241) DROP TABLE albums + + SQL (0.002115) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002039) DROP TABLE images + + SQL (0.001974) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.001822) UPDATE schema_info SET version = 0 + + SQL (0.003381) DROP TABLE albums + + SQL (0.109731) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002492) DROP TABLE images + + SQL (0.002593) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002353) UPDATE schema_info SET version = 0 + + SQL (0.003402) DROP TABLE albums + + SQL (0.002717) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002438) DROP TABLE images + + SQL (0.002594) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002616) UPDATE schema_info SET version = 0 + + SQL (0.003519) DROP TABLE albums + + SQL (0.002566) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002303) DROP TABLE images + + SQL (0.002629) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002411) UPDATE schema_info SET version = 0 + + SQL (0.003929) DROP TABLE albums + + SQL (0.355165) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002081) DROP TABLE images + + SQL (0.002145) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002041) UPDATE schema_info SET version = 0 + + SQL (0.003301) DROP TABLE albums + + SQL (0.097022) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002306) DROP TABLE images + + SQL (0.002696) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002415) UPDATE schema_info SET version = 0 + + SQL (0.004339) DROP TABLE albums + + SQL (0.002884) CREATE TABLE albums ("id" INTEGER PRIMARY KEY NOT NULL, "name" varchar(255) DEFAULT NULL)  + + SQL (0.002563) DROP TABLE images + + SQL (0.002791) CREATE TABLE images ("id" INTEGER PRIMARY KEY NOT NULL, "parent_id" integer DEFAULT NULL, "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT NULL, "thumbnail" varchar(255) DEFAULT NULL, "size" integer DEFAULT NULL, "width" integer DEFAULT NULL, "height" integer DEFAULT NULL)  + + SQL (0.000000) SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer) + + SQL (0.002748) UPDATE schema_info SET version = 0 + diff --git a/spec/slideshow_spec.rb b/spec/slideshow_spec.rb new file mode 100644 index 0000000..29b0ad4 --- /dev/null +++ b/spec/slideshow_spec.rb @@ -0,0 +1,71 @@ +require File.dirname(__FILE__) + '/spec_helper' + +describe "Creating a slideshow from a single album without specifying prefs" do + + before(:each) do + @controller = Controller.new + @album = Model.new + @album.stub!(:slideshow_album_xml) + end + + it "should return a string" do + @controller.mono_slideshow_xml(@album).should be_an_instance_of String + end + + it "should call slideshow_album_xml on the album once" do + @album.should_receive(:slideshow_album_xml).once + @controller.mono_slideshow_xml(@album) + end + + it "should return expected XML doc with defaults" do + @album.should_receive(:slideshow_album_xml).once + slideshow = @controller.mono_slideshow_xml(@album) + slideshow.should be_an_instance_of String + pref_hash = {"imageScaleMode"=>"scaleToFit", "showAlbumsButton" => "false"} + Hash.from_xml(slideshow).should == {"slideshow"=>{"preferences"=> pref_hash}} + end + + it "should convert each album to xml" do + @album.should_receive(:slideshow_album_xml).once + @controller.mono_slideshow_xml(@album) + end + +end + +describe "Creating a slideshow from multiple albums" do + + before(:each) do + @controller = Controller.new + @album = Model.new + @album.stub!(:slideshow_album_xml) + @albums = [@album,@album] + end + + + it "should return an xml doc" do + @album.should_receive(:slideshow_album_xml).twice + slideshow = @controller.mono_slideshow_xml(@albums) + slideshow.should be_an_instance_of String + pref_hash = {"imageScaleMode"=>"scaleToFit"} + Hash.from_xml(slideshow).should == {"slideshow"=>{"preferences"=> pref_hash}} + end + + it "should convert each album to xml" do + @album.should_receive(:slideshow_album_xml).exactly(@albums.size).times + @controller.mono_slideshow_xml(@albums) + end + +end + +describe "Specifying preferences for a slideshow" do + it "should return an XML doc with global prefs" do + @controller = Controller.new + @album = Model.new + @album.stub!(:slideshow_album_xml) + @albums = [@album,@album] + slideshow = @controller.mono_slideshow_xml(@albums, :showThumbnailsButton => :false, :imageScaleMode => :scaleToFill) + slideshow.should be_an_instance_of String + pref_hash = {"imageScaleMode"=>"scaleToFill", "showThumbnailsButton" => "false"} + Hash.from_xml(slideshow).should == {"slideshow"=>{"preferences"=> pref_hash}} + end +end diff --git a/spec/spec_helper.rb b/spec/spec_helper.rb new file mode 100644 index 0000000..839d792 --- /dev/null +++ b/spec/spec_helper.rb @@ -0,0 +1,16 @@ +require File.dirname(__FILE__) + '/../../../../spec/spec_helper' + +plugin_spec_dir = File.dirname(__FILE__) +# ActiveRecord::Base.logger = Logger.new(plugin_spec_dir + "/debug.log") + +# databases = YAML::load(IO.read(plugin_spec_dir + "/db/database.yml")) +# ActiveRecord::Base.establish_connection(databases[ENV["DB"] || "sqlite3"]) +# load(File.join(plugin_spec_dir, "db", "schema.rb")) + +class Model + include MonoSlideshow::Album +end + +class Controller + include MonoSlideshow::SlideshowXML +end diff --git a/tasks/mono_slideshow_tasks.rake b/tasks/mono_slideshow_tasks.rake new file mode 100644 index 0000000..a73da04 --- /dev/null +++ b/tasks/mono_slideshow_tasks.rake @@ -0,0 +1,4 @@ +# desc "Explaining what the task does" +# task :mono_slideshow do +# # Task goes here +# end \ No newline at end of file diff --git a/uninstall.rb b/uninstall.rb new file mode 100644 index 0000000..9738333 --- /dev/null +++ b/uninstall.rb @@ -0,0 +1 @@ +# Uninstall hook code here -- 2.11.4.GIT