AnsweredAssumed Answered

database modification

Question asked by mannou on May 31, 2006
Hi,

I want to create a new table on the database 'alfresco' .
How can i connect to the database and create my table .
- i tried  : mysql -u root -p  and i showed the different database tables but when i try to add a new table :



create table alfresco.workflow (
IdWf SMaLLINT PRIMARY KEY ,
NameWf VARCHAR(40)
DescripWf VARCHAR(50)) ;


a syntax error is generayed.


and please how alfresco connect to the database for storing or retrieving data.

thanks .

Outcomes