File: data.sql

package info (click to toggle)
skytools 2.1.8-2.2
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 1,980 kB
  • ctags: 1,543
  • sloc: sql: 6,635; python: 6,237; ansic: 2,799; makefile: 308; sh: 268
file content (22 lines) | stat: -rw-r--r-- 402 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 

set client_min_messages = 'warning';

create table data1 (
    id serial primary key,
    data text
);

create unique index idx_data1_uq on data1 (data);

create index idx_data1_rand on data1 (id, data);

create table data2 (
    id serial primary key,
    data text,
    -- old_id integer references data1,
    constraint uq_data2 unique (data)
);

create index idx_data2_rand on data2 (id, data);