CREATE TABLE `objects` (
	`id` int NOT NULL AUTO_INCREMENT,
	`name` nvarchar(100) NOT NULL,
	`description` text,
	`createdAt` datetime NOT NULL,
	`updatedAt` datetime NOT NULL,
	`folderID` int NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `name_UNIQUE` (`name`),
	KEY `fk_folderID` (`folderID`),
	CONSTRAINT `fk_folderID` FOREIGN KEY (`folderID`) REFERENCES `folders` (`id`) 
		ON DELETE NO ACTION ON UPDATE NO ACTION
	) ENGINE=InnoDB;

DELIMITER // 
CREATE PROCEDURE `save_obj`(id int, name nvarchar(100), description text,
	 createdAt datetime, updatedAt datetime, folderID int)
LANGUAGE SQL 
BEGIN 
   UPDATE `objects` 
	SET
   	`name` = name,
   	`description` = description,
   	`createdAt` = createdAt,
   	`updatedAt` = updatedAt,
   	`folderID` = folderID
   WHERE 
   	`id` = id;
END;//

call save_test(4 , "qqqqqq", "d", "2011-12-18 13:17:17", "2011-12-18 13:17:17", 1);

 UPDATE `objects` 
            SET
                `name` = "qqqqqq",
                `description` = "description",
                `createdAt` = "2011-12-18 13:17:17",
                `updatedAt` = "2011-12-18 13:17:17",
                `folderID` = "1"
            WHERE 
                `id` = 4;