My Anytone 878UV Codeplug

drop table if exists radio_id_list;
drop table if exists channels;
drop table if exists talk_groups;

create table radio_id_list
(
       "No." integer not null
             constraint radio_id_list
             primary key autoincrement,
       "Radio ID" TEXT,
       Name TEXT
);

create unique index "radio_id_list_No._uindex"
         on radio_id_list ("No.");

create table talk_groups
(
       "No." integer not null
             constraint talk_groups
             primary key autoincrement,
       "Radio ID" TEXT,
       Name TEXT,
       "Call Type" TEXT,
       "Call Alert" TEXT
);

create unique index "talk_groups_No._uindex"
         on talk_groups ("No.");
create unique index "talk_groups_name._uindex"
         on talk_groups (Name);

drop table if exists channels;
create table channels
(
    "No." integer not null
          constraint channels
          primary key autoincrement,
    "Channel Name"                 TEXT,
    "Receive Frequency"            TEXT,
    "Transmit Frequency"           TEXT,
    "Channel Type"                 TEXT,
    "Transmit Power"               TEXT,
    "Band Width"                   TEXT,
    "CTCSS/DCS Decode"             TEXT default 'Off',
    "CTCSS/DCS Encode"             TEXT default 'Off',
    Contact                        TEXT,
    "Contact Call Type"            TEXT,
    "Contact TG/DMR ID"            TEXT,
    "Radio ID"                     TEXT,
    "Busy Lock/TX Permit"          TEXT,
    "Squelch Mode"                 TEXT default 'Carrier',
    "Optional Signal"              TEXT default 'Off',
    "DTMF ID"                      TEXT default '1',
    "2Tone ID"                     TEXT default '1',
    "5Tone ID"                     TEXT default '1',
    "PTT ID"                       TEXT default 'Off',
    "Color Code"                   TEXT default '1',
    Slot                           TEXT default '2',
    "Scan List"                    TEXT default 'None',
    "Receive Group List"           TEXT default 'None',
    "PTT Prohibit"                 TEXT default 'Off',
    Reverse                        TEXT default 'Off',
    "Simplex TDMA"                 TEXT default 'Off',
    "Slot Suit"                    TEXT default 'Off',
    "AES Digital Encryption"       TEXT default 'Normal Encryption',
    "Digital Encryption"           TEXT default 'Off',
    "Call Confirmation"            TEXT default 'Off',
    "Talk Around(Simplex)"         TEXT default 'Off',
    "Work Alone"                   TEXT default 'Off',
    "Custom CTCSS"                 TEXT default '2511.0',
    "2TONE Decode"                 TEXT default '1',
    Ranging                        TEXT default 'Off',
    "Through Mode"                 TEXT default 'Off',
    "APRS RX"                      TEXT default 'Off',
    "Analog APRS PTT Mode"         TEXT default 'Off',
    "Digital APRS PTT Mode"        TEXT default 'Off',
    "APRS Report Type"             TEXT default 'Off',
    "Digital APRS Report Channel"  TEXT default '1',
    "Correct Frequency[Hz]"        TEXT default '0',
    "SMS Confirmation"             TEXT default 'On',
    "Exclude channel from roaming" TEXT default '0',
    "DMR MODE"                     TEXT,
    "DataACK Disable"              TEXT default '0',
    R5toneBot                      TEXT default '0',
    R5ToneEot                      TEXT default '0',
    "Auto Scan"                    TEXT default '0',
    "Ana Aprs Mute"                TEXT default '0'
);

create unique index "channels_No._uindex"
         on channels ("No.");

drop table if exists zones;
create table zones
(
    "No." integer not null
          constraint zones
          primary key autoincrement,
    "Zone Name"                        TEXT,
    "Zone Channel Member"              TEXT,
    "Zone Channel Member RX Frequency" TEXT,
    "Zone Channel Member TX Frequency" TEXT,
    "A Channel"                        TEXT,
    "A Channel RX Frequency"           TEXT,
    "A Channel TX Frequency"           TEXT,
    "B Channel"                        TEXT,
    "B Channel RX Frequency"           TEXT,
    "B Channel TX Frequency"           TEXT
);

create unique index "zones_No._uindex"
         on zones ("No.");

create temporary table temp_table("Radio ID" text, Name text);
.mode csv temp_table
.import $mydata temp_table

insert into radio_id_list ("Radio ID", Name) select * from temp_table;

.mode csv

drop table if exists my_talk_groups;
.import $mydata my_talk_groups

insert into talk_groups ("Radio ID", Name, "Call Type", "Call Alert")
       select "Radio ID", Name, "Call Type", "Call Alert" from my_talk_groups;

-- func generate_zone(name, channels)

with a_channel as (select "Channel Name", "Receive Frequency", "Transmit Frequency"
                   from $channels
                   limit 1),
     b_channel as (select "Channel Name", "Receive Frequency", "Transmit Frequency"
                   from $channels
                   limit 1 offset 1)
insert
into zones("Zone Name", "Zone Channel Member", "Zone Channel Member RX Frequency",
           "Zone Channel Member TX Frequency", "A Channel", "A Channel RX Frequency", "A Channel TX Frequency",
           "B Channel", "B Channel RX Frequency", "B Channel TX Frequency")
select '$name',
       group_concat(c."Channel Name", ' | '),
       group_concat(c."Receive Frequency", ' | '),
       group_concat(c."Transmit Frequency", ' | '),
       a_channel."Channel Name",
       a_channel."Receive Frequency",
       a_channel."Transmit Frequency",
       b_channel."Channel Name",
       b_channel."Receive Frequency",
       b_channel."Transmit Frequency"
from $channels as c,
     a_channel,
     b_channel
order by c."Channel Name";

-- end func

-- set default radio id
UPDATE channels
       SET "Radio ID" = '$default_radio_id'
       WHERE "Radio ID" is NULL or "Radio ID" not in (select distinct Name from radio_id_list);

.mode csv
.headers on

.output codeplug/RadioIDList.CSV
select * from radio_id_list;

.output codeplug/TalkGroups.CSV
select * from talk_groups;

.output codeplug/Channel.CSV
select * from channels;

.output codeplug/Zone.CSV
select * from zones;