sap-archive / cloud-activerecord-maxdb-adapter Goto Github PK

add_index :memberships, [:user_id, :group_id], :unique => true

An error has occurred, all later migrations canceled: ActiveRecord::JDBCError: [-5015] (at 39): Missing keyword:ON: CREATE UNIQUE INDEX idx_rmemberships_[:user_id, :group_id] ON rmemberships([:user_id, :group_id]) from arjdbc/jdbc/RubyJdbcConnection.java:195:in `execute' from /usr/sap/ljs/webapps/nwc_team_calendar/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.2.5/lib/arjdbc/jdbc/adapter.rb:217:in `_execute' 

ActiveRecord::JDBCError: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "SERIAL" at line 1, column 50.: CREATE TABLE admins (id INTEGER NOT NULL DEFAULT SERIAL PRIMARY KEY, email VARCHAR(255) DEFAULT '' NOT NULL, encrypted_password VARCHAR(255) DEFAULT '' NOT NULL, reset_password_token VARCHAR(255), reset_password_sent_at timestamp, remember_created_at timestamp, sign_in_count INTEGER DEFAULT 0 NOT NULL, current_sign_in_at timestamp, last_sign_in_at timestamp, current_sign_in_ip VARCHAR(255), last_sign_in_ip VARCHAR(255), created_at timestamp, updated_at timestamp)