diff options
| author | Jeremy Kemper <jeremy@bitsweat.net> | 2007-01-15 00:34:43 +0000 |
|---|---|---|
| committer | Jeremy Kemper <jeremy@bitsweat.net> | 2007-01-15 00:34:43 +0000 |
| commit | e3103441114b1c5e7b67b71efa9c0b44e03645e6 (patch) | |
| tree | 54bfe03ea0ef7637367bfb04e0200f939d9594cd /activerecord/test/fixtures/db_definitions | |
| parent | 9ccb12a3dda123942def21834eedb761299f67b9 (diff) | |
| download | rails-e3103441114b1c5e7b67b71efa9c0b44e03645e6.tar.gz rails-e3103441114b1c5e7b67b71efa9c0b44e03645e6.tar.bz2 rails-e3103441114b1c5e7b67b71efa9c0b44e03645e6.zip | |
Oracle: create_table takes a :sequence_name option to override the 'tablename_seq' default. Closes #7000.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5933 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
| -rw-r--r-- | activerecord/test/fixtures/db_definitions/oracle.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/oracle.sql b/activerecord/test/fixtures/db_definitions/oracle.sql index ccf472c905..869c59fb75 100644 --- a/activerecord/test/fixtures/db_definitions/oracle.sql +++ b/activerecord/test/fixtures/db_definitions/oracle.sql @@ -137,6 +137,23 @@ create table booleantests ( ); create sequence booleantests_seq minvalue 10000; +CREATE TABLE defaults ( + id integer not null, + modified_date date default sysdate, + modified_date_function date default sysdate, + fixed_date date default to_date('2004-01-01', 'YYYY-MM-DD'), + modified_time date default sysdate, + modified_time_function date default sysdate, + fixed_time date default TO_DATE('2004-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), + char1 varchar2(1) default 'Y', + char2 varchar2(50) default 'a varchar field', + char3 clob default 'a text field', + positive_integer integer default 1, + negative_integer integer default -1, + decimal_number number(3,2) default 2.78 +); +create sequence defaults_seq minvalue 10000; + create table auto_id_tests ( auto_id integer not null, value integer default null, |