File name: addrbook/adminsert.sub (1,557 bytes) Text file viewer v1.2
    1 : /* file: adminsert.sub
    2 : 
    3 :    주소록 생성 테이블 (author: 서광현)
    4 : 
    5 :    Copyright (c) 2001/02/22 by Wesoft
    6 :    All Rights Reserved.
    7 : */
    8 : 
    9 : ADDRBOOK_TABLE=
   10 : {[
   11 :  create table {$preTBname}{$id} (
   12 :     selno     int4      DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
   13 :     wdtime    char(19)  DEFAULT '' NOT NULL,
   14 :     wip       char(15)  DEFAULT '' NOT NULL,
   15 :     mdtime    char(19)  DEFAULT '' NOT NULL,
   16 :     mip       char(15)  DEFAULT '' NOT NULL,
   17 :     idtime    char(19)  DEFAULT '' NOT NULL,
   18 :     iip       char(15)  DEFAULT '' NOT NULL,
   19 : 
   20 :     name      char(30)  DEFAULT '' NOT NULL,
   21 :     birth     char(16)  DEFAULT '' NOT NULL,
   22 :     hdphone   char(16)  DEFAULT '' NOT NULL,
   23 :     hphone    char(16)  DEFAULT '' NOT NULL,
   24 :     hfax      char(16)  DEFAULT '' NOT NULL,
   25 :     homepage  char(40)  DEFAULT '' NOT NULL,
   26 :     email     char(40)  DEFAULT '' NOT NULL,
   27 :     hzipcode  char(7)   DEFAULT '' NOT NULL,
   28 :     haddr1    char(68)  DEFAULT '' NOT NULL,
   29 :     haddr2    char(50)  DEFAULT '' NOT NULL,
   30 : 
   31 :     office    char(40)  DEFAULT '' NOT NULL,
   32 :     buseo     char(20)  DEFAULT '' NOT NULL,
   33 :     position  char(10)  DEFAULT '' NOT NULL,
   34 :     ophone    char(16)  DEFAULT '' NOT NULL,
   35 :     ofax      char(16)  DEFAULT '' NOT NULL,
   36 :     ozipcode  char(7)   DEFAULT '' NOT NULL,
   37 :     oaddr1    char(68)  DEFAULT '' NOT NULL,
   38 :     oaddr2    char(50)  DEFAULT '' NOT NULL,
   39 :     memo      char(100) DEFAULT '' NOT NULL,
   40 :     delflag   char(1)   DEFAULT '' NOT NULL,
   41 : 
   42 :     KEY name(name),
   43 :     KEY office(office),
   44 :     KEY delflag(delflag)
   45 :  )
   46 : ]};
   47 : 
   48 : create_addrtable= strform(ADDRBOOK_TABLE);
   49 : return;
File name: addrbook/adminsert.sub (1,557 bytes) Wesoft Corp. ⓒ 2001 All rights reserved.