-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Jul 06, 2010, 01:36 PM
-- 伺服器版本: 4.1.8
-- PHP 版本: 5.0.3
-- 
-- 資料庫: `wwf`
-- 

-- --------------------------------------------------------

-- 
-- 資料表格式： `birds`
-- 

CREATE TABLE `birds` (
  `id` smallint(5) NOT NULL auto_increment,
  `photo` varchar(100) character set big5 NOT NULL default '',
  `BirdName` varchar(50) character set big5 NOT NULL default '',
  `ChineseName` varchar(20) character set big5 NOT NULL default '',
  `Quantity` varchar(10) character set big5 NOT NULL default '',
  `place1` varchar(20) character set big5 NOT NULL default '',
  `place2` varchar(50) NOT NULL default '',
  `place3` varchar(50) NOT NULL default '',
  `place4` varchar(50) NOT NULL default '',
  `place5` varchar(50) NOT NULL default '',
  `Behaviour1` varchar(30) character set big5 NOT NULL default '',
  `Behaviour2` varchar(50) NOT NULL default '',
  `Behaviour3` varchar(50) NOT NULL default '',
  `Behaviour4` varchar(50) NOT NULL default '',
  `Score` varchar(30) character set big5 NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Birds';

-- 
-- 列出以下資料庫的數據： `birds`
-- 

INSERT INTO `birds` VALUES (18, 'newbird photo/Black-winged Stilt.jpg', '18BlackWinged_Stilt', '黑翅長腳鷸', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (17, 'newbird photo/NorthernPintail.jpg', '17NorthernPintail', '針尾鴨', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (16, 'newbird photo/Eurasian_wigeon.jpg', '16EurasianWigeon', '赤頸鴨', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (15, 'newbird photo/BlackFacedSpoonbill.jpg', '15BlackFacedSpoonbill', '黑臉琵鷺', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (14, 'newbird photo/Comorant.jpg', '14GreatCormorant', '鸕"茲鳥"', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (13, 'newbird photo/Black Kite.jpg', '13BlackKite', '麻鷹', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (12, 'newbird photo/MapieRobin.jpg', '12MapieRobin', '鵲鴝', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (10, 'newbird photo/spotteddove.jpg', '10spotteddove', '珠頸斑鳩', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (11, 'newbird photo/Long Tailed Shrike.jpg', '11LongTailedShike', '棕背伯勞', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (9, 'newbird photo/WhiteWagtail.jpg', '9WhiteWagtail', '白鶺鴒', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (8, 'newbird photo/Common_Kingfisher.jpg', '8ComonKingfisher', '普通翠鳥', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (7, 'newbird photo/white_throated_kingfisher.jpg', '7WhiteThroatedKingfisher', '白胸翡翠', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (6, 'newbird photo/WhiteBreasted_Waterhen.jpg', '6WhiteBreastedWaterhen', '白胸苦惡鳥', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (5, 'newbird photo/Common_Moorhen.jpg', '5CommonMoorhen', '黑水雞', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (4, 'newbird photo/little_grebe.jpg', '4LittleGrebe', '小鷿"虒鳥"', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (3, 'newbird photo/ChinesePond_Heron.jpg', '3ChinesePond_Heron', '池鷺', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (1, 'newbird photo/little_egret.jpg', '1LittleEgret', '小白鷺', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (2, 'newbird photo/great_egret.jpg', '2GreatEgret', '大白鷺', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (19, 'newbird photo/Pied Avocet.jpg', '19Pied_Avocet', '反咀鷸', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (20, 'newbird photo/Barn Swallow.jpg', '20BarnSwallow', '家燕', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (21, 'newbird photo/Marsh Sandpiper.jpg', '21MarshSandpiper', '澤鷸', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (22, 'newbird photo/RedShank.jpg', '22CommonRedshank', '紅腳鷸', '0', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `birds` VALUES (23, 'newbird photo/Grey Heron.jpg', '23GreyHeron', '蒼鷺', '0', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

-- 
-- 資料表格式： `mangrove1`
-- 

CREATE TABLE `mangrove1` (
  `id` smallint(5) NOT NULL auto_increment,
  `Mangrove` varchar(25) NOT NULL default '',
  `photo` varchar(150) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Mangrove1';

-- 
-- 列出以下資料庫的數據： `mangrove1`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `mangrove2`
-- 

CREATE TABLE `mangrove2` (
  `id` smallint(5) NOT NULL auto_increment,
  `Mangrove` varchar(100) NOT NULL default '',
  `photo` varchar(100) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='mangrove2';

-- 
-- 列出以下資料庫的數據： `mangrove2`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `mangrove3`
-- 

CREATE TABLE `mangrove3` (
  `id` smallint(5) NOT NULL auto_increment,
  `Mangrove` varchar(100) NOT NULL default '',
  `photo` varchar(150) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='mangrove3';

-- 
-- 列出以下資料庫的數據： `mangrove3`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `mangrove4`
-- 

CREATE TABLE `mangrove4` (
  `id` smallint(5) NOT NULL auto_increment,
  `Mangrove` varchar(150) NOT NULL default '',
  `photo` varchar(150) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Mangrove4';

-- 
-- 列出以下資料庫的數據： `mangrove4`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `othermangrove`
-- 

CREATE TABLE `othermangrove` (
  `id` smallint(5) NOT NULL auto_increment,
  `mangrove1_1` varchar(30) NOT NULL default '',
  `mangrove1_2` varchar(30) NOT NULL default '',
  `mangrove2_1` varchar(30) NOT NULL default '',
  `mangrove2_2` varchar(30) NOT NULL default '',
  `mangrove3_1` varchar(30) NOT NULL default '',
  `mangrove3_2` varchar(30) NOT NULL default '',
  `mangrove4_1` varchar(30) NOT NULL default '',
  `mangrove4_2` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Other Mangrove';

-- 
-- 列出以下資料庫的數據： `othermangrove`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `planktonnew`
-- 

CREATE TABLE `planktonnew` (
  `id` smallint(5) NOT NULL auto_increment,
  `phytoplankton1` varchar(20) NOT NULL default '0',
  `phytoplankton2` varchar(20) NOT NULL default '0',
  `phytoplankton3` varchar(20) NOT NULL default '0',
  `phytoplankton4` varchar(20) NOT NULL default '0',
  `phytoplankton5` varchar(20) NOT NULL default '0',
  `phytoplankton6` varchar(20) NOT NULL default '0',
  `phytoplankton7` varchar(20) NOT NULL default '0',
  `plankton1` varchar(20) NOT NULL default '0',
  `plankton2` varchar(20) NOT NULL default '0',
  `plankton3` varchar(20) NOT NULL default '0',
  `plankton4` varchar(20) NOT NULL default '0',
  `plankton5` varchar(20) NOT NULL default '0',
  `plankton6` varchar(20) NOT NULL default '0',
  `plankton7` varchar(20) NOT NULL default '0',
  `plankton8` varchar(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='New plankton';

-- 
-- 列出以下資料庫的數據： `planktonnew`
-- 

