23 lines
732 B
SQL
23 lines
732 B
SQL
-- SQL to create the cost tracking table
|
|
-- Run this in phpMyAdmin or Local's Adminer tool
|
|
|
|
CREATE TABLE IF NOT EXISTS `wp_wpaw_cost_tracking` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`post_id` bigint(20) NOT NULL,
|
|
`model` varchar(255) NOT NULL,
|
|
`action` varchar(50) NOT NULL,
|
|
`input_tokens` int(11) NOT NULL,
|
|
`output_tokens` int(11) NOT NULL,
|
|
`cost` decimal(10,6) NOT NULL,
|
|
`created_at` datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `post_id` (`post_id`),
|
|
KEY `created_at` (`created_at`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- Verify table was created
|
|
SHOW TABLES LIKE 'wp_wpaw_cost_tracking';
|
|
|
|
-- Show table structure
|
|
DESCRIBE wp_wpaw_cost_tracking;
|