Differential D8344 Diff 19854 resources/sql/patches/20130214.chatlogchannel.sql

Changeset View

Standalone View


	CREATE TABLE {$NAMESPACE}_chatlog.chatlog_channel (			CREATE TABLE {$NAMESPACE}_chatlog.chatlog_channel (
	id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,			id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	serviceName VARCHAR(64) COLLATE utf8_bin NOT NULL,			serviceName VARCHAR(64) COLLATE utf8_bin NOT NULL,
	serviceType VARCHAR(32) COLLATE utf8_bin NOT NULL,			serviceType VARCHAR(32) COLLATE utf8_bin NOT NULL,
	channelName VARCHAR(64) COLLATE utf8_bin NOT NULL,			channelName VARCHAR(64) COLLATE utf8_bin NOT NULL,
	viewPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,			viewPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
	editPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,			editPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
	dateCreated INT UNSIGNED NOT NULL,			dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,			dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_channel` (channelName, serviceType, serviceName)			UNIQUE KEY `key_channel` (channelName, serviceType, serviceName)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8;			)ENGINE=InnoDB DEFAULT CHARSET=utf8;