20140721.phortune.2.purchase.sql
No OneTemporary
Actions

Size

728 B

Referenced Files

None

Subscribers

None

20140721.phortune.2.purchase.sql
View Options

	CREATE TABLE {$NAMESPACE}_phortune.phortune_purchase (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
	productPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	accountPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	cartPHID VARCHAR(64) COLLATE utf8_bin,
	basePriceInCents INT NOT NULL,
	quantity INT UNSIGNED NOT NULL,
	totalPriceInCents INT NOT NULL,
	status VARCHAR(32) NOT NULL COLLATE utf8_bin,
	metadata LONGTEXT NOT NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_phid` (phid),
	KEY `key_cart` (cartPHID)
	) ENGINE=InnoDB, COLLATE utf8_general_ci;

File Metadata

Mime Type: text/plain
Expires: Sun, Jan 19, 18:14 (1 w, 4 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1127321
Default Alt Text: 20140721.phortune.2.purchase.sql (728 B)

Event Timeline