source: branches/rel/html/install/sql/add/dtb_mobile_ext_session_id_mysql.sql @ 12157

Revision 12157, 582 bytes checked in by uehara, 17 years ago (diff)
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(64));
10CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value(64));
11CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url(64));
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.