db-4.8.30/test/scr038/data/two_indexes_on_same_column.sql


1
2
3
4
5
6
7
8
9
10

CREATE DATABASE numismatics;  

CREATE TABLE table1 (att_int INT(8) PRIMARY KEY,
			att_char CHAR(2));

CREATE INDEX int_index ON table1(att_int);

CREATE INDEX int_index_1 ON table1(att_int);