nextcloud / circles

👪 Create groups with other users on a Nextcloud instance and share with them
GNU Affero General Public License v3.0
144 stars 47 forks source link

migrating custom groups #1685

Open ArtificialOwl opened 3 weeks ago

ArtificialOwl commented 3 weeks ago

migrate owncloud's Custom Groups to Teams

for each Custom Group (CG):

original data

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| group_id     | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| uri          | varchar(255)        | NO   | UNI | NULL    |                |
| display_name | varchar(64)         | NO   |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

+----------+---------------------+------+-----+---------+-------+
| Field    | Type                | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| group_id | bigint(20) unsigned | NO   | PRI | NULL    |       |
| user_id  | varchar(64)         | NO   | PRI | NULL    |       |
| role     | int(11)             | NO   |     | 0       |       |
+----------+---------------------+------+-----+---------+-------+