As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
I'm doing a manual deployment, but I can't find the script for creating the database, where can I find it? The version I'm deploying is 6.2.
You need to create the database and the user in Postgres.
Something like this: https://github.com/loftuxab/alfresco-ubuntu-install/blob/master/scripts/postgresql.sh#L40
After that, when Alfresco starts, all the tables and database objects are created during the application bootstrap.