[DiscordArchive] DB question: Whats up with the `vw_` prefixed tables in the world db. I haven't found any references
[DiscordArchive] DB question: Whats up with the `vw_` prefixed tables in the world db. I haven't found any references
Original source
![[Image: image.png?ex=690c72b5&is=690b2135&hm=fec...92322e840&]](https://cdn.discordapp.com/attachments/376457042392514560/1129171553653887086/image.png?ex=690c72b5&is=690b2135&hm=fecd39864272c0708a7c7580a726745ca136a08b6cedb368bbec2dd92322e840&)
rektbyfaith
07-13-2023, 10:04 PM #11Archived author: jackpoz • Posted: 2023-07-13T22:04:37.484000+00:00
Original source
Original source
This is the sai view
rektbyfaith
07-13-2023, 10:04 PM #12Archived author: jackpoz • Posted: 2023-07-13T22:04:54.025000+00:00
Original source
This is the sai view
Original source
Instead of showing the sai number, it shows the enum text
rektbyfaith
07-13-2023, 10:05 PM #13Archived author: jackpoz • Posted: 2023-07-13T22:05:16.975000+00:00
Original source
Instead of showing the sai number, it shows the enum text
Original source
Everyone checking sai should use this view instead of the tables
rektbyfaith
07-13-2023, 10:06 PM #14Archived author: jackpoz • Posted: 2023-07-13T22:06:24.485000+00:00
Original source
Everyone checking sai should use this view instead of the tables
Original source
isn't that redundant with making the field type an enum?
rektbyfaith
07-13-2023, 10:07 PM #15Archived author: Sarjuuk • Posted: 2023-07-13T22:07:20.353000+00:00
Original source
isn't that redundant with making the field type an enum?
Original source
https://dev.mysql.com/doc/refman/8.0/en/enum.html
rektbyfaith
07-13-2023, 10:07 PM #16Archived author: Sarjuuk • Posted: 2023-07-13T22:07:20.731000+00:00
Original source
https://dev.mysql.com/doc/refman/8.0/en/enum.html
Original source
internally it's a number, you are getting the human readable fulltext. (and the values are limited to valid ones)
rektbyfaith
07-13-2023, 10:08 PM #17Archived author: Sarjuuk • Posted: 2023-07-13T22:08:09.687000+00:00
Original source
internally it's a number, you are getting the human readable fulltext. (and the values are limited to valid ones)
Original source
But the field is not an enum today
rektbyfaith
07-13-2023, 10:09 PM #18Archived author: jackpoz • Posted: 2023-07-13T22:09:05.998000+00:00
Original source
But the field is not an enum today
Original source
no, but it could be tomorrow ;p
rektbyfaith
07-13-2023, 10:09 PM #19Archived author: Sarjuuk • Posted: 2023-07-13T22:09:19.682000+00:00
Original source
no, but it could be tomorrow ;p
Original source
A view is just a select statement exposed as a table
rektbyfaith
07-13-2023, 10:09 PM #20Archived author: jackpoz • Posted: 2023-07-13T22:09:39.214000+00:00
Original source
A view is just a select statement exposed as a table
1 Guest(s)
1 Guest(s)