1 files changed, 23 insertions, 0 deletions
diff --git a/pkg/model/quote.go b/pkg/model/quote.go
new file mode 100644
index 0000000..0ad89cf
--- /dev/null
+++ b/pkg/model/quote.go
@@ -0,0 +1,23 @@
+package model
+
+import (
+	"strings"
+	"time"
+
+	"github.com/uptrace/bun"
+)
+
+type Quote struct {
+	bun.BaseModel `bun:"table:quotes,alias:q"`
+
+	ID        int64  `bun:",pk,autoincrement"`
+	Quote     string `bun:",notnull"`
+	Approved  bool
+	Archive   bool
+	CreatedAt time.Time `bun:",nullzero,notnull,default:current_timestamp"`
+	DeletedAt time.Time `bun:",soft_delete,nullzero"`
+}
+
+func (q *Quote) Text() string {
+	return strings.ReplaceAll(q.Quote, "\n", "<br />")
+}