(Brion Vibber vibber@aludra.usc.edu): On Fri, 28 Mar 2003, Thomas Corell wrote:
a closer look in the maintenance directory from cvs esp. BuildTables.[inc|sql] showed differencs between those two files. (e.g. table user, user_touched).
buildTables.inc is currently canonical. It consists of a bunch of SQL statements which are executed in turn, which strikes me as kind of silly.
I intended that buildTables.sql replace it, but it hasn't been kept up to date and isn't yet used by anything.
Originally it was the .sql, but I changed it to PHP code because proper initialization of the database requires filling in some data from variables defined in LocalSettings.php. The only reasonable way to do that is with PHP code.
Of course, we could change the PHP code to read all the CREATE TABLE/CREATE INDEX type statements from a .sql file.