search

kpamela / SOEN343

https://tecmarket.herokuapp.com/
2 stars 0 forks source link

Purchase History TDG #106

Closed kpamela closed 6 years ago

Raph1105 commented 6 years ago

@kpamela Do you need other queries ?

kpamela commented 6 years ago

Not for now, but I do need to add a column IsReturned which is a boolean and change UserID to Username in the history table

Raph1105 commented 6 years ago

Ok !! I'll do that right now

CharlesPhilippeLabbe commented 6 years ago

while you're at it can you change the timestamp to a Long, I like working with time in millis... if not ...well that's fine too

Raph1105 commented 6 years ago

What do you mean as Long ? Because apparently I can't change it for long... I can only change for double or float.

CharlesPhilippeLabbe commented 6 years ago

Found [this]( https://www.google.ca/search?client=safari&rls=en&q=Date.now()&ie=UTF-8&oe=UTF-8&gfe_rd=cr&dcr=0&ei=pO8BWqoxqOzwB9yutYgP) which means that doubles is the way to go

Raph1105 commented 6 years ago
capture d ecran 2017-11-07 a 12 47 39
Raph1105 commented 6 years ago

It's done !

CharlesPhilippeLabbe commented 6 years ago

hmm any reasons why the username is an integer?

Raph1105 commented 6 years ago

ah haha it was for UderID my bad ! changing it

Raph1105 commented 6 years ago

Do I just delete UserID from every table and point them to Username ?

CharlesPhilippeLabbe commented 6 years ago

You might as well, we are not using them