Database: Species #30

New Issue

2026-02-15T22:07:04Z

TussockyJoker commented

2026-02-15 22:07:04 +00:00

We need a table in the database for all the species on the site, it needs to contain:

English Name
Latin Name
Info Paragraph

species (
species_id INTEGER PRIMARY KEY AUTOINCREMENT,
species_english TEXT,
species_latin TEXT,
body_text TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)

We need a table in the database for all the species on the site, it needs to contain: 1. English Name 2. Latin Name 3. Info Paragraph species ( species_id INTEGER PRIMARY KEY AUTOINCREMENT, species_english TEXT, species_latin TEXT, body_text TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP )

TussockyJoker added the help wanted Medium priority labels 2026-02-15 22:07:04 +00:00

TussockyJoker added a new dependency 2026-02-17 15:03:43 +00:00

#19 Database

TussockyJoker commented

2026-02-23 20:51:05 +00:00

Also needs category field

Ugric commented

2026-02-26 12:02:57 +00:00

here is the database files, download the one you want

species.db.zip

1.3 KiB

species.db.tar.gz

1.2 KiB

TussockyJoker commented

2026-03-05 12:35:32 +00:00

Current schema for species table:

species (
species_id INTEGER PRIMARY KEY AUTOINCREMENT,
species_english TEXT,
species_latin TEXT,
body_text TEXT,
category TEXT,
extinction_risk TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
photoid TEXT
)

Tentatively marked as completed

Current schema for species table: species ( species_id INTEGER PRIMARY KEY AUTOINCREMENT, species_english TEXT, species_latin TEXT, body_text TEXT, category TEXT, extinction_risk TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, photoid TEXT ) Tentatively marked as completed

TussockyJoker closed this issue

2026-03-05 12:35:32 +00:00

Sign in to join this conversation.

2 Participants

Notifications

Due Date

No due date set.

Blocks

#19 Database

Ugric/Komodo-Hub

Reference: Ugric/Komodo-Hub#30