20141215.almanacservicetype.sql
No OneTemporary
Actions

Size

320 B

Subscribers

None

20141215.almanacservicetype.sql
View Options

	ALTER TABLE {$NAMESPACE}_almanac.almanac_service
	ADD serviceClass VARCHAR(64) NOT NULL COLLATE {$COLLATE_TEXT};

	ALTER TABLE {$NAMESPACE}_almanac.almanac_service
	ADD KEY `key_class` (serviceClass);

	UPDATE {$NAMESPACE}_almanac.almanac_service
	SET serviceClass = 'AlmanacCustomServiceType' WHERE serviceClass = '';