modified schema sql and split bootstrap into canned and not canned