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: Thu, Feb 6, 2:09 AM (15 h, 4 m)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 33905
Default Alt Text: 20140902.almanacdevice.1.sql (701 B)

Event Timeline