回答編集履歴
1
Version縛り
test
CHANGED
|
@@ -17,3 +17,91 @@
|
|
|
17
17
|
```
|
|
18
18
|
|
|
19
19
|
で、ご満足いただければ幸いです。
|
|
20
|
+
|
|
21
|
+
|
|
22
|
+
|
|
23
|
+
|
|
24
|
+
|
|
25
|
+
----
|
|
26
|
+
|
|
27
|
+
|
|
28
|
+
|
|
29
|
+
3.13.0 からだそうです。 https://www.sqlite.org/releaselog/3_13_0.html
|
|
30
|
+
|
|
31
|
+
|
|
32
|
+
|
|
33
|
+
El Capitanだと
|
|
34
|
+
|
|
35
|
+
```
|
|
36
|
+
|
|
37
|
+
$ sqlite3 --version
|
|
38
|
+
|
|
39
|
+
3.8.10.2 2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4
|
|
40
|
+
|
|
41
|
+
```
|
|
42
|
+
|
|
43
|
+
のようなで使えないですね。 brew か何かで新しめのものを入れてあげてください
|
|
44
|
+
|
|
45
|
+
|
|
46
|
+
|
|
47
|
+
sierra なら
|
|
48
|
+
|
|
49
|
+
```
|
|
50
|
+
|
|
51
|
+
$ sqlite3 --version
|
|
52
|
+
|
|
53
|
+
3.14.0 2016-07-26 15:17:14 91e811f51e611a37372875e96a4c51bbed2dfdea
|
|
54
|
+
|
|
55
|
+
```
|
|
56
|
+
|
|
57
|
+
なので
|
|
58
|
+
|
|
59
|
+
```
|
|
60
|
+
|
|
61
|
+
sqlite> .schema --indent users
|
|
62
|
+
|
|
63
|
+
CREATE TABLE "users"(
|
|
64
|
+
|
|
65
|
+
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
66
|
+
|
|
67
|
+
"email" varchar DEFAULT '' NOT NULL,
|
|
68
|
+
|
|
69
|
+
"encrypted_password" varchar DEFAULT '' NOT NULL,
|
|
70
|
+
|
|
71
|
+
"reset_password_token" varchar,
|
|
72
|
+
|
|
73
|
+
"reset_password_sent_at" datetime,
|
|
74
|
+
|
|
75
|
+
"remember_created_at" datetime,
|
|
76
|
+
|
|
77
|
+
"sign_in_count" integer DEFAULT 0 NOT NULL,
|
|
78
|
+
|
|
79
|
+
"current_sign_in_at" datetime,
|
|
80
|
+
|
|
81
|
+
"last_sign_in_at" datetime,
|
|
82
|
+
|
|
83
|
+
"current_sign_in_ip" varchar,
|
|
84
|
+
|
|
85
|
+
"last_sign_in_ip" varchar,
|
|
86
|
+
|
|
87
|
+
"created_at" datetime NOT NULL,
|
|
88
|
+
|
|
89
|
+
"updated_at" datetime NOT NULL,
|
|
90
|
+
|
|
91
|
+
"role_id" integer NOT NULL
|
|
92
|
+
|
|
93
|
+
);
|
|
94
|
+
|
|
95
|
+
CREATE UNIQUE INDEX "index_users_on_email" ON "users"("email");
|
|
96
|
+
|
|
97
|
+
CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users"(
|
|
98
|
+
|
|
99
|
+
"reset_password_token"
|
|
100
|
+
|
|
101
|
+
);
|
|
102
|
+
|
|
103
|
+
CREATE INDEX "index_users_on_role_id" ON "users"("role_id");
|
|
104
|
+
|
|
105
|
+
```
|
|
106
|
+
|
|
107
|
+
こんな感じでお望みの感じに近いかと。
|