FileRack Default Categories Investigation

Database Connection

✅ Connected to database: filerack_launcher

Database Table Check

Found 8 tables in database:

Category-Related Tables:

Categories Table Structure

Field Type Null Key Default
id int NO PRI
user_id int YES MUL
name varchar(100) NO
description text YES
color varchar(7) YES #2563EB
is_default tinyint(1) YES MUL 0
is_active tinyint(1) YES 1
sort_order int YES 0
created_at timestamp YES CURRENT_TIMESTAMP
updated_at timestamp YES CURRENT_TIMESTAMP

Categories Content (Sample):

iduser_idnamedescriptioncoloris_defaultis_activesort_ordercreated_atupdated_at
451General#2563EB0102025-07-27 01:31:112025-07-27 01:31:11
461Business#2563EB0102025-07-27 01:31:112025-07-27 01:31:11
471News#2563EB0102025-07-27 01:31:112025-07-27 01:31:11
481AI#2563EB0102025-07-27 01:31:112025-07-27 01:31:11
491Search Engines#2563EB0102025-07-27 01:31:112025-07-27 01:31:11

Default Categories Check

✅ default_categories table exists!

Table Structure:

Field Type Null Key Default
id int NO PRI
name varchar(255) NO
description text YES
sites json YES
display_order int YES 0

Default Categories Content:

idnamedescriptionsitesdisplay_order
1GeneralCommonly used websites[{"url": "https://google.com", "name": "Google", "description": "Search engine"}, {"url": "https://gmail.com", "name": "Gmail", "description": "Email service"}, {"url": "https://amazon.com", "name": "Amazon", "description": "Online shopping"}, {"url": "https://maps.google.com", "name": "Google Maps", "description": "Maps and directions"}, {"url": "https://copilot.com", "name": "Copilot", "description": "AI assistant"}, {"url": "https://biz.yahoo.com", "name": "Yahoo Business", "description": "Business news"}, {"url": "https://expedia.com", "name": "Expedia", "description": "Travel booking"}]0
2BusinessBusiness and financial websites[{"url": "https://biz.yahoo.com", "name": "Yahoo Business", "description": "Business news"}, {"url": "https://cnbc.com", "name": "CNBC", "description": "Business news"}, {"url": "https://business.com", "name": "Business.com", "description": "Business resources"}, {"url": "https://bloomberg.com", "name": "Bloomberg", "description": "Financial news"}, {"url": "https://businessinsider.com", "name": "Business Insider", "description": "Business news"}, {"url": "https://seekingalpha.com", "name": "Seeking Alpha", "description": "Investment research"}, {"url": "https://foxbusiness.com", "name": "Fox Business", "description": "Business news"}, {"url": "https://dailystocks.com", "name": "Daily Stocks", "description": "Stock information"}, {"url": "https://thomasnet.com", "name": "Thomas Net", "description": "Supplier discovery"}]1
3NewsNews and information websites[{"url": "https://wsj.com", "name": "Wall Street Journal", "description": "Financial news"}, {"url": "https://apnews.com", "name": "AP News", "description": "Associated Press"}, {"url": "https://npr.org", "name": "NPR", "description": "Public radio"}, {"url": "https://news.google.com", "name": "Google News", "description": "News aggregator"}, {"url": "https://cnn.com", "name": "CNN", "description": "Cable news"}, {"url": "https://abcnews.go.com", "name": "ABC News", "description": "Broadcast news"}, {"url": "https://news.yahoo.com", "name": "Yahoo News", "description": "News portal"}, {"url": "https://bbc.com", "name": "BBC", "description": "British news"}, {"url": "https://reuters.com", "name": "Reuters", "description": "International news"}, {"url": "https://newsnationnow.com", "name": "NewsNation", "description": "Cable news"}, {"url": "https://axios.com", "name": "Axios", "description": "News briefings"}, {"url": "https://washingtonpost.com", "name": "Washington Post", "description": "Newspaper"}, {"url": "https://cbsnews.com", "name": "CBS News", "description": "Broadcast news"}, {"url": "https://usatoday.com", "name": "USA Today", "description": "Newspaper"}, {"url": "https://nytimes.com", "name": "NY Times", "description": "Newspaper"}, {"url": "https://latimes.com", "name": "LA Times", "description": "Newspaper"}, {"url": "https://foxnews.com", "name": "Fox News", "description": "Cable news"}]2
4AIArtificial intelligence tools[{"url": "https://chatgpt.com", "name": "ChatGPT", "description": "AI chat by OpenAI"}, {"url": "https://gemini.google.com", "name": "Google Gemini", "description": "Google AI assistant"}, {"url": "https://anthropic.com", "name": "Anthropic", "description": "Claude AI assistant"}, {"url": "https://copilot.com", "name": "Microsoft Copilot", "description": "Microsoft AI assistant"}, {"url": "https://perplexity.ai", "name": "Perplexity", "description": "AI search engine"}, {"url": "https://genspark.ai", "name": "GenSpark", "description": "AI platform"}, {"url": "https://manus.chat", "name": "Manus", "description": "AI assistant"}, {"url": "https://notebooklm.google.com", "name": "Google NotebookLM", "description": "AI notes"}, {"url": "https://midjourney.com", "name": "Midjourney", "description": "AI image generation"}, {"url": "https://deepl.com", "name": "DeepL", "description": "AI translation"}, {"url": "https://quillbot.com", "name": "QuillBot", "description": "AI writing assistant"}]3
5Search EnginesWeb search tools[{"url": "https://google.com", "name": "Google", "description": "Search engine"}, {"url": "https://bing.com", "name": "Bing", "description": "Microsoft search"}, {"url": "https://yahoo.com", "name": "Yahoo", "description": "Search portal"}, {"url": "https://duckduckgo.com", "name": "DuckDuckGo", "description": "Privacy-focused search"}, {"url": "https://elasticsearch.com", "name": "Elasticsearch", "description": "Search platform"}, {"url": "https://excite.com", "name": "Excite", "description": "Search portal"}, {"url": "https://opensearch.com", "name": "OpenSearch", "description": "Search engine"}, {"url": "https://ahmia.fi", "name": "Ahmia", "description": "Onion search engine"}, {"url": "https://chegg.com", "name": "Chegg", "description": "Educational search"}]4

Recommended Actions

Back to Dashboard