aboutsummaryrefslogtreecommitdiffstats
path: root/spec/schemas/sqlite3_schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'spec/schemas/sqlite3_schema.rb')
-rw-r--r--spec/schemas/sqlite3_schema.rb7
1 files changed, 7 insertions, 0 deletions
diff --git a/spec/schemas/sqlite3_schema.rb b/spec/schemas/sqlite3_schema.rb
index 94d224520e..9dbb62428e 100644
--- a/spec/schemas/sqlite3_schema.rb
+++ b/spec/schemas/sqlite3_schema.rb
@@ -11,6 +11,13 @@ sql = <<-SQL
user_id INTEGER NOT NULL,
camera_id INTEGER NOT NULL
);
+ DROP TABLE IF EXISTS developers;
+ CREATE TABLE developers (
+ id INTEGER NOT NULL PRIMARY KEY,
+ name VARCHAR(255) NOT NULL,
+ salary INTEGER NOT NULL,
+ department VARCHAR(255) NOT NULL
+ );
SQL
sql.split(/;/).select(&:present?).each do |sql_statement|