Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
linux_wiki:create_a_simple_database_schema [2016/10/08 18:06] billdozor |
linux_wiki:create_a_simple_database_schema [2018/05/20 23:05] billdozor [Create a Database] |
||
---|---|---|---|
Line 10: | Line 10: | ||
The following virtual machines will be used: | The following virtual machines will be used: | ||
- | * server1.example.com (192.168.1.150) -> Perform any client testing | + | * server2.example.com (192.168.1.151) -> Database |
- | * server2.example.com (192.168.1.151) -> Install | + | |
+ | **Previous Section Completed** | ||
+ | * [[linux_wiki: | ||
---- | ---- | ||
Line 71: | Line 73: | ||
Create a new table in the emails database | Create a new table in the emails database | ||
<code bash> | <code bash> | ||
- | MariaDB [emails]> | + | MariaDB [emails]> |
</ | </ | ||
* When you create a table, you must define the names of the columns and the type of data they should contain | * When you create a table, you must define the names of the columns and the type of data they should contain | ||
- | * userID INT -> Named userID and of type integer | + | |
- | * userFirstName char(25) -> Named userFirstName and of type characters up to 25 long | + | |
+ | * AUTO_INCREMENT -> Auto increment the entries in this column | ||
+ | * PRIMARY KEY -> The userid column is the primary sorting key | ||
+ | | ||
+ | * Table Options | ||
+ | * AUTO_INCREMENT = 100 -> Start userid at 100 | ||
\\ | \\ |