diff options
Diffstat (limited to 'test/scr038/data/database_without_name.sql')
-rw-r--r-- | test/scr038/data/database_without_name.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/test/scr038/data/database_without_name.sql b/test/scr038/data/database_without_name.sql new file mode 100644 index 0000000..00134e5 --- /dev/null +++ b/test/scr038/data/database_without_name.sql @@ -0,0 +1,9 @@ +CREATE DATABASE; + +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)); |