eOne Extender SQL Tables

Each of the tables in this series holds data for a different data type

EXT01200
EXT01201
EXT01203
EXT01211
EXT01212
EXT01213

EXT00900 - Lookup table values
EXT10200 - Lookup Tables
EXT20010 - Window Field Layout
EXT20021 - Item List Values
EXT20110 - Windows
EXT20120 - "Additional" Menu Entries - Check here if you get duplicated menus
EXT20200 - Resource list
EXT20400 - Event List - update the companyid here if restored
EXT20401,2,3 - Event Actions
EXT20500 - Views
EXT20700 - Imports
EXT21000 - Solutions
EXT21010 - Extender Solution Details


When restoring from one company to another, run these scripts to update any company references. Replace "TEST" with your new database id.

 update [EXT20401] set interid = 'TEST'