Editing Background Painting Progress Database (section)

== Table definitions ==
Sqlite3 database.


<syntaxhighlight lang="mysql">
CREATE TABLE "bgs" ( 
CREATE TABLE `locations` (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL UNIQUE
);

insert into locations (id, name) values (NULL, 'interior');
insert into locations (id, name) values (NULL, 'exterior');

CREATE TABLE `bgs` (
    `id` INTEGER PRIMARY KEY,
    `show_code` TEXT NOT NULL DEFAULT '', 
    `episode_code` INTEGER NOT NULL DEFAULT 0, 
    `episode` TEXT NOT NULL DEFAULT '',
    `scene` INTEGER NOT NULL, 
    `width` INTEGER NOT NULL, 
    `height` INTEGER NOT NULL, 
    `overlay_count` INTEGER NOT NULL DEFAULT 0, 
    `partial` INTEGER DEFAULT 0, 
    `establishing_shot` INTEGER DEFAULT 0, 
    `location_id` INTEGER NOT NULL,
    `hours` INTEGER, 
    `finished` INTEGER DEFAULT 0,
    `approved` INTEGER DEFAULT 0,
    FOREIGN KEY (location_id) REFERENCES locations(id)
);
</syntaxhighlight>