Hi all,

I can't create with ibernate a table contating a column named 'delete', it's Asterisk (Open source PBX) needs a field called 'deleted' for voicemail (http://www.voip-info.org/wiki/view/Aste ... +Voicemail)
This SQL works:

CREATE TABLE `voicemail_users` (
`uniqueid` int(11) NOT NULL auto_increment,
....
`delete` varchar(4) NOT NULL default 'no',
....
`stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`uniqueid`),
KEY `mailbox_context` (`mailbox`,`context`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;

but this class fails to create:

@Entity
@Table(
appliesTo="VoiceMail", indexes=
@Index(
name="mailbox_search_index",
columnNames = {"mailbox","context"}
)
)
public class VoiceMail implements Serializable
{
private static final long serialVersionUID = -4918214058275097969L;
private int uniqueid;
...
private String delete;
...
private String hidefromdir;
}

Shows clasic "Incorrect sintax near delete check your sql manual.."

You'll need to define the column name with backticks: