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=2.2 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT, FREEMAIL_FORGED_FROMDOMAIN,FREEMAIL_FROM,HEADER_FROM_DIFFERENT_DOMAINS, RCVD_IN_DNSWL_NONE,RCVD_IN_MSPIKE_H3,RCVD_IN_MSPIKE_WL,SPF_HELO_NONE, SPF_PASS autolearn=no autolearn_force=no version=3.4.6 Received: from mail-pj1-f54.google.com (mail-pj1-f54.google.com [209.85.216.54]) by gnuweeb.org (Postfix) with ESMTPS id CDE7A8176A for ; Sun, 27 Nov 2022 20:32:47 +0000 (UTC) Received: by mail-pj1-f54.google.com with SMTP id k2-20020a17090a4c8200b002187cce2f92so12094212pjh.2 for ; Sun, 27 Nov 2022 12:32:47 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=E2VHLK1a+jrdm+DoDe/KwhEzQNmsRXYqu0+A6nk3QVY=; b=s/dMhRE2mnjj72dUGHTnc+w0vnJ5MHTuHZkblXs/DjxRhlwtCb1xEybqtFVy1s29z3 C00gPD2aW5fUzqtQqCndqnym+SilHzQwUeJkqf8lEYsbfNawzdxZRnysW0A72K6Aw0R5 SGMx1iW04yXNQfGGe0DRgkJrXR60EfHGP3/ePyW9PDOcuU8Mrm4BK/EHDmzT/dC2dLW+ c1FsGPDGcOYDc6y2sVwzCvUog0gWQVxFPz3tYXWrkEgPRc14pC9hdhjmbfQ0i5wOtklw hfEGtHrIlZ52eTuFX20XDME1Midt1pvPzVaWM161hRuxxCxRSh0ShIzHd3bxwjC92YKs 71sw== X-Gm-Message-State: ANoB5pmwzNqH67R5XjO999NbaciUxZFU5hQn1xlDrCSsT+9yiw6mluHh sdGpHnwIAQkpaj442x6izjit7jlaC4n14g== X-Google-Smtp-Source: AA0mqf4eUnudqLKng68nj6YndY+2PoPNMHswBTnRRoyWASBFP0EMvRpKivrErDFWnfuKpsUN612ONA== X-Received: by 2002:a17:902:d550:b0:189:7bfe:1eb5 with SMTP id z16-20020a170902d55000b001897bfe1eb5mr6328362plf.9.1669581167420; Sun, 27 Nov 2022 12:32:47 -0800 (PST) Received: from localhost.localdomain ([2404:8000:1021:2a9:da99:231d:4dfa:7f54]) by smtp.gmail.com with ESMTPSA id ij13-20020a170902ab4d00b0018685257c0dsm7234904plb.58.2022.11.27.12.32.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 27 Nov 2022 12:32:47 -0800 (PST) From: Ammar Faizi To: Gilang Fachrezy Cc: Ammar Faizi , Taufiq Pohan , Aldy Prastyo , Muhammad Fitrah Pandjalu , Nauvalsa Yanandana , GNU/Weeb Mailing List , VNLX Kernel Department Subject: [PATCH v1 07/13] Export the DDL Date: Mon, 28 Nov 2022 03:32:10 +0700 Message-Id: <20221127203216.408808-8-ammarfaizi2@gnuweeb.org> X-Mailer: git-send-email 2.34.1 In-Reply-To: <20221127203216.408808-1-ammarfaizi2@gnuweeb.org> References: <20221127203216.408808-1-ammarfaizi2@gnuweeb.org> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: Initial work of the database part. Co-authored-by: Muhammad Fitrah Pandjalu Signed-off-by: Muhammad Fitrah Pandjalu Co-authored-by: Taufiq Pohan Signed-off-by: Taufiq Pohan Signed-off-by: Ammar Faizi --- database.sql | 57 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 database.sql diff --git a/database.sql b/database.sql new file mode 100644 index 0000000..909d987 --- /dev/null +++ b/database.sql @@ -0,0 +1,57 @@ +-- Adminer 4.8.1 MySQL 8.0.31-0ubuntu0.22.04.1 dump + +SET NAMES utf8; +SET time_zone = '+00:00'; +SET foreign_key_checks = 0; +SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; + +SET NAMES utf8mb4; + +DROP TABLE IF EXISTS `attendances`; +CREATE TABLE `attendances` ( + `id` int unsigned NOT NULL AUTO_INCREMENT, + `city_id` int unsigned DEFAULT NULL, + `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL, + `phone_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, + `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, + `facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `twitter_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `discord_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `github_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `created_at` datetime DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `full_name` (`full_name`), + KEY `phone_number` (`phone_number`), + KEY `email` (`email`), + KEY `facebook_id` (`facebook_id`), + KEY `twitter_username` (`twitter_username`), + KEY `discord_username` (`discord_username`), + KEY `github_username` (`github_username`), + KEY `created_at` (`created_at`), + KEY `city_id` (`city_id`), + CONSTRAINT `attendances_ibfk_2` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE SET NULL ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; + + +DROP TABLE IF EXISTS `cities`; +CREATE TABLE `cities` ( + `id` int unsigned NOT NULL AUTO_INCREMENT, + `province_id` tinyint unsigned NOT NULL, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, + PRIMARY KEY (`id`), + KEY `name` (`name`), + KEY `province_id` (`province_id`), + CONSTRAINT `cities_ibfk_3` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; + + +DROP TABLE IF EXISTS `provinces`; +CREATE TABLE `provinces` ( + `id` tinyint unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; + + +-- 2022-11-27 18:33:10 -- Ammar Faizi