SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;


CREATE DATABASE /*!32312 IF NOT EXISTS*/ `adsl`;
USE `adsl`;
CREATE TABLE "user" (
  "mid" int(15) NOT NULL auto_increment,
  "userid" varchar(5) default '0',
  "username" varchar(20) default NULL,
  "valiable" char(1) default 'Y',
  "addr" varchar(40) default '',
  "tele" varchar(8) default '',
  "mobile" varchar(11) default '',
  "expire" date default '2002-01-01',
  "ip" varchar(15) default '',
  "mac" varchar(17) default '',
  "mem" varchar(100) default '',
  PRIMARY KEY  ("mid")
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User details';
INSERT INTO `user` (`mid`,`userid`,`username`,`valiable`,`addr`,`tele`,`mobile`,`expire`,`ip`,`mac`,`mem`) VALUES (1,'1','ÖÜС½ã','Y','Ò»·¿Ò»Ìü201','','13929551809','2004-10-01','192.168.1.3','00-0e-a6-83-36-83','¿ª»§ÈÕÆÚ£º2002.9.4£¬µ¥¼Û£º40Ôª/ÔÂ'),(2,'2','101','Y','101','','','2004-11-01','192.168.1.5','00-0c-6e-f0-38-19','¿ª»§ÈÕÆÚ£º2002.9.4 µ¥¼Û£º40Ôª/ÔÂ'),(3,'3','¶­Éú','Y','¶ÔÃæһ¥','','13002076897','2004-10-22','192.168.1.4','00-d0-09-ee-ea-24','µ¥¼Û£º40Ôª/ÔÂ'),(4,'4','ÖÓÃ÷','Y','¶«Ô¼´ó½Ö17ºÅ402','84468154','13719298495','2004-11-07','192.168.1.6','00-0a-eb-01-50-fd','¿ª»§ÈÕÆÚ£º2002.9.15 µ¥¼Û£º40Ôª/ÔÂ'),(5,'5','°¢±ó','Y','¶«Ô¼´ó½Ö17ºÅ302','','13719187043','2004-11-20','192.168.1.7','10-00-03-c6-f4-b0','¿ª»§ÈÕÆÚ£º2002.10.29 µ¥¼Û£º40Ôª/ÔÂ'),(6,'6','·ëÉú','Y','´óÔºÒ»·¿Ò»Ìü501','84184287','','2004-11-01','192.168.1.10','00-40-D0-40-1F-C3','¿ª»§ÈÕÆÚ£º2002.11.10 µ¥¼Û£º40Ôª/ÔÂ'),(7,'7','·¢ÀÈ','Y','10.10ÔÝÍ£','84468224','','2004-10-27','192.168.1.13','00-e0-4c-05-e0-0b','¿ª»§ÈÕÆÚ£º2002.11.16 µ¥¼Û£º40Ôª/ÔÂ');
INSERT INTO `user` (`mid`,`userid`,`username`,`valiable`,`addr`,`tele`,`mobile`,`expire`,`ip`,`mac`,`mem`) VALUES (8,'8','502','Y','¶«Ô¼´ó½Ö25ºÅ502','','','2004-10-08','192.168.1.14','00-0d-61-96-06-2C','¿ª»§ÈÕÆÚ£º2002.11.16 µ¥¼Û£º40Ôª/ÔÂ'),(9,'9','ÎâÉú','Y','¶ÔÃæ302','','13570103375','2004-10-22','192.168.1.15','00-10-DC-F9-77-CE','¿ª»§ÈÕÆÚ£º2003.05.12 µ¥¼Û£º30Ôª/ÔÂ'),(10,'10','ÎâÉú','Y','¶ÔÃæ302','','13570103375','2004-10-22','192.168.1.16','00-A0-D1-D8-70-F4','¿ª»§ÈÕÆÚ£º2002.12.11 µ¥¼Û£º30Ôª/ÔÂ'),(11,'11','½­Éú','N','¶«Ô¼´ó½Ö28ºÅ401','','13570188246','2003-08-30','192.168.1.15','00-00-c0-13-0a-01','¿ª»§ÈÕÆÚ£º2002.12.30 µ¥¼Û£º50Ôª/ÔÂ'),(12,'12','ÕÅÎÄ','N','´óÔº402','84194641','','2003-09-15','192.168.1.14','','¿ª»§ÈÕÆÚ£º2003.3.19 µ¥¼Û£º40Ôª/ÔÂ'),(13,'13','ÕÅÎÄ','N','´óÔº402','84464340','','2003-07-20','192.168.1.16','','¿ª»§ÈÕÆÚ£º2003.3.20 µ¥¼Û£º40Ôª/ÔÂ'),(14,'14','501','Y','´óÔº403','','','2004-09-25','192.168.1.17','00-E0-4C-50-46-02','¿ª»§ÈÕÆÚ£º2003.3.24 µ¥¼Û£º40Ôª/ÔÂ');
INSERT INTO `user` (`mid`,`userid`,`username`,`valiable`,`addr`,`tele`,`mobile`,`expire`,`ip`,`mac`,`mem`) VALUES (15,'15','ÁõС½ã','Y','´óÔºÒ»·¿Ò»Ìü402','84196394','13533017152','2004-10-01','192.168.1.11','00-00-39-64-06-EE','¿ª»§ÈÕÆÚ£º2003.3.28 µ¥¼Û£º40Ôª/ÔÂ'),(16,'16','Ö£ÏþȺ','N','¶«Ô¼´ó½Ö17ºÅ404','84468284','','2003-07-12','192.168.1.12','00-05-5d-02-ec-71','¿ª»§ÈÕÆÚ£º2003.05.12   µ¥¼Û£º40Ôª/Ô  2003.07.12ÔÝÍ£'),(17,'17','ÖÓÃ÷','N','','84468154','','2003-08-02','192.168.1.6','00-0A-EB-01-50-FD','¿ª»§ÈÕÆÚ£º2003.06.02 µ¥¼Û£º30Ôª/ÔÂ'),(18,'18','102','N','102','84464624','','2003-08-01','192.168.1.18','00-0A-EB-21-A8-CE','¿ª»§ÈÕÆÚ£º2003.07.01 µ¥¼Û£º60Ôª/ÔÂ'),(19,'19','ÌÀС½ã','Y','302   192.168.1.12 52-54-ab--20-21-a7','','13825045348','2004-10-05','192.168.1.8','','¿ª»§ÈÕÆÚ£º2003.07.04 µ¥¼Û£º50Ôª/ÔÂ'),(20,'20','»Æ³¬','Y','¶«Ô¼´ó½Ö25ºÅ504·¿','34455661','13312803606','2004-10-12','192.168.1.9','00-40-05-14-a7-07','¿ª»§ÈÕÆÚ£º2003.07.06 µ¥¼Û£º40Ôª/ÔÂ'),(21,'21','ÁõÉú','N','ÁªÍ¨201    13570200018','84464041','13580369311','2004-03-12','192.168.1.20','192.168.1.20','¿ª»§ÈÕÆÚ£º2003.07.11 µ¥¼Û£º40Ôª/ÔÂ');
INSERT INTO `user` (`mid`,`userid`,`username`,`valiable`,`addr`,`tele`,`mobile`,`expire`,`ip`,`mac`,`mem`) VALUES (22,'22','304','N','25ºÅ304','','13016030747','2003-08-21','192.168.1.22','','¿ª»§ÈÕÆÚ£º2003.07.20 µ¥¼Û£º60Ôª/ÔÂ');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;