Created and an empty DB and them used step_04_all_following_steps.sql. Then dumped the DDL to a file which will be called Step 4. Started clean again and used load_demo_data.sql. Then dumped the DDL to a file which will be called Demo. Next a diff of the two files was done. There are many key, foreign key, and constraint issues highlighted in the diff. This issue will only enumerate field and engine differences.

Below find for each named table what is found in Step 4 and the corresponding difference from Demo:

oh_medicaldsrstovkmov
STEP 4: MMV_WRD_ID_A char(3) DEFAULT '',
Demo: MMV_WRD_ID_A char(3) DEFAULT NULL,

oh_medicaldsrstockmovward
STEP 4: MMVN_WRD_ID_A char(3) NOT NULL DEFAULT '',
Demo: MMVN_WRD_ID_A char(3) NOT NULL,

oh_medicaldsrward
STEP 4: MDSRWRD_WRD_ID_A char(3) NOT NULL DEFAULT '',
Demo: MDSRWRD_WRD_ID_A char(3) NOT NULL,

oh_operationrow
STEP 4: OPER_ADMISSION_ID int(11) DEFAULT NULL,
OPER_OPD_ID int(11) DEFAULT NULL,
OPER_BILL_ID int(11) DEFAULT NULL,
Demo: OPER_ADMISSION_ID int(11) DEFAULT 0,
OPER_OPD_ID int(11) DEFAULT 0,
OPER_BILL_ID int(11) DEFAULT 0,

oh_visits
STEP 4: VST_WRD_ID_A char(3) DEFAULT '',
Demo: VST_WRD_ID_A char(3) DEFAULT NULL,

oh_ward
STEP 4: WRD_ID_A char(3) NOT NULL DEFAULT '',
Demo: WRD_ID_A char(3) NOT NULL,