Page Comparison

1. Tables, Constraints, and Indices
   1. The Tables 0.9.5x.sql file includes a single line statement that defines each table. Some tables that include CLOB columns have tablespace definition that may need to be replaced depending on the name of the tablespaces defined when setting up the database.

   2. Code Block
      language sql title Example Table Create Statement
      CREATE TABLE NOTIFICATIONS ( NOTIFICATION_ID NUMBER(19) NOT NULL, VERSION NUMBER(19) NOT NULL, CREATED_DATE TIMESTAMP(6), LUD TIMESTAMP(6), LUN VARCHAR2(30 CHAR), MESSAGE_TEXT CLOB NOT NULL, MSG_FROM NUMBER(19), MESSAGE_LINK NUMBER(19), MESSAGE_LINK_TYPE VARCHAR2(30 CHAR), MSG_TO NUMBER(19) NOT NULL, MESSAGE_TO_SECTION_LINK NUMBER(19), MESSAGE_TO_SERVICE_LINK NUMBER(19), MESSAGE_TYPE VARCHAR2(30 CHAR) NOT NULL, STATUS VARCHAR2(30 CHAR) NOT NULL ) LOB (MESSAGE_TEXT) STORE AS ( TABLESPACE <b>DATADATA_SMALL</b>SMALL ENABLE STORAGE IN ROW CHUNK 8192 RETENTION); CREATE INDEX NOTIFICATIONS_MSG_FROM_INDEX ON NOTIFICATIONS (MSG_FROM); CREATE INDEX NOTIFICATIONS_MSG_TO_INDEX ON NOTIFICATIONS (MSG_TO); ALTER TABLE NOTIFICATIONS ADD ( PRIMARY KEY (NOTIFICATION_ID) ENABLE VALIDATE); ALTER TABLE NOTIFICATIONS ADD ( CONSTRAINT FK4BD694E880B55DEB FOREIGN KEY (MSG_FROM) REFERENCES EMPLOYEE (EMP_ID) ENABLE VALIDATE, CONSTRAINT FK4BD694E88DBFBC3C FOREIGN KEY (MSG_TO) REFERENCES EMPLOYEE (EMP_ID) ENABLE VALIDATE);

1. SequencesLocalization 

   1. Code Block
      language sql title Example Sequence Statement
      CREATE SEQUENCE SEQ_ACCESSION_COMMENT_ID START WITH 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;

2. Localization
   
   1. Localization is a table of labels and messages used to display dynamically on the rendened web pages by language. The localization script loads up the default set of text which is in English. The "Localization All 0.9.x.sql" file deletes all existing records in the table and resets it for the indicated version.

   2. Code Block
      language sql title Example Localization Statement
      Insert into LOCALIZATION (ID, VERSION, CODE, DATE_CREATED, LAST_UPDATED, LOC, RELEVANCE, TEXT) Values (1464, 0, 'privilege.description.worksheet', TO_TIMESTAMP('8/3/2012 11:10:31.562000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), TO_TIMESTAMP('8/3/2012 11:10:31.562000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), '*', 1, 'Worksheet Screen');

3. Security Roles and Admin User Account
   

Next Step