amir abbas wrote:ok i found two schema file in install folder
the first one will make all the tables abd the second one will add default values to
am i right ?
Yes you are
A bit more than just the config default setupe, the default cat, forum and post as well.
amir abbas wrote:i think i must add all off sql queries at the end of mysql_schema.sql file
but there is a problem
some mods have a db_update.php file
how can i extract the sql queries from these files ?
You are welcome
So that's why I told you to start working with a full db backup of a sample install (without any more post than the demo one but fully working, once all of your premod code is final) of your premod, so that all of the sql you'd have manually or through a php script will be added in it.
Then you'd just have to copy and paste (you have to follow exactly the way it is written down in the phpBB install files so you might have to change small things as well; with phpmyadmin you can end up with "`" to protect fields, if so get rid of those) code from the db backup to the phpBB sql install files.
You'll face several cases :
A mod added a table, then, you should find the sql definition of it in the db backup followed by the insert for the default settings. Just paste it all in the mysql_schema.sql. You can paste the inserts in mysql_basic.sql, but I am not sure this is really required, it could work as well if you just paste all of it (table definition + inserts) in mysql_schema.sql.
A mod modified a phpBB table, then, copy and overwrite this table definition from the db backupt to the mysql_schema.sql, and do the same with the eventual associated inserts in mysql_basic.sql.
All other non modded nor added phpBB table should be left as is in the original phpBB sql install files.
Quite simple in the end