Skip to content

Instantly share code, notes, and snippets.

@kurozumi

kurozumi/dtb_member.sql

Created June 8, 2015 08:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kurozumi/b918a7ec12f8d4110560 to your computer and use it in GitHub Desktop.
Save kurozumi/b918a7ec12f8d4110560 to your computer and use it in GitHub Desktop.
Download ZIP
【EC-CUBE2.13】メンバー管理の項目を住所と電話番号とメールアドレスを追加する方法(SQL)
Raw
dtb_member.sql
ALTER TABLE dtb_member ADD zip01 text;
ALTER TABLE dtb_member ADD zip02 text;
ALTER TABLE dtb_member ADD pref smallint(6) DEFAULT NULL;
ALTER TABLE dtb_member ADD addr01 text;
ALTER TABLE dtb_member ADD addr02 text;
ALTER TABLE dtb_member ADD email text NOT NULL;
ALTER TABLE dtb_member ADD tel01 text;
ALTER TABLE dtb_member ADD tel02 text;
ALTER TABLE dtb_member ADD tel03 text;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment