import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class ApplyWxContactStub {
    private static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas"
            + "?useSSL=false&serverTimezone=GMT%2B8";
    private static final String USER = "root";
    private static final String PWD = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        try (Connection c = DriverManager.getConnection(URL, USER, PWD);
             Statement st = c.createStatement()) {
            st.execute("CREATE TABLE IF NOT EXISTS wx_contact ("
                    + "id BIGINT PRIMARY KEY,"
                    + "user_name VARCHAR(128), nick_name VARCHAR(128), quan_pin VARCHAR(256),"
                    + "sex INT, alias VARCHAR(128), phone VARCHAR(32), head_img_url VARCHAR(512),"
                    + "encrypt_user_name VARCHAR(256), province VARCHAR(64), city VARCHAR(64),"
                    + "account_id BIGINT, company_id BIGINT, company_user_id BIGINT, customer_id BIGINT,"
                    + "friends INT, create_time DATETIME, create_by VARCHAR(64),"
                    + "update_time DATETIME, update_by VARCHAR(64), remark VARCHAR(500)"
                    + ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
            st.execute("INSERT IGNORE INTO wx_contact (id, nick_name, company_id) VALUES (999338052, 'validation-stub', 338)");
            System.out.println("wx_contact stub OK");
        }
    }
}