Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 863124 Details for
Bug 1053351
script to migrate data from bz db to hwcert db for public veiw
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
sql queries to make db shema changes for public view
public_view_schema.sql (text/plain), 621 bytes, created by
Tony Fu
on 2014-02-14 06:43:44 UTC
(
hide
)
Description:
sql queries to make db shema changes for public view
Filename:
MIME Type:
Creator:
Tony Fu
Created:
2014-02-14 06:43:44 UTC
Size:
621 bytes
patch
obsolete
>ALTER TABLE cert_records > ADD COLUMN spec_url text, > ADD COLUMN product int(6) default null, > ADD COLUMN version int(6) default null, > ADD COLUMN minor_version varchar(255) default null, > ADD COLUMN platforms varchar(255) default null, > ADD COLUMN cert_status varchar(255) default null, > ADD COLUMN category varchar(255) default null, > ADD COLUMN is_public boolean default 0; > >CREATE TABLE products ( > id int(6) not null AUTO_INCREMENT PRIMARY KEY, > name varchar(64) not null >); > >CREATE TABLE versions ( > id int(6) not null AUTO_INCREMENT PRIMARY KEY, > name varchar(64) not null >); > >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=863124">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 1053351
:
862684
|
863033
|
863035
| 863124