MultipleUserLoginSystem/MySQL_HELP.txt at main · VivekJGupta/MultipleUserLoginSystem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27


MariaDB [vivek]> desc reset_table;
+---------+----------+------+-----+-------------------+----------------+
| Field   | Type     | Null | Key | Default           | Extra          |
+---------+----------+------+-----+-------------------+----------------+
| id      | int(11)  | NO   | PRI | NULL              | auto_increment |
| email   | text     | NO   |     | NULL              |                |
| token   | text     | NO   |     | NULL              |                |
| expdate | datetime | NO   |     | CURRENT_TIMESTAMP |                |
+---------+----------+------+-----+-------------------+----------------+


MariaDB [vivek]> desc users;
+------------+--------------+------+-----+-------------------+----------------+
| Field      | Type         | Null | Key | Default           | Extra          |
+------------+--------------+------+-----+-------------------+----------------+
| id         | int(11)      | NO   | PRI | NULL              | auto_increment |
| created_at | datetime     | YES  |     | CURRENT_TIMESTAMP |                |
| NAME       | varchar(100) | YES  |     | NULL              |                |
| email      | varchar(100) | YES  | UNI | NULL              |                |
| PASSWORD   | varchar(20)  | YES  |     | NULL              |                |
| city       | varchar(50)  | YES  |     | NULL              |                |
| state      | varchar(50)  | YES  |     | NULL              |                |
+------------+--------------+------+-----+-------------------+----------------+