Updated install.sql with complete api_methods based on existing api controllers.