smr/src/sql/insert_comment.sql

/*
Add a new comment to a story
*/
INSERT INTO comments(
	postid,
	author,
	isanon,
	comment_text,
	hashedip,
	post_time
) VALUES (
	:postid,
	:authorid,
	:isanon,
	:comment_text,
	'',
	strftime('%s','now')
);
Lots of new documentation * Add a tool that automatically generates parts of a graphviz input from an sql file * Use that tool to generate bits of graphviz input from all the `create_` sql files in `src/` * Copy all those bits of graphviz input togeather to generate diagrams for each table. 2023-08-10 00:28:48 +02:00			`/*`
			`Add a new comment to a story`
			`*/`
Add comments Add comments for each paste, Also add a "Download TXT" button. 2020-08-13 19:59:33 +02:00			`INSERT INTO comments(`
			`postid,`
			`author,`
			`isanon,`
			`comment_text,`
			`hashedip,`
			`post_time`
			`) VALUES (`
			`:postid,`
			`:authorid,`
			`:isanon,`
			`:comment_text,`
			`'',`
			`strftime('%s','now')`
			`);`