--- /dev/null
+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