Something

ERROR 1064 (42000) at line 75: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tables text NOT NULL,
  price text NOT NULL,
  day int(1) NOT NULL default '0',
' at line 11



CREATE TABLE nights (
  ni_id int(11) NOT NULL auto_increment,
  ven_id int(11) NOT NULL default '0',
  name varchar(30) NOT NULL default '',
  time_start time NOT NULL default '00:00:00',
  time_finish time NOT NULL default '00:00:00',
  date_start date NOT NULL default '0000-00-00',
  date_finish date NOT NULL default '0000-00-00',
  music text NOT NULL,
  dress_code text NOT NULL,
  tables text NOT NULL,
  price text NOT NULL,
  day int(1) NOT NULL default '0',
  no_book int(1) NOT NULL default '0',
  special int(1) NOT NULL default '0',
  no_priority int(11) NOT NULL default '0',
  description text NOT NULL,
  active int(1) NOT NULL default '1',
  comingsoon int(1) NOT NULL default '0',
  photo varchar(20) NOT NULL default '',
  mischief_night int(1) NOT NULL default '0',
  PRIMARY KEY  (ni_id),
  KEY ven_id (ven_id),
  KEY comingsoon (comingsoon)
) TYPE=MyISAM;