another_id INTEGER DEFAULT 2,
timest TIMESTAMP,
PRIMARY KEY (id),
- CONSTRAINT emailuniqueindex UNIQUE (email)
+ CONSTRAINT emailuniqueindex UNIQUE (email),
+ CONSTRAINT very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms UNIQUE (title)
);
DROP TABLE Another;
CREATE TABLE Another (
id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,
+ num NUMERIC(10,2),
PRIMARY KEY (id)
);