dede_archives是什么？如何使用？

Of course. This is a very common question for developers working with the DedeCMS (织梦CMS) content management system.

Let's break down dede_archives in detail.

What is dede_archives?

In simple terms, dede_archives is the main and most important table in the DedeCMS database.

Think of it as the central library or the main filing cabinet for all your website's content. It stores the core information for every single piece of content you publish on your site, such as:

• Articles / Posts
• Pages
• Software Downloads
• Products (in many basic setups)

Its name comes from the default table prefix used by DedeCMS: dede_. So, the full name is dede_archives.

Core Purpose and Function

The primary purpose of dede_archives is to store the meta-data and content of your articles. This data is what powers your website's front-end display and the back-end management system.

When you create a new article in the DedeCMS admin panel, you are essentially adding a new row to this table. When a visitor views an article on your website, DedeCMS fetches the data for that specific article ID from this table and uses it to generate the HTML page.

Key Fields (Columns) in dede_archives

This table has many columns, but here are the most important ones you'll frequently encounter:

How it Works with Other Tables

dede_archives rarely works in isolation. It's the center of a relational database structure.

a) Relationship with dede_arctype (Categories)

• dede_arctype stores all your category information (e.g., "News," "Tutorials," "About Us").
• The typeid field in dede_archives links to the id field in dede_arctype.
• This connection allows DedeCMS to:
  • Group articles by category.
  • Automatically generate navigation menus.
  • Display articles belonging to a specific category on a category page.

b) Relationship with dede_addonarticle (Extended Content)

For articles, the main body content is often stored in a separate table called dede_addonarticle.

• Why? To keep the main dede_archives table lean and fast.
• The id in dede_archives is linked to an aid (article ID) field in dede_addonarticle.
• When you create an article, DedeCMS first creates a record in dede_archives with the title, author, etc., and then creates a corresponding record in dede_addonarticle with the full body content.

Example Query: To get a full article with its category name, you would need to join these tables:

SELECT
    a.title,
    a.body,
    t.typename as category_name
FROM
    dede_archives as a
JOIN
    dede_arctype as t ON a.typeid = t.id
WHERE
    a.id = 123; -- The ID of the article you want to fetch

Common Use Cases and Examples

Use Case 1: Getting the 10 Most Popular Articles

You would query dede_archives and order by the click field.

SELECT id, title, litpic
FROM dede_archives
WHERE arcrank = 0 -- Only get published articles
ORDER BY click DESC
LIMIT 10;

Use Case 2: Getting All Articles in a Specific Category

You would filter by the typeid field.

SELECT id, title, description, pubdate
FROM dede_archives
WHERE typeid = 5 -- Assuming category ID 5 is "Tutorials"
AND arcrank = 0
ORDER BY pubdate DESC;

Use Case 3: Fixing Broken Links or Images

If you migrate a site or change image paths, you might need to update the body field for all articles.

Warning: This is an advanced operation. Always back up your database first!

-- This is an example. Be very careful with UPDATE statements.
UPDATE dede_archives
SET body = REPLACE(body, 'old-image-path/', 'new-image-path/')
WHERE body LIKE '%old-image-path%';

Summary