1 echo create index test;
2 create table t1 (f1 integer not null, f2 integer not null,
3 f3 int not null, f4 int not null,
4 f5 int not null, f6 int not null);
5 create index idx1 on t1 (f1);
6 create index idx2 on t1 (f2) UNIQUE;
7 create index idx3 on t1 (f3) PRIMARY;
8 create index idx4 on t1 (f4) HASH PRIMARY;
9 create index idx5 on t1 (f5) TREE;
10 create index idx6 on t1 (f6) TREE PRIMARY;