The schema xml file (<module>/schemas/<schema-name>.xml) is metadata about the database tables for things like custom labels, URLs, buttons, and lookups. It can be created for you automatically, but you will most likely need to customize the xml to add labels and buttons. As you write sql upgrade scripts, you'll need to manually keep the schema xml file in sync with the changes you make to the underlying database tables.