
UPDATE menus set name='customers_ledgers_lists' where id=35;
UPDATE menus set name='suppliers_ledgers_lists' where id=36;

DELETE FROM menu_categories where id=7;
INSERT INTO menu_categories SET id=7, disp_name='各種リスト', disp_sort=7, created_at=NOW(), updated_at=NOW();
DELETE FROM menus where menu_category_id=7;
INSERT INTO menus SET id=63, menu_category_id=7, name='sales_users_lists', disp_name='担当者別売上', disp_sort=50, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=64, menu_category_id=7, name='sales_warehouses_lists', disp_name='売上リスト', disp_sort=52, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=65, menu_category_id=7, name='stocks_arrivings_lists', disp_name='未入荷一覧', disp_sort=53, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=66, menu_category_id=7, name='stocks_others_lists', disp_name='貸出在庫一覧', disp_sort=54, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=67, menu_category_id=7, name='stocks_owns_lists', disp_name='自社在庫一覧', disp_sort=55, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=68, menu_category_id=7, name='stocks_reserves_lists', disp_name='予備在庫一覧', disp_sort=56, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=69, menu_category_id=7, name='backorders_lists', disp_name='バックオーダ一覧', disp_sort=57, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=70, menu_category_id=7, name='shipping_sheets_lists', disp_name='出荷伝票枚数', disp_sort=58, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=71, menu_category_id=7, name='shipping_shorts_lists', disp_name='短期貸出一覧', disp_sort=59, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=72, menu_category_id=7, name='stocks_ubd_lists', disp_name='UBD切迫本数', disp_sort=60, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=73, menu_category_id=7, name='sales_products_lists', disp_name='型番別売上', disp_sort=61, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=74, menu_category_id=7, name='stocks_manufactured_lists', disp_name='製造年月日別在庫', disp_sort=62, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=75, menu_category_id=7, name='sales_samples_lists', disp_name='売上・サンプル', disp_sort=63, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=76, menu_category_id=7, name='stocks_customers_lists', disp_name='棚卸原票', disp_sort=64, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=77, menu_category_id=7, name='stocks_shippings_and_sales_lists', disp_name='仕様別不稼働', disp_sort=65, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=78, menu_category_id=7, name='stocks_books_lists', disp_name='医療機器出納記録', disp_sort=66, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=79, menu_category_id=7, name='trans_search_lists', disp_name='取引履歴検索', disp_sort=67, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=80, menu_category_id=7, name='stock_search_lists', disp_name='在庫元帳検索', disp_sort=68, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=81, menu_category_id=7, name='customers_drafts_lists', disp_name='受取手形一覧', disp_sort=69, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=82, menu_category_id=7, name='customers_gross_lists', disp_name='粗利益率一覧', disp_sort=70, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=83, menu_category_id=7, name='customers_cashflow_lists', disp_name='キャッシュフロー', disp_sort=71, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=84, menu_category_id=7, name='customers_receivings_lists', disp_name='回収予定一覧', disp_sort=72, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=85, menu_category_id=7, name='customers_receivables_lists', disp_name='債権残高一覧', disp_sort=73, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=86, menu_category_id=7, name='customers_unrealized_lists', disp_name='未回収残高一覧', disp_sort=74, created_at=NOW(), updated_at=NOW();
INSERT INTO menus SET id=87, menu_category_id=7, name='stocks_products_lists', disp_name='型番別在庫一覧', disp_sort=75, created_at=NOW(), updated_at=NOW();



#UPDATE menu_categories set invalid_flag_code=0;
#UPDATE menus set invalid_flag_code=0;

#ALTER TABLE menu_categories ADD invalid_flag_code smallint(6) after disp_sort;
#ALTER TABLE menus ADD invalid_flag_code smallint(6) after disp_sort;
UPDATE menu_categories set invalid_flag_code=0;
UPDATE menus set invalid_flag_code=0;

