1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:37, 2 May 2017
, 16:37, 2 May 2017→Patent Number Cleanup
--11577028
ALTER TABLE ptoproperty_app RENAME COLUMN documentid TO appno;
DROP TABLE ptoproperty_pub;
CREATE TABLE ptoproperty_pub AS
SELECT * FROM ptopropertynd WHERE length(documentid) = 11;
--6217864
ALTER TABLE ptoproperty_pub RENAME COLUMN documentid TO pubno;
===Ptotracking Tables===
