質問編集履歴
1
create tableの追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -41,3 +41,25 @@
|
|
|
41
41
|
end
|
|
42
42
|
|
|
43
43
|
```
|
|
44
|
+
|
|
45
|
+
create table
|
|
46
|
+
|
|
47
|
+
```
|
|
48
|
+
|
|
49
|
+
sqlite> select * from sqlite_master;
|
|
50
|
+
|
|
51
|
+
table|schema_migrations|schema_migrations|2|CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)
|
|
52
|
+
|
|
53
|
+
index|sqlite_autoindex_schema_migrations_1|schema_migrations|3|
|
|
54
|
+
|
|
55
|
+
table|ar_internal_metadata|ar_internal_metadata|4|CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
|
|
56
|
+
|
|
57
|
+
index|sqlite_autoindex_ar_internal_metadata_1|ar_internal_metadata|5|
|
|
58
|
+
|
|
59
|
+
table|courses|courses|6|CREATE TABLE "courses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "course" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
|
|
60
|
+
|
|
61
|
+
table|sqlite_sequence|sqlite_sequence|7|CREATE TABLE sqlite_sequence(name,seq)
|
|
62
|
+
|
|
63
|
+
table|posts|posts|8|CREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
|
|
64
|
+
|
|
65
|
+
table|faculities|faculities|10|CREATE TABLE "faculities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "dep" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ```
|