View Issue Details

IDProjectCategoryView StatusLast Update
0000475CATS.cacert.orgDatabasepublic2021-08-25 13:34
Reporterevaldo Assigned ToTed  
Status needs workResolutionopen 
PlatformDefaultOSanyOS Versionany
Product Versionproduction 
Summary0000475: Improvements on some tables
DescriptionTable user:

We should have an issuer table with a list of our roots, and only the root_id on the user table. This allows for future expansion, and for third-party use. Remember CAcert is going to release its code as open-source.

  `root` set('CA Cert Signing Authority','CAcert Class 3 Root') collate latin1_general_ci NOT NULL default '',
should be changed with a foreign relation to the issuer table.

LANG doesn't always come in 2-letter flavours, for example "pt_BR.ISO8859-1". We are kinda breaking ISO here, which is a bad idea :)
  `lang` char(2) collate latin1_general_ci NOT NULL default '',

Database encoding should be changed to UTF-8 to allow non-ascii-writing people to use the system. Think asia!

Table topics:

numOfQu shouldn't exist like that. we should count() questions for that topic instead. Desyncs are bad!

Table learnprogress:

root -> see table user comments
percentage as decimal(5,0): I wonder who can do 99999.00% of it right ;) decimal with 0 decimal positions is a misuse -> try int ;)

All Tables:

We should use BOOL (BOOLEAN) type instead of enum, to avoid the conversion overhead.

MySQL 5 Reference:

These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true: "
TagsNo tags attached.


related to 0000769 needs workTed Main CAcert Website Client certificate broken with unicode 



2008-01-05 01:02

developer   ~0000988

Bug 0000472 comment 982 reminded me to comment about "Not Null" statements that should be on all collumns on all tables unless there REALLY is a meaning for that collumn being null.


2008-01-05 01:34

developer   ~0000990

Bug 0000465 suggests the lack of unique constraints/indexes needed to eliminate problems with duplicate records automatically


2008-01-09 14:02

developer   ~0000995

>>Table topics:

>>numOfQu shouldn't exist like that. we should count() questions for that topic >>instead. Desyncs are bad!

numOfQu doesn't count the questions of a topic.
Here is stored how many questions a test of this topic has.
Topic 1 : numOfQu=5
Topic1 has 5 questions per test.

Maybe it is named unfortunately.
I think we should rename it.


2008-01-13 20:59

administrator   ~0000998

Last edited: 2008-01-13 21:00

RFC 3046 ( recommends a buffer length of at least 42 characters for language tags.
Since I don't think that this will lead us into storage problem we should adher to this (though I doubt we'll really use even 10 characters).

Werner Dworak

2012-12-29 05:29

updater   ~0003580

At present shelved

Issue History

Date Modified Username Field Change
2008-01-05 00:36 evaldo New Issue
2008-01-05 00:36 evaldo Status new => needs work
2008-01-05 00:36 evaldo Assigned To => Ted
2008-01-05 01:02 evaldo Note Added: 0000988
2008-01-05 01:34 evaldo Note Added: 0000990
2008-01-05 16:32 Ted Assigned To Ted => MichelleStahl
2008-01-09 14:02 MichelleStahl Note Added: 0000995
2008-01-13 20:59 Ted Note Added: 0000998
2008-01-13 21:00 Ted Note Edited: 0000998
2008-01-13 21:00 Ted Note Edited: 0000998
2011-07-18 07:34 Ted Assigned To MichelleStahl => Ted
2012-12-29 05:29 Werner Dworak Note Added: 0003580
2021-08-25 13:34 bdmc Relationship added related to 0000769