Skip to content

Instantly share code, notes, and snippets.

@vishwasbabu
Last active March 2, 2018 10:12
Show Gist options
  • Select an option

  • Save vishwasbabu/dc105b6a9450cff8ff1f to your computer and use it in GitHub Desktop.

Select an option

Save vishwasbabu/dc105b6a9450cff8ff1f to your computer and use it in GitHub Desktop.
Create schema_version in `mifosplatform-tenants`
mysql -uroot -pmysql
use `mifosplatform-tenants`;
CREATE TABLE `schema_version` (
`version_rank` int(11) NOT NULL,
`installed_rank` int(11) NOT NULL,
`version` varchar(50) NOT NULL,
`description` varchar(200) NOT NULL,
`type` varchar(20) NOT NULL,
`script` varchar(1000) NOT NULL,
`checksum` int(11) DEFAULT NULL,
`installed_by` varchar(100) NOT NULL,
`installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`execution_time` int(11) NOT NULL,
`success` tinyint(1) NOT NULL,
PRIMARY KEY (`version`),
KEY `schema_version_vr_idx` (`version_rank`),
KEY `schema_version_ir_idx` (`installed_rank`),
KEY `schema_version_s_idx` (`success`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `schema_version` (`version_rank`, `installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`, `installed_on`, `execution_time`, `success`) VALUES
(1, 1, '1', 'mifos-platform-shared-tenants', 'SQL', 'V1__mifos-platform-shared-tenants.sql', -486745552, 'root', '2014-10-12 22:13:50', 896, 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment