Myra db update

[Lurker_005]

Nice to see a new update to this DB Myra.

The latest dumpeditems.sql has a different structure than the db.sql file. A good reason to dump the table structure with the data. There are some changes besides the last few columns, but here is the differance at the end:

dumpeditems.sql

  updated datetime NOT NULL default '0000-00-00 00:00:00',
  weight int(11) NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  loreflag tinyint(3) unsigned NOT NULL default '0',
  pendingloreflag tinyint(3) unsigned NOT NULL default '0',
  artifactflag tinyint(3) unsigned NOT NULL default '0',
  summonedflag tinyint(3) unsigned NOT NULL default '0',
  unknown113 int(11) NOT NULL default '0',
  unknown115 int(11) NOT NULL default '0',

Vs.
db.sql

  updated datetime default NULL,
  md5sum tinyblob NULL,
  weight int(11) NULL,
  comment varchar(255) default NULL,

Vs.
MyraItems.sql data structure (best as I can tell)

  weight int(11) NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  loreflag tinyint(3) unsigned NOT NULL default '0',
  pendingloreflag tinyint(3) unsigned NOT NULL default '0',
  artifactflag tinyint(3) unsigned NOT NULL default '0',
  summonedflag tinyint(3) unsigned NOT NULL default '0',
 updated datetime NOT NULL default '0000-00-00 00:00:00',

---  Add Quest_globalbs table that is missing from db.sql
DROP TABLE IF EXISTS quest_globals;
CREATE TABLE quest_globals (
  id int(11) NOT NULL auto_increment,
  charid int(11) NOT NULL default 0,
  npcid int(11) NOT NULL default 0,
  zoneid int(11) NOT NULL default 0,
  name varchar(65) NOT NULL,
  value varchar(65) NOT NULL default "?",
  expdate int(11) NOT NULL default 0,
  PRIMARY KEY  (id),
  UNIQUE KEY qname (name,charid,npcid,zoneid)
) TYPE=MyISAM;



--- Reorder npc_types to same as default eqemu db.sql

ALTER TABLE `npc_types` ADD `mysqlfront_temp_fieldname` TINYINT(4)  DEFAULT "0" NOT NULL AFTER `runspeed`
UPDATE `npc_types` SET `mysqlfront_temp_fieldname`=`see_invis`
ALTER TABLE `npc_types` DROP `see_invis`
ALTER TABLE `npc_types` CHANGE `mysqlfront_temp_fieldname` `see_invis` TINYINT(4)  DEFAULT "0" NOT NULL

ALTER TABLE `npc_types` ADD `mysqlfront_temp_fieldname` TINYINT(4)  DEFAULT "1" NOT NULL AFTER `see_invis`
UPDATE `npc_types` SET `mysqlfront_temp_fieldname`=`see_invis_undead`
ALTER TABLE `npc_types` DROP `see_invis_undead`
ALTER TABLE `npc_types` CHANGE `mysqlfront_temp_fieldname` `see_invis_undead` TINYINT(4)  DEFAULT "1" NOT NULL

I also noticed

  revoked tinyint(3) unsigned NOT NULL default '0',

in the accounts table. I don't know if this is needed, or will cause problems.

PS. the Trump, Scorp, Myra exchange gave me a good chuckle, thanks