index
:
vndb
fran
master
Source code of VNDB.org
Yorhel
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
sql
/
tableattrs.sql
Age
Commit message (
Expand
)
Author
Files
Lines
2024-03-14
SQL: Add improved email normalization
Yorhel
1
-1
/
+1
2024-03-01
Misc::Reports: Use a proper log table, fix log formatting
Yorhel
1
-0
/
+3
2024-02-26
VN::Quotes: Remove approval system, adjust submission & editing limits
Yorhel
1
-0
/
+1
2024-02-23
Expand VN quotes feature a bit
Yorhel
1
-0
/
+8
2023-12-03
SQL: Rename staff.aid to staff.main
Yorhel
1
-1
/
+1
2023-10-14
DRM: Initial implementation
Yorhel
1
-0
/
+5
2023-09-15
SQL/quotes: Add "approved" flag and improve randomisation
Yorhel
1
-0
/
+1
2023-06-04
UserLogin: Allow login with email
Yorhel
1
-0
/
+1
2023-05-03
SQL: Rename columns that are SQL keywords
Yorhel
1
-1
/
+1
2023-04-19
Track who uploaded an images + add filter to image flagging browser
Yorhel
1
-0
/
+1
2023-03-24
Search backend changes: faster results with trigram index + ranking
Yorhel
1
-0
/
+2
2022-12-19
SQL: Also use MERGE for traits_chars_calc()
Yorhel
1
-1
/
+1
2022-12-19
SQL: Fix indices to use "NULLS NOT DISTINCT" instead of coalesce-hack
Yorhel
1
-5
/
+5
2022-12-18
SQL: Experiment with MERGE to perform in-place updates for tags_vn_calc()
Yorhel
1
-2
/
+0
2022-10-31
SQL: Merge ulist_vns_labels into ulist_vns as array + cache private flag
Yorhel
1
-4
/
+0
2022-09-28
WIP add language-specific titles to releases
Yorhel
1
-2
/
+4
2022-09-27
sql: Fix definition of foreign key constraint
Yorhel
1
-1
/
+1
2022-08-30
Also add trait overrides
Yorhel
1
-0
/
+2
2022-08-29
Add tag spoiler & highlight preferences
Yorhel
1
-0
/
+2
2022-08-25
Staff editions
Yorhel
1
-2
/
+4
2022-08-04
AdvSearch: Also add option to not match child traits
Yorhel
1
-0
/
+1
2022-08-03
Add tags_vn_direct cache table
Yorhel
1
-0
/
+2
2022-06-20
Add changes patrolling mod feature
Yorhel
1
-0
/
+2
2022-06-16
Debloat users table my moving some columns to other tables
Yorhel
1
-0
/
+1
2022-04-01
Add user traits feature
Yorhel
1
-0
/
+2
2022-02-08
VN: Add support for multiple titles in different languages
Yorhel
1
-0
/
+4
2021-11-19
Search adjustments + use new search for producers,staff,characters too
Yorhel
1
-6
/
+0
2021-11-18
Minor cleanup
Yorhel
1
-48
/
+48
2021-11-18
Releases: Experiment with new SQL search implementation
Yorhel
1
-0
/
+6
2021-11-15
Discussions::Search: Add reviews & review comment search
Yorhel
1
-0
/
+2
2021-10-28
Allow uppercase characters in usernames
Yorhel
1
-0
/
+1
2021-10-28
Allow and log username changes
Yorhel
1
-0
/
+1
2021-09-02
SQL: Add ON UPDATE CASCADE to to ulist_vns_labels constraints
Yorhel
1
-2
/
+2
2021-08-09
VNLengthVote: Add unique vote id to handle editing deleted user's votes
Yorhel
1
-1
/
+1
2021-08-09
VNLengthVote: Add support for multiple release selection
Yorhel
1
-1
/
+0
2021-08-04
VNLengthVote: Misc code reorg + basic user stats
Yorhel
1
-0
/
+1
2021-07-30
Add early test implementation of VN length voting
Yorhel
1
-0
/
+4
2021-05-25
SQL: Separate sensitive columns out of the users table
Yorhel
1
-0
/
+1
2021-03-23
Traits: Convert to vndbids + add edit history
Yorhel
1
-2
/
+5
2021-03-11
Tags: Convert to vndbids + add edit histories
Yorhel
1
-3
/
+3
2021-03-01
SQL: vndbid data type conversion for most DB entries
Yorhel
1
-3
/
+4
2021-01-29
SQL: Add index on releases.released to speed up homepage queries
Yorhel
1
-0
/
+1
2021-01-03
AdvSearch: Add feature to save/load/delete queries
Yorhel
1
-0
/
+1
2020-10-15
reviews: Allow anonymous voting + display overrule counting
Yorhel
1
-0
/
+1
2020-10-07
notifications: Mark as read when opening page + delete when deleting posts/re...
Yorhel
1
-1
/
+1
2020-10-07
notifications: Add backend for subscriptions and new notification types
Yorhel
1
-0
/
+1
2020-10-05
notifications: Consolidate and simplify creation of notifications
Yorhel
1
-1
/
+0
2020-08-25
SQL/reviews: Two rather stupid fixups on reviews_posts
Yorhel
1
-1
/
+1
2020-08-19
reviews: Count & list review comments as posts on user page
Yorhel
1
-0
/
+1
2020-08-17
reviews: Make reviews mod-only for now to allow some beta testing
Yorhel
1
-0
/
+10
[next]