| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(200) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | varchar(255) | Yes | NULL | |||
| litpic2 | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 8 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 82 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 35 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| action_id (Primary) | tinyint(3) | No | ||||
| parent_id | tinyint(3) | No | 0 | |||
| action_code | varchar(100) | No | ||||
| relevance | varchar(20) | No | ||||
| sortrank | int(11) | Yes | 100 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | action_id | 56 | A | No | |
| parent_id | BTREE | No | No | parent_id | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| log_id (Primary) | int(10) | No | ||||
| log_time | int(10) | No | 0 | |||
| user_id | tinyint(3) | No | 0 | |||
| log_info | varchar(255) | No | ||||
| ip_address | varchar(15) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | log_id | 31190 | A | No | |
| log_time | BTREE | No | No | log_time | 31190 | A | No | |
| user_id | BTREE | No | No | user_id | 2 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user_id (Primary) | smallint(5) | No | ||||
| user_name | varchar(60) | No | ||||
| varchar(60) | Yes | |||||
| password | varchar(32) | No | ||||
| add_time | int(11) | Yes | 0 | |||
| last_login | int(11) | Yes | 0 | |||
| last_ip | varchar(15) | Yes | ||||
| action_list | text | Yes | NULL | |||
| nav_list | text | Yes | NULL | |||
| lang_type | varchar(50) | Yes | ||||
| agency_id | smallint(5) | Yes | NULL | |||
| suppliers_id | smallint(5) | Yes | 0 | |||
| todolist | longtext | Yes | NULL | |||
| role_id | smallint(5) | Yes | NULL | |||
| admin_purview | int(11) | Yes | NULL | |||
| admin_quanxian | text | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_id | 2 | A | No | |
| user_name | BTREE | No | No | user_name | 2 | A | No | |
| agency_id | BTREE | No | No | agency_id | 2 | A | Yes |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 17 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| city_name | varchar(80) | Yes | NULL | |||
| sortrank | int(11) | Yes | 100 | |||
| adminid | int(11) | Yes | 0 | |||
| siteurl | varchar(255) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | smallint(5) | No | ||||
| parent_id | smallint(5) | No | 0 | |||
| code | varchar(30) | No | ||||
| type | varchar(10) | No | ||||
| store_range | varchar(255) | No | ||||
| store_dir | varchar(255) | No | ||||
| value | text | No | ||||
| sort_order | tinyint(3) | No | 1 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 16 | A | No | |
| code | BTREE | Yes | No | code | 16 | A | No | |
| parent_id | BTREE | No | No | parent_id | 1 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 | |||
| classid | text | Yes | NULL | |||
| product_id | text | Yes | NULL | |||
| product_attr_id | text | Yes | NULL | |||
| product_attr2_id | text | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 920 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 43 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| uid | int(11) | Yes | 0 | |||
| title | varchar(255) | Yes | NULL | |||
| typeid | int(11) | Yes | 0 | |||
| litpic | text | Yes | NULL | |||
| litpic_thumb | varchar(255) | Yes | NULL | |||
| imgalt | varchar(255) | Yes | NULL | |||
| brief | varchar(255) | Yes | NULL | |||
| content | text | Yes | NULL | |||
| color | varchar(255) | Yes | NULL | |||
| flags | varchar(255) | Yes | NULL | |||
| source | varchar(255) | Yes | NULL | |||
| writer | varchar(255) | Yes | NULL | |||
| click | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| arcrank | int(11) | Yes | 0 | |||
| iscover | int(11) | Yes | 0 | |||
| tuijian | int(11) | Yes | 0 | |||
| display | int(11) | Yes | 0 | |||
| adminid | int(11) | Yes | 0 | |||
| otherkey | text | Yes | NULL | |||
| tags | text | Yes | NULL | |||
| tagsid | text | Yes | NULL | |||
| title_seo | varchar(255) | Yes | NULL | |||
| keywords_seo | text | Yes | NULL | |||
| description_seo | text | Yes | NULL | |||
| jumpurl | varchar(200) | Yes | NULL | |||
| isstop | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| date (Primary) | date | No | 0000-00-00 | |||
| searchengine (Primary) | varchar(20) | No | ||||
| keyword (Primary) | varchar(90) | No | ||||
| count | mediumint(8) | No | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | date | 2547 | A | No | |
| searchengine | 7392 | A | No | |||||
| keyword | 1352770 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| typeid | int(11) | Yes | 0 | |||
| names | varchar(255) | Yes | NULL | |||
| links | varchar(255) | Yes | NULL | |||
| logos | varchar(255) | Yes | NULL | |||
| display | int(11) | Yes | 0 | |||
| addtime | varchar(50) | Yes | NULL | |||
| adminid | int(11) | Yes | 0 | |||
| sortrank | int(11) | Yes | 0 | |||
| cityid | int(11) | Yes | 0 |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 730 | A | No | |
| id | BTREE | No | No | id | 730 | A | No | |
| pid | 730 | A | Yes | |||||
| 730 | A | Yes | ||||||
| display | BTREE | No | No | display | 4 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 78 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 262 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 500 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | date | A | No | ||
| searchengine | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 96 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | sesskey | 4 | A | No | |
| expiry | BTREE | No | No | expiry | 4 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | sesskey | 0 | A | No | |
| expiry | BTREE | No | No | expiry | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 8 | A | No |
| Column | Type | Null | Default | Comments | MIME |
|---|
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 255 | A | No | |
| id | BTREE | No | No | id | 255 | A | No | |
| reid | BTREE | No | No | reid | 63 | A | No | |
| topid | BTREE | No | No | topid | 4 | A | No | |
| typelx | BTREE | No | No | typelx | 2 | A | No | |
| display | BTREE | No | No | display | 2 | A | No | |
| type_name | BTREE | No | No | type_name | 255 | A | No | |
| type_name_en | BTREE | No | No | type_name_en | 1 | A | Yes | |
| siteurl | BTREE | No | No | siteurl | 255 | A | Yes | |
| logo | BTREE | No | No | logo | 255 | A | Yes | |
| banner | BTREE | No | No | banner | 63 | A | Yes | |
| ispart | BTREE | No | No | ispart | 1 | A | Yes | |
| issend | BTREE | No | No | issend | 2 | A | Yes |