5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# File 'lib/dbgeni/initializers/sqlite.rb', line 5
def self.initialize(db_connection, config)
raise DBGeni::DatabaseAlreadyInitialized if self.initialized?(db_connection, config)
db_connection.execute("create table #{config.db_table}
(
sequence_or_hash varchar2(100) not null,
migration_name varchar2(4000) not null,
migration_type varchar2(20) not null,
migration_state varchar2(20) not null,
start_dtm date,
completed_dtm date
)")
db_connection.execute("create unique index #{config.db_table}_uk1 on #{config.db_table} (sequence_or_hash, migration_name, migration_type)")
db_connection.execute("create index #{config.db_table}_idx2 on #{config.db_table} (migration_name)")
end
|