summaryrefslogtreecommitdiff
path: root/db-4.8.30/test/scr038/data/wrong_create_sequence.sql
blob: c1664605a47a2e5f5651d54fe0af3efcbe7c2db1 (plain)
1
2
3
4
5
6
7
8
9
10

CREATE INDEX unit_index ON coin(unit);

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));

CREATE DATABASE numismatics;