· 4 years ago · Jul 12, 2021, 04:12 PM
1#!/usr/bin/env bash
2
3: "${TABLE_NAME?TABLE_NAME variable not set}"
4
5read -r -d '' VAR <<'EOF'
6CREATE TABLE IF NOT EXISTS "${TABLE_NAME}".'Members' (
7 'membership_number' INT AUTOINCREMENT ,
8 'full_names' VARCHAR(150) NOT NULL ,
9 'gender' VARCHAR(6) ,
10 'date_of_birth' DATE ,
11 'physical_address' VARCHAR(255) ,
12 'postal_address' VARCHAR(255) ,
13 'contact_number' VARCHAR(75) ,
14 'email' VARCHAR(255) ,
15 PRIMARY KEY ('membership_number') )
16EOF
17
18echo "${VAR}"
19