The backup DB included was not used to set up these files as i had allready created an sql DB and connected to the game using my  connection .

Disclaimer* the mir2 db included was not tested in the setting up and running of these files.


you should do a restore on this DB and not attach it.
i am told that the DB is fully updated from the updates.doc and this is what has been done to it since its first release as TD's  old DB.

•	db update: in tbl_charinfo add the following field:
		Fld_Killpoints (bigint, length 8, default value 0, allow null : false)
•	forgot to mention last update log: you need to add a new table to the ms sql 'char' db info:
	name: TBL_GuildWarLog
	fields:
		Fld_GuildName1, varchar, length 20, allow null = false
		Fld_GuildName2 (same as above)
		Fld_Time, int, length 4, allow null = false, default value = 0
		Fld_Duration (same as above
•	reworked the dbserver; info below(afraid it can only run mssql now not mysql)
	deleted following data from tbl_charinfo:(all pointless really)
	Fld_AC,Fld_mac,Fld_DC,Fld_MC,Fld_SC,Fld_MaxHP,Fld_MaxMP,Fld_MaxExp, Fld_Weight,Fld_MaxWeight,
	Fld_WearWeight,Fld_MaxWearWeight,Fld_HandWeight, Fld_MaxHandWeight
	changes to tbl_CharList:(allow null is always false :p)
	Fld_Index(int, length4, increment = yes, identity increment = 1)
	Fld_Account(varchar,16)
	Fld_CharName(varchar,20)
	Fld_CreateDate(bigint,8,default 0)
	Fld_Modifydate(bigint,8, default 0)
	Fld_SelectID(int,4,default 0)
	Fld_Deleted(bit,1,default 0)
	Fld_Selected(bit, 1, default value 0)
•	you need to add Fld_GuildPoints to tbl_guildlist, data type: int, length: 4, allow nulls: false, default value 0
•	need to add a new field to tbl_guildlist: fieldname: Fld_GuildLogo , data type: varchar, length: 20, allow null = false, default value : '' (yes the 2 ' signs)
•	added a few new tables to the char database
	- Tbl_GuildList (contains only one field: Fld_GuildName, data type: varchar, length: 20, allow nulls:false)
	- Tbl_GuildItems(contains the same fields as tbl_useritems except instead of Fld_Charname it's Fld_Guildname here)
	- Tbl_GuildMemberList, contains:
		Fld_GuildName: varchar, length 20, allow null : false
		Fld_GuildRank:   int	      , length 4	, allow null: false
		Fld_CharName: varchar , length20,  allow null: false
		Fld_Level	  :  int	      , length 4  , allow null: false
		Fld_RankName: varchar, length 50, allow null: false