Having Difficulty in Creating these tables.

[Ahmed Feroze]

Please help me in identifying/understanding the errors I am getting when I try to create a table by using the following DDL:
Thanks for your help.

create table company_contact
(
company_contact_date char(18) not null,
company_number decimal(7) not null,
company_contact_name varchar(30),
company_contact_type_code char(7),
computer_user_name char(30),
primary key (company_contact_date, company_number)
)
comment = "a contact made with a representative of a company by a member of staff of microcapital.

for example :-

chris jarrous participated in a public conference call hosted by loud technologies."
type = innodb;

/*==============================================================*/
/* Index: xif1company_contact */
/*==============================================================*/
create index xif1company_contact on company_contact
(
company_contact_type_code
);

/*==============================================================*/
/* Index: xif2company_contact */
/*==============================================================*/
create index xif2company_contact on company_contact
(
company_number
);

/*==============================================================*/
/* Index: xif3company_contact */
/*==============================================================*/
create index xif3company_contact on company_contact
(
computer_user_name
);