search

zakaf / KDHC

KDHC
http://www.dongkeunlee.com
6 stars 0 forks source link

Database schema overhaul #27

Closed zakaf closed 6 years ago

zakaf commented 6 years ago
  1. Drop column crawled_url_id from news
  2. Add a table (news_crawl_ct) connecting news and crawl_url
  3. Fix crawl logic -> add news and then add news_crawl_ct (all crawl_url with same url connected to news)
  4. Fix addKeyword logic -> user can't have same keyword, if keyword and url combination exists, just add ct
  5. Fix deleteKeyword logic -> delete crawl_url and news if current user is the only one using it
  6. Fix /news, /keywords, /listKeywords to fit new db schema
zakaf commented 6 years ago

done 7838fad86cc0cbd589fae45295e971450f830eee