View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000475 | CATS.cacert.org | Database | public | 2008-01-05 00:36 | 2021-08-25 13:34 |
| Reporter | evaldo | Assigned To | Ted | ||
| Priority | low | Severity | trivial | Reproducibility | always |
| Status | needs work | Resolution | open | ||
| Platform | Default | OS | any | OS Version | any |
| Product Version | production | ||||
| Summary | 0000475: Improvements on some tables | ||||
| Description | Table 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: "BOOL, BOOLEAN These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true: " | ||||
| Tags | No tags attached. | ||||
|
|
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. |
|
|
Bug 0000465 suggests the lack of unique constraints/indexes needed to eliminate problems with duplicate records automatically |
|
|
>>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. p.e. Topic 1 : numOfQu=5 Topic1 has 5 questions per test. Maybe it is named unfortunately. I think we should rename it. |
|
|
RFC 3046 (http://tools.ietf.org/html/rfc4646#section-4.3) 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). |
|
|
At present shelved |
| 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 |
