20140721.phortune.3.charge.sql
No OneTemporary
Actions

Size

705 B

Referenced Files

None

Subscribers

None

20140721.phortune.3.charge.sql
View Options

	CREATE TABLE {$NAMESPACE}_phortune.phortune_charge (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid 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) NOT NULL COLLATE utf8_bin,
	paymentMethodPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	amountInCents 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),
	KEY `key_account` (accountPHID)
	) ENGINE=InnoDB, COLLATE utf8_general_ci;

File Metadata

Mime Type: text/plain
Expires: Thu, Jan 15, 2:02 AM (1 d, 6 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 620336
Default Alt Text: 20140721.phortune.3.charge.sql (705 B)

Event Timeline