summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/mysql/1.3/history_uint.sql
blob: 8d8b7d8d8cd2c0f576b3079e3d5d4b72e1c4bce3 (plain)
1
2
3
4
5
6
CREATE TABLE history_uint (
	itemid		bigint unsigned		DEFAULT '0'	NOT NULL,
	clock		integer		DEFAULT '0'	NOT NULL,
	value		bigint unsigned		DEFAULT '0'	NOT NULL
);
CREATE INDEX history_uint_1 on history_uint (itemid,clock);