<commit_before>CREATE TABLE users (
    id                 SERIAL          PRIMARY KEY,
    username           VARCHAR( 64 ),
    encrypted_password VARCHAR( 512 ),
    time_created       TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP,
    openid             VARCHAR( 1024 ),
    CONSTRAINT identifiable CHECK (
        (
            username IS NOT NULL
            AND encrypted_password IS NOT NULL
        ) OR openid IS NOT NULL
    )
);

CREATE TABLE tags (
    id           SERIAL          PRIMARY KEY,
    name         VARCHAR( 128 )  NOT NULL
);

CREATE TABLE bookmarks (
    id           SERIAL          PRIMARY KEY,
    uri          VARCHAR( 1024 ) NOT NULL,
);

CREATE TABLE users_bookmarks (
    user_id      INTEGER         NOT NULL REFERENCES users( id ),
    bookmark_id  INTEGER         NOT NULL REFERENCES bookmarks( id ),
    time_created TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP,
    title        VARCHAR( 256 )  NOT NULL,
    notes        VARCHAR( 4096 ),
    UNIQUE( user_id, bookmark_id )
);

CREATE TABLE users_bookmarks_tags (
    user_id      INTEGER         NOT NULL REFERENCES users( id ),
    bookmark_id  INTEGER         NOT NULL REFERENCES bookmarks( id ),
    tag_id       INTEGER         NOT NULL REFERENCES tags( id ),
    UNIQUE( user_id, bookmark_id, tag_id )
);
<commit_msg>Increased bookmarks.uri to VARCHAR( 2048 ).<commit_after>CREATE TABLE users (
    id                 SERIAL          PRIMARY KEY,
    username           VARCHAR( 64 ),
    encrypted_password VARCHAR( <PASSWORD> ),
    time_created       TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP,
    openid             VARCHAR( 1024 ),
    CONSTRAINT identifiable CHECK (
        (
            username IS NOT NULL
            AND encrypted_password IS NOT NULL
        ) OR openid IS NOT NULL
    )
);

CREATE TABLE tags (
    id           SERIAL          PRIMARY KEY,
    name         VARCHAR( 128 )  NOT NULL
);

CREATE TABLE bookmarks (
    id           SERIAL          PRIMARY KEY,
    uri          VARCHAR( 2048 ) NOT NULL,
);

CREATE TABLE users_bookmarks (
    user_id      INTEGER         NOT NULL REFERENCES users( id ),
    bookmark_id  INTEGER         NOT NULL REFERENCES bookmarks( id ),
    time_created TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP,
    title        VARCHAR( 256 )  NOT NULL,
    notes        VARCHAR( 4096 ),
    UNIQUE( user_id, bookmark_id )
);

CREATE TABLE users_bookmarks_tags (
    user_id      INTEGER         NOT NULL REFERENCES users( id ),
    bookmark_id  INTEGER         NOT NULL REFERENCES bookmarks( id ),
    tag_id       INTEGER         NOT NULL REFERENCES tags( id ),
    UNIQUE( user_id, bookmark_id, tag_id )
);

{'fraction_non_alphanumeric': 0.05359136583550428, 'fraction_numerical': 0.017491626349088202, 'mean_word_length': 1.8058455114822547, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5850434', 'n_tokens_mistral': 839, 'n_tokens_neox': 765, 'n_words': 255}