added API doc 
remove db alter script
fix status data type