source: branches/feature-module-update/html/install/sql/add/dtb_mobile_kara_mail_mysql.sql @ 15079

Revision 15079, 527 bytes checked in by nanasess, 17 years ago (diff)

svn:mime-type application/x-httpd-php; charset=UTF-8 設定

  • Property svn:mime-type set to application/x-httpd-php; charset=UTF-8
Line 
1CREATE TABLE dtb_mobile_kara_mail (
2    kara_mail_id serial PRIMARY KEY,
3    session_id text NOT NULL,
4    token text NOT NULL,
5    next_url text NOT NULL,
6    create_date timestamp NOT NULL DEFAULT now(),
7    email text,
8    receive_date timestamp
9);
10
11CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token(64));
12CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date);
13CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date);
Note: See TracBrowser for help on using the repository browser.