-- MySQL dump 9.11
--
-- Host: localhost    Database: webhost
-- ------------------------------------------------------
-- Server version	4.0.20

--
-- Table structure for table `bill_mijin`
--

CREATE TABLE bill_mijin (
  idx int(11) NOT NULL auto_increment,
  companyNum varchar(30) NOT NULL default '',
  companyName varchar(50) NOT NULL default '',
  chiefName varchar(30) NOT NULL default '',
  companyAddr varchar(200) NOT NULL default '',
  opt_1 varchar(50) NOT NULL default '',
  opt_2 varchar(50) NOT NULL default '',
  limitdate varchar(10) NOT NULL default '',
  leftpoint smallint(5) unsigned NOT NULL default '0',
  pwd varchar(10) NOT NULL default '',
  joindate varchar(10) NOT NULL default '',
  lastbilldate varchar(10) NOT NULL default '',
  sealfilename varchar(50) NOT NULL default '',
  PRIMARY KEY  (idx),
  UNIQUE KEY companynumuniq (companyNum)
) TYPE=MyISAM;

--
-- Dumping data for table `bill_mijin`
--

INSERT INTO bill_mijin VALUES (1,'502--10--34984','미진소프트','이은희','대구 수성구 범어3동 1425','소매','소프트웨어/컴퓨터','',998,'8680','','2006-03-09','');
INSERT INTO bill_mijin VALUES (5,'502-18-70308','미진소프트','정일영','대구 수성구 범어동 1425 2층','소매','컴퓨터,주변기기/소프트웨어','',86,'8680','2006-03-10','2006-03-13','');
INSERT INTO bill_mijin VALUES (6,'314-09-55260','이레테크','김남주','대전 서구 복수동 275-15','도소매서비스','컴퓨터외','',100,'','2006-03-10','','');
INSERT INTO bill_mijin VALUES (7,'129-28-75562','월드쎄미콘','유선화','경기 성남시 중원구 성남동 4109번지','도매','무역(반도체장비부품)','',99,'','2006-03-10','2006-03-10','');
INSERT INTO bill_mijin VALUES (8,'134-22-41102','한빛통신','장인숙','경기 안산시 상록구 일동 595','서비스','도급(인터넷전화)','',100,'4212','2006-03-11','','');
INSERT INTO bill_mijin VALUES (9,'119-01-56483','탑','ㅇㅍ뉼ㅇㄴ','','ㅊㅌㅍㅊㅍㅊ','ㅊㅍ','',99,'','2006-03-11','2006-03-11','');
INSERT INTO bill_mijin VALUES (10,'417-81-30910','웨이건설(주)','김 병 일','전남 여수시 안산동 725-16','건설업','토공사,철근콘크리트공사','',99,'','2006-03-14','2006-03-14','');
INSERT INTO bill_mijin VALUES (11,'137-12-30380','원식품','한경환','인천 서구 석남동 223-651 10-104','도소매,제조','과일및채소절임식품','',99,'hk4867','2006-03-14','2006-03-14','');
INSERT INTO bill_mijin VALUES (12,'502-10-34984','미진소프트','이은희','대구 수성구 범어동 1425 2층','소매','컴퓨터,주변기기/소프트웨어','',78,'','2006-03-14','2006-03-23','');
INSERT INTO bill_mijin VALUES (13,'108-08-78337','i and c','정상균','경기 파주시 교하읍 동문2차아파트 208/1406','제조','cd제작','',98,'1148711','2006-03-15','2006-03-15','');
INSERT INTO bill_mijin VALUES (14,'217-81-17563','인터레브(주)','윤승욱','서울 강남구 역삼1동 828-10 올림피아센터 B1-17','도매','무선통신기기','',99,'','2006-03-16','2006-03-16','');
INSERT INTO bill_mijin VALUES (15,'219-02-20943','기분좋은날동부익스프레스','장경숙','서울 송파구 풍납동 505-7번지','운수','이사화물','',99,'js5114','2006-03-16','2006-03-16','');
INSERT INTO bill_mijin VALUES (16,'135-10-51838','CADLAND','신성호','경기 용인시 양지면 양지리 233-1','서비스','전자회로판설계','',99,'ssh532317','2006-03-17','2006-03-17','');