summaryrefslogtreecommitdiff
path: root/Makefile
AgeCommit message (Collapse)AuthorFilesLines
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-1/+7
This is the first part. The flag is stored in the database, can be edited through the usual VN edit form, and is displayed in the diff viewer. Things to do to make this feature fully functional: - display "official" status on VN page at the relation listing - update relation graphs to display unofficial relations differently - update guidelines
2010-11-02Removed XML sitemapYorhel1-0/+1
Was growing too large and isn't really necessary anymore, now that VNDB is indexed quite well in most search engines.
2010-03-13Improved VN searchYorhel1-1/+5
This adds a new column to the vn table: c_search, which holds the normalized titles for speedy search results using LIKE. Also split some functions from VNDB::Func that didn't require YAWF into a VNDBUtil module, so Multi can also make use of them. The normalization functions are the same for Multi and VNDB, after all. The API and Multi::IRC still use the old search, these should be updated as well.
2010-01-24Versioned the deleting and locking of database entriesYorhel1-5/+9
This is implemented by adding ihid (item hidden) and ilock (item locked) columns to the changes table, The (vn|release|producer).(hidden|locked) columns now work as a cache, refering to the changes.(ihid|ilock) columns with changes.id = (vn|release|producer).latest. The cached columns are updated automatically each time a new revision is inserted. This is a pretty large change, bugs are quite likely.
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel1-2/+2
The functions can now be edited without having to repeat them in the update scripts. Just importing the func.sql file with \i will do the trick.
2009-12-06Added simple SQL manipulation and upgrade functionality to the MakefileYorhel1-11/+48
This makes it possible to do (mostly) automated updates, and makes sure I don't forget to update something, as usual. Of course, this update functionality is not fool-proof, and in no way subsistutes for manually checking what an update requires. It simply does the things that a basic script can do without relying on a specific configuration.
2009-11-02Makefile: Added rules for controlling MultiYorhel1-1/+31
This will come in handy when writing update rules.
2009-11-02Replaced util/init.pl with a MakefileYorhel1-0/+72
I'm planning to add some more stuff to this makefile later, like starting/stopping Multi and performing updates.