export const linksVisitor = mysqlTable(
"links_visitor",
{
linkId: varchar("link_id", { length: 24 }).references(() => links.id, {
onDelete: "cascade",
}),
viewedAt: timestamp("viewed_at").defaultNow(),
linkCreator: varchar("link_creator", { length: 255 })
.references(() => user.id, { onDelete: "cascade" })
.notNull(),
ip: varchar("ip", { length: 20 }).notNull(),
},
(self) => ({
pk: primaryKey({
columns: [self.linkId, self.ip],
}),
})
);
export const linksVisitor = mysqlTable(
"links_visitor",
{
linkId: varchar("link_id", { length: 24 }).references(() => links.id, {
onDelete: "cascade",
}),
viewedAt: timestamp("viewed_at").defaultNow(),
linkCreator: varchar("link_creator", { length: 255 })
.references(() => user.id, { onDelete: "cascade" })
.notNull(),
ip: varchar("ip", { length: 20 }).notNull(),
},
(self) => ({
pk: primaryKey({
columns: [self.linkId, self.ip],
}),
})
);