質問編集履歴
1
sql分の追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -254,5 +254,33 @@
|
|
|
254
254
|
</body>
|
|
255
255
|
</html>
|
|
256
256
|
```
|
|
257
|
+
#作成したテーブル
|
|
258
|
+
```sql
|
|
259
|
+
|
|
260
|
+
--ユーザーテーブル--
|
|
261
|
+
CREATE TABLE IF NOT EXISTS user(
|
|
262
|
+
user_id INTEGER AUTO_INCREMENT,
|
|
263
|
+
user_name VARCHAR(12) NOT NULL,
|
|
264
|
+
PRIMARY KEY(user_id);
|
|
265
|
+
) ENGINE=INNODB DEFAULT CHARSET=utf8;
|
|
266
|
+
|
|
267
|
+
--メッセージテーブル--
|
|
268
|
+
CREATE TABLE IF NOT EXISTS message(
|
|
269
|
+
message_id BIGINT AUTO_INCREMENT NOT NULL,
|
|
270
|
+
sender_user_id INTEGER NOT NULL,
|
|
271
|
+
receiver_user_id INTEGER NOT NULL,
|
|
272
|
+
message_content VARCHAR(300),
|
|
273
|
+
message_time datetime DEFAULT CURRENT_TIMESTAMP,
|
|
274
|
+
PRIMARY KEY(message_id),
|
|
275
|
+
FOREIGN KEY (sender_user_id)
|
|
276
|
+
REFERENCES user(user_id)
|
|
277
|
+
ON DELETE CASCADE,
|
|
278
|
+
FOREIGN KEY (receiver_user_id)
|
|
279
|
+
REFERENCES user(user_id)
|
|
280
|
+
ON DELETE CASCADE
|
|
281
|
+
) ENGINE=INNODB DEFAULT CHARSET=utf8;
|
|
282
|
+
|
|
283
|
+
|
|
284
|
+
```
|
|
257
285
|
#ER図
|
|
258
286
|
|