-- OdxAIM  Omnidex Automatic Indexing Manager
 
-- Date Generated:    06/20/05  10:26:38
-- Environment File:          C:\DOCSAMPLES\orders\ssv\orders.env
-- Database Type:             ODBC
-- Omnidex Version:           4.1 Build 5L
-- ODXAIM Version:            1.3.03
 
drop table ODXAIM_ODXREQUESTS
go
 
create table ODXAIM_ODXREQUESTS
      (
        REQUEST_SEQUENCE      integer IDENTITY(1,1),
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        TRANSACTION_DATA      varchar(4000)
      )
go
 
 
drop table ODXAIM_ODXLOG
go
 
create table ODXAIM_ODXLOG
      (
        REQUEST_SEQUENCE      integer,
        EVENT_TIMESTAMP       char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        REQUEST               char(32),
        ERROR_NO              integer,
        ERROR_MSG             char(1024)
      )
go
 
 
drop table ODXAIM_ACTIVITY
go
 
create table ODXAIM_ACTIVITY
      (
        REQ_AUTO_ID           integer IDENTITY(1,1),
        REQUEST_SEQUENCE      integer,
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        CUSTOMER_NO                       integer,
        DATE_TICKLER                      DATETIME,
        TICKLER                           CHAR(2),
        INITIALS                          CHAR(4),
        ACTION_INFO                       VARCHAR(60)
      )
go
 
 
drop trigger ACTIVITY_odx_ins_trg
go
create trigger ACTIVITY_odx_ins_trg
    on ORDERS.dbo.ACTIVITY after insert
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'INSERT',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_ACTIVITY'
            from inserted ins
        insert into ODXAIM_ACTIVITY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_TICKLER,TICKLER,INITIALS,ACTION_INFO)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'INSERT',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.CUSTOMER_NO, ins.DATE_TICKLER,
             ins.TICKLER, ins.INITIALS,
             ins.ACTION_INFO
            from inserted ins
go
 
 
drop trigger ACTIVITY_odx_upd_trg
go
create trigger ACTIVITY_odx_upd_trg
    on ORDERS.dbo.ACTIVITY after update
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'UPDATE',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(del.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_ACTIVITY'
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_ACTIVITY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_TICKLER,TICKLER,INITIALS,ACTION_INFO)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATEOLD',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.CUSTOMER_NO, del.DATE_TICKLER,
             del.TICKLER, del.INITIALS,
             del.ACTION_INFO
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_ACTIVITY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_TICKLER,TICKLER,INITIALS,ACTION_INFO)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATENEW',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.CUSTOMER_NO, ins.DATE_TICKLER,
             ins.TICKLER, ins.INITIALS,
             ins.ACTION_INFO
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
go
 
 
drop trigger ACTIVITY_odx_del_trg
go
create trigger ACTIVITY_odx_del_trg
    on ORDERS.dbo.ACTIVITY after delete
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'DELETE',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_ACTIVITY'
            from deleted del
        insert into ODXAIM_ACTIVITY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_TICKLER,TICKLER,INITIALS,ACTION_INFO)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'DELETE',
            CURRENT_TIMESTAMP,
            'ACTIVITY',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.CUSTOMER_NO, del.DATE_TICKLER,
             del.TICKLER, del.INITIALS,
             del.ACTION_INFO
            from deleted del
go
 
 
drop table ODXAIM_CUST_NOTES
go
 
create table ODXAIM_CUST_NOTES
      (
        REQ_AUTO_ID           integer IDENTITY(1,1),
        REQUEST_SEQUENCE      integer,
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        CUSTOMER_NO                       integer,
        DATE_ENTERED                      DATETIME,
        DESC_LINES                        VARCHAR(350)
      )
go
 
 
drop trigger CUST_NOTES_odx_ins_trg
go
create trigger CUST_NOTES_odx_ins_trg
    on ORDERS.dbo.CUST_NOTES after insert
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'INSERT',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_CUST_NOTES'
            from inserted ins
        insert into ODXAIM_CUST_NOTES
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_ENTERED,DESC_LINES)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'INSERT',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.CUSTOMER_NO, ins.DATE_ENTERED,
             ins.DESC_LINES
            from inserted ins
go
 
 
drop trigger CUST_NOTES_odx_upd_trg
go
create trigger CUST_NOTES_odx_upd_trg
    on ORDERS.dbo.CUST_NOTES after update
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'UPDATE',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(del.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_CUST_NOTES'
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_CUST_NOTES
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_ENTERED,DESC_LINES)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATEOLD',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.CUSTOMER_NO, del.DATE_ENTERED,
             del.DESC_LINES
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_CUST_NOTES
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_ENTERED,DESC_LINES)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATENEW',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.CUSTOMER_NO, ins.DATE_ENTERED,
             ins.DESC_LINES
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
go
 
 
drop trigger CUST_NOTES_odx_del_trg
go
create trigger CUST_NOTES_odx_del_trg
    on ORDERS.dbo.CUST_NOTES after delete
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'DELETE',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_CUST_NOTES'
            from deleted del
        insert into ODXAIM_CUST_NOTES
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,DATE_ENTERED,DESC_LINES)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'DELETE',
            CURRENT_TIMESTAMP,
            'CUST_NOTES',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.CUSTOMER_NO, del.DATE_ENTERED,
             del.DESC_LINES
            from deleted del
go
 
 
drop table ODXAIM_CUSTOMERS
go
 
create table ODXAIM_CUSTOMERS
      (
        REQ_AUTO_ID           integer IDENTITY(1,1),
        REQUEST_SEQUENCE      integer,
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        CUSTOMER_NO                       integer,
        COMPANY                           VARCHAR(40),
        CONTACT                           VARCHAR(24),
        CITY                              VARCHAR(20),
        STATE                             CHAR(2),
        POSTAL_CODE                       VARCHAR(10),
        PHONE_NO                          VARCHAR(18),
        AKA_COMPANY                       VARCHAR(20),
        COMMENTS                          VARCHAR(60)
      )
go
 
 
drop trigger CUSTOMERS_odx_ins_trg
go
create trigger CUSTOMERS_odx_ins_trg
    on ORDERS.dbo.CUSTOMERS after insert
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'INSERT',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
            '$TABLESPEC=ODXAIM_CUSTOMERS'
            from inserted ins
        insert into ODXAIM_CUSTOMERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,COMPANY,CONTACT,CITY,STATE,POSTAL_CODE,PHONE_NO,
             AKA_COMPANY,COMMENTS)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'INSERT',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
             ins.CUSTOMER_NO, ins.COMPANY,
             ins.CONTACT, ins.CITY,
             ins.STATE, ins.POSTAL_CODE,
             ins.PHONE_NO, ins.AKA_COMPANY,
             ins.COMMENTS
            from inserted ins
go
 
 
drop trigger CUSTOMERS_odx_upd_trg
go
create trigger CUSTOMERS_odx_upd_trg
    on ORDERS.dbo.CUSTOMERS after update
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'UPDATE',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
            '$TABLESPEC=ODXAIM_CUSTOMERS'
            from deleted del, inserted ins
        insert into ODXAIM_CUSTOMERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,COMPANY,CONTACT,CITY,STATE,POSTAL_CODE,PHONE_NO,
             AKA_COMPANY,COMMENTS)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATEOLD',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
             del.CUSTOMER_NO, del.COMPANY,
             del.CONTACT, del.CITY,
             del.STATE, del.POSTAL_CODE,
             del.PHONE_NO, del.AKA_COMPANY,
             del.COMMENTS
            from deleted del, inserted ins
        insert into ODXAIM_CUSTOMERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,COMPANY,CONTACT,CITY,STATE,POSTAL_CODE,PHONE_NO,
             AKA_COMPANY,COMMENTS)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATENEW',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
             ins.CUSTOMER_NO, ins.COMPANY,
             ins.CONTACT, ins.CITY,
             ins.STATE, ins.POSTAL_CODE,
             ins.PHONE_NO, ins.AKA_COMPANY,
             ins.COMMENTS
            from deleted del, inserted ins
go
 
 
drop trigger CUSTOMERS_odx_del_trg
go
create trigger CUSTOMERS_odx_del_trg
    on ORDERS.dbo.CUSTOMERS after delete
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'DELETE',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
            '$TABLESPEC=ODXAIM_CUSTOMERS'
            from deleted del
        insert into ODXAIM_CUSTOMERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,COMPANY,CONTACT,CITY,STATE,POSTAL_CODE,PHONE_NO,
             AKA_COMPANY,COMMENTS)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'DELETE',
            CURRENT_TIMESTAMP,
            'CUSTOMERS',
            'norowid',
            'norowid',
             del.CUSTOMER_NO, del.COMPANY,
             del.CONTACT, del.CITY,
             del.STATE, del.POSTAL_CODE,
             del.PHONE_NO, del.AKA_COMPANY,
             del.COMMENTS
            from deleted del
go
 
 
drop table ODXAIM_INVENTORY
go
 
create table ODXAIM_INVENTORY
      (
        REQ_AUTO_ID           integer IDENTITY(1,1),
        REQUEST_SEQUENCE      integer,
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        PRODUCT_NO                        CHAR(12),
        INV_DATE                          DATETIME,
        INV_QTY                           SMALLINT,
        INV_COST                          integer,
        INV_LOC                           VARCHAR(16)
      )
go
 
 
drop trigger INVENTORY_odx_ins_trg
go
create trigger INVENTORY_odx_ins_trg
    on ORDERS.dbo.INVENTORY after insert
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'INSERT',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_INVENTORY'
            from inserted ins
        insert into ODXAIM_INVENTORY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,INV_DATE,INV_QTY,INV_COST,INV_LOC)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'INSERT',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.PRODUCT_NO, ins.INV_DATE,
             ins.INV_QTY, ins.INV_COST,
             ins.INV_LOC
            from inserted ins
go
 
 
drop trigger INVENTORY_odx_upd_trg
go
create trigger INVENTORY_odx_upd_trg
    on ORDERS.dbo.INVENTORY after update
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'UPDATE',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(del.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_INVENTORY'
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_INVENTORY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,INV_DATE,INV_QTY,INV_COST,INV_LOC)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATEOLD',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.PRODUCT_NO, del.INV_DATE,
             del.INV_QTY, del.INV_COST,
             del.INV_LOC
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_INVENTORY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,INV_DATE,INV_QTY,INV_COST,INV_LOC)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATENEW',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.PRODUCT_NO, ins.INV_DATE,
             ins.INV_QTY, ins.INV_COST,
             ins.INV_LOC
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
go
 
 
drop trigger INVENTORY_odx_del_trg
go
create trigger INVENTORY_odx_del_trg
    on ORDERS.dbo.INVENTORY after delete
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'DELETE',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_INVENTORY'
            from deleted del
        insert into ODXAIM_INVENTORY
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,INV_DATE,INV_QTY,INV_COST,INV_LOC)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'DELETE',
            CURRENT_TIMESTAMP,
            'INVENTORY',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.PRODUCT_NO, del.INV_DATE,
             del.INV_QTY, del.INV_COST,
             del.INV_LOC
            from deleted del
go
 
 
drop table ODXAIM_ORDERS
go
 
create table ODXAIM_ORDERS
      (
        REQ_AUTO_ID           integer IDENTITY(1,1),
        REQUEST_SEQUENCE      integer,
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        CUSTOMER_NO                       integer,
        PRODUCT_NO                        CHAR(12),
        ORDER_DATE                        DATETIME,
        STATUS                            CHAR(4),
        QUANTITY                          integer,
        AMOUNT                            integer
      )
go
 
 
drop trigger ORDERS_odx_ins_trg
go
create trigger ORDERS_odx_ins_trg
    on ORDERS.dbo.ORDERS after insert
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'INSERT',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_ORDERS'
            from inserted ins
        insert into ODXAIM_ORDERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,PRODUCT_NO,ORDER_DATE,STATUS,QUANTITY,AMOUNT)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'INSERT',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.CUSTOMER_NO, ins.PRODUCT_NO,
             ins.ORDER_DATE, ins.STATUS,
             ins.QUANTITY, ins.AMOUNT
            from inserted ins
go
 
 
drop trigger ORDERS_odx_upd_trg
go
create trigger ORDERS_odx_upd_trg
    on ORDERS.dbo.ORDERS after update
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'UPDATE',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(del.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_ORDERS'
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_ORDERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,PRODUCT_NO,ORDER_DATE,STATUS,QUANTITY,AMOUNT)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATEOLD',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.CUSTOMER_NO, del.PRODUCT_NO,
             del.ORDER_DATE, del.STATUS,
             del.QUANTITY, del.AMOUNT
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
        insert into ODXAIM_ORDERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,PRODUCT_NO,ORDER_DATE,STATUS,QUANTITY,AMOUNT)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATENEW',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(ins.REDEF_ROWID),
            STR(ins.REDEF_ROWID),
             ins.CUSTOMER_NO, ins.PRODUCT_NO,
             ins.ORDER_DATE, ins.STATUS,
             ins.QUANTITY, ins.AMOUNT
            from deleted del, inserted ins
            where del.REDEF_ROWID=ins.REDEF_ROWID
go
 
 
drop trigger ORDERS_odx_del_trg
go
create trigger ORDERS_odx_del_trg
    on ORDERS.dbo.ORDERS after delete
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'DELETE',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
            '$TABLESPEC=ODXAIM_ORDERS'
            from deleted del
        insert into ODXAIM_ORDERS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             CUSTOMER_NO,PRODUCT_NO,ORDER_DATE,STATUS,QUANTITY,AMOUNT)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'DELETE',
            CURRENT_TIMESTAMP,
            'ORDERS',
            STR(del.REDEF_ROWID),
            STR(del.REDEF_ROWID),
             del.CUSTOMER_NO, del.PRODUCT_NO,
             del.ORDER_DATE, del.STATUS,
             del.QUANTITY, del.AMOUNT
            from deleted del
go
 
 
drop table ODXAIM_PRODUCTS
go
 
create table ODXAIM_PRODUCTS
      (
        REQ_AUTO_ID           integer IDENTITY(1,1),
        REQUEST_SEQUENCE      integer,
        REQUEST               char(32),
        REQUEST_TIMESTAMP     char(32),
        TABLENAME             char(32),
        NATIVE_ROWID          char(32),
        NEW_NATIVE_ROWID      char(32),
        PRODUCT_NO                        CHAR(12),
        PRODUCT_CLASS                     VARCHAR(20),
        PRODUCT_NAME                      VARCHAR(40),
        SALES_PRICE                       integer,
        PRODUCT_COST                      integer
      )
go
 
 
drop trigger PRODUCTS_odx_ins_trg
go
create trigger PRODUCTS_odx_ins_trg
    on ORDERS.dbo.PRODUCTS after insert
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'INSERT',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
            '$TABLESPEC=ODXAIM_PRODUCTS'
            from inserted ins
        insert into ODXAIM_PRODUCTS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,PRODUCT_CLASS,PRODUCT_NAME,SALES_PRICE,PRODUCT_COST)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'INSERT',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
             ins.PRODUCT_NO, ins.PRODUCT_CLASS,
             ins.PRODUCT_NAME, ins.SALES_PRICE,
             ins.PRODUCT_COST
            from inserted ins
go
 
 
drop trigger PRODUCTS_odx_upd_trg
go
create trigger PRODUCTS_odx_upd_trg
    on ORDERS.dbo.PRODUCTS after update
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'UPDATE',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
            '$TABLESPEC=ODXAIM_PRODUCTS'
            from deleted del, inserted ins
        insert into ODXAIM_PRODUCTS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,PRODUCT_CLASS,PRODUCT_NAME,SALES_PRICE,PRODUCT_COST)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATEOLD',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
             del.PRODUCT_NO, del.PRODUCT_CLASS,
             del.PRODUCT_NAME, del.SALES_PRICE,
             del.PRODUCT_COST
            from deleted del, inserted ins
        insert into ODXAIM_PRODUCTS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,PRODUCT_CLASS,PRODUCT_NAME,SALES_PRICE,PRODUCT_COST)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'UPDATENEW',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
             ins.PRODUCT_NO, ins.PRODUCT_CLASS,
             ins.PRODUCT_NAME, ins.SALES_PRICE,
             ins.PRODUCT_COST
            from deleted del, inserted ins
go
 
 
drop trigger PRODUCTS_odx_del_trg
go
create trigger PRODUCTS_odx_del_trg
    on ORDERS.dbo.PRODUCTS after delete
-- Omnidex OdxAim Generated Trigger 06/20/2005
-- OdxAim Version: 1.3.03
        as
        insert into ODXAIM_ODXREQUESTS
            (REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, TRANSACTION_DATA)
            SELECT
            'DELETE',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
            '$TABLESPEC=ODXAIM_PRODUCTS'
            from deleted del
        insert into ODXAIM_PRODUCTS
            (REQUEST_SEQUENCE, REQUEST, REQUEST_TIMESTAMP, TABLENAME,
             NATIVE_ROWID, NEW_NATIVE_ROWID, 
             PRODUCT_NO,PRODUCT_CLASS,PRODUCT_NAME,SALES_PRICE,PRODUCT_COST)
            SELECT
            IDENT_CURRENT('ODXAIM_ODXREQUESTS'),
            'DELETE',
            CURRENT_TIMESTAMP,
            'PRODUCTS',
            'norowid',
            'norowid',
             del.PRODUCT_NO, del.PRODUCT_CLASS,
             del.PRODUCT_NAME, del.SALES_PRICE,
             del.PRODUCT_COST
            from deleted del
go