collapse collapse
Menu
  • Home
  • Archives
    • * User Info
     
     
    Welcome, Guest. Please login or register.
    * Search

    * Board Stats
    • stats Total Members: 989
    • stats Total Posts: 18366
    • stats Total Topics: 2501
    • stats Total Categories: 7
    • stats Total Boards: 35
    • stats Most Online: 1144
    « previous next »
    Pages: [1]   Go Down

    Author Topic: database creations  (Read 3919 times)

    0 Members and 1 Guest are viewing this topic.

    Offline Nytridr

    • BeBot Expert
    • ****
    • Posts: 262
    • Karma: +0/-0
      • Rising Sun
    database creations
    « 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..
    Logged
    Co-Prez of Rising Sun RK1 (1st & only org I will ever belong to)

    Offline Khalem

    • BeBot Founder
    • Administrator
    • ********
    • Posts: 1169
    • Karma: +0/-0
      • http://www.ancarim.com
    Re: database creations
    « Reply #1 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.
    Logged
    BeBot Founder and Fixer Kingpin

    Offline Tsuyoi

    • BeBot User
    • **
    • Posts: 30
    • Karma: +0/-0
    • BigT
      • Adrenaline Rush Forums
    Re: database creations
    « Reply #2 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...
    Logged
    Pages: [1]   Go Up
    « previous next »
     
    * Recent Posts
    Com bot module by bitnykk
    [November 25, 2024, 05:36:11 pm ]
    0.8.x updates for AO by bitnykk
    [June 23, 2024, 03:19:47 pm ]
    0.8.x updates for AoC by bitnykk
    [June 23, 2024, 03:19:44 pm ]
    [AoC] special char for items module by bitnykk
    [February 09, 2024, 09:41:18 pm ]
    BeBot still alive & kicking ! by bitnykk
    [December 17, 2023, 12:58:44 am ]
    * Who's Online
    • Dot Guests: 142
    • Dot Hidden: 0
    • Dot Users: 0

    There aren't any users online.
    * Forum Staff
    bitnykk admin bitnykk
    Administrator
    Khalem admin Khalem
    Administrator
    WeZoN gmod WeZoN
    Global Moderator
    SimplePortal 2.3.7 © 2008-2024, SimplePortal