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

[atimathong]

Latest SQL Database file (4/11/22)

online-auction.sql.zip

[peteryu6688]

online-auction.sql.zip Newest sql file with added picture names.

[peteryu6688]

online-auction.sql.zip Have changed the picture file of two items (Self-Design Thank you card and Pride and Prejudice). Changing the extension from jpeg to jpg so the pictures could be displayed properly on our auction website.

[peteryu6688]

online-auction.sql.zip Added a watchlist_delete table. Needed to print out the name of the item to show which item has been deleted from the list.

[peteryu6688]

online-auction.sql.zip Added some new testing data. Added new view_times column to view_history table.

[atimathong]

Latest Version of DB (14/11/12)

online-auction.sql.zip

[atimathong]

Latest Version of DB (2/2/2022)

online-auction.sql.zip