Nim/tests/stdlib/somesql.sql

create table anon40(
  anon41 anon42 primary key default anon43(),
  anon44 text unique not null,
  anon45 text unique not null,
  anon46 text not null,
  anon47 text not null,
  anon48 text default null,
  anon49 text default null,
  anon50 text default null,
  anon51 text default null,
  anon52 text default null,
  anon53 text default null,
  anon54 text default null,
  anon55 text default null,
  anon56 text default null,
  anon57 text default null,
  anon58 text default null,
  anon59 text default null,
  anon60 text default null,
  anon61 text default null,
  anon62 varchar(30) default null,
  anon63 varchar(30) default null);
create table anon64(
  anon41 serial  primary key,
  anon65 varchar(30) not null unique,
  anon46 varchar(30) not null,
  anon66 varchar(30) not null,
  anon47 varchar(30) not null,
  anon67 text not null,
  anon55 varchar(30) not null unique,
  anon68 varchar(30) default 'o',
  anon69 boolean default true,
  anon70 int not null  references anon40(anon41));
create table anon71(
  anon72 varchar(30) not null  primary key,
  anon73 varchar(30) not null unique,
  anon70 int not null  references anon40(anon41));
create table anon74(
  anon72 varchar(30) not null  primary key,
  anon73 varchar(30) not null unique,
  anon75 varchar(30) not null,
  anon70 int not null references anon40(anon41),
  foreign key(anon75) references anon71(anon72));
create table anon76(
  anon41 serial  primary key,
  anon72 varchar(30) not null unique,
  anon73 varchar(30) not null unique,
  anon77 varchar(30) not null,
  anon70 int not null  references anon40(anon41),
  foreign key(anon77) references anon74(anon72));
create table anon78(
  anon41 serial  primary key,
  anon72 varchar(30) not null unique,
  anon73 varchar(30) not null unique,
  anon79 int not null,
  anon80 varchar(30) default null,
  anon81 int not null,
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41),
  foreign key(anon79) references anon78(anon41),
  foreign key(anon81) references anon76(anon41));
create table anon82(
  anon41 serial  primary key,
  anon72 varchar(30) not null unique,
  anon73 text not null unique,
  anon79 int not null,
  anon80 text default null,
  anon83 varchar(30) not null default 'd',
  anon84 decimal default 0.00,
  anon69 boolean not null default true,
  anon85 decimal default 0.00,
  anon86 decimal default 0.00,
  anon87 decimal default 0.00,
  anon70 int not null  references anon40(anon41),
  foreign key(anon79) references anon78(anon41));
create table anon88(
  anon41 serial  primary key,
  anon72 varchar(30) not null unique,
  anon80 text default '',
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41));
create table anon89(
  anon90 int not null  primary key,
  anon91 anon92 default 0.00,
  anon93 varchar(30),
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41),
  foreign key(anon90) references anon82(anon41));
create table anon94(
  anon41 serial  primary key,
  anon73 text unique not null,
  anon80 text default null,
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41));
create table anon95(
  anon41 serial  primary key,
  anon73 text unique not null,
  anon96 int not null  references anon94(anon41),
  anon80 text default null,
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41));
create table anon97(
  anon41 serial  primary key,
  anon73 text unique not null,
  anon98 int not null  references anon95(anon41),
  anon80 text default null,
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41));
create table anon99(
  anon41 serial  primary key,
  anon73 varchar(30) unique not null,
  anon100 varchar(30) default null,
  anon101 anon102 default 0,
  anon103 varchar(30) default 'g',
  anon104 int not null,
  anon105 decimal not null default 1,
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41));
create table anon106(
  anon107 varchar(30) default 'g',
  anon108 int  references anon99(anon41) not null,
  anon109 decimal default 1,
  anon110 int  references anon99(anon41) not null,
  anon70 int not null  references anon40(anon41));
create table anon111(
  anon41 serial  primary key,
  anon112 text unique not null,
  anon73 text unique not null,
  anon113 anon102  references anon97(anon41) not null,
  anon114 varchar(30) not null,
  anon115 int not null  references anon88(anon41),
  anon116 int not null  references anon82(anon41),
  anon117 int not null  references anon82(anon41),
  anon118 int not null  references anon82(anon41),
  anon119 int not null  references anon82(anon41),
  anon120 int not null  references anon82(anon41),
  anon121 int not null  references anon82(anon41),
  anon122 int  references anon99(anon41) not null,
  anon123 decimal default 0.00,
  anon124 decimal default 0.00,
  anon69 boolean default true,
  anon70 int not null  references anon40(anon41));
create table anon125(
  anon41 serial  primary key,
  anon126 int  references anon111(anon41) not null,
  anon80 text not null,
  anon127 varchar(30) not null,
  anon128 decimal default 0.00,
  anon129 decimal default 0,
  anon130 decimal default 0,
  anon131 decimal default 0,
  anon132 decimal default 0,
  anon133 decimal default 0.00,
  anon134 decimal default 0.00,
  anon135 decimal default 0.00,
  anon70 int not null  references anon40(anon41),  constraint anon136 check anon137(anon126, anon127, anon129));
create table anon138(
  anon41 serial  primary key,
  anon126 int  references anon111(anon41) not null,
  anon80 text not null,
  anon127 varchar(30) not null,
  anon139 date not null,
  anon129 decimal default 0,
  anon130 decimal default 0,
  anon131 decimal default 0,
  anon132 decimal default 0,
  anon70 int not null  references anon40(anon41),  constraint anon136 check anon137(anon127, anon129));
create table anon140(
  anon41 serial  primary key,
  anon141 text unique not null,
  anon46 text default null,
  anon47 text default null,
  anon57 varchar(30) default null,
  anon142 text default null,
  anon51 text default null,
  anon143 varchar(30) default null,
  anon53 text default null,
  anon54 text default null,
  anon55 text default null,
  anon45 text default null,
  anon69 boolean default true,
  anon70 int not null  references anon40(anon41));
create table anon144(
  anon41 serial  primary key,
  anon72 varchar(30) unique not null,
  anon73 varchar(30) unique not null,
  anon80 varchar(30) default null,
  anon69 boolean default true,
  anon70 int not null  references anon40(anon41));
create table anon145(
  anon41 serial  primary key,
  anon72 varchar(30) unique not null,
  anon73 varchar(30) unique not null,
  anon146 int not null,
  anon147 anon92 default 1,
  anon148 anon92 default 9999999,
  anon80 varchar(30) default null,
  anon69 boolean default true,
  anon149 int default 0,
  anon150 int not null,
  anon151 anon92 default 0,
  anon70 int not null  references anon40(anon41),
  foreign key(anon150) references anon82(anon41),
  foreign key(anon146) references anon144(anon41));
create table anon152(
  anon41 serial  primary key,
  anon73 varchar(30) not null unique,
  anon153 varchar(30) not null unique,
  anon80 text default null,
  anon69 boolean not null default true,
  anon70 int not null  references anon40(anon41));
create table anon154(
  anon41 serial  primary key not null,
  anon155 int not null unique,
  date date default anon156 not null,
  anon157 anon102  references anon140(anon41) not null,
  anon158 anon102  references anon64(anon41) not null,
  anon159 decimal default 0 not null,
  anon160 decimal default 0 not null,
  anon161 decimal default 0 not null,
  anon162 decimal default 0 not null,
  anon163 decimal default 0 not null,
  anon164 decimal default 0 not null,
  anon165 decimal default 0.00,
  anon166 decimal default 0 not null,
  anon167 decimal default 0.00,
  anon168 decimal default 0 not null,
  anon169 boolean default false,
  anon170 varchar(30) default 'ca',
  anon171 varchar(30) default 'n',
  anon172 varchar(30) not null default 'd',
  anon173 decimal default 0.00,
  anon174 decimal default 0.00,
  anon175 int,
  anon176 varchar(30) default null,
  anon177 varchar(30) default '',
  anon178 varchar(30) default null,
  anon70 int not null  references anon40(anon41));
create table anon179(
  anon41 serial  primary key not null,
  anon180 anon102  references anon154(anon41) not null,
  anon181 int  references anon125(anon41) not null,
  anon182 int  references anon82(anon41) not null,
  anon122 int  references anon99(anon41) not null,
  anon183 decimal not null,
  anon184 decimal default 0.00,
  anon174 decimal default 0,
  anon160 decimal default 0.00,
  anon185 decimal default 0,
  anon162 decimal default 0.00,
  anon186 decimal default 0,
  anon163 decimal default 0.00,
  anon187 decimal default 0,
  anon164 decimal default 0.00,
  anon188 decimal default 0,
  anon161 decimal default 0.00,
  anon189 decimal default 0.00,
  anon168 decimal default 0.00,
  anon190 decimal not null,
  anon191 decimal default 0,
  anon83 varchar(30) not null default 't',
  anon192 decimal default 0,
  anon193 decimal not null,
  anon194 decimal not null,
  anon70 int not null  references anon40(anon41));
create table anon195(
  anon41 serial not null,
  anon196 int not null,
  anon175 char not null,
  anon90 int not null  references anon82,
  anon165 decimal default 0.00,
  anon70 int not null  references anon40(anon41),  primary key(anon196, anon175));
create table anon197(
  anon41 serial not null,
  anon196 int not null,
  anon175 char not null,
  anon198 int not null,
  anon189 decimal default 0.00,
  anon199 varchar(30) default null,
  anon200 varchar(30) default null,
  anon70 int not null  references anon40(anon41),
  primary key(anon196, anon175),
  foreign key(anon198) references anon145(anon41));
create table anon201(
  anon41 serial  primary key,
  anon202 varchar(30) not null,
  anon203 varchar(30) not null,
  anon204 varchar(30) not null,
  anon205 varchar(30) not null,
  anon206 boolean default null,
  anon70 int not null  references anon40(anon41));
create table anon207(
  anon41 serial  primary key,
  anon208 varchar(30) not null,
  anon209 varchar(30) not null,
  anon204 varchar(30) default null,
  anon70 int not null  references anon40(anon41));
select * from anon207 where anon41 in (1, 2, 3);