title: how to do "adc" INTEGER GENERATED BY DEFAULT IDENTITY in .sql file: adc is coloumn name
body: <p>how to do adc INTEGER GENERATED BY DEFAULT IDENTITY  in .sql file. adc is my coloumn name.
  i want this beacuse i am using  tag in spring which takes a script of schema which is of .sql extension. but my embedded database is in hsql. hsql does not support autoincrement so i have to write the create table statement in my .sql file like this : </p>
  
  <pre><code>CREATE TABLE personal (
      id INTEGER GENERATED BY DEFAULT IDENTITY,
      username varchar(45) NOT NULL,
      password varchar(45) NOT NULL,
      host_name varchar(45) DEFAULT NULL,
      port_number varchar(45) DEFAULT NULL,
      database_name varchar(45) DEFAULT NULL
  )
  </code></pre>
  
  <p>how i can do the above query in .sql file. please help me as soon as possible
  Thank you</p>