search

nguyenhust / genealogy-book-website

1 stars 0 forks source link

Creating the database and it's tables #10

Open nguyenhust opened 4 years ago

nguyenhust commented 4 years ago

Phpmyadmin homepage: localhost/phpmyadmin Go to the Databases tab located on top then from the text box in the middle, type first_db then click on create ext, create another table named list with 7 columns and for the table's structure:

id - INT - N/A - Not Null - Auto Increment details - text - Not null date_posted - varchar - 30 - Not null time_posted - Time - Not null date_edited - varchar - 30 - Not null time_edited - Time - Not null public -varchar - 5 - Not null

image

nguyenhust commented 4 years ago

For the table's structure, make sure to have the following fields then click on save:

Format: Column Name - Type - Length - Null Property - Other Properties id - INT - N/A - Not Null - Auto Increment username - varchar - 50 - Not null password - varchar - 50 - Not null