File: schema-3.sql

package info (click to toggle)
clementine 1.2.3%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 24,792 kB
  • ctags: 20,160
  • sloc: cpp: 111,170; xml: 4,413; python: 2,687; ansic: 984; sql: 753; sh: 66; makefile: 25
file content (9 lines) | stat: -rw-r--r-- 268 bytes parent folder | download | duplicates (8) 
1
2
3
4
5
6
7
8
9
 
ALTER TABLE songs ADD COLUMN filetype INTEGER NOT NULL DEFAULT 0;

ALTER TABLE songs ADD COLUMN playcount INTEGER NOT NULL DEFAULT 0;

ALTER TABLE songs ADD COLUMN lastplayed INTEGER;

ALTER TABLE songs ADD COLUMN rating INTEGER;

UPDATE schema_version SET version=3;