Changeset 663 in code


Ignore:
Timestamp:
Nov 2, 2021, 9:58:50 PM (4 years ago)
Author:
contact
Message:

db_sqlite: use TEXT instead of VARCHAR

VARCHAR(n) is pointless in SQLite and is the same as TEXT. Don't
bother with a migration since they're equivalent.

Also remove some unnecessary DEFAULT NULL statements.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/db_sqlite.go

    r652 r663  
    1818CREATE TABLE User (
    1919        id INTEGER PRIMARY KEY,
    20         username VARCHAR(255) NOT NULL UNIQUE,
    21         password VARCHAR(255),
     20        username TEXT NOT NULL UNIQUE,
     21        password TEXT,
    2222        admin INTEGER NOT NULL DEFAULT 0,
    23         realname VARCHAR(255)
     23        realname TEXT
    2424);
    2525
    2626CREATE TABLE Network (
    2727        id INTEGER PRIMARY KEY,
    28         name VARCHAR(255),
     28        name TEXT,
    2929        user INTEGER NOT NULL,
    30         addr VARCHAR(255) NOT NULL,
    31         nick VARCHAR(255) NOT NULL,
    32         username VARCHAR(255),
    33         realname VARCHAR(255),
    34         pass VARCHAR(255),
    35         connect_commands VARCHAR(1023),
    36         sasl_mechanism VARCHAR(255),
    37         sasl_plain_username VARCHAR(255),
    38         sasl_plain_password VARCHAR(255),
    39         sasl_external_cert BLOB DEFAULT NULL,
    40         sasl_external_key BLOB DEFAULT NULL,
     30        addr TEXT NOT NULL,
     31        nick TEXT NOT NULL,
     32        username TEXT,
     33        realname TEXT,
     34        pass TEXT,
     35        connect_commands TEXT,
     36        sasl_mechanism TEXT,
     37        sasl_plain_username TEXT,
     38        sasl_plain_password TEXT,
     39        sasl_external_cert BLOB,
     40        sasl_external_key BLOB,
    4141        enabled INTEGER NOT NULL DEFAULT 1,
    4242        FOREIGN KEY(user) REFERENCES User(id),
    … …  
    4848        id INTEGER PRIMARY KEY,
    4949        network INTEGER NOT NULL,
    50         name VARCHAR(255) NOT NULL,
    51         key VARCHAR(255),
     50        name TEXT NOT NULL,
     51        key TEXT,
    5252        detached INTEGER NOT NULL DEFAULT 0,
    53         detached_internal_msgid VARCHAR(255),
     53        detached_internal_msgid TEXT,
    5454        relay_detached INTEGER NOT NULL DEFAULT 0,
    5555        reattach_on INTEGER NOT NULL DEFAULT 0,
    … …  
    6363        id INTEGER PRIMARY KEY,
    6464        network INTEGER NOT NULL,
    65         target VARCHAR(255) NOT NULL,
    66         client VARCHAR(255),
    67         internal_msgid VARCHAR(255) NOT NULL,
     65        target TEXT NOT NULL,
     66        client TEXT,
     67        internal_msgid TEXT NOT NULL,
    6868        FOREIGN KEY(network) REFERENCES Network(id),
    6969        UNIQUE(network, target, client)
Note: See TracChangeset for help on using the changeset viewer.