export const sales = mysqlTable("Sales", {
id: int("id").autoincrement().notNull(),
startingDate: datetime("starting_date", { mode: 'string'}).notNull(),
expirationDate: datetime("expiration_date", { mode: 'string'}),
bundleId: int("BundleId").references(() => bundles.id, { onDelete: "set null", onUpdate: "cascade" } ),
},
(table) => {
return {
bundleId: index("BundleId").on(table.bundleId),
salesId: primaryKey(table.id),
}
});
export const bundles = mysqlTable("Bundles", {
id: int("id").autoincrement().notNull(),
amount: float("amount").notNull(),
name: varchar("name", { length: 255 }),
},
(table) => {
return {
bundlesId: primaryKey(table.id),
}
});
export const sales = mysqlTable("Sales", {
id: int("id").autoincrement().notNull(),
startingDate: datetime("starting_date", { mode: 'string'}).notNull(),
expirationDate: datetime("expiration_date", { mode: 'string'}),
bundleId: int("BundleId").references(() => bundles.id, { onDelete: "set null", onUpdate: "cascade" } ),
},
(table) => {
return {
bundleId: index("BundleId").on(table.bundleId),
salesId: primaryKey(table.id),
}
});
export const bundles = mysqlTable("Bundles", {
id: int("id").autoincrement().notNull(),
amount: float("amount").notNull(),
name: varchar("name", { length: 255 }),
},
(table) => {
return {
bundlesId: primaryKey(table.id),
}
});