File: init_schema.sql

package info (click to toggle)
slony1-2 2.0.4-1
  • links: PTS
  • area: main
  • in suites: squeeze
  • size: 6,716 kB
  • ctags: 4,089
  • sloc: ansic: 17,784; sh: 12,592; xml: 8,185; sql: 7,314; yacc: 2,468; perl: 2,376; lex: 1,321; makefile: 909; awk: 24
file content (8 lines) | stat: -rw-r--r-- 441 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
 
-- $Id: init_schema.sql,v 1.2 2006-09-07 13:07:27 xfade Exp $

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

create table table1a (id serial primary key, table1_id int4 references table1a(id) on update cascade on delete cascade, data text);
create table table2a (id serial primary key, table2_id int4 references table2a(id) on update cascade on delete cascade, data text);