Overview
Comment:style(music/music.sql): capitalize "CREATE INDEX"
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: d64f34be4222ee45ca7c5b706d621f9adb7ecbf60a5b057cedb9aea7c89d5e7c
User & Date: dbohdan on 2020-08-24 11:10:01
Other Links: manifest | tags
Context
2020-08-24
12:01
build(skin/js/highlight.pack.js): downgrade to highlight.js v9.18.1 for legacy browser support. Remove more languages to reduce the file size. check-in: 7db5bda2dd user: dbohdan tags: trunk
11:10
style(music/music.sql): capitalize "CREATE INDEX" check-in: d64f34be42 user: dbohdan tags: trunk
11:08
refactor(music/music.sql): add constraint NOT NULL to all columns check-in: 8b14826415 user: dbohdan tags: trunk
Changes

Modified music/music.sql from [de79ffb82c] to [90d1a54a59].

8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
    artist TEXT NOT NULL,
    title TEXT NOT NULL,
    url TEXT NOT NULL,
    category_id INTEGER NOT NULL,
    FOREIGN KEY(category_id) REFERENCES categories(category_id)
);

create index idx_songs_artist
on songs (artist);

CREATE TABLE notes(
    song_id INTEGER PRIMARY KEY NOT NULL,
    content TEXT NOT NULL,
    FOREIGN KEY(song_id) REFERENCES songs(song_id)
);








|
|







8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
    artist TEXT NOT NULL,
    title TEXT NOT NULL,
    url TEXT NOT NULL,
    category_id INTEGER NOT NULL,
    FOREIGN KEY(category_id) REFERENCES categories(category_id)
);

CREATE INDEX idx_songs_artist
ON songs (artist);

CREATE TABLE notes(
    song_id INTEGER PRIMARY KEY NOT NULL,
    content TEXT NOT NULL,
    FOREIGN KEY(song_id) REFERENCES songs(song_id)
);