diff options
author | Zhang Qiang <qiang.z.zhang@intel.com> | 2012-05-29 12:22:00 +0800 |
---|---|---|
committer | Zhang Qiang <qiang.z.zhang@intel.com> | 2012-05-29 12:22:00 +0800 |
commit | 02f0634ac29e19c68279e5544cac963e7f1203b8 (patch) | |
tree | b983472f94ef063cedf866d8ecfb55939171779d /test/scr038/data/database_without_name.sql | |
parent | e776056ea09ba0b6d9505ced6913c9190a12d632 (diff) | |
download | db4-2.0alpha.tar.gz db4-2.0alpha.tar.bz2 db4-2.0alpha.zip |
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)); |