#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import sqlite3

conn = sqlite3.connect(r'\\ll\D\xtrssvjj\db\dpd.db')
cursor = conn.cursor()

try:
    cursor.execute("ALTER TABLE ads ADD COLUMN pubsetdt_of_v TEXT")
    print("已添加字段: pubsetdt_of_v")
except Exception as e:
    print(f"添加 pubsetdt_of_v 失败: {e}")

try:
    cursor.execute("ALTER TABLE ads ADD COLUMN pubenddt_of_v TEXT")
    print("已添加字段: pubenddt_of_v")
except Exception as e:
    print(f"添加 pubenddt_of_v 失败: {e}")

conn.commit()
conn.close()
print("完成!")