SHOW:
|
|
- or go back to the newest paste.
| 1 | sqlite3 arimaa.db "CREATE TABLE game (id NUMERIC, wplayerid NUMERIC, bplayerid NUMERIC, wusername TEXT, busername TEXT, wtitle TEXT, btitle TEXT, wcountry TEXT, bcountry TEXT, wrating NUMERIC, brating NUMERIC, wratingk NUMERIC, bratingk NUMERIC, wtype TEXT, btype TEXT, event TEXT, site TEXT, timecontrol TEXT, postal TEXT, startts NUMERIC, endts NUMERIC, result TEXT, termination TEXT, plycount NUMERIC, mode TEXT, rated TEXT, corrupt TEXT, movelist TEXT, events TEXT);" | |
| 2 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames2002.txt game" | |
| 3 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames2003.txt game" | |
| 4 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames2004.txt game" | |
| 5 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames2005.txt game" | |
| 6 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200601.txt game" | |
| 7 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200602.txt game" | |
| 8 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200603.txt game" | |
| 9 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200604.txt game" | |
| 10 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200605.txt game" | |
| 11 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200606.txt game" | |
| 12 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200607.txt game" | |
| 13 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200608.txt game" | |
| 14 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200609.txt game" | |
| 15 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200610.txt game" | |
| 16 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200611.txt game" | |
| 17 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200612.txt game" | |
| 18 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200701.txt game" | |
| 19 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200702.txt game" | |
| 20 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200703.txt game" | |
| 21 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200704.txt game" | |
| 22 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200705.txt game" | |
| 23 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200706.txt game" | |
| 24 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200707.txt game" | |
| 25 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200708.txt game" | |
| 26 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200709.txt game" | |
| 27 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200710.txt game" | |
| 28 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200711.txt game" | |
| 29 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200712.txt game" | |
| 30 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200801.txt game" | |
| 31 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200802.txt game" | |
| 32 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200803.txt game" | |
| 33 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200804.txt game" | |
| 34 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200805.txt game" | |
| 35 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200806.txt game" | |
| 36 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200807.txt game" | |
| 37 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200808.txt game" | |
| 38 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200809.txt game" | |
| 39 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200810.txt game" | |
| 40 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200811.txt game" | |
| 41 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200812.txt game" | |
| 42 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200901.txt game" | |
| 43 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200902.txt game" | |
| 44 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200903.txt game" | |
| 45 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200904.txt game" | |
| 46 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200905.txt game" | |
| 47 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200906.txt game" | |
| 48 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200907.txt game" | |
| 49 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200908.txt game" | |
| 50 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200909.txt game" | |
| 51 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200910.txt game" | |
| 52 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200911.txt game" | |
| 53 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames200912.txt game" | |
| 54 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201001.txt game" | |
| 55 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201002.txt game" | |
| 56 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201003.txt game" | |
| 57 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201004.txt game" | |
| 58 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201005.txt game" | |
| 59 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201006.txt game" | |
| 60 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201007.txt game" | |
| 61 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201008.txt game" | |
| 62 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201009.txt game" | |
| 63 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201010.txt game" | |
| 64 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201011.txt game" | |
| 65 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201012.txt game" | |
| 66 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201101.txt game" | |
| 67 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201102.txt game" | |
| 68 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201103.txt game" | |
| 69 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201104.txt game" | |
| 70 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201105.txt game" | |
| 71 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201106.txt game" | |
| 72 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201107.txt game" | |
| 73 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201108.txt game" | |
| 74 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201109.txt game" | |
| 75 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201110.txt game" | |
| 76 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201111.txt game" | |
| 77 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201112.txt game" | |
| 78 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201201.txt game" | |
| 79 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201202.txt game" | |
| 80 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201203.txt game" | |
| 81 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201204.txt game" | |
| 82 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201205.txt game" | |
| 83 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201206.txt game" | |
| 84 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201207.txt game" | |
| 85 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201208.txt game" | |
| 86 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201209.txt game" | |
| 87 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201210.txt game" | |
| 88 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201211.txt game" | |
| 89 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201212.txt game" | |
| 90 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201301.txt game" | |
| 91 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201302.txt game" | |
| 92 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201303.txt game" | |
| 93 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201304.txt game" | |
| 94 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201305.txt game" | |
| 95 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201306.txt game" | |
| 96 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201307.txt game" | |
| 97 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201308.txt game" | |
| 98 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201309.txt game" | |
| 99 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201310.txt game" | |
| 100 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201311.txt game" | |
| 101 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201312.txt game" | |
| 102 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201401.txt game" | |
| 103 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201402.txt game" | |
| 104 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201403.txt game" | |
| 105 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201404.txt game" | |
| 106 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201405.txt game" | |
| 107 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201406.txt game" | |
| 108 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201407.txt game" | |
| 109 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201408.txt game" | |
| 110 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201409.txt game" | |
| 111 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201410.txt game" | |
| 112 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201411.txt game" | |
| 113 | sqlite3 -separator $'\t' arimaa.db ".import txt/allgames201412.txt game" | |
| 114 | - | sqlite3 arimaa.db "delete from game where id = ''" |
| 114 | + | sqlite3 arimaa.db "delete from game where wtitle <> ''" |
