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