

CREATE TABLE `friends_list` (
  `uuid` varchar(255) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
);

CREATE TABLE `chat_headers` (
  `id` int(11) NOT NULL,
  `chatName` varchar(255) Null,
  `chatName2` varchar(255) Null,
  `lastMsg` varchar(255) Null,
  `type` varchar(255) Null,
  `userId` int(11) Null,
  `userId2` int(11) Null,
  `roomId` int(11) Null,
  `roomId2` int(11) Null,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
);
  
  CREATE TABLE `ping` (
  `id` int(11) NOT NULL,
  `ping_by` int(11) NOT NULL,
  `ping_to` int(11) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL
);

ALTER TABLE `ping`
  ADD PRIMARY KEY (`id`);
  
  ALTER TABLE `ping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  insert into chat_headers (chatName, chatName2, type, userId, userId2,
              createdAt, updatedAt) values ('friendFullName', 'myFullName', 
              'person', '888', '999', CURRENT_DATE(),CURRENT_DATE())
              
              select * from chat_headers

    alter table users add fcm_token varchar(255)