 
 
DROP TABLE REALMBASES;
DROP TABLE REALMSHIPS;
 
ALTER TABLE FORTRESSES DROP DEF_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	DEF_EDC_MPD double precision;

ALTER TABLE FORTRESSES DROP WEP_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	WEP_EDC_MPD double precision;

ALTER TABLE FORTRESSES DROP TBM_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	TBM_EDC_MPD double precision;

ALTER TABLE FORTRESSES DROP SEN_EDC1_MPD;
ALTER TABLE FORTRESSES ADD 	SEN_EDC1_MPD double precision;

ALTER TABLE FORTRESSES DROP SEN_EDC2_MPD;
ALTER TABLE FORTRESSES ADD 	SEN_EDC2_MPD double precision;

ALTER TABLE FORTRESSES DROP CLO_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	CLO_EDC_MPD double precision;

ALTER TABLE FORTRESSES DROP MEC_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	MEC_EDC_MPD double precision;

ALTER TABLE FORTRESSES DROP OTH_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	OTH_EDC_MPD double precision;

ALTER TABLE FORTRESSES DROP MAI_EDC_MPD;
ALTER TABLE FORTRESSES ADD 	MAI_EDC_MPD double precision;

ALTER TABLE FORTRESSES ADD  BUILDINGPTS bigint;
