diff options
Diffstat (limited to 'db-4.8.30/test/scr038/data/two_same_name_indexes.sql')
| -rw-r--r-- | db-4.8.30/test/scr038/data/two_same_name_indexes.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/db-4.8.30/test/scr038/data/two_same_name_indexes.sql b/db-4.8.30/test/scr038/data/two_same_name_indexes.sql new file mode 100644 index 0000000..533bb94 --- /dev/null +++ b/db-4.8.30/test/scr038/data/two_same_name_indexes.sql @@ -0,0 +1,11 @@ +CREATE DATABASE numismatics; + +CREATE TABLE coin (cid INT(8) PRIMARY KEY, + unit VARCHAR(20), + value NUMERIC(8,2), + mintage_year INT(8)); + +CREATE INDEX unit_index ON coin(unit); + +CREATE INDEX unit_index1 ON coin(unit); + |