We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

creating table mysql

Hello, ladies and gentlemen. Can you please tell me if it is possible to create tables in the database using a phalcon? When creating a user, you need to create several tables. Is it expedient if the users have a lot of personal data, settings, etc.? Then in models

public function getSource() { return 'user12345_table_name'; }

If you have to modify your database for each new user, I think you need to re-examine your database scruture and normalize your data. Each user should be a row, not a separate table.

With that said, I don't think you can create tables with PHQL. There is a way to access the PDO connection though, so you could use that to run raw SQL.