76 commits

Author	SHA1	Message	Date
Eggbertx	db6194a5fd	Add DBVERSION SQL replacer constant	2025-07-10 12:00:37 -07:00
Eggbertx	d5f489ef22	implement all installer pages, add DBPREFIX to constraints (not necessary to update if already installed)	2025-06-27 17:01:57 -07:00
Eggbertx	305b557e41	Refactor threads table, rename cyclical attribute to cyclic for consistency	2025-05-02 11:47:01 -07:00
Eggbertx	401662a0a9	Add banned message handling to posts and update related views	2025-04-29 20:16:55 -07:00
Eggbertx	83f8601334	Refactor thread and post data structures to include IsSpoilered and update related queries and templates (still a WIP)	2025-04-21 17:10:42 -07:00
Eggbertx	61693f4a4a	Exit without errors (but with warning message) if database is empty, and with appropriate message if database_version exists but doesn't have gochan db version	2025-04-20 14:03:22 -07:00
Eggbertx	f370c4bd37	Merge branch 'master' into audit-config-fields	2025-04-20 10:52:40 -07:00
Eggbertx	d5e6bb9a11	Update Go version in Dockerfile, add frontend building to shell script and fix view drop order	2025-04-18 14:42:00 -07:00
Eggbertx	3cbf75db1d	Merge branch 'master' into audit-config-fields	2025-04-18 14:11:22 -07:00
Eggbertx	331d437c0e	Update Go tag in Dockerfile, update config file, and fix Postgres compatibility issues in reset_views.sql	2025-04-18 14:06:50 -07:00
Eggbertx	f37dbbc840	Rename threads column spoilered to is_spoilered for consistency	2025-04-16 16:57:44 -07:00
Eggbertx	3dc45fef53	Add spoilered column and migration, update tests in gctemplates to use goquery to not have to test against really big strings	2025-04-13 01:18:55 -07:00
Eggbertx	b8547af58d	Update ERD	2025-04-09 23:04:51 -07:00
Eggbertx	01faaa992f	Add spoilered column to threads table and improve initdb scripts to remove comments and properly get sql directory relative to script directory	2025-04-09 22:29:59 -07:00
Eggbertx	4c0ce122ad	Add is_secure_tripcode column to posts and update gochan-migration to add it	2025-04-06 15:08:46 -07:00
Eggbertx	37c73fae0d	Show link to embed video on recent posts page, show thumbnail on front page	2025-03-29 23:39:42 -07:00
Eggbertx	48fb11a199	Treat recent posts with embed as if they have no thumbnail/upload on front page	2025-03-29 12:59:16 -07:00
Eggbertx	a47e03def4	Add text formatting classes and update report handling logic to dismissing in bulk	2025-03-28 21:55:15 -07:00
Eggbertx	4aab676c67	Improve request validation and logging, implement cleanup for reports of deleted posts.	2025-03-28 17:34:00 -07:00
Eggbertx	b966604d1d	Avoid using Select * in SQL queries, normalize some view columns	2025-01-12 14:01:36 -08:00
Eggbertx	d41127a1df	Update post/thread/file deletion query scan parameters	2024-11-23 11:27:11 -08:00
Eggbertx	6f591bade7	Remove no longer necessary recent posts view	2024-11-23 10:42:56 -08:00
Eggbertx	f593f70bad	Return all post IDs in v_top_post_board_dir	2024-11-21 10:35:54 -08:00
Eggbertx	a55bd39cf1	Use only single quotes in reset_views.sql (double quotes cause issues in Postgres)	2024-11-07 11:22:17 -08:00
Eggbertx	658ee0f41d	Fix some issues with views (not getting the expected data, columns not matching, etc)	2024-10-20 01:01:13 -07:00
Eggbertx	184d7a1701	Fix syntax errors in view reset file	2024-10-18 16:30:02 -07:00
Eggbertx	7a3130635a	Reset views on gochan startup	2024-10-18 13:05:37 -07:00
Eggbertx	c7fa173d3a	Add more views	2024-10-17 12:36:26 -07:00
Eggbertx	046068fadf	add board_id to recent posts view	2024-10-17 11:55:04 -07:00
Eggbertx	018c1eef96	Add more views	2024-10-15 09:55:41 -07:00
Eggbertx	82cd5a338a	Start adding views	2024-10-14 12:50:16 -07:00
Eggbertx	8b19b771b5	Add SQL replacer notes	2024-10-14 12:23:08 -07:00
Eggbertx	a92b120b62	Update migration subject scripts and initial gochan db version	2024-09-22 13:01:50 -07:00
Eggbertx	9551c35f83	Update database ERD with handle_if_any	2024-09-06 15:41:12 -07:00
Eggbertx	b1df0bf80a	Add "handle if any" functionality to matching filters	2024-09-05 18:49:20 -07:00
Eggbertx	ec8ce785aa	Update ERD with renamed column	2024-08-25 17:23:36 -07:00
Eggbertx	ce293d3e24	replace is_regex in filters with more string matching options (substring, regex, exact match)	2024-08-24 15:37:34 -07:00
Eggbertx	6a7296b4f6	Update tests with new filter schema	2024-08-21 17:24:47 -07:00
Eggbertx	83bc642674	Update init SQL files and schema diagram now that the wordfilter table is no longer necessary	2024-08-12 12:31:12 -07:00
Eggbertx	e812ef0b0a	Add stuff to migrate wordfilters to filter tables	2024-08-11 10:12:59 -07:00
Eggbertx	38deb284c0	Add is_active to filter table	2024-08-11 00:01:45 -07:00
Eggbertx	e12b2fb982	Add migration stuff for filter tables	2024-08-10 20:01:33 -07:00
Eggbertx	c7f15e3d25	Fix typo in sql init files	2024-08-10 17:56:09 -07:00
Eggbertx	6b3d8e8aeb	Start adding filter mgmt page and some more ERD updates	2024-08-10 01:14:21 -07:00
Eggbertx	a0fa938669	re-add wordfilter table (with board table) to ERD	2024-08-09 23:26:05 -07:00
Eggbertx	269efd40d0	Update ERD with planned filter diagram updates	2024-08-09 21:44:42 -07:00
Eggbertx	3d6ca6db45	update database relationship diagram	2024-08-09 20:57:28 -07:00
Eggbertx	75fd0bd668	Add fingerprinting attributes, update ERD	2024-02-12 13:38:17 -08:00
Eggbertx	1deec0e462	Add country and flag columns to DB version 3 schema	2024-01-12 15:51:05 -08:00
Eggbertx	121959fa15	Convert DBPREFIXposts.ip and DBPREFIXreports.ip to VARBINARY	2024-01-01 13:30:32 -08:00