• Resolved Big Boss

    (@andddd)


    I have a following query that breaks:

    CREATE TABLE matches (
    id int(10) unsigned NOT NULL AUTO_INCREMENT,
    title varchar(200) DEFAULT NULL,
    date timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    post_id bigint(20) unsigned DEFAULT NULL,
    team1 int(11) unsigned NOT NULL,
    team2 int(11) unsigned NOT NULL,
    game_id int(11) unsigned NOT NULL,
    match_status tinyint(1) DEFAULT ‘0’,
    description text NOT NULL,
    external_url varchar(200) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY post_id (post_id),
    KEY post_title (title),
    KEY game_id (game_id),
    KEY team1 (team1),
    KEY team2 (team2),
    KEY match_status (match_status),
    KEY date (date)
    );

    Gets converted into:

    CREATE TABLE IF NOT EXISTS wp_cw_matches (
    id integer NOT NULL PRIMARY KEY AUTOINCREMENT ,
    title text DEFAULT NULL,
    date text NULL DEFAULT CURRENT_TIMESTAMP,
    post_id integer DEFAULT NULL,
    team1 integer NOT NULL,
    team2 integer NOT NULL,
    game_id integer NOT NULL,
    match_status integer DEFAULT ‘0’,
    description text NOT NULL,
    external_url text DEFAULT NULL,
    KEY team1 (team1),
    KEY team2 (team2)
    )

    Any thoughts why it breaks and how to fix it?

    https://wordpress.org/plugins/sqlite-integration/

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL query is not properly converted into SQLite query’ is closed to new replies.