File: prefixes.sql

package info (click to toggle)
prefix 1.2.3-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 688 kB
  • ctags: 150
  • sloc: ansic: 1,313; sql: 756; makefile: 36; sh: 2
file content (10 lines) | stat: -rw-r--r-- 256 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
10
 
create table prefixes (
       prefix    text primary key,
       name      text not null,
       shortname text,
       state     char default 'S',

       check( state in ('S', 'R') )
);

comment on column prefixes.state is 'S: attribué - R: réservé';