FedEMIS Bootstrap Work

[Ghislain Hachey]

Got most of the core lookups data done and schools and enrolment related data cleaned up and imported. Now trying to get the basics working with the latest pineapples code base.

[Ghislain Hachey]

OK. So I need a few minor changes to the schema for FSM lookup data. Here's what I did locally on my FEDEMIS-TEST DB.

ALTER TABLE SchoolTypeGroup ALTER COLUMN codeCode NVARCHAR(10) NOT NULL; 
ALTER TABLE SchoolTypeGroup ALTER COLUMN codeDescription NVARCHAR(200) NOT NULL;
ALTER TABLE SchoolTypes ALTER COLUMN stDescription NVARCHAR(200) NOT NULL; 
ALTER TABLE SchoolTypes ALTER COLUMN stTypeGrp NVARCHAR(10) NOT NULL;
ALTER TABLE Schools ALTER COLUMN schName NVARCHAR(200) NOT NULL;

I already managed to sync my local DB to what seems to be the latest on VCNSQL90.webhost4life.com and I even got the new build warehouse feature working with the data set I've cleaned up from FSM. All showing in the AtAGlance fedemis custom template, sweet! Still some things a bit rough but definitely a good start.

Should I just push my minor schema changes above using SQLDelta?

GH

[Ghislain Hachey]

feat(fedemis): initial adaption

Closes #218

→ <<cset d59049b2f066>>