9 lines
394 B
SQL
9 lines
394 B
SQL
-- 云账单轻量汇率设置，只维护 USD/CNY。 // Logan.Li
|
|
CREATE TABLE IF NOT EXISTS asset_cloud_billing_settings (
|
|
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
|
usd_cny_rate DECIMAL(12,6) NOT NULL DEFAULT 7.2,
|
|
updated_by VARCHAR(128) NOT NULL DEFAULT '',
|
|
created_at DATETIME NOT NULL,
|
|
updated_at DATETIME NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|