Re: Custom map for quota

2024-01-14 Thread John Fawcett
On 15/01/2024 01:10, m87562...@gmail.com wrote: John Fawcett wrote: On 13/01/2024 14:01, Matt wrote: Hi, I'm trying to setup quota with the following layout CREATE TABLE "domain" ( "id" INTEGER,

Re: Custom map for quota

2024-01-14 Thread m87562378
John Fawcett wrote: > On 13/01/2024 14:01, Matt wrote: > > Hi, > > I'm trying to setup quota with the following layout > > CREATE TABLE "domain" ( > > "id" INTEGER, > > "name" TEXT, > > "active" INTEGER DEFAULT 0, > > PRIMARY KEY("id"), > > UNIQUE("name") > > ) > > CREATE TABLE "address" ( > > "id"

Re: Custom map for quota

2024-01-14 Thread John Fawcett
On 13/01/2024 14:01, Matt wrote: Hi, I'm trying to setup quota with the following layout CREATE TABLE "domain" ( "id" INTEGER, "name" TEXT, "active" INTEGER DEFAULT 0, PRIMARY KEY("id"), UNIQUE("name") ) CREATE TABLE "address" ( "id" INTEGER, "localpart" TEXT NOT NULL, "domain_id" INTEGER NOT

Custom map for quota

2024-01-14 Thread Matt
Hi, I'm trying to setup quota with the following layout CREATE TABLE "domain" ( "id" INTEGER, "name" TEXT, "active" INTEGER DEFAULT 0, PRIMARY KEY("id"), UNIQUE("name") ) CREATE TABLE "address" ( "id" INTEGER, "localpart" TEXT NOT NULL, "domain_id" INTEGER NOT NULL, PRIMARY KEY("id"), UNIQUE("lo