-
Notifications
You must be signed in to change notification settings - Fork 0
/
create.sql
34 lines (34 loc) · 3.43 KB
/
create.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
create table cell_automaton (cell_automaton_id int8 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int8 not null, ordinal int8, cell_automaton_id int8, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create table cell_automaton (cell_automaton_id int8 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int8 not null, ordinal int8, cell_automaton_id int8, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create table cell_automaton (cell_automaton_id int8 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int8 not null, ordinal int8, cell_automaton_id int8, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create sequence hibernate_sequence start 1 increment 1;
create table cell_automaton (cell_automaton_id int4 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int4 not null, ordinal int4, cell_automaton_id int4, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create table cell_automaton (cell_automaton_id int4 generated by default as identity, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int4 generated by default as identity, ordinal int4, cell_automaton_id int4, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create sequence hibernate_sequence start 1 increment 1;
create table cell_automaton (cell_automaton_id int4 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int4 not null, ordinal int4, cell_automaton_id int4, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create sequence hibernate_sequence start 1 increment 1;
create table cell_automaton (cell_automaton_id int4 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int4 not null, ordinal int4, cell_automaton_id int4, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create sequence hibernate_sequence start 1 increment 1;
create table cell_automaton (cell_automaton_id int4 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int4 not null, ordinal int4, cell_automaton_id int4, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;
create sequence hibernate_sequence start 1 increment 1;
create table cell_automaton (cell_automaton_id int4 not null, type varchar(255), primary key (cell_automaton_id));
create table step (step_id int4 not null, ordinal int4, cell_automaton_id int4, primary key (step_id));
alter table if exists step add constraint FK1yuhvgqfbwk55obn5ldd629x8 foreign key (cell_automaton_id) references cell_automaton;