eowhadi commented on a change in pull request #10: Migrate customer service from MariaDB to PostgreSQL URL: https://github.com/apache/fineract-cn-customer/pull/10#discussion_r298295211
########## File path: service/src/main/resources/db/migrations/postgresql/V4__identification_card_scans.sql ########## @@ -17,17 +17,7 @@ -- under the License. -- -CREATE TABLE maat_identification_card_scans ( - id BIGINT NOT NULL AUTO_INCREMENT, - identifier VARCHAR(32) NOT NULL, - description VARCHAR(4096) NOT NULL, - identification_card_id BIGINT NOT NULL, - content_type VARCHAR(256) NOT NULL, - size BIGINT NOT NULL, - image MEDIUMBLOB NOT NULL, - created_on TIMESTAMP(3) NOT NULL, - created_by VARCHAR(32) NOT NULL, - CONSTRAINT maat_ident_card_scans_pk PRIMARY KEY (id), - CONSTRAINT maat_ident_card_scans_ident_uq UNIQUE (identifier, identification_card_id), - CONSTRAINT maat_ident_card_scans_fk FOREIGN KEY (identification_card_id) REFERENCES maat_identification_cards (id) -); \ No newline at end of file +CREATE TABLE maat_identification_card_scans ( id BIGINT NOT NULL, identifier VARCHAR(32) NOT NULL, description VARCHAR(4096) NOT NULL, identification_card_id BIGINT NOT NULL, content_type VARCHAR(256) NOT NULL, size BIGINT NOT NULL, image BYTEA NOT NULL, created_on TIMESTAMP(3) NOT NULL, created_by VARCHAR(32) NOT NULL, Review comment: I wonder why with mariadb id is auto increment, while it is not with postgresql ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
