text: 
  
  ALTER TABLE ASSET_INFO ADD COLUMN CATEGORY_ID BIGINT;
  ALTER TABLE ASSET_INFO ADD COLUMN SUB_CATEGORY_ID BIGINT;
  ALTER TABLE ASSET_INFO ADD COLUMN MODEL VARCHAR(50);
  ALTER TABLE ASSET_INFO ADD COLUMN PRICE FLOAT;
  ALTER TABLE ASSET_INFO ADD COLUMN BUY_DATE DATE;
  ALTER TABLE ASSET_INFO ADD COLUMN STATUS VARCHAR(50);
  ALTER TABLE ASSET_INFO ADD COLUMN USER_ID VARCHAR(64);
  
  ALTER TABLE ASSET_INFO ADD CONSTRAINT FK_ASSET_INFO_CATEGORY FOREIGN KEY(CATEGORY_ID) REFERENCES ASSET_CATEGORY(ID);
  ALTER TABLE ASSET_INFO ADD CONSTRAINT FK_ASSET_INFO_SUB FOREIGN KEY(SUB_CATEGORY_ID) REFERENCES ASSET_CATEGORY(ID);
  
  