
DROP INDEX LD0I1SocialWelfareCustship ON LD0P0SOCIALWELFARECUSTSHIP
;

UPDATE LD0P0SOCIALWELFARECUSTSHIP SET VERSION = '1'
;

ALTER TABLE LD0P0SocialWelfareCustship 	ALTER COLUMN SERVPRO VARCHAR(100) NULL
;

ALTER TABLE LD0P0SocialWelfareCustship 	ALTER COLUMN VERSION INT 
;

ALTER TABLE LD0P0SocialWelfareCustship ADD SPECIALCONTENTS INT
	CONSTRAINT LD0P0SocialWelfareCustship_SPECIALCONTENTS  DEFAULT 0 NOT NULL
;

ALTER TABLE LD0P0SocialWelfareCustship ADD DRAFTDAT	DATETIME NULL
;

ALTER TABLE LD0P0SocialWelfareCustship ADD CREATEDAT  DATETIME NULL
;

ALTER VIEW LD0V0SocialWelfareCustship  AS SELECT * FROM LD0P0SocialWelfareCustship 
;

GRANT ALL ON LD0V0SocialWelfareCustship TO LD0ROANV
;


