Hi, After I Run->Create Database, It is shown this message:
[11:53:23.775] Creating database jdbc:hsqldb:hsql://localhost/surveys
:app-core:assembleDbScripts
:app-core:createDb
Using database URL: jdbc:hsqldb:hsql://localhost/surveys, user: sa
Executing SQL: drop schema public cascade;
Using database URL: jdbc:hsqldb:hsql://localhost/surveys, user: sa
Executing SQL script: C:\Users\jorge\studio-projects\surveys\modules\core\build\db\10-cuba\init\hsql\create-db.sql
Executing SQL script: C:\Users\jorge\studio-projects\surveys\modules\core\build\db\50-surveys\init\hsql\10.create-db.sql
Failed to execute:
-- end SURVEYS_HOTELS
-- begin SURVEYS_SURVEYS
create table SURVEYS_SURVEYS (
ID varchar(36) not null,
VERSION integer not null,
CREATE_TS timestamp,
CREATED_BY varchar(50),
UPDATE_TS timestamp,
UPDATED_BY varchar(50),
DELETE_TS timestamp,
DELETED_BY varchar(50),
--
FOLIO integer,
NAME varchar(30),
LASTNAME varchar(30),
ADDRESS varchar(40),
COUNTRY_ID varchar(36),
STATE_ID varchar(36),
ZIPCODE varchar(10),
EMAIL varchar(0),
YOUROCCUPATION_ID varchar(36),
SPOUSEOCCUPATION_ID varchar(36),
INCOME_ID varchar(36),
DATE_ date,
PHONE varchar(18),
HOTEL_ID varchar(36),
YOURHOWLONG integer,
YOURAGE integer,
SPOUSEHOWLONG integer,
SPOUSEAGE integer,
GOLF boolean,
--
primary key (ID)
) because: precisión o escala fuera de rango
:app-core:createDb FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':app-core:createDb'.
> java.sql.SQLSyntaxErrorException: precisión o escala fuera de rango
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output.
BUILD FAILED
Total time: 12.122 secs
[11:53:37.178] Task 'createDb' failed
java.sql.SQLSyntaxErrorException: precisión o escala fuera de rango
Thank you
Regards.
Jorge Soto