aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/schema/oracle_specific_schema.rb
blob: 2d87f34625158634301540e7d6101c6e4a6fa30c (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
ActiveRecord::Schema.define do

  execute "drop table test_oracle_defaults" rescue nil
  execute "drop sequence test_oracle_defaults_seq" rescue nil

  execute <<-SQL
create table test_oracle_defaults (
  id integer not null primary key,
  test_char char(1) default 'X' not null,
  test_string varchar2(20) default 'hello' not null,
  test_int integer default 3 not null
)
  SQL

  execute <<-SQL
create sequence test_oracle_defaults_seq minvalue 10000
  SQL

end