title: how to use foreign-keys with hsql create table?
body: <p>could someone explain me how to use foreign keys in hsql?
  I would like it in an create table, but working alter table is also ok.
  I am working without tools, just in eclipse
  whats wrong with the hsql code?</p>
  
  <pre><code>CREATE TABLE user(
    t_id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1, INCREMENT   BY   1) PRIMARY KEY,
    name VARCHAR(30),
    lastname VARCHAR(30),
    email  VARCHAR(30),  
    --FOREIGN KEY (b_id) REFERENCES bookingnumber(b_id)
  );
  
  CREATE TABLE bookingnumber (
    b_id INTEGER PRIMARY KEY
  );
  
  ALTER TABLE user
    ADD FOREIGN KEY (fk_b_id) REFERENCES bookingnumber(b_id);
  </code></pre>