| 1 | CREATE 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 | |
|---|
| 9 | CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key); |
|---|
| 10 | CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value); |
|---|
| 11 | CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); |
|---|
| 12 | CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); |
|---|
| 13 | |
|---|
| 14 | INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_ext_session_id', '¥»¥Ã¥·¥ç¥óID´ÉÍý'); |
|---|
| 15 | INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'session_id', '¥»¥Ã¥·¥ç¥óID'); |
|---|
| 16 | INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_key', '¥Ñ¥é¥á¡¼¥¿Ì¾'); |
|---|
| 17 | INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_value', '¥Ñ¥é¥á¡¼¥¿ÃÍ'); |
|---|
| 18 | INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'url', 'URL'); |
|---|
| 19 | INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'create_date', 'ºîÀ®Æü»þ'); |
|---|
