BeBot - An Anarchy Online and Age Of Conan chat automaton

Development => Coding and development discussion => Topic started by: Nytridr on March 10, 2007, 11:46:18 pm

Title: database creations
Post by: Nytridr on March 10, 2007, 11:46:18 pm

I would like to see one file in the core folder that handles all database creations....

then each module anywhere else can check to see if the tables are there.. if it isnt then maybe find a way to append the database to the creation file.. there are times I get tired of tracking down where the tables are created just to change the length of a field.. like with the guild field.. about 40 is about right for that field.. not sure what the max is for the FC field but varchar(40) seems to work for the differnt orgs in the alliance I am in.. there are a few other minor things but I can not remember what they are..

but having a centralized place to look for table creations would be a nice convinces..

Title: Re: database creations
Post by: Khalem on March 11, 2007, 02:03:24 am

It's on the list of things we want to do. But a low priority atm.

Basically i'm thinking of having a schema table to track schema versions, a script that runs on bot launch that checks schema version and if neccecary updates the schema.
If you have ever dealt with Ruby on Rails database migration process, this should be rather familiar.

Title: Re: database creations
Post by: Tsuyoi on March 12, 2007, 02:19:17 pm

Quote from: Khalem on March 11, 2007, 02:03:24 am

If you have ever dealt with Ruby on Rails database migration process, this should be rather familiar.

That demo video blew my mind...