From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on gnuweeb.org X-Spam-Level: X-Spam-Status: No, score=-0.8 required=5.0 tests=ALL_TRUSTED,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,NO_DNS_FOR_FROM,URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.6 Received: from localhost.localdomain (unknown [101.128.125.94]) by gnuweeb.org (Postfix) with ESMTPSA id BD0328076C; Fri, 29 Jul 2022 01:41:35 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gnuweeb.org; s=default; t=1659058897; bh=HTdTpWVxFKziLED7K1WnrezyPXk36wrVOdF44Jdxovk=; h=From:To:Cc:Subject:Date:In-Reply-To:References:From; b=N+EPNiOGyMcA1CGuVbSiWOtzAGSSQeaiEuXUZCv2Ei1mELdNS4aRWtJjltWtabaht bjmQBaKROvK/VQbPK4xPmhz9u7XDZE2PgFBQi1A74S2xE1Z41h05x/sos7isy1l7bT Iayvku5d7cFANlR6z7ziRsWtKzBDI7In19OD8XPc4fxkMfYZIJ3YC168Io5PvTnO71 ps6M1bBHg0iO7W8j5mjrUFozdVJOIIXzYqF7/CQxyhsRUqVyrIMu16CqECcvU+Od4I 01WmtF1j6T4Y6fTMXoc8G+r46XzhQIhTw5xJmjrdRvAcVvoCjcFH3a+DlCm2e6Wf0U hz8il91l9yVEw== From: Muhammad Rizki To: Ammar Faizi Cc: Muhammad Rizki , GNU/Weeb Mailing List , Alviro Iskandar Setiawan Subject: [PATCH v3 01/18] Add new table for atom URLs and broadcast chats in db.sql Date: Fri, 29 Jul 2022 08:40:35 +0700 Message-Id: <20220729014052.1547-2-kiizuha@gnuweeb.org> X-Mailer: git-send-email 2.34.1.windows.1 In-Reply-To: <20220729014052.1547-1-kiizuha@gnuweeb.org> References: <20220729014052.1547-1-kiizuha@gnuweeb.org> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: Just add new table for atom URLs and broadcast chats in db.sql to save them in MySQL database. Signed-off-by: Muhammad Rizki --- .gitignore | 4 ++++ daemon/db.sql | 25 +++++++++++++++++++++++++ 2 files changed, 29 insertions(+) diff --git a/.gitignore b/.gitignore index ca28962..511dbbe 100644 --- a/.gitignore +++ b/.gitignore @@ -136,4 +136,8 @@ data.json # VSCode editor .vscode/ +# PATCH *.patch + +# RFC directory +RFC \ No newline at end of file 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