# phpMyAdmin MySQL-Dump
# version 2.3.3
# http://www.phpmyadmin.net/ (download page)
#
# : localhost
# : Jan 21, 2003 at 06:27 PM
# ŷ汾: 3.23.53
# PHP 汾: 4.2.3
# ݿ : `test`
# --------------------------------------------------------

#
# ݱĽṹ `mango_album`
#

CREATE TABLE mango_album (
  id int(11) NOT NULL auto_increment,
  title varchar(20) NOT NULL default '',
  memo text NOT NULL,
  type varchar(10) NOT NULL default '',
  size varchar(10) NOT NULL default '',
  photofrom varchar(20) NOT NULL default '',
  uploadman varchar(10) NOT NULL default '',
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  hit int(11) NOT NULL default '0',
  public tinyint(1) NOT NULL default '0',
  filename varchar(20) NOT NULL default '',
  pvpic tinyint(1) NOT NULL default '0',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_album`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_bringlawsuitbox`
#

CREATE TABLE mango_bringlawsuitbox (
  id int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  memo text NOT NULL,
  readed tinyint(1) NOT NULL default '0',
  senddt datetime NOT NULL default '0000-00-00 00:00:00',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  username varchar(8) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_bringlawsuitbox`
#

INSERT INTO mango_bringlawsuitbox VALUES (1, 'Ƶķ㷨', 'Ƶķ㷨', 0, '2002-12-13 11:41:32', 60, 'ÿ');
INSERT INTO mango_bringlawsuitbox VALUES (3, 'sdsf', 'sdfdsf', 0, '2002-12-24 18:06:19', 60, 'ÿ');
INSERT INTO mango_bringlawsuitbox VALUES (4, 'sdf', 'sdfsf', 1, '2002-12-27 17:27:34', 60, 'ÿ');
INSERT INTO mango_bringlawsuitbox VALUES (5, 'sdf', 'dsfsd', 0, '2002-12-27 17:27:37', 60, 'ÿ');
# --------------------------------------------------------

#
# ݱĽṹ `mango_classbc`
#

CREATE TABLE mango_classbc (
  id int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  form varchar(10) NOT NULL default '',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  senddt datetime NOT NULL default '0000-00-00 00:00:00',
  memo text NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_classbc`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_download`
#

CREATE TABLE mango_download (
  id int(11) NOT NULL auto_increment,
  softname varchar(50) NOT NULL default '',
  size varchar(8) NOT NULL default '',
  language varchar(10) NOT NULL default '',
  softtype varchar(10) NOT NULL default '',
  platform varchar(50) NOT NULL default 'ƽ̨',
  date date NOT NULL default '0000-00-00',
  downhit int(11) NOT NULL default '0',
  browsehit int(11) NOT NULL default '0',
  level varchar(10) NOT NULL default '0',
  email varchar(30) NOT NULL default '',
  httpurl varchar(50) NOT NULL default '0',
  memo text NOT NULL,
  filename varchar(25) NOT NULL default '',
  pubfile tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_download`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_guestbook`
#

CREATE TABLE mango_guestbook (
  dateandtime varchar(25) NOT NULL default '',
  vnickname varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default 'No_email',
  url varchar(200) NOT NULL default 'http://',
  topic varchar(200) NOT NULL default '',
  body text NOT NULL,
  host varchar(100) NOT NULL default '',
  ip varchar(15) NOT NULL default '127.0.0.1',
  id int(4) NOT NULL auto_increment,
  whisper char(3) NOT NULL default 'no',
  parentid tinyint(4) NOT NULL default '0',
  child tinyint(4) NOT NULL default '0',
  rootid tinyint(4) NOT NULL default '0',
  layer tinyint(4) NOT NULL default '1',
  orders tinyint(4) NOT NULL default '0',
  vnumber tinyint(2) unsigned zerofill NOT NULL default '00',
  expression varchar(10) NOT NULL default '',
  length int(11) NOT NULL default '0',
  hits int(11) NOT NULL default '0',
  mastersn tinyint(2) unsigned zerofill NOT NULL default '00',
  PRIMARY KEY  (id),
  KEY parentid (parentid,child,rootid,layer,orders),
  KEY vnumber (vnumber),
  KEY mastersn (mastersn)
) TYPE=MyISAM;

#
# ݿ `mango_guestbook`
#

INSERT INTO mango_guestbook VALUES ('2002-12-13 11:42:23 AM', 'ÿ', '', 'http://', 'Ƿ㷨', 'Ƶķ㷨ʿ', '', '127.0.0.1', 1, 'no', 0, 1, 1, 1, 0, 60, 'smiley.gif', 18, 2, 60);
INSERT INTO mango_guestbook VALUES ('2002-12-13 11:42:46 AM', 'ÿ', '', 'http://', 'ظ: Ƿ㷨', 'Ƶķ㷨ʿ', '', '127.0.0.1', 2, 'no', 1, 0, 1, 2, 1, 60, 'smiley.gif', 18, 1, 60);
INSERT INTO mango_guestbook VALUES ('2002-12-24 18:06:50 PM', 'ÿ', '', 'http://', 'sdfsdf', 'sdfsdf', '', '127.0.0.1', 3, 'no', 0, 1, 3, 1, 0, 60, 'smiley.gif', 6, 1, 60);
INSERT INTO mango_guestbook VALUES ('2002-12-24 18:06:57 PM', 'ÿ', '', 'http://', 'dsfsdfs', 'dfsdfsdf', '', '127.0.0.1', 4, 'no', 0, 0, 4, 1, 0, 60, 'smiley.gif', 8, 0, 60);
INSERT INTO mango_guestbook VALUES ('2002-12-24 18:07:09 PM', 'ÿ', '', 'http://', 'ظ: sdfsdf', 'sdfsdf', '', '127.0.0.1', 5, 'no', 3, 0, 3, 2, 1, 60, '14.gif', 6, 0, 60);
INSERT INTO mango_guestbook VALUES ('2002-12-25 11:43:50 AM', '', '', 'http://', 'dsfsd', 'sdfsdf', '', '127.0.0.1', 6, 'no', 0, 0, 6, 1, 0, 03, 'smiley.gif', 6, 1, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:22:58 PM', '', '', 'http://', 'sdf', 'fsf', '', '127.0.0.1', 7, 'no', 0, 0, 7, 1, 0, 03, 'smiley.gif', 3, 0, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:09 PM', '', '', 'http://', 'fsdfsd', 'fasdf', '', '127.0.0.1', 8, 'no', 0, 0, 8, 1, 0, 03, 'smiley.gif', 5, 0, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:13 PM', '', '', 'http://', 'sadf', 'sdfsdf', '', '127.0.0.1', 9, 'no', 0, 0, 9, 1, 0, 03, 'smiley.gif', 6, 0, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:17 PM', '', '', 'http://', 'asdfsd', 'fasdf', '', '127.0.0.1', 10, 'no', 0, 0, 10, 1, 0, 03, 'smiley.gif', 5, 0, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:22 PM', '', '', 'http://', 'sadfsdf', 'sadfsdf', '', '127.0.0.1', 11, 'no', 0, 0, 11, 1, 0, 03, 'smiley.gif', 7, 0, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:26 PM', '', '', 'http://', 'sdfsdf', 'sdfsdf', '', '127.0.0.1', 12, 'no', 0, 0, 12, 1, 0, 03, 'smiley.gif', 6, 0, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:32 PM', '', '', 'http://', 'sdfsdfsdf', 'sdfsf', '', '127.0.0.1', 13, 'no', 0, 0, 13, 1, 0, 03, 'smiley.gif', 5, 2, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:44 PM', '', '', 'http://', 'sdfsdf', 'adfsdf', '', '127.0.0.1', 14, 'no', 0, 0, 14, 1, 0, 03, 'smiley.gif', 6, 1, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:48 PM', '', '', 'http://', 'sdfsdf', 'sdfsdf', '', '127.0.0.1', 15, 'no', 0, 1, 15, 1, 0, 03, 'smiley.gif', 6, 3, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 20:16:35 PM', '', 'fcy@km169.com', 'http://', 'ظ: fsdfs', 'dfsdfsdf', '', '127.0.0.1', 28, 'no', 20, 0, 20, 2, 1, 32, 'smiley.gif', 8, 0, 32);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:23:57 PM', '', '', 'http://', 'sdfasfd', 'sdfsdf', '', '127.0.0.1', 17, 'no', 0, 0, 17, 1, 0, 03, 'smiley.gif', 6, 1, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:24:07 PM', '', '', 'http://', 'dsfasdf', 'sdfsdf', '', '127.0.0.1', 18, 'no', 0, 2, 18, 1, 0, 03, 'smiley.gif', 6, 4, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:24:11 PM', '', '', 'http://', 'afsdfas', 'fsdfsd', '', '127.0.0.1', 19, 'no', 0, 0, 19, 1, 0, 03, 'smiley.gif', 6, 3, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:24:15 PM', '', '', 'http://', 'fsdfs', 'dfsdfsdf', '', '127.0.0.1', 20, 'no', 0, 2, 20, 1, 0, 03, 'smiley.gif', 8, 5, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:27:04 PM', 'ÿ', '', 'http://', 'sdfsd', 'fsdf', '', '127.0.0.1', 21, 'no', 0, 1, 21, 1, 0, 60, 'smiley.gif', 4, 3, 60);
INSERT INTO mango_guestbook VALUES ('2002-12-27 18:52:32 PM', '', '', 'http://', 'faf', 'sdf', '', '127.0.0.1', 27, 'no', 0, 1, 27, 1, 0, 03, 'smiley.gif', 3, 2, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 20:16:40 PM', '', 'fcy@km169.com', 'http://', 'ظ: faf', 'sdf', '', '127.0.0.1', 29, 'no', 27, 1, 27, 2, 1, 32, 'smiley.gif', 3, 1, 32);
INSERT INTO mango_guestbook VALUES ('2002-12-27 17:54:50 PM', '', '', 'http://', 'ظ: dsfasdf', 'sdfsdf', '', '127.0.0.1', 24, 'no', 18, 1, 18, 2, 1, 03, 'smiley.gif', 6, 1, 03);
INSERT INTO mango_guestbook VALUES ('2002-12-27 20:16:46 PM', '', 'fcy@km169.com', 'http://', 'ظ: ظ: faf', 'sdf', '', '127.0.0.1', 30, 'no', 29, 0, 27, 3, 2, 32, 'smiley.gif', 3, 0, 32);
INSERT INTO mango_guestbook VALUES ('2002-12-27 20:16:52 PM', '', 'fcy@km169.com', 'http://', 'dfasdf', 'sdfasdf', '', '127.0.0.1', 31, 'no', 0, 0, 31, 1, 0, 32, 'smiley.gif', 7, 1, 32);
INSERT INTO mango_guestbook VALUES ('2003-01-21 09:47:37 AM', 'ÿ', '', 'http://', 'cxvxcv', 'xcvxcv', '', '127.0.0.1', 32, 'no', 0, 0, 32, 1, 0, 60, 'smiley.gif', 6, 1, 60);
# --------------------------------------------------------

#
# ݱĽṹ `mango_infor`
#

CREATE TABLE mango_infor (
  name varchar(8) NOT NULL default '',
  subject varchar(50) NOT NULL default '',
  memo text NOT NULL,
  dw varchar(50) NOT NULL default '',
  date date NOT NULL default '0000-00-00',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  id int(11) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;

#
# ݿ `mango_infor`
#

INSERT INTO mango_infor VALUES ('', 'dfsdf', 'sdfsdf', 'Ӫ', '2002-12-27', 03, 1);
INSERT INTO mango_infor VALUES ('', 'zzzzzzzzzwerwer', 'sdfsdfwerwe', 'Ӫ', '2002-12-27', 03, 2);
INSERT INTO mango_infor VALUES ('', 'fsdf', 'sdf', 'Ӫ', '2002-12-27', 03, 3);
# --------------------------------------------------------

#
# ݱĽṹ `mango_invite`
#

CREATE TABLE mango_invite (
  id int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  memo text NOT NULL,
  snto tinyint(2) unsigned zerofill NOT NULL default '00',
  readed tinyint(1) NOT NULL default '0',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  username varchar(8) NOT NULL default '',
  senddate date NOT NULL default '0000-00-00',
  toname varchar(8) NOT NULL default '',
  whys varchar(30) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_invite`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_logininfo`
#

CREATE TABLE mango_logininfo (
  id tinyint(2) NOT NULL auto_increment,
  ip varchar(20) NOT NULL default '',
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_logininfo`
#

INSERT INTO mango_logininfo VALUES (1, '127.0.0.1', '2002-04-08 14:07:31', 01);
INSERT INTO mango_logininfo VALUES (2, '127.0.0.1', '0000-00-00 00:00:00', 02);
INSERT INTO mango_logininfo VALUES (3, '127.0.0.1', '2003-01-21 14:18:38', 03);
INSERT INTO mango_logininfo VALUES (55, '127.0.0.1', '2002-04-08 14:27:37', 55);
# --------------------------------------------------------

#
# ݱĽṹ `mango_meet`
#

CREATE TABLE mango_meet (
  id int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  initiator varchar(20) NOT NULL default '',
  pubdate date NOT NULL default '0000-00-00',
  meetdt varchar(22) NOT NULL default 'ʱδ',
  address varchar(50) NOT NULL default '',
  memo text NOT NULL,
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  hit int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_meet`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_message`
#

CREATE TABLE mango_message (
  id int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  form varchar(10) NOT NULL default '',
  msgto varchar(10) NOT NULL default '',
  writeback tinyint(1) NOT NULL default '0',
  wbman varchar(10) NOT NULL default '',
  readed tinyint(1) NOT NULL default '0',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  senddt datetime NOT NULL default '0000-00-00 00:00:00',
  memo text,
  msgtoid tinyint(2) unsigned zerofill NOT NULL default '00',
  inceptdel tinyint(1) NOT NULL default '0',
  senddel tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_message`
#

INSERT INTO mango_message VALUES (1, 'fsdfsdf', '', '', 0, 'nobody', 0, 03, '2002-12-14 15:54:45', 'sdfsdf', 01, 0, 0);
INSERT INTO mango_message VALUES (2, 'fsdfds', '', 'С', 0, 'nobody', 0, 03, '2002-12-25 14:46:46', 'fdsfsdf', 02, 0, 0);
INSERT INTO mango_message VALUES (3, 'df', '', 'Ǯ̫', 0, 'nobody', 0, 03, '2002-12-25 14:47:01', 'df', 32, 0, 0);
INSERT INTO mango_message VALUES (4, 'dfsdf', '', '', 0, 'nobody', 0, 03, '2002-12-25 14:47:15', 'dfsdf', 01, 0, 1);
INSERT INTO mango_message VALUES (5, 'dfsdf', '', 'С', 0, 'nobody', 0, 03, '2002-12-25 14:47:15', 'dfsdf', 02, 0, 1);
INSERT INTO mango_message VALUES (7, 'sdfsd', '', '', 0, 'nobody', 0, 03, '2002-12-26 08:37:22', 'fsdf', 01, 0, 1);
INSERT INTO mango_message VALUES (8, 'sdfg', '', 'С', 0, 'nobody', 0, 03, '2002-12-26 08:38:09', 'sdfg', 02, 0, 1);
INSERT INTO mango_message VALUES (10, 'zxc', '', 'С', 0, 'nobody', 0, 03, '2002-12-27 17:12:33', 'zxc', 02, 0, 1);
INSERT INTO mango_message VALUES (11, 'sdfsd', '', '', 0, 'nobody', 0, 03, '2002-12-27 17:56:11', 'fsdfs', 01, 0, 1);
INSERT INTO mango_message VALUES (12, 'sdfsd', '', 'С', 0, 'nobody', 0, 03, '2002-12-27 17:56:11', 'fsdfs', 02, 0, 1);
INSERT INTO mango_message VALUES (15, 'sdfsdf', '', '', 0, 'nobody', 0, 03, '2002-12-27 17:56:17', 'sdfsdf', 01, 0, 1);
INSERT INTO mango_message VALUES (16, 'sdfsdf', '', 'С', 0, 'nobody', 0, 03, '2002-12-27 17:56:17', 'sdfsdf', 02, 0, 1);
INSERT INTO mango_message VALUES (18, 'sdfsdf', '', 'Ǯ̫', 0, 'nobody', 0, 03, '2002-12-27 17:56:17', 'sdfsdf', 32, 0, 1);
INSERT INTO mango_message VALUES (19, 'sdfsdf', '', '', 0, 'nobody', 0, 03, '2002-12-27 17:56:17', 'sdfsdf', 01, 0, 1);
INSERT INTO mango_message VALUES (20, 'sdfsdf', '', 'С', 0, 'nobody', 0, 03, '2002-12-27 17:56:17', 'sdfsdf', 02, 0, 1);
INSERT INTO mango_message VALUES (22, 'sdfsdf', '', 'Ǯ̫', 0, 'nobody', 1, 03, '2002-12-27 17:56:17', 'sdfsdf', 32, 0, 1);
INSERT INTO mango_message VALUES (23, 'sd', '', '', 0, 'nobody', 0, 03, '2002-12-27 17:56:23', 'asdas', 01, 0, 1);
INSERT INTO mango_message VALUES (24, 'sd', '', 'С', 0, 'nobody', 0, 03, '2002-12-27 17:56:23', 'asdas', 02, 0, 1);
INSERT INTO mango_message VALUES (26, 'sd', '', 'Ǯ̫', 0, 'nobody', 0, 03, '2002-12-27 17:56:23', 'asdas', 32, 0, 1);
INSERT INTO mango_message VALUES (27, 'fsdf', '', '', 0, 'nobody', 0, 03, '2002-12-27 17:56:29', 'dfdf', 01, 0, 1);
INSERT INTO mango_message VALUES (28, 'fsdf', '', 'С', 0, 'nobody', 0, 03, '2002-12-27 17:56:29', 'dfdf', 02, 0, 1);
INSERT INTO mango_message VALUES (30, 'fsdf', '', 'Ǯ̫', 0, 'nobody', 0, 03, '2002-12-27 17:56:29', 'dfdf', 32, 0, 1);
INSERT INTO mango_message VALUES (31, 'cfsf', '', '', 0, 'nobody', 0, 03, '2002-12-27 18:01:39', 'sdf', 01, 0, 0);
# --------------------------------------------------------

#
# ݱĽṹ `mango_news`
#

CREATE TABLE mango_news (
  id int(11) NOT NULL auto_increment,
  newsfrom varchar(100) NOT NULL default '41197Ӫ',
  title varchar(50) NOT NULL default '',
  memo text NOT NULL,
  author varchar(20) NOT NULL default '',
  date date NOT NULL default '0000-00-00',
  publisher varchar(20) NOT NULL default '',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;

#
# ݿ `mango_news`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_password`
#

CREATE TABLE mango_password (
  ID tinyint(2) unsigned zerofill NOT NULL auto_increment,
  USERID varchar(16) NOT NULL default 'GUEST',
  PWD varchar(16) NOT NULL default 'GUEST',
  QX varchar(5) NOT NULL default 'GUEST',
  NUMBER tinyint(2) unsigned zerofill NOT NULL default '55',
  name varchar(10) NOT NULL default '',
  PRIMARY KEY  (ID),
  UNIQUE KEY ID_2 (ID,USERID),
  KEY ID (ID,USERID,NUMBER)
) TYPE=MyISAM;

#
# ݿ `mango_password`
#

INSERT INTO mango_password VALUES (01, 'admin', 'admin', 'super', 03, 'Ա');
INSERT INTO mango_password VALUES (02, 'guest', 'guest', 'guest', 60, 'guest');
INSERT INTO mango_password VALUES (03, 'ss', 'ss', 'tx', 32, 'dsaf');
INSERT INTO mango_password VALUES (04, 'xxxx', 'xxxx', 'tx', 32, 'Ǯ̫');
INSERT INTO mango_password VALUES (05, 'zzzzzzzz', 'asdff', 'super', 32, 'Ǯ̫');
# --------------------------------------------------------

#
# ݱĽṹ `mango_polls`
#

CREATE TABLE mango_polls (
  pollid int(11) NOT NULL auto_increment,
  polltitle char(60) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  pollsdate date NOT NULL default '0000-00-00',
  PRIMARY KEY  (pollid)
) TYPE=MyISAM;

#
# ݿ `mango_polls`
#

INSERT INTO mango_polls VALUES (3, 'sdfasdf', 1043129870, '2003-01-21');
INSERT INTO mango_polls VALUES (4, 'sdfasdfdsa', 1043129897, '2003-01-21');
INSERT INTO mango_polls VALUES (5, 'fdasdf', 1043129909, '2003-01-21');
# --------------------------------------------------------

#
# ݱĽṹ `mango_pollsdata`
#

CREATE TABLE mango_pollsdata (
  pollid int(11) NOT NULL default '0',
  optiontext char(50) NOT NULL default '',
  optioncount int(11) NOT NULL default '0',
  voteid int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# ݿ `mango_pollsdata`
#

INSERT INTO mango_pollsdata VALUES (3, 'sdfasd', 0, 1);
INSERT INTO mango_pollsdata VALUES (3, 'fsdfasdf', 0, 2);
INSERT INTO mango_pollsdata VALUES (4, 'fasdfasdf', 0, 1);
INSERT INTO mango_pollsdata VALUES (4, 'asdfasdf', 0, 6);
INSERT INTO mango_pollsdata VALUES (5, 'asdfasdf', 1, 1);
INSERT INTO mango_pollsdata VALUES (5, 'asdfasdf', 0, 2);
INSERT INTO mango_pollsdata VALUES (5, 'dfasdf', 0, 3);
INSERT INTO mango_pollsdata VALUES (5, 'adfasdf', 0, 4);
INSERT INTO mango_pollsdata VALUES (5, 'asdfasdf', 0, 5);
INSERT INTO mango_pollsdata VALUES (5, 'sdfsad', 0, 6);
INSERT INTO mango_pollsdata VALUES (5, 'fsdf', 0, 7);
INSERT INTO mango_pollsdata VALUES (5, 'fsdfa', 0, 8);
INSERT INTO mango_pollsdata VALUES (5, 'sdfasd', 0, 9);
INSERT INTO mango_pollsdata VALUES (5, 'asfasdf', 0, 10);
# --------------------------------------------------------

#
# ݱĽṹ `mango_pollsip`
#

CREATE TABLE mango_pollsip (
  pollid int(11) NOT NULL default '0',
  voteid int(11) NOT NULL default '0',
  votersip char(16) NOT NULL default '',
  timestamp int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# ݿ `mango_pollsip`
#

INSERT INTO mango_pollsip VALUES (5, 1, '127.0.0.1', 1043129922);
# --------------------------------------------------------

#
# ݱĽṹ `mango_pollslog`
#

CREATE TABLE mango_pollslog (
  logid int(11) NOT NULL auto_increment,
  pollid int(11) NOT NULL default '0',
  voteid int(11) NOT NULL default '0',
  votersid char(16) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (logid)
) TYPE=MyISAM;

#
# ݿ `mango_pollslog`
#

# --------------------------------------------------------

#
# ݱĽṹ `mango_schoolmate_info`
#

CREATE TABLE mango_schoolmate_info (
  studentnumber tinyint(2) unsigned zerofill NOT NULL default '00',
  name varchar(10) NOT NULL default '',
  nickname varchar(20) default '',
  gender varchar(5) NOT NULL default '',
  birthday varchar(15) NOT NULL default '1900-00-00',
  lcbirthday varchar(20) default '',
  constellation varchar(10) NOT NULL default '',
  attribute varchar(6) NOT NULL default 'Ф',
  bloodtype varchar(6) default NULL,
  icq varchar(15) default NULL,
  edulevel varchar(20) NOT NULL default 'ѧ',
  interest_taste varchar(100) default NULL,
  kidney varchar(100) default NULL,
  strongsuit varchar(100) default NULL,
  nation varchar(16) NOT NULL default '',
  familyseat varchar(20) NOT NULL default 'ͥڵ',
  fdwellplace varchar(100) NOT NULL default '',
  nativeplace varchar(20) default NULL,
  linkman varchar(10) default NULL,
  contactphone varchar(20) default NULL,
  zipcode varchar(10) NOT NULL default '',
  memo text,
  commonusephone varchar(20) default NULL,
  beeppager varchar(20) default NULL,
  mobiletelephone varchar(20) default NULL,
  worktelephone varchar(20) default NULL,
  email varchar(100) default NULL,
  otheremail varchar(255) default NULL,
  url varchar(100) default NULL,
  photo varchar(50) default NULL,
  homephone varchar(20) default NULL,
  occupation varchar(20) NOT NULL default 'ǰְҵ',
  nowcompany varchar(255) default NULL,
  oldcompany varchar(255) default NULL,
  corpsites varchar(100) default NULL,
  companyname varchar(255) default NULL,
  corpzipcode varchar(15) default NULL,
  corpaddress varchar(255) default NULL,
  business varchar(20) default 'ְ',
  maritalstatus varchar(6) NOT NULL default '',
  spouse varchar(30) NOT NULL default '',
  familymember varchar(255) NOT NULL default '',
  article int(11) NOT NULL default '0',
  oicq varchar(15) NOT NULL default '',
  PRIMARY KEY  (studentnumber),
  UNIQUE KEY studentnumber_2 (studentnumber),
  KEY studentnumber (studentnumber,name,gender,zipcode,homephone),
  KEY oicq (oicq)
) TYPE=MyISAM;

#
# ݿ `mango_schoolmate_info`
#

INSERT INTO mango_schoolmate_info VALUES (01, '', '', '', '2002310', '', '', 'Ф', NULL, NULL, 'ѧ', NULL, NULL, NULL, '0', 'ͥڵ', '10', NULL, 'С˫', '011-29588748', '321000', '', NULL, '', '', '', '', NULL, '', '', '', 'ǰְҵ', NULL, NULL, NULL, NULL, NULL, NULL, 'ְ', '', '', '', 0, '');
INSERT INTO mango_schoolmate_info VALUES (02, 'С', '', 'Ů', '19000625', '', '', 'Ф', NULL, NULL, 'ѧ', NULL, NULL, NULL, '0', 'ͥڵ', 'Ӣ˽234', NULL, '', '', '012-987654', '', NULL, '', '', '', '', NULL, '', '', '', 'ǰְҵ', NULL, NULL, NULL, NULL, NULL, NULL, 'ְ', '', '', '', 0, '');
INSERT INTO mango_schoolmate_info VALUES (03, '', '', '', '1982219', '', '', 'Ф', NULL, NULL, 'ѧ', NULL, NULL, NULL, '0', 'ͥڵ', 'йϺ', NULL, 'Ĵ', '0277-98745612', '654000', '', NULL, '', '', '', '', NULL, '', '', '', 'ǰְҵ', NULL, NULL, NULL, NULL, NULL, NULL, 'ְ', '', '', '', 36, '');
INSERT INTO mango_schoolmate_info VALUES (32, 'Ǯ̫', '', 'Ů', '', '', '', 'Ф', NULL, NULL, 'ѧ', NULL, NULL, NULL, '0', 'ͥڵ', '', NULL, '', '', '', '', NULL, '', '', '', 'fcy@km169.com', NULL, '', '', '', 'ǰְҵ', NULL, NULL, NULL, NULL, NULL, NULL, 'ְ', '', '', '', 4, '');
# --------------------------------------------------------

#
# ݱĽṹ `mango_searchman`
#

CREATE TABLE mango_searchman (
  id int(11) NOT NULL auto_increment,
  searchwho varchar(10) NOT NULL default '',
  memo text NOT NULL,
  date date NOT NULL default '0000-00-00',
  name varchar(10) NOT NULL default '',
  userid tinyint(2) unsigned zerofill NOT NULL default '00',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;

#
# ݿ `mango_searchman`
#

INSERT INTO mango_searchman VALUES (1, 'Ƶķ', 'Ƶķ㷨', '2002-12-13', 'ÿ', 60);
INSERT INTO mango_searchman VALUES (2, 'dfdf', 'sdfdsf', '2002-12-24', 'ÿ', 60);
INSERT INTO mango_searchman VALUES (3, 'dsfsd', 'dsfsdf', '2002-12-24', 'ÿ', 60);
INSERT INTO mango_searchman VALUES (4, 'fsd', 'fsdf', '2002-12-27', 'ÿ', 60);

    