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