diff options
Diffstat (limited to 'test/scr038/data/two_same_databases.sql')
-rw-r--r-- | test/scr038/data/two_same_databases.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/test/scr038/data/two_same_databases.sql b/test/scr038/data/two_same_databases.sql new file mode 100644 index 0000000..549a9dd --- /dev/null +++ b/test/scr038/data/two_same_databases.sql @@ -0,0 +1,11 @@ +CREATE DATABASE numismatics; + +CREATE DATABASE numismatics; + +CREATE TABLE coin (cid INT(8) PRIMARY KEY, + unit VARCHAR(20), + value NUMERIC(8,2), -- just a comment here; + mintage_year INT(8), + mint_id INT(8), + CONSTRAINT mint_id_fk FOREIGN KEY(mint_id) + REFERENCES mint(mid)); |