Files F15535162

20140902.almanacdevice.1.sql
No OneTemporary
Actions

Size

701 B

Referenced Files

None

Subscribers

None

20140902.almanacdevice.1.sql
View Options

	CREATE TABLE {$NAMESPACE}_almanac.almanac_device (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARBINARY(64) NOT NULL,
	name VARCHAR(255) NOT NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_phid` (phid)
	) ENGINE=InnoDB, COLLATE utf8_bin;

	CREATE TABLE {$NAMESPACE}_almanac.almanac_deviceproperty (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	devicePHID VARBINARY(64) NOT NULL,
	`key` VARCHAR(128) NOT NULL COLLATE utf8_bin,
	value LONGTEXT NOT NULL,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	KEY `key_device` (devicePHID, `key`)
	) ENGINE=InnoDB, COLLATE utf8_bin;

File Metadata

Mime Type: text/plain
Expires: Tue, Apr 28, 7:40 PM (1 d, 13 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1089551
Default Alt Text: 20140902.almanacdevice.1.sql (701 B)

Event Timeline