# File lib/sqlite_magic.rb, line 36 def create_table(tbl_name, col_names, unique_keys=nil) puts "Now creating new table: #{tbl_name}" if verbose? query = unique_keys ? "CREATE TABLE #{tbl_name} (#{col_names.join(',')}, UNIQUE (#{unique_keys.join(',')}))" : "CREATE TABLE #{tbl_name} (#{col_names.join(',')})" database.execute query if unique_keys && !unique_keys.empty? query = "CREATE UNIQUE INDEX IF NOT EXISTS #{unique_keys.join('_')} " + "ON #{tbl_name} (#{unique_keys.join(',')})" database.execute query end end