summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--migrate.sql111
1 files changed, 0 insertions, 111 deletions
diff --git a/migrate.sql b/migrate.sql
deleted file mode 100644
index 1d218b3..0000000
--- a/migrate.sql
+++ /dev/null
@@ -1,111 +0,0 @@
-attach database 'old.db' as old;
-
-pragma foreign_keys = on;
-
-.read tools/sql/schema.txt
-
--- Drop triggers while migrating data:
-drop trigger no_join_on_active_game;
-
-BEGIN;
-
-.read tools/sql/data-300-ew.txt
-.read tools/sql/data-caesar.txt
-.read tools/sql/data-crusader.txt
-.read tools/sql/data-hammer.txt
-.read tools/sql/data-richard.txt
-.read tools/sql/data-tripoli.txt
-
-insert into users
- (user_id,name,mail,notify,password,salt,ctime,about)
-values
- (0, 'Deleted', 'deleted@rally-the-troops.com', 0, '', '', '1970-01-01 00:00:00', 'Deleted user.');
-
--- Users
-
-insert into users (
- user_id,name,mail,notify,password,salt,ctime,about
-) select
- user_id,name,mail,notifications,password,salt,ctime,about
-from old.users;
-
-insert into user_last_seen (
- user_id,atime,aip
-) select
- user_id,atime,aip
-from old.users;
-
-insert into tokens (
- user_id,token,time
-) select
- user_id,token,time
-from old.tokens;
-
--- Messages and Forum
-
-insert into messages (
- message_id,from_id,to_id,time,subject,body,read,deleted_from_inbox,deleted_from_outbox
-) select
- message_id,from_id,to_id,time,subject,body,read,deleted_from_inbox,deleted_from_outbox
-from old.messages;
-
-insert into threads (
- thread_id,author_id,subject,locked
-) select
- thread_id,author_id,subject,locked
-from old.threads;
-
-insert into posts (
- post_id,thread_id,author_id,ctime,mtime,body
-) select
- post_id,thread_id,author_id,ctime,mtime,body
-from old.posts;
-
--- Games
-
-insert into games (
- game_id,title_id,scenario,options,owner_id,ctime,private,random,description,status,result
-) select
- game_id,title_id,scenario,options,owner_id,ctime,private,random,description,status,result
-from old.games;
-
-insert into game_state (
- game_id,mtime,active,state
-) select
- game_id,mtime,active,state
-from old.games;
-
-insert into game_chat (
- game_id,time,user_id,message
-) select
- game_id
- , datetime(json_extract(value,'$[0]')) AS time
- , (select user_id from old.users where name=json_extract(value,'$[1]'))
- , json_extract(value,'$[2]')
-from old.chats, json_each(chat,'$')
-order by time;
-
-insert into game_replay (
- game_id,time,role,action,arguments
-) select
- game_id,time,role,action,arguments
-from old.replay;
-
-insert into players (
- user_id,game_id,role
-) select
- user_id,game_id,role
-from old.players;
-
--- Foo
-
-insert into last_notified (
- game_id,user_id,time
-) select
- game_id,user_id,time
-from old.notifications;
-
-COMMIT;
-
--- re-enable triggers
-.read tools/sql/schema.txt