Re: 病害虫分類及び害虫グループ付き m_byochu

このトピックの投稿一覧へ

なし Re: 病害虫分類及び害虫グループ付き m_byochu

msg# 1.3.2.2.2
depth:
4
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 .2 | 投稿日時 2010.11.04 00:39 | 最終変更
OhYeah!  管理人   投稿数: 983 オンライン
まずは、害虫グループマスターの spec.ggaichu です。m_byochu では、ここから gid のみ貼り付けます。

2010.11.4 9:24 追記
グループ名に「複数害虫」と「グループ無し」を追加しました。

--/d
drop table if exists spec.ggaichu;
create table spec.ggaichu (gid integer primary key autoincrement, gname varchar unique);
begin transaction;
insert into spec.ggaichu (gname) values ('アオムシG');
insert into spec.ggaichu (gname) values ('アゲハG');
insert into spec.ggaichu (gname) values ('アザミウマG');
insert into spec.ggaichu (gname) values ('アブラムシG');
insert into spec.ggaichu (gname) values ('アリG');
insert into spec.ggaichu (gname) values ('イナゴ・バッタG');
insert into spec.ggaichu (gname) values ('イラガG');
insert into spec.ggaichu (gname) values ('ウスバG');
insert into spec.ggaichu (gname) values ('ウワバG');
insert into spec.ggaichu (gname) values ('ウンカG');
insert into spec.ggaichu (gname) values ('カイガラムシG');
insert into spec.ggaichu (gname) values ('カキヘタノムシガ・マイコガG');
insert into spec.ggaichu (gname) values ('カスミカメG');
insert into spec.ggaichu (gname) values ('カブトムシG');
insert into spec.ggaichu (gname) values ('カミキリムシG');
insert into spec.ggaichu (gname) values ('カメムシG');
insert into spec.ggaichu (gname) values ('カレハガG');
insert into spec.ggaichu (gname) values ('ガガンボG');
insert into spec.ggaichu (gname) values ('キクイムシG');
insert into spec.ggaichu (gname) values ('キジラミG');
insert into spec.ggaichu (gname) values ('クスサンG');
insert into spec.ggaichu (gname) values ('クロバネキノコバエG');
insert into spec.ggaichu (gname) values ('グンバイムシG');
insert into spec.ggaichu (gname) values ('ケシキスイG');
insert into spec.ggaichu (gname) values ('ケムシG');
insert into spec.ggaichu (gname) values ('ケラG');
insert into spec.ggaichu (gname) values ('コウモリガG');
insert into spec.ggaichu (gname) values ('コオロギ・カネタタキG');
insert into spec.ggaichu (gname) values ('コガネムシ・ブイブイG');
insert into spec.ggaichu (gname) values ('コガG');
insert into spec.ggaichu (gname) values ('コナカイガラムシG');
insert into spec.ggaichu (gname) values ('コナガ・スガG');
insert into spec.ggaichu (gname) values ('コナジラミG');
insert into spec.ggaichu (gname) values ('コナダニG');
insert into spec.ggaichu (gname) values ('コメツキムシG');
insert into spec.ggaichu (gname) values ('サビダニG');
insert into spec.ggaichu (gname) values ('シジミチョウG');
insert into spec.ggaichu (gname) values ('シバンムシG');
insert into spec.ggaichu (gname) values ('シャクガG');
insert into spec.ggaichu (gname) values ('シャチホコガG');
insert into spec.ggaichu (gname) values ('シンクイガ・シンクイムシG');
insert into spec.ggaichu (gname) values ('ジャガイモガ・イモコガG');
insert into spec.ggaichu (gname) values ('スカシバG');
insert into spec.ggaichu (gname) values ('スズメガG');
insert into spec.ggaichu (gname) values ('セミG');
insert into spec.ggaichu (gname) values ('センチュウG');
insert into spec.ggaichu (gname) values ('ゾウムシG');
insert into spec.ggaichu (gname) values ('タネコバチG');
insert into spec.ggaichu (gname) values ('タネバエ・ハナバエG');
insert into spec.ggaichu (gname) values ('タマバエG');
insert into spec.ggaichu (gname) values ('タマバチG');
insert into spec.ggaichu (gname) values ('タマムシG');
insert into spec.ggaichu (gname) values ('タマワタムシG');
insert into spec.ggaichu (gname) values ('ダンゴムシG');
insert into spec.ggaichu (gname) values ('チビガG');
insert into spec.ggaichu (gname) values ('チョッキリG');
insert into spec.ggaichu (gname) values ('ツトガG');
insert into spec.ggaichu (gname) values ('テントウムシダマシG');
insert into spec.ggaichu (gname) values ('テントウムシG');
insert into spec.ggaichu (gname) values ('トビムシG');
insert into spec.ggaichu (gname) values ('トラガG');
insert into spec.ggaichu (gname) values ('トリバガG');
insert into spec.ggaichu (gname) values ('ナガカメムシG');
insert into spec.ggaichu (gname) values ('ナメクジG');
insert into spec.ggaichu (gname) values ('ネアブラムシG');
insert into spec.ggaichu (gname) values ('ネダニG');
insert into spec.ggaichu (gname) values ('ハゴロモG');
insert into spec.ggaichu (gname) values ('ハダニG');
insert into spec.ggaichu (gname) values ('ハバチG');
insert into spec.ggaichu (gname) values ('ハマキガG');
insert into spec.ggaichu (gname) values ('ハムシG');
insert into spec.ggaichu (gname) values ('ハモグリガG');
insert into spec.ggaichu (gname) values ('ハモグリバエ・キモグリバエ・カラバエ・ミギワバエG');
insert into spec.ggaichu (gname) values ('ハンミョウG');
insert into spec.ggaichu (gname) values ('ヒトリガG');
insert into spec.ggaichu (gname) values ('ヒラタムシG');
insert into spec.ggaichu (gname) values ('ヒロズコガG');
insert into spec.ggaichu (gname) values ('ホコリダニG');
insert into spec.ggaichu (gname) values ('ホソガ・カワモグリG');
insert into spec.ggaichu (gname) values ('マイマイ・カタツムリG');
insert into spec.ggaichu (gname) values ('マイマイ・ドクガG');
insert into spec.ggaichu (gname) values ('ミノガ・ミノムシG');
insert into spec.ggaichu (gname) values ('ミバエG');
insert into spec.ggaichu (gname) values ('ムギダニG');
insert into spec.ggaichu (gname) values ('メイガG');
insert into spec.ggaichu (gname) values ('ヤガG');
insert into spec.ggaichu (gname) values ('ヨコバイG');
insert into spec.ggaichu (gname) values ('ヨトウG');
insert into spec.ggaichu (gname) values ('リンゴガイG');
insert into spec.ggaichu (gname) values ('ロウムシ・ロウカイガラムシG');
insert into spec.ggaichu (gname) values ('複数害虫');
insert into spec.ggaichu (gname) values ('グループ無し');
commit;
投票数:2 平均点:5.00

投稿ツリー

  条件検索へ