Tables

UC_PLUGINSPRO_LICENSE

The table stores information about plug-ins pro licenses activated.

Column Name	Data Type	Nullable	Default	Primary Key
PLUGIN	VARCHAR2(250)	No	-	Yes
API_KEY	VARCHAR2(250)	Yes	-	-
LICENSE_KEY	VARCHAR2(500)	Yes	-	-
CUST_KEY	VARCHAR2(250)	Yes	-	-
CREATED_ON	DATE	No	sysdate	-
VALID_TILL	DATE	Yes	-	-

None

None

UC_FROALA_SAMPLE_BLOBS

The table stores uploaded images using the plug-in RESTful service.

Column Name	Data Type	Nullable	Default	Primary Key
ID	NUMBER	No	-	Yes
FILE_NAME	VARCHAR2(4000)	No	-	-
FILE_MIMETYPE	VARCHAR2(4000)	No	-	-
FILE_CONTENT	BLOB	No	-	-
SESSION_ID	VARCHAR2(4000)	Yes	-	-
STATIC_ID	VARCHAR2(4000)	Yes	-	-
FOLDER	VARCHAR2(4000)	Yes	-	-

CREATE SEQUENCE   "UC_FROALA_SAMPLE_BLOBS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 29413 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
/

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_UC_FROALA_SAMPLE_BLOBS"
  before insert on "UC_FROALA_SAMPLE_BLOBS"
  for each row
begin
  if :NEW."ID" is null then
    select "UC_FROALA_SAMPLE_BLOBS_SEQ".nextval into :NEW."ID" from sys.dual;
  end if;
end;

/
ALTER TRIGGER  "BI_UC_FROALA_SAMPLE_BLOBS" ENABLE
/

UC_FROALA_SAMPLE_CLOBS

Column Name	Data Type	Nullable	Default	Primary Key
ID	NUMBER	No	-	Yes
SESSION_ID	NUMBER	No	-	-
CLOB_CONTENT	CLOB	Yes	-	-
STATIC_ID	VARCHAR2(4000)	Yes	-	-
DESCRIPTION	VARCHAR2(4000)	Yes	-	-

CREATE SEQUENCE   "UC_FROALA_SAMPLE_CLOBS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 11778 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
/

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_UC_FROALA_SAMPLE_CLOBS"
  before insert on "UC_FROALA_SAMPLE_CLOBS"
  for each row
begin
  if :NEW."ID" is null then
    select "UC_FROALA_SAMPLE_CLOBS_SEQ".nextval into :NEW."ID" from sys.dual;
  end if;
end;


/
ALTER TRIGGER  "BI_UC_FROALA_SAMPLE_CLOBS" ENABLE
/

The table stores the sample application CLOB values modified with the plug-in.

UC_FROALA_SAMPLE_CLOB_BLOBS

The table stores uploaded image BLOB content (table UC_FROALA_SAMPLE_BLOBS) in the context of saved rich text document CLOB value (table UC_FROALA_SAMPLE_CLOBS).

Column Name	Data Type	Nullable	Default	Primary Key
ID	NUMBER	No	-	Yes
BLOB_ID	NUMBER	No	-	-
CLOB_ID	NUMBER	No	-	-
IMAGE_URL	VARCHAR2(4000)	No	-	-

CREATE SEQUENCE   "UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 621 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_UC_FROALA_SAMPLE_CLOB_BLOBS"
  before insert on "UC_FROALA_SAMPLE_CLOB_BLOBS"
  for each row
begin
  if :NEW."ID" is null then
    select "UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ".nextval into :NEW."ID" from sys.dual;
  end if;
end;

/
ALTER TRIGGER  "BI_UC_FROALA_SAMPLE_CLOB_BLOBS" ENABLE
/