migrations/committed/000003.sql at main · eldridge.cam/cookiealyst

Christmas cookie ranking site

cookiealyst / migrations / committed / 000003.sql

at main 9 lines 580 B view raw

wrap content

1--! Previous: sha1:f13230e6433a096866618e1cf38041772c96b01c
2--! Hash: sha1:68b252bfff5435081d6aeb5a3f6134a26b915c3d
3
4ALTER TABLE reviews DROP CONSTRAINT IF EXISTS comment_max_length;
5ALTER TABLE comments DROP CONSTRAINT IF EXISTS comment_max_length;
6ALTER TABLE accounts DROP CONSTRAINT IF EXISTS account_id_max_length;
7ALTER TABLE reviews ADD CONSTRAINT comment_max_length CHECK (length(comment) <= 2048);
8ALTER TABLE comments ADD CONSTRAINT comment_max_length CHECK (length(comment) <= 2048);
9ALTER TABLE accounts ADD CONSTRAINT account_id_max_length CHECK (length(id) <= 128);