If your calendar application is already created, we must add the fields
below in the table so that the new functionalities work correctly:

|  |  |
| --- | --- |
| category | int |
| id\_api | varchar(255) |
| id\_event\_google | varchar(255) |
| recur\_info | varchar(255) |
| event\_color | varchar(255) |
| creator | varchar(255) |
| reminder | varchar(255) |

You can change the table structure with the ALTER TABLE function.  
  
**Example in MySQL:**

```
ALTER TABLE table_calendar
ADD COLUMN category int,
ADD COLUMN id_api varchar(255),
ADD COLUMN id_event_google varchar(255),
ADD COLUMN recur_info varchar(255),
ADD COLUMN event_color varchar(255),
ADD COLUMN creator varchar(255),
ADD COLUMN reminder varchar(255)
AFTER period;
```

Next, we must access the Calendar application and update the application fields through the item **Application > Synchronize Table**.  
  
**Now we should only configure the fields added according to the configuration below:**

**Field event\_color**

![](https://scriptcase-suporte.kayako.com/base/media/url/2bJRuvoJGTo4XpxKmRyccHWfsmEbhQbF)

![](https://scriptcase-suporte.kayako.com/base/media/url/wM1wa0iavZfSOkhthkYHBZtev7fjOwB9)

**Field category:**

![](https://scriptcase-suporte.kayako.com/base/media/url/TUFtWyy6uWGFkWmvx442Gzm6Ynxqckik)

![](https://scriptcase-suporte.kayako.com/base/media/url/pCgsHCghs9WSTAWoX6BcWOaAEOSriR1X)

**Field id\_api:**

![](https://scriptcase-suporte.kayako.com/base/media/url/gpkU8Dgdxxex0ilq0nGgw79Iy7aHazFg)

![](https://scriptcase-suporte.kayako.com/base/media/url/XiLzyddi4dfTO2L9eCAArhPtFz71Xr8m)

**Id\_event\_google field:**

**![](https://scriptcase-suporte.kayako.com/base/media/url/CRhvOL45MpREYRPC6hWqDeZ9sQ5jv6DK)**

![](https://scriptcase-suporte.kayako.com/base/media/url/G1ViHsLVaXJGHr2IrpcY8eFWaEahgDFw)

**Field recur\_info:**

![](https://scriptcase-suporte.kayako.com/base/media/url/DtOaWSwYNmq0E0tyMt6u1Jowh4YcFPAP)

![](https://scriptcase-suporte.kayako.com/base/media/url/EsmxdtGY6hSBq9h6CoiSyzSWWo5bAMOw)

**Now we should relate the fields of the table to the fields of the application:**

![](https://scriptcase-suporte.kayako.com/base/media/url/Et2zAsbJk4o3HF6EE4C5l7GUWxK9qHm2)

After that, the application will be ready to work properly with Google Calendar integration.