[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
A view is a cached select statement, it doesn't store data
rektbyfaith
07-13-2023, 10:16 PM #31Archived author: jackpoz • Posted: 2023-07-13T22:16:48.265000+00:00
Original source
A view is a cached select statement, it doesn't store data
Original source
Check https://github.com/TrinityCore/TrinityCo...fa3011c5dc
[Embed: DB/Misc: Add new View for RBAC · TrinityCore/TrinityCore@46bab72]
https://github.com/TrinityCore/TrinityCo...fa3011c5dc
rektbyfaith
07-13-2023, 10:16 PM #32Archived author: jackpoz • Posted: 2023-07-13T22:16:53.898000+00:00
Original source
Check https://github.com/TrinityCore/TrinityCo...fa3011c5dc
[Embed: DB/Misc: Add new View for RBAC · TrinityCore/TrinityCore@46bab72]
https://github.com/TrinityCore/TrinityCo...fa3011c5dc
Original source
Or https://github.com/TrinityCore/TrinityCo...0_auth.sql
[Embed: TrinityCore/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql at 46bab7...]
TrinityCore Open Source MMO Framework (master = 10.1.0.50000, 3.3.5 = 3.3.5a.12340) - TrinityCore/TrinityCore
https://github.com/TrinityCore/TrinityCo...0_auth.sql
rektbyfaith
07-13-2023, 10:17 PM #33Archived author: jackpoz • Posted: 2023-07-13T22:17:23.389000+00:00
Original source
Or https://github.com/TrinityCore/TrinityCo...0_auth.sql
[Embed: TrinityCore/sql/updates/auth/3.3.5/2021_06_20_00_auth.sql at 46bab7...]
TrinityCore Open Source MMO Framework (master = 10.1.0.50000, 3.3.5 = 3.3.5a.12340) - TrinityCore/TrinityCore
https://github.com/TrinityCore/TrinityCo...0_auth.sql
Original source
That's how a view is defined
rektbyfaith
07-13-2023, 10:17 PM #34Archived author: jackpoz • Posted: 2023-07-13T22:17:33.935000+00:00
Original source
That's how a view is defined
Original source
Then as a user you select on the view, like if it was a table
rektbyfaith
07-13-2023, 10:17 PM #35Archived author: jackpoz • Posted: 2023-07-13T22:17:55.266000+00:00
Original source
Then as a user you select on the view, like if it was a table
Original source
And mysql runs the select statement defined by the view, with all the joins hidden from the user
rektbyfaith
07-13-2023, 10:18 PM #36Archived author: jackpoz • Posted: 2023-07-13T22:18:27.232000+00:00
Original source
And mysql runs the select statement defined by the view, with all the joins hidden from the user
Original source
Which for rbac means users don't need to know how rbac tables are linked together, they can just use the view
rektbyfaith
07-13-2023, 10:19 PM #37Archived author: jackpoz • Posted: 2023-07-13T22:19:04.935000+00:00
Original source
Which for rbac means users don't need to know how rbac tables are linked together, they can just use the view
Original source
You don't update data from a view
rektbyfaith
07-13-2023, 10:19 PM #38Archived author: jackpoz • Posted: 2023-07-13T22:19:21.978000+00:00
Original source
You don't update data from a view
Original source
You don't insert data into a view
rektbyfaith
07-13-2023, 10:19 PM #39Archived author: jackpoz • Posted: 2023-07-13T22:19:37.255000+00:00
Original source
You don't insert data into a view
Original source
https://paste2.org/2HDc1Cg1 jfc
rektbyfaith
07-13-2023, 10:31 PM #40Archived author: Sarjuuk • Posted: 2023-07-13T22:31:08.732000+00:00
Original source
https://paste2.org/2HDc1Cg1 jfc