BEGIN TRANSACTION
CREATE TABLE wizards.Tmp_LAFCMS_association
	(
	association_id char(26) NOT NULL,
	associated_id_a char(26) NULL,
	associated_id_b char(26) NULL,
	label_id char(26) NULL,
	date_created datetime NULL,
	date_modified datetime NULL
	)  ON [PRIMARY]
INSERT INTO wizards.Tmp_LAFCMS_association (association_id, associated_id_a, associated_id_b, label_id, date_created, date_modified)
		SELECT association_id, associated_id_a, associated_id_b, '00000000000000000000000000' AS label_id, date_created, date_modified FROM wizards.LAFCMS_association TABLOCKX
DROP TABLE wizards.LAFCMS_association
EXECUTE sp_rename N'wizards.Tmp_LAFCMS_association', N'LAFCMS_association', 'OBJECT'
ALTER TABLE wizards.LAFCMS_association ADD CONSTRAINT
	PK_association PRIMARY KEY CLUSTERED 
	(
	association_id
	) WITH FILLFACTOR = 90 ON [PRIMARY]

CREATE TABLE wizards.Tmp_LAFCMS_membership
	(
	membership_id char(26) NOT NULL,
	container_id char(26) NULL,
	item_id char(26) NULL,
	location_id char(26) NULL,
	label_id char(26) NULL,
	date_created datetime NULL,
	date_modified datetime NULL
	)  ON [PRIMARY]
INSERT INTO wizards.Tmp_LAFCMS_membership (membership_id, container_id, item_id, location_id, label_id, date_created, date_modified)
		SELECT membership_id, container_id, item_id, location_id, '00000000000000000000000000' AS label_id, date_created, date_modified FROM wizards.LAFCMS_membership TABLOCKX
DROP TABLE wizards.LAFCMS_membership
EXECUTE sp_rename N'wizards.Tmp_LAFCMS_membership', N'LAFCMS_membership', 'OBJECT'
ALTER TABLE wizards.LAFCMS_membership ADD CONSTRAINT
	PK_item_membership PRIMARY KEY CLUSTERED 
	(
	membership_id
	) WITH FILLFACTOR = 90 ON [PRIMARY]

COMMIT