---------------Authorization
update flyway_schema_history set success=true where installed_rank=109;
update flyway_schema_history set success=true where installed_rank=50;
update flyway_schema_history set success=true where installed_rank=56;
update flyway_schema_history set success=true where installed_rank=25;

---------------------------



select * from flyway_schema_history;
drop database permissions; 
CREATE SCHEMA  permissions;

select * from Action where name='io.netfoundry.test';
select * from Resource where name='nfrn:tests:*:foos:*';
select * from role where name='Foo Admin';
select * from resourcetype where name='Test Type';

select r.* from resourcetype r, domain d where  r.domainId=d.id and d.code='io.netfoundry.test';

select * from domain where code='io.netfoundry.test';

delete from role  where name='Foo Admin';
delete from Action  where name='tests:create-foo';
delete from Resource  where name='nfrn:tests:*:foos:*';
delete from Domain  where code='io.netfoundry.test';
delete from resourcetype where name='Test Type';
--remove foreign key check while deleting
SET foreign_key_checks = 0;

--------------------Identity
CREATE SCHEMA IF NOT EXISTS `identity`;


-----------------------------------Billing
update flyway_schema_history set success=true where installed_rank=23;
update flyway_schema_history set success=true where installed_rank=24;
update flyway_schema_history set success=true where installed_rank=56;
update flyway_schema_history set success=true where installed_rank=25;


--drop database billing; 

CREATE SCHEMA  billing;




select * from flyway_schema_history;

CREATE TABLE `VersionNumberTableMeta` (
  `tableName` varchar(128) NOT NULL,
  `version` bigint NOT NULL,
  PRIMARY KEY (`tableName`)
);

select * from UserIdentity;
INSERT INTO UserIdentity (id, tenantId, firstName, lastName, email, active) VALUES ('1','2','test','testlstname','no-reply@netfoundry.io',1);

--9fe3ff17-1ae5-47c4-b081-404b160536be
--INSERT INTO UserIdentity (id, tenantId, firstName, lastName, email, active) VALUES ('fa0bf14e-3d60-11ed-b878-0242ac120002','2','test','testlstname','no-reply@netfoundry.io',1);





------------------------------------------------------
--DATA
--------------------------------------------------------

CREATE SCHEMA nfapidb;
-- the Compose file grants privs on the default schema, but some services create additional schemas e.g.
--  "flowable" for Healing Service. This ensures that the common user localuser has all privileges on all future schemas.
GRANT ALL PRIVILEGES ON *.* TO 'localuser'@'%' WITH GRANT OPTION;


--select HEX(id),HEX(geo_region_id) from countries where HEX(geo_region_id)='d791b158c7dc4fce9781c1d5b29fb3f3';
select * from countries where HEX(geo_region_id)='d791b158c7dc4fce9781c1d5b29fb3f3';

select * from geo_regions where HEX(id)='d791b158c7dc4fce9781c1d5b29fb3f3';

select HEX(id),HEX(geo_region_id), countries.* from countries where HEX(id)='905B3354C3AB4AB0A10AF6D1A63D35C6';

select count(*) from data_centers;

--08785C94BB2649DDA43C93E6145BB7F4

select * from geo_regions where HEX(ID)='08785C94BB2649DDA43C93E6145BB7F4';
--Canada East