use liquidnet_adam;
-- >>------------------------------------------------------------------------------------
insert into liquidnet_adam.adam_role
values (null, 'Administrator', 1, 1, 1, 'init by zhanggb', sysdate(), null, null, null);
insert into liquidnet_adam.adam_role
values (null, 'Executor', 1, 1, 1, 'init by zhanggb', sysdate(), null, null, null);
insert into liquidnet_adam.adam_role
values (null, 'Viewer', 1, 1, 1, 'init by zhanggb', sysdate(), null, null, null);
-- >>------------------------------------------------------------------------------------
insert into liquidnet_adam.adam_role_permission
values (1, '096D7A14', 1, 2),
       (1, '3E669FC2', 1, 2),
       (1, '4F15121D', 1, 2),
       (1, '6FA22359', 1, 2),
       (1, '773E1BDB', 1, 2),
       (1, '7D53AE2D', 1, 2),
       (1, '803598E3', 1, 2),
       (1, 'A040E8E8', 1, 2),
       (1, 'A06B0297', 1, 2),
       (1, 'A1059625', 1, 2),
       (1, 'AEE5E22D', 1, 2),
       (1, 'AF4FF85A', 1, 2),
       (1, 'B235B1CC', 1, 2),
       (1, 'BDCB8E7F', 1, 2),
       (1, 'FE3FC5E2', 1, 2),
       (2, '096D7A14', 2, 2),
       (2, '3E669FC2', 2, 2),
       (2, '4F15121D', 1, 2),
       (2, '6FA22359', 1, 2),
       (2, '773E1BDB', 1, 2),
       (2, '7D53AE2D', 1, 1),
       (2, '803598E3', 1, 1),
       (2, 'A040E8E8', 1, 1),
       (2, 'A06B0297', 1, 1),
       (2, 'A1059625', 1, 1),
       (2, 'AEE5E22D', 0, 1),
       (2, 'AF4FF85A', 0, 1),
       (2, 'B235B1CC', 2, 2),
       (2, 'BDCB8E7F', 2, 2),
       (2, 'FE3FC5E2', 1, 2),
       (3, '096D7A14', 2, 2),
       (3, '3E669FC2', 2, 2),
       (3, '4F15121D', 1, 2),
       (3, '6FA22359', 1, 2),
       (3, '773E1BDB', 1, 2),
       (3, '7D53AE2D', 2, 2),
       (3, '803598E3', 2, 2),
       (3, 'A040E8E8', 2, 2),
       (3, 'A06B0297', 0, 1),
       (3, 'A1059625', 0, 1),
       (3, 'AEE5E22D', 2, 2),
       (3, 'AF4FF85A', 0, 1),
       (3, 'B235B1CC', 2, 2),
       (3, 'BDCB8E7F', 2, 2),
       (3, 'FE3FC5E2', 1, 2);
-- >>------------------------------------------------------------------------------------




INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'AL', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'AK', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'AZ', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'AR', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'CA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'CO', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'CT', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'DE', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'FL', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'GA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'HI', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'ID', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'IL', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'IN', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'IA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'KS', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'KY', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'LA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'ME', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MD', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MI', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MN', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MS', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MO', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'MT', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NE', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NV', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NH', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NJ', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NM', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NY', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'NC', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'ND', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'OH', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'OK', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'OR', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'PA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'RI', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'SC', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'SD', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'TN', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'TX', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'UT', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'VT', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'VA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'WA', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'WV', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'WI', NULL, NULL);
INSERT INTO `liquidnet_adam`.`adam_sys_country_province`(`country_code`, `province_code`, `create_time`, `update_time`) VALUES ('US', 'WY', NULL, NULL);
-- >>------------------------------------------------------------------------------------
INSERT INTO `liquidnet_adam`.`adam_sys_country`( `code`, `name`, `phone_code`, `currency_name`, `currency_alphabetic_code`, `currency_numeric_code`, `currency_minor_unit`) VALUES ('CN', 'China', '86', 'Yuan Renminbi', 'CNY', '156', '2' );
INSERT INTO `liquidnet_adam`.`adam_sys_country`( `code`, `name`, `phone_code`, `currency_name`, `currency_alphabetic_code`, `currency_numeric_code`, `currency_minor_unit`) VALUES ('US', 'United States', '1', 'US Dollar', 'USD', '840', '2');
INSERT INTO `liquidnet_adam`.`adam_sys_country`( `code`, `name`, `phone_code`, `currency_name`, `currency_alphabetic_code`, `currency_numeric_code`, `currency_minor_unit`) VALUES ('HK', 'Hong Kong', '852', 'Hong Kong Dollar', 'HKD', '344', '2');
INSERT INTO `liquidnet_adam`.`adam_sys_country`( `code`, `name`, `phone_code`, `currency_name`, `currency_alphabetic_code`, `currency_numeric_code`, `currency_minor_unit`) VALUES ('TH', 'Thailand', '66', 'Baht', 'THB', '764', '2');
INSERT INTO `liquidnet_adam`.`adam_sys_country`( `code`, `name`, `phone_code`, `currency_name`, `currency_alphabetic_code`, `currency_numeric_code`, `currency_minor_unit`) VALUES ('SG', 'Singapore', '65', 'Singapore Dollar', 'SGD', '702', '2');
INSERT INTO `liquidnet_adam`.`adam_sys_country`( `code`, `name`, `phone_code`, `currency_name`, `currency_alphabetic_code`, `currency_numeric_code`, `currency_minor_unit`) VALUES ('ID', 'Indonesia', '62', 'Rupiah', 'IDR', '360', '2');


-- >>------------------------------------------------------------------------------------
INSERT INTO `liquidnet_adam`.`sys_sequence`(`seq_name`, `current_val`, `increment`) VALUES ('SEQ_TRANSACTION_NUMBER', 1, 1);