HSQLDB uses the :hsqldb database type.
# File lib/sequel/adapters/jdbc/hsqldb.rb, line 26 def database_type :hsqldb end
The version of the database, as an integer (e.g 2.2.5 -> 20205)
# File lib/sequel/adapters/jdbc/hsqldb.rb, line 42 def db_version return @db_version if defined?(@db_version) v = get(Sequel.function(:DATABASE_VERSION)) @db_version = if v =~ /(\d+)\.(\d+)\.(\d+)/ $1.to_i * 10000 + $2.to_i * 100 + $3.to_i end end
# File lib/sequel/adapters/jdbc/hsqldb.rb, line 30 def freeze db_version super end
HSQLDB uses an IDENTITY sequence as the default value for primary key columns.
# File lib/sequel/adapters/jdbc/hsqldb.rb, line 37 def serial_primary_key_options {:primary_key => true, :type => :integer, :identity=>true, :start_with=>1} end
HSQLDB supports DROP TABLE IF EXISTS
# File lib/sequel/adapters/jdbc/hsqldb.rb, line 51 def supports_drop_table_if_exists? true end