-- generator on mysql
select '-- use prj_carleyfoundry_import MYSQL';
select '-- set nocount on; MSSQL';
select
    concat(
        'select \'',
        t.TABLE_NAME,
        '\', count(*) from ',
        t.TABLE_NAME,
        ';'
    )

from INFORMATION_SCHEMA.TABLES t
where t.TABLE_SCHEMA = 'prj_carleyfoundry_import'
order by t.TABLE_NAME;


-- generated on mysql AND mssql
/*
-- use prj_carleyfoundry_import; MYSQL
-- set nocount on; MSSQL
select 'cf_AclResource', count(*) from cf_AclResource;
select 'cf_AclResource2Role', count(*) from cf_AclResource2Role;
select 'cf_AclResourcePrivilege', count(*) from cf_AclResourcePrivilege;
select 'cf_AclRole', count(*) from cf_AclRole;
select 'cf_AclRule', count(*) from cf_AclRule;
select 'cf_Client', count(*) from cf_Client;
select 'cf_Client2User', count(*) from cf_Client2User;
select 'cf_Department', count(*) from cf_Department;
select 'cf_DepartmentAndProcessSorter', count(*) from cf_DepartmentAndProcessSorter;
select 'cf_DPermission', count(*) from cf_DPermission;
select 'cf_DPrivilege', count(*) from cf_DPrivilege;
select 'cf_DResource', count(*) from cf_DResource;
select 'cf_DState', count(*) from cf_DState;
select 'cf_DStatus', count(*) from cf_DStatus;
select 'cf_Form', count(*) from cf_Form;
select 'cf_FormElement', count(*) from cf_FormElement;
select 'cf_FormElementProperty', count(*) from cf_FormElementProperty;
select 'cf_FormElementPropertyValue', count(*) from cf_FormElementPropertyValue;
select 'cf_FormSubmission', count(*) from cf_FormSubmission;
select 'cf_FormSubmissionValue', count(*) from cf_FormSubmissionValue;
select 'cf_Media', count(*) from cf_Media;
select 'cf_Part', count(*) from cf_Part;
select 'cf_Part2PartData', count(*) from cf_Part2PartData;
select 'cf_Part2Process', count(*) from cf_Part2Process;
select 'cf_Part2ProcessData', count(*) from cf_Part2ProcessData;
select 'cf_Part2User', count(*) from cf_Part2User;
select 'cf_PartVersion', count(*) from cf_PartVersion;
select 'cf_Process', count(*) from cf_Process;
select 'cf_Process2User', count(*) from cf_Process2User;
select 'cf_User', count(*) from cf_User;
select 'cf_User2Department', count(*) from cf_User2Department;
select 'cf_User2Permission', count(*) from cf_User2Permission;
select 'cf_zz_Admin', count(*) from cf_zz_Admin;
select 'cf_zz_DFileType', count(*) from cf_zz_DFileType;
select 'cf_zz_DLanguage', count(*) from cf_zz_DLanguage;
select 'cf_zz_DNotFoundMode', count(*) from cf_zz_DNotFoundMode;
select 'cf_zz_DPageHandler', count(*) from cf_zz_DPageHandler;
select 'cf_zz_DPageItemGroup', count(*) from cf_zz_DPageItemGroup;
select 'cf_zz_DPageItemType', count(*) from cf_zz_DPageItemType;
select 'cf_zz_DPageOption', count(*) from cf_zz_DPageOption;
select 'cf_zz_DraftHtmlBlock', count(*) from cf_zz_DraftHtmlBlock;
select 'cf_zz_DraftHtmlBlockContent', count(*) from cf_zz_DraftHtmlBlockContent;
select 'cf_zz_DraftPage', count(*) from cf_zz_DraftPage;
select 'cf_zz_DraftPageContent', count(*) from cf_zz_DraftPageContent;
select 'cf_zz_DraftPageItem', count(*) from cf_zz_DraftPageItem;
select 'cf_zz_DraftPageItemConfig', count(*) from cf_zz_DraftPageItemConfig;
select 'cf_zz_DraftPageOption', count(*) from cf_zz_DraftPageOption;
select 'cf_zz_File', count(*) from cf_zz_File;
select 'cf_zz_HtmlBlock', count(*) from cf_zz_HtmlBlock;
select 'cf_zz_HtmlBlockContent', count(*) from cf_zz_HtmlBlockContent;
select 'cf_zz_Log', count(*) from cf_zz_Log;
select 'cf_zz_NotFound', count(*) from cf_zz_NotFound;
select 'cf_zz_Page', count(*) from cf_zz_Page;
select 'cf_zz_PageContent', count(*) from cf_zz_PageContent;
select 'cf_zz_PageIndex', count(*) from cf_zz_PageIndex;
select 'cf_zz_PageItem', count(*) from cf_zz_PageItem;
select 'cf_zz_PageItemConfig', count(*) from cf_zz_PageItemConfig;
select 'cf_zz_PageOption', count(*) from cf_zz_PageOption;
select 'cf_zz_Redirection', count(*) from cf_zz_Redirection;
select 'cf_zz_Settings', count(*) from cf_zz_Settings;
select 'cf_zz_SettingsCategory', count(*) from cf_zz_SettingsCategory;
select 'cf_zz_SettingsOptions', count(*) from cf_zz_SettingsOptions;
*/