Skip to content

v0

[!WARNING] This schema is not intended to be use in production...

It is just for prototyping...

  • Used By: v0.1.0 Only
  • Purpose: Build For Prototyping Application....

Entire Database Schema

Tables

Tables Description
passwords For storing password entity.

Passwords Table (passwords)

Fields Property Constraints Description
id Integer PRIMARY KEY, AUTOINCREMENT --
domain VarChar(40) NOT NULL domain/platform name to which password entity is associated with.
username VarChar(60) NOT NULL username on that domain/platform. email can be even used as a value.
password VarChar(60) NOT NULL password on that domain/platform
notes VarChar(100) -- --
createdat Date DEFAULT CURRENT_TIMESTAMP --
updatedat Date DEFAULT CURRENT_TIMESTAMP --

Setup SQL

BEGIN TRANSACTION;

CREATE TABLE IF NOT EXISTS `passwords` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `domain` VARCHAR(40) NOT NULL,
    `username` VARCHAR(60) NOT NULL,
    `password` VARCHAR(60) NOT NULL,
    `notes` VARCHAR(100),
    `createdat` DATE DEFAULT CURRENT_TIMESTAMP,
    `updatedat` DATE DEFAULT CURRENT_TIMESTAMP
);

COMMIT;

Migration SQL (v$ -> v0)

-- NO MIGRATION NEEDED!!
-- As this is first time, version history start from here, no migration needed.

Revert SQL (v$ <- v0)

BEGIN TRANSACTION;

DROP TABLE `passwords`;

COMMIT;

Changes Made

XXXXX No Changes, As every thing is New!! XXXXX