Sorry for this easy question but I'm kind of a newbie and I'm wondering if someone could assist me with creating a new table for a postnuke module? I need to copy the following content into a table I create named nuke_zc_ads:
( `ad_id` smallint(5) unsigned NOT NULL auto_increment, `cat_id` smallint(5) unsigned NOT NULL default '0', `user_name` varchar(20) NOT NULL default '', `email` varchar(50) NOT NULL default '', `price` text NOT NULL, `condition` varchar(10) NOT NULL default '', `city` varchar(20) NOT NULL default '', `state` varchar(20) NOT NULL default '', `country` varchar(20) NOT NULL default '', `lastup_date` int(11) NOT NULL default '0', `subject` text NOT NULL, `descript` text NOT NULL, `url` text NOT NULL, `views` int(11) NOT NULL default '0', `paypal` char(3) NOT NULL default 'No', `add_date` int(11) NOT NULL default '0', `exp_date` int(11) NOT NULL default '0', PRIMARY KEY (`ad_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; I see where to create the table but I'm not sure about the number of fields to add. My instincts are telling me I need 18 fields but I just need to confirm. Any responses are appreciated.