A Project for Chronicle 4 based on L2JServer.


    Auto increment primary keys

    Share

    Neeeeeeeeeel.-

    Posts : 44
    Join date : 2014-01-04
    Location : Argentina

    Auto increment primary keys

    Post  Neeeeeeeeeel.- on 5th January 2014, 02:38

    Just delete this please, now I saw the random int primary key column on characters table. I advice to put an int primary key on accounts table but is not that important because it's not called every time as characters table.
    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: Auto increment primary keys

    Post  DnR on 7th January 2014, 17:58

    Table characters doesn't have an auto-increment column.
    The primary key is the object id of a character.
    I don't know what's wrong with that.

    Neeeeeeeeeel.-

    Posts : 44
    Join date : 2014-01-04
    Location : Argentina

    Re: Auto increment primary keys

    Post  Neeeeeeeeeel.- on 8th January 2014, 07:02

    I posted before I saw the obj_id column because first I saw that account queries were made by account name so when I saw in characters that the first column wasn't an int primary key I made the thread, then I edited my post. Just delete the thread, sorry.

    Sponsored content

    Re: Auto increment primary keys

    Post  Sponsored content


      Current date/time is 24th November 2017, 09:29