Latest SQL UPDATED: 10/14/2013

[vbawol]

As we change pricing and add new items and/or missing items, use this SQL to keep up to date:

https://raw.github.com/vbawol/DayZ-Epoch/master/Server%20Files/mysql/epoch.sql

[Aliveman]

Is there a changelog for these updates? I have already made several pricing and item changes and would hate to have them overwritten. I did see about three small changes on the github page but is that all this sql is updating?

[jordo_123]

how do i add this, do i just save as and import or copy the code and paste into the sql tab and hit go.

sorry i'm new to phpmyadmin

[Gimmic]

If you're concerned about custom pricing changes overlapping with SQL updates, you could always diff the files to see what changed and where overlap might be. 

[raincloud]

 

 

CREATE TABLE IF NOT EXISTS `Object_DATA` (

`ObjectID` int(11) unsigned NOT NULL AUTO_INCREMENT,

`ObjectUID` bigint(24) NOT NULL DEFAULT '0',

`Instance` int(11) unsigned NOT NULL,

`Classname` varchar(50) DEFAULT NULL,

`Datestamp` datetime NOT NULL,

`LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`CharacterID` int(11) unsigned NOT NULL DEFAULT '0',

`Worldspace` varchar(128) NOT NULL DEFAULT '[]',

`Inventory` longtext,

`Hitpoints` varchar(512) NOT NULL DEFAULT '[]',

`Fuel` double(13,5) NOT NULL DEFAULT '1.00000',

`Damage` double(13,5) NOT NULL DEFAULT '0.00000',

PRIMARY KEY (`ObjectID`),

KEY `ObjectUID` (`ObjectUID`) USING BTREE,

KEY `Instance` (`Instance`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

 

For some reason this doesnt add `LastUpdated` entry when i run a query, am i doing something wrong?