DROP TABLE IF EXISTS `Notes`;
DROP TABLE IF EXISTS `BrokerNotes`;
CREATE TABLE `BrokerNotes`(
`BrokerNoteID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`BrokerID` BIGINT(20) UNSIGNED NOT NULL,
`Origin` VARCHAR(64) NOT NULL,
`Created` DATETIME NOT NULL,
`Note` VARCHAR(1024) NOT NULL,
PRIMARY KEY(`BrokerNoteID`),
INDEX(`BrokerID`) )ENGINE=InnoDB;

INSERT INTO `BrokerNotes` (`BrokerID`, `Origin`, `Created`, `Note`) VALUES (1,'1','20060606123333','note');

ALTER TABLE BrokerNotes RENAME Notes,CHANGE BrokerNoteID NoteID bigint unsigned not null auto_increment,CHANGE BrokerID GenericUserID bigint unsigned not null;