shopr

Artifact Content
Login

Artifact 4719e79588a8bc999b3e61334ac6372d5a70cac93d86ab7a0bc6fe2824f88c89:


create table users(
    uid integer primary key autoincrement,
    name text,
    pw text,
    unique(name)
);

create table lists(
    lid integer primary key autoincrement,
    owner integer,
    name text,
    unique(owner,name)
);

create table items(
    list integer,
    name text,
    idx integer,
    gen integer,
    unique(list,name)
);