CREATE TABLE `mmnkr_items` ( `shops_id` INT( 4 ) NOT NULL , `shops_b` INT( 4 ) NULL , `shops_c` VARCHAR( 255 ) NULL , `shops_cate` VARCHAR( 255 ) NOT NULL , `shops_item` VARCHAR( 255 ) NOT NULL , `shops_price` INT( 10 ) NOT NULL , `shops_g` INT( 2 ) NULL , `shops_h` VARCHAR( 255 ) NULL , `shops_i` INT( 2 ) NULL , `shops_j` VARCHAR( 255 ) NULL , `shops_k` VARCHAR( 255 ) NULL , `shops_l` VARCHAR( 255 ) NULL , `shops_m` VARCHAR( 255 ) NULL , `shops_comm1` TEXT NULL , `shops_comm2` LONGTEXT NULL , `shops_p` VARCHAR( 255 ) NULL , `shops_q` VARCHAR( 255 ) NULL , `shops_r` VARCHAR( 255 ) NULL , `shops_s` VARCHAR( 255 ) NULL , `shops_t` VARCHAR( 255 ) NULL , `shops_u` VARCHAR( 255 ) NULL , `shops_v` VARCHAR( 255 ) NULL , `shops_w` VARCHAR( 255 ) NULL , `shops_x` VARCHAR( 255 ) NULL , `shops_y` VARCHAR( 255 ) NULL , `shops_z` VARCHAR( 255 ) NULL , PRIMARY KEY ( `shops_id` ) ) TYPE = MYISAM COMMENT = 'フィード出力用-商品一覧'; CREATE TABLE `mmnkr_cates` ( `cate1` INT( 2 ) NOT NULL , `cate2` INT( 2 ) NOT NULL , `cate_n1` VARCHAR( 255 ) NULL , `cate3` INT( 2 ) NOT NULL , `cate_n2` VARCHAR( 255 ) NULL ) TYPE = MYISAM COMMENT = 'フィード出力用-カテゴリ一覧';