Hello!
I need use a compound primary key. The script to create table is:
-------------------------------------------------
CREATE TABLE tablasalidas
(matricula VARCHAR(10),
horario VARCHAR(5),
parada VARCHAR(20),
PRIMARY KEY(matricula,horario)
);
-------------------------------------------------
I think the script is correct, but Hypersonic creates normal primary key. What I have to do to create a compound primary key with Hypersonic?
(If I use the HSQL DB Manager, in the "Indices" field I only see matricula as primary key)