CREATE TABLE `post_products` (
	`id` int AUTO_INCREMENT NOT NULL,
	`post_id` int NOT NULL,
	`product_id` int NOT NULL,
	`created_at` timestamp DEFAULT (now()),
	CONSTRAINT `post_products_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
ALTER TABLE `orders` MODIFY COLUMN `paymentMethod` enum('vnpay','momo','credit_card','installment','cod','bank_transfer') NOT NULL DEFAULT 'cod';--> statement-breakpoint
ALTER TABLE `posts` ADD `category` varchar(100) DEFAULT 'blog';--> statement-breakpoint
ALTER TABLE `staff` ADD `avatar_url` text;