===数据库 topofor1_cnc1 == 表的结构 AreaGroupBlockTypes |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**btID**//|int(10) |否|0 == 转存表中的数据 AreaGroupBlockTypes == 表的结构 AreaGroupBlockTypes |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**btID**//|int(10) |否|0 == 表的结构 AreaGroups |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |agPermissions|varchar(64)|否| == 转存表中的数据 AreaGroups == 表的结构 AreaGroups |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |agPermissions|varchar(64)|否| == 表的结构 Areas |------ |字段|类型|空|默认 |------ |//**arID**//|int(10) |否| |cID|int(10) |否|0 |arHandle|varchar(255)|否| |arOverrideCollectionPermissions|tinyint(1)|否|0 |arInheritPermissionsFromAreaOnCID|int(10) |否|0 == 转存表中的数据 Areas |1|1|Header Nav|0|0 |2|1|Header|0|0 |3|1|Sidebar|0|0 |4|1|Main|0|0 |5|2|Header Nav|0|0 |6|2|Header|0|0 |7|2|Sidebar|0|0 |8|2|Main|0|0 |9|64|Header Nav|0|0 |10|64|Header|0|0 |11|64|Sidebar|0|0 |12|64|Main|0|0 |13|65|Header Nav|0|0 |14|65|Header|0|0 |15|65|Main|0|0 |16|66|Blog Post Header|0|0 |17|66|Main|0|0 |18|66|Blog Post More|0|0 |19|66|Blog Post Footer|0|0 |20|66|Header Nav|0|0 |21|66|Header|0|0 |22|66|Sidebar|0|0 |23|67|Header Nav|0|0 |24|67|Header|0|0 |25|67|Sidebar|0|0 |26|67|Main|0|0 |27|68|Header Nav|0|0 |28|68|Header|0|0 |29|68|Sidebar|0|0 |30|68|Main|0|0 |31|69|Header Nav|0|0 |32|69|Header|0|0 |33|69|Sidebar|0|0 |34|69|Main|0|0 |35|70|Header Nav|0|0 |36|70|Header|0|0 |37|70|Sidebar|0|0 |38|70|Main|0|0 |39|71|Header Nav|0|0 |40|71|Header|0|0 |41|71|Sidebar|0|0 |42|71|Main|0|0 |43|72|Header Nav|0|0 |44|72|Header|0|0 |45|72|Blog Post Header|0|0 |46|72|Main|0|0 |47|72|Blog Post More|0|0 |48|72|Blog Post Footer|0|0 |49|72|Sidebar|0|0 |50|13|Main|0|0 |51|73|Header Nav|0|0 |52|73|Header|0|0 |53|73|Blog Post Header|0|0 |54|73|Main|0|0 |55|73|Blog Post More|0|0 |56|73|Blog Post Footer|0|0 |57|73|Sidebar|0|0 |58|36|Global|0|0 == 表的结构 Areas |------ |字段|类型|空|默认 |------ |//**arID**//|int(10) |否| |cID|int(10) |否|0 |arHandle|varchar(255)|否| |arOverrideCollectionPermissions|tinyint(1)|否|0 |arInheritPermissionsFromAreaOnCID|int(10) |否|0 == 表的结构 atAddress |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否|0 |address1|varchar(255)|是|NULL |address2|varchar(255)|是|NULL |city|varchar(255)|是|NULL |state_province|varchar(255)|是|NULL |country|varchar(4)|是|NULL |postal_code|varchar(32)|是|NULL == 转存表中的数据 atAddress == 表的结构 atAddress |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否|0 |address1|varchar(255)|是|NULL |address2|varchar(255)|是|NULL |city|varchar(255)|是|NULL |state_province|varchar(255)|是|NULL |country|varchar(4)|是|NULL |postal_code|varchar(32)|是|NULL == 表的结构 atAddressCustomCountries |------ |字段|类型|空|默认 |------ |//**atAddressCustomCountryID**//|int(10) |否| |akID|int(10) |否|0 |country|varchar(5)|否| == 转存表中的数据 atAddressCustomCountries == 表的结构 atAddressCustomCountries |------ |字段|类型|空|默认 |------ |//**atAddressCustomCountryID**//|int(10) |否| |akID|int(10) |否|0 |country|varchar(5)|否| == 表的结构 atAddressSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否|0 |akHasCustomCountries|int(1)|否|0 |akDefaultCountry|varchar(12)|是|NULL == 转存表中的数据 atAddressSettings == 表的结构 atAddressSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否|0 |akHasCustomCountries|int(1)|否|0 |akDefaultCountry|varchar(12)|是|NULL == 表的结构 atBoolean |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|tinyint(1)|否|0 == 转存表中的数据 atBoolean |14|0 |18|1 |23|0 |27|0 |31|0 |35|0 |39|0 |44|0 == 表的结构 atBoolean |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|tinyint(1)|否|0 == 表的结构 atBooleanSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |akCheckedByDefault|tinyint(1)|否|0 == 转存表中的数据 atBooleanSettings == 表的结构 atBooleanSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |akCheckedByDefault|tinyint(1)|否|0 == 表的结构 atDateTime |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|datetime|是|0000-00-00 00:00:00 == 转存表中的数据 atDateTime == 表的结构 atDateTime |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|datetime|是|0000-00-00 00:00:00 == 表的结构 atDateTimeSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |akDateDisplayMode|varchar(255)|是|NULL == 转存表中的数据 atDateTimeSettings == 表的结构 atDateTimeSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |akDateDisplayMode|varchar(255)|是|NULL == 表的结构 atDefault |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|longtext|是|NULL == 转存表中的数据 atDefault |11| |12| |13| |15| |16| |17| |20| |21| |22| |24| |25| |26| |28| |29| |30| |32| |33| |34| |36| |37| |38| |41| |42| |43| == 表的结构 atDefault |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|longtext|是|NULL == 表的结构 atFile |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |fID|int(10) |否| == 转存表中的数据 atFile == 表的结构 atFile |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |fID|int(10) |否| == 表的结构 atNumber |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|decimal(14,4)|是|0.0000 == 转存表中的数据 atNumber |1|800.0000 |2|192.0000 |3|800.0000 |4|192.0000 |5|800.0000 |6|192.0000 |7|800.0000 |8|215.0000 |9|800.0000 |10|192.0000 == 表的结构 atNumber |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |value|decimal(14,4)|是|0.0000 == 表的结构 atSelectOptions |------ |字段|类型|空|默认 |------ |//**ID**//|int(10) |否| |akID|int(10) |是|NULL |value|varchar(255)|是|NULL |displayOrder|int(10) |是|NULL |isEndUserAdded|tinyint(1)|否|0 == 转存表中的数据 atSelectOptions |1|11|sample|0|1 |2|11|Hello World|1|1 == 表的结构 atSelectOptions |------ |字段|类型|空|默认 |------ |//**ID**//|int(10) |否| |akID|int(10) |是|NULL |value|varchar(255)|是|NULL |displayOrder|int(10) |是|NULL |isEndUserAdded|tinyint(1)|否|0 == 表的结构 atSelectOptionsSelected |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |//**atSelectOptionID**//|int(10) |否| == 转存表中的数据 atSelectOptionsSelected |40|1 |40|2 |45|1 == 表的结构 atSelectOptionsSelected |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |//**atSelectOptionID**//|int(10) |否| == 表的结构 atSelectSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |akSelectAllowMultipleValues|tinyint(1)|否|0 |akSelectOptionDisplayOrder|varchar(255)|否|display_asc |akSelectAllowOtherValues|tinyint(1)|否|0 == 转存表中的数据 atSelectSettings |11|1|display_asc|1 == 表的结构 atSelectSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |akSelectAllowMultipleValues|tinyint(1)|否|0 |akSelectOptionDisplayOrder|varchar(255)|否|display_asc |akSelectAllowOtherValues|tinyint(1)|否|0 == 表的结构 atTextareaSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否|0 |akTextareaDisplayMode|varchar(255)|是|NULL == 转存表中的数据 atTextareaSettings == 表的结构 atTextareaSettings |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否|0 |akTextareaDisplayMode|varchar(255)|是|NULL == 表的结构 AttributeKeyCategories |------ |字段|类型|空|默认 |------ |//**akCategoryID**//|int(10) |否| |akCategoryHandle|varchar(255)|否| |akCategoryAllowSets|smallint(4)|否|0 |pkgID|int(10) |是|NULL == 转存表中的数据 AttributeKeyCategories |1|collection|0|NULL |2|user|0|NULL |3|file|0|NULL == 表的结构 AttributeKeyCategories |------ |字段|类型|空|默认 |------ |//**akCategoryID**//|int(10) |否| |akCategoryHandle|varchar(255)|否| |akCategoryAllowSets|smallint(4)|否|0 |pkgID|int(10) |是|NULL == 表的结构 AttributeKeys |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |**akHandle**|varchar(255)|否| |akName|varchar(255)|否| |akIsSearchable|tinyint(1)|否|0 |akIsSearchableIndexed|tinyint(1)|否|0 |akIsAutoCreated|tinyint(1)|否|0 |akIsColumnHeader|tinyint(1)|否|0 |akIsEditable|tinyint(1)|否|0 |atID|int(10) |是|NULL |**akCategoryID**|int(10) |是|NULL |pkgID|int(10) |是|NULL == 转存表中的数据 AttributeKeys |1|meta_title|Meta Title|1|0|0|0|1|1|1|0 |2|meta_description|Meta Description|1|0|0|0|1|2|1|0 |3|meta_keywords|Meta Keywords|1|0|0|0|1|2|1|0 |4|exclude_nav|Exclude From Nav|1|0|0|0|1|3|1|0 |5|exclude_page_list|Exclude From Page List|1|0|0|0|1|3|1|0 |6|header_extra_content|Header Extra Content|1|0|0|0|1|2|1|0 |7|exclude_search_index|Exclude From Search Index|1|0|0|0|1|3|1|0 |8|exclude_sitemapxml|Exclude From sitemap.xml|1|0|0|0|1|3|1|0 |11|tags|Tags|0|0|0|0|1|8|1|0 == 表的结构 AttributeKeys |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |**akHandle**|varchar(255)|否| |akName|varchar(255)|否| |akIsSearchable|tinyint(1)|否|0 |akIsSearchableIndexed|tinyint(1)|否|0 |akIsAutoCreated|tinyint(1)|否|0 |akIsColumnHeader|tinyint(1)|否|0 |akIsEditable|tinyint(1)|否|0 |atID|int(10) |是|NULL |**akCategoryID**|int(10) |是|NULL |pkgID|int(10) |是|NULL == 表的结构 AttributeSetKeys |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否|0 |//**asID**//|int(10) |否|0 |displayOrder|int(10) |否|0 == 转存表中的数据 AttributeSetKeys == 表的结构 AttributeSetKeys |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否|0 |//**asID**//|int(10) |否|0 |displayOrder|int(10) |否|0 == 表的结构 AttributeSets |------ |字段|类型|空|默认 |------ |//**asID**//|int(10) |否| |asName|varchar(255)|是|NULL |asHandle|varchar(255)|否| |akCategoryID|int(10) |否|0 |pkgID|int(10) |否|0 == 转存表中的数据 AttributeSets == 表的结构 AttributeSets |------ |字段|类型|空|默认 |------ |//**asID**//|int(10) |否| |asName|varchar(255)|是|NULL |asHandle|varchar(255)|否| |akCategoryID|int(10) |否|0 |pkgID|int(10) |否|0 == 表的结构 AttributeTypeCategories |------ |字段|类型|空|默认 |------ |//**atID**//|int(10) |否|0 |//**akCategoryID**//|int(10) |否|0 == 转存表中的数据 AttributeTypeCategories |1|1 |1|2 |1|3 |2|1 |2|2 |2|3 |3|1 |3|2 |3|3 |4|1 |4|2 |4|3 |5|1 |6|1 |6|2 |6|3 |7|1 |7|3 |8|1 |8|2 |8|3 |9|2 == 表的结构 AttributeTypeCategories |------ |字段|类型|空|默认 |------ |//**atID**//|int(10) |否|0 |//**akCategoryID**//|int(10) |否|0 == 表的结构 AttributeTypes |------ |字段|类型|空|默认 |------ |//**atID**//|int(10) |否| |atHandle|varchar(255)|否| |atName|varchar(255)|否| |pkgID|int(10) |是|NULL == 转存表中的数据 AttributeTypes |1|text|Text|0 |2|textarea|Text Area|0 |3|boolean|Checkbox|0 |4|date_time|Date/Time|0 |5|image_file|Image/File|0 |6|number|Number|0 |7|rating|Rating|0 |8|select|Select|0 |9|address|Address|0 == 表的结构 AttributeTypes |------ |字段|类型|空|默认 |------ |//**atID**//|int(10) |否| |atHandle|varchar(255)|否| |atName|varchar(255)|否| |pkgID|int(10) |是|NULL == 表的结构 AttributeValues |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |akID|int(10) |是|NULL |avDateAdded|datetime|否|0000-00-00 00:00:00 |uID|int(10) |是|NULL |atID|int(10) |是|NULL == 转存表中的数据 AttributeValues |1|9|2011-04-19 11:21:12|1|6 |2|10|2011-04-19 11:21:12|1|6 |3|9|2011-04-19 11:21:12|1|6 |4|10|2011-04-19 11:21:12|1|6 |5|9|2011-04-19 11:21:12|1|6 |6|10|2011-04-19 11:21:12|1|6 |7|9|2011-04-19 11:21:12|1|6 |8|10|2011-04-19 11:21:12|1|6 |9|9|2011-04-19 11:21:12|1|6 |10|10|2011-04-19 11:21:12|1|6 |11|1|2011-04-19 11:21:12|1|1 |12|2|2011-04-19 11:21:12|1|2 |13|3|2011-04-19 11:21:12|1|2 |14|4|2011-04-19 11:21:12|1|3 |15|1|2011-04-19 11:21:12|1|1 |16|2|2011-04-19 11:21:12|1|2 |17|3|2011-04-19 11:21:12|1|2 |18|4|2011-04-19 11:21:12|1|3 |19|11|2011-04-19 11:21:12|1|8 |20|1|2011-04-19 11:21:12|1|1 |21|2|2011-04-19 11:21:12|1|2 |22|3|2011-04-19 11:21:12|1|2 |23|4|2011-04-19 11:21:12|1|3 |24|1|2011-04-19 11:21:12|1|1 |25|2|2011-04-19 11:21:12|1|2 |26|3|2011-04-19 11:21:12|1|2 |27|4|2011-04-19 11:21:12|1|3 |28|1|2011-04-19 11:21:12|1|1 |29|2|2011-04-19 11:21:12|1|2 |30|3|2011-04-19 11:21:12|1|2 |31|4|2011-04-19 11:21:12|1|3 |32|1|2011-04-19 11:21:12|1|1 |33|2|2011-04-19 11:21:12|1|2 |34|3|2011-04-19 11:21:12|1|2 |35|4|2011-04-19 11:21:12|1|3 |36|1|2011-04-19 11:21:12|1|1 |37|2|2011-04-19 11:21:12|1|2 |38|3|2011-04-19 11:21:12|1|2 |39|4|2011-04-19 11:21:12|1|3 |40|11|2011-04-19 11:21:12|1|8 |41|1|2011-04-19 11:21:12|1|1 |42|2|2011-04-19 11:21:12|1|2 |43|3|2011-04-19 11:21:12|1|2 |44|4|2011-04-19 11:21:12|1|3 |45|11|2011-04-19 11:21:12|1|8 == 表的结构 AttributeValues |------ |字段|类型|空|默认 |------ |//**avID**//|int(10) |否| |akID|int(10) |是|NULL |avDateAdded|datetime|否|0000-00-00 00:00:00 |uID|int(10) |是|NULL |atID|int(10) |是|NULL == 表的结构 BlockRelations |------ |字段|类型|空|默认 |------ |//**brID**//|int(10) |否| |bID|int(10) |否|0 |originalBID|int(10) |否|0 |relationType|varchar(50)|否| == 转存表中的数据 BlockRelations |1|31|15|DUPLICATE |2|32|16|DUPLICATE |3|33|23|DUPLICATE |4|34|31|DUPLICATE |5|35|32|DUPLICATE |6|36|15|DUPLICATE |7|39|23|DUPLICATE |9|43|1|DUPLICATE |11|48|44|DUPLICATE == 表的结构 BlockRelations |------ |字段|类型|空|默认 |------ |//**brID**//|int(10) |否| |bID|int(10) |否|0 |originalBID|int(10) |否|0 |relationType|varchar(50)|否| == 表的结构 Blocks |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |bName|varchar(60)|是|NULL |bDateAdded|datetime|否|0000-00-00 00:00:00 |bDateModified|datetime|否|0000-00-00 00:00:00 |bFilename|varchar(32)|是|NULL |bIsActive|varchar(1)|否|1 |btID|int(10) |否|0 |uID|int(10) |是|NULL == 转存表中的数据 Blocks |1|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|header_menu.php|1|3|1 |2|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|11|1 |3|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|3|1 |46|NULL|2011-04-19 11:37:38|2011-04-19 11:37:38|NULL|1|1|1 |45|NULL|2011-04-19 11:35:03|2011-04-19 11:35:03|NULL|1|1|1 |44|NULL|2011-04-19 11:31:52|2011-04-19 11:33:37|NULL|1|1|1 |7|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|header_menu.php|1|3|1 |8|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|8|1 |9|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|3|1 |10|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|header_menu.php|1|3|1 |11|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|8|1 |12|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|header_menu.php|1|3|1 |13|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|8|1 |14|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|breadcrumb.php|1|3|1 |15|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |16|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |17|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|10|1 |18|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|18|1 |19|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|12|1 |20|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|3|1 |21|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |22|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|12|1 |23|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|20|1 |24|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |25|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |26|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |27|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|10|1 |28|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|18|1 |29|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|tag_cloud|1|12|1 |30|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|blog_index.php|1|6|1 |31|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |32|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |33|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|20|1 |34|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |35|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |36|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |37|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|17|1 |38|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |39|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|20|1 |40|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|19|1 |41|My_Site_Name|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL|1|1|1 |43|NULL|2011-04-19 11:29:12|2011-04-19 11:29:12|header_menu.php|1|3|1 |48|NULL|2011-10-11 20:22:46|2011-10-11 20:27:40|NULL|1|1|1 == 表的结构 Blocks |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |bName|varchar(60)|是|NULL |bDateAdded|datetime|否|0000-00-00 00:00:00 |bDateModified|datetime|否|0000-00-00 00:00:00 |bFilename|varchar(32)|是|NULL |bIsActive|varchar(1)|否|1 |btID|int(10) |否|0 |uID|int(10) |是|NULL == 表的结构 BlockTypes |------ |字段|类型|空|默认 |------ |//**btID**//|int(10) |否| |**btHandle**|varchar(32)|否| |btName|varchar(128)|否| |btDescription|text|是|NULL |btActiveWhenAdded|tinyint(1)|否|1 |btCopyWhenPropagate|tinyint(1)|否|0 |btIncludeAll|tinyint(1)|否|0 |btIsInternal|tinyint(1)|否|0 |btInterfaceWidth|int(10) |否|400 |btInterfaceHeight|int(10) |否|400 |pkgID|int(10) |否|0 == 转存表中的数据 BlockTypes |1|content|Content|HTML/WYSIWYG Editor Content.|1|0|0|0|600|465|0 |2|html|HTML|For adding HTML by hand.|1|0|0|0|600|465|0 |3|autonav|Auto-Nav|Creates navigation trees and sitemaps.|1|0|0|0|500|350|0 |4|external_form|External Form|Include external forms in the filesystem and place them on pages.|1|0|0|0|300|200|0 |5|form|Form|Build simple forms and surveys.|1|0|0|0|420|430|0 |6|page_list|Page List|List pages based on type, area.|1|0|0|0|500|350|0 |7|file|File|Link to files stored in the asset library.|1|0|0|0|300|250|0 |8|image|Image|Adds images and onstates from the library to pages.|1|0|0|0|300|440|0 |9|flash_content|Flash Content|Embeds SWF files, including flash detection.|1|0|0|0|300|240|0 |10|guestbook|Guestbook|Adds blog-style comments (a guestbook) to your page.|1|0|1|0|300|260|0 |11|slideshow|Slideshow|Display a running loop of images.|1|0|0|0|550|400|0 |12|search|Search|Add a search box to your site.|1|0|0|0|400|170|0 |13|google_map|Google Map|Enter an address and a Google Map of that location will be placed in your page.|1|0|0|0|400|220|0 |14|video|Video Player|Embeds uploaded video into a web page. Supports AVI, WMV, Quicktime/MPEG4 and FLV formats.|1|0|0|0|300|200|0 |15|rss_displayer|RSS Displayer|Fetch, parse and display the contents of an RSS or Atom feed.|1|0|0|0|400|170|0 |16|youtube|Youtube Video|Embeds a Youtube Video in your web page.|1|0|0|0|400|170|0 |17|survey|Survey|Provide a simple survey, along with results in a pie chart format.|1|0|1|0|420|300|0 |18|date_nav|Date Navigation|A collapsible date based navigation tree|1|0|0|0|500|350|0 |19|next_previous|Next & Previous Nav|Navigate through sibling pages.|1|0|0|0|430|300|0 |20|tags|Tags|List pages based on type, area.|1|0|0|0|500|350|0 == 表的结构 BlockTypes |------ |字段|类型|空|默认 |------ |//**btID**//|int(10) |否| |**btHandle**|varchar(32)|否| |btName|varchar(128)|否| |btDescription|text|是|NULL |btActiveWhenAdded|tinyint(1)|否|1 |btCopyWhenPropagate|tinyint(1)|否|0 |btIncludeAll|tinyint(1)|否|0 |btIsInternal|tinyint(1)|否|0 |btInterfaceWidth|int(10) |否|400 |btInterfaceHeight|int(10) |否|400 |pkgID|int(10) |否|0 == 表的结构 btContentFile |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|NULL |fileLinkText|varchar(255)|是|NULL |filePassword|varchar(255)|是|NULL == 转存表中的数据 btContentFile == 表的结构 btContentFile |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|NULL |fileLinkText|varchar(255)|是|NULL |filePassword|varchar(255)|是|NULL == 表的结构 btContentImage |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|0 |fOnstateID|int(10) |是|0 |maxWidth|int(10) |是|0 |maxHeight|int(10) |是|0 |externalLink|varchar(255)|是|NULL |altText|varchar(255)|是|NULL == 转存表中的数据 btContentImage |8|4|0|0|0| | |11|2|0|0|0| | |13|1|0|0|0| | == 表的结构 btContentImage |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|0 |fOnstateID|int(10) |是|0 |maxWidth|int(10) |是|0 |maxHeight|int(10) |是|0 |externalLink|varchar(255)|是|NULL |altText|varchar(255)|是|NULL == 表的结构 btContentLocal |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |content|longtext|是|NULL == 转存表中的数据 btContentLocal |44|<p><span style="color: #000000;">for all inquiries, please email us at <a href="mailto:info@topoforms.com">info@topoforms.com</a></span></p> |45|<p><span style="color: #000000;">l a n d s c a p e&nbsp;&nbsp;&nbsp; a r c h i t e c t u r e<strong>&nbsp; .&nbsp; </strong>u r b a n &nbsp;&nbsp; d e s i g n<strong>&nbsp; .&nbsp; </strong>p l a n n i n g</span></p> |46| |15|<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum vel tellus lectus, scelerisque faucibus nunc. Curabitur lacus nibh, eleifend vel porttitor in, bibendum quis tortor. Curabitur eros ligula, scelerisque ac ultricies a, dictum ac tellus. Mauris id tellus tortor. Proin a sollicitudin libero. Nam pellentesque commodo magna, nec mattis elit pulvinar id. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris orci dui, adipiscing sit amet bibendum vel, sodales sed purus. Donec fringilla odio vel enim cursus luctus quis semper leo. Donec rhoncus odio ac elit dignissim lobortis.</p> <p>&nbsp;</p> |16|<p>Duis dapibus nibh eu arcu viverra tempor. Fusce auctor sapien eu mauris malesuada vel euismod orci vulputate. Curabitur at orci id quam mollis rhoncus vitae volutpat urna. Nam eget sapien at neque mollis varius sed vitae ipsum. Vestibulum commodo, eros sit amet sagittis cursus, massa mi lacinia lorem, vel pellentesque sapien purus eu lacus. Pellentesque mollis gravida enim. Fusce mi odio, elementum ut fermentum a, pharetra in quam. Mauris sed vestibulum sapien. In sit amet faucibus diam. Proin lectus quam, sodales ut posuere non, viverra a nibh. Aenean sollicitudin, diam eu elementum rutrum, nisi ante pretium mi, ut tristique ante tellus non ligula. Nam diam turpis, viverra non volutpat vel, scelerisque vel neque. In pretium, libero et vulputate varius, libero nulla blandit ligula, tincidunt egestas leo mi eu nisi. Mauris nunc augue, cursus vel viverra non, feugiat in enim. In eget dignissim est. Donec dictum leo in libero tincidunt sollicitudin hendrerit elit placerat. Aliquam vitae nunc diam, non vulputate nibh. Quisque tincidunt, dui ut rutrum feugiat, libero lorem interdum sapien, eget pharetra mi ligula ut lectus. Pellentesque consequat mollis est viverra malesuada.</p> <p>Curabitur eget quam vitae tellus blandit congue a sed lectus. Nunc ultrices lacus dignissim felis venenatis varius placerat eros dapibus. Nulla facilisi. Vivamus sodales accumsan convallis. Mauris congue tempus feugiat. Proin elementum fringilla leo, sit amet pretium nisl imperdiet interdum. Suspendisse volutpat cursus eros, nec porta est laoreet at. Sed porttitor suscipit augue, eu molestie justo faucibus et. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vivamus faucibus mi vel tortor consequat eget rutrum nisl ultrices. Praesent et lacinia augue. Phasellus id est id enim ultricies placerat. Etiam porta enim eu enim convallis sed eleifend metus faucibus. In ac lobortis eros. Pellentesque felis turpis, cursus sed imperdiet non, viverra vel diam. Donec vel orci mi, placerat egestas purus. Vestibulum vel diam id magna suscipit accumsan. Quisque risus felis, sagittis non iaculis id, tempus in arcu. Donec tempus metus neque. Proin malesuada dui a tortor pretium tincidunt quis at ligula.</p> <p>Nam laoreet faucibus purus ac pretium. Aenean euismod diam adipiscing erat semper quis sodales elit tristique. Vestibulum vel tellus eu lorem porttitor aliquet. Vestibulum bibendum viverra cursus. Aenean sit amet magna odio, convallis imperdiet metus. Duis condimentum posuere vulputate. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed vitae elit ut sapien vestibulum tempor sit amet ac tortor. Donec ligula nulla, varius id ornare id, vestibulum non felis. Nullam neque erat, tristique a eleifend pellentesque, eleifend sit amet ipsum. In eget urna nibh. Phasellus scelerisque, magna ac feugiat ultricies, risus dolor volutpat quam, in rutrum nunc ante id sem. Fusce interdum scelerisque fermentum.</p> <p>&nbsp;</p> |21|<h1>Site Map</h1> |24|<h1>Learn More</h1> <p>Visit&nbsp;<a title="concrete5 Content Management System" href="{CCM:BASE_URL}.org" target="_blank">concrete5.org</a>&nbsp;to learn more from the&nbsp;<a title="open source content management system" href="{CCM:BASE_URL}.org/community" target="_blank">community</a>&nbsp;and the&nbsp;<a title="concrete5 documentation" href="http://www.concrete5.org/documentation/" target="_blank">documentation</a>. You can also browse our&nbsp;<a title="concrete5 marketplace" href="http://www.concrete5.org/marketplace/" target="_blank">marketplace</a>&nbsp;for more&nbsp;<a title="Add-ons for concrete5" href="http://www.concrete5.org/marketplace/addons/" target="_blank">add-ons</a>&nbsp;and&nbsp;<a title="Themes for concrete5" href="http://www.concrete5.org/marketplace/themes/" target="_blank">themes</a>&nbsp;to quickly build the site you really need.&nbsp;</p> <p>&nbsp;</p> |25|<h2>Common Tips</h2> <p>Want to&nbsp;<a title="change your site name in concrete5" href="http://www.concrete5.org/help/faq/how_do_i_get_rid_of_my_sitename_/" target="_blank">change your site name</a>&nbsp;up top?</p> <p>Need to sell stuff on your website? Check out our&nbsp;<a title="eCommerce and concrete5" href="http://www.concrete5.org/marketplace/addons/ecommerce/" target="_blank">eCommerce add-on</a>.</p> <p>Help,&nbsp;<a title="Reset your admin password in concrete5" href="http://www.concrete5.org/help/faq/i-can-t-login/" target="_blank">I can't login</a>&nbsp;anymore!</p> <p>&nbsp;</p> |26|<h1>Say Hi!</h1> <p>Here's a simple guestbook you can add to any page on your website to allow comments. Why not put the guestbook block in edit mode and play with the options?</p> <p>We also have a fully featured&nbsp;<a title="Forums for concrete5" href="http://www.concrete5.org/marketplace/addons/discussion/" target="_blank">Discussions Forum Add-on</a>&nbsp;if you need it.&nbsp;</p> <p>&nbsp;</p> |31|<p>This is the intro of your blog post. If your post is short, just stick it all in here. Everything in the "Main" block area will be displayed from the main&nbsp;<a title="Blog" href="{CCM:CID_71}">blog list page</a>.</p> <p>&nbsp;</p> |32|<p>If you tend to write long blog posts that go on, and on, and on - you should consider keeping that content in this "Blog Post More" block area. This area only shows up to visitors who click on the blog post's title or more link to read the full post.&nbsp;</p> <p>Keep your long posts in here and just a short synopsis up top if you'd like a nice scannable blog.</p> <p>&nbsp;</p> |34|<p>This is the intro of your blog post. If your post is short, just stick it all in here. Everything in the "Main" block area will be displayed from the main&nbsp;<a title="Blog" href="{CCM:CID_71}">blog list page</a>.</p> |35|<p>If you tend to write long blog posts that go on, and on, and on - you should consider keeping that content in this "Blog Post More" block area. This area only shows up to visitors who click on the blog post's title or more link to read the full post.&nbsp;</p> <p>Keep your long posts in here and just a short synopsis up top if you'd like a nice scannable blog.</p> |36|<p>In-context editing is pretty cool cool!</p> |38|<p>By now you've probably watched through the basics at concrete5.org, so you're getting a good sense of how you can add pages around your site. To make a new blog post...</p> <ol> <li>Goto the blog list page, this is the holder page for all your posts in the site tree.&nbsp;</li> <li>Click Add Page, on the upper left.&nbsp;</li> <li>Pick Blog Entry as a page type.&nbsp;</li> <li>Give it a name and hit return, or click the add page button at the bottom of the drop down. (You don't need to worry about all these other fields yet, you can always change them later through Edit Page &gt; Properties</li> <li>You're now on your new blog post page, in edit mode. Start making blocks and get things looking right.&nbsp;</li> <li>Exit Edit Mode and Publish your changes.&nbsp;</li> </ol> |41|<p>{[CCM:SITE]}</p> |48|<p style="text-align: right;"><span style="color: #000000;">l a n d s c a p e&nbsp;&nbsp;&nbsp; a r c h i t e c t u r e<strong>&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; </strong>u r b a n&nbsp;&nbsp;&nbsp; d e s i g n<strong>&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; </strong>p l a n n i n g</span></p> <p><span style="color: #000000;">&nbsp;</span></p> <p><span style="color: #000000;">&nbsp;</span></p> <p><span style="color: #000000;">for all inquiries, please email us at <a href="mailto:info@topoforms.com">info@topoforms.com</a></span></p> == 表的结构 btContentLocal |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |content|longtext|是|NULL == 表的结构 btDateNav |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |num|smallint(5) |否| |cParentID|int(10) |否|1 |cThis|tinyint(3) |否|0 |ctID|smallint(5) |是|NULL |flatDisplay|int(11)|是|0 |defaultNode|varchar(64)|是|current_page |truncateTitles|int(11)|是|0 |truncateSummaries|int(11)|是|0 |displayFeaturedOnly|int(11)|是|0 |truncateChars|int(11)|是|128 |truncateTitleChars|int(11)|是|128 |showDescriptions|int(11)|是|0 == 转存表中的数据 btDateNav |18|0|0|0|4|0|current_page|0|0|0|0|0|0 |28|0|71|1|0|0|current_month|0|0|0|0|0|0 == 表的结构 btDateNav |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |num|smallint(5) |否| |cParentID|int(10) |否|1 |cThis|tinyint(3) |否|0 |ctID|smallint(5) |是|NULL |flatDisplay|int(11)|是|0 |defaultNode|varchar(64)|是|current_page |truncateTitles|int(11)|是|0 |truncateSummaries|int(11)|是|0 |displayFeaturedOnly|int(11)|是|0 |truncateChars|int(11)|是|128 |truncateTitleChars|int(11)|是|128 |showDescriptions|int(11)|是|0 == 表的结构 btExternalForm |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |filename|varchar(128)|是|NULL == 转存表中的数据 btExternalForm == 表的结构 btExternalForm |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |filename|varchar(128)|是|NULL == 表的结构 btFile |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |filename|varchar(255)|是|NULL |origfilename|varchar(255)|是|NULL |url|varchar(255)|是|NULL |type|varchar(32)|是|NULL |generictype|varchar(32)|是|NULL == 转存表中的数据 btFile == 表的结构 btFile |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |filename|varchar(255)|是|NULL |origfilename|varchar(255)|是|NULL |url|varchar(255)|是|NULL |type|varchar(32)|是|NULL |generictype|varchar(32)|是|NULL == 表的结构 btFlashContent |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|NULL |quality|varchar(255)|是|NULL |minVersion|varchar(255)|是|NULL == 转存表中的数据 btFlashContent == 表的结构 btFlashContent |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|NULL |quality|varchar(255)|是|NULL |minVersion|varchar(255)|是|NULL == 表的结构 btForm |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |questionSetId|int(10) |是|0 |surveyName|varchar(255)|是|NULL |thankyouMsg|text|是|NULL |notifyMeOnSubmission|tinyint(3) |否|0 |recipientEmail|varchar(255)|是|NULL |displayCaptcha|int(11)|是|1 |redirectCID|int(11)|是|0 == 转存表中的数据 btForm == 表的结构 btForm |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |questionSetId|int(10) |是|0 |surveyName|varchar(255)|是|NULL |thankyouMsg|text|是|NULL |notifyMeOnSubmission|tinyint(3) |否|0 |recipientEmail|varchar(255)|是|NULL |displayCaptcha|int(11)|是|1 |redirectCID|int(11)|是|0 == 表的结构 btFormAnswers |------ |字段|类型|空|默认 |------ |//**aID**//|int(10) |否| |asID|int(10) |是|0 |msqID|int(10) |是|0 |answer|varchar(255)|是|NULL |answerLong|text|是|NULL == 转存表中的数据 btFormAnswers == 表的结构 btFormAnswers |------ |字段|类型|空|默认 |------ |//**aID**//|int(10) |否| |asID|int(10) |是|0 |msqID|int(10) |是|0 |answer|varchar(255)|是|NULL |answerLong|text|是|NULL == 表的结构 btFormAnswerSet |------ |字段|类型|空|默认 |------ |//**asID**//|int(10) |否| |questionSetId|int(10) |是|0 |created|timestamp|否|CURRENT_TIMESTAMP |uID|int(10) |是|0 == 转存表中的数据 btFormAnswerSet == 表的结构 btFormAnswerSet |------ |字段|类型|空|默认 |------ |//**asID**//|int(10) |否| |questionSetId|int(10) |是|0 |created|timestamp|否|CURRENT_TIMESTAMP |uID|int(10) |是|0 == 表的结构 btFormQuestions |------ |字段|类型|空|默认 |------ |//**qID**//|int(10) |否| |msqID|int(10) |是|0 |bID|int(10) |是|0 |questionSetId|int(10) |是|0 |question|varchar(255)|是|NULL |inputType|varchar(255)|是|NULL |options|text|是|NULL |position|int(10) |是|1000 |width|int(10) |是|50 |height|int(10) |是|3 |required|int(11)|是|0 == 转存表中的数据 btFormQuestions == 表的结构 btFormQuestions |------ |字段|类型|空|默认 |------ |//**qID**//|int(10) |否| |msqID|int(10) |是|0 |bID|int(10) |是|0 |questionSetId|int(10) |是|0 |question|varchar(255)|是|NULL |inputType|varchar(255)|是|NULL |options|text|是|NULL |position|int(10) |是|1000 |width|int(10) |是|50 |height|int(10) |是|3 |required|int(11)|是|0 == 表的结构 btGoogleMap |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |api_key|varchar(255)|是|NULL |location|varchar(255)|是|NULL |latitude|double|是|NULL |longitude|double|是|NULL |zoom|int(8)|是|NULL == 转存表中的数据 btGoogleMap == 表的结构 btGoogleMap |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |api_key|varchar(255)|是|NULL |location|varchar(255)|是|NULL |latitude|double|是|NULL |longitude|double|是|NULL |zoom|int(8)|是|NULL == 表的结构 btGuestBook |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |requireApproval|int(11)|是|0 |title|varchar(100)|是|Comments |dateFormat|varchar(100)|是|NULL |displayGuestBookForm|int(11)|是|1 |displayCaptcha|int(11)|是|1 |authenticationRequired|int(11)|是|0 |notifyEmail|varchar(100)|是|NULL == 转存表中的数据 btGuestBook |17|0|Comments:|M jS, Y|1|1|0| |27|0|Comments:|M jS, Y|1|1|0| == 表的结构 btGuestBook |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |requireApproval|int(11)|是|0 |title|varchar(100)|是|Comments |dateFormat|varchar(100)|是|NULL |displayGuestBookForm|int(11)|是|1 |displayCaptcha|int(11)|是|1 |authenticationRequired|int(11)|是|0 |notifyEmail|varchar(100)|是|NULL == 表的结构 btGuestBookEntries |------ |字段|类型|空|默认 |------ |bID|int(11)|是|NULL |cID|int(11)|是|1 |//**entryID**//|int(11)|否| |uID|int(11)|是|0 |commentText|longtext|是|NULL |user_name|varchar(100)|是|NULL |user_email|varchar(100)|是|NULL |entryDate|timestamp|否|CURRENT_TIMESTAMP |approved|int(11)|是|1 == 转存表中的数据 btGuestBookEntries == 表的结构 btGuestBookEntries |------ |字段|类型|空|默认 |------ |bID|int(11)|是|NULL |cID|int(11)|是|1 |//**entryID**//|int(11)|否| |uID|int(11)|是|0 |commentText|longtext|是|NULL |user_name|varchar(100)|是|NULL |user_email|varchar(100)|是|NULL |entryDate|timestamp|否|CURRENT_TIMESTAMP |approved|int(11)|是|1 == 表的结构 btNavigation |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |orderBy|varchar(255)|是|alpha_asc |displayPages|varchar(255)|是|top |displayPagesCID|int(10) |否|1 |displayPagesIncludeSelf|tinyint(3) |否|0 |displaySubPages|varchar(255)|是|none |displaySubPageLevels|varchar(255)|是|none |displaySubPageLevelsNum|smallint(5) |否|0 |displayUnavailablePages|tinyint(3) |否|0 == 转存表中的数据 btNavigation |1|display_asc|top|0|0|none|enough|0|0 |3|display_asc|second_level|0|0|relevant|enough|0|0 |7|display_asc|top|0|0|none|enough|0|0 |9|display_asc|second_level|0|0|relevant|enough|0|0 |10|display_asc|top|0|0|none|enough|0|0 |12|display_asc|top|0|0|none|enough|0|0 |14|display_asc|top|0|0|relevant_breadcrumb|enough|0|0 |20|display_asc|top|0|0|all|all|0|0 |43|display_asc|top|0|0|relevant|enough|0|0 == 表的结构 btNavigation |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |orderBy|varchar(255)|是|alpha_asc |displayPages|varchar(255)|是|top |displayPagesCID|int(10) |否|1 |displayPagesIncludeSelf|tinyint(3) |否|0 |displaySubPages|varchar(255)|是|none |displaySubPageLevels|varchar(255)|是|none |displaySubPageLevelsNum|smallint(5) |否|0 |displayUnavailablePages|tinyint(3) |否|0 == 表的结构 btNextPrevious |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |linkStyle|varchar(32)|是|NULL |nextLabel|varchar(128)|是|NULL |previousLabel|varchar(128)|是|NULL |showArrows|int(11)|是|1 |loopSequence|int(11)|是|1 |excludeSystemPages|int(11)|是|1 == 转存表中的数据 btNextPrevious |40|next_previous|Next|Previous|1|1|1 == 表的结构 btNextPrevious |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |linkStyle|varchar(32)|是|NULL |nextLabel|varchar(128)|是|NULL |previousLabel|varchar(128)|是|NULL |showArrows|int(11)|是|1 |loopSequence|int(11)|是|1 |excludeSystemPages|int(11)|是|1 == 表的结构 btPageList |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |num|smallint(5) |否| |orderBy|varchar(32)|是|NULL |cParentID|int(10) |否|1 |cThis|tinyint(3) |否|0 |paginate|tinyint(3) |否|0 |displayAliases|tinyint(3) |否|1 |ctID|smallint(5) |是|NULL |rss|int(11)|是|0 |rssTitle|varchar(255)|是|NULL |rssDescription|longtext|是|NULL |truncateSummaries|int(11)|是|0 |displayFeaturedOnly|int(11)|是|0 |truncateChars|int(11)|是|128 == 转存表中的数据 btPageList |30|10|chrono_desc|0|0|1|1|4|1|Blog| |0|0|0 == 表的结构 btPageList |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |num|smallint(5) |否| |orderBy|varchar(32)|是|NULL |cParentID|int(10) |否|1 |cThis|tinyint(3) |否|0 |paginate|tinyint(3) |否|0 |displayAliases|tinyint(3) |否|1 |ctID|smallint(5) |是|NULL |rss|int(11)|是|0 |rssTitle|varchar(255)|是|NULL |rssDescription|longtext|是|NULL |truncateSummaries|int(11)|是|0 |displayFeaturedOnly|int(11)|是|0 |truncateChars|int(11)|是|128 == 表的结构 btRssDisplay |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |url|varchar(255)|是|NULL |dateFormat|varchar(100)|是|NULL |itemsToDisplay|int(10) |是|5 |showSummary|tinyint(3) |否|1 |launchInNewWindow|tinyint(3) |否|1 == 转存表中的数据 btRssDisplay == 表的结构 btRssDisplay |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |url|varchar(255)|是|NULL |dateFormat|varchar(100)|是|NULL |itemsToDisplay|int(10) |是|5 |showSummary|tinyint(3) |否|1 |launchInNewWindow|tinyint(3) |否|1 == 表的结构 btSearch |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |buttonText|varchar(128)|是|NULL |baseSearchPath|varchar(255)|是|NULL |resultsURL|varchar(255)|是|NULL == 转存表中的数据 btSearch |19|Search Results|Search| | |22|Search Your Site|Go| |/search/search-results |29|Tags| | |/search/search-results == 表的结构 btSearch |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |buttonText|varchar(128)|是|NULL |baseSearchPath|varchar(255)|是|NULL |resultsURL|varchar(255)|是|NULL == 表的结构 btSlideshow |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fsID|int(10) |是|NULL |playback|varchar(50)|是|NULL |duration|int(10) |是|NULL |fadeDuration|int(10) |是|NULL == 转存表中的数据 btSlideshow |2|0|ORDER|NULL|NULL == 表的结构 btSlideshow |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fsID|int(10) |是|NULL |playback|varchar(50)|是|NULL |duration|int(10) |是|NULL |fadeDuration|int(10) |是|NULL == 表的结构 btSlideshowImg |------ |字段|类型|空|默认 |------ |//**slideshowImgId**//|int(10) |否| |bID|int(10) |是|NULL |fID|int(10) |是|NULL |url|varchar(255)|是|NULL |duration|int(10) |是|NULL |fadeDuration|int(10) |是|NULL |groupSet|int(10) |是|NULL |position|int(10) |是|NULL |imgHeight|int(10) |是|NULL == 转存表中的数据 btSlideshowImg |1|2|5| |5|2|0|0|192 |2|2|4| |5|2|0|1|215 |3|2|2| |5|2|0|2|192 |4|2|3| |5|2|0|3|192 == 表的结构 btSlideshowImg |------ |字段|类型|空|默认 |------ |//**slideshowImgId**//|int(10) |否| |bID|int(10) |是|NULL |fID|int(10) |是|NULL |url|varchar(255)|是|NULL |duration|int(10) |是|NULL |fadeDuration|int(10) |是|NULL |groupSet|int(10) |是|NULL |position|int(10) |是|NULL |imgHeight|int(10) |是|NULL == 表的结构 btSurvey |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |question|varchar(255)|是| |requiresRegistration|int(11)|是|0 == 转存表中的数据 btSurvey |37|What's easiest?|0 == 表的结构 btSurvey |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |question|varchar(255)|是| |requiresRegistration|int(11)|是|0 == 表的结构 btSurveyOptions |------ |字段|类型|空|默认 |------ |//**optionID**//|int(10) |否| |bID|int(11)|是|NULL |optionName|varchar(255)|是|NULL |displayOrder|int(11)|是|0 == 转存表中的数据 btSurveyOptions |1|37|Fixing a typo when I see it.|0 |2|37|Adding a form as easily as content.|1 |3|37|Block area layouts are pretty cool.|2 == 表的结构 btSurveyOptions |------ |字段|类型|空|默认 |------ |//**optionID**//|int(10) |否| |bID|int(11)|是|NULL |optionName|varchar(255)|是|NULL |displayOrder|int(11)|是|0 == 表的结构 btSurveyResults |------ |字段|类型|空|默认 |------ |//**resultID**//|int(10) |否| |optionID|int(10) |是|0 |uID|int(10) |是|0 |bID|int(11)|是|NULL |cID|int(11)|是|NULL |ipAddress|varchar(128)|是|NULL |timestamp|timestamp|否|CURRENT_TIMESTAMP == 转存表中的数据 btSurveyResults == 表的结构 btSurveyResults |------ |字段|类型|空|默认 |------ |//**resultID**//|int(10) |否| |optionID|int(10) |是|0 |uID|int(10) |是|0 |bID|int(11)|是|NULL |cID|int(11)|是|NULL |ipAddress|varchar(128)|是|NULL |timestamp|timestamp|否|CURRENT_TIMESTAMP == 表的结构 btTags |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |targetCID|int(11)|是|NULL == 转存表中的数据 btTags |23|Tags|68 |33|Tags|68 |39|Tags|68 == 表的结构 btTags |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |targetCID|int(11)|是|NULL == 表的结构 btVideo |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|NULL |width|int(10) |是|NULL |height|int(10) |是|NULL == 转存表中的数据 btVideo == 表的结构 btVideo |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |fID|int(10) |是|NULL |width|int(10) |是|NULL |height|int(10) |是|NULL == 表的结构 btYouTube |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |videoURL|varchar(255)|是|NULL == 转存表中的数据 btYouTube == 表的结构 btYouTube |------ |字段|类型|空|默认 |------ |//**bID**//|int(10) |否| |title|varchar(255)|是|NULL |videoURL|varchar(255)|是|NULL == 表的结构 CollectionAttributeValues |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 |//**avID**//|int(10) |否|0 == 转存表中的数据 CollectionAttributeValues |66|1|11|19 |67|2|1|11 |67|2|2|12 |67|2|3|13 |67|2|4|14 |67|3|1|11 |67|3|2|12 |67|3|3|13 |67|3|4|14 |68|2|1|15 |68|2|2|16 |68|2|3|17 |68|2|4|18 |69|2|1|20 |69|2|2|21 |69|2|3|22 |69|2|4|23 |69|3|1|20 |69|3|2|21 |69|3|3|22 |69|3|4|23 |70|2|1|24 |70|2|2|25 |70|2|3|26 |70|2|4|27 |70|3|1|28 |70|3|2|29 |70|3|3|30 |70|3|4|31 |71|2|1|32 |71|2|2|33 |71|2|3|34 |71|2|4|35 |72|2|1|36 |72|2|2|37 |72|2|3|38 |72|2|4|39 |72|2|11|40 |72|3|1|36 |72|3|2|37 |72|3|3|38 |72|3|4|39 |72|3|11|40 |72|4|1|36 |72|4|2|37 |72|4|3|38 |72|4|4|39 |72|4|11|40 |73|2|1|41 |73|2|2|42 |73|2|3|43 |73|2|4|44 |73|3|1|41 |73|3|2|42 |73|3|3|43 |73|3|4|44 |73|3|11|45 |73|4|1|41 |73|4|2|42 |73|4|3|43 |73|4|4|44 |73|4|11|45 == 表的结构 CollectionAttributeValues |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 |//**avID**//|int(10) |否|0 == 表的结构 Collections |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否| |cDateAdded|datetime|否|0000-00-00 00:00:00 |cDateModified|datetime|否|0000-00-00 00:00:00 |cHandle|varchar(255)|是|NULL == 转存表中的数据 Collections |1|2011-04-19 11:21:09|2011-10-11 20:31:40|home |2|2011-04-19 11:21:09|2011-04-19 11:21:09|NULL |5|2011-04-19 11:21:09|2011-04-19 11:21:09|login |6|2011-04-19 11:21:09|2011-04-19 11:21:09|register |7|2011-04-19 11:21:09|2011-04-19 11:21:09|profile |8|2011-04-19 11:21:09|2011-04-19 11:21:09|edit |10|2011-04-19 11:21:09|2011-04-19 11:21:09|avatar |11|2011-04-19 11:21:09|2011-04-19 11:21:09|messages |12|2011-04-19 11:21:09|2011-04-19 11:21:09|friends |13|2011-04-19 11:21:09|2011-04-19 11:21:09|page_not_found |14|2011-04-19 11:21:09|2011-04-19 11:21:09|page_forbidden |15|2011-04-19 11:21:09|2011-04-19 11:21:09|dashboard |16|2011-04-19 11:21:09|2011-04-19 11:21:09|sitemap |17|2011-04-19 11:21:09|2011-04-19 11:21:09|full |18|2011-04-19 11:21:09|2011-04-19 11:21:09|explore |19|2011-04-19 11:21:09|2011-04-19 11:21:09|search |20|2011-04-19 11:21:09|2011-04-19 11:21:09|access |21|2011-04-19 11:21:09|2011-04-19 11:21:09|files |22|2011-04-19 11:21:09|2011-04-19 11:21:09|search |23|2011-04-19 11:21:09|2011-04-19 11:21:09|attributes |24|2011-04-19 11:21:09|2011-04-19 11:21:09|sets |25|2011-04-19 11:21:09|2011-04-19 11:21:09|access |26|2011-04-19 11:21:09|2011-04-19 11:21:09|reports |27|2011-04-19 11:21:09|2011-04-19 11:21:09|forms |28|2011-04-19 11:21:09|2011-04-19 11:21:09|surveys |29|2011-04-19 11:21:09|2011-04-19 11:21:09|logs |30|2011-04-19 11:21:09|2011-04-19 11:21:09|users |31|2011-04-19 11:21:09|2011-04-19 11:21:09|search |32|2011-04-19 11:21:09|2011-04-19 11:21:09|add |33|2011-04-19 11:21:09|2011-04-19 11:21:09|groups |34|2011-04-19 11:21:09|2011-04-19 11:21:09|attributes |35|2011-04-19 11:21:09|2011-04-19 11:21:09|registration |36|2011-04-19 11:21:09|2011-04-19 11:21:09|scrapbook |37|2011-04-19 11:21:09|2011-04-19 11:21:09|pages |38|2011-04-19 11:21:09|2011-04-19 11:21:09|themes |39|2011-04-19 11:21:09|2011-04-19 11:21:09|add |40|2011-04-19 11:21:09|2011-04-19 11:21:09|inspect |41|2011-04-19 11:21:09|2011-04-19 11:21:09|customize |43|2011-04-19 11:21:09|2011-04-19 11:21:09|types |44|2011-04-19 11:21:09|2011-04-19 11:21:09|attributes |45|2011-04-19 11:21:09|2011-04-19 11:21:09|single |46|2011-04-19 11:21:09|2011-04-19 11:21:09|install |47|2011-04-19 11:21:09|2011-04-19 11:21:09|system |48|2011-04-19 11:21:09|2011-04-19 11:21:09|jobs |49|2011-04-19 11:21:09|2011-04-19 11:21:09|backup |50|2011-04-19 11:21:09|2011-04-19 11:21:09|update |51|2011-04-19 11:21:09|2011-04-19 11:21:09|notifications |52|2011-04-19 11:21:09|2011-04-19 11:21:09|settings |53|2011-04-19 11:21:09|2011-04-19 11:21:09|mail |54|2011-04-19 11:21:09|2011-04-19 11:21:09|marketplace |55|2011-04-19 11:21:09|2011-04-19 11:21:09|download_file |63|2011-04-19 11:21:09|2011-04-19 11:21:09|uID=1 |64|2011-04-19 11:21:09|2011-04-19 11:21:09|members == 表的结构 Collections |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否| |cDateAdded|datetime|否|0000-00-00 00:00:00 |cDateModified|datetime|否|0000-00-00 00:00:00 |cHandle|varchar(255)|是|NULL == 表的结构 CollectionSearchIndexAttributes |------ |字段|类型|空|默认 |------ |//**cID**//|int(11) |否|0 |ak_meta_title|text|是|NULL |ak_meta_description|text|是|NULL |ak_meta_keywords|text|是|NULL |ak_exclude_nav|tinyint(4)|是|0 |ak_exclude_page_list|tinyint(4)|是|0 |ak_header_extra_content|text|是|NULL |ak_exclude_search_index|tinyint(4)|是|0 |ak_exclude_sitemapxml|tinyint(4)|是|0 |ak_tags|text|是|NULL == 转存表中的数据 CollectionSearchIndexAttributes |2|NULL|NULL|NULL|0|0|NULL|0|0|NULL |1|NULL|NULL|NULL|0|0|NULL|0|0|NULL |65|NULL|NULL|NULL|0|0|NULL|0|0|NULL |42|NULL|NULL|NULL|0|0|NULL|0|0|NULL |67| | | |0|0|NULL|0|0|NULL |68| | | |1|0|NULL|0|0|NULL |66|NULL|NULL|NULL|0|0|NULL|0|0| |69| | | |0|0|NULL|0|0|NULL |70| | | |0|0|NULL|0|0|NULL |71| | | |0|0|NULL|0|0|NULL |72| | | |0|0|NULL|0|0| sample Hello World |73| | | |0|0|NULL|0|0| sample == 表的结构 CollectionSearchIndexAttributes |------ |字段|类型|空|默认 |------ |//**cID**//|int(11) |否|0 |ak_meta_title|text|是|NULL |ak_meta_description|text|是|NULL |ak_meta_keywords|text|是|NULL |ak_exclude_nav|tinyint(4)|是|0 |ak_exclude_page_list|tinyint(4)|是|0 |ak_header_extra_content|text|是|NULL |ak_exclude_search_index|tinyint(4)|是|0 |ak_exclude_sitemapxml|tinyint(4)|是|0 |ak_tags|text|是|NULL == 表的结构 CollectionVersionAreaLayouts |------ |字段|类型|空|默认 |------ |//**cvalID**//|int(10) |否| |cID|int(10) |是|0 |cvID|int(10) |是|0 |arHandle|varchar(255)|是|NULL |layoutID|int(10) |否|0 |position|int(10)|是|1000 |areaNameNumber|int(10) |是|0 == 转存表中的数据 CollectionVersionAreaLayouts == 表的结构 CollectionVersionAreaLayouts |------ |字段|类型|空|默认 |------ |//**cvalID**//|int(10) |否| |cID|int(10) |是|0 |cvID|int(10) |是|0 |arHandle|varchar(255)|是|NULL |layoutID|int(10) |否|0 |position|int(10)|是|1000 |areaNameNumber|int(10) |是|0 == 表的结构 CollectionVersionAreaStyles |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |csrID|int(10) |否|0 == 转存表中的数据 CollectionVersionAreaStyles == 表的结构 CollectionVersionAreaStyles |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |csrID|int(10) |否|0 == 表的结构 CollectionVersionBlockPermissions |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|1 |//**bID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |cbgPermissions|varchar(32)|是|NULL == 转存表中的数据 CollectionVersionBlockPermissions == 表的结构 CollectionVersionBlockPermissions |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|1 |//**bID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |cbgPermissions|varchar(32)|是|NULL == 表的结构 CollectionVersionBlocks |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|1 |//**bID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |cbDisplayOrder|int(10) |否|0 |isOriginal|varchar(1)|否|0 |cbOverrideAreaPermissions|tinyint(1)|否|0 |cbIncludeAll|tinyint(1)|否|0 == 转存表中的数据 CollectionVersionBlocks |2|1|1|Header Nav|0|1|0|0 |2|1|2|Header|0|1|0|0 |2|1|3|Sidebar|0|1|0|0 |1|2|1|Header Nav|0|0|0|0 |1|2|2|Header|0|0|0|0 |1|4|43|Header Nav|0|0|0|0 |1|3|43|Header Nav|0|1|0|0 |1|3|2|Header|0|0|0|0 |64|1|7|Header Nav|0|1|0|0 |64|1|8|Header|0|1|0|0 |64|1|9|Sidebar|0|1|0|0 |65|1|10|Header Nav|0|1|0|0 |65|1|11|Header|0|1|0|0 |66|1|12|Header Nav|0|1|0|0 |66|1|13|Header|0|1|0|0 |66|1|14|Blog Post Header|0|1|0|0 |66|1|15|Main|0|1|0|0 |66|1|16|Blog Post More|0|1|0|0 |66|1|17|Blog Post Footer|1|1|0|1 |66|1|18|Sidebar|0|1|0|0 |67|1|7|Header Nav|0|0|0|0 |67|1|8|Header|0|0|0|0 |67|1|9|Sidebar|0|0|0|0 |67|2|7|Header Nav|0|0|0|0 |67|2|8|Header|0|0|0|0 |67|2|9|Sidebar|0|0|0|0 |68|1|7|Header Nav|0|0|0|0 |68|1|8|Header|0|0|0|0 |68|1|9|Sidebar|0|0|0|0 |68|2|7|Header Nav|0|0|0|0 |68|2|8|Header|0|0|0|0 |68|2|9|Sidebar|0|0|0|0 |68|2|19|Main|0|1|0|0 |67|3|7|Header Nav|0|0|0|0 |67|3|8|Header|0|0|0|0 |67|3|22|Sidebar|0|1|0|0 |67|3|20|Main|1|1|0|0 |67|3|21|Main|0|1|0|0 |66|1|23|Sidebar|1|1|0|0 |69|1|7|Header Nav|0|0|0|0 |69|1|8|Header|0|0|0|0 |69|1|9|Sidebar|0|0|0|0 |69|2|7|Header Nav|0|0|0|0 |69|2|8|Header|0|0|0|0 |69|2|9|Sidebar|0|0|0|0 |69|2|24|Main|0|1|0|0 |69|3|7|Header Nav|0|0|0|0 |69|3|8|Header|0|0|0|0 |69|3|9|Sidebar|0|0|0|0 |69|3|24|Main|0|0|0|0 |69|3|25|Main|1|1|0|0 |70|1|7|Header Nav|0|0|0|0 |70|1|8|Header|0|0|0|0 |70|1|9|Sidebar|0|0|0|0 |70|2|7|Header Nav|0|0|0|0 |70|2|8|Header|0|0|0|0 |70|2|9|Sidebar|0|0|0|0 |70|2|26|Main|0|1|0|0 |70|2|27|Main|1|1|0|1 |70|3|7|Header Nav|0|0|0|0 |70|3|8|Header|0|0|0|0 |70|3|9|Sidebar|0|0|0|0 |70|3|26|Main|0|0|0|0 |71|1|1|Header Nav|0|0|0|0 |71|1|2|Header|0|0|0|0 |71|1|3|Sidebar|0|0|0|0 |71|2|1|Header Nav|0|0|0|0 |71|2|2|Header|0|0|0|0 |71|2|28|Sidebar|0|1|0|0 |71|2|29|Sidebar|1|1|0|0 |71|2|30|Main|0|1|0|0 |72|1|12|Header Nav|0|0|0|0 |72|1|13|Header|0|0|0|0 |72|1|14|Blog Post Header|0|0|0|0 |72|1|15|Main|0|0|0|0 |72|1|16|Blog Post More|0|0|0|0 |72|1|17|Blog Post Footer|0|0|0|0 |72|1|18|Sidebar|0|0|0|0 |72|1|23|Sidebar|1|0|0|0 |72|2|12|Header Nav|0|0|0|0 |72|2|13|Header|0|0|0|0 |72|2|14|Blog Post Header|0|0|0|0 |72|2|32|Blog Post More|0|1|0|0 |72|2|33|Sidebar|1|1|0|0 |72|2|17|Blog Post Footer|0|0|0|0 |72|2|18|Sidebar|0|0|0|0 |72|3|12|Header Nav|0|0|0|0 |72|2|31|Main|0|1|0|0 |72|3|13|Header|0|0|0|0 |72|3|14|Blog Post Header|0|0|0|0 |72|3|17|Blog Post Footer|0|0|0|0 |72|3|18|Sidebar|0|0|0|0 |72|3|35|Blog Post More|0|1|0|0 |73|1|12|Header Nav|0|0|0|0 |72|3|33|Sidebar|1|0|0|0 |72|3|34|Main|0|1|0|0 |73|1|13|Header|0|0|0|0 |73|1|14|Blog Post Header|0|0|0|0 |73|1|15|Main|0|0|0|0 |73|1|16|Blog Post More|0|0|0|0 |73|1|17|Blog Post Footer|0|0|0|0 |73|1|18|Sidebar|0|0|0|0 |73|1|23|Sidebar|1|0|0|0 |73|2|12|Header Nav|0|0|0|0 |73|2|13|Header|0|0|0|0 |73|2|14|Blog Post Header|0|0|0|0 |73|2|38|Blog Post More|0|1|0|0 |73|2|37|Main|1|1|0|1 |73|2|17|Blog Post Footer|0|0|0|0 |73|2|18|Sidebar|0|0|0|0 |73|2|23|Sidebar|1|0|0|0 |73|2|36|Main|0|1|0|0 |73|3|12|Header Nav|0|0|0|0 |73|3|13|Header|0|0|0|0 |73|3|14|Blog Post Header|0|0|0|0 |73|3|17|Blog Post Footer|0|0|0|0 |73|3|18|Sidebar|0|0|0|0 |73|3|36|Main|0|0|0|0 |73|3|38|Blog Post More|0|0|0|0 |73|3|39|Sidebar|1|1|0|0 |66|1|40|Blog Post Footer|0|1|0|0 |73|3|40|Blog Post Footer|1|0|0|0 |72|3|40|Blog Post Footer|1|0|0|0 |72|4|12|Header Nav|0|0|0|0 |72|4|13|Header|0|0|0|0 |72|4|14|Blog Post Header|0|0|0|0 |72|4|17|Blog Post Footer|1|0|0|0 |72|4|18|Sidebar|0|0|0|0 |72|4|34|Main|0|0|0|0 |72|4|35|Blog Post More|0|0|0|0 |72|4|33|Sidebar|1|0|0|0 |72|4|40|Blog Post Footer|0|0|0|0 |73|4|12|Header Nav|0|0|0|0 |73|4|13|Header|0|0|0|0 |73|4|14|Blog Post Header|0|0|0|0 |73|4|17|Blog Post Footer|1|0|0|0 |73|4|18|Sidebar|0|0|0|0 |73|4|36|Main|0|0|0|0 |73|4|38|Blog Post More|0|0|0|0 |73|4|39|Sidebar|1|0|0|0 |73|4|40|Blog Post Footer|0|0|0|0 |36|2|41|Global|0|1|0|0 |1|4|2|Header|0|0|0|0 |1|4|44|Header|1|1|0|0 |1|4|45|Header Nav|1|1|0|0 |1|4|46|Header Nav|2|1|0|0 |1|5|2|Header|0|0|0|0 |1|5|48|Header|1|1|0|0 == 表的结构 CollectionVersionBlocks |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|1 |//**bID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |cbDisplayOrder|int(10) |否|0 |isOriginal|varchar(1)|否|0 |cbOverrideAreaPermissions|tinyint(1)|否|0 |cbIncludeAll|tinyint(1)|否|0 == 表的结构 CollectionVersionBlockStyles |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|0 |//**bID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |csrID|int(10) |否|0 == 转存表中的数据 CollectionVersionBlockStyles |1|2|1|Header Nav|0 |1|2|2|Header|0 |1|3|43|Header Nav|0 |1|3|2|Header|0 |67|1|7|Header Nav|0 |67|1|8|Header|0 |67|1|9|Sidebar|0 |67|2|7|Header Nav|0 |67|2|8|Header|0 |67|2|9|Sidebar|0 |68|1|7|Header Nav|0 |68|1|8|Header|0 |68|1|9|Sidebar|0 |68|2|7|Header Nav|0 |68|2|8|Header|0 |68|2|9|Sidebar|0 |69|1|8|Header|0 |69|1|7|Header Nav|0 |69|1|9|Sidebar|0 |69|2|7|Header Nav|0 |69|2|8|Header|0 |69|2|9|Sidebar|0 |69|3|7|Header Nav|0 |69|3|8|Header|0 |69|3|9|Sidebar|0 |69|3|24|Main|0 |70|1|7|Header Nav|0 |70|1|8|Header|0 |70|1|9|Sidebar|0 |70|2|7|Header Nav|0 |70|2|8|Header|0 |70|2|9|Sidebar|0 |70|3|7|Header Nav|0 |70|3|8|Header|0 |70|3|9|Sidebar|0 |70|3|26|Main|0 |71|1|1|Header Nav|0 |71|1|2|Header|0 |71|1|3|Sidebar|0 |71|2|1|Header Nav|0 |71|2|2|Header|0 |72|1|12|Header Nav|0 |72|1|13|Header|0 |72|1|14|Blog Post Header|0 |72|1|15|Main|0 |72|1|16|Blog Post More|0 |72|1|17|Blog Post Footer|0 |72|1|18|Sidebar|0 |72|1|23|Sidebar|0 |72|2|12|Header Nav|0 |72|2|13|Header|0 |72|2|14|Blog Post Header|0 |72|2|32|Blog Post More|0 |72|2|33|Sidebar|0 |72|2|17|Blog Post Footer|0 |72|2|18|Sidebar|0 |72|3|12|Header Nav|0 |72|2|31|Main|0 |72|3|13|Header|0 |72|3|14|Blog Post Header|0 |72|3|17|Blog Post Footer|0 |72|3|18|Sidebar|0 |72|3|35|Blog Post More|0 |73|1|12|Header Nav|0 |72|3|33|Sidebar|0 |72|3|34|Main|0 |73|1|13|Header|0 |73|1|14|Blog Post Header|0 |73|1|15|Main|0 |73|1|16|Blog Post More|0 |73|1|17|Blog Post Footer|0 |73|1|18|Sidebar|0 |73|1|23|Sidebar|0 |73|2|12|Header Nav|0 |73|2|13|Header|0 |73|2|14|Blog Post Header|0 |73|3|13|Header|0 |73|3|12|Header Nav|0 |73|2|17|Blog Post Footer|0 |73|2|18|Sidebar|0 |73|2|23|Sidebar|0 |73|2|36|Main|0 |73|3|14|Blog Post Header|0 |73|3|17|Blog Post Footer|0 |73|3|18|Sidebar|0 |73|3|36|Main|0 |73|3|38|Blog Post More|0 |73|3|39|Sidebar|0 |73|3|40|Blog Post Footer|0 |72|3|40|Blog Post Footer|0 |1|4|2|Header|0 |1|4|43|Header Nav|0 |1|5|2|Header|0 |1|5|48|Header|0 == 表的结构 CollectionVersionBlockStyles |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|0 |//**bID**//|int(10) |否|0 |//**arHandle**//|varchar(255)|否| |csrID|int(10) |否|0 == 表的结构 CollectionVersions |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|1 |cvName|text|是|NULL |cvHandle|varchar(64)|是|NULL |cvDescription|text|是|NULL |cvDatePublic|datetime|是|NULL |cvDateCreated|datetime|否|0000-00-00 00:00:00 |cvComments|varchar(255)|是|NULL |cvIsApproved|tinyint(1)|否|0 |cvIsNew|tinyint(1)|否|0 |cvAuthorUID|int(10) |是|NULL |cvApproverUID|int(10) |是|NULL |cvActivateDatetime|datetime|是|NULL == 转存表中的数据 CollectionVersions |2|1|NULL|NULL|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |1|2|Home|home|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|New Version 2|0|0|1|1|NULL |5|1|Login|login|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |6|1|Register|register|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |7|1|Profile|profile|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |8|1|Edit|edit|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |10|1|Avatar|avatar|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |11|1|Messages|messages|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |12|1|Friends|friends|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |13|1|Page Not Found|page_not_found|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |14|1|Page Forbidden|page_forbidden|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |15|1|Dashboard|dashboard|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |16|1|Sitemap|sitemap|Whole world at a glance.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |17|1|Full Sitemap|full|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |18|1|Flat View|explore|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |19|1|Page Search|search|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |20|1|Access|access|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |21|1|File Manager|files|All documents and images.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |22|1|Search|search|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |23|1|Attributes|attributes|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |24|1|Sets|sets|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |25|1|Access|access|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |26|1|Reports|reports|Get data from forms and logs.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |27|1|Form Results|forms|Get submission data.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |28|1|Surveys|surveys|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |29|1|Logs|logs|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |30|1|Users and Groups|users|Add and manage people.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |31|1|Find Users|search|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |32|1|Add User|add|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |33|1|Groups|groups|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |34|1|User Attributes|attributes|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |35|1|Login & Registration|registration|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |36|1|Scrapbook|scrapbook|Share content across your site.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |37|1|Pages and Themes|pages|Reskin your site.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |38|1|Themes|themes|Reskin your site.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |39|1|Add|add|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |40|1|Inspect|inspect|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |41|1|Customize|customize|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |43|1|Page Types|types|What goes in your site.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |44|1|Attributes|attributes|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |45|1|Single Pages|single|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |46|1|Add Functionality|install|Install addons & themes.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |47|1|System & Maintenance|system|Backup, cleanup and update.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |48|1|Jobs|jobs|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |49|1|Backup & Restore|backup|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |50|1|Update|update|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |51|1|Notifications|notifications|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |52|1|Sitewide Settings|settings|Secure and setup your site.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |53|1|Email|mail|Enable post via email and other settings.|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |54|1|Marketplace|marketplace|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |55|1|Download File|download_file|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|1|NULL|NULL |63|1|NULL|uID=1|NULL|2011-04-19 11:21:09|2011-04-19 11:21:09|Initial Version|1|0|NULL|NULL|NULL |64|1|Members|members|NULL|2010-10-01 16:04:12|2010-10-01 16:04:12|Initial Version|1|0|1|NULL|NULL |1|3|Home|home|NULL|2011-04-19 11:21:09|2011-04-19 11:29:12|New Version 3|0|0|1|1|NULL |1|4|Home|home|NULL|2011-04-19 11:21:09|2011-04-19 11:31:52|Version 4|0|0|1|1|NULL |1|5|Home|home|NULL|2011-04-19 11:21:09|2011-10-11 20:16:12|New Version 5|1|0|1|1|NULL == 表的结构 CollectionVersions |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**cvID**//|int(10) |否|1 |cvName|text|是|NULL |cvHandle|varchar(64)|是|NULL |cvDescription|text|是|NULL |cvDatePublic|datetime|是|NULL |cvDateCreated|datetime|否|0000-00-00 00:00:00 |cvComments|varchar(255)|是|NULL |cvIsApproved|tinyint(1)|否|0 |cvIsNew|tinyint(1)|否|0 |cvAuthorUID|int(10) |是|NULL |cvApproverUID|int(10) |是|NULL |cvActivateDatetime|datetime|是|NULL == 表的结构 Config |------ |字段|类型|空|默认 |------ |//**cfKey**//|varchar(64)|否| |timestamp|timestamp|否|CURRENT_TIMESTAMP |cfValue|longtext|是|NULL |//**uID**//|int(10) |否|0 |pkgID|int(10) |否|0 == 转存表中的数据 Config |SITE|2011-04-19 11:36:12|T O P O F O R M S|0|0 |SITE_APP_VERSION|2011-04-19 11:21:09|5.4.1.1|0|0 |SITE_DEBUG_LEVEL|2011-04-19 11:21:09|1|0|0 |ENABLE_LOG_EMAILS|2011-04-19 11:21:09|1|0|0 |ENABLE_LOG_ERRORS|2011-04-19 11:21:09|1|0|0 |FULL_PAGE_CACHE_GLOBAL|2011-04-19 11:21:09|0|0|0 |ENABLE_MARKETPLACE_SUPPORT|2011-04-19 11:21:55|1|0|0 |APP_VERSION_LATEST|2011-10-08 08:07:44|5.4.2.1|0|0 == 表的结构 Config |------ |字段|类型|空|默认 |------ |//**cfKey**//|varchar(64)|否| |timestamp|timestamp|否|CURRENT_TIMESTAMP |cfValue|longtext|是|NULL |//**uID**//|int(10) |否|0 |pkgID|int(10) |否|0 == 表的结构 CustomStylePresets |------ |字段|类型|空|默认 |------ |//**cspID**//|int(10) |否| |cspName|varchar(255)|否| |csrID|int(10) |否|0 == 转存表中的数据 CustomStylePresets == 表的结构 CustomStylePresets |------ |字段|类型|空|默认 |------ |//**cspID**//|int(10) |否| |cspName|varchar(255)|否| |csrID|int(10) |否|0 == 表的结构 CustomStyleRules |------ |字段|类型|空|默认 |------ |//**csrID**//|int(10) |否| |css_id|varchar(128)|是|NULL |css_class|varchar(128)|是|NULL |css_serialized|text|是|NULL |css_custom|text|是|NULL == 转存表中的数据 CustomStyleRules == 表的结构 CustomStyleRules |------ |字段|类型|空|默认 |------ |//**csrID**//|int(10) |否| |css_id|varchar(128)|是|NULL |css_class|varchar(128)|是|NULL |css_serialized|text|是|NULL |css_custom|text|是|NULL == 表的结构 DashboardHomepage |------ |字段|类型|空|默认 |------ |//**dbhID**//|int(10) |否| |dbhModule|varchar(255)|否| |dbhDisplayName|varchar(255)|是|NULL |dbhDisplayOrder|int(10) |否|0 |pkgID|int(10) |否|0 == 转存表中的数据 DashboardHomepage |1|activity|Site Activity|0|0 |2|reports|Statistics|0|0 |3|help|Help|0|0 |4|news|Latest News|0|0 |5|notes|Notes|0|0 == 表的结构 DashboardHomepage |------ |字段|类型|空|默认 |------ |//**dbhID**//|int(10) |否| |dbhModule|varchar(255)|否| |dbhDisplayName|varchar(255)|是|NULL |dbhDisplayOrder|int(10) |否|0 |pkgID|int(10) |否|0 == 表的结构 DownloadStatistics |------ |字段|类型|空|默认 |------ |//**dsID**//|int(10) |否| |fID|int(10) |否| |fvID|int(10) |否| |uID|int(10) |否| |rcID|int(10) |否| |timestamp|timestamp|否|CURRENT_TIMESTAMP == 转存表中的数据 DownloadStatistics == 表的结构 DownloadStatistics |------ |字段|类型|空|默认 |------ |//**dsID**//|int(10) |否| |fID|int(10) |否| |fvID|int(10) |否| |uID|int(10) |否| |rcID|int(10) |否| |timestamp|timestamp|否|CURRENT_TIMESTAMP == 表的结构 FileAttributeValues |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否|0 |//**fvID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 |//**avID**//|int(10) |否|0 == 转存表中的数据 FileAttributeValues |1|1|9|1 |1|1|10|2 |2|1|9|3 |2|1|10|4 |3|1|9|5 |3|1|10|6 |4|1|9|7 |4|1|10|8 |5|1|9|9 |5|1|10|10 == 表的结构 FileAttributeValues |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否|0 |//**fvID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 |//**avID**//|int(10) |否|0 == 表的结构 FilePermissionFileTypes |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**extension**//|varchar(32)|否| == 转存表中的数据 FilePermissionFileTypes == 表的结构 FilePermissionFileTypes |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**extension**//|varchar(32)|否| == 表的结构 FilePermissions |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |canRead|int(4)|否|0 |canWrite|int(4)|否|0 |canAdmin|int(4)|否|0 |canSearch|int(4)|否|0 == 转存表中的数据 FilePermissions == 表的结构 FilePermissions |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |canRead|int(4)|否|0 |canWrite|int(4)|否|0 |canAdmin|int(4)|否|0 |canSearch|int(4)|否|0 == 表的结构 Files |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否| |fDateAdded|datetime|是|NULL |//**uID**//|int(10) |否|0 |//**fslID**//|int(10) |否|0 |ocID|int(10) |否|0 |fOverrideSetPermissions|int(1)|否|0 |fPassword|varchar(255)|是|NULL == 转存表中的数据 Files |1|2011-04-19 11:21:12|1|0|2|0|NULL |2|2011-04-19 11:21:12|1|0|2|0|NULL |3|2011-04-19 11:21:12|1|0|2|0|NULL |4|2011-04-19 11:21:12|1|0|2|0|NULL |5|2011-04-19 11:21:12|1|0|2|0|NULL == 表的结构 Files |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否| |fDateAdded|datetime|是|NULL |//**uID**//|int(10) |否|0 |//**fslID**//|int(10) |否|0 |ocID|int(10) |否|0 |fOverrideSetPermissions|int(1)|否|0 |fPassword|varchar(255)|是|NULL == 表的结构 FileSearchIndexAttributes |------ |字段|类型|空|默认 |------ |//**fID**//|int(11) |否|0 |ak_width|decimal(14,4)|是|0.0000 |ak_height|decimal(14,4)|是|0.0000 == 转存表中的数据 FileSearchIndexAttributes |1|800.0000|192.0000 |2|800.0000|192.0000 |3|800.0000|192.0000 |4|800.0000|215.0000 |5|800.0000|192.0000 == 表的结构 FileSearchIndexAttributes |------ |字段|类型|空|默认 |------ |//**fID**//|int(11) |否|0 |ak_width|decimal(14,4)|是|0.0000 |ak_height|decimal(14,4)|是|0.0000 == 表的结构 FileSetFiles |------ |字段|类型|空|默认 |------ |//**fsfID**//|int(10) |否| |fID|int(10) |否| |fsID|int(10) |否| |timestamp|timestamp|否|CURRENT_TIMESTAMP |fsDisplayOrder|int(10) |否| == 转存表中的数据 FileSetFiles == 表的结构 FileSetFiles |------ |字段|类型|空|默认 |------ |//**fsfID**//|int(10) |否| |fID|int(10) |否| |fsID|int(10) |否| |timestamp|timestamp|否|CURRENT_TIMESTAMP |fsDisplayOrder|int(10) |否| == 表的结构 FileSetPermissions |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |canRead|int(4)|是|NULL |canWrite|int(4)|是|NULL |canAdmin|int(4)|是|NULL |canAdd|int(4)|是|NULL |canSearch|int(3) |是|NULL == 转存表中的数据 FileSetPermissions |0|1|0|10|0|0|0|0 |0|2|0|10|0|0|0|0 |0|3|0|10|10|10|10|10 == 表的结构 FileSetPermissions |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |canRead|int(4)|是|NULL |canWrite|int(4)|是|NULL |canAdmin|int(4)|是|NULL |canAdd|int(4)|是|NULL |canSearch|int(3) |是|NULL == 表的结构 FileSets |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否| |fsName|varchar(64)|否| |uID|int(10) |否|0 |fsType|int(4)|否| |fsOverrideGlobalPermissions|int(4)|是|NULL == 转存表中的数据 FileSets == 表的结构 FileSets |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否| |fsName|varchar(64)|否| |uID|int(10) |否|0 |fsType|int(4)|否| |fsOverrideGlobalPermissions|int(4)|是|NULL == 表的结构 FileSetSavedSearches |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否|0 |fsSearchRequest|text|是|NULL |fsResultColumns|text|是|NULL == 转存表中的数据 FileSetSavedSearches == 表的结构 FileSetSavedSearches |------ |字段|类型|空|默认 |------ |//**fsID**//|int(10) |否|0 |fsSearchRequest|text|是|NULL |fsResultColumns|text|是|NULL == 表的结构 FileStorageLocations |------ |字段|类型|空|默认 |------ |//**fslID**//|int(10) |否|0 |fslName|varchar(255)|否| |fslDirectory|varchar(255)|否| == 转存表中的数据 FileStorageLocations == 表的结构 FileStorageLocations |------ |字段|类型|空|默认 |------ |//**fslID**//|int(10) |否|0 |fslName|varchar(255)|否| |fslDirectory|varchar(255)|否| == 表的结构 FileVersionLog |------ |字段|类型|空|默认 |------ |//**fvlID**//|int(10) |否| |fID|int(10) |否|0 |fvID|int(10) |否|0 |fvUpdateTypeID|int(3) |否|0 |fvUpdateTypeAttributeID|int(10) |否|0 == 转存表中的数据 FileVersionLog |1|1|1|5|9 |2|1|1|5|10 |3|2|1|5|9 |4|2|1|5|10 |5|3|1|5|9 |6|3|1|5|10 |7|4|1|5|9 |8|4|1|5|10 |9|5|1|5|9 |10|5|1|5|10 |11|1|1|3|0 |12|1|1|4|0 |13|2|1|3|0 |14|2|1|4|0 |15|3|1|3|0 |16|3|1|4|0 |17|4|1|3|0 |18|4|1|4|0 |19|5|1|3|0 |20|5|1|4|0 == 表的结构 FileVersionLog |------ |字段|类型|空|默认 |------ |//**fvlID**//|int(10) |否| |fID|int(10) |否|0 |fvID|int(10) |否|0 |fvUpdateTypeID|int(3) |否|0 |fvUpdateTypeAttributeID|int(10) |否|0 == 表的结构 FileVersions |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否|0 |//**fvID**//|int(10) |否|0 |fvFilename|varchar(255)|否| |fvPrefix|varchar(12)|是|NULL |fvGenericType|int(3) |否|0 |fvSize|int(20) |否|0 |fvTitle|varchar(255)|是|NULL |fvDescription|text|是|NULL |fvTags|varchar(255)|是|NULL |fvIsApproved|int(10) |否|1 |fvDateAdded|datetime|是|NULL |fvApproverUID|int(10) |否|0 |fvAuthorUID|int(10) |否|0 |fvActivateDatetime|datetime|是|NULL |fvHasThumbnail1|int(1)|否|0 |fvHasThumbnail2|int(1)|否|0 |fvHasThumbnail3|int(1)|否|0 |fvExtension|varchar(32)|是|NULL |fvType|int(10) |否|0 == 转存表中的数据 FileVersions |1|1|inneroptics_dot_net_aspens.jpg|371285369023|1|108199|inneroptics_dot_net_aspens.jpg| | |1|2011-04-19 11:21:12|1|1|2011-04-19 11:21:12|1|1|0|jpg|1 |2|1|inneroptics_dot_net_canyonlands.jpg|911285369025|1|54531|inneroptics_dot_net_canyonlands.jpg| | |1|2011-04-19 11:21:12|1|1|2011-04-19 11:21:12|1|1|0|jpg|1 |3|1|inneroptics_dot_net_new_zealand_sheep.jpg|851285369025|1|80735|inneroptics_dot_net_new_zealand_sheep.jpg| | |1|2011-04-19 11:21:12|1|1|2011-04-19 11:21:12|1|1|0|jpg|1 |4|1|inneroptics_dot_net_portland.jpg|711285369026|1|55737|inneroptics_dot_net_portland.jpg| | |1|2011-04-19 11:21:12|1|1|2011-04-19 11:21:12|1|1|0|jpg|1 |5|1|inneroptics_dot_net_starfish.jpg|701285369026|1|88621|inneroptics_dot_net_starfish.jpg| | |1|2011-04-19 11:21:12|1|1|2011-04-19 11:21:12|1|1|0|jpg|1 == 表的结构 FileVersions |------ |字段|类型|空|默认 |------ |//**fID**//|int(10) |否|0 |//**fvID**//|int(10) |否|0 |fvFilename|varchar(255)|否| |fvPrefix|varchar(12)|是|NULL |fvGenericType|int(3) |否|0 |fvSize|int(20) |否|0 |fvTitle|varchar(255)|是|NULL |fvDescription|text|是|NULL |fvTags|varchar(255)|是|NULL |fvIsApproved|int(10) |否|1 |fvDateAdded|datetime|是|NULL |fvApproverUID|int(10) |否|0 |fvAuthorUID|int(10) |否|0 |fvActivateDatetime|datetime|是|NULL |fvHasThumbnail1|int(1)|否|0 |fvHasThumbnail2|int(1)|否|0 |fvHasThumbnail3|int(1)|否|0 |fvExtension|varchar(32)|是|NULL |fvType|int(10) |否|0 == 表的结构 Groups |------ |字段|类型|空|默认 |------ |//**gID**//|int(10) |否| |**gName**|varchar(128)|否| |gDescription|varchar(255)|否| |gUserExpirationIsEnabled|int(1)|否|0 |gUserExpirationMethod|varchar(12)|是|NULL |gUserExpirationSetDateTime|datetime|是|NULL |gUserExpirationInterval|int(10) |否|0 |gUserExpirationAction|varchar(20)|是|NULL == 转存表中的数据 Groups |1|Guest|The guest group represents unregistered visitors to your site.|0|NULL|NULL|0|NULL |2|Registered Users|The registered users group represents all user accounts.|0|NULL|NULL|0|NULL |3|Administrators| |0|NULL|NULL|0|NULL == 表的结构 Groups |------ |字段|类型|空|默认 |------ |//**gID**//|int(10) |否| |**gName**|varchar(128)|否| |gDescription|varchar(255)|否| |gUserExpirationIsEnabled|int(1)|否|0 |gUserExpirationMethod|varchar(12)|是|NULL |gUserExpirationSetDateTime|datetime|是|NULL |gUserExpirationInterval|int(10) |否|0 |gUserExpirationAction|varchar(20)|是|NULL == 表的结构 Jobs |------ |字段|类型|空|默认 |------ |//**jID**//|int(10) |否| |jName|varchar(100)|否| |jDescription|varchar(255)|否| |jDateInstalled|datetime|是|NULL |jDateLastRun|datetime|是|NULL |pkgID|int(10) |否|0 |jLastStatusText|varchar(255)|是|NULL |jLastStatusCode|smallint(4)|否|0 |jStatus|varchar(14)|否|ENABLED |jHandle|varchar(255)|否| |jNotUninstallable|smallint(4)|否|0 == 转存表中的数据 Jobs |1|Index Search Engine|Index the site to allow searching to work quickly and accurately.|2011-04-19 11:21:09|2011-04-19 11:21:09|0|Index updated. 6 pages required reindexing.|0|ENABLED|index_search|1 |2|Generate Sitemap File|Generate the sitemap.xml file that search engines use to crawl your site.|2011-04-19 11:21:09|2011-04-19 11:21:09|0|Sitemap XML File Saved.|0|ENABLED|generate_sitemap|0 |3|Process Email Posts|Polls an email account and grabs private messages/postings that are sent there..|2011-04-19 11:21:09|2011-04-19 11:21:09|0|The Job was run successfully.|0|ENABLED|process_email|0 == 表的结构 Jobs |------ |字段|类型|空|默认 |------ |//**jID**//|int(10) |否| |jName|varchar(100)|否| |jDescription|varchar(255)|否| |jDateInstalled|datetime|是|NULL |jDateLastRun|datetime|是|NULL |pkgID|int(10) |否|0 |jLastStatusText|varchar(255)|是|NULL |jLastStatusCode|smallint(4)|否|0 |jStatus|varchar(14)|否|ENABLED |jHandle|varchar(255)|否| |jNotUninstallable|smallint(4)|否|0 == 表的结构 JobsLog |------ |字段|类型|空|默认 |------ |//**jlID**//|int(10) |否| |jID|int(10) |否| |jlMessage|varchar(255)|否| |jlTimestamp|timestamp|否|CURRENT_TIMESTAMP |jlError|int(10)|否|0 == 转存表中的数据 JobsLog |1|0|Index updated. 6 pages required reindexing.|2011-04-19 11:21:09|0 |2|0|Sitemap XML File Saved.|2011-04-19 11:21:09|0 |3|0|The Job was run successfully.|2011-04-19 11:21:09|0 == 表的结构 JobsLog |------ |字段|类型|空|默认 |------ |//**jlID**//|int(10) |否| |jID|int(10) |否| |jlMessage|varchar(255)|否| |jlTimestamp|timestamp|否|CURRENT_TIMESTAMP |jlError|int(10)|否|0 == 表的结构 LayoutPresets |------ |字段|类型|空|默认 |------ |//**lpID**//|int(10) |否| |lpName|varchar(128)|否| |**layoutID**|int(10) |否|0 == 转存表中的数据 LayoutPresets == 表的结构 LayoutPresets |------ |字段|类型|空|默认 |------ |//**lpID**//|int(10) |否| |lpName|varchar(128)|否| |**layoutID**|int(10) |否|0 == 表的结构 Layouts |------ |字段|类型|空|默认 |------ |//**layoutID**//|int(10) |否| |layout_rows|int(5)|否|3 |layout_columns|int(3)|否|3 |spacing|int(3)|否|3 |breakpoints|varchar(255)|否| |locked|tinyint(1)|否|0 == 转存表中的数据 Layouts == 表的结构 Layouts |------ |字段|类型|空|默认 |------ |//**layoutID**//|int(10) |否| |layout_rows|int(5)|否|3 |layout_columns|int(3)|否|3 |spacing|int(3)|否|3 |breakpoints|varchar(255)|否| |locked|tinyint(1)|否|0 == 表的结构 Logs |------ |字段|类型|空|默认 |------ |//**logID**//|int(10) |否| |logType|varchar(64)|否| |timestamp|timestamp|否|CURRENT_TIMESTAMP |logText|longtext|是|NULL |logIsInternal|tinyint(1)|否|0 == 转存表中的数据 Logs |1|sent_emails|2011-10-08 08:06:36|**EMAILS ARE ENABLED. THIS EMAIL WAS SENT TO mail()** Template Used: forgot_password To: royizhu@gmail.com From: &quot;Forgot Password&quot; &lt;royizhu@gmail.com&gt; Subject: Forgot Password Body: Dear admin, You have requested a new password for the site T O P O F O R M S Your username is: admin You may change your password at the following address: http://www.topoforms.com/index.php/login/change_password/RS2ZSs30lmzq/ Thanks for browsing the site! |1 |2|sent_emails|2011-10-11 20:13:59|**EMAILS ARE ENABLED. THIS EMAIL WAS SENT TO mail()** Template Used: forgot_password To: royizhu@gmail.com From: &quot;Forgot Password&quot; &lt;royizhu@gmail.com&gt; Subject: Forgot Password Body: Dear admin, You have requested a new password for the site T O P O F O R M S Your username is: admin You may change your password at the following address: http://www.topoforms.com/index.php/login/change_password/NWPCh7EJvzUV/ Thanks for browsing the site! |1 == 表的结构 Logs |------ |字段|类型|空|默认 |------ |//**logID**//|int(10) |否| |logType|varchar(64)|否| |timestamp|timestamp|否|CURRENT_TIMESTAMP |logText|longtext|是|NULL |logIsInternal|tinyint(1)|否|0 == 表的结构 MailImporters |------ |字段|类型|空|默认 |------ |//**miID**//|int(10) |否| |miHandle|varchar(64)|否| |miServer|varchar(255)|是|NULL |miUsername|varchar(255)|是|NULL |miPassword|varchar(255)|是|NULL |miEncryption|varchar(32)|是|NULL |miIsEnabled|int(1)|否|0 |miEmail|varchar(255)|是|NULL |miPort|int(10) |否|0 |pkgID|int(10) |是|NULL == 转存表中的数据 MailImporters |1|private_message|NULL|NULL|NULL|NULL|0|NULL|0|0 == 表的结构 MailImporters |------ |字段|类型|空|默认 |------ |//**miID**//|int(10) |否| |miHandle|varchar(64)|否| |miServer|varchar(255)|是|NULL |miUsername|varchar(255)|是|NULL |miPassword|varchar(255)|是|NULL |miEncryption|varchar(32)|是|NULL |miIsEnabled|int(1)|否|0 |miEmail|varchar(255)|是|NULL |miPort|int(10) |否|0 |pkgID|int(10) |是|NULL == 表的结构 MailValidationHashes |------ |字段|类型|空|默认 |------ |//**mvhID**//|int(10) |否| |miID|int(10) |否|0 |email|varchar(255)|否| |mHash|varchar(128)|否| |mDateGenerated|int(10) |否|0 |mDateRedeemed|int(10) |否|0 |data|text|是|NULL == 转存表中的数据 MailValidationHashes == 表的结构 MailValidationHashes |------ |字段|类型|空|默认 |------ |//**mvhID**//|int(10) |否| |miID|int(10) |否|0 |email|varchar(255)|否| |mHash|varchar(128)|否| |mDateGenerated|int(10) |否|0 |mDateRedeemed|int(10) |否|0 |data|text|是|NULL == 表的结构 Packages |------ |字段|类型|空|默认 |------ |//**pkgID**//|int(10) |否| |pkgName|varchar(255)|否| |**pkgHandle**|varchar(64)|否| |pkgDescription|text|是|NULL |pkgDateInstalled|datetime|否| |pkgIsInstalled|tinyint(1)|否|1 |pkgVersion|varchar(32)|是|NULL |pkgAvailableVersion|varchar(32)|是|NULL == 转存表中的数据 Packages == 表的结构 Packages |------ |字段|类型|空|默认 |------ |//**pkgID**//|int(10) |否| |pkgName|varchar(255)|否| |**pkgHandle**|varchar(64)|否| |pkgDescription|text|是|NULL |pkgDateInstalled|datetime|否| |pkgIsInstalled|tinyint(1)|否|1 |pkgVersion|varchar(32)|是|NULL |pkgAvailableVersion|varchar(32)|是|NULL == 表的结构 PagePaths |------ |字段|类型|空|默认 |------ |//**ppID**//|int(10) |否| |cID|int(10) |是|0 |cPath|text|是|NULL |ppIsCanonical|varchar(1)|否|1 == 转存表中的数据 PagePaths |1|5|/login|1 |2|6|/register|1 |3|7|/profile|1 |4|8|/profile/edit|1 |6|10|/profile/avatar|1 |7|11|/profile/messages|1 |8|12|/profile/friends|1 |9|13|/page_not_found|1 |10|14|/page_forbidden|1 |11|15|/dashboard|1 |12|16|/dashboard/sitemap|1 |13|17|/dashboard/sitemap/full|1 |14|18|/dashboard/sitemap/explore|1 |15|19|/dashboard/sitemap/search|1 |16|20|/dashboard/sitemap/access|1 |17|21|/dashboard/files|1 |18|22|/dashboard/files/search|1 |19|23|/dashboard/files/attributes|1 |20|24|/dashboard/files/sets|1 |21|25|/dashboard/files/access|1 |22|26|/dashboard/reports|1 |23|27|/dashboard/reports/forms|1 |24|28|/dashboard/reports/surveys|1 |25|29|/dashboard/reports/logs|1 |26|30|/dashboard/users|1 |27|31|/dashboard/users/search|1 |28|32|/dashboard/users/add|1 |29|33|/dashboard/users/groups|1 |30|34|/dashboard/users/attributes|1 |31|35|/dashboard/users/registration|1 |32|36|/dashboard/scrapbook|1 |33|37|/dashboard/pages|1 |34|38|/dashboard/pages/themes|1 |35|39|/dashboard/pages/themes/add|1 |36|40|/dashboard/pages/themes/inspect|1 |37|41|/dashboard/pages/themes/customize|1 |39|43|/dashboard/pages/types|1 |40|44|/dashboard/pages/attributes|1 |41|45|/dashboard/pages/single|1 |42|46|/dashboard/install|1 |43|47|/dashboard/system|1 |44|48|/dashboard/system/jobs|1 |45|49|/dashboard/system/backup|1 |46|50|/dashboard/system/update|1 |47|51|/dashboard/system/notifications|1 |48|52|/dashboard/settings|1 |49|53|/dashboard/settings/mail|1 |50|54|/dashboard/settings/marketplace|1 |51|55|/download_file|1 |52|64|/members|1 == 表的结构 PagePaths |------ |字段|类型|空|默认 |------ |//**ppID**//|int(10) |否| |cID|int(10) |是|0 |cPath|text|是|NULL |ppIsCanonical|varchar(1)|否|1 == 表的结构 PagePermissionPageTypes |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**ctID**//|int(10) |否|0 == 转存表中的数据 PagePermissionPageTypes == 表的结构 PagePermissionPageTypes |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**ctID**//|int(10) |否|0 == 表的结构 PagePermissions |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |cgPermissions|varchar(32)|是|NULL |cgStartDate|datetime|是|NULL |cgEndDate|datetime|是|NULL == 转存表中的数据 PagePermissions |5|1|0|r|NULL|NULL |5|2|0|r|NULL|NULL |6|1|0|r|NULL|NULL |15|3|0|r:wa:adm|NULL|NULL |1|1|0|r|NULL|NULL |1|3|0|r:rv:wa:db:av:dc:adm|NULL|NULL == 表的结构 PagePermissions |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |cgPermissions|varchar(32)|是|NULL |cgStartDate|datetime|是|NULL |cgEndDate|datetime|是|NULL == 表的结构 Pages |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |ctID|int(10) |否|0 |cIsTemplate|varchar(1)|否|0 |uID|int(10) |是|NULL |cIsCheckedOut|tinyint(1)|否|0 |cCheckedOutUID|int(10) |是|NULL |cCheckedOutDatetime|datetime|是|NULL |cCheckedOutDatetimeLastEdit|datetime|是|NULL |cPendingAction|varchar(6)|是|NULL |cPendingActionDatetime|datetime|否|0000-00-00 00:00:00 |cPendingActionUID|int(10) |是|NULL |cPendingActionTargetCID|int(10) |是|NULL |cOverrideTemplatePermissions|tinyint(1)|否|1 |cInheritPermissionsFromCID|int(10) |否|0 |cInheritPermissionsFrom|varchar(8)|否|PARENT |cFilename|varchar(255)|是|NULL |cPointerID|int(10) |否|0 |cPointerExternalLink|varchar(255)|是|NULL |cPointerExternalLinkNewWindow|tinyint(1)|否|0 |cChildren|int(10) |否|0 |cDisplayOrder|int(10) |否|0 |cParentID|int(10) |否|0 |pkgID|int(10) |否|0 |ptID|int(10) |否|0 |cCacheFullPageContent|int(4)|否|-1 |cCacheFullPageContentOverrideLifetime|varchar(32)|否|0 |cCacheFullPageContentLifetimeCustom|int(10) |否|0 == 转存表中的数据 Pages |1|1|0|1|1|1|2011-10-11 21:37:37|2011-10-11 21:37:37|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|OVERRIDE|NULL|0|NULL|0|7|0|0|0|1|-1|0|0 |2|1|1|NULL|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|0|PARENT|NULL|0|NULL|0|0|0|0|0|0|-1|0|0 |5|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|5|OVERRIDE|/login.php|0|NULL|0|0|0|1|0|1|-1|0|0 |6|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|6|OVERRIDE|/register.php|0|NULL|0|0|1|1|0|1|-1|0|0 |7|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/profile/view.php|0|NULL|0|4|2|1|0|1|-1|0|0 |8|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/profile/edit.php|0|NULL|0|0|0|7|0|1|-1|0|0 |10|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/profile/avatar.php|0|NULL|0|0|1|7|0|1|-1|0|0 |11|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/profile/messages.php|0|NULL|0|0|2|7|0|1|-1|0|0 |12|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/profile/friends.php|0|NULL|0|0|3|7|0|1|-1|0|0 |13|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/page_not_found.php|0|NULL|0|0|4|1|0|1|-1|0|0 |14|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/page_forbidden.php|0|NULL|0|0|5|1|0|1|-1|0|0 |15|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|OVERRIDE|/dashboard/view.php|0|NULL|0|9|6|1|0|0|-1|0|0 |16|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/sitemap/view.php|0|NULL|0|4|0|15|0|0|-1|0|0 |17|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/sitemap/full.php|0|NULL|0|0|0|16|0|0|-1|0|0 |18|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/sitemap/explore.php|0|NULL|0|0|1|16|0|0|-1|0|0 |19|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/sitemap/search.php|0|NULL|0|0|2|16|0|0|-1|0|0 |20|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/sitemap/access.php|0|NULL|0|0|3|16|0|0|-1|0|0 |21|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/files/view.php|0|NULL|0|4|1|15|0|0|-1|0|0 |22|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/files/search.php|0|NULL|0|0|0|21|0|0|-1|0|0 |23|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/files/attributes.php|0|NULL|0|0|1|21|0|0|-1|0|0 |24|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/files/sets.php|0|NULL|0|0|2|21|0|0|-1|0|0 |25|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/files/access.php|0|NULL|0|0|3|21|0|0|-1|0|0 |26|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/reports.php|0|NULL|0|3|2|15|0|0|-1|0|0 |27|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/reports/forms.php|0|NULL|0|0|0|26|0|0|-1|0|0 |28|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/reports/surveys.php|0|NULL|0|0|1|26|0|0|-1|0|0 |29|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/reports/logs.php|0|NULL|0|0|2|26|0|0|-1|0|0 |30|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/users/view.php|0|NULL|0|5|3|15|0|0|-1|0|0 |31|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/users/search.php|0|NULL|0|0|0|30|0|0|-1|0|0 |32|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/users/add.php|0|NULL|0|0|1|30|0|0|-1|0|0 |33|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/users/groups.php|0|NULL|0|0|2|30|0|0|-1|0|0 |34|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/users/attributes.php|0|NULL|0|0|3|30|0|0|-1|0|0 |35|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/users/registration.php|0|NULL|0|0|4|30|0|0|-1|0|0 |36|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/scrapbook/view.php|0|NULL|0|0|4|15|0|0|-1|0|0 |37|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/view.php|0|NULL|0|4|5|15|0|0|-1|0|0 |38|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/themes/view.php|0|NULL|0|4|0|37|0|0|-1|0|0 |39|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/themes/add.php|0|NULL|0|0|0|38|0|0|-1|0|0 |40|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/themes/inspect.php|0|NULL|0|0|1|38|0|0|-1|0|0 |41|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/themes/customize.php|0|NULL|0|0|2|38|0|0|-1|0|0 |43|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/types/view.php|0|NULL|0|0|1|37|0|0|-1|0|0 |44|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/attributes.php|0|NULL|0|0|2|37|0|0|-1|0|0 |45|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/pages/single.php|0|NULL|0|0|3|37|0|0|-1|0|0 |46|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/install.php|0|NULL|0|0|6|15|0|0|-1|0|0 |47|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/system/view.php|0|NULL|0|4|7|15|0|0|-1|0|0 |48|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/system/jobs.php|0|NULL|0|0|0|47|0|0|-1|0|0 |49|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/system/backup.php|0|NULL|0|0|1|47|0|0|-1|0|0 |50|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/system/update.php|0|NULL|0|0|2|47|0|0|-1|0|0 |51|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/system/notifications.php|0|NULL|0|0|3|47|0|0|-1|0|0 |52|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/settings/view.php|0|NULL|0|2|8|15|0|0|-1|0|0 |53|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/settings/mail/view.php|0|NULL|0|0|0|52|0|0|-1|0|0 |54|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|15|PARENT|/dashboard/settings/marketplace.php|0|NULL|0|0|1|52|0|0|-1|0|0 |55|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/download_file.php|0|NULL|0|0|7|1|0|0|-1|0|0 |64|0|0|1|0|NULL|NULL|NULL|NULL|2011-04-19 11:21:10|NULL|NULL|1|1|PARENT|/members.php|0|NULL|0|0|7|1|0|0|-1|0|0 == 表的结构 Pages |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |ctID|int(10) |否|0 |cIsTemplate|varchar(1)|否|0 |uID|int(10) |是|NULL |cIsCheckedOut|tinyint(1)|否|0 |cCheckedOutUID|int(10) |是|NULL |cCheckedOutDatetime|datetime|是|NULL |cCheckedOutDatetimeLastEdit|datetime|是|NULL |cPendingAction|varchar(6)|是|NULL |cPendingActionDatetime|datetime|否|0000-00-00 00:00:00 |cPendingActionUID|int(10) |是|NULL |cPendingActionTargetCID|int(10) |是|NULL |cOverrideTemplatePermissions|tinyint(1)|否|1 |cInheritPermissionsFromCID|int(10) |否|0 |cInheritPermissionsFrom|varchar(8)|否|PARENT |cFilename|varchar(255)|是|NULL |cPointerID|int(10) |否|0 |cPointerExternalLink|varchar(255)|是|NULL |cPointerExternalLinkNewWindow|tinyint(1)|否|0 |cChildren|int(10) |否|0 |cDisplayOrder|int(10) |否|0 |cParentID|int(10) |否|0 |pkgID|int(10) |否|0 |ptID|int(10) |否|0 |cCacheFullPageContent|int(4)|否|-1 |cCacheFullPageContentOverrideLifetime|varchar(32)|否|0 |cCacheFullPageContentLifetimeCustom|int(10) |否|0 == 表的结构 PageSearchIndex |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |content|text|是|NULL |cName|varchar(255)|是|NULL |cDescription|text|是|NULL |cPath|text|是|NULL |cDatePublic|datetime|是|NULL |cDateLastIndexed|datetime|是|NULL |cDateLastSitemapped|datetime|是|NULL == 转存表中的数据 PageSearchIndex |1|l a n d s c a p e&nbsp;&nbsp;&nbsp; a r c h i t e c t u r e&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; u r b a n&nbsp;&nbsp;&nbsp; d e s i g n&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp; p l a n n i n g &nbsp; &nbsp; for all inquiries, please email us at info@topoforms.com |Home|NULL|NULL|2011-04-19 11:21:09|2011-10-11 20:31:40|NULL |67|Site Map |Search| |/search|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |68| |Search Results| |/search/search-results|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |66| Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum vel tellus lectus, scelerisque faucibus nunc. Curabitur lacus nibh, eleifend vel porttitor in, bibendum quis tortor. Curabitur eros ligula, scelerisque ac ultricies a, dictum ac tellus. Mauris id tellus tortor. Proin a sollicitudin libero. Nam pellentesque commodo magna, nec mattis elit pulvinar id. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris orci dui, adipiscing sit amet bibendum vel, sodales sed purus. Donec fringilla odio vel enim cursus luctus quis semper leo. Donec rhoncus odio ac elit dignissim lobortis. &nbsp; Duis dapibus nibh eu arcu viverra tempor. Fusce auctor sapien eu mauris malesuada vel euismod orci vulputate. Curabitur at orci id quam mollis rhoncus vitae volutpat urna. Nam eget sapien at neque mollis varius sed vitae ipsum. Vestibulum commodo, eros sit amet sagittis cursus, massa mi lacinia lorem, vel pellentesque sapien purus eu lacus. Pellentesque mollis gravida enim. Fusce mi odio, elementum ut fermentum a, pharetra in quam. Mauris sed vestibulum sapien. In sit amet faucibus diam. Proin lectus quam, sodales ut posuere non, viverra a nibh. Aenean sollicitudin, diam eu elementum rutrum, nisi ante pretium mi, ut tristique ante tellus non ligula. Nam diam turpis, viverra non volutpat vel, scelerisque vel neque. In pretium, libero et vulputate varius, libero nulla blandit ligula, tincidunt egestas leo mi eu nisi. Mauris nunc augue, cursus vel viverra non, feugiat in enim. In eget dignissim est. Donec dictum leo in libero tincidunt sollicitudin hendrerit elit placerat. Aliquam vitae nunc diam, non vulputate nibh. Quisque tincidunt, dui ut rutrum feugiat, libero lorem interdum sapien, eget pharetra mi ligula ut lectus. Pellentesque consequat mollis est viverra malesuada. Curabitur eget quam vitae tellus blandit congue a sed lectus. Nunc ultrices lacus dignissim felis venenatis varius placerat eros dapibus. Nulla facilisi. Vivamus sodales accumsan convallis. Mauris congue tempus feugiat. Proin elementum fringilla leo, sit amet pretium nisl imperdiet interdum. Suspendisse volutpat cursus eros, nec porta est laoreet at. Sed porttitor suscipit augue, eu molestie justo faucibus et. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vivamus faucibus mi vel tortor consequat eget rutrum nisl ultrices. Praesent et lacinia augue. Phasellus id est id enim ultricies placerat. Etiam porta enim eu enim convallis sed eleifend metus faucibus. In ac lobortis eros. Pellentesque felis turpis, cursus sed imperdiet non, viverra vel diam. Donec vel orci mi, placerat egestas purus. Vestibulum vel diam id magna suscipit accumsan. Quisque risus felis, sagittis non iaculis id, tempus in arcu. Donec tempus metus neque. Proin malesuada dui a tortor pretium tincidunt quis at ligula. Nam laoreet faucibus purus ac pretium. Aenean euismod diam adipiscing erat semper quis sodales elit tristique. Vestibulum vel tellus eu lorem porttitor aliquet. Vestibulum bibendum viverra cursus. Aenean sit amet magna odio, convallis imperdiet metus. Duis condimentum posuere vulputate. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed vitae elit ut sapien vestibulum tempor sit amet ac tortor. Donec ligula nulla, varius id ornare id, vestibulum non felis. Nullam neque erat, tristique a eleifend pellentesque, eleifend sit amet ipsum. In eget urna nibh. Phasellus scelerisque, magna ac feugiat ultricies, risus dolor volutpat quam, in rutrum nunc ante id sem. Fusce interdum scelerisque fermentum. &nbsp; | |NULL|NULL|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |69|Learn More Visit&nbsp;concrete5.org&nbsp;to learn more from the&nbsp;community&nbsp;and the&nbsp;documentation. You can also browse our&nbsp;marketplace&nbsp;for more&nbsp;add-ons&nbsp;and&nbsp;themes&nbsp;to quickly build the site you really need.&nbsp; &nbsp; Common Tips Want to&nbsp;change your site name&nbsp;up top? Need to sell stuff on your website? Check out our&nbsp;eCommerce add-on. Help,&nbsp;I can't login&nbsp;anymore! &nbsp; |About| |/about|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |70|Say Hi! Here's a simple guestbook you can add to any page on your website to allow comments. Why not put the guestbook block in edit mode and play with the options? We also have a fully featured&nbsp;Discussions Forum Add-on&nbsp;if you need it.&nbsp; &nbsp; |Guestbook| |/about/guest-book|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |71| |Blog| |/about/guest-book/blog|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |72| This is the intro of your blog post. If your post is short, just stick it all in here. Everything in the "Main" block area will be displayed from the main&nbsp;blog list page. If you tend to write long blog posts that go on, and on, and on - you should consider keeping that content in this "Blog Post More" block area. This area only shows up to visitors who click on the blog post's title or more link to read the full post.&nbsp; Keep your long posts in here and just a short synopsis up top if you'd like a nice scannable blog. |My First Blog Post| |/blog/my-first-blog-post|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL |73| In-context editing is pretty cool cool! By now you've probably watched through the basics at concrete5.org, so you're getting a good sense of how you can add pages around your site. To make a new blog post... Goto the blog list page, this is the holder page for all your posts in the site tree.&nbsp; Click Add Page, on the upper left.&nbsp; Pick Blog Entry as a page type.&nbsp; Give it a name and hit return, or click the add page button at the bottom of the drop down. (You don't need to worry about all these other fields yet, you can always change them later through Edit Page &gt; Properties You're now on your new blog post page, in edit mode. Start making blocks and get things looking right.&nbsp; Exit Edit Mode and Publish your changes.&nbsp; |Adding a New Post| |/blog/adding-a-new-post|2011-04-19 11:21:12|2011-04-19 11:21:12|NULL == 表的结构 PageSearchIndex |------ |字段|类型|空|默认 |------ |//**cID**//|int(10) |否|0 |content|text|是|NULL |cName|varchar(255)|是|NULL |cDescription|text|是|NULL |cPath|text|是|NULL |cDatePublic|datetime|是|NULL |cDateLastIndexed|datetime|是|NULL |cDateLastSitemapped|datetime|是|NULL == 表的结构 PageStatistics |------ |字段|类型|空|默认 |------ |//**pstID**//|bigint(20) |否| |cID|int(10) |否|0 |date|date|是|NULL |timestamp|timestamp|否|CURRENT_TIMESTAMP |uID|int(10) |否|0 == 转存表中的数据 PageStatistics |1|1|2011-04-19|2011-04-19 11:21:55|0 |2|1|2011-04-19|2011-04-19 11:22:05|0 |3|5|2011-04-19|2011-04-19 11:22:11|0 |4|5|2011-04-19|2011-04-19 11:22:26|0 |5|1|2011-04-19|2011-04-19 11:22:27|1 |6|5|2011-04-19|2011-04-19 11:24:08|1 |7|1|2011-04-19|2011-04-19 11:24:09|1 |8|1|2011-04-19|2011-04-19 11:26:04|1 |9|1|2011-04-19|2011-04-19 11:26:18|1 |10|1|2011-04-19|2011-04-19 11:28:33|1 |11|1|2011-04-19|2011-04-19 11:28:43|1 |12|1|2011-04-19|2011-04-19 11:28:48|1 |13|1|2011-04-19|2011-04-19 11:29:35|1 |14|1|2011-04-19|2011-04-19 11:29:41|1 |15|1|2011-04-19|2011-04-19 11:29:47|1 |16|1|2011-04-19|2011-04-19 11:29:52|1 |17|1|2011-04-19|2011-04-19 11:30:32|1 |18|1|2011-04-19|2011-04-19 11:35:24|1 |19|52|2011-04-19|2011-04-19 11:35:53|1 |20|52|2011-04-19|2011-04-19 11:36:12|1 |21|52|2011-04-19|2011-04-19 11:36:13|1 |22|53|2011-04-19|2011-04-19 11:36:19|1 |23|52|2011-04-19|2011-04-19 11:36:34|1 |24|1|2011-04-19|2011-04-19 11:36:37|1 |25|1|2011-04-19|2011-04-19 11:36:50|1 |26|1|2011-04-19|2011-04-19 11:37:02|1 |27|1|2011-04-19|2011-04-19 11:37:52|1 |28|5|2011-04-19|2011-04-19 11:38:04|1 |29|1|2011-04-19|2011-04-19 11:38:05|0 |30|1|2011-04-19|2011-04-19 18:16:52|0 |31|5|2011-04-19|2011-04-19 18:18:07|0 |32|5|2011-04-19|2011-04-19 18:18:25|0 |33|5|2011-04-19|2011-04-19 18:18:38|0 |34|1|2011-04-19|2011-04-19 18:18:39|1 |35|15|2011-04-19|2011-04-19 18:19:16|1 |36|37|2011-04-19|2011-04-19 18:19:23|1 |37|38|2011-04-19|2011-04-19 18:19:24|1 |38|45|2011-04-19|2011-04-19 18:19:45|1 |39|1|2011-04-19|2011-04-19 18:19:56|1 |40|1|2011-04-19|2011-04-19 18:20:11|1 |41|1|2011-04-19|2011-04-19 18:20:18|1 |42|5|2011-04-19|2011-04-19 18:20:27|1 |43|5|2011-04-19|2011-04-19 18:20:27|0 |44|1|2011-04-19|2011-04-19 18:20:27|0 |45|1|2011-04-19|2011-04-19 18:21:00|0 |46|5|2011-04-19|2011-04-19 18:22:19|0 |47|5|2011-04-19|2011-04-19 18:22:32|0 |48|5|2011-04-19|2011-04-19 18:22:45|0 |49|5|2011-04-19|2011-04-19 18:23:00|0 |50|1|2011-04-19|2011-04-19 18:23:01|1 |51|1|2011-04-19|2011-04-19 18:23:16|1 |52|1|2011-04-19|2011-04-19 18:23:25|1 |53|1|2011-04-19|2011-04-19 18:23:40|1 |54|15|2011-04-19|2011-04-19 18:24:48|1 |55|30|2011-04-19|2011-04-19 18:24:53|1 |56|31|2011-04-19|2011-04-19 18:24:54|1 |57|32|2011-04-19|2011-04-19 18:25:24|1 |58|35|2011-04-19|2011-04-19 18:25:38|1 |59|1|2011-04-19|2011-04-19 18:31:44|0 |60|1|2011-04-19|2011-04-19 18:32:58|0 |61|1|2011-04-19|2011-04-19 18:33:13|0 |62|1|2011-04-19|2011-04-19 18:35:24|0 |63|1|2011-04-19|2011-04-19 20:39:17|0 |64|5|2011-04-19|2011-04-19 20:39:41|0 |65|5|2011-04-19|2011-04-19 20:39:55|0 |66|1|2011-04-19|2011-04-19 20:39:56|1 |67|1|2011-04-19|2011-04-19 20:41:03|1 |68|1|2011-04-19|2011-04-19 20:43:30|0 |69|1|2011-04-19|2011-04-19 20:50:23|0 |70|1|2011-04-19|2011-04-19 20:50:33|0 |71|1|2011-04-19|2011-04-19 20:52:09|0 |72|1|2011-04-19|2011-04-19 21:06:26|0 |73|1|2011-04-19|2011-04-19 21:23:18|0 |74|1|2011-04-20|2011-04-20 00:14:08|0 |75|1|2011-04-20|2011-04-20 00:26:39|0 |76|1|2011-04-20|2011-04-20 02:12:34|0 |77|1|2011-04-20|2011-04-20 02:24:16|0 |78|1|2011-04-20|2011-04-20 02:24:29|0 |79|5|2011-04-20|2011-04-20 02:24:32|0 |80|5|2011-04-20|2011-04-20 02:24:42|0 |81|1|2011-04-20|2011-04-20 02:24:43|1 |82|1|2011-04-20|2011-04-20 02:25:51|1 |83|1|2011-04-20|2011-04-20 02:25:55|1 |84|1|2011-04-20|2011-04-20 02:26:31|1 |85|1|2011-04-20|2011-04-20 02:26:54|1 |86|1|2011-04-20|2011-04-20 02:27:04|1 |87|1|2011-04-20|2011-04-20 09:33:38|0 |88|5|2011-04-20|2011-04-20 09:34:19|0 |89|5|2011-04-20|2011-04-20 09:34:35|0 |90|1|2011-04-20|2011-04-20 09:34:36|1 |91|1|2011-04-20|2011-04-20 09:35:06|1 |92|1|2011-04-20|2011-04-20 09:36:13|1 |93|15|2011-04-20|2011-04-20 09:36:20|1 |94|30|2011-04-20|2011-04-20 09:36:29|1 |95|31|2011-04-20|2011-04-20 09:36:29|1 |96|30|2011-04-20|2011-04-20 09:36:42|1 |97|31|2011-04-20|2011-04-20 09:36:42|1 |98|32|2011-04-20|2011-04-20 09:36:50|1 |99|52|2011-04-20|2011-04-20 09:37:16|1 |100|30|2011-04-20|2011-04-20 09:38:17|1 |101|31|2011-04-20|2011-04-20 09:38:18|1 |102|16|2011-04-20|2011-04-20 09:38:23|1 |103|17|2011-04-20|2011-04-20 09:38:24|1 |104|30|2011-04-20|2011-04-20 09:38:39|1 |105|31|2011-04-20|2011-04-20 09:38:41|1 |106|33|2011-04-20|2011-04-20 09:38:55|1 |107|34|2011-04-20|2011-04-20 09:38:56|1 |108|32|2011-04-20|2011-04-20 09:39:02|1 |109|35|2011-04-20|2011-04-20 09:39:06|1 |110|32|2011-04-20|2011-04-20 09:39:24|1 |111|1|2011-04-20|2011-04-20 09:40:21|0 |112|1|2011-04-20|2011-04-20 11:11:34|0 |113|1|2011-04-20|2011-04-20 11:12:22|0 |114|1|2011-04-20|2011-04-20 11:12:33|0 |115|1|2011-04-20|2011-04-20 11:12:47|0 |116|1|2011-04-20|2011-04-20 11:16:55|0 |117|1|2011-04-20|2011-04-20 11:17:22|0 |118|1|2011-04-20|2011-04-20 11:18:19|0 |119|1|2011-04-20|2011-04-20 11:22:18|0 |120|5|2011-04-20|2011-04-20 11:22:31|0 |121|1|2011-04-20|2011-04-20 11:38:28|0 |122|5|2011-04-20|2011-04-20 11:38:31|0 |123|5|2011-04-20|2011-04-20 11:38:44|0 |124|1|2011-04-20|2011-04-20 12:02:06|0 |125|5|2011-04-20|2011-04-20 16:15:00|0 |126|1|2011-04-20|2011-04-20 20:23:48|0 |127|1|2011-04-21|2011-04-21 01:25:05|0 |128|1|2011-04-21|2011-04-21 07:33:34|0 |129|1|2011-04-21|2011-04-21 07:48:17|0 |130|1|2011-04-21|2011-04-21 10:01:39|0 |131|1|2011-04-21|2011-04-21 17:34:50|0 |132|1|2011-04-21|2011-04-21 17:35:54|0 |133|1|2011-04-21|2011-04-21 20:23:26|0 |134|1|2011-04-21|2011-04-21 22:05:54|0 |135|1|2011-04-21|2011-04-21 23:32:22|0 |136|5|2011-04-21|2011-04-21 23:43:14|0 |137|1|2011-04-22|2011-04-22 05:57:25|0 |138|1|2011-04-22|2011-04-22 16:56:09|0 |139|1|2011-04-22|2011-04-22 19:06:17|0 |140|1|2011-04-22|2011-04-22 20:30:58|0 |141|1|2011-04-23|2011-04-23 01:32:58|0 |142|1|2011-04-23|2011-04-23 05:37:45|0 |143|1|2011-04-23|2011-04-23 10:50:05|0 |144|5|2011-04-23|2011-04-23 10:50:07|0 |145|1|2011-04-23|2011-04-23 10:57:34|0 |146|1|2011-04-23|2011-04-23 20:15:22|0 |147|1|2011-04-23|2011-04-23 20:37:17|0 |148|1|2011-04-24|2011-04-24 09:36:00|0 |149|1|2011-04-25|2011-04-25 13:51:26|0 |150|1|2011-04-25|2011-04-25 16:46:04|0 |151|1|2011-04-26|2011-04-26 01:23:41|0 |152|1|2011-04-26|2011-04-26 01:23:48|0 |153|1|2011-04-26|2011-04-26 14:43:45|0 |154|1|2011-04-26|2011-04-26 20:45:05|0 |155|1|2011-04-27|2011-04-27 02:19:34|0 |156|1|2011-04-27|2011-04-27 15:20:53|0 |157|1|2011-04-27|2011-04-27 21:18:37|0 |158|1|2011-04-27|2011-04-27 21:54:42|0 |159|1|2011-04-28|2011-04-28 06:50:26|0 |160|1|2011-04-28|2011-04-28 06:52:25|0 |161|1|2011-04-28|2011-04-28 21:46:02|0 |162|1|2011-04-29|2011-04-29 04:49:00|0 |163|1|2011-04-29|2011-04-29 08:09:23|0 |164|1|2011-04-29|2011-04-29 10:10:21|0 |165|1|2011-04-29|2011-04-29 10:10:22|0 |166|1|2011-04-29|2011-04-29 10:10:36|0 |167|1|2011-04-29|2011-04-29 10:30:26|0 |168|1|2011-04-29|2011-04-29 11:23:04|0 |169|1|2011-04-29|2011-04-29 23:22:22|0 |170|1|2011-04-29|2011-04-29 23:22:40|0 |171|1|2011-04-30|2011-04-30 00:25:19|0 |172|1|2011-04-30|2011-04-30 00:25:25|0 |173|1|2011-04-30|2011-04-30 02:22:22|0 |174|1|2011-04-30|2011-04-30 06:07:11|0 |175|1|2011-04-30|2011-04-30 15:32:41|0 |176|1|2011-04-30|2011-04-30 23:51:53|0 |177|1|2011-05-01|2011-05-01 03:39:23|0 |178|1|2011-05-01|2011-05-01 03:39:28|0 |179|5|2011-05-01|2011-05-01 03:39:31|0 |180|1|2011-05-01|2011-05-01 08:03:15|0 |181|1|2011-05-01|2011-05-01 08:13:46|0 |182|1|2011-05-01|2011-05-01 08:14:34|0 |183|1|2011-05-02|2011-05-02 11:07:36|0 |184|1|2011-05-02|2011-05-02 22:40:12|0 |185|1|2011-05-03|2011-05-03 13:40:27|0 |186|1|2011-05-04|2011-05-04 02:11:55|0 |187|1|2011-05-04|2011-05-04 02:12:00|0 |188|1|2011-05-04|2011-05-04 03:11:11|0 |189|1|2011-05-04|2011-05-04 03:11:12|0 |190|1|2011-05-04|2011-05-04 10:20:10|0 |191|5|2011-05-04|2011-05-04 13:04:32|0 |192|1|2011-05-04|2011-05-04 15:33:47|0 |193|1|2011-05-04|2011-05-04 17:58:56|0 |194|1|2011-05-04|2011-05-04 18:52:51|0 |195|1|2011-05-04|2011-05-04 18:52:53|0 |196|5|2011-05-04|2011-05-04 18:52:55|0 |197|1|2011-05-05|2011-05-05 18:15:43|0 |198|1|2011-05-05|2011-05-05 23:55:55|0 |199|1|2011-05-06|2011-05-06 04:27:33|0 |200|1|2011-05-06|2011-05-06 11:07:13|0 |201|1|2011-05-06|2011-05-06 23:20:02|0 |202|5|2011-05-07|2011-05-07 09:53:25|0 |203|5|2011-05-07|2011-05-07 09:53:26|0 |204|1|2011-05-07|2011-05-07 22:05:16|0 |205|1|2011-05-09|2011-05-09 02:52:28|0 |206|5|2011-05-09|2011-05-09 05:23:52|0 |207|5|2011-05-09|2011-05-09 05:23:53|0 |208|1|2011-05-09|2011-05-09 16:21:24|0 |209|5|2011-05-09|2011-05-09 16:40:46|0 |210|5|2011-05-09|2011-05-09 16:40:47|0 |211|1|2011-05-10|2011-05-10 09:59:13|0 |212|5|2011-05-10|2011-05-10 14:30:24|0 |213|5|2011-05-10|2011-05-10 14:30:25|0 |214|1|2011-05-11|2011-05-11 17:01:25|0 |215|1|2011-05-11|2011-05-11 22:22:24|0 |216|1|2011-05-11|2011-05-11 22:22:27|0 |217|1|2011-05-13|2011-05-13 08:03:28|0 |218|5|2011-05-13|2011-05-13 08:26:58|0 |219|1|2011-05-16|2011-05-16 18:42:00|0 |220|1|2011-05-16|2011-05-16 18:42:02|0 |221|1|2011-05-16|2011-05-16 22:11:05|0 |222|1|2011-05-17|2011-05-17 18:01:45|0 |223|1|2011-05-18|2011-05-18 23:20:09|0 |224|1|2011-05-19|2011-05-19 00:20:21|0 |225|1|2011-05-19|2011-05-19 05:03:57|0 |226|1|2011-05-21|2011-05-21 13:57:45|0 |227|1|2011-05-21|2011-05-21 13:57:47|0 |228|1|2011-05-22|2011-05-22 04:00:17|0 |229|5|2011-05-22|2011-05-22 11:18:46|0 |230|5|2011-05-22|2011-05-22 11:18:51|0 |231|1|2011-05-23|2011-05-23 01:25:10|0 |232|1|2011-05-23|2011-05-23 04:33:39|0 |233|1|2011-05-23|2011-05-23 10:19:56|0 |234|5|2011-05-23|2011-05-23 10:20:37|0 |235|1|2011-05-23|2011-05-23 20:12:35|0 |236|1|2011-05-23|2011-05-23 20:13:02|0 |237|1|2011-05-23|2011-05-23 20:13:07|0 |238|1|2011-05-23|2011-05-23 20:18:04|0 |239|1|2011-05-23|2011-05-23 20:18:05|0 |240|1|2011-05-23|2011-05-23 21:24:53|0 |241|1|2011-05-24|2011-05-24 20:31:57|0 |242|1|2011-05-24|2011-05-24 22:36:23|0 |243|1|2011-05-25|2011-05-25 13:30:35|0 |244|1|2011-05-25|2011-05-25 13:30:36|0 |245|1|2011-05-26|2011-05-26 07:41:01|0 |246|1|2011-05-26|2011-05-26 21:51:14|0 |247|1|2011-05-27|2011-05-27 06:59:46|0 |248|1|2011-05-27|2011-05-27 17:20:11|0 |249|1|2011-05-27|2011-05-27 17:20:12|0 |250|1|2011-05-27|2011-05-27 18:43:06|0 |251|1|2011-05-27|2011-05-27 23:48:35|0 |252|1|2011-05-28|2011-05-28 12:19:15|0 |253|1|2011-05-28|2011-05-28 17:05:31|0 |254|1|2011-05-29|2011-05-29 16:55:54|0 |255|1|2011-05-29|2011-05-29 16:55:58|0 |256|1|2011-05-29|2011-05-29 17:52:01|0 |257|1|2011-05-29|2011-05-29 17:52:02|0 |258|1|2011-05-29|2011-05-29 23:39:49|0 |259|1|2011-05-29|2011-05-29 23:39:56|0 |260|1|2011-05-30|2011-05-30 07:08:28|0 |261|1|2011-05-30|2011-05-30 07:08:35|0 |262|1|2011-05-30|2011-05-30 12:55:17|0 |263|1|2011-05-30|2011-05-30 14:39:19|0 |264|5|2011-05-30|2011-05-30 15:39:40|0 |265|1|2011-05-31|2011-05-31 10:09:24|0 |266|1|2011-05-31|2011-05-31 10:10:04|0 |267|1|2011-05-31|2011-05-31 10:13:38|0 |268|1|2011-05-31|2011-05-31 10:17:37|0 |269|1|2011-05-31|2011-05-31 10:19:13|0 |270|1|2011-05-31|2011-05-31 18:24:10|0 |271|1|2011-05-31|2011-05-31 18:24:11|0 |272|1|2011-05-31|2011-05-31 20:41:27|0 |273|1|2011-05-31|2011-05-31 20:41:28|0 |274|1|2011-05-31|2011-05-31 21:30:35|0 |275|1|2011-05-31|2011-05-31 21:59:58|0 |276|1|2011-05-31|2011-05-31 22:00:04|0 |277|1|2011-06-01|2011-06-01 12:19:37|0 |278|1|2011-06-01|2011-06-01 13:17:07|0 |279|1|2011-06-01|2011-06-01 17:51:23|0 |280|1|2011-06-01|2011-06-01 21:46:39|0 |281|1|2011-06-01|2011-06-01 21:46:40|0 |282|1|2011-06-02|2011-06-02 05:24:36|0 |283|1|2011-06-02|2011-06-02 18:27:51|0 |284|1|2011-06-03|2011-06-03 14:53:18|0 |285|1|2011-06-04|2011-06-04 04:57:23|0 |286|1|2011-06-04|2011-06-04 12:08:21|0 |287|1|2011-06-04|2011-06-04 12:08:33|0 |288|1|2011-06-05|2011-06-05 01:41:50|0 |289|1|2011-06-05|2011-06-05 16:46:08|0 |290|1|2011-06-05|2011-06-05 16:46:10|0 |291|1|2011-06-06|2011-06-06 04:30:42|0 |292|1|2011-06-06|2011-06-06 04:33:11|0 |293|5|2011-06-06|2011-06-06 04:33:13|0 |294|1|2011-06-06|2011-06-06 07:34:37|0 |295|1|2011-06-06|2011-06-06 08:24:08|0 |296|1|2011-06-07|2011-06-07 03:00:46|0 |297|1|2011-06-07|2011-06-07 21:41:31|0 |298|1|2011-06-08|2011-06-08 03:56:53|0 |299|1|2011-06-08|2011-06-08 03:56:55|0 |300|5|2011-06-08|2011-06-08 04:21:29|0 |301|5|2011-06-08|2011-06-08 04:21:30|0 |302|1|2011-06-08|2011-06-08 08:48:05|0 |303|1|2011-06-08|2011-06-08 11:30:08|0 |304|1|2011-06-08|2011-06-08 14:15:58|0 |305|1|2011-06-09|2011-06-09 09:06:47|0 |306|1|2011-06-09|2011-06-09 21:31:25|0 |307|1|2011-06-09|2011-06-09 21:31:26|0 |308|1|2011-06-10|2011-06-10 04:36:47|0 |309|1|2011-06-10|2011-06-10 10:03:49|0 |310|5|2011-06-10|2011-06-10 10:03:52|0 |311|1|2011-06-10|2011-06-10 14:00:40|0 |312|5|2011-06-10|2011-06-10 20:43:13|0 |313|5|2011-06-10|2011-06-10 20:43:14|0 |314|5|2011-06-11|2011-06-11 03:05:12|0 |315|5|2011-06-11|2011-06-11 03:05:13|0 |316|5|2011-06-11|2011-06-11 03:19:31|0 |317|5|2011-06-11|2011-06-11 03:19:32|0 |318|1|2011-06-11|2011-06-11 07:11:23|0 |319|1|2011-06-11|2011-06-11 07:11:32|0 |320|1|2011-06-11|2011-06-11 12:45:47|0 |321|1|2011-06-11|2011-06-11 13:51:13|0 |322|1|2011-06-11|2011-06-11 20:34:20|0 |323|1|2011-06-11|2011-06-11 20:34:29|0 |324|1|2011-06-12|2011-06-12 14:27:22|0 |325|5|2011-06-12|2011-06-12 16:22:05|0 |326|1|2011-06-12|2011-06-12 21:06:05|0 |327|1|2011-06-13|2011-06-13 02:47:58|0 |328|1|2011-06-13|2011-06-13 05:32:44|0 |329|1|2011-06-13|2011-06-13 14:48:06|0 |330|1|2011-06-13|2011-06-13 16:51:32|0 |331|1|2011-06-13|2011-06-13 17:41:49|0 |332|1|2011-06-13|2011-06-13 19:11:51|0 |333|1|2011-06-13|2011-06-13 19:11:52|0 |334|1|2011-06-15|2011-06-15 23:39:59|0 |335|1|2011-06-15|2011-06-15 23:40:09|0 |336|1|2011-06-16|2011-06-16 06:59:47|0 |337|1|2011-06-16|2011-06-16 23:18:59|0 |338|1|2011-06-16|2011-06-16 23:39:54|0 |339|1|2011-06-17|2011-06-17 00:45:10|0 |340|1|2011-06-17|2011-06-17 07:13:08|0 |341|1|2011-06-17|2011-06-17 07:13:10|0 |342|1|2011-06-17|2011-06-17 10:16:27|0 |343|1|2011-06-17|2011-06-17 11:44:35|0 |344|1|2011-06-17|2011-06-17 18:48:03|0 |345|1|2011-06-17|2011-06-17 18:48:05|0 |346|5|2011-06-17|2011-06-17 23:31:35|0 |347|1|2011-06-18|2011-06-18 00:05:03|0 |348|1|2011-06-18|2011-06-18 02:30:09|0 |349|1|2011-06-18|2011-06-18 15:06:05|0 |350|1|2011-06-18|2011-06-18 20:37:05|0 |351|1|2011-06-18|2011-06-18 22:17:45|0 |352|1|2011-06-18|2011-06-18 22:17:56|0 |353|5|2011-06-19|2011-06-19 01:07:15|0 |354|1|2011-06-19|2011-06-19 05:47:17|0 |355|1|2011-06-19|2011-06-19 10:00:42|0 |356|5|2011-06-19|2011-06-19 18:33:30|0 |357|1|2011-06-19|2011-06-19 19:41:18|0 |358|1|2011-06-19|2011-06-19 19:41:19|0 |359|1|2011-06-21|2011-06-21 02:36:46|0 |360|1|2011-06-21|2011-06-21 03:12:40|0 |361|5|2011-06-21|2011-06-21 22:36:13|0 |362|5|2011-06-21|2011-06-21 22:36:15|0 |363|1|2011-06-22|2011-06-22 02:30:39|0 |364|1|2011-06-22|2011-06-22 02:30:42|0 |365|1|2011-06-22|2011-06-22 12:04:00|0 |366|1|2011-06-23|2011-06-23 18:28:13|0 |367|1|2011-06-23|2011-06-23 18:28:16|0 |368|1|2011-06-23|2011-06-23 21:29:44|0 |369|1|2011-06-24|2011-06-24 00:22:35|0 |370|1|2011-06-24|2011-06-24 01:34:59|0 |371|1|2011-06-25|2011-06-25 02:08:51|0 |372|1|2011-06-25|2011-06-25 13:30:03|0 |373|1|2011-06-25|2011-06-25 15:19:09|0 |374|1|2011-06-25|2011-06-25 21:34:38|0 |375|1|2011-06-25|2011-06-25 21:34:39|0 |376|1|2011-06-26|2011-06-26 03:56:06|0 |377|1|2011-06-27|2011-06-27 00:19:32|0 |378|1|2011-06-27|2011-06-27 02:45:29|0 |379|1|2011-06-27|2011-06-27 02:49:07|0 |380|1|2011-06-27|2011-06-27 13:46:53|0 |381|1|2011-06-27|2011-06-27 13:46:54|0 |382|1|2011-06-27|2011-06-27 20:45:28|0 |383|1|2011-06-27|2011-06-27 20:45:29|0 |384|1|2011-06-28|2011-06-28 12:55:50|0 |385|1|2011-06-28|2011-06-28 13:48:43|0 |386|1|2011-06-28|2011-06-28 18:42:57|0 |387|1|2011-06-28|2011-06-28 19:44:29|0 |388|1|2011-06-28|2011-06-28 20:46:13|0 |389|5|2011-06-29|2011-06-29 02:17:14|0 |390|1|2011-06-29|2011-06-29 14:42:26|0 |391|1|2011-06-29|2011-06-29 18:13:03|0 |392|1|2011-06-29|2011-06-29 18:13:05|0 |393|1|2011-06-30|2011-06-30 20:12:30|0 |394|1|2011-06-30|2011-06-30 21:10:08|0 |395|1|2011-07-01|2011-07-01 15:43:11|0 |396|1|2011-07-01|2011-07-01 19:25:55|0 |397|1|2011-07-01|2011-07-01 19:25:56|0 |398|1|2011-07-02|2011-07-02 15:29:40|0 |399|1|2011-07-03|2011-07-03 01:36:33|0 |400|1|2011-07-03|2011-07-03 01:37:14|0 |401|1|2011-07-03|2011-07-03 01:37:18|0 |402|1|2011-07-03|2011-07-03 01:37:27|0 |403|1|2011-07-03|2011-07-03 02:30:49|0 |404|1|2011-07-03|2011-07-03 03:13:50|0 |405|1|2011-07-03|2011-07-03 21:23:41|0 |406|1|2011-07-03|2011-07-03 23:11:08|0 |407|1|2011-07-03|2011-07-03 23:11:10|0 |408|1|2011-07-04|2011-07-04 02:46:41|0 |409|1|2011-07-04|2011-07-04 15:14:28|0 |410|1|2011-07-04|2011-07-04 15:23:38|0 |411|1|2011-07-04|2011-07-04 16:45:04|0 |412|1|2011-07-04|2011-07-04 16:45:06|0 |413|1|2011-07-05|2011-07-05 14:36:59|0 |414|1|2011-07-06|2011-07-06 00:52:51|0 |415|1|2011-07-06|2011-07-06 01:28:42|0 |416|1|2011-07-07|2011-07-07 16:17:45|0 |417|1|2011-07-07|2011-07-07 18:37:10|0 |418|1|2011-07-07|2011-07-07 18:37:23|0 |419|1|2011-07-08|2011-07-08 02:27:24|0 |420|1|2011-07-08|2011-07-08 23:48:45|0 |421|1|2011-07-09|2011-07-09 00:37:35|0 |422|5|2011-07-09|2011-07-09 00:37:42|0 |423|1|2011-07-09|2011-07-09 04:32:12|0 |424|1|2011-07-09|2011-07-09 14:02:19|0 |425|1|2011-07-09|2011-07-09 14:02:20|0 |426|1|2011-07-09|2011-07-09 15:31:35|0 |427|1|2011-07-10|2011-07-10 01:43:21|0 |428|1|2011-07-10|2011-07-10 18:04:03|0 |429|1|2011-07-10|2011-07-10 23:36:53|0 |430|1|2011-07-11|2011-07-11 01:10:14|0 |431|5|2011-07-11|2011-07-11 06:50:42|0 |432|1|2011-07-11|2011-07-11 18:20:43|0 |433|1|2011-07-11|2011-07-11 18:25:33|0 |434|1|2011-07-11|2011-07-11 18:25:34|0 |435|1|2011-07-11|2011-07-11 22:09:03|0 |436|1|2011-07-11|2011-07-11 23:01:36|0 |437|1|2011-07-12|2011-07-12 03:33:04|0 |438|5|2011-07-12|2011-07-12 06:14:40|0 |439|1|2011-07-12|2011-07-12 16:56:46|0 |440|1|2011-07-12|2011-07-12 16:56:50|0 |441|5|2011-07-12|2011-07-12 16:56:52|0 |442|1|2011-07-12|2011-07-12 20:23:33|0 |443|1|2011-07-12|2011-07-12 22:32:04|0 |444|5|2011-07-13|2011-07-13 05:25:44|0 |445|1|2011-07-13|2011-07-13 11:05:42|0 |446|1|2011-07-13|2011-07-13 16:45:36|0 |447|1|2011-07-13|2011-07-13 20:13:04|0 |448|1|2011-07-13|2011-07-13 20:59:30|0 |449|1|2011-07-13|2011-07-13 21:41:13|0 |450|1|2011-07-13|2011-07-13 22:13:43|0 |451|1|2011-07-13|2011-07-13 22:13:44|0 |452|1|2011-07-14|2011-07-14 18:36:32|0 |453|1|2011-07-14|2011-07-14 19:17:43|0 |454|1|2011-07-14|2011-07-14 21:12:26|0 |455|5|2011-07-15|2011-07-15 03:05:08|0 |456|5|2011-07-15|2011-07-15 07:51:08|0 |457|1|2011-07-15|2011-07-15 21:24:37|0 |458|1|2011-07-16|2011-07-16 02:15:14|0 |459|1|2011-07-16|2011-07-16 02:15:15|0 |460|1|2011-07-16|2011-07-16 15:33:03|0 |461|1|2011-07-17|2011-07-17 01:44:52|0 |462|1|2011-07-17|2011-07-17 20:34:04|0 |463|1|2011-07-17|2011-07-17 21:58:53|0 |464|1|2011-07-17|2011-07-17 21:58:53|0 |465|1|2011-07-17|2011-07-17 22:09:29|0 |466|1|2011-07-18|2011-07-18 05:02:47|0 |467|1|2011-07-18|2011-07-18 05:03:00|0 |468|1|2011-07-18|2011-07-18 13:28:52|0 |469|5|2011-07-19|2011-07-19 02:48:30|0 |470|1|2011-07-19|2011-07-19 23:15:00|0 |471|1|2011-07-20|2011-07-20 00:12:23|0 |472|1|2011-07-20|2011-07-20 00:36:24|0 |473|1|2011-07-20|2011-07-20 00:36:25|0 |474|1|2011-07-21|2011-07-21 07:05:15|0 |475|1|2011-07-21|2011-07-21 10:41:04|0 |476|1|2011-07-22|2011-07-22 00:12:14|0 |477|1|2011-07-22|2011-07-22 00:16:29|0 |478|1|2011-07-22|2011-07-22 01:06:50|0 |479|1|2011-07-22|2011-07-22 02:23:27|0 |480|1|2011-07-22|2011-07-22 02:23:28|0 |481|5|2011-07-22|2011-07-22 09:51:12|0 |482|5|2011-07-22|2011-07-22 09:51:17|0 |483|1|2011-07-23|2011-07-23 17:25:40|0 |484|1|2011-07-23|2011-07-23 21:08:47|0 |485|1|2011-07-23|2011-07-23 21:08:48|0 |486|1|2011-07-24|2011-07-24 04:35:38|0 |487|1|2011-07-24|2011-07-24 05:40:14|0 |488|1|2011-07-24|2011-07-24 08:46:08|0 |489|1|2011-07-24|2011-07-24 10:39:50|0 |490|1|2011-07-24|2011-07-24 12:33:14|0 |491|1|2011-07-25|2011-07-25 06:57:06|0 |492|1|2011-07-25|2011-07-25 06:57:08|0 |493|1|2011-07-26|2011-07-26 01:47:28|0 |494|5|2011-07-26|2011-07-26 12:35:04|0 |495|1|2011-07-26|2011-07-26 20:52:39|0 |496|1|2011-07-26|2011-07-26 22:09:21|0 |497|5|2011-07-26|2011-07-26 23:34:01|0 |498|5|2011-07-26|2011-07-26 23:34:07|0 |499|1|2011-07-26|2011-07-26 23:35:34|0 |500|1|2011-07-27|2011-07-27 00:54:51|0 |501|1|2011-07-27|2011-07-27 00:55:03|0 |502|1|2011-07-27|2011-07-27 14:49:09|0 |503|1|2011-07-27|2011-07-27 17:57:20|0 |504|1|2011-07-27|2011-07-27 17:57:21|0 |505|1|2011-07-27|2011-07-27 19:16:30|0 |506|1|2011-07-27|2011-07-27 19:16:59|0 |507|5|2011-07-27|2011-07-27 19:17:10|0 |508|1|2011-07-27|2011-07-27 19:17:13|0 |509|1|2011-07-27|2011-07-27 19:17:35|0 |510|1|2011-07-27|2011-07-27 19:17:59|0 |511|1|2011-07-27|2011-07-27 19:23:33|0 |512|1|2011-07-28|2011-07-28 01:45:22|0 |513|1|2011-07-29|2011-07-29 00:20:55|0 |514|1|2011-07-29|2011-07-29 01:47:04|0 |515|1|2011-07-29|2011-07-29 02:07:18|0 |516|1|2011-07-29|2011-07-29 04:00:49|0 |517|1|2011-07-29|2011-07-29 04:00:55|0 |518|1|2011-07-30|2011-07-30 04:54:51|0 |519|1|2011-07-30|2011-07-30 04:54:54|0 |520|1|2011-07-30|2011-07-30 06:01:23|0 |521|1|2011-07-31|2011-07-31 02:05:03|0 |522|1|2011-07-31|2011-07-31 03:53:24|0 |523|1|2011-07-31|2011-07-31 08:14:52|0 |524|1|2011-07-31|2011-07-31 08:14:55|0 |525|1|2011-07-31|2011-07-31 19:04:00|0 |526|1|2011-07-31|2011-07-31 19:55:28|0 |527|1|2011-08-01|2011-08-01 08:01:57|0 |528|1|2011-08-01|2011-08-01 08:02:00|0 |529|1|2011-08-01|2011-08-01 19:51:30|0 |530|1|2011-08-01|2011-08-01 19:51:48|0 |531|1|2011-08-01|2011-08-01 23:10:07|0 |532|1|2011-08-02|2011-08-02 05:12:28|0 |533|1|2011-08-02|2011-08-02 08:09:46|0 |534|1|2011-08-02|2011-08-02 10:14:09|0 |535|5|2011-08-02|2011-08-02 10:14:12|0 |536|1|2011-08-02|2011-08-02 20:58:46|0 |537|1|2011-08-03|2011-08-03 02:15:26|0 |538|1|2011-08-03|2011-08-03 02:51:22|0 |539|5|2011-08-03|2011-08-03 04:44:35|0 |540|1|2011-08-03|2011-08-03 06:41:11|0 |541|1|2011-08-03|2011-08-03 08:05:35|0 |542|5|2011-08-03|2011-08-03 11:36:04|0 |543|1|2011-08-03|2011-08-03 15:52:06|0 |544|1|2011-08-03|2011-08-03 20:59:29|0 |545|1|2011-08-03|2011-08-03 20:59:33|0 |546|1|2011-08-04|2011-08-04 07:59:54|0 |547|1|2011-08-05|2011-08-05 02:30:08|0 |548|1|2011-08-06|2011-08-06 03:03:39|0 |549|1|2011-08-06|2011-08-06 04:14:11|0 |550|1|2011-08-06|2011-08-06 04:29:14|0 |551|1|2011-08-06|2011-08-06 04:49:33|0 |552|1|2011-08-07|2011-08-07 03:53:34|0 |553|1|2011-08-07|2011-08-07 07:22:08|0 |554|1|2011-08-07|2011-08-07 12:51:41|0 |555|1|2011-08-07|2011-08-07 12:51:43|0 |556|5|2011-08-07|2011-08-07 14:27:04|0 |557|1|2011-08-08|2011-08-08 07:50:48|0 |558|1|2011-08-08|2011-08-08 21:13:17|0 |559|1|2011-08-08|2011-08-08 21:49:29|0 |560|1|2011-08-09|2011-08-09 09:08:06|0 |561|1|2011-08-09|2011-08-09 09:08:09|0 |562|5|2011-08-09|2011-08-09 09:08:11|0 |563|1|2011-08-09|2011-08-09 10:52:52|0 |564|1|2011-08-09|2011-08-09 12:46:27|0 |565|1|2011-08-09|2011-08-09 13:08:11|0 |566|1|2011-08-09|2011-08-09 13:08:15|0 |567|1|2011-08-10|2011-08-10 12:18:31|0 |568|1|2011-08-10|2011-08-10 22:18:56|0 |569|1|2011-08-11|2011-08-11 14:35:12|0 |570|5|2011-08-12|2011-08-12 01:25:40|0 |571|1|2011-08-12|2011-08-12 01:33:30|0 |572|1|2011-08-12|2011-08-12 01:33:32|0 |573|1|2011-08-12|2011-08-12 05:13:43|0 |574|5|2011-08-12|2011-08-12 05:13:47|0 |575|1|2011-08-12|2011-08-12 15:06:08|0 |576|1|2011-08-12|2011-08-12 16:05:38|0 |577|1|2011-08-12|2011-08-12 16:55:48|0 |578|1|2011-08-12|2011-08-12 20:25:10|0 |579|1|2011-08-13|2011-08-13 06:45:29|0 |580|5|2011-08-13|2011-08-13 08:26:58|0 |581|1|2011-08-13|2011-08-13 17:10:47|0 |582|1|2011-08-14|2011-08-14 03:31:41|0 |583|1|2011-08-14|2011-08-14 03:31:43|0 |584|1|2011-08-14|2011-08-14 05:15:27|0 |585|1|2011-08-14|2011-08-14 10:35:47|0 |586|1|2011-08-14|2011-08-14 11:00:13|0 |587|1|2011-08-15|2011-08-15 12:28:44|0 |588|1|2011-08-15|2011-08-15 12:54:56|0 |589|1|2011-08-15|2011-08-15 13:33:21|0 |590|1|2011-08-16|2011-08-16 07:27:11|0 |591|1|2011-08-16|2011-08-16 15:54:09|0 |592|1|2011-08-16|2011-08-16 19:01:53|0 |593|1|2011-08-16|2011-08-16 19:01:54|0 |594|1|2011-08-16|2011-08-16 21:06:42|0 |595|1|2011-08-17|2011-08-17 12:36:58|0 |596|1|2011-08-17|2011-08-17 12:37:08|0 |597|1|2011-08-17|2011-08-17 14:42:09|0 |598|1|2011-08-17|2011-08-17 15:32:27|0 |599|5|2011-08-17|2011-08-17 18:36:29|0 |600|1|2011-08-17|2011-08-17 18:50:19|0 |601|1|2011-08-17|2011-08-17 19:32:33|0 |602|1|2011-08-18|2011-08-18 19:14:43|0 |603|1|2011-08-18|2011-08-18 19:33:55|0 |604|1|2011-08-18|2011-08-18 22:53:57|0 |605|5|2011-08-19|2011-08-19 06:41:41|0 |606|1|2011-08-19|2011-08-19 09:34:40|0 |607|1|2011-08-19|2011-08-19 14:30:59|0 |608|1|2011-08-19|2011-08-19 14:31:01|0 |609|1|2011-08-19|2011-08-19 20:06:51|0 |610|1|2011-08-20|2011-08-20 15:12:10|0 |611|1|2011-08-20|2011-08-20 16:52:46|0 |612|1|2011-08-20|2011-08-20 17:11:03|0 |613|1|2011-08-20|2011-08-20 18:33:10|0 |614|1|2011-08-21|2011-08-21 15:39:33|0 |615|1|2011-08-21|2011-08-21 20:26:45|0 |616|1|2011-08-21|2011-08-21 20:26:47|0 |617|1|2011-08-21|2011-08-21 23:57:26|0 |618|1|2011-08-22|2011-08-22 06:38:56|0 |619|1|2011-08-22|2011-08-22 13:26:41|0 |620|1|2011-08-22|2011-08-22 13:57:00|0 |621|1|2011-08-22|2011-08-22 15:14:27|0 |622|1|2011-08-22|2011-08-22 17:11:28|0 |623|1|2011-08-22|2011-08-22 18:38:01|0 |624|1|2011-08-23|2011-08-23 00:41:30|0 |625|1|2011-08-23|2011-08-23 02:20:44|0 |626|1|2011-08-23|2011-08-23 14:24:39|0 |627|1|2011-08-23|2011-08-23 14:24:41|0 |628|1|2011-08-23|2011-08-23 19:20:41|0 |629|5|2011-08-23|2011-08-23 22:38:56|0 |630|1|2011-08-24|2011-08-24 14:22:52|0 |631|1|2011-08-24|2011-08-24 14:22:53|0 |632|1|2011-08-24|2011-08-24 15:21:03|0 |633|1|2011-08-24|2011-08-24 16:18:35|0 |634|1|2011-08-24|2011-08-24 16:53:32|0 |635|1|2011-08-24|2011-08-24 17:01:11|0 |636|5|2011-08-24|2011-08-24 18:52:33|0 |637|1|2011-08-25|2011-08-25 02:50:44|0 |638|5|2011-08-25|2011-08-25 02:50:56|0 |639|1|2011-08-25|2011-08-25 16:11:01|0 |640|1|2011-08-25|2011-08-25 17:24:08|0 |641|1|2011-08-26|2011-08-26 00:15:57|0 |642|1|2011-08-26|2011-08-26 01:22:49|0 |643|1|2011-08-26|2011-08-26 01:22:50|0 |644|1|2011-08-26|2011-08-26 07:45:18|0 |645|1|2011-08-26|2011-08-26 08:17:28|0 |646|1|2011-08-26|2011-08-26 13:22:29|0 |647|1|2011-08-26|2011-08-26 16:18:32|0 |648|1|2011-08-27|2011-08-27 02:35:09|0 |649|1|2011-08-27|2011-08-27 16:05:25|0 |650|1|2011-08-27|2011-08-27 16:12:35|0 |651|1|2011-08-27|2011-08-27 16:51:57|0 |652|1|2011-08-27|2011-08-27 16:51:57|0 |653|1|2011-08-28|2011-08-28 16:21:58|0 |654|1|2011-08-28|2011-08-28 16:40:56|0 |655|1|2011-08-28|2011-08-28 17:26:37|0 |656|1|2011-08-28|2011-08-28 18:29:06|0 |657|1|2011-08-28|2011-08-28 19:04:47|0 |658|1|2011-08-28|2011-08-28 19:59:32|0 |659|1|2011-08-28|2011-08-28 22:02:37|0 |660|1|2011-08-29|2011-08-29 16:34:06|0 |661|1|2011-08-29|2011-08-29 19:33:36|0 |662|1|2011-08-30|2011-08-30 00:45:53|0 |663|1|2011-08-30|2011-08-30 00:45:59|0 |664|1|2011-08-30|2011-08-30 01:42:20|0 |665|1|2011-08-30|2011-08-30 09:01:10|0 |666|1|2011-08-30|2011-08-30 17:32:35|0 |667|1|2011-08-30|2011-08-30 18:37:15|0 |668|1|2011-08-31|2011-08-31 10:38:45|0 |669|1|2011-08-31|2011-08-31 20:16:30|0 |670|1|2011-09-01|2011-09-01 01:10:56|0 |671|1|2011-09-01|2011-09-01 01:10:59|0 |672|1|2011-09-01|2011-09-01 10:07:37|0 |673|1|2011-09-01|2011-09-01 11:44:38|0 |674|1|2011-09-01|2011-09-01 14:07:57|0 |675|1|2011-09-01|2011-09-01 15:34:22|0 |676|1|2011-09-01|2011-09-01 21:47:28|0 |677|1|2011-09-01|2011-09-01 21:51:31|0 |678|1|2011-09-01|2011-09-01 21:51:33|0 |679|1|2011-09-02|2011-09-02 06:37:18|0 |680|1|2011-09-02|2011-09-02 11:08:06|0 |681|1|2011-09-02|2011-09-02 14:24:25|0 |682|1|2011-09-02|2011-09-02 20:21:12|0 |683|5|2011-09-03|2011-09-03 03:45:34|0 |684|1|2011-09-03|2011-09-03 07:30:58|0 |685|1|2011-09-03|2011-09-03 15:56:43|0 |686|1|2011-09-03|2011-09-03 16:32:38|0 |687|1|2011-09-03|2011-09-03 22:11:20|0 |688|1|2011-09-03|2011-09-03 22:11:33|0 |689|1|2011-09-05|2011-09-05 09:48:31|0 |690|1|2011-09-05|2011-09-05 09:48:34|0 |691|1|2011-09-05|2011-09-05 11:15:14|0 |692|1|2011-09-05|2011-09-05 11:51:30|0 |693|1|2011-09-05|2011-09-05 16:22:17|0 |694|1|2011-09-05|2011-09-05 23:24:51|0 |695|1|2011-09-06|2011-09-06 09:40:42|0 |696|1|2011-09-07|2011-09-07 03:51:00|0 |697|1|2011-09-07|2011-09-07 15:07:23|0 |698|1|2011-09-07|2011-09-07 15:39:55|0 |699|1|2011-09-07|2011-09-07 16:28:54|0 |700|1|2011-09-07|2011-09-07 19:10:26|0 |701|1|2011-09-08|2011-09-08 02:20:04|0 |702|1|2011-09-08|2011-09-08 02:20:06|0 |703|5|2011-09-08|2011-09-08 12:11:56|0 |704|1|2011-09-08|2011-09-08 14:47:27|0 |705|1|2011-09-08|2011-09-08 17:22:09|0 |706|1|2011-09-08|2011-09-08 23:12:54|0 |707|1|2011-09-08|2011-09-08 23:13:28|0 |708|5|2011-09-08|2011-09-08 23:13:54|0 |709|1|2011-09-09|2011-09-09 03:44:48|0 |710|1|2011-09-09|2011-09-09 03:44:49|0 |711|1|2011-09-09|2011-09-09 07:46:30|0 |712|1|2011-09-09|2011-09-09 16:14:26|0 |713|1|2011-09-09|2011-09-09 16:57:36|0 |714|1|2011-09-09|2011-09-09 16:57:46|0 |715|1|2011-09-09|2011-09-09 16:57:47|0 |716|5|2011-09-10|2011-09-10 06:17:02|0 |717|1|2011-09-10|2011-09-10 06:26:05|0 |718|1|2011-09-10|2011-09-10 10:14:26|0 |719|5|2011-09-10|2011-09-10 10:14:37|0 |720|1|2011-09-11|2011-09-11 12:03:02|0 |721|1|2011-09-11|2011-09-11 13:00:32|0 |722|1|2011-09-11|2011-09-11 18:18:10|0 |723|1|2011-09-11|2011-09-11 20:06:18|0 |724|1|2011-09-11|2011-09-11 20:06:20|0 |725|1|2011-09-12|2011-09-12 01:02:07|0 |726|1|2011-09-12|2011-09-12 01:07:59|0 |727|1|2011-09-12|2011-09-12 10:47:37|0 |728|1|2011-09-12|2011-09-12 17:51:17|0 |729|1|2011-09-13|2011-09-13 11:00:19|0 |730|1|2011-09-13|2011-09-13 11:37:07|0 |731|1|2011-09-13|2011-09-13 13:31:42|0 |732|1|2011-09-13|2011-09-13 16:23:08|0 |733|1|2011-09-13|2011-09-13 23:02:27|0 |734|1|2011-09-13|2011-09-13 23:02:36|0 |735|1|2011-09-13|2011-09-13 23:06:19|0 |736|1|2011-09-13|2011-09-13 23:12:27|0 |737|1|2011-09-13|2011-09-13 23:23:39|0 |738|1|2011-09-14|2011-09-14 01:51:31|0 |739|1|2011-09-14|2011-09-14 02:48:23|0 |740|1|2011-09-14|2011-09-14 02:48:24|0 |741|1|2011-09-14|2011-09-14 03:19:30|0 |742|5|2011-09-14|2011-09-14 10:44:49|0 |743|1|2011-09-15|2011-09-15 11:44:08|0 |744|1|2011-09-15|2011-09-15 15:48:13|0 |745|1|2011-09-15|2011-09-15 16:26:45|0 |746|5|2011-09-16|2011-09-16 06:45:16|0 |747|5|2011-09-16|2011-09-16 08:12:09|0 |748|1|2011-09-17|2011-09-17 09:57:10|0 |749|1|2011-09-17|2011-09-17 10:47:57|0 |750|1|2011-09-17|2011-09-17 12:19:46|0 |751|5|2011-09-18|2011-09-18 01:11:56|0 |752|1|2011-09-18|2011-09-18 07:18:15|0 |753|1|2011-09-18|2011-09-18 17:06:13|0 |754|1|2011-09-18|2011-09-18 17:48:12|0 |755|5|2011-09-18|2011-09-18 21:10:11|0 |756|1|2011-09-19|2011-09-19 05:55:35|0 |757|1|2011-09-19|2011-09-19 14:29:55|0 |758|1|2011-09-19|2011-09-19 16:09:53|0 |759|1|2011-09-19|2011-09-19 16:46:01|0 |760|1|2011-09-19|2011-09-19 21:05:23|0 |761|1|2011-09-19|2011-09-19 21:05:25|0 |762|1|2011-09-20|2011-09-20 00:33:29|0 |763|1|2011-09-20|2011-09-20 00:33:50|0 |764|1|2011-09-20|2011-09-20 00:35:58|0 |765|1|2011-09-20|2011-09-20 00:41:14|0 |766|1|2011-09-20|2011-09-20 03:22:19|0 |767|1|2011-09-20|2011-09-20 12:39:22|0 |768|1|2011-09-20|2011-09-20 19:10:55|0 |769|1|2011-09-20|2011-09-20 20:38:21|0 |770|1|2011-09-21|2011-09-21 02:29:41|0 |771|1|2011-09-21|2011-09-21 02:29:43|0 |772|1|2011-09-21|2011-09-21 07:49:19|0 |773|5|2011-09-21|2011-09-21 19:16:10|0 |774|1|2011-09-21|2011-09-21 23:00:14|0 |775|1|2011-09-21|2011-09-21 23:53:08|0 |776|1|2011-09-22|2011-09-22 02:08:58|0 |777|5|2011-09-22|2011-09-22 04:20:04|0 |778|1|2011-09-22|2011-09-22 04:35:38|0 |779|1|2011-09-22|2011-09-22 04:35:39|0 |780|1|2011-09-22|2011-09-22 09:07:53|0 |781|1|2011-09-23|2011-09-23 04:49:15|0 |782|1|2011-09-23|2011-09-23 06:02:52|0 |783|1|2011-09-23|2011-09-23 10:02:27|0 |784|1|2011-09-23|2011-09-23 11:43:56|0 |785|1|2011-09-23|2011-09-23 15:55:35|0 |786|1|2011-09-23|2011-09-23 17:56:22|0 |787|1|2011-09-23|2011-09-23 17:56:23|0 |788|1|2011-09-24|2011-09-24 15:00:37|0 |789|1|2011-09-24|2011-09-24 17:08:07|0 |790|1|2011-09-24|2011-09-24 17:08:13|0 |791|1|2011-09-24|2011-09-24 21:27:19|0 |792|1|2011-09-24|2011-09-24 23:06:16|0 |793|1|2011-09-25|2011-09-25 02:26:03|0 |794|1|2011-09-25|2011-09-25 08:26:23|0 |795|1|2011-09-25|2011-09-25 10:39:10|0 |796|1|2011-09-25|2011-09-25 12:50:26|0 |797|1|2011-09-25|2011-09-25 12:50:28|0 |798|1|2011-09-25|2011-09-25 22:41:19|0 |799|1|2011-09-26|2011-09-26 01:10:16|0 |800|1|2011-09-26|2011-09-26 01:23:22|0 |801|1|2011-09-26|2011-09-26 18:37:56|0 |802|1|2011-09-27|2011-09-27 01:53:36|0 |803|1|2011-09-27|2011-09-27 01:53:39|0 |804|1|2011-09-27|2011-09-27 17:11:38|0 |805|1|2011-09-27|2011-09-27 17:59:01|0 |806|1|2011-09-27|2011-09-27 20:51:32|0 |807|1|2011-09-28|2011-09-28 09:45:49|0 |808|1|2011-09-28|2011-09-28 09:46:07|0 |809|1|2011-09-28|2011-09-28 13:04:33|0 |810|1|2011-09-28|2011-09-28 13:04:43|0 |811|1|2011-09-28|2011-09-28 15:56:18|0 |812|1|2011-09-28|2011-09-28 19:36:01|0 |813|1|2011-09-28|2011-09-28 20:20:58|0 |814|1|2011-09-28|2011-09-28 21:20:34|0 |815|1|2011-09-29|2011-09-29 13:02:48|0 |816|1|2011-09-29|2011-09-29 19:38:52|0 |817|1|2011-09-29|2011-09-29 19:38:54|0 |818|1|2011-09-30|2011-09-30 13:43:02|0 |819|1|2011-09-30|2011-09-30 13:43:27|0 |820|1|2011-09-30|2011-09-30 16:38:03|0 |821|1|2011-09-30|2011-09-30 17:09:22|0 |822|1|2011-10-01|2011-10-01 08:35:54|0 |823|1|2011-10-01|2011-10-01 15:44:28|0 |824|1|2011-10-02|2011-10-02 02:45:07|0 |825|1|2011-10-02|2011-10-02 02:45:11|0 |826|1|2011-10-02|2011-10-02 12:32:08|0 |827|1|2011-10-03|2011-10-03 09:46:45|0 |828|1|2011-10-03|2011-10-03 22:37:33|0 |829|1|2011-10-04|2011-10-04 06:31:15|0 |830|1|2011-10-04|2011-10-04 06:31:17|0 |831|1|2011-10-04|2011-10-04 09:18:51|0 |832|1|2011-10-04|2011-10-04 14:00:46|0 |833|1|2011-10-04|2011-10-04 17:58:58|0 |834|1|2011-10-04|2011-10-04 17:59:01|0 |835|1|2011-10-05|2011-10-05 15:47:40|0 |836|1|2011-10-06|2011-10-06 07:44:37|0 |837|1|2011-10-06|2011-10-06 09:13:56|0 |838|1|2011-10-06|2011-10-06 09:14:00|0 |839|1|2011-10-07|2011-10-07 11:53:11|0 |840|5|2011-10-07|2011-10-07 12:24:08|0 |841|5|2011-10-07|2011-10-07 19:37:09|0 |842|1|2011-10-07|2011-10-07 20:43:05|0 |843|1|2011-10-07|2011-10-07 23:30:31|0 |844|1|2011-10-08|2011-10-08 03:00:54|0 |845|1|2011-10-08|2011-10-08 05:58:52|0 |846|1|2011-10-08|2011-10-08 05:58:53|0 |847|1|2011-10-08|2011-10-08 07:43:59|0 |848|1|2011-10-08|2011-10-08 08:05:08|0 |849|5|2011-10-08|2011-10-08 08:05:29|0 |850|5|2011-10-08|2011-10-08 08:05:50|0 |851|5|2011-10-08|2011-10-08 08:06:16|0 |852|5|2011-10-08|2011-10-08 08:06:35|0 |853|5|2011-10-08|2011-10-08 08:06:36|0 |854|5|2011-10-08|2011-10-08 08:07:22|0 |855|1|2011-10-08|2011-10-08 08:07:23|1 |856|15|2011-10-08|2011-10-08 08:07:41|1 |857|30|2011-10-08|2011-10-08 08:07:54|1 |858|31|2011-10-08|2011-10-08 08:07:54|1 |859|34|2011-10-08|2011-10-08 08:08:17|1 |860|16|2011-10-08|2011-10-08 08:08:33|1 |861|17|2011-10-08|2011-10-08 08:08:34|1 |862|17|2011-10-08|2011-10-08 08:08:41|1 |863|30|2011-10-08|2011-10-08 08:08:48|1 |864|31|2011-10-08|2011-10-08 08:08:48|1 |865|30|2011-10-08|2011-10-08 08:13:38|1 |866|31|2011-10-08|2011-10-08 08:13:39|1 |867|31|2011-10-08|2011-10-08 08:13:45|1 |868|34|2011-10-08|2011-10-08 08:13:53|1 |869|1|2011-10-08|2011-10-08 13:03:11|0 |870|1|2011-10-08|2011-10-08 19:19:58|0 |871|1|2011-10-08|2011-10-08 19:20:43|0 |872|5|2011-10-08|2011-10-08 19:21:26|0 |873|1|2011-10-09|2011-10-09 01:05:45|0 |874|1|2011-10-09|2011-10-09 03:36:36|0 |875|1|2011-10-09|2011-10-09 16:07:36|0 |876|1|2011-10-09|2011-10-09 16:25:36|0 |877|1|2011-10-09|2011-10-09 17:21:55|0 |878|1|2011-10-10|2011-10-10 01:42:55|0 |879|1|2011-10-10|2011-10-10 06:35:12|0 |880|1|2011-10-10|2011-10-10 06:35:13|0 |881|1|2011-10-10|2011-10-10 07:10:18|0 |882|1|2011-10-10|2011-10-10 17:15:16|0 |883|1|2011-10-11|2011-10-11 04:44:52|0 |884|1|2011-10-11|2011-10-11 11:30:54|0 |885|1|2011-10-11|2011-10-11 16:05:05|0 |886|1|2011-10-11|2011-10-11 17:32:24|0 |887|1|2011-10-11|2011-10-11 19:49:42|0 |888|1|2011-10-11|2011-10-11 19:54:00|0 |889|5|2011-10-11|2011-10-11 19:54:26|0 |890|5|2011-10-11|2011-10-11 19:54:36|0 |891|5|2011-10-11|2011-10-11 19:55:06|0 |892|5|2011-10-11|2011-10-11 20:13:50|0 |893|5|2011-10-11|2011-10-11 20:13:53|0 |894|5|2011-10-11|2011-10-11 20:13:59|0 |895|5|2011-10-11|2011-10-11 20:14:00|0 |896|5|2011-10-11|2011-10-11 20:14:07|0 |897|5|2011-10-11|2011-10-11 20:15:30|0 |898|1|2011-10-11|2011-10-11 20:15:30|1 |899|1|2011-10-11|2011-10-11 20:15:42|1 |900|1|2011-10-11|2011-10-11 20:15:45|1 |901|1|2011-10-11|2011-10-11 20:17:33|1 |902|1|2011-10-11|2011-10-11 20:17:47|1 |903|1|2011-10-11|2011-10-11 20:18:43|0 |904|5|2011-10-11|2011-10-11 20:18:50|0 |905|5|2011-10-11|2011-10-11 20:19:01|0 |906|1|2011-10-11|2011-10-11 20:19:02|1 |907|5|2011-10-11|2011-10-11 20:20:41|1 |908|1|2011-10-11|2011-10-11 20:20:41|0 |909|1|2011-10-11|2011-10-11 20:21:40|0 |910|5|2011-10-11|2011-10-11 20:21:45|0 |911|5|2011-10-11|2011-10-11 20:21:52|0 |912|1|2011-10-11|2011-10-11 20:21:53|1 |913|1|2011-10-11|2011-10-11 20:21:58|1 |914|1|2011-10-11|2011-10-11 20:24:44|1 |915|1|2011-10-11|2011-10-11 20:28:05|0 |916|5|2011-10-11|2011-10-11 20:28:13|0 |917|5|2011-10-11|2011-10-11 20:28:18|0 |918|1|2011-10-11|2011-10-11 20:28:19|1 |919|1|2011-10-11|2011-10-11 20:28:42|1 |920|1|2011-10-11|2011-10-11 20:30:38|1 |921|1|2011-10-11|2011-10-11 20:31:41|1 |922|1|2011-10-11|2011-10-11 20:35:08|0 |923|5|2011-10-11|2011-10-11 20:35:38|0 |924|5|2011-10-11|2011-10-11 20:35:44|0 |925|1|2011-10-11|2011-10-11 20:35:44|1 |926|1|2011-10-11|2011-10-11 20:36:30|1 |927|1|2011-10-11|2011-10-11 21:37:19|0 |928|5|2011-10-11|2011-10-11 21:37:24|0 |929|5|2011-10-11|2011-10-11 21:37:30|0 |930|1|2011-10-11|2011-10-11 21:37:30|1 |931|1|2011-10-11|2011-10-11 21:37:37|1 |932|1|2011-10-11|2011-10-11 23:15:55|0 |933|1|2011-10-11|2011-10-11 23:16:32|0 |934|1|2011-10-12|2011-10-12 01:54:33|0 |935|1|2011-10-12|2011-10-12 01:54:52|0 |936|1|2011-10-12|2011-10-12 01:54:58|0 == 表的结构 PageStatistics |------ |字段|类型|空|默认 |------ |//**pstID**//|bigint(20) |否| |cID|int(10) |否|0 |date|date|是|NULL |timestamp|timestamp|否|CURRENT_TIMESTAMP |uID|int(10) |否|0 == 表的结构 PageThemes |------ |字段|类型|空|默认 |------ |//**ptID**//|int(10) |否| |**ptHandle**|varchar(64)|否| |ptName|varchar(255)|是|NULL |ptDescription|text|是|NULL |pkgID|int(10) |否|0 == 转存表中的数据 PageThemes |1|default|Plain Yogurt |Plain Yogurt is Concrete's default theme.|0 |2|greensalad|Green Salad Theme |This is Concrete's Green Salad site theme.|0 |3|dark_chocolate|Dark Chocolate |Dark Chocolate is Concrete's default theme in black.|0 == 表的结构 PageThemes |------ |字段|类型|空|默认 |------ |//**ptID**//|int(10) |否| |**ptHandle**|varchar(64)|否| |ptName|varchar(255)|是|NULL |ptDescription|text|是|NULL |pkgID|int(10) |否|0 == 表的结构 PageThemeStyles |------ |字段|类型|空|默认 |------ |//**ptID**//|int(10) |否|0 |//**ptsHandle**//|varchar(128)|否| |ptsValue|longtext|是|NULL |//**ptsType**//|varchar(32)|否| == 转存表中的数据 PageThemeStyles == 表的结构 PageThemeStyles |------ |字段|类型|空|默认 |------ |//**ptID**//|int(10) |否|0 |//**ptsHandle**//|varchar(128)|否| |ptsValue|longtext|是|NULL |//**ptsType**//|varchar(32)|否| == 表的结构 PageTypeAttributes |------ |字段|类型|空|默认 |------ |//**ctID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 == 转存表中的数据 PageTypeAttributes |1|1 |1|2 |1|3 |1|4 == 表的结构 PageTypeAttributes |------ |字段|类型|空|默认 |------ |//**ctID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 == 表的结构 PageTypes |------ |字段|类型|空|默认 |------ |//**ctID**//|int(10) |否| |**ctHandle**|varchar(32)|否| |ctIcon|varchar(128)|是|NULL |ctName|varchar(90)|否| |pkgID|int(10) |否|0 == 转存表中的数据 PageTypes |1|page|template3.png|Page|0 == 表的结构 PageTypes |------ |字段|类型|空|默认 |------ |//**ctID**//|int(10) |否| |**ctHandle**|varchar(32)|否| |ctIcon|varchar(128)|是|NULL |ctName|varchar(90)|否| |pkgID|int(10) |否|0 == 表的结构 PileContents |------ |字段|类型|空|默认 |------ |//**pcID**//|int(10) |否| |pID|int(10) |否|0 |itemID|int(10) |否|0 |itemType|varchar(64)|否| |quantity|int(10) |否|1 |timestamp|timestamp|否|CURRENT_TIMESTAMP |displayOrder|int(10) |否|0 == 转存表中的数据 PileContents == 表的结构 PileContents |------ |字段|类型|空|默认 |------ |//**pcID**//|int(10) |否| |pID|int(10) |否|0 |itemID|int(10) |否|0 |itemType|varchar(64)|否| |quantity|int(10) |否|1 |timestamp|timestamp|否|CURRENT_TIMESTAMP |displayOrder|int(10) |否|0 == 表的结构 Piles |------ |字段|类型|空|默认 |------ |//**pID**//|int(10) |否| |uID|int(10) |是|NULL |isDefault|tinyint(1)|否|0 |timestamp|timestamp|否|CURRENT_TIMESTAMP |name|varchar(255)|是|NULL |state|varchar(64)|否| == 转存表中的数据 Piles |1|1|1|2011-04-19 11:30:00|NULL|READY == 表的结构 Piles |------ |字段|类型|空|默认 |------ |//**pID**//|int(10) |否| |uID|int(10) |是|NULL |isDefault|tinyint(1)|否|0 |timestamp|timestamp|否|CURRENT_TIMESTAMP |name|varchar(255)|是|NULL |state|varchar(64)|否| == 表的结构 SignupRequests |------ |字段|类型|空|默认 |------ |//**id**//|int(11)|否| |ipFrom|int(10) |否|0 |date_access|timestamp|否|CURRENT_TIMESTAMP == 转存表中的数据 SignupRequests == 表的结构 SignupRequests |------ |字段|类型|空|默认 |------ |//**id**//|int(11)|否| |ipFrom|int(10) |否|0 |date_access|timestamp|否|CURRENT_TIMESTAMP == 表的结构 SystemNotifications |------ |字段|类型|空|默认 |------ |//**snID**//|int(10) |否| |snTypeID|int(3) |否|0 |snURL|text|是|NULL |snURL2|text|是|NULL |snDateTime|datetime|否| |snIsArchived|int(1)|否|0 |snIsNew|int(1)|否|0 |snTitle|varchar(255)|是|NULL |snDescription|text|是|NULL |snBody|text|是|NULL == 转存表中的数据 SystemNotifications |1|11|http://www.concrete5.org/about/blog/concrete5-sightings/concrete5-takes-off-in-the-uk/|NULL|2011-04-19 14:24:00|0|0|concrete5 takes off in the UK!|A great in-depth article and cover shot on this month's Web Designer Magazine in the UK has us wanting to flush out our UK meetups. Do you live in the UK and love concrete5? Let us know!|A great in-depth article and cover shot on this month's Web Designer Magazine in the UK has us wanting to flush out our UK meetups. Do you live in the UK and love concrete5? Let us know! |2|11|http://www.concrete5.org/about/blog/concrete5-sightings/book-on-concrete5-released/|NULL|2011-04-18 16:31:00|0|0|Book on concrete5 released!|Packt publishing has released a great introduction for developers to concrete5. If you know PHP but are new to concrete5, this is a great tool.|Packt publishing has released a great introduction for developers to concrete5. If you know PHP but are new to concrete5, this is a great tool. |3|11|http://www.concrete5.org/about/blog/concrete5-sightings/live-screencast-on-designer-content-block/|NULL|2011-04-14 14:36:00|0|0|Live Screencast on Designer Content Block|For this week's totally random live screencast Andrew is out of town, so we're bringing in JordanLev to talk about how his cool Designer Content block works.|For this week's totally random live screencast Andrew is out of town, so we're bringing in JordanLev to talk about how his cool Designer Content block works. |4|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-studio-testimonials/|NULL|2011-04-11 17:26:45|0|0|Add-on Approved: Studio Testimonials|<p>Manage and display user testimonials at random, including live rotation, and allow users to submit new testimonials.</p><p><a href="http://www.concrete5.org/marketplace/addons/studio-testimonials/">View this item in the marketplace.</a></p>|<p>Manage and display user testimonials at random, including live rotation, and allow users to submit new testimonials.</p><p><a href="http://www.concrete5.org/marketplace/addons/studio-testimonials/">View this item in the marketplace.</a></p> |5|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-scrapbook-slider-for-concrete5/|NULL|2011-04-11 17:17:06|0|1|Add-on Approved: Scrapbook Slider for Concrete5|<p>Easily create amazing enhanced slideshows for your website with Scrapbook Slide for Concrete5.</p><p><a href="http://www.concrete5.org/marketplace/addons/scrapbook-slider-for-concrete5/">View this item in the marketplace.</a></p>|<p>Easily create amazing enhanced slideshows for your website with Scrapbook Slide for Concrete5.</p><p><a href="http://www.concrete5.org/marketplace/addons/scrapbook-slider-for-concrete5/">View this item in the marketplace.</a></p> |6|10|/index.php/dashboard/system/update/|NULL|2011-10-08 08:07:44|0|1|A new version of concrete5 is now available.| | <h2>5.4.2.1</h2> <h3>New Features</h3> <ul> <li>Updated the YouTube block that fixes IE bugs, works with youtu.be URLs, allows the size of the video to be changed, and supports mobile devices.</li> </ul> <h3>Bug Fixes &amp; Security Improvements</h3> <ul> <li>Fixing bug where custom template changes would be immediately visible on a live site.</li> <li>Fixed bug where editing a custom style would display the wrong style name in the confirmation area.</li> <li>Updated security "regenerateSession" function to work better in IE than php's built-in session_regenerate_id() function.</li> <li>User Attribute cache was persisting even when it was supposed to be cleared, leading to unsortable user attributes, data retention, etc...</li> <li>Fixed bug in the mail helper where interaction with new helper code could lead to many duplicate emails being sent if they all are sent in one request.</li> <li>Reverted a fix for zip_open failing on larger archives on 64-bit linux. Rewrote solution to hopefully fix both problems. Should fix problems with zip not unpacking marketplace archives.</li> <li>Fixed bug where renaming a block in a scrapbook with a space in it fails to work</li> <li>Fixed bug with layouts where spacing wasn't being honored.</li> <li>Fixed bug where Zend Framework would complain if it already appeared with the include_path before concrete5 loaded.</li> <li>File downloads should no longer hang the active session</li> <li>Fixed nav bar in the settings section (thanks 12345j)</li> <li>Fixed some bugs in the sample content (thanks 12345j)</li> <li>Fixed bug when getting page by path with a trailing slash (shouldn't happen through front-end request, only through API)</li> <li>Fixed places where strings weren't being translated.</li> <li>Fixed http://www.concrete5.org/developers/bugs/5-4-2/filemanager-sets-can-type-when-add-to-set-isnand039t-selected/</li> <li>Fixed bug where add-ons wouldn't download under certain circumstances.</li> <li>Composer sometimes wouldn't publish the latest version when clicking "Publish," due to a conflict with autosaving. This is fixed.</li> <li>Sometimes previewing a page in composer wouldn't have the most up to date copy of the page.</li> <li>Fixed bug in advanced permissions where blocks couldn't be reverted to area permissions because the button didn't exist.</li> </ul> <h3>Behavioral Improvements</h3> <ul> <li>Stripping tags from JSON response because of some plugins/malware that injects HTML into a response, screwing up editing</li> <li>Modified Zend Framework's Loader.php to fix bug where Zend Framework improperly whines about open_basedir when loading Zend_Translate in some cases</li> <li>Rich text editor attribute should load the required javascript and css to display the concrete5 toolbar.</li> <li>Autocomplete select attribute mode should work when you haven't already loaded the necessary javascript and css. </li> <li>Date picker no longer dies without javascript if jquery UI isn't included in header.</li> </ul> <h3>Developer Updates</h3> <ul> <li>Added a clear option to the page selector form helper.</li> <li>Added shortenURL() function to the URLS helper that shortens URLs with the TinyURL API (thanks 12345j)</li> <li>Added DATE_APP_DATE_PICKER constant that controls the jQuery UI datepicker dateFormat property. Documentation here: http://docs.jquery.com/UI/Datepicker/formatDate</li> </ul> |7|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-concrete-paving/|NULL|2011-10-06 17:28:44|0|1|Add-on Approved: Concrete Paving|<p>Concrete also gets used for paving. This Concrete5 take on the well known lines game brings the two together.</p><p><a href="http://www.concrete5.org/marketplace/addons/concrete-paving/">View this item in the marketplace.</a></p>|<p>Concrete also gets used for paving. This Concrete5 take on the well known lines game brings the two together.</p><p><a href="http://www.concrete5.org/marketplace/addons/concrete-paving/">View this item in the marketplace.</a></p> |8|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-flipper/|NULL|2011-10-06 17:21:39|0|1|Add-on Approved: Flipper|<p>It's like two content blocks, but with a flip!</p><p><a href="http://www.concrete5.org/marketplace/addons/flipper/">View this item in the marketplace.</a></p>|<p>It's like two content blocks, but with a flip!</p><p><a href="http://www.concrete5.org/marketplace/addons/flipper/">View this item in the marketplace.</a></p> |9|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-group-password/|NULL|2011-10-06 17:07:19|0|1|Add-on Approved: Group Password|<p>Users can subscribe to one or more group by entering a custom code (coupon code/password)</p><p><a href="http://www.concrete5.org/marketplace/addons/group-password/">View this item in the marketplace.</a></p>|<p>Users can subscribe to one or more group by entering a custom code (coupon code/password)</p><p><a href="http://www.concrete5.org/marketplace/addons/group-password/">View this item in the marketplace.</a></p> |10|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-photo-box/|NULL|2011-10-06 16:58:24|0|1|Add-on Approved: Photo Box|<p>Photo Box is a lightweight Jquery Image Gallery that automatically frames, scales and creates a thumbnail chooser.</p><p><a href="http://www.concrete5.org/marketplace/addons/photo-box/">View this item in the marketplace.</a></p>|<p>Photo Box is a lightweight Jquery Image Gallery that automatically frames, scales and creates a thumbnail chooser.</p><p><a href="http://www.concrete5.org/marketplace/addons/photo-box/">View this item in the marketplace.</a></p> |11|11|http://www.concrete5.org/about/blog/add-on-releases/add-on-approved-responsive-image-gallery/|NULL|2011-10-06 16:52:43|0|1|Add-on Approved: Responsive Image Gallery|<p>Resizable image gallery.</p><p><a href="http://www.concrete5.org/marketplace/addons/responsive-image-gallery/">View this item in the marketplace.</a></p>|<p>Resizable image gallery.</p><p><a href="http://www.concrete5.org/marketplace/addons/responsive-image-gallery/">View this item in the marketplace.</a></p> == 表的结构 SystemNotifications |------ |字段|类型|空|默认 |------ |//**snID**//|int(10) |否| |snTypeID|int(3) |否|0 |snURL|text|是|NULL |snURL2|text|是|NULL |snDateTime|datetime|否| |snIsArchived|int(1)|否|0 |snIsNew|int(1)|否|0 |snTitle|varchar(255)|是|NULL |snDescription|text|是|NULL |snBody|text|是|NULL == 表的结构 TaskPermissions |------ |字段|类型|空|默认 |------ |//**tpID**//|int(10) |否| |**tpHandle**|varchar(255)|是|NULL |tpName|varchar(255)|是|NULL |tpDescription|text|是|NULL |pkgID|int(10) |否|0 == 转存表中的数据 TaskPermissions |1|access_task_permissions|Change Task Permissions| |0 |2|access_sitemap|Access Sitemap and Page Search| |0 |3|access_user_search|Access User Search| |0 |4|access_group_search|Access Group Search| |0 |5|access_page_defaults|Change Content on Page Type Default Pages| |0 |6|backup|Perform Full Database Backups| |0 |7|sudo|Sign in as User| |0 |8|uninstall_packages|Uninstall Packages| |0 |9|install_packages|Install Packages and Connect to the Marketplace| |0 == 表的结构 TaskPermissions |------ |字段|类型|空|默认 |------ |//**tpID**//|int(10) |否| |**tpHandle**|varchar(255)|是|NULL |tpName|varchar(255)|是|NULL |tpDescription|text|是|NULL |pkgID|int(10) |否|0 == 表的结构 TaskPermissionUserGroups |------ |字段|类型|空|默认 |------ |//**tpID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |canRead|int(1)|否|0 == 转存表中的数据 TaskPermissionUserGroups |1|3|0|1 |2|3|0|1 |3|3|0|1 |4|3|0|1 |5|3|0|1 |6|3|0|1 |8|3|0|1 |9|3|0|1 == 表的结构 TaskPermissionUserGroups |------ |字段|类型|空|默认 |------ |//**tpID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |canRead|int(1)|否|0 == 表的结构 UserAttributeKeys |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |uakProfileDisplay|tinyint(1)|否|0 |uakMemberListDisplay|tinyint(1)|否|0 |uakProfileEdit|tinyint(1)|否|1 |uakProfileEditRequired|tinyint(1)|否|0 |uakRegisterEdit|tinyint(1)|否|0 |uakRegisterEditRequired|tinyint(1)|否|0 |displayOrder|int(10) |是|0 |uakIsActive|tinyint(1)|否|1 == 转存表中的数据 UserAttributeKeys == 表的结构 UserAttributeKeys |------ |字段|类型|空|默认 |------ |//**akID**//|int(10) |否| |uakProfileDisplay|tinyint(1)|否|0 |uakMemberListDisplay|tinyint(1)|否|0 |uakProfileEdit|tinyint(1)|否|1 |uakProfileEditRequired|tinyint(1)|否|0 |uakRegisterEdit|tinyint(1)|否|0 |uakRegisterEditRequired|tinyint(1)|否|0 |displayOrder|int(10) |是|0 |uakIsActive|tinyint(1)|否|1 == 表的结构 UserAttributeValues |------ |字段|类型|空|默认 |------ |//**uID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 |//**avID**//|int(10) |否|0 == 转存表中的数据 UserAttributeValues == 表的结构 UserAttributeValues |------ |字段|类型|空|默认 |------ |//**uID**//|int(10) |否|0 |//**akID**//|int(10) |否|0 |//**avID**//|int(10) |否|0 == 表的结构 UserBannedIPs |------ |字段|类型|空|默认 |------ |//**ipFrom**//|int(10) |否|0 |//**ipTo**//|int(10) |否|0 |banCode|int(1) |否|1 |expires|int(10) |否|0 |isManual|int(1)|否|0 == 转存表中的数据 UserBannedIPs == 表的结构 UserBannedIPs |------ |字段|类型|空|默认 |------ |//**ipFrom**//|int(10) |否|0 |//**ipTo**//|int(10) |否|0 |banCode|int(1) |否|1 |expires|int(10) |否|0 |isManual|int(1)|否|0 == 表的结构 UserGroups |------ |字段|类型|空|默认 |------ |//**uID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |ugEntered|datetime|否|0000-00-00 00:00:00 |type|varchar(64)|是|NULL == 转存表中的数据 UserGroups == 表的结构 UserGroups |------ |字段|类型|空|默认 |------ |//**uID**//|int(10) |否|0 |//**gID**//|int(10) |否|0 |ugEntered|datetime|否|0000-00-00 00:00:00 |type|varchar(64)|是|NULL == 表的结构 UserOpenIDs |------ |字段|类型|空|默认 |------ |uID|int(10) |否| |//**uOpenID**//|varchar(255)|否| == 转存表中的数据 UserOpenIDs == 表的结构 UserOpenIDs |------ |字段|类型|空|默认 |------ |uID|int(10) |否| |//**uOpenID**//|varchar(255)|否| == 表的结构 UserPrivateMessages |------ |字段|类型|空|默认 |------ |//**msgID**//|int(10) |否| |uAuthorID|int(10) |否|0 |msgDateCreated|datetime|否| |msgSubject|varchar(255)|否| |msgBody|text|是|NULL |uToID|int(10) |否|0 == 转存表中的数据 UserPrivateMessages == 表的结构 UserPrivateMessages |------ |字段|类型|空|默认 |------ |//**msgID**//|int(10) |否| |uAuthorID|int(10) |否|0 |msgDateCreated|datetime|否| |msgSubject|varchar(255)|否| |msgBody|text|是|NULL |uToID|int(10) |否|0 == 表的结构 UserPrivateMessagesTo |------ |字段|类型|空|默认 |------ |//**msgID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**uAuthorID**//|int(10) |否|0 |msgMailboxID|int(11)|否| |msgIsNew|int(1)|否|0 |msgIsUnread|int(1)|否|0 |msgIsReplied|int(1)|否|0 == 转存表中的数据 UserPrivateMessagesTo == 表的结构 UserPrivateMessagesTo |------ |字段|类型|空|默认 |------ |//**msgID**//|int(10) |否|0 |//**uID**//|int(10) |否|0 |//**uAuthorID**//|int(10) |否|0 |msgMailboxID|int(11)|否| |msgIsNew|int(1)|否|0 |msgIsUnread|int(1)|否|0 |msgIsReplied|int(1)|否|0 == 表的结构 Users |------ |字段|类型|空|默认 |------ |//**uID**//|int(10) |否| |**uName**|varchar(64)|否| |uEmail|varchar(64)|否| |uPassword|varchar(255)|否| |uIsActive|varchar(1)|否|0 |uIsValidated|tinyint(4)|否|-1 |uIsFullRecord|tinyint(1)|否|1 |uDateAdded|datetime|否|0000-00-00 00:00:00 |uHasAvatar|tinyint(1)|否|0 |uLastOnline|int(10) |否|0 |uLastLogin|int(10) |否|0 |uPreviousLogin|int(10) |否|0 |uNumLogins|int(10) |否|0 |uTimezone|varchar(255)|是|NULL == 转存表中的数据 Users |1|admin|royizhu@gmail.com|7b00e5a3e6a91726fc316b32adf81be5|1|-1|1|2011-04-19 11:21:11|0|1318390650|1318390650|1318386944|14|NULL == 表的结构 Users |------ |字段|类型|空|默认 |------ |//**uID**//|int(10) |否| |**uName**|varchar(64)|否| |uEmail|varchar(64)|否| |uPassword|varchar(255)|否| |uIsActive|varchar(1)|否|0 |uIsValidated|tinyint(4)|否|-1 |uIsFullRecord|tinyint(1)|否|1 |uDateAdded|datetime|否|0000-00-00 00:00:00 |uHasAvatar|tinyint(1)|否|0 |uLastOnline|int(10) |否|0 |uLastLogin|int(10) |否|0 |uPreviousLogin|int(10) |否|0 |uNumLogins|int(10) |否|0 |uTimezone|varchar(255)|是|NULL == 表的结构 UserSearchIndexAttributes |------ |字段|类型|空|默认 |------ |//**uID**//|int(11) |否|0 == 转存表中的数据 UserSearchIndexAttributes == 表的结构 UserSearchIndexAttributes |------ |字段|类型|空|默认 |------ |//**uID**//|int(11) |否|0 == 表的结构 UsersFriends |------ |字段|类型|空|默认 |------ |//**ufID**//|int(10) |否| |uID|int(10) |是|NULL |status|varchar(64)|否| |friendUID|int(10) |是|NULL |uDateAdded|datetime|否|0000-00-00 00:00:00 == 转存表中的数据 UsersFriends == 表的结构 UsersFriends |------ |字段|类型|空|默认 |------ |//**ufID**//|int(10) |否| |uID|int(10) |是|NULL |status|varchar(64)|否| |friendUID|int(10) |是|NULL |uDateAdded|datetime|否|0000-00-00 00:00:00 == 表的结构 UserValidationHashes |------ |字段|类型|空|默认 |------ |//**uvhID**//|int(10) |否| |uID|int(10) |是|NULL |uHash|varchar(64)|否| |type|int(4) |否|0 |uDateGenerated|int(10) |否|0 |uDateRedeemed|int(10) |否|0 == 转存表中的数据 UserValidationHashes == 表的结构 UserValidationHashes |------ |字段|类型|空|默认 |------ |//**uvhID**//|int(10) |否| |uID|int(10) |是|NULL |uHash|varchar(64)|否| |type|int(4) |否|0 |uDateGenerated|int(10) |否|0 |uDateRedeemed|int(10) |否|0