File: pgsql_schema

package info (click to toggle)
libapache-mod-mp3 0.39-5
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 436 kB
  • ctags: 432
  • sloc: ansic: 3,135; perl: 521; sh: 176; makefile: 50
file content (20 lines) | stat: -rw-r--r-- 500 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
CREATE TABLE songs (
  id SERIAL,
  name varchar(255) NOT NULL,
  filename varchar(255) NOT NULL,
  signature varchar(255) NOT NULL UNIQUE,
  artist varchar(255) NOT NULL,
  album varchar(255) NOT NULL,
  comment varchar(255) NOT NULL,
  track varchar(255) NOT NULL,
  year varchar(255) NOT NULL,
  genre varchar(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE songs (
  id SERIAL,
  token varchar(255) NOT NULL,
  signature varchar(255) NOT NULL UNIQUE,
  PRIMARY KEY (id)
);