postgres

var PostgresQueries = []string{
	`CREATE TABLE IF NOT EXISTS Thread(
			Id uuid PRIMARY KEY,
			CreatedAt TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) not null,
			Path varchar(255) not null UNIQUE
		)`,
	`CREATE TABLE IF NOT EXISTS Comment(
			Id uuid PRIMARY KEY,
			ThreadId uuid not null,
			Body text not null,
			Author varchar(255) not null,
			Confirmed bool not null default false,
			CreatedAt TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) not null,
			ReplyTo uuid default null,
			DeletedAt TIMESTAMP(6) NULL,
			FOREIGN KEY(ThreadId) references Thread(Id)
		)`,
}