MySQL query is not properly converted into SQLite query
-
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
),
KEYpost_id
(post_id
),
KEYpost_title
(title
),
KEYgame_id
(game_id
),
KEYteam1
(team1
),
KEYteam2
(team2
),
KEYmatch_status
(match_status
),
KEYdate
(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?
- The topic ‘MySQL query is not properly converted into SQLite query’ is closed to new replies.