diff options
| author | jakefeasel <jfeasel@gmail.com> | 2012-10-16 22:24:50 -0700 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2012-10-16 22:24:50 -0700 |
| commit | 692466e74bef40f3f1440e369803a28c87ee9942 (patch) | |
| tree | d31fdf9970bc72a6a3828b63df3d3b5b0d34c6bc | |
| parent | 4628031dbe3523621dc4db56ca81a7654fdea3eb (diff) | |
| download | sqlfiddle-692466e74bef40f3f1440e369803a28c87ee9942.zip sqlfiddle-692466e74bef40f3f1440e369803a28c87ee9942.tar.gz sqlfiddle-692466e74bef40f3f1440e369803a28c87ee9942.tar.bz2 | |
Fix primary key for query_sets
| -rw-r--r-- | src/main/webapp/db/h2/01_schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/main/webapp/db/h2/01_schema.sql b/src/main/webapp/db/h2/01_schema.sql index 1637ad9..3c8dceb 100644 --- a/src/main/webapp/db/h2/01_schema.sql +++ b/src/main/webapp/db/h2/01_schema.sql @@ -43,7 +43,7 @@ CREATE TABLE queries ( DROP table IF EXISTS query_sets; CREATE TABLE query_sets ( - id integer NOT NULL AUTO_INCREMENT PRIMARY KEY, + id integer NOT NULL, query_id integer NOT NULL, schema_def_id integer NOT NULL, row_count integer, @@ -52,7 +52,8 @@ CREATE TABLE query_sets ( sql text, execution_plan text, error_message text, - columns_list varchar(500) + columns_list varchar(500), + PRIMARY KEY(id, schema_def_id, query_id) ); DROP table IF EXISTS schema_defs; |