db_zh_tw_utf8.sql

支持中、英、繁三种语言； 3、提供9套风格任意转换； 4、内嵌全球免费可视电话系统

#
# 資料表的結構 `law_member_cat`
#

CREATE TABLE law_member_cat (
  catid int(12) NOT NULL auto_increment,
  pid int(12) default NULL,
  cat char(100) default NULL,
  xuhao int(4) default NULL,
  catpath char(255) default NULL,
  nums int(20) default NULL,
  PRIMARY KEY  (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_cat`
#

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

#
# 資料表的結構 `law_member_func`
#

CREATE TABLE law_member_func (
  id int(10) NOT NULL auto_increment,
  pid int(10) default NULL,
  menu char(50) default NULL,
  link char(100) default NULL,
  xuhao int(10) default NULL,
  used int(1) default NULL,
  intro char(255) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_func`
#

INSERT INTO law_member_func VALUES (13, 0, '會員設置', '', 1, 1, NULL);
INSERT INTO law_member_func VALUES (1, 13, '修改資料', 'member_modify.php', 6, 1, '');
INSERT INTO law_member_func VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO law_member_func VALUES (14, 0, '退出登錄', 'logout.php', 4, 1, NULL);
INSERT INTO law_member_func VALUES (16, 15, '文章發佈', 'member_fabu.php', 1, 1, '');
INSERT INTO law_member_func VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------

#
# 資料表的結構 `law_member_func_10`
#

CREATE TABLE law_member_func_10 (
  id int(10) NOT NULL auto_increment,
  pid int(10) default NULL,
  menu char(50) default NULL,
  link char(100) default NULL,
  xuhao int(10) default NULL,
  used int(1) default NULL,
  intro char(255) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_func_10`
#

INSERT INTO law_member_func_10 VALUES (13, 0, '會員設置', '', 1, 1, NULL);
INSERT INTO law_member_func_10 VALUES (1, 13, '修改資料', 'member_modify.php', 6, 1, '');
INSERT INTO law_member_func_10 VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO law_member_func_10 VALUES (14, 0, '退出登錄', 'logout.php', 4, 1, NULL);
INSERT INTO law_member_func_10 VALUES (16, 15, '文章發佈', 'member_fabu.php', 1, 1, '');
INSERT INTO law_member_func_10 VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------

#
# 資料表的結構 `law_member_notice`
#

CREATE TABLE law_member_notice (
  id int(12) NOT NULL auto_increment,
  membertypeid int(20) default NULL,
  title varchar(255) default NULL,
  body text,
  dtime int(11) default NULL,
  xuhao int(5) default NULL,
  cl int(20) default NULL,
  ifnew int(1) default NULL,
  ifred int(1) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_notice`
#

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

#
# 資料表的結構 `law_member_nums`
#

CREATE TABLE law_member_nums (
  id int(12) NOT NULL auto_increment,
  memberid int(50) default NULL,
  secureid int(50) default NULL,
  nums int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_nums`
#

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

#
# 資料表的結構 `law_member_regform`
#

CREATE TABLE law_member_regform (
  id int(12) NOT NULL auto_increment,
  formname varchar(200) default NULL,
  formcolname varchar(200) default NULL,
  mustfill int(1) default NULL,
  canrepeat int(1) default NULL,
  moveable int(1) default NULL,
  intro text,
  used int(1) default NULL,
  xuhao int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_regform`
#

INSERT INTO law_member_regform VALUES (1, '會員名稱', 'user', 1, 0, 0, '[5-20位元英文或數位]', 1, NULL);
INSERT INTO law_member_regform VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位元英文或數位]', 1, NULL);
INSERT INTO law_member_regform VALUES (3, '重複密碼', 'repass', 1, 1, 0, '[5-20位元英文或數位]', 1, NULL);
INSERT INTO law_member_regform VALUES (6, '企業名稱', 'company', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (7, '您的姓名', 'name', 1, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (8, '性　　別', 'sex', 1, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (10, '所在地區', 'zoneid', 1, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (11, '所屬行業', 'catid', 1, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (13, '電話號碼', 'tel', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (14, '手機號碼', 'mov', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (15, '傳真號碼', 'fax', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (16, '郵遞區號', 'postcode', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (17, '電子郵件', 'email', 1, 1, 0, '[請輸入正確的電子郵件]', 1, NULL);
INSERT INTO law_member_regform VALUES (18, '網站網址', 'url', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (19, '證件類型', 'passtype', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (20, '證件號碼', 'passcode', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (21, 'QQ號碼', 'qq', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (22, 'MSN號碼', 'msn', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (24, '備註留言', 'bz', 0, 1, 1, '', 0, NULL);
# --------------------------------------------------------

#
# 資料表的結構 `law_member_regform_10`
#

CREATE TABLE law_member_regform_10 (
  id int(12) NOT NULL auto_increment,
  formname varchar(200) default NULL,
  formcolname varchar(200) default NULL,
  mustfill int(1) default NULL,
  canrepeat int(1) default NULL,
  moveable int(1) default NULL,
  intro text,
  used int(1) default NULL,
  xuhao int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_regform_10`
#

INSERT INTO law_member_regform_10 VALUES (1, '會 員 名', 'user', 1, 0, 0, '[5-20位元英文或數位]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位元英文或數位]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (3, '重複密碼', 'repass', 1, 1, 0, '[5-20位元英文或數位]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (6, '企業名稱', 'company', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (7, '會員姓名', 'name', 1, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (8, '您的稱呼', 'sex', 1, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (10, '所在地區', 'zoneid', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (11, '所屬行業', 'catid', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (13, '電話號碼', 'tel', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (14, '手機號碼', 'mov', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (15, '傳真號碼', 'fax', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (16, '郵遞區號', 'postcode', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (17, '電子郵件', 'email', 1, 1, 0, '[請輸入正確的電子郵件]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (18, '網站網址', 'url', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (19, '證件類型', 'passtype', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (20, '證件號碼', 'passcode', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (21, 'QQ號碼', 'qq', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (22, 'MSN號碼', 'msn', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (24, '備註留言', 'bz', 0, 1, 1, '', 0, 0);
# --------------------------------------------------------

#
# 資料表的結構 `law_member_rights`
#

CREATE TABLE law_member_rights (
  id int(12) NOT NULL auto_increment,
  memberid int(50) default NULL,
  secureid int(50) default NULL,
  securetype char(100) default NULL,
  secureset int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_rights`
#

INSERT INTO law_member_rights VALUES (10, 1, 7, 'func', 0);
INSERT INTO law_member_rights VALUES (9, 1, 4, 'con', 0);
INSERT INTO law_member_rights VALUES (8, 1, 3, 'menu', 0);
INSERT INTO law_member_rights VALUES (7, 1, 2, 'func', 0);
INSERT INTO law_member_rights VALUES (6, 1, 6, 'func', 0);
INSERT INTO law_member_rights VALUES (11, 1, 8, 'func', 0);
INSERT INTO law_member_rights VALUES (12, 1, 9, 'func', 0);
INSERT INTO law_member_rights VALUES (13, 1, 10, 'func', 0);
# --------------------------------------------------------

#
# 資料表的結構 `law_member_type`
#

CREATE TABLE law_member_type (
  membertypeid int(6) NOT NULL auto_increment,
  membertype varchar(100) default NULL,
  memberprop int(1) NOT NULL default '0',
  ifcanreg int(1) default NULL,
  ifchecked int(1) default NULL,
  regxy text,
  regmail text,
  expday int(8) default NULL,
  startcent int(20) default NULL,
  endcent int(20) default NULL,
  PRIMARY KEY  (membertypeid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_type`
#

INSERT INTO law_member_type VALUES (10, '普通會員', 0, 1, 1, '', '{#name#}{#sex#},您好!\r\n\r\n感謝您在本站註冊!\r\n\r\n會員名: {#user#}\r\n密碼: {#password#}\r\n\r\n網址:http://', 0, 0, 0);
# --------------------------------------------------------

#
# 資料表的結構 `law_member_zone`
#

CREATE TABLE law_member_zone (
  catid int(12) NOT NULL auto_increment,
  pid int(12) default NULL,
  cat char(50) default NULL,
  xuhao int(4) default NULL,
  catpath char(255) default NULL,
  PRIMARY KEY  (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `law_member_zone`
#