Created
October 3, 2018 13:49
-
-
Save afarber/d51fb18fe0700c14830a628d981fb17d to your computer and use it in GitHub Desktop.
Despite successful @TypeConverter call: NOT NULL constraint failed: table_games.pile
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"formatVersion": 1, | |
"database": { | |
"version": 1, | |
"identityHash": "b4b5c4981b24b731a84a2c6cd13f8c1a", | |
"entities": [ | |
{ | |
"tableName": "table_config", | |
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`uid` INTEGER NOT NULL, `visited` INTEGER NOT NULL, `banned` TEXT, `vip` TEXT, `grand` TEXT, `elo` INTEGER NOT NULL, `coins` INTEGER NOT NULL, `medals` INTEGER NOT NULL, PRIMARY KEY(`uid`))", | |
"fields": [ | |
{ | |
"fieldPath": "uid", | |
"columnName": "uid", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "visited", | |
"columnName": "visited", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "banned", | |
"columnName": "banned", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "vip", | |
"columnName": "vip", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "grand", | |
"columnName": "grand", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "elo", | |
"columnName": "elo", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "coins", | |
"columnName": "coins", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "medals", | |
"columnName": "medals", | |
"affinity": "INTEGER", | |
"notNull": true | |
} | |
], | |
"primaryKey": { | |
"columnNames": [ | |
"uid" | |
], | |
"autoGenerate": false | |
}, | |
"indices": [], | |
"foreignKeys": [] | |
}, | |
{ | |
"tableName": "table_games", | |
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`gid` INTEGER NOT NULL, `bid` INTEGER NOT NULL, `chat1` INTEGER NOT NULL, `created` INTEGER NOT NULL, `expire1` INTEGER NOT NULL, `expire2` INTEGER NOT NULL, `finished` INTEGER NOT NULL, `pilelen` INTEGER NOT NULL, `played1` INTEGER NOT NULL, `played2` INTEGER NOT NULL, `player1` INTEGER NOT NULL, `player2` INTEGER NOT NULL, `score` INTEGER NOT NULL, `score1` INTEGER NOT NULL, `score2` INTEGER NOT NULL, `given1` TEXT NOT NULL, `given2` TEXT, `hint1` TEXT, `photo1` TEXT, `photo2` TEXT, `reason` TEXT, `state1` TEXT, `hand1` TEXT NOT NULL, `pile` TEXT NOT NULL, `tiles` TEXT NOT NULL, `letters` TEXT NOT NULL, `values` TEXT NOT NULL, PRIMARY KEY(`gid`))", | |
"fields": [ | |
{ | |
"fieldPath": "gid", | |
"columnName": "gid", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "bid", | |
"columnName": "bid", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "chat1", | |
"columnName": "chat1", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "created", | |
"columnName": "created", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "expire1", | |
"columnName": "expire1", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "expire2", | |
"columnName": "expire2", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "finished", | |
"columnName": "finished", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "pilelen", | |
"columnName": "pilelen", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "played1", | |
"columnName": "played1", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "played2", | |
"columnName": "played2", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "player1", | |
"columnName": "player1", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "player2", | |
"columnName": "player2", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "score", | |
"columnName": "score", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "score1", | |
"columnName": "score1", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "score2", | |
"columnName": "score2", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "given1", | |
"columnName": "given1", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "given2", | |
"columnName": "given2", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "hint1", | |
"columnName": "hint1", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "photo1", | |
"columnName": "photo1", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "photo2", | |
"columnName": "photo2", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "reason", | |
"columnName": "reason", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "state1", | |
"columnName": "state1", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "hand1", | |
"columnName": "hand1", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "pile", | |
"columnName": "pile", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "tiles", | |
"columnName": "tiles", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "letters", | |
"columnName": "letters", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "values", | |
"columnName": "values", | |
"affinity": "TEXT", | |
"notNull": true | |
} | |
], | |
"primaryKey": { | |
"columnNames": [ | |
"gid" | |
], | |
"autoGenerate": false | |
}, | |
"indices": [], | |
"foreignKeys": [] | |
}, | |
{ | |
"tableName": "table_social", | |
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`social` INTEGER NOT NULL, `sid` TEXT NOT NULL, `auth` TEXT NOT NULL, `given` TEXT NOT NULL, `family` TEXT, `photo` TEXT, `lat` REAL, `lng` REAL, `stamp` INTEGER NOT NULL, PRIMARY KEY(`social`))", | |
"fields": [ | |
{ | |
"fieldPath": "social", | |
"columnName": "social", | |
"affinity": "INTEGER", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "sid", | |
"columnName": "sid", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "auth", | |
"columnName": "auth", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "given", | |
"columnName": "given", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "family", | |
"columnName": "family", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "photo", | |
"columnName": "photo", | |
"affinity": "TEXT", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "lat", | |
"columnName": "lat", | |
"affinity": "REAL", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "lng", | |
"columnName": "lng", | |
"affinity": "REAL", | |
"notNull": false | |
}, | |
{ | |
"fieldPath": "stamp", | |
"columnName": "stamp", | |
"affinity": "INTEGER", | |
"notNull": true | |
} | |
], | |
"primaryKey": { | |
"columnNames": [ | |
"social" | |
], | |
"autoGenerate": false | |
}, | |
"indices": [], | |
"foreignKeys": [] | |
}, | |
{ | |
"tableName": "table_words", | |
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`word` TEXT NOT NULL, `expl` TEXT, PRIMARY KEY(`word`))", | |
"fields": [ | |
{ | |
"fieldPath": "word", | |
"columnName": "word", | |
"affinity": "TEXT", | |
"notNull": true | |
}, | |
{ | |
"fieldPath": "expl", | |
"columnName": "expl", | |
"affinity": "TEXT", | |
"notNull": false | |
} | |
], | |
"primaryKey": { | |
"columnNames": [ | |
"word" | |
], | |
"autoGenerate": false | |
}, | |
"indices": [], | |
"foreignKeys": [] | |
} | |
], | |
"setupQueries": [ | |
"CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)", | |
"INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"b4b5c4981b24b731a84a2c6cd13f8c1a\")" | |
] | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment