Database from phpMyAdmin

[atimathong]

@c20chin @yly828 @peteryu6688 @atimathong

We can keep updating the .sql file and post it here in this issue.

[atimathong]

Users database

users.sql.zip

[peteryu6688]

onlineuser.sql.zip

[peteryu6688]

Updated sql script.
onlineuser.sql.zip

[yly828]

items.sql.zip

[yly828]

Update: SQL file with all items
item (1).sql.zip

[c20chin]

Updated sql script. onlineuser.sql.zip

This file Peter uploaded is incompatible with with the original file that Atima uploaded, please delete it or update it based on Atima's file.
When I run the code with this file, the data cannot write in.

[atimathong]

Category Table

category.sql.zip

1. CategoryID (PK) (FK in items table)
2. Category

[peteryu6688]

1. Bidding Table
2. View History Table
3. Watchlist Table

bidding.sql.zip
view_history.sql.zip
watchlist.sql.zip

[peteryu6688]

Added three furniture items. Added a foreign key for the item table which links to the category table Atima created. (category_ID (FK))
item-4.sql.zip

[yly828]

Update: removed the category column from the item table
item table_category_removed.sql.zip

[c20chin]

description -> pro_desc
condition-> cond
start_date -> sta_date

item (1).sql.zip