Anonymous avatar Anonymous committed d3e2027

Updated hsqldb table script ENCUESTAME-502

Comments (0)

Files changed (1)

encuestame-business/src/main/resources/org/encuestame/business/sqlscripts/hsqldb/install/tables.sql

 create table userAccount_permission (sec_id_secondary bigint not null, sec_id_permission bigint not null, primary key (sec_id_permission, sec_id_secondary))
 create table userAccount_project (sec_id_secondary bigint not null, cat_id_project bigint not null, primary key (cat_id_project, sec_id_secondary))
 create table survey_temporal_result (IdTempResult bigint generated by default as identity (start with 1), txtResponse varchar(255), hash varchar(255) not null, answer_q_answer_id bigint, question_qid bigint, survey_sid bigint, primary key (IdTempResult), unique (hash), unique (IdTempResult))
-create table question_preferences (preferenceId bigint generated by default as identity (start with 1), preference varchar(255), value varchar(255), question_qid bigint, primary key (preferenceId), unique (preferenceId))
+create table question_preferences (preferenceId bigint generated by default as identity (start with 1), preference varchar(255), preference_value varchar(255), question_qid bigint, primary key (preferenceId), unique (preferenceId))
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.