File: DATABASE

package info (click to toggle)
libcddb-get-perl 2.23-2.1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 124 kB
  • ctags: 14
  • sloc: perl: 674; makefile: 51
file content (18 lines) | stat: -rw-r--r-- 495 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
# this a the database example of Falko

CREATE TABLE cds (
  cddbid varchar(20) NOT NULL default '',
  artist varchar(250) NOT NULL default '',
  title varchar(250) NOT NULL default '',
  category varchar(250) NOT NULL default '',
  tracks varchar(250) NOT NULL default '',
  PRIMARY KEY  (cddbid)
);

CREATE TABLE tracks (
  cddbid varchar(20) NOT NULL default '',
  title varchar(250) NOT NULL default '',
  trackno tinyint(2) NOT NULL default '0',
  time time NOT NULL default '00:00:00'
);