ai_use_cases.db•53.2 kB
SQLite format 3 @
.r�
� �
�� V
�
� \
��� � E-�indexidx_scraping_configs_enabledscraping_configs
CREATE INDEX idx_scraping_configs_enabled ON scraping_configs(enabled)r =%�indexidx_use_cases_created_atai_use_cases CREATE INDEX idx_use_cases_created_at ON ai_use_cases(created_at)l
9%�indexidx_use_cases_industryai_use_cases CREATE INDEX idx_use_cases_industry ON ai_use_cases(industry)l 9%�indexidx_use_cases_categoryai_use_cases
CREATE INDEX idx_use_cases_category ON ai_use_cases(category)�D--�;tablescraping_resultsscraping_resultsCREATE TABLE scraping_results (
id TEXT PRIMARY KEY,
url TEXT NOT NULL,
title TEXT NOT NULL,
content TEXT NOT NULL,
extracted_data TEXT NOT NULL,
success INTEGER NOT NULL,
error TEXT,
timestamp TEXT NOT NULL
)?S- indexsqlite_autoindex_scraping_results_1scraping_results �0++�tablekeyword_configskeyword_configsCREATE TABLE keyword_configs (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
keywords TEXT NOT NULL,
category TEXT NOT NULL,
enabled INTEGER DEFAULT 1,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL
)=Q+ indexsqlite_autoindex_keyword_configs_1keyword_configs�J--�Gtablescraping_configsscraping_configsCREATE TABLE scraping_configs (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
url TEXT NOT NULL,
selectors TEXT NOT NULL,
enabled INTEGER DEFAULT 1,
last_scraped TEXT,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL
)?S- indexsqlite_autoindex_scraping_configs_1scraping_configs�X%%�stableai_use_casesai_use_casesCREATE TABLE ai_use_cases (
id TEXT PRIMARY KEY,
title TEXT NOT NULL,
summary TEXT NOT NULL,
source_url TEXT NOT NULL,
category TEXT NOT NULL,
industry TEXT,
technology_keywords TEXT NOT NULL,
publication_date TEXT,
company TEXT,
implementation_details TEXT,
results TEXT,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL
)7K% indexsqlite_autoindex_ai_use_cases_1ai_use_cases