rvr-nextgen/database/migrations/structure/20230428_1826_community_main_currency.sql

5 lines
240 B
MySQL
Raw Permalink Normal View History

ALTER TABLE `communities`
ADD `main_currency_id` int(10) unsigned DEFAULT NULL,
ADD KEY `main_currency_id` (`main_currency_id`),
ADD CONSTRAINT `communities_main_currency_id` FOREIGN KEY (`main_currency_id`) REFERENCES `currencies` (`id`);