how can i make a db update file

[AmirAbbas]

i want to make premodded phpbb
i have some question

it this time i've installed over 20 mod
some of this mod has a database update file and some of them has a SQL queries

i want to make a one install file for all standard phpbb table and for all of my mods
i want to install another template as a default template instead of phpbb.

i found a script that is useful for make DB_update files
you must give the sql queries to this script and then this script will make a db_update for you
but i couldn't find a tool for extract sql queries from db update files

have you any suggestion ?
thank you

[dcz]

Well, if you want to make your install as compatible as phpBB itself, you should edit the sql schemas located in the original phpBB2/install/schemas.

You would just have to properly add the table definitions and default settings for mod's tables and to mod phpBB table settings for them to be directly created with the modified settings.

Should not be that hard, open the files up, and open as well a db backup of your moded forum, you'll find in there what could be the proper alteration for phpBB tables. Concerning new tables, the sql provided in the mod file should suffice.

You should at least be able to create an auto install for mysql without suffering too much

[AmirAbbas]

ok i found two schema file in install folder

1- mysql_schema.sql
2- basic_schema.sql

the first one will make all the tables abd the second one will add default values to
config table
am i right ?

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 ?

thanks dcz

[dcz]

[AmirAbbas]

thank you