Changeset 19986 for branches/version-2_5-dev/html/install/sql
- Timestamp:
- 2011/01/19 19:47:07 (13 years ago)
- Location:
- branches/version-2_5-dev/html/install/sql
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r19966 r19986 579 579 reminder smallint, 580 580 reminder_answer text, 581 salt text, 581 582 secret_key varchar(50) NOT NULL UNIQUE, 582 583 first_buy_date datetime, … … 791 792 login_id text NOT NULL, 792 793 password text NOT NULL, 794 salt text NOT NULL, 793 795 authority smallint NOT NULL, 794 796 rank int NOT NULL DEFAULT 0, -
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r19966 r19986 581 581 reminder smallint, 582 582 reminder_answer text, 583 salt text, 583 584 secret_key text NOT NULL UNIQUE, 584 585 first_buy_date timestamp, … … 793 794 login_id text NOT NULL, 794 795 password text NOT NULL, 796 salt text NOT NULL, 795 797 authority smallint NOT NULL, 796 798 rank int NOT NULL DEFAULT 0, -
branches/version-2_5-dev/html/install/sql/insert_data.sql
r19985 r19986 481 481 INSERT INTO dtb_mailtemplate (template_id, subject, header, footer, creator_id, del_flg, create_date, update_date) VALUES (5, 'お問い合わせを受け付けました', NULL, NULL, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 482 482 483 INSERT INTO dtb_member (member_id, name, department, login_id, password, authority, rank, work, del_flg, creator_id, update_date, create_date, login_date) VALUES (1, 'dummy', NULL, 'dummy', 'dummy', 0, 0, 1, 1, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL);483 INSERT INTO dtb_member (member_id, name, department, login_id, password, salt, authority, rank, work, del_flg, creator_id, update_date, create_date, login_date) VALUES (1, 'dummy', NULL, 'dummy', 'dummy', 'dummy', 0, 0, 1, 1, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL); 484 484 485 485 INSERT INTO dtb_module (module_id, module_code, module_name, sub_data, auto_update_flg, del_flg, create_date, update_date) VALUES (0, '0', 'patch', NULL, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); … … 1030 1030 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ZIP_DSN', 'DEFAULT_DSN', 8, '郵便番号専用DB'); 1031 1031 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_URL', 'HTTP_URL . USER_DIR', 9, 'ユーザー作成ページ等'); 1032 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('AUTH_ MAGIC', '"31eafcbd7a81d7b401a7fdc12bba047c02d1fae6"', 10, '認証用 magic');1032 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('AUTH_TYPE', '"HMAC"', 10, '認証方式'); 1033 1033 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_TEMPLATE_DIR', '"templates/"', 16, 'テンプレートファイル保存先'); 1034 1034 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_PACKAGE_DIR', '"packages/"', 17, 'テンプレートファイル保存先'); … … 1068 1068 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_RECOMMEND', '1', 61, 'おすすめ商品登録(有効:1 無効:0)'); 1069 1069 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_CLASS_REGIST', '1', 62, '商品規格登録(有効:1 無効:0)'); 1070 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_PASSWORD', '" UAhgGR3L"', 66, '会員登録変更(マイページ)パスワード用');1070 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_PASSWORD', '"******"', 66, '会員登録変更(マイページ)パスワード用'); 1071 1071 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIV_ADDR_MAX', '20', 67, '別のお届け先最大登録数'); 1072 1072 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_STATUS_MAX', '50', 70, '管理画面ステータス一覧表示件数');
Note: See TracChangeset
for help on using the changeset viewer.