path: root/Makefile
AgeCommit message (Collapse)AuthorFilesLines
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 = (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/ with a MakefileYorhel1-0/+72
I'm planning to add some more stuff to this makefile later, like starting/stopping Multi and performing updates.