Is there a major DB structure change on the horizon

[Edgar1898]

Probably a week, we are working on getting a few more basic features working. For example, spells are still being debugged, and we would like to get those working properly before we release the source.

[jbb]

Excellent.

[kabalah]

hi all, has the new and improved db structure been released to the public yet? i wanted to help in debugging but, i have db issues...missing fields/tables?

kabalah

[Merth]

Yes, the new db.sql should be available from CVS. I haven't touched CVS in a while, so if you don't see it, let us know.

[kabalah]

ok, i checked cvs and i don't see the db.sql file anywhere in the eqemu/NewSource tree.
kabalah

[Edgar1898]

it show be under eqemu release

[kabalah]

nope, not under NewSource, do you mean directly under eqemu tree?
kabalah

[Bigpull]

the db.sql is in NightDumps/EQEMu Release/ and likely not upto date

alter table character_ add inventory blob default NULL after profile;
CREATE TABLE start_zones (
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zone_id int(4) NOT NULL default '0',
player_deity int(4) NOT NULL default '0',
player_race int(4) NOT NULL default '0',
player_class int(2) NOT NULL default '0',
player_choice int(2) NOT NULL default '0'
) TYPE=MyISAM;

[tcsmyworld]

Is that the only change needed so far?
Do we need to wipe accts and start fresh?

[Bigpull]

Accounts are fine character_ is another matter, untill/unless someone writes a converter, you may want to dump them to a .sql or temp table

[kabalah]

thanks bigpull!
kabalah

[mutombo]

additional i need to add timeleft in the spawn2 table to join zones.

added it this way:
timeleft int(11) NOT NULL default '0',

seems working, i can login.
npcs are there too
there seems something wrong with the items always getting :"got a bogus item, deleting it " when i want to trade with a npc, but im sure thats something with the DB, im using Drawde's Worlddata 1.1 final for CVS.