Tables

UC_PLUGINSPRO_LICENSE

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

Columns

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	-	-

Sequence

None

Triggers

None

UC_FROALA_SAMPLE_BLOBS

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

Columns

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	-	-

Sequence

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

Triggers

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

Columns

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	-	-

Sequence

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

Triggers

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).

Columns

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	-	-

Sequence

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

Triggers

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
/