summaryrefslogtreecommitdiff
path: root/templates/posts.sql
AgeCommit message (Collapse)Author
2013-09-01New index in post tables for listing threads slightly faster (index pages)Michael Foster
2013-09-01Fix issue #136Michael Foster
2013-09-01Some SQL and indexes improvementsMichael Foster
2013-08-29Critical bugfix: SQL typoMichael Foster
2013-08-28Add `ip` index to post tables for faster ?/IP/ (and flood detection, etc.)Michael Foster
2013-08-18Make `file` and `thumb` 255 charsMichael Foster
2013-07-31Add optional database table prefix (issue #118; see issue comments for details)Michael Foster
2013-07-31Convert to UNIX line endingsMichael Foster
2013-07-30Upgrade to utf8mb4 charset for MySQL server versions above 5.5.3. Keep ↵Michael Foster
support for older versions. Fix charsets for multiple columns and tables.
2013-01-19Remove now redundant single-column `thread` key from posts_* tables.Macil Tech
2013-01-19Add (`thread`, `id`) multi-column key to optimize rebuilding index pages.Macil Tech
This SQL command can be used to add the key to existing board tables: create index `thread_id` on posts_%s (`thread`, `id`);
2012-08-27use UNSIGNED for `id` columnsMichael Save
2011-12-05track cites (remove broken links after a post 404s)Savetheinternet
2011-12-05use NULL in database where possibleSavetheinternet
2011-10-10update SQL files for v0.9.4-dev-2Savetheinternet
2011-10-05transition to TwigSavetheinternet
2011-10-02add indexesSavetheinternet
2011-10-01Show full filename on mouseover.Savetheinternet
2011-09-10Use MyISAM instead of InnoDBSavetheinternet
2011-08-27increased subject max length to 100 charactersSavetheinternet
2011-07-14made `filehash` TEXT instead of a varchar (fixed maximum length)Savetheinternet
2011-05-18Embedding fieldSavetheinternet
2011-04-30increased field sizesSavetheinternet
2011-04-12Fix AUTO_INCREMENT in SQL dumpsSavetheinternet
2011-04-12New `capcode` field for posts and custom capcodes (run install.php to ↵Savetheinternet
upgrade tables)
2011-03-28Expanded database for larger capcodes. See commit comment for a query to ↵Savetheinternet
update existing tables.
2011-03-21Fix IPv6...Savetheinternet
2011-02-19Increased `filehash` length and made the ↵Savetheinternet
reject-post-if-image-already-exists-in-active-content thing
2011-02-17Expanded fields in databaseSavetheinternet
2011-01-19a bunch of thingsSavetheinternet
2011-01-02Locked field in databaseSavetheinternet
2010-12-16Basic stickiesSavetheinternet
2010-12-02SQL table creation templateSavetheinternet
generated by cgit v1.3 (git 2.53.0) at 2026-10-25 21:17:10 +0000