source: branches/version-2/html/install/sql/add/dtb_mobile_ext_session_id_pgsql.sql @ 18561

Revision 18561, 557 bytes checked in by kajiwara, 14 years ago (diff)

Ver2.4.3にアップデート

  • Property svn:mime-type set to application/x-httpd-php; charset=UTF-8
Line 
1CREATE TABLE dtb_mobile_ext_session_id (
2    session_id text NOT NULL,
3    param_key text,
4    param_value text,
5    url text,
6    create_date timestamp NOT NULL DEFAULT now()
7);
8
9CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key);
10CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value);
11CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url);
12CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date);
13
Note: See TracBrowser for help on using the repository browser.