diff options
Diffstat (limited to 'src/main/resources')
| -rw-r--r-- | src/main/resources/schema-h2.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql index 423fc375..c1b398bd 100644 --- a/src/main/resources/schema-h2.sql +++ b/src/main/resources/schema-h2.sql @@ -1,9 +1,10 @@ SET DB_CLOSE_ON_EXIT TRUE; +SET MODE=MYSQL; CREATE TABLE IF NOT EXISTS `android` ( `user_id` int(10) unsigned NOT NULL, `regid` char(255) NOT NULL, - `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS `auth` ( `user_id` int(10) unsigned NOT NULL, @@ -13,7 +14,7 @@ CREATE TABLE IF NOT EXISTS `auth` ( ); CREATE TABLE IF NOT EXISTS `bl_tags` ( `user_id` int(10) unsigned NOT NULL, - `tag_id` int(10) unsigned NOT NULL, + `tag_id` int(10) unsigned NOT NULL ); CREATE TABLE IF NOT EXISTS `bl_users` ( `user_id` int(10) unsigned NOT NULL, |