The design of menu table in SQL

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

CREATE TABLE IF NOT EXISTS `upmenu_block` (
  `id_foto_b` int(5) NOT NULL auto_increment,
  `id_sec` int(5) NOT NULL,
  `f_b1` varchar(100) NOT NULL,
  `f_b2` varchar(100) NOT NULL,
  `f_b3` varchar(100) NOT NULL,
  `f_b4` varchar(100) NOT NULL,
  `f_o1` varchar(200) NOT NULL,
  `f_o2` varchar(200) NOT NULL,
  `f_o3` varchar(200) NOT NULL,
  `f_o4` varchar(200) NOT NULL
  PRIMARY KEY  (`id_foto_b`)
)