source: temp/branches/mobile/html/install/sql/add/dtb_mobile_kara_mail_mysql.sql @ 11406

CREATE TABLE dtb_mobile_kara_mail (
    kara_mail_id serial PRIMARY KEY,
    session_id text NOT NULL,
    token text NOT NULL,
    next_url text NOT NULL,
    create_date timestamp NOT NULL DEFAULT now(),
    email text,
    receive_date timestamp
);

CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token(64));
CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date);
CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date);

INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_kara_mail', '¶õ¥á¡¼¥ë´ÉÍý');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'kara_mail_id', '¶õ¥á¡¼¥ë´ÉÍýID');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'session_id', '¥»¥Ã¥·¥ç¥óID');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'token', '¥È¡¼¥¯¥ó');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'next_url', '¼¡¥Ú¡¼¥¸URL');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'create_date', 'ºîÀ®Æü»þ');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'email', '¥á¡¼¥ë¥¢¥É¥ì¥¹');
INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'receive_date', '¼õ¿®Æü»þ');