Bug 443563
| Summary: | FEAT: Match the new db schema of bz3.0 [#7 TABLE longdescs] | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Ready Certification Tests | Reporter: | XINSUN <xisun> |
| Component: | web site | Assignee: | XINSUN <xisun> |
| Status: | CLOSED NOTABUG | QA Contact: | Yu Shao <yshao> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 2 | CC: | bxu, dkl, kbaker, nelhawar, rlandry, tfu, xiqin, ykun, yshao |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2008-04-25 02:20:20 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 443456 | ||
Have not tested my above thought After fixed the login issue with Dave's patch, I can do the adding comments
test. It worked well in the hwcert catalog. the db records is below
+--------+--------+---------------------+-----------+---------+-----------+--------------+-----------------+------------+------+------------+
| bug_id | who | bug_when | work_time | thetext | isprivate |
public_in_it | already_wrapped | comment_id | type | extra_data |
+--------+--------+---------------------+-----------+---------+-----------+--------------+-----------------+------------+------+------------+
| 437538 | 215871 | 2008-04-24 09:58:59 | 0.00 | test | 0 |
0 | 0 | 1640574 | 0 | NULL |
+--------+--------+---------------------+-----------+---------+-----------+--------------+-----------------+------------+------+------------+
Maybe. hwcert catalog need to add some more particular codes with the column
"comment_id".Because the comment_id is 0 by default in catalog, while 3.2
bugzilla need the column "comment_id" to update or make private for the
comments. Is that right?
Sorry for my carelessness, Column "Comment_id" is auto_increment. So close this bug as not a bug. |
7.Relate to TABLE longdescs need to change list below: 7.1 New the field already_wrapped,comment_id,type (Not NULL) in the table longdescs (Maybe this place is not necessary to change our codes, because it just impacts the insert the comments and the fields which are defined as Not NULL have the default value in the longdescs table. So just mark it for checking if it will have some more new logic from bz 3.2 with the longdescs. comment_id etc.)