changeset

<changeSet id="201401081823-TRUNK-4202" author="k-joseph">
     	<validCheckSum>3:d0da8b0b930623f6c62e2bd02bc2523b</validCheckSum>
     	<validCheckSum><comment>Changing identifier from person.person_id to user.system_id</comment>3:cccc02519a766bd8fde048cea13d307c</validCheckSum>
     	<validCheckSum><comment>Changing now() to CURRENT_TIMESTAMP</comment>3:a70d8897d05364a0a4398f2b90542fd4</validCheckSum>
     	<validCheckSum><comment>Copying user.retired to person.voided so that generated providers for retired users are retired</comment>3:f338c9ea12ce38b0695db335d983b4e1</validCheckSum>
     	<validCheckSum><comment>Correcting checksum</comment>3:216ab5057dca5471de69124e93953d96</validCheckSum>
     	<preConditions onFail="MARK_RAN">
			<columnExists tableName="orders" columnName="orderer" />
			<not><sqlCheck expectedResult="0">select count(*) from orders</sqlCheck></not>
		</preConditions>
		<comment>Creating provider accounts for all users who have placed
			orders for patients and have no associated provider accounts
		</comment>
		<sql>
			insert into provider(person_id, identifier, creator, date_created, retired, uuid) values (
			select orders.orderer where users.user_id = orders.orderer, CONCAT('prov: ', SUBSTRING(SELECT UUID(), 5)), 1, CURRENT_TIMESTAMP, false, (SELECT UUID())
			where orders.orderer is not null and orders.orderer not in (select person_id from provider);
		</sql>
	</changeSet>