Home

DB Schemas and Discussion

The devices table already exists (Ray created it).

mysql> describe devices;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| ID    | int(11)      | NO   | PRI | NULL    | auto_increment |
| Name  | varchar(100) | NO   |     | NULL    |                |
+-------+--------------+------+-----+---------+----------------+