I have an application that I’m using spring boot and postgres. I’m getting this error when I try to create a user.
When I run this query on my database, I get the same error:
select * from APP_USER
ERROR: relation "app_user" does not exist
LINE 1: select * from APP_USER
^
********** Error **********
ERROR: relation "app_user" does not exist
SQL state: 42P01
But if I change that to:
select * from "APP_USER"
It works.
How can I configure that on my spring boot app?
dependencies in pom.xml:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-actuator</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.thymeleaf.extras</groupId>
<artifactId>thymeleaf-extras-tiles2</artifactId>
<version>2.1.1.RELEASE</version>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>9.4-1201-jdbc41</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
application.properties:
spring.datasource.driverClassName=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost:5432/boek
spring.datasource.username=postgres
spring.datasource.password=ABCD123$
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.generate-ddl=false
#spring.jpa.hibernate.ddl-auto=create
spring.jpa.show-sql=true
My entity:
@Entity
@Table(name = "APP_USER")
public class User implements Serializable {
private static final long serialVersionUID = -1152779434213289790L;
@Id
@Column(name="ID", nullable = false, updatable = false)
@GeneratedValue(strategy=GenerationType.AUTO)
private long id;
@Column(name="NAME", nullable = false)
private String name;
@Column(name="USER_NAME", nullable = false, unique = true)
private String username;
@Column(name="PASSWORD", nullable = false)
private String password;
@Column(name="EMAIL", nullable = false, unique = true)
private String email;
@Column(name="ROLE", nullable = false)
private RoleEnum role;
I’m calling this action from a form:
<form role="form" action="#" th:action="@{/user/create}" th:object="${userDTO}" method="post">
and this is my controller:
@RequestMapping(value = "/user/create", method = RequestMethod.POST)
public String handleUserCreateForm(@Valid @ModelAttribute("form") UserDTO form, BindingResult bindingResult) {
if (bindingResult.hasErrors()) {
return "user_create";
}
try {
userService.create(form);
} catch (DataIntegrityViolationException e) {
bindingResult.reject("email.exists", "Email already exists");
return "user_create";
}
return "redirect:/users";
}
The validator that cath the error:
private void validateEmail(Errors errors, UserDTO form) {
if (userService.getUserByEmail(form.getEmail()).isPresent()) {
errors.reject("email.exists", "User with this email already exists");
}
}
UserServiceImpl (@Service):
@Override
public Optional<User> getUserByEmail(String email) {
return userRepository.findOneByEmail(email);
}
And the repository is a CrudRepository interface, and have no implementation:
@Repository
public interface UserRepository extends CrudRepository<User, Serializable> {
Optional<User> findOneByEmail(String email);
}
And debuging the validator I could get this stack:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:238)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:221)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:122)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy75.findOneByEmail(Unknown Source)
at com.myapp.service.impl.UserServiceImpl.getUserByEmail(UserServiceImpl.java:32)
at com.myapp.model.validator.UserValidator.validateEmail(UserValidator.java:40)
at com.myapp.model.validator.UserValidator.validate(UserValidator.java:30)
at org.springframework.validation.DataBinder.validate(DataBinder.java:785)
at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.validateIfApplicable(ModelAttributeMethodProcessor.java:164)
at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.resolveArgument(ModelAttributeMethodProcessor.java:111)
at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:77)
at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:162)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:129)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.boot.actuate.autoconfigure.EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal(EndpointWebMvcAutoConfiguration.java:295)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:102)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:57)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:68)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
at org.hibernate.loader.Loader.doQuery(Loader.java:910)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
at org.hibernate.loader.Loader.doList(Loader.java:2554)
at org.hibernate.loader.Loader.doList(Loader.java:2540)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
at org.hibernate.loader.Loader.list(Loader.java:2365)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
at org.hibernate.jpa.criteria.compile.CriteriaQueryTypeQueryAdapter.getSingleResult(CriteriaQueryTypeQueryAdapter.java:71)
at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:202)
at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:74)
at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:99)
at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:90)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:415)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:393)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$DefaultMethodInvokingMethodInterceptor.invoke(RepositoryFactorySupport.java:506)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
... 98 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "app_user" does not exist
Posição: 177
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
... 129 more
Thanks for the help!
Хочу просто вывести из таблицы users_id колонку id вот таким образом
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select id from users_id");
while(rs.next()){
System.out.println(rs.getString("contry_id")+", "+rs.getString("country_name"));ОШИБКА:org.postgresql.util.PSQLException: ОШИБКА: отношение «users_id» не существует
Вот скрин шот что все тблицы существуют 
For some strange reason hibernate generated query not working with postgres, it tells it cannot find relation/table even though there is valid table film_actor in dvdrental schema? This answer did not help.
Exception:
org.postgresql.util.PSQLException : ERROR : relation "dvdrental.film_actor" does NOT exist PreparedStatement.executeQuery () FAILED !
HQL
Query searchQuery = session.createQuery("select film from Film as film " +
"inner join film.actors as a " +
"inner join film.categories as c " +
"where c.categoryId=:categoryId " +
"and film.language.id=:languageId " +
"and film.releaseYear=:releaseYear " +
"and a.actorId=:actorId");
Generated SQL
SELECT
film0_.film_id AS film_id1_8_,
film0_.description AS descript2_8_,
film0_.language_id AS languag12_8_,
film0_.last_update AS last_upd3_8_,
film0_. LENGTH AS length4_8_,
film0_.rating AS rating5_8_,
film0_.release_year AS release_6_8_,
film0_.rental_duration AS rental_d7_8_,
film0_.rental_rate AS rental_r8_8_,
film0_.replacement_cost AS replacem9_8_,
film0_.special_features AS special10_8_,
film0_.title AS title11_8_
FROM
dvdrental. PUBLIC .film film0_
INNER JOIN dvdrental.film_actor actors1_ ON film0_.film_id = actors1_.film_id
INNER JOIN dvdrental. PUBLIC .actor actor2_ ON actors1_.actor_id = actor2_.actor_id
INNER JOIN dvdrental.film_category categories3_ ON film0_.film_id = categories3_.film_id
INNER JOIN dvdrental. PUBLIC .category category4_ ON categories3_.category_id = category4_.category_id
WHERE
category4_.category_id = 1
AND film0_.language_id = 1
AND film0_.release_year = 2016
AND actor2_.actor_id = 2;
This query works fine:
SELECT
*
FROM
film f
INNER JOIN film_actor fa ON f.film_id = fa.film_id
LIMIT 100;
The Film entity annotation based mapping:
@ManyToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
@JoinTable(name = "film_actor", catalog = "dvdrental", joinColumns = {
@JoinColumn(name = "film_id", nullable = false, updatable = false) },
inverseJoinColumns = { @JoinColumn(name = "actor_id",
nullable = false, updatable = false) })
public Set<Actor> getActors() {
return actors;
}
public void setActors(Set<Actor> actors) {
this.actors = actors;
}
Solution/Hack:
After commenting /*catalog = "dvdrental"*/ the problem went away.
Thanks people,
And @arvindsv , Here is the results of running the above commands:
java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql ‘SELECT * FROM changelog’
1 | DDL | 2011-02-01 10:01:56.831 | 2011-02-01 10:01:56.906 | SA | 1_create_initial_tables.sql
2 | DDL | 2011-02-01 10:01:56.907 | 2011-02-01 10:01:56.913 | SA | 2_create_indexes.sql
3 | DDL | 2011-02-01 10:01:56.914 | 2011-02-01 10:01:56.942 | SA | 3_add_build_ignored_column.sql
4 | DDL | 2011-02-01 10:01:56.942 | 2011-02-01 10:01:56.951 | SA | 4_add_check_externals_column.sql
5 | DDL | 2011-02-01 10:01:56.952 | 2011-02-01 10:01:56.963 | SA | 5_add_from_external_column.sql
6 | DDL | 2011-02-01 10:01:56.964 | 2011-02-01 10:01:56.979 | SA | 6_add_pipeline_label.sql
7 | DDL | 2011-02-01 10:01:56.98 | 2011-02-01 10:01:56.983 | SA | 7_add_pipeline_label_counters.sql
8 | DDL | 2011-02-01 10:01:56.984 | 2011-02-01 10:01:56.987 | SA | 8_add_build_cause_buffer.sql
9 | DDL | 2011-02-01 10:01:56.988 | 2011-02-01 10:01:56.992 | SA | 9_add_material_properties_table.sql
10 | DDL | 2011-02-01 10:01:56.993 | 2011-02-01 10:01:57.004 | SA | 10_add_stage_timestamp.sql
11 | DDL | 2011-02-01 10:01:57.005 | 2011-02-01 10:01:57.016 | SA | 11_add_stage_order.sql
12 | DDL | 2011-02-01 10:01:57.016 | 2011-02-01 10:01:57.031 | SA | 12_add_stage_result.sql
13 | DDL | 2011-02-01 10:01:57.032 | 2011-02-01 10:01:57.043 | SA | 13_add_stage_approvalType.sql
14 | DDL | 2011-02-01 10:01:57.044 | 2011-02-01 10:01:57.045 | SA | 14_add_name_pipelineId_index_for_stages.sql
15 | DDL | 2011-02-01 10:01:57.046 | 2011-02-01 10:01:57.047 | SA | 15_add_name_agentId_buildid_index_for_builds.sql
16 | DDL | 2011-02-01 10:01:57.048 | 2011-02-01 10:01:57.056 | SA | 16_add_folder_to_materials.sql
17 | DDL | 2011-02-01 10:01:57.057 | 2011-02-01 10:01:57.061 | SA | 17_correct_integrity_issues_in_stages.sql
18 | DDL | 2011-02-01 10:01:57.062 | 2011-02-01 10:01:57.07 | SA | 18_change_material_properties_value_to_nvarchar.sql
19 | DDL | 2011-02-01 10:01:57.071 | 2011-02-01 10:01:57.078 | SA | 19_change_material_url_to_nvarchar.sql
20 | DDL | 2011-02-01 10:01:57.079 | 2011-02-01 10:01:57.082 | SA | 20_add_artifact_properties_generator_table.sql
21 | DDL | 2011-02-01 10:01:57.083 | 2011-02-01 10:01:57.095 | SA | 21_add_materialId_to_modifications.sql
22 | DDL | 2011-02-01 10:01:57.096 | 2011-02-01 10:01:57.105 | SA | 22_remove_pipelineId_from_modifications.sql
23 | DDL | 2011-02-01 10:01:57.106 | 2011-02-01 10:01:57.118 | SA | 23_add_index_for_stages.sql
24 | DDL | 2011-02-01 10:01:57.119 | 2011-02-01 10:01:57.136 | SA | 24_add_columns_for_dependency_materials.sql
25 | DDL | 2011-02-01 10:01:57.137 | 2011-02-01 10:01:57.145 | SA | 25_change_length_of_revision_to_1024_for_modifications.sql
26 | DDL | 2011-02-01 10:01:57.146 | 2011-02-01 10:01:57.147 | SA | 26_add_table_fetch_artifact_plans.sql
27 | DDL | 2011-02-01 10:01:57.148 | 2011-02-01 10:01:57.152 | SA | 27_set_not_null_on_fetch_artifact_plans.sql
28 | DDL | 2011-02-01 10:01:57.153 | 2011-02-01 10:01:57.155 | SA | 28_drop_table_fetch_artifacts.sql
29 | DDL | 2011-02-01 10:01:57.156 | 2011-02-01 10:01:57.197 | SA | 29_fix_hsqldb_migration.sql
30 | DDL | 2011-02-01 10:01:57.198 | 2011-02-01 10:01:57.206 | SA | 30_add_buildcause_message_to_pipeline.sql
31 | DDL | 2011-02-01 10:01:57.206 | 2011-02-01 10:01:57.208 | SA | 31_add_user_setting.sql
32 | DDL | 2011-02-01 10:01:57.209 | 2011-02-01 10:01:57.213 | SA | 32_add_email_me_column.sql
33 | DDL | 2011-02-01 10:01:57.214 | 2011-02-01 10:01:57.215 | SA | 33_add_unique_constraint_to_name_column_on_usersettings.sql
34 | DDL | 2011-02-01 10:01:57.216 | 2011-02-01 10:01:57.224 | SA | 34_add_changed_column_to_modifications.sql
35 | DDL | 2011-02-01 10:01:57.225 | 2011-02-01 10:01:57.227 | SA | 35_rename_usersettings_table.sql
36 | DDL | 2011-02-01 10:01:57.227 | 2011-02-01 10:01:57.231 | SA | 36_add_notificationfilters_table.sql
37 | DDL | 2011-02-01 10:01:57.233 | 2011-02-01 10:01:57.234 | SA | 37_make_the_pipeline_name_case_insensitive.sql
38 | DDL | 2011-02-01 10:01:57.235 | 2011-02-01 10:01:57.235 | SA | 38_make_the_stage_name_case_insensitive.sql
39 | DDL | 2011-02-01 10:01:57.236 | 2011-02-01 10:01:57.237 | SA | 39_make_the_job_name_case_insensitive.sql
40 | DDL | 2011-02-01 10:01:57.238 | 2011-02-01 10:01:57.238 | SA | 40_undo_pipelines_case_insensitive_change.sql
41 | DDL | 2011-02-01 10:01:57.239 | 2011-02-01 10:01:57.24 | SA | 41_add_builds_index_on_name_state_and_stageid.sql
42 | DDL | 2011-02-01 10:01:57.241 | 2011-02-01 10:01:57.249 | SA | 42_add_counter_to_pipelines.sql
43 | DDL | 2011-02-01 10:01:57.249 | 2011-02-01 10:01:57.255 | SA | 43_alter_modifiedFiles_fileName.sql
44 | DDL | 2011-02-01 10:01:57.256 | 2011-02-01 10:01:57.263 | SA | 44_added_name_column_into_material.sql
45 | DDL | 2011-02-01 10:01:57.264 | 2011-02-01 10:01:57.281 | SA | 45_remove_matcher_from_builds.sql
46 | DDL | 2011-02-01 10:01:57.281 | 2011-02-01 10:01:57.314 | SA | 46_remove_material_properties.sql
47 | DDL | 2011-02-01 10:01:57.315 | 2011-02-01 10:01:57.414 | SA | 47_create_new_materials.sql
48 | DDL | 2011-02-01 10:01:57.415 | 2011-02-01 10:01:57.422 | SA | 48_add_name_to_material_instance.sql
49 | DDL | 2011-02-01 10:01:57.423 | 2011-02-01 10:01:57.424 | SA | 49_add_unique_constraint_to_revisions.sql
50 | DDL | 2011-02-01 10:01:57.425 | 2011-02-01 10:01:57.441 | SA | 50_add_run_on_all_agents_to_builds.sql
51 | DDL | 2011-02-01 10:01:57.442 | 2011-02-01 10:01:57.443 | SA | 51_add_environment_variable_properties.sql
52 | DDL | 2011-02-01 10:01:57.444 | 2011-02-01 10:01:57.452 | SA | 52_add_pipeline_lock.sql
53 | DDL | 2011-02-01 10:01:57.453 | 2011-02-01 10:01:57.454 | SA | 53_add_index_on_pipelines_locked.sql
54 | DDL | 2011-02-01 10:01:57.455 | 2011-02-01 10:01:57.464 | SA | 54_add_stage_id_to_build_transitions.sql
55 | DDL | 2011-02-01 10:01:57.465 | 2011-02-01 10:01:57.478 | SA | 55_add_completed_at_transition_id_to_stages.sql
56 | DDL | 2011-02-01 10:01:57.479 | 2011-02-01 10:01:57.48 | SA | 56_create_index_on_environment_variables_job_id.sql
57 | DDL | 2011-02-01 10:01:57.481 | 2011-02-01 10:01:57.493 | SA | 57_add_state_to_stage.sql
58 | DDL | 2011-02-01 10:01:57.494 | 2011-02-01 10:01:57.503 | SA | 58_add_natural_order_to_pipelines.sql
59 | DDL | 2011-02-01 10:01:57.504 | 2011-02-01 10:01:57.505 | SA | 59_create_index_on_stages_state.sql
60 | DDL | 2011-02-01 10:01:57.506 | 2011-02-01 10:01:57.512 | SA | 60_support_for_variables_at_different_levels.sql
61 | DDL | 2011-02-01 10:01:57.513 | 2011-02-01 10:01:57.532 | SA | 61_migrate_old_pipelines_to_have_counter.sql
62 | DDL | 2011-02-01 10:01:57.532 | 2011-02-01 10:01:57.64 | SA | 62_migrate_dependency_modifications_to_use_pipeline_counter_based_stage_locator.sql
63 | DDL | 2011-02-01 10:01:57.641 | 2011-02-01 10:01:57.653 | SA | 63_add_schedule_to_and_from_revisions.sql
64 | DDL | 2011-02-01 10:01:57.654 | 2011-02-01 10:01:57.698 | SA | 64_populate_missing_pipeline_label_in_modifications.sql
65 | DDL | 2011-02-01 10:01:57.699 | 2011-02-01 10:01:57.711 | SA | 65_repoint_FROM_to_TO_for_dependency_pmr.sql
66 | DDL | 2011-02-01 10:01:57.712 | 2011-02-01 10:01:57.721 | SA | 66_remove_schedule_to_and_from_revisions.sql
67 | DDL | 2011-02-01 10:01:57.722 | 2011-02-01 10:01:57.723 | SA | 67_create_pipeline_selections_table.sql
68 | DDL | 2011-02-01 10:01:57.724 | 2011-02-01 10:01:57.725 | SA | 68_add_foreign_key_from_pmr_to_pipeline.sql
69 | DDL | 2011-02-01 10:01:57.726 | 2011-02-01 10:01:57.727 | SA | 69_create_index_on_builds_name_and_stage_id.sql
70 | DDL | 2011-02-01 10:01:57.728 | 2011-02-01 10:01:57.747 | SA | 70_change_pipeline_stage_and_job_name_to_varchar_ignorecase.sql
71 | DDL | 2011-02-01 10:01:57.748 | 2011-02-01 10:01:57.757 | SA | 71_add_latest_run_flag_on_stage.sql
72 | DDL | 2011-02-01 10:01:57.758 | 2011-02-01 10:01:57.761 | SA | 72_create_builds_view.sql
73 | DDL | 2011-02-01 10:01:57.761 | 2011-02-01 10:01:57.763 | SA | 73_create_stages_view.sql
74 | DDL | 2011-02-01 10:01:57.764 | 2011-02-01 10:01:57.765 | SA | 74_add_unique_constraint_for_stages_on_pipelineId_name_counter.sql
75 | DDL | 2011-02-01 10:01:57.766 | 2011-02-01 10:01:57.767 | SA | 75_create_agent_cookie_mapping_table.sql
76 | DDL | 2011-02-01 10:01:57.768 | 2011-02-01 10:01:57.774 | SA | 76_create_oauth_tables.sql
77 | DDL | 2011-02-01 10:01:57.775 | 2011-02-01 10:01:57.779 | SA | 77_add_enabled_to_users.sql
78 | DDL | 2011-02-01 10:01:57.779 | 2011-02-01 10:01:57.791 | SA | 78_add_fetchMaterials_to_stages.sql
79 | DDL | 2011-02-01 10:01:57.791 | 2011-02-01 10:01:57.796 | SA | 79_recreate_build_and_stages_views.sql
80 | DDL | 2011-02-01 10:01:57.796 | 2011-02-01 10:01:57.807 | SA | 80_add_cleanWorkingDir_to_stages.sql
81 | DDL | 2011-02-01 10:01:57.808 | 2011-02-01 10:01:57.812 | SA | 81_recreate_build_and_stages_views.sql
82 | DDL | 2011-02-01 10:01:57.813 | 2011-02-01 10:01:57.814 | SA | 82_make_oauth_client_names_unique.sql
83 | DDL | 2011-02-01 10:01:57.815 | 2011-02-01 10:01:57.82 | SA | 83_create_gadget_oauth_tables.sql
84 | DDL | 2011-02-01 10:01:57.821 | 2011-02-01 10:01:57.828 | SA | 84_add_pipelineId_to_modifications.sql
85 | DDL | 2011-02-01 10:01:57.829 | 2011-02-01 10:01:57.834 | SA | 85_add_materialId_to_pipelineMaterialRevisions.sql
86 | DDL | 2016-03-16 15:20:46.178 | 2016-03-16 15:20:46.338 | SA | 86_add_actual_from_revision_to_pmr.sql
87 | DDL | 2016-03-16 15:20:46.341 | 2016-03-16 15:20:46.344 | SA | 87_create_index_modifications_materialId.sql
88 | DDL | 2016-03-16 15:20:46.346 | 2016-03-16 15:20:46.529 | SA | 88_rerun_to_actual_job_mapping.sql
89 | DDL | 2016-03-16 15:20:46.531 | 2016-03-16 15:20:46.619 | SA | 89_adding_rerun_of_counter_for_rerun_job_stages.sql
90 | DDL | 2016-03-16 15:20:46.62 | 2016-03-16 15:20:46.654 | SA | 90_populate_missing_completed_at_transition_id.sql
221001 | DDL | 2016-03-16 15:20:46.656 | 2016-03-16 15:20:46.675 | SA | 221001_fix_incomplete_stages_and_jobs.sql
230001 | DDL | 2016-03-16 15:20:46.677 | 2016-03-16 15:20:46.733 | SA | 230001_add_column_artifacts_deleted_to_stage.sql
230002 | DDL | 2016-03-16 15:20:46.735 | 2016-03-16 15:20:46.751 | SA | 230002_populate_missing_completed_by_transition_id.sql
230003 | DDL | 2016-03-16 15:20:46.753 | 2016-03-16 15:20:46.773 | SA | 230003_stop_persisting_material_password.sql
230004 | DDL | 2016-03-16 15:20:46.775 | 2016-03-16 15:20:46.815 | SA | 230004_add_config_version_to_stage.sql
230005 | DDL | 2016-03-16 15:20:46.817 | 2016-03-16 15:20:46.82 | SA | 230005_add_index_bst_buildid_currentstate.sql
230006 | DDL | 2016-03-16 15:20:46.822 | 2016-03-16 15:20:46.873 | SA | 230006_make_user_name_case_insensitive.sql
230007 | DDL | 2016-03-16 15:20:46.875 | 2016-03-16 15:20:46.914 | SA | 230007_add_completed_time_on_job_and_stage.sql
230008 | DDL | 2016-03-16 15:20:46.916 | 2016-03-16 15:20:46.918 | SA | 230008_drop_unique_revisions_for_material_constraint.sql
230009 | DDL | 2016-03-16 15:20:46.92 | 2016-03-16 15:20:46.923 | SA | 230009_update_git_material_with_null_branch_to_use_branch_master.sql
240001 | DDL | 2016-03-16 15:20:46.925 | 2016-03-16 15:20:46.933 | SA | 240001_add_userid_column_to_pipelineselections.sql
240002 | DDL | 2016-03-16 15:20:46.934 | 2016-03-16 15:20:46.945 | SA | 240002_add_disableLicenseExpiryWarning_to_users.sql
300001 | DDL | 2016-03-16 15:20:46.946 | 2016-03-16 15:20:46.949 | SA | 300001_add_serverBackup_table.sql
300002 | DDL | 2016-03-16 15:20:46.95 | 2016-03-16 15:20:46.97 | SA | 300002_add_pause_info_column.sql
300003 | DDL | 2016-03-16 15:20:46.972 | 2016-03-16 15:20:46.983 | SA | 300003_add_serveralias_column_to_material_instance.sql
300004 | DDL | 2016-03-16 15:20:46.985 | 2016-03-16 15:20:46.988 | SA | 300004_create_luau_state_table.sql
300005 | DDL | 2016-03-16 15:20:46.989 | 2016-03-16 15:20:46.995 | SA | 300005_drop_auth_state_column_from_luau_state.sql
300006 | DDL | 2016-03-16 15:20:46.996 | 2016-03-16 15:20:47.03 | SA | 300006_add_tfs_material_attributes.sql
300007 | DDL | 2016-03-16 15:20:47.032 | 2016-03-16 15:20:47.042 | SA | 300007_add_display_name_column_to_users.sql
300008 | DDL | 2016-03-16 15:20:47.044 | 2016-03-16 15:20:47.05 | SA | 300008_create_luau_groups.sql
300009 | DDL | 2016-03-16 15:20:47.051 | 2016-03-16 15:20:47.059 | SA | 300009_add_secure_column_to_environment_variables.sql
300010 | DDL | 2016-03-16 15:20:47.061 | 2016-03-16 15:20:47.066 | SA | 300010_add_column_to_store_last_successful_sync_time.sql
300011 | DDL | 2016-03-16 15:20:47.067 | 2016-03-16 15:20:47.076 | SA | 300011_remove_column_workspace_owner.sql
1202001 | DDL | 2016-03-16 15:20:47.077 | 2016-03-16 15:20:47.078 | SA | 1202001_fix_dependency_material_fingerprint_to_adjust_serveralias.sql
1202002 | DDL | 2016-03-16 15:20:47.079 | 2016-03-16 15:20:47.087 | SA | 1202002_add_domain_column_to_material_instance.sql
1202003 | DDL | 2016-03-16 15:20:47.088 | 2016-03-16 15:20:47.096 | SA | 1202003_remove_ignore_case_from_domain_column_to_material_instance.sql
1203002 | DDL | 2016-03-16 15:20:47.097 | 2016-03-16 15:20:47.105 | SA | 1203002_add_user_column_to_server_backup_table.sql
1203003 | DDL | 2016-03-16 15:20:47.111 | 2016-03-16 15:20:47.112 | SA | 1203003_zap_natural_order_values.sql
1203004 | DDL | 2016-03-16 15:20:47.122 | 2016-03-16 15:20:47.137 | SA | 1203004_kill_remote_dependency_material.sql
1203005 | DDL | 2016-03-16 15:20:47.142 | 2016-03-16 15:20:47.147 | SA | 1203005_add_index_on_modifications_revision.sql
1301001 | DDL | 2016-03-16 15:20:47.148 | 2016-03-16 15:20:47.193 | SA | 1301001_drop_build_event_column_from_builds.sql
1302001 | DDL | 2016-03-16 15:20:47.194 | 2016-03-16 15:20:47.209 | SA | 1302001_add_configuration_field_to_materials_table.sql
1303001 | DDL | 2016-03-16 15:20:47.21 | 2016-03-16 15:20:47.219 | SA | 1303001_add_additional_data_field_to_modifications_table.sql
1303002 | DDL | 2016-03-16 15:20:47.22 | 2016-03-16 15:20:47.221 | SA | 1303002_add_index_to_builds_on_stageId.sql
1303003 | DDL | 2016-03-16 15:20:47.221 | 2016-03-16 15:20:47.222 | SA | 1303003_add_index_to_stages_resources_tables.sql
1303004 | DDL | 2016-03-16 15:20:47.223 | 2016-03-16 15:20:47.225 | SA | 1303004_indexes_based_on_purge_tool.sql
1304001 | DDL | 2016-03-16 15:20:47.225 | 2016-03-16 15:20:47.228 | SA | 1304001_remove_luau_related_entries.sql
1401001 | DDL | 2016-03-16 15:20:47.229 | 2016-03-16 15:20:47.23 | SA | 1401001_recreating_trigger_because_of_cruise_to_go_change.sql
1403001 | DDL | 2016-03-16 15:20:47.231 | 2016-03-16 15:20:47.232 | SA | 1403001_fix_null_artifacttype_on_artifactplans_table.sql
1403002 | DDL | 2016-03-16 15:20:47.233 | 2016-03-16 15:20:47.254 | SA | 1403002_add_runMultipleInstance_column_on_builds_table_recreate_view.sql
1501001 | DDL | 2016-03-16 15:20:47.255 | 2016-03-16 15:20:47.262 | SA | 1501001_rename_pipeline_selections_unselected_pipelines_column_to_selections.sql
1501002 | DDL | 2016-03-16 15:20:47.263 | 2016-03-16 15:20:47.279 | SA | 1501002_add_comment_column_to_pipelines.sql
1501003 | DDL | 2016-03-16 15:20:47.28 | 2016-03-16 15:20:47.29 | SA | 1501003_add_additional_data_field_to_materials_table.sql
1502001 | DDL | 2016-03-16 15:20:47.291 | 2016-03-16 15:20:47.293 | SA | 1502001_create_plugins_table.sql
1503001 | DDL | 2016-03-16 15:20:47.293 | 2016-03-16 15:20:47.302 | SA | 1503001_remove_licensing_from_users.sql
1503002 | DDL | 2016-03-16 15:20:47.303 | 2016-03-16 15:20:47.304 | SA | 1503002_create_version_infos_table.sql
1606001 | DDL | 2017-01-10 22:12:00.185 | 2017-01-10 22:12:09.837 | SA | 1606001_add_index_to_buildstatetransitions.sql
1606002 | DDL | 2017-01-10 22:12:09.839 | 2017-01-10 22:12:09.997 | SA | 1606002_add_index_to_artifactplans.sql
1607001 | DDL | 2017-01-10 22:12:09.998 | 2017-01-10 22:12:10.005 | SA | 1607001_create_agent_metadata_job_table.sql
1610001 | DDL | 2017-01-10 22:12:10.006 | 2017-01-10 22:12:10.009 | SA | 1610001_add_index_to_modifiedfiles.sql
1701001 | DDL | 2017-03-29 20:41:46.921 | 2017-03-29 20:41:46.95 | SA | 1701001_remove_gadget_oauth_tables.sql
1702001 | DDL | 2017-03-29 20:41:46.953 | 2017-03-29 20:41:46.964 | SA | 1702001_remove_build_cause_buffer_table.sql
1704001 | DDL | 2019-02-07 12:42:35.652 | 2019-02-07 12:42:35.658 | SA | 1704001_widen_agents_uuid_column.sql
1704002 | DDL | 2019-02-07 12:42:35.66 | 2019-02-07 12:42:35.671 | SA | 1704002_widen_builds_agent_uuid_column.sql
1704003 | DDL | 2019-02-07 12:42:35.672 | 2019-02-07 12:42:42.865 | SA | 1704003_pipeline_state_table.sql
1708001 | DDL | 2019-02-07 12:42:42.866 | 2019-02-07 12:42:43.505 | SA | 1708001_add_hostname_and_ip_to_agents_table.sql
1801001 | DDL | 2019-02-07 12:42:43.506 | 2019-02-07 12:42:43.513 | SA | 1801001_remove_regex_generator_type_from_artifact_properties_generator.sql
1801002 | DDL | 2019-02-07 12:42:43.514 | 2019-02-07 12:42:43.626 | SA | 1801002_add_pluggable_artifactconfig_json_to_artifact_plans.sql
1801003 | DDL | 2019-02-07 12:42:43.626 | 2019-02-07 12:42:43.627 | SA | 1801003_remove_environment_variables_for_completed_jobs.sql
1801004 | DDL | 2019-02-07 12:42:43.627 | 2019-02-07 12:42:43.627 | SA | 1801004_remove_artifact_plans_for_completed_jobs.sql
1801005 | DDL | 2019-02-07 12:42:43.628 | 2019-02-07 12:42:43.628 | SA | 1801005_remove_artifact_properties_generator_for_completed_jobs.sql
1801006 | DDL | 2019-02-07 12:42:43.628 | 2019-02-07 12:42:43.629 | SA | 1801006_remove_resources_for_completed_jobs.sql
1801007 | DDL | 2019-02-07 12:42:43.629 | 2019-02-07 12:42:43.629 | SA | 1801007_remove_job_agent_metadata_for_completed_jobs.sql
1802001 | DDL | 2019-02-07 12:42:43.63 | 2019-02-07 12:42:44.207 | SA | 1802001_clear_username_and_comment_for_dependency_materials.sql
1802002 | DDL | 2019-02-07 12:42:44.208 | 2019-02-07 12:42:44.75 | SA | 1802002_add_index_on_pipelines_name_and_id_column.sql
1804001 | DDL | 2019-02-07 12:42:44.75 | 2019-02-07 12:42:44.779 | SA | 1804001_add_case_insensitive_pipelinename_column_to_pipelinelabelcounts.sql
1805001 | DDL | 2019-02-07 12:42:44.78 | 2019-02-07 12:42:44.781 | SA | 1805001_drop_preferred_table.sql
1807001 | DDL | 2019-02-07 12:42:44.781 | 2019-02-07 12:42:44.782 | SA | 1807001_data_sharing_settings_table.sql
1807002 | DDL | 2019-02-07 12:42:44.782 | 2019-02-07 12:42:44.788 | SA | 1807002_usage_data_reporting_table.sql
1808001 | DDL | 2019-02-07 12:42:44.788 | 2019-02-07 12:42:44.79 | SA | 1808001_remove_oauth_tables.sql
1808002 | DDL | 2019-02-07 12:42:44.79 | 2019-02-07 12:42:44.81 | SA | 1808002_add_filters_and_version_to_pipeline_selections.sql
1901001 | DDL | 2019-02-21 13:17:19.94 | 2019-02-21 13:18:08.171 | SA | 1901001_add_cancelled_by_to_stages_table.sql
1902001 | DDL | 2020-05-14 11:14:13.194 | 2020-05-14 11:14:13.699 | SA | 1902001_add_paused_at_to_pipeline_label_counts.sql
1902002 | DDL | 2020-05-14 11:14:13.701 | 2020-05-14 11:14:13.711 | SA | 1902002_add_access_token.sql
1902003 | DDL | 2020-05-14 11:14:13.714 | 2020-05-14 11:14:13.736 | SA | 1902003_add_revoke_cause_to_access_tokens.sql
1902004 | DDL | 2020-05-14 11:14:13.738 | 2020-05-14 11:14:13.758 | SA | 1902004_add_revoked_by_to_access_tokens.sql
1902005 | DDL | 2020-05-14 11:14:13.766 | 2020-05-14 11:14:13.78 | SA | 1902005_remove_name_from_access_tokens.sql
1902006 | DDL | 2020-05-14 11:14:13.781 | 2020-05-14 11:14:13.799 | SA | 1902006_access_token_description.sql
1902007 | DDL | 2020-05-14 11:14:13.8 | 2020-05-14 11:14:13.815 | SA | 1902007_add_soft_delete_to_access_token.sql
1902008 | DDL | 2020-05-14 11:14:13.816 | 2020-05-14 11:14:13.829 | SA | 1902008_rename_is_revoked_to_revoke_in_access_token.sql
1903001 | DDL | 2020-05-14 11:14:13.83 | 2020-05-14 11:14:14.851 | SA | 1903001_add_status_and_message_to_server_backup.sql
1903002 | DDL | 2020-05-14 11:14:14.852 | 2020-05-14 11:14:14.911 | SA | 1903002_add_cluster_profile_on_job_agent_metadata.sql
1903003 | DDL | 2020-05-14 11:14:14.911 | 2020-05-14 11:14:14.953 | SA | 1903003_add_progress_status_to_server_backup.sql
1909001 | DDL | 2020-05-14 11:14:14.953 | 2020-05-14 11:14:33.383 | SA | 1909001_update_agents_table.sql
1910001 | DDL | 2020-05-14 11:14:33.383 | null | SA | 1910001_drop_properties_table.sql
1910002 | DDL | 2020-05-14 11:22:38.541 | 2020-05-14 11:22:38.552 | SA | 1910002_drop_artifact_properties_generator_table.sql
1910003 | DDL | 2020-05-14 11:22:38.554 | 2020-05-14 11:47:33.953 | SA | 1910003_remove_environment_variables_for_completed_jobs.sql
1910004 | DDL | 2020-05-14 11:47:33.955 | 2020-05-14 11:51:30.328 | SA | 1910004_remove_artifact_plans_for_completed_jobs.sql
1910005 | DDL | 2020-05-14 11:51:30.328 | 2020-05-14 11:51:33.47 | SA | 1910005_remove_resources_for_completed_jobs.sql
1910006 | DDL | 2020-05-14 11:51:33.471 | 2020-05-14 11:51:35.46 | SA | 1910006_remove_job_agent_metadata_for_completed_jobs.sql
(180 rows, 14 ms)
java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql ‘SELECT * FROM information_schema.sequences’
CRUISE | PUBLIC | SYSTEM_SEQUENCE_5905FFA4_C3D4_4193_8B52_666552039E7C | 270432 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 15
CRUISE | PUBLIC | SYSTEM_SEQUENCE_859B5F93_EBC9_4F88_B114_BAF2E20B6934 | 328629 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 153
CRUISE | PUBLIC | SYSTEM_SEQUENCE_FDC5201C_9B59_4624_825A_88685D212FAE | 7317580 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 99
CRUISE | PUBLIC | SYSTEM_SEQUENCE_B878C2EE_959E_4F1A_8F4F_3AA8D316D9F3 | 973 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 13
CRUISE | PUBLIC | SYSTEM_SEQUENCE_D44D740B_D094_449B_880B_B1275F6EFBEE | 9674448 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 33
CRUISE | PUBLIC | SYSTEM_SEQUENCE_7E59D9C7_83A0_40F2_92A9_DECE05129B89 | 1 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 161
CRUISE | PUBLIC | SYSTEM_SEQUENCE_99F415B6_76F0_4856_9A1F_537A8C905669 | 749 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 12
CRUISE | PUBLIC | SYSTEM_SEQUENCE_1F27F84E_AFFC_41FD_A479_7AE38356566D | 219 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 71
CRUISE | PUBLIC | SYSTEM_SEQUENCE_3700FBB3_9951_4C74_B249_BAAB0E0EDE68 | 1347 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 67
CRUISE | PUBLIC | SYSTEM_SEQUENCE_DE3EC304_8573_4030_B280_2FE345E2717A | 29254 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 40
CRUISE | PUBLIC | SYSTEM_SEQUENCE_6221BF74_8932_4361_BBDA_5CCE5A324FF5 | 1 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 166
CRUISE | PUBLIC | SYSTEM_SEQUENCE_6B20E7FB_05C9_4875_8E5D_741CF3DF0F4F | 2574 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 182
CRUISE | PUBLIC | SYSTEM_SEQUENCE_F6C2459B_D4A1_43B7_B85E_54DC3C3D129E | 258 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 55
CRUISE | PUBLIC | SYSTEM_SEQUENCE_6B7E1695_E79C_4675_B07A_5DE43C9223A0 | 792084 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 27
CRUISE | PUBLIC | SYSTEM_SEQUENCE_8811DC19_1147_46DD_9670_C2A9AF425FE2 | 161707 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 11
CRUISE | PUBLIC | SYSTEM_SEQUENCE_2548E279_7269_47A4_981A_55F4C7AD2A1B | 5 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 32
CRUISE | PUBLIC | SYSTEM_SEQUENCE_F8A69B86_705E_40B2_BABC_97A0ABD6B54B | 0 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 43
CRUISE | PUBLIC | SYSTEM_SEQUENCE_DD533966_D2B7_4355_9CE4_131F7111F9E2 | 67858 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 52
CRUISE | PUBLIC | SYSTEM_SEQUENCE_B8B92BF5_C569_4B0F_8E1C_9F0305078FD6 | 7672 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 46
CRUISE | PUBLIC | SYSTEM_SEQUENCE_D1229517_4596_4AEB_B211_1FF03C966396 | 4654949 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 64
CRUISE | PUBLIC | SYSTEM_SEQUENCE_AD7EB9A5_62CF_4D77_BE81_48B2FD2FBF20 | 2 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 127
CRUISE | PUBLIC | SYSTEM_SEQUENCE_6C1CFB3E_06B1_49F3_8E42_5D580B5259B1 | 180950 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 58
CRUISE | PUBLIC | SYSTEM_SEQUENCE_82CF0044_4B25_4EF0_93D5_7FA28F6441D8 | 1723 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 176
CRUISE | PUBLIC | SYSTEM_SEQUENCE_2DA6D80A_0B48_40B1_AD44_235FB0263598 | 2327072 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 31
CRUISE | PUBLIC | SYSTEM_SEQUENCE_2A717171_A53D_4A9B_A04F_35AFBC2310A9 | 32 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 235
CRUISE | PUBLIC | SYSTEM_SEQUENCE_2C0FAF5B_CAA8_4013_A8B2_7FF9D3DD9FDA | 307 | 1 | TRUE | | 32 | 1 | 9223372036854775807 | FALSE | 210
(26 rows, 1 ms)
java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql ‘SELECT * FROM information_schema.indexes’
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_NAME | ORDINAL_POSITION | COLUMN_NAME | CARDINALITY | PRIMARY_KEY | INDEX_TYPE_NAME | IS_GENERATED | INDEX_TYPE | ASC_OR_DESC | PAGES | FILTER_CONDITION | REMARKS | SQL | ID | SORT_TYPE | CONSTRAINT_NAME | INDEX_CLASS | AFFINITY
CRUISE | PUBLIC | MODIFIEDFILES | TRUE | FK_MODIFIEDFILES_MODIFICATIONS_INDEX_3 | 1 | MODIFICATIONID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_MODIFIEDFILES_MODIFICATIONS_INDEX_3" ON "PUBLIC"."MODIFIEDFILES"("MODIFICA | 86 | 0 | FK_MODIFIEDFILES_MODIFICATIONS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFIEDFILES | FALSE | PRIMARY_KEY_8783C | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8783C" ON "PUBLIC"."MODIFIEDFILES"("ID") | 132 | 0 | CONSTRAINT_3 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PROPERTIES | FALSE | PRIMARY_KEY_E | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_E" ON "PUBLIC"."PROPERTIES"("ID") | 35 | 0 | CONSTRAINT_E | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PROPERTIES | FALSE | CONSTRAINT_INDEX_E | 1 | BUILDID | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_E" ON "PUBLIC"."PROPERTIES"("BUILDID", "KEY") | 37 | 0 | CONSTRAINT_E5 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PROPERTIES | FALSE | CONSTRAINT_INDEX_E | 2 | KEY | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_E" ON "PUBLIC"."PROPERTIES"("BUILDID", "KEY") | 37 | 0 | CONSTRAINT_E5 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PROPERTIES | TRUE | IDX_PROPERTIES_KEY | 1 | KEY | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PROPERTIES_KEY" ON "PUBLIC"."PROPERTIES"("KEY") | 72 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PROPERTIES | TRUE | IDX_PROPERTIES_BUILDID | 1 | BUILDID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PROPERTIES_BUILDID" ON "PUBLIC"."PROPERTIES"("BUILDID") | 107 | 0 | FK_PROPERTIES_BUILDS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ACCESSTOKEN | FALSE | PRIMARY_KEY_1 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_1" ON "PUBLIC"."ACCESSTOKEN"("ID") | 205 | 0 | CONSTRAINT_43 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | ACCESSTOKEN | FALSE | CONSTRAINT_43F_INDEX_1 | 1 | VALUE | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_43F_INDEX_1" ON "PUBLIC"."ACCESSTOKEN"("VALUE") | 207 | 0 | CONSTRAINT_43F | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ACCESSTOKEN | FALSE | CONSTRAINT_43F0_INDEX_1 | 1 | SALTID | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_43F0_INDEX_1" ON "PUBLIC"."ACCESSTOKEN"("SALTID") | 209 | 0 | CONSTRAINT_43F0 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ACCESSTOKEN | FALSE | CONSTRAINT_43F05_INDEX_1 | 1 | SALTVALUE | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_43F05_INDEX_1" ON "PUBLIC"."ACCESSTOKEN"("SALTVALUE") | 214 | 0 | CONSTRAINT_43F05 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | DATASHARINGSETTINGS | FALSE | PRIMARY_KEY_7 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_7" ON "PUBLIC"."DATASHARINGSETTINGS"("ID") | 162 | 0 | CONSTRAINT_7D | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PIPELINESTATES | FALSE | PRIMARY_KEY_6 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_6" ON "PUBLIC"."PIPELINESTATES"("ID") | 56 | 0 | CONSTRAINT_6A | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PIPELINESTATES | FALSE | UNIQUE_PIPELINE_STATE_INDEX_6 | 1 | PIPELINENAME | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_STATE_INDEX_6" ON "PUBLIC"."PIPELINESTATES"("PIPELINEN | 59 | 0 | UNIQUE_PIPELINE_STATE | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINELABELCOUNTS | TRUE | IDX_PIPELINELABELCOUNTS_PIPELINENAME | 1 | PIPELINENAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINELABELCOUNTS_PIPELINENAME" ON "PUBLIC"."PIPELINELABELCOUNTS"("PIPE | 101 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINELABELCOUNTS | TRUE | IDX_PIPELINELABELCOUNTS_CASEINSENSITIVEPIPELINENAME | 1 | CASEINSENSITIVEPIPELINENAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINELABELCOUNTS_CASEINSENSITIVEPIPELINENAME" ON "PUBLIC"."PIPELINELAB | 181 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINELABELCOUNTS | FALSE | PRIMARY_KEY_6E | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_6E" ON "PUBLIC"."PIPELINELABELCOUNTS"("ID") | 185 | 0 | CONSTRAINT_C7 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINELABELCOUNTS | FALSE | UNIQUE_PIPELINE_NAME_INDEX_6 | 1 | PIPELINENAME | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_NAME_INDEX_6" ON "PUBLIC"."PIPELINELABELCOUNTS"("PIPEL | 187 | 0 | UNIQUE_PIPELINE_NAME | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | USAGEDATAREPORTING | FALSE | PRIMARY_KEY_3 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_3" ON "PUBLIC"."USAGEDATAREPORTING"("ID") | 167 | 0 | CONSTRAINT_3F | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | ARTIFACTPLANS | TRUE | IDX_ARTIFACTPLAN_BUILD_ID | 1 | BUILDID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_ARTIFACTPLAN_BUILD_ID" ON "PUBLIC"."ARTIFACTPLANS"("BUILDID") | 108 | 0 | FK_ARTIFACTPLANS_BUILDS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ARTIFACTPLANS | FALSE | PRIMARY_KEY_5B | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_5B" ON "PUBLIC"."ARTIFACTPLANS"("ID") | 115 | 0 | CONSTRAINT_E1 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_PIPELINEID | 1 | PIPELINEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_PIPELINEID" ON "PUBLIC"."STAGES"("PIPELINEID") | 68 | 0 | FK_STAGES_PIPELINES | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGE_NAME | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGE_NAME" ON "PUBLIC"."STAGES"("NAME") | 91 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_ORDERID | 1 | ORDERID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_ORDERID" ON "PUBLIC"."STAGES"("ORDERID") | 92 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_NAME_PIPELINEID | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_PIPELINEID" ON "PUBLIC"."STAGES"("NAME", "PIPELINEID") | 93 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_NAME_PIPELINEID | 2 | PIPELINEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_PIPELINEID" ON "PUBLIC"."STAGES"("NAME", "PIPELINEID") | 93 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_COUNTER_INDEX | 1 | COUNTER | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_COUNTER_INDEX" ON "PUBLIC"."STAGES"("COUNTER") | 95 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_COMPLETEDBYTRANSITIONID | 1 | COMPLETEDBYTRANSITIONID | 0 | FALSE | INDEX | FALSE | 3 | D | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_COMPLETEDBYTRANSITIONID" ON "PUBLIC"."STAGES"("COMPLETEDBYTRANSITI | 96 | 1 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_STATE | 1 | STATE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_STATE" ON "PUBLIC"."STAGES"("STATE") | 110 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_NAME_LATESTRUN_RESULT | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_LATESTRUN_RESULT" ON "PUBLIC"."STAGES"("NAME", "LATESTRUN", " | 116 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_NAME_LATESTRUN_RESULT | 2 | LATESTRUN | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_LATESTRUN_RESULT" ON "PUBLIC"."STAGES"("NAME", "LATESTRUN", " | 116 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | TRUE | IDX_STAGES_NAME_LATESTRUN_RESULT | 3 | RESULT | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGES_NAME_LATESTRUN_RESULT" ON "PUBLIC"."STAGES"("NAME", "LATESTRUN", " | 116 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | FALSE | PRIMARY_KEY_5BD | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_5BD" ON "PUBLIC"."STAGES"("ID") | 170 | 0 | CONSTRAINT_9 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | FALSE | UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5 | 1 | PIPELINEID | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5" ON "PUBLIC"."STAGES"("PIPELIN | 173 | 0 | UNIQUE_PIPELINE_ID_NAME_COUNTER | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | FALSE | UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5 | 2 | NAME | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5" ON "PUBLIC"."STAGES"("PIPELIN | 173 | 0 | UNIQUE_PIPELINE_ID_NAME_COUNTER | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGES | FALSE | UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5 | 3 | COUNTER | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_PIPELINE_ID_NAME_COUNTER_INDEX_5" ON "PUBLIC"."STAGES"("PIPELIN | 173 | 0 | UNIQUE_PIPELINE_ID_NAME_COUNTER | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | SERVERBACKUPS | FALSE | PRIMARY_KEY_D | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_D" ON "PUBLIC"."SERVERBACKUPS"("ID") | 45 | 0 | CONSTRAINT_7B | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | VERSIONINFOS | FALSE | PRIMARY_KEY_848 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_848" ON "PUBLIC"."VERSIONINFOS"("ID") | 258 | 0 | CONSTRAINT_848 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | VERSIONINFOS | FALSE | CONSTRAINT_INDEX_84 | 1 | COMPONENTNAME | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_84" ON "PUBLIC"."VERSIONINFOS"("COMPONENTNAME") | 260 | 0 | CONSTRAINT_848D | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | CHANGELOG | FALSE | PRIMARY_KEY_F | 1 | CHANGE_NUMBER | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_F" ON "PUBLIC"."CHANGELOG"("CHANGE_NUMBER", "DELTA_SET") | 9 | 0 | PKCHANGELOG | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | CHANGELOG | FALSE | PRIMARY_KEY_F | 2 | DELTA_SET | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_F" ON "PUBLIC"."CHANGELOG"("CHANGE_NUMBER", "DELTA_SET") | 9 | 0 | PKCHANGELOG | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | RESOURCES | FALSE | PRIMARY_KEY_2 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_2" ON "PUBLIC"."RESOURCES"("ID") | 48 | 0 | CONSTRAINT_2 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | RESOURCES | TRUE | FK_RESOURCES_BUILDS_INDEX_2 | 1 | BUILDID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_RESOURCES_BUILDS_INDEX_2" ON "PUBLIC"."RESOURCES"("BUILDID") | 90 | 0 | FK_RESOURCES_BUILDS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | RESOURCES | TRUE | IDX_RESOURCES_BUILDID | 1 | BUILDID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_RESOURCES_BUILDID" ON "PUBLIC"."RESOURCES"("BUILDID") | 103 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | NOTIFICATIONFILTERS | FALSE | PRIMARY_KEY_5 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_5" ON "PUBLIC"."NOTIFICATIONFILTERS"("ID") | 104 | 0 | CONSTRAINT_5 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | NOTIFICATIONFILTERS | TRUE | FK_NOTIFICATIONFILTERS_USERS_INDEX_5 | 1 | USERID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_NOTIFICATIONFILTERS_USERS_INDEX_5" ON "PUBLIC"."NOTIFICATIONFILTERS"("USER | 111 | 0 | FK_NOTIFICATIONFILTERS_USERS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILD_STATE | 1 | STATE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILD_STATE" ON "PUBLIC"."BUILDS"("STATE") | 157 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILD_NAME | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILD_NAME" ON "PUBLIC"."BUILDS"("NAME") | 158 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILD_RESULT | 1 | RESULT | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILD_RESULT" ON "PUBLIC"."BUILDS"("RESULT") | 194 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILD_AGENT | 1 | AGENTUUID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILD_AGENT" ON "PUBLIC"."BUILDS"("AGENTUUID") | 195 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILD_IGNORED | 1 | IGNORED | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILD_IGNORED" ON "PUBLIC"."BUILDS"("IGNORED") | 196 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_AGENTID_STAGEID_NAME | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_AGENTID_STAGEID_NAME | 2 | AGENTUUID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_AGENTID_STAGEID_NAME | 3 | STAGEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_AGENTID_STAGEID_NAME | 4 | STATE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_AGENTID_STAGEID_NAME | 5 | RESULT | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_AGENTID_STAGEID_NAME" ON "PUBLIC"."BUILDS"("NAME", "AGENTUUID", "S | 197 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_NAME_STATE_STAGEID | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STATE_STAGEID" ON "PUBLIC"."BUILDS"("NAME", "STATE", "STAGEID | 198 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_NAME_STATE_STAGEID | 2 | STATE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STATE_STAGEID" ON "PUBLIC"."BUILDS"("NAME", "STATE", "STAGEID | 198 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_NAME_STATE_STAGEID | 3 | STAGEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STATE_STAGEID" ON "PUBLIC"."BUILDS"("NAME", "STATE", "STAGEID | 198 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_NAME_STAGE_ID | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STAGE_ID" ON "PUBLIC"."BUILDS"("NAME", "STAGEID") | 199 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_NAME_STAGE_ID | 2 | STAGEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_NAME_STAGE_ID" ON "PUBLIC"."BUILDS"("NAME", "STAGEID") | 199 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | TRUE | IDX_BUILDS_STAGEID | 1 | STAGEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDS_STAGEID" ON "PUBLIC"."BUILDS"("STAGEID") | 211 | 0 | FK_BUILDS_STAGES | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDS | FALSE | PRIMARY_KEY_2EB | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_2EB" ON "PUBLIC"."BUILDS"("ID") | 290 | 0 | CONSTRAINT_7 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PIPELINES | TRUE | IDX_PIPELINE_NAME_ID | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINE_NAME_ID" ON "PUBLIC"."PIPELINES"("NAME", "ID") | 20 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINES | TRUE | IDX_PIPELINE_NAME_ID | 2 | ID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINE_NAME_ID" ON "PUBLIC"."PIPELINES"("NAME", "ID") | 20 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINES | TRUE | IDX_PIPELINE_NAME | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINE_NAME" ON "PUBLIC"."PIPELINES"("NAME") | 74 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINES | TRUE | IDX_PIPELINE_LABEL | 1 | LABEL | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINE_LABEL" ON "PUBLIC"."PIPELINES"("LABEL") | 75 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINES | TRUE | IDX_PIPELINES_NAME_COUNTER | 1 | NAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINES_NAME_COUNTER" ON "PUBLIC"."PIPELINES"("NAME", "COUNTER") | 76 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINES | TRUE | IDX_PIPELINES_NAME_COUNTER | 2 | COUNTER | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PIPELINES_NAME_COUNTER" ON "PUBLIC"."PIPELINES"("NAME", "COUNTER") | 76 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINES | FALSE | PRIMARY_KEY_F8 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_F8" ON "PUBLIC"."PIPELINES"("ID") | 77 | 0 | CONSTRAINT_F | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | TRUE | IDX_PMR_PIPELINE_ID | 1 | PIPELINEID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_PMR_PIPELINE_ID" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("PIPELINEID") | 80 | 0 | FK_PMR_PIPELINE | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | TRUE | FK_PMR_MATERIALID_INDEX_B | 1 | MATERIALID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_PMR_MATERIALID_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("MATERIALI | 82 | 0 | FK_PMR_MATERIALID | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | FALSE | PRIMARY_KEY_B81 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_B81" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("ID") | 85 | 0 | CONSTRAINT_A2 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | TRUE | FK_PMR_FROM_REVISION_INDEX_B | 1 | FROMREVISIONID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_PMR_FROM_REVISION_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("FROMRE | 100 | 0 | FK_PMR_FROM_REVISION | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | TRUE | FK_PMR_TO_REVISION_INDEX_B | 1 | TOREVISIONID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_PMR_TO_REVISION_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"("TOREVISI | 102 | 0 | FK_PMR_TO_REVISION | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | TRUE | FK_PMR_ACTUALFROMREVISIONID_INDEX_B | 1 | ACTUALFROMREVISIONID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_PMR_ACTUALFROMREVISIONID_INDEX_B" ON "PUBLIC"."PIPELINEMATERIALREVISIONS"( | 105 | 0 | FK_PMR_ACTUALFROMREVISIONID | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | TRUE | IDX_MODIFICATIONS_MODIFIEDTIME | 1 | MODIFIEDTIME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_MODIFIEDTIME" ON "PUBLIC"."MODIFICATIONS"("MODIFIEDTIME") | 140 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | TRUE | IDX_MOD_NEW_MATERIAL_ID | 1 | MATERIALID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_MOD_NEW_MATERIAL_ID" ON "PUBLIC"."MODIFICATIONS"("MATERIALID") | 141 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | TRUE | IDX_MODIFICATIONS_MATERIALID_ID | 1 | MATERIALID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_MATERIALID_ID" ON "PUBLIC"."MODIFICATIONS"("MATERIALID", "I | 142 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | TRUE | IDX_MODIFICATIONS_MATERIALID_ID | 2 | ID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_MATERIALID_ID" ON "PUBLIC"."MODIFICATIONS"("MATERIALID", "I | 142 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | TRUE | IDX_MODIFICATIONS_REVISION | 1 | REVISION | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_MODIFICATIONS_REVISION" ON "PUBLIC"."MODIFICATIONS"("REVISION") | 144 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | TRUE | FK_MODIFICATIONS_PIPELINEID_INDEX_A | 1 | PIPELINEID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_MODIFICATIONS_PIPELINEID_INDEX_A" ON "PUBLIC"."MODIFICATIONS"("PIPELINEID" | 145 | 0 | FK_MODIFICATIONS_PIPELINEID | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MODIFICATIONS | FALSE | PRIMARY_KEY_AC | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_AC" ON "PUBLIC"."MODIFICATIONS"("ID") | 190 | 0 | CONSTRAINT_C8 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PIPELINESELECTIONS | FALSE | PRIMARY_KEY_99 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_99" ON "PUBLIC"."PIPELINESELECTIONS"("ID") | 178 | 0 | CONSTRAINT_6 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PIPELINESELECTIONS | TRUE | FK_PIPELINESELECTIONS_USERID_INDEX_9 | 1 | USERID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_PIPELINESELECTIONS_USERID_INDEX_9" ON "PUBLIC"."PIPELINESELECTIONS"("USERI | 180 | 0 | FK_PIPELINESELECTIONS_USERID | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | PLUGINS | FALSE | PRIMARY_KEY_E7 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_E7" ON "PUBLIC"."PLUGINS"("ID") | 128 | 0 | CONSTRAINT_E7 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | PLUGINS | FALSE | CONSTRAINT_INDEX_E7 | 1 | PLUGINID | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_INDEX_E7" ON "PUBLIC"."PLUGINS"("PLUGINID") | 130 | 0 | CONSTRAINT_E72 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | JOBAGENTMETADATA | FALSE | PRIMARY_KEY_23 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_23" ON "PUBLIC"."JOBAGENTMETADATA"("ID") | 159 | 0 | CONSTRAINT_25 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | JOBAGENTMETADATA | FALSE | CONSTRAINT_25E_INDEX_2 | 1 | JOBID | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_25E_INDEX_2" ON "PUBLIC"."JOBAGENTMETADATA"("JOBID") | 217 | 0 | FK_JOBAGENTMETADATA_JOBS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TRUE | IDX_BUILDSTATETRANSITION_BUILD_ID | 1 | BUILDID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BUILDSTATETRANSITION_BUILD_ID" ON "PUBLIC"."BUILDSTATETRANSITIONS"("BUILD | 14 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TRUE | FK_BUILDTRANSITIONS_STAGES_INDEX_F | 1 | STAGEID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_BUILDTRANSITIONS_STAGES_INDEX_F" ON "PUBLIC"."BUILDSTATETRANSITIONS"("STAG | 65 | 0 | FK_BUILDTRANSITIONS_STAGES | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TRUE | IDX_STATE_TRANSITION | 1 | CURRENTSTATE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STATE_TRANSITION" ON "PUBLIC"."BUILDSTATETRANSITIONS"("CURRENTSTATE") | 147 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | FALSE | PRIMARY_KEY_8 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8" ON "PUBLIC"."BUILDSTATETRANSITIONS"("ID") | 148 | 0 | CONSTRAINT_F2 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TRUE | FK_BUILDSTATETRANSITIONS_BUILDS_INDEX_8 | 1 | BUILDID | 0 | FALSE | INDEX | TRUE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."FK_BUILDSTATETRANSITIONS_BUILDS_INDEX_8" ON "PUBLIC"."BUILDSTATETRANSITIONS"( | 150 | 0 | FK_BUILDSTATETRANSITIONS_BUILDS | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TRUE | IDX_BST_BUILDID_CURRENTSTATE | 1 | BUILDID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BST_BUILDID_CURRENTSTATE" ON "PUBLIC"."BUILDSTATETRANSITIONS"("BUILDID", | 168 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TRUE | IDX_BST_BUILDID_CURRENTSTATE | 2 | CURRENTSTATE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_BST_BUILDID_CURRENTSTATE" ON "PUBLIC"."BUILDSTATETRANSITIONS"("BUILDID", | 168 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ENVIRONMENTVARIABLES | TRUE | IDX_ENVIRONMENTVARIABLES_ENTITYTYPE | 1 | ENTITYTYPE | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_ENVIRONMENTVARIABLES_ENTITYTYPE" ON "PUBLIC"."ENVIRONMENTVARIABLES"("ENTI | 193 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ENVIRONMENTVARIABLES | TRUE | IDX_ENV_JOB_ID | 1 | ENTITYID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_ENV_JOB_ID" ON "PUBLIC"."ENVIRONMENTVARIABLES"("ENTITYID") | 303 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | ENVIRONMENTVARIABLES | FALSE | PRIMARY_KEY_9E | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_9E" ON "PUBLIC"."ENVIRONMENTVARIABLES"("ID") | 304 | 0 | CONSTRAINT_E6 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | AGENTS | TRUE | IDX_AGENT_UUID | 1 | UUID | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_AGENT_UUID" ON "PUBLIC"."AGENTS"("UUID") | 125 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | AGENTS | FALSE | PRIMARY_KEY_33D | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_33D" ON "PUBLIC"."AGENTS"("ID") | 126 | 0 | CONSTRAINT_72 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | AGENTS | FALSE | CONSTRAINT_72F_INDEX_3 | 1 | UUID | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_72F_INDEX_3" ON "PUBLIC"."AGENTS"("UUID") | 136 | 0 | CONSTRAINT_72F | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | AGENTS | FALSE | CONSTRAINT_72F4_INDEX_3 | 1 | COOKIE | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."CONSTRAINT_72F4_INDEX_3" ON "PUBLIC"."AGENTS"("COOKIE") | 234 | 0 | CONSTRAINT_72F4 | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | STAGEARTIFACTCLEANUPPROHIBITED | FALSE | PRIMARY_KEY_8D | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_8D" ON "PUBLIC"."STAGEARTIFACTCLEANUPPROHIBITED"("ID") | 69 | 0 | CONSTRAINT_8D | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | STAGEARTIFACTCLEANUPPROHIBITED | TRUE | IDX_STAGEARTIFACTCLEANUPPROHIBITED_PIPELINENAME | 1 | PIPELINENAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_STAGEARTIFACTCLEANUPPROHIBITED_PIPELINENAME" ON "PUBLIC"."STAGEARTIFACTCL | 288 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | USERS | FALSE | PRIMARY_KEY_BFE | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_BFE" ON "PUBLIC"."USERS"("ID") | 188 | 0 | CONSTRAINT_A | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | USERS | FALSE | UNIQUE_NAME_INDEX_B | 1 | NAME | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_NAME_INDEX_B" ON "PUBLIC"."USERS"("NAME") | 322 | 0 | UNIQUE_NAME | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MATERIALS | TRUE | IDX_MATERIALS_PIPELINENAME | 1 | PIPELINENAME | 0 | FALSE | INDEX | FALSE | 3 | A | 0 | | | CREATE INDEX "PUBLIC"."IDX_MATERIALS_PIPELINENAME" ON "PUBLIC"."MATERIALS"("PIPELINENAME") | 220 | 0 | null | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MATERIALS | FALSE | MATERIALS_FLYWEIGHTNAME_UNIQUE_INDEX_D | 1 | FLYWEIGHTNAME | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."MATERIALS_FLYWEIGHTNAME_UNIQUE_INDEX_D" ON "PUBLIC"."MATERIALS"("FLYWE | 221 | 0 | MATERIALS_FLYWEIGHTNAME_UNIQUE | org.h2.pagestore.db.PageBtreeIndex | FALSE
CRUISE | PUBLIC | MATERIALS | FALSE | PRIMARY_KEY_D22 | 1 | ID | 0 | TRUE | PRIMARY KEY | TRUE | 3 | A | 0 | | | CREATE PRIMARY KEY "PUBLIC"."PRIMARY_KEY_D22" ON "PUBLIC"."MATERIALS"("ID") | 223 | 0 | CONSTRAINT_4 | org.h2.pagestore.db.PageDelegateIndex | FALSE
CRUISE | PUBLIC | MATERIALS | FALSE | UNIQUE_FINGERPRINT_INDEX_D | 1 | FINGERPRINT | 0 | FALSE | UNIQUE INDEX | TRUE | 3 | A | 0 | | | CREATE UNIQUE INDEX "PUBLIC"."UNIQUE_FINGERPRINT_INDEX_D" ON "PUBLIC"."MATERIALS"("FINGERPRINT") | 225 | 0 | UNIQUE_FINGERPRINT | org.h2.pagestore.db.PageBtreeIndex | FALSE
(data is partially truncated)
(111 rows, 30 ms)
java -cp lib/h2-1.4.200.jar org.h2.tools.Shell -url jdbc:h2:./cruise -user sa -sql ‘SELECT * FROM information_schema.tables’
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | STORAGE_TYPE | SQL | REMARKS | LAST_MODIFICATION | ID | TYPE_NAME | TABLE_CLASS | ROW_COUNT_ESTIMATE
CRUISE | INFORMATION_SCHEMA | FUNCTION_COLUMNS | SYSTEM TABLE | CACHED | null | | 269804 | -22 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | CONSTANTS | SYSTEM TABLE | CACHED | null | | 269804 | -23 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | SEQUENCES | SYSTEM TABLE | CACHED | null | | 269804 | -9 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | RIGHTS | SYSTEM TABLE | CACHED | null | | 269804 | -12 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | TRIGGERS | SYSTEM TABLE | CACHED | null | | 269804 | -25 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | CATALOGS | SYSTEM TABLE | CACHED | null | | 269804 | -6 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | CROSS_REFERENCES | SYSTEM TABLE | CACHED | null | | 269804 | -20 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | SETTINGS | SYSTEM TABLE | CACHED | null | | 9223372036854775807 | -7 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | FUNCTION_ALIASES | SYSTEM TABLE | CACHED | null | | 269804 | -13 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | VIEWS | SYSTEM TABLE | CACHED | null | | 269804 | -18 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | TYPE_INFO | SYSTEM TABLE | CACHED | null | | 269804 | -5 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | CONSTRAINTS | SYSTEM TABLE | CACHED | null | | 269804 | -21 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | COLUMNS | SYSTEM TABLE | CACHED | null | | 269804 | -2 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | LOCKS | SYSTEM TABLE | CACHED | null | | 9223372036854775807 | -27 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | KEY_COLUMN_USAGE | SYSTEM TABLE | CACHED | null | | 269804 | -32 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | DOMAINS | SYSTEM TABLE | CACHED | null | | 269804 | -24 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | SCHEMATA | SYSTEM TABLE | CACHED | null | | 269804 | -14 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | COLUMN_PRIVILEGES | SYSTEM TABLE | CACHED | null | | 269804 | -16 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | HELP | SYSTEM TABLE | CACHED | null | | 269804 | -8 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | SESSION_STATE | SYSTEM TABLE | CACHED | null | | 9223372036854775807 | -28 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | TABLE_PRIVILEGES | SYSTEM TABLE | CACHED | null | | 269804 | -15 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | REFERENTIAL_CONSTRAINTS | SYSTEM TABLE | CACHED | null | | 269804 | -33 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | TABLE_TYPES | SYSTEM TABLE | CACHED | null | | 269804 | -4 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | TABLES | SYSTEM TABLE | CACHED | null | | 269804 | -1 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | QUERY_STATISTICS | SYSTEM TABLE | CACHED | null | | 269804 | -29 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | ROLES | SYSTEM TABLE | CACHED | null | | 269804 | -11 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | SESSIONS | SYSTEM TABLE | CACHED | null | | 9223372036854775807 | -26 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | IN_DOUBT | SYSTEM TABLE | CACHED | null | | 9223372036854775807 | -19 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | USERS | SYSTEM TABLE | CACHED | null | | 269804 | -10 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | COLLATIONS | SYSTEM TABLE | CACHED | null | | 269804 | -17 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | SYNONYMS | SYSTEM TABLE | CACHED | null | | 269804 | -30 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | TABLE_CONSTRAINTS | SYSTEM TABLE | CACHED | null | | 269804 | -31 | null | org.h2.table.MetaTable | 1000
CRUISE | INFORMATION_SCHEMA | INDEXES | SYSTEM TABLE | CACHED | null | | 269804 | -3 | null | org.h2.table.MetaTable | 1000
CRUISE | PUBLIC | MODIFIEDFILES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."MODIFIEDFILES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE | | 0 | 131 | null | org.h2.pagestore.db.PageStoreTable | 179436
CRUISE | PUBLIC | PROPERTIES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PROPERTIES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_S | | 0 | 34 | null | org.h2.pagestore.db.PageStoreTable | 9672202
CRUISE | PUBLIC | _STAGES | VIEW | MEMORY | CREATE FORCE VIEW "PUBLIC"."_STAGES"("ID", "NAME", "APPROVEDBY", "PIPELINEID", "CREATEDTIME", "ORDER | | 0 | 61 | null | org.h2.table.TableView | 100
CRUISE | PUBLIC | ACCESSTOKEN | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."ACCESSTOKEN"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_ | | 0 | 204 | null | org.h2.pagestore.db.PageStoreTable | 0
CRUISE | PUBLIC | DATASHARINGSETTINGS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."DATASHARINGSETTINGS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC". | | 0 | 160 | null | org.h2.pagestore.db.PageStoreTable | 1
CRUISE | PUBLIC | PIPELINESTATES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PIPELINESTATES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYST | | 0 | 54 | null | org.h2.pagestore.db.PageStoreTable | 149
CRUISE | PUBLIC | PIPELINELABELCOUNTS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PIPELINELABELCOUNTS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC". | | 0 | 84 | null | org.h2.pagestore.db.PageStoreTable | 484
CRUISE | PUBLIC | USAGEDATAREPORTING | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."USAGEDATAREPORTING"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"." | | 0 | 165 | null | org.h2.pagestore.db.PageStoreTable | 1
CRUISE | PUBLIC | ARTIFACTPLANS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."ARTIFACTPLANS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE | | 0 | 98 | null | org.h2.pagestore.db.PageStoreTable | 4694
CRUISE | PUBLIC | STAGES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."STAGES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUE | | 0 | 62 | null | org.h2.pagestore.db.PageStoreTable | 267455
CRUISE | PUBLIC | SERVERBACKUPS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."SERVERBACKUPS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE | | 0 | 44 | null | org.h2.pagestore.db.PageStoreTable | 607
CRUISE | PUBLIC | VERSIONINFOS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."VERSIONINFOS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM | | 0 | 70 | null | org.h2.pagestore.db.PageStoreTable | 1
CRUISE | PUBLIC | CHANGELOG | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."CHANGELOG"(
"CHANGE_NUMBER" INTEGER NOT NULL,
"DELTA_SET" VARC | | 0 | 8 | null | org.h2.pagestore.db.PageStoreTable | 180
CRUISE | PUBLIC | RESOURCES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."RESOURCES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SE | | 0 | 47 | null | org.h2.pagestore.db.PageStoreTable | 5
CRUISE | PUBLIC | NOTIFICATIONFILTERS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."NOTIFICATIONFILTERS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC". | | 0 | 87 | null | org.h2.pagestore.db.PageStoreTable | 24
CRUISE | PUBLIC | BUILDS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."BUILDS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUE | | 0 | 156 | null | org.h2.pagestore.db.PageStoreTable | 788552
CRUISE | PUBLIC | PIPELINES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PIPELINES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SE | | 0 | 66 | null | org.h2.pagestore.db.PageStoreTable | 159264
CRUISE | PUBLIC | PIPELINEMATERIALREVISIONS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PIPELINEMATERIALREVISIONS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PU | | 0 | 79 | null | org.h2.pagestore.db.PageStoreTable | 326164
CRUISE | PUBLIC | MODIFICATIONS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."MODIFICATIONS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTE | | 0 | 139 | null | org.h2.pagestore.db.PageStoreTable | 66178
CRUISE | PUBLIC | PIPELINESELECTIONS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PIPELINESELECTIONS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"." | | 0 | 177 | null | org.h2.pagestore.db.PageStoreTable | 112
CRUISE | PUBLIC | PLUGINS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."PLUGINS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQU | | 0 | 124 | null | org.h2.pagestore.db.PageStoreTable | 2
CRUISE | PUBLIC | JOBAGENTMETADATA | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."JOBAGENTMETADATA"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SY | | 0 | 155 | null | org.h2.pagestore.db.PageStoreTable | 0
CRUISE | PUBLIC | BUILDSTATETRANSITIONS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."BUILDSTATETRANSITIONS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC | | 0 | 146 | null | org.h2.pagestore.db.PageStoreTable | 4651917
CRUISE | PUBLIC | ENVIRONMENTVARIABLES | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."ENVIRONMENTVARIABLES"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC" | | 0 | 302 | null | org.h2.pagestore.db.PageStoreTable | 93620
CRUISE | PUBLIC | AGENTS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."AGENTS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUE | | 0 | 123 | null | org.h2.pagestore.db.PageStoreTable | 2357
CRUISE | PUBLIC | STAGEARTIFACTCLEANUPPROHIBITED | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."STAGEARTIFACTCLEANUPPROHIBITED"(
"ID" BIGINT DEFAULT NEXT VALUE FO | | 0 | 63 | null | org.h2.pagestore.db.PageStoreTable | 1100
CRUISE | PUBLIC | _BUILDS | VIEW | MEMORY | CREATE FORCE VIEW "PUBLIC"."_BUILDS"("ID", "NAME", "STATE", "RESULT", "AGENTUUID", "SCHEDULEDDATE", | | 0 | 122 | null | org.h2.table.TableView | 100
CRUISE | PUBLIC | USERS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."USERS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SEQUEN | | 0 | 135 | null | org.h2.pagestore.db.PageStoreTable | 424
CRUISE | PUBLIC | MATERIALS | TABLE | CACHED | CREATE CACHED TABLE "PUBLIC"."MATERIALS"(
"ID" BIGINT DEFAULT NEXT VALUE FOR "PUBLIC"."SYSTEM_SE | | 0 | 219 | null | org.h2.pagestore.db.PageStoreTable | 526
(data is partially truncated)
(62 rows, 7 ms)
Issue
I have tried to execute the Hibernate Demo application. I’m getting the below error message.
Database: PostgreSQL
Hibernate Version: 5
Source code for Bean class
package com.javatpoint;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
public class Employee {
@Id
private int id;
private String firstName,lastName;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
}
Test class
package com.javatpoint;
import org.hibernate.*;
import org.hibernate.cfg.*;
public class Test {
public static void main(String[] args) {
Configuration cfg=new Configuration();
cfg.configure("/hibernate.cfg.xml");
SessionFactory sf=cfg.buildSessionFactory();
Session session=sf.openSession();
Transaction t=session.beginTransaction();
Employee e1=new Employee();
e1.setId(1001);
e1.setFirstName("sonoo");
e1.setLastName("jaiswal");
Employee e2=new Employee();
e2.setId(1002);
e2.setFirstName("vimal");
e2.setLastName("jaiswal");
session.persist(e1);
session.persist(e2);
t.commit();
session.close();
System.out.println("successfully saved");
}
}
hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="hbm2ddl.auto">create</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.url">jdbc:postgresql://localhost:5555/postgres</property>
<property name="connection.username">postgres</property>
<property name="connection.password">password</property>
<property name="connection.driver_class">org.postgresql.Driver</property>
<mapping class="com.javatpoint.Employee"/>
</session-factory>
Error Message
Jun 18, 2016 12:06:34 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.2.0.Final}
Jun 18, 2016 12:06:34 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Jun 18, 2016 12:06:34 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Jun 18, 2016 12:06:34 AM org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-configuration. Use namespace http://www.hibernate.org/dtd/hibernate-configuration instead. Support for obsolete DTD/XSD namespaces may be removed at any time.
Jun 18, 2016 12:06:35 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
Jun 18, 2016 12:06:35 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
Jun 18, 2016 12:06:35 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost:5555/postgres]
Jun 18, 2016 12:06:35 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {user=postgres, password=****}
Jun 18, 2016 12:06:35 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
Jun 18, 2016 12:06:35 AM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
Jun 18, 2016 12:06:35 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
Jun 18, 2016 12:06:35 AM org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl useContextualLobCreation
INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
Jun 18, 2016 12:06:35 AM org.hibernate.type.BasicTypeRegistry register
INFO: HHH000270: Type registration [java.util.UUID] overrides previous : [email protected]
Jun 18, 2016 12:06:36 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper$StandardWarningHandler logWarning
WARN: SQL Warning Code: 0, SQLState: 00000
Jun 18, 2016 12:06:36 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper$StandardWarningHandler logWarning
WARN: schema "hibernatedemo" does not exist, skipping
Jun 18, 2016 12:06:36 AM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
WARN: GenerationTarget encountered exception accepting command : Unable to execute command [create table HibernateDemo.Employee (id int4 not null, firstName varchar(255), lastName varchar(255), primary key (id))]
org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [create table HibernateDemo.Employee (id int4 not null, firstName varchar(255), lastName varchar(255), primary key (id))]
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:63)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:434)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:419)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:310)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:308)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:476)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:707)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:723)
at com.javatpoint.Test.main(Test.java:11)
Caused by: org.postgresql.util.PSQLException: ERROR: schema "hibernatedemo" does not exist
Position: 14
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:313)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:51)
... 13 more
Jun 18, 2016 12:06:36 AM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@13f17eb4'
Jun 18, 2016 12:06:36 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 0, SQLState: 42P01
Jun 18, 2016 12:06:36 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ERROR: relation "hibernatedemo.employee" does not exist
Position: 13
Jun 18, 2016 12:06:36 AM org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release
INFO: HHH000010: On release of batch it still contained JDBC statements
Jun 18, 2016 12:06:36 AM org.hibernate.internal.ExceptionMapperStandardImpl mapManagedFlushFailure
ERROR: HHH000346: Error during managed flush [org.hibernate.exception.SQLGrammarException: could not execute statement]
Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1402)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:472)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3132)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2369)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:467)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:221)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
at com.javatpoint.Test.main(Test.java:28)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2934)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3434)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1396)
... 9 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "hibernatedemo.employee" does not exist
Position: 13
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:133)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
... 18 more
Eclipse Project
PostgreSQL Database
Solution
Hibernate is trying to create entity in hibernatedemo schema. You need to create that schema in database. I did not see your configuration that is pointing to hibernatedemo schema. The cfg.xml is generated by MyEclipse Hibernate tools. Check that configuratioon.
How to create schema in PostGreSQL Link
CREATE SCHEMA IF NOT EXISTS schema_name
After creating schema try again to start your application
Answered By — Sangram Jadhav