Bug 479950
| Summary: | spacewalk 0.4: new and upgraded schemas do not match | ||
|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Milan Zázrivec <mzazrivec> |
| Component: | Server | Assignee: | Milan Zázrivec <mzazrivec> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
| Severity: | medium | Docs Contact: | |
| Priority: | low | ||
| Version: | 0.4 | CC: | msuchy |
| 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: | 2009-01-22 16:31:42 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: | 456552 | ||
|
Description
Milan Zázrivec
2009-01-14 09:21:49 UTC
Fixes in: 56960dc72bb4130eeb1b40023a031d817cca5962 45e87b034e0f10fb26dd1d3983ca0fe76e7d38b4 New schema version: spacewalk-schema-0.4.16-1 Upgraded spacewalk: SQL> desc rhnKSData Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER ORG_ID NOT NULL NUMBER IS_ORG_DEFAULT NOT NULL CHAR(1) LABEL NOT NULL VARCHAR2(64) COMMENTS VARCHAR2(4000) ACTIVE NOT NULL CHAR(1) POSTLOG NOT NULL CHAR(1) PRE BLOB POST BLOB NOCHROOT_POST BLOB STATIC_DEVICE VARCHAR2(32) KERNEL_PARAMS VARCHAR2(128) CREATED NOT NULL DATE MODIFIED NOT NULL DATE PRELOG NOT NULL CHAR(1) KSCFG NOT NULL CHAR(1) VERBOSEUP2DATE NOT NULL CHAR(1) NONCHROOTPOST NOT NULL CHAR(1) COBBLER_ID VARCHAR2(64) KS_TYPE NOT NULL VARCHAR2(8) SQL> desc rhnPackage Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER ORG_ID NUMBER NAME_ID NOT NULL NUMBER EVR_ID NOT NULL NUMBER PACKAGE_ARCH_ID NOT NULL NUMBER PACKAGE_GROUP NUMBER RPM_VERSION VARCHAR2(16) DESCRIPTION VARCHAR2(4000) SUMMARY VARCHAR2(4000) PACKAGE_SIZE NOT NULL NUMBER PAYLOAD_SIZE NUMBER BUILD_HOST VARCHAR2(256) BUILD_TIME DATE SOURCE_RPM_ID NUMBER MD5SUM NOT NULL VARCHAR2(64) VENDOR NOT NULL VARCHAR2(64) PAYLOAD_FORMAT VARCHAR2(32) COMPAT NUMBER(1) PATH VARCHAR2(1000) HEADER_SIG VARCHAR2(64) COPYRIGHT VARCHAR2(64) COOKIE VARCHAR2(128) LAST_MODIFIED NOT NULL DATE CREATED NOT NULL DATE MODIFIED NOT NULL DATE HEADER_START NOT NULL NUMBER HEADER_END NOT NULL NUMBER Brand new spacewalk: SQL> desc rhnKSData Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER KS_TYPE NOT NULL VARCHAR2(8) ORG_ID NOT NULL NUMBER IS_ORG_DEFAULT NOT NULL CHAR(1) LABEL NOT NULL VARCHAR2(64) COMMENTS VARCHAR2(4000) ACTIVE NOT NULL CHAR(1) POSTLOG NOT NULL CHAR(1) PRELOG NOT NULL CHAR(1) KSCFG NOT NULL CHAR(1) COBBLER_ID VARCHAR2(64) PRE BLOB POST BLOB NOCHROOT_POST BLOB STATIC_DEVICE VARCHAR2(32) KERNEL_PARAMS VARCHAR2(128) VERBOSEUP2DATE NOT NULL CHAR(1) NONCHROOTPOST NOT NULL CHAR(1) CREATED NOT NULL DATE MODIFIED NOT NULL DATE SQL> desc rhnPackage Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER ORG_ID NUMBER NAME_ID NOT NULL NUMBER EVR_ID NOT NULL NUMBER PACKAGE_ARCH_ID NOT NULL NUMBER PACKAGE_GROUP NUMBER RPM_VERSION VARCHAR2(16) DESCRIPTION VARCHAR2(4000) SUMMARY VARCHAR2(4000) PACKAGE_SIZE NOT NULL NUMBER PAYLOAD_SIZE NUMBER BUILD_HOST VARCHAR2(256) BUILD_TIME DATE SOURCE_RPM_ID NUMBER MD5SUM NOT NULL VARCHAR2(64) VENDOR NOT NULL VARCHAR2(64) PAYLOAD_FORMAT VARCHAR2(32) COMPAT NUMBER(1) PATH VARCHAR2(1000) HEADER_SIG VARCHAR2(64) COPYRIGHT VARCHAR2(64) COOKIE VARCHAR2(128) LAST_MODIFIED NOT NULL DATE CREATED NOT NULL DATE MODIFIED NOT NULL DATE HEADER_START NOT NULL NUMBER HEADER_END NOT NULL NUMBER VERIFIED |