Можно выбирать базу, смотреть структуру, выполнять SELECT/PRAGMA и write-SQL с отдельным подтверждением.
| База | Статус | Путь | Размер |
|---|---|---|---|
| SEO DB · article_keyword_pool.sqlite | OK | /var/www/www-root/data/www/saltolibero.ru/seo_keywords/az/article_keyword_pool.sqlite | 165.18 MB |
| Articles DB · articles.db | NO | /home/a/ae535/my.4l.su/public_html/az/perelinkovka/articles.db | - |
| Professions DB · professions.db | NO | /home/a/ae535/my.4l.su/public_html/az/prof/professions.db | - |
| Courses DB · courses.db | NO | /home/a/ae535/my.4l.su/public_html/az/kurs/courses.db | - |
READ OK · строк: 7
| name |
|---|
| article_anchors |
| article_faq |
| article_gaps |
| article_queries |
| article_terms |
| articles |
| sqlite_sequence |
Array
(
[0] => Array
(
[name] => article_anchors
)
[1] => Array
(
[name] => article_faq
)
[2] => Array
(
[name] => article_gaps
)
[3] => Array
(
[name] => article_queries
)
[4] => Array
(
[name] => article_terms
)
[5] => Array
(
[name] => articles
)
[6] => Array
(
[name] => sqlite_sequence
)
)
| Таблица | Строк | Поля |
|---|---|---|
| article_anchors | 20296 | id INTEGER, article_id INTEGER, domain TEXT, url TEXT, anchor_text TEXT, priority INTEGER, created_at TEXT |
| article_faq | 17745 | id INTEGER, article_id INTEGER, domain TEXT, url TEXT, question TEXT, answer TEXT, priority INTEGER, created_at TEXT |
| article_gaps | 20280 | id INTEGER, article_id INTEGER, domain TEXT, url TEXT, gap_text TEXT, priority INTEGER, created_at TEXT |
| article_queries | 93761 | id INTEGER, article_id INTEGER, domain TEXT, url TEXT, query_type TEXT, query_text TEXT, priority INTEGER, intent_type TEXT, note TEXT, created_at TEXT, query_clean TEXT, query_stem TEXT, normalized_at TEXT |
| article_terms | 101237 | id INTEGER, article_id INTEGER, domain TEXT, url TEXT, term_type TEXT, term TEXT, created_at TEXT |
| articles | 2542 | id INTEGER, domain TEXT, path TEXT, url TEXT, title TEXT, text_len_original INTEGER, text_len_sent INTEGER, main_topic TEXT, topic_cluster TEXT, search_intent TEXT, intent_type TEXT, commercial_angle TEXT, recommended_title TEXT, recommended_meta_description TEXT, raw_json TEXT, status TEXT, error TEXT, created_at TEXT, updated_at TEXT, page_type TEXT |
| sqlite_sequence | 6 | name, seq |