File: 1_initial.sql

package info (click to toggle)
golang-ariga-atlas 0.7.2-2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, forky, sid, trixie
  • size: 5,676 kB
  • sloc: javascript: 592; sql: 404; makefile: 10
file content (22 lines) | stat: -rw-r--r-- 388 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
--liquibase formatted sql

--changeset atlas:1-1
CREATE TABLE post
(
    id    int NOT NULL,
    title text,
    body  text,
    PRIMARY KEY (id)
);
--rollback: DROP TABLE post;

--changeset atlas:1-2
ALTER TABLE post ADD created_at TIMESTAMP NOT NULL;
--rollback: ALTER TABLE post DROP created_at;

--changeset atlas:1-3
INSERT INTO post (title) VALUES (
'This is
my multiline

value');