summaryrefslogtreecommitdiff
path: root/script.sql
diff options
context:
space:
mode:
Diffstat (limited to 'script.sql')
-rw-r--r--script.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/script.sql b/script.sql
index 25e5ffe..7f3f3c0 100644
--- a/script.sql
+++ b/script.sql
@@ -11,8 +11,8 @@ CREATE TABLE transactions (
client_id INTEGER REFERENCES clients,
value INTEGER NOT NULL,
type transaction_type NOT NULL,
- description VARCHAR(10) NOT NULL,
- created_at TIMESTAMP NOT NULL DEFAULT NOW()
+ description VARCHAR(255) NOT NULL,
+ created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE TABLE balances (