//no create


CREATE TABLE ProjectHistory(
id INT PRIMARY KEY,
user_id INT NOT NULL,
category_name VARCHAR(50) NOT NULL,
title VARCHAR(50) NOT NULL,
description VARCHAR(500),
gallery_id INT NOT NULL,
DATE DATETIME NOT NULL,
STATUS VARCHAR(50) CHECK(STATUS IN('Approved', 'Not approved', 'Approving')) NOT NULL
) ON Content;



//no logic


GO
CREATE PROCEDURE spMoverParaHistorico
AS

	INSERT INTO ProjectHistory(id, user_id, category_name,title ,description ,gallery_id ,DATE,STATUS)
	select p.* from Project p
    where getdate()>=DATEADD(month, 1, p.DATE);

	delete from Comment where project_id in (select p.id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

	delete from UserRateProject where project_id in (select p.id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

	delete from [View] where project_id in (select p.id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

	delete from Download where gallery_id in (select p.gallery_id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

	delete from GalleryImage where gallery_id in (select p.gallery_id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

	delete from Project where id in (select p.id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

	delete from Gallery where id in (select p.gallery_id from Project p
    where getdate()>=DATEADD(month, 1, p.DATE));

GO