/usr/share/doc/audiolink/mysql.schema is in audiolink 0.05-1.2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | CREATE TABLE aldb (
song_nr INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
album CHAR(100),
song CHAR(100) NOT NULL,
year CHAR(4),
band CHAR(30),
genre CHAR(20),
track INT,
composer CHAR(30),
lyricist CHAR(30),
ma1 CHAR(30),
ma2 CHAR(30),
fa1 CHAR(30),
fa2 CHAR(30),
comment CHAR(100),
path CHAR(200) NOT NULL UNIQUE
);
|