Details

      Description

      Querying MySQL's information_schema database we can find those tables without companyId.

      mysql> use information_schema;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      
      Database changed
      mysql> select table_schema, TABLE_NAME from tables where table_name not in (select distinct table_name  from columns  where column_name = 'companyId') and table_schema = 'liferay_master';
      

      The result of that query, with all affected tables, is:

      +----------------+--------------------------------+
      | table_schema   | TABLE_NAME                     |
      +----------------+--------------------------------+
      | liferay_master | announcementsflag              |
      | liferay_master | assetentries_assetcategories   |
      | liferay_master | assetentries_assettags         |
      | liferay_master | assettagstats                  |
      | liferay_master | browsertracker                 |
      | liferay_master | classname_                     |
      | liferay_master | clustergroup                   |
      | liferay_master | counter                        |
      | liferay_master | country                        |
      | liferay_master | cyrususer                      |
      | liferay_master | cyrusvirtual                   |
      | liferay_master | ddmstoragelink                 |
      | liferay_master | ddmstructurelink               |
      | liferay_master | ddmtemplatelink                |
      | liferay_master | dlfileentrymetadata            |
      | liferay_master | dlfileentrytypes_dlfolders     |
      | liferay_master | dlsyncevent                    |
      | liferay_master | groups_orgs                    |
      | liferay_master | groups_roles                   |
      | liferay_master | groups_usergroups              |
      | liferay_master | image                          |
      | liferay_master | journalarticleimage            |
      | liferay_master | journalarticleresource         |
      | liferay_master | listtype                       |
      | liferay_master | marketplace_module             |
      | liferay_master | mbstatsuser                    |
      | liferay_master | orggrouprole                   |
      | liferay_master | orglabor                       |
      | liferay_master | passwordpolicyrel              |
      | liferay_master | passwordtracker                |
      | liferay_master | portalpreferences              |
      | liferay_master | portletpreferences             |
      | liferay_master | quartz_blob_triggers           |
      | liferay_master | quartz_calendars               |
      | liferay_master | quartz_cron_triggers           |
      | liferay_master | quartz_fired_triggers          |
      | liferay_master | quartz_job_details             |
      | liferay_master | quartz_locks                   |
      | liferay_master | quartz_paused_trigger_grps     |
      | liferay_master | quartz_scheduler_state         |
      | liferay_master | quartz_simple_triggers         |
      | liferay_master | quartz_simprop_triggers        |
      | liferay_master | quartz_triggers                |
      | liferay_master | ratingsstats                   |
      | liferay_master | region                         |
      | liferay_master | release_                       |
      | liferay_master | resourceaction                 |
      | liferay_master | resourceblockpermission        |
      | liferay_master | scframeworkversi_scproductvers |
      | liferay_master | sclicense                      |
      | liferay_master | sclicenses_scproductentries    |
      | liferay_master | servicecomponent               |
      | liferay_master | shoppingitemfield              |
      | liferay_master | shoppingitemprice              |
      | liferay_master | shoppingorderitem              |
      | liferay_master | trashversion                   |
      | liferay_master | usergroupgrouprole             |
      | liferay_master | usergrouprole                  |
      | liferay_master | usergroups_teams               |
      | liferay_master | useridmapper                   |
      | liferay_master | users_groups                   |
      | liferay_master | users_orgs                     |
      | liferay_master | users_roles                    |
      | liferay_master | users_teams                    |
      | liferay_master | users_usergroups               |
      | liferay_master | usertrackerpath                |
      | liferay_master | wikipageresource               |
      +----------------+--------------------------------+
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              shuyang.zhou Shuyang Zhou
              Reporter:
              david.truong David Truong
              Recent user:
              Minhchau Dang
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 49 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.0 Alpha 2