[DiscordArchive] do you also plan to include database tables ?
[DiscordArchive] do you also plan to include database tables ?
Original source
I still have never worked on software that uses FK constraints. Usually it's handled at a software level rather than DB level
rektbyfaith
06-29-2023, 10:11 PM #11Archived author: stoneharry • Posted: 2023-06-29T22:11:17.255000+00:00
Original source
I still have never worked on software that uses FK constraints. Usually it's handled at a software level rather than DB level
Original source
-1, 0 or some other strange value. All inside the same dbc
rektbyfaith
06-29-2023, 10:11 PM #12Archived author: Ike • Posted: 2023-06-29T22:11:20.556000+00:00
Original source
-1, 0 or some other strange value. All inside the same dbc
Original source
could be different versions of the tooling, or different functions that set null as 0 or -1
rektbyfaith
06-29-2023, 10:11 PM #13Archived author: Titi • Posted: 2023-06-29T22:11:39.453000+00:00
Original source
could be different versions of the tooling, or different functions that set null as 0 or -1
Original source
Could be
rektbyfaith
06-29-2023, 10:11 PM #14Archived author: Ike • Posted: 2023-06-29T22:11:53.555000+00:00
Original source
Could be
Original source
or -1 is also often unitialised data isn't it ?
rektbyfaith
06-29-2023, 10:12 PM #15Archived author: Titi • Posted: 2023-06-29T22:12:14.592000+00:00
Original source
or -1 is also often unitialised data isn't it ?
Original source
idk if you've seen the light band DBCs, they ahve so much garbage data
rektbyfaith
06-29-2023, 10:12 PM #16Archived author: Titi • Posted: 2023-06-29T22:12:36.701000+00:00
Original source
idk if you've seen the light band DBCs, they ahve so much garbage data
Original source
Yes, they are terrible
rektbyfaith
06-29-2023, 10:13 PM #17Archived author: Ike • Posted: 2023-06-29T22:13:15.164000+00:00
Original source
Yes, they are terrible
Original source
they have this value a lot instead of 0
![[Image: image.png?ex=690c74c0&is=690b2340&hm=997...0226f68ce&]](https://cdn.discordapp.com/attachments/408013572430626817/1124100315973681172/image.png?ex=690c74c0&is=690b2340&hm=997481af40f7cf35273be00daed4c4218bcb7da919c8b1c6c62443f0226f68ce&)
rektbyfaith
06-29-2023, 10:13 PM #18Archived author: Titi • Posted: 2023-06-29T22:13:20.162000+00:00
Original source
they have this value a lot instead of 0
Original source
also if they swap their database definitions from signed to unsigned.. they would then have to change their null if they used -1
rektbyfaith
06-29-2023, 10:14 PM #19Archived author: Titi • Posted: 2023-06-29T22:14:35.654000+00:00
Original source
also if they swap their database definitions from signed to unsigned.. they would then have to change their null if they used -1
Original source
-1 is often stored in unsigned fields (saved as uint max)
all string flags are ignored by the client
-1 can mean not applicable, not defined, or everything.
some DBCs have magic non-standard orders that need to be enforced
there's a lot of fuckery
rektbyfaith
06-29-2023, 10:16 PM #20Archived author: stoneharry • Posted: 2023-06-29T22:16:19.374000+00:00
Original source
-1 is often stored in unsigned fields (saved as uint max)
all string flags are ignored by the client
-1 can mean not applicable, not defined, or everything.
some DBCs have magic non-standard orders that need to be enforced
there's a lot of fuckery
1 Guest(s)
1 Guest(s)