1 files changed, 25 insertions, 0 deletions
diff --git a/activerecord/test/schema/sqlite_specific_schema.rb b/activerecord/test/schema/sqlite_specific_schema.rb
new file mode 100644
index 0000000000..ea05b35fe0
--- /dev/null
+++ b/activerecord/test/schema/sqlite_specific_schema.rb
@@ -0,0 +1,25 @@
+ActiveRecord::Schema.define do
+  # For sqlite 3.1.0+, make a table with a autoincrement column
+  if supports_autoincrement?
+    create_table :table_with_autoincrement, :force => true do |t|
+      t.column :name, :string
+    end
+  end
+
+  execute "DROP TABLE fk_test_has_fk" rescue nil
+  execute "DROP TABLE fk_test_has_pk" rescue nil
+  execute <<_SQL
+  CREATE TABLE 'fk_test_has_pk' (
+    'id' INTEGER NOT NULL PRIMARY KEY
+  );
+_SQL
+
+  execute <<_SQL
+  CREATE TABLE 'fk_test_has_fk' (
+    'id'    INTEGER NOT NULL PRIMARY KEY,
+    'fk_id' INTEGER NOT NULL,
+
+    FOREIGN KEY ('fk_id') REFERENCES 'fk_test_has_pk'('id')
+  );
+_SQL
+end
+\ No newline at end of file