public inbox for [email protected]
 help / color / mirror / Atom feed
From: Muhammad Rizki <[email protected]>
To: Ammar Faizi <[email protected]>
Cc: Muhammad Rizki <[email protected]>,
	GNU/Weeb Mailing List <[email protected]>,
	Alviro Iskandar Setiawan <[email protected]>
Subject: [PATCH v5 01/19] Add new table for atom URLs and broadcast chats in db.sql
Date: Mon,  1 Aug 2022 07:18:59 +0700	[thread overview]
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

Just add new table for atom URLs and broadcast chats in db.sql to save
them in MySQL database.

Signed-off-by: Muhammad Rizki <[email protected]>
---
 daemon/db.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

diff --git a/daemon/db.sql b/daemon/db.sql
index 0e4841a..ac6ed0d 100644
--- a/daemon/db.sql
+++ b/daemon/db.sql
@@ -34,4 +34,29 @@ CREATE TABLE `tg_emails` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 
 
+DROP TABLE IF EXISTS `atom_urls`;
+CREATE TABLE `atom_urls` (
+  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
+  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
+  `created_at` datetime NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `url` (`url`),
+  KEY `created_at` (`created_at`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
+
+
+DROP TABLE IF EXISTS `broadcast_chats`;
+CREATE TABLE `broadcast_chats` (
+  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
+  `chat_id` bigint NOT NULL,
+  `username` varchar(32),
+  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
+  `type` varchar(32) NOT NULL,
+  `link` varchar(64),
+  `created_at` datetime NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `chat_id` (`chat_id`),
+  KEY `created_at` (`created_at`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
+
 -- 2022-07-07 14:25:28
-- 
Muhammad Rizki


  reply	other threads:[~2022-08-01  0:19 UTC|newest]

Thread overview: 26+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2022-08-01  0:18 [PATCH v5 00/19] New feature to handle atom URLs and broadcast Muhammad Rizki
2022-08-01  0:18 ` Muhammad Rizki [this message]
2022-08-01  0:19 ` [PATCH v5 02/19] Add a comment in .gitignore Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 03/19] Add ATOM_URLS and BROADCAST_CHAT methods Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 04/19] Fix MySQL InternalError: Unread result found Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 05/19] Create /add_atom command Muhammad Rizki
2022-08-02 21:43   ` Ammar Faizi
2022-08-01  0:19 ` [PATCH v5 06/19] Add utility functions for /add_atom Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 07/19] Refactor database methods Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 08/19] Add insert_atom() in scraper/db.py Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 09/19] Rename admin.py to debugger.py Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 10/19] Add delete_atom() function in scraper/db.py Muhammad Rizki
2022-08-02 21:45   ` Ammar Faizi
2022-08-01  0:19 ` [PATCH v5 11/19] Add utility function buton_numbers() Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 12/19] Move bot commands related files to packages/plugins/commands/ Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 13/19] Add del_atom callback query Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 14/19] Add insert_broadcast() in scraper/db.py Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 15/19] Add delete_broadcast() " Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 16/19] Create /add_bc bot command Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 17/19] Add create_chat_link() function Muhammad Rizki
2022-08-01  0:19 ` [PATCH v5 18/19] Add /del_bc bot command Muhammad Rizki
2022-08-02 21:47   ` Ammar Faizi
2022-08-01  0:19 ` [PATCH v5 19/19] Add del_chat callback query Muhammad Rizki
2022-08-02 21:47   ` Ammar Faizi
2022-08-03  0:13 ` [PATCH v5 00/19] New feature to handle atom URLs and broadcast Ammar Faizi
2022-08-03  0:14 ` Ammar Faizi

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    [email protected] \
    [email protected] \
    [email protected] \
    [email protected] \
    [email protected] \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox