CREATE TABLE myTable
(c_id integer NOT NULL AUTO_INCREMENT,
c_image varchar(32) NOT NULL default '',
c_deviant integer NOT NULL default 0,
c_flickr integer NOT NULL default 0,
c_natpho integer NOT NULL default 0,
c_natscape integer NOT NULL default 0,
c_pbase integer NOT NULL default 0,
c_photonet integer NOT NULL default 0,
c_photoport integer NOT NULL default 0,
c_smugmug integer NOT NULL default 0,
PRIMARY KEY (c_id));