Hi,

I have a table:

CREATE TABLE `tbldoc` (

`dcid` smallint(6) UNSIGNED NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`descr` varchar(255) NOT NULL,
`type` enum('fo','fi','lk') NOT NULL default 'fo',
`loc` varchar(255) NOT NULL default 'loc',
`root` smallint(6) UNSIGNED NOT NULL default '0',
`owner` varchar(25) NOT NULL default 'root',
`faculty` smallint(6) UNSIGNED NOT NULL default '0',
`vis` enum('1','2','3','4') NOT NULL default '1',
`date` date NOT NULL,
`dclock` bool NOT NULL default '0', PRIMARY KEY (`dcid`) ) TYPE=MyISAM;

and I want to insert a record:


INSERT INTO tbldoc SET
dcid=0,

name='Root folder',
descr=' Placeholder, prevents any other records using dcid = 0',
type='fo',
loc='',
root='0',
owner='root',
faculty='4',
vis=5,
date='01-01-2003',
dclock=0;


The problem comes when I look at the record it has inserted, the value for vis is '', any odeas apprecated! have tried vis='5' to no avail.