Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Add at the top of the localDB.script file the content of the following example in order to create the sample HSQL database.

Note

Make sure JBoss is not running at the time of modifying this file.

CREATE MEMORY TABLE CUSTOMER(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(45),BIRTHDATE DATE,SSS_NO VARCHAR(25),ADDRESS VARCHAR(60),ANNUAL_SALARY DOUBLE,LOAN_AMOUNT DOUBLE)

...