20130324.phortuneproduct.sql
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

20130324.phortuneproduct.sql
View Options

	CREATE TABLE {$NAMESPACE}_phortune.phortune_product (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
	productName VARCHAR(255) NOT NULL,
	productType VARCHAR(64) NOT NULL COLLATE utf8_bin,
	status VARCHAR(64) NOT NULL COLLATE utf8_bin,
	priceInCents BIGINT NOT NULL,
	billingIntervalInMonths INT UNSIGNED,
	trialPeriodInDays INT UNSIGNED,
	metadata LONGTEXT NOT NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_phid` (phid),
	KEY `key_status` (status)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

	CREATE TABLE {$NAMESPACE}_phortune.phortune_producttransaction (
	id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
	authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
	editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
	commentPHID VARCHAR(64) COLLATE utf8_bin,
	commentVersion INT UNSIGNED NOT NULL,
	transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
	oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
	newValue LONGTEXT NOT NULL COLLATE utf8_bin,
	contentSource LONGTEXT 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_object` (objectPHID)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;