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)
Are you looking for an answer to the topic “postgresql error relation does not exist“? We answer all your questions at the website Brandiscrafts.com in category: Latest technology and computer news updates. You will find the answer right below.
Keep Reading
What does relation does not exist mean in SQL?
In PostgreSQL, a relation does not exist error happens when you reference a table name that can’t be found in the database you currently connect to. In the case above, the error happens because Sequelize is trying to find Users table with an s , while the existing table is named User without an s .
What is relation in PostgreSQL?
PostgreSQL is a relational database management system ( RDBMS ). That means it is a system for managing data stored in relations. Relation is essentially a mathematical term for table.
How to fix Postgres relation not found error
How to fix Postgres relation not found error
How to fix Postgres relation not found error
Images related to the topicHow to fix Postgres relation not found error
How do I connect to a Postgres database?
Connecting to a Database
In order to connect to a database you need to know the name of your target database, the host name and port number of the server, and what user name you want to connect as. psql can be told about those parameters via command line options, namely -d , -h , -p , and -U respectively.
Can we disable index in PostgreSQL?
With Postgresql it can be very faster to disable the indexes before runing the query and reindex all the table afterwards. You can do it like this : Disable all table indexes.
What is schema in PostgreSQL?
A schema is a named collection of tables. A schema can also contain views, indexes, sequences, data types, operators, and functions. Schemas are analogous to directories at the operating system level, except that schemas cannot be nested. PostgreSQL statement CREATE SCHEMA creates a schema.
Is Postgres case sensitive?
String comparisons in PostgreSQL are case sensitive* (unless a case-insensitive collation were to be introduced). To work around this, PostgreSQL has several methods to match strings in a case-insensitive manner.
What is relation SQL?
In SQL, a relation is a bag of objects that all share the same characteristics: a list of attributes with a known given data type. We name those objects tuples in SQL. An object with three attributes can be named a triple, an object with four attributes a quadruple, with six attributes a sextuple, etc.
See some more details on the topic postgresql error relation does not exist here:
Cannot simply use PostgreSQL table name (“relation does not …
From what I’ve read, this error means that you’re not referencing the table name correctly. One common reason is that the table is defined with a mixed-case …
+ Read More
Sequelize – How to fix relation does not exist error – Nathan …
In PostgreSQL, a relation does not exist error happens when you reference a table name that can’t be found in the database you currently …
+ Read More Here
ERROR: relation “table_name” does not exist – Magento Forums
This means that a table created by alice, who is neither you nor a role than you are a member of (can be checked, for example, by using du in …
+ Read More Here
Debugging “relation does not exist” error in postgres – Rajya …
Alter user postgres so that it uses password: alter user postgres with password ‘pwd123’; · Change connection string: “host=localhost port=5432 …
+ View More Here
How do you create a relationship between two tables in SQL?
Use SQL Server Management Studio
- In Object Explorer, right-click the table that will be on the foreign-key side of the relationship and select Design. …
- From the Table Designer menu, select Relationships. …
- In the Foreign-key Relationships dialog box, select Add. …
- Select the relationship in the Selected Relationship list.
How do I link tables in PostgreSQL?
PostgreSQL INNER JOIN
- First, specify columns from both tables that you want to select data in the SELECT clause.
- Second, specify the main table i.e., table A in the FROM clause.
- Third, specify the second table (table B ) in the INNER JOIN clause and provide a join condition after the ON keyword.
How do I connect to a postgres user?
Connect to your PostgreSQL server instance using the following command:
- sudo -u postgres psql. …
- c databasename; …
- CREATE ROLE chartio_read_only_user LOGIN PASSWORD ‘secure_password’; …
- GRANT CONNECT ON DATABASE exampledb TO chartio_read_only_user; GRANT USAGE ON SCHEMA public TO chartio_read_only_user;
Can’t connect to local postgres?
First make sure PostgreSQL server has been started to remote server. If it is running and you get above error, you need to add enable TCP/IP support. By default, the PostgreSQL server only allows connections to the database from the local machine or localhost.
Error: relation tablename does not exist while Inserting data from code to Database SOLVED | Part 2
Error: relation tablename does not exist while Inserting data from code to Database SOLVED | Part 2
Error: relation tablename does not exist while Inserting data from code to Database SOLVED | Part 2
Images related to the topicError: relation tablename does not exist while Inserting data from code to Database SOLVED | Part 2
What is the psql command to show all the relations in a database?
Type the command l in the psql command-line interface to display a list of all the databases on your Postgres server.
How do you drop an index?
The DROP INDEX command is used to delete an index in a table.
- MS Access: DROP INDEX index_name ON table_name;
- SQL Server: DROP INDEX table_name.index_name;
- DB2/Oracle: DROP INDEX index_name;
- MySQL: ALTER TABLE table_name. DROP INDEX index_name;
Is schema and database same in PostgreSQL?
A database in PostgreSQL contains the subset of schema. It contains all the schemas, records, and constraints for tables. A Schema in PostgreSQL is basically a namespace that contains all the named database objects like tables, indexes, data types, functions, stored procedures, etc.
How do I get PostgreSQL schema?
How to list all available schemas in PostgreSQL?
- Using SQL Query. You can get the list of all schemas using SQL with the ANSI standard of INFORMATION_SCHEMA: SELECT schema_name FROM information_schema.schemata. or. SELECT nspname FROM pg_catalog. …
- Using psql. While using psql, simply use command dn .
- With TablePlus.
What is difference between database and schema?
The database is a collection of schema, records, and constraints for the tables. On the other hand, a schema contains the structure of tables, attributes, their types, constraints, and how they relate to other tables.
How do I make Postgres database case-insensitive?
The older PostgreSQL method for performing case-insensitive text operations is the citext type; it is similar to the text type, but operators are functions between citext values are implicitly case-insensitive. The PostgreSQL docs provide more information on this type.
Is schema name case sensitive in PostgreSQL?
PostgreSQL names are case sensitive. By default, AWS Schema Conversion Tool (AWS SCT) uses object name in lowercase for PostgreSQL. In most cases, you’ll want to use AWS Database Migration Service transformations to change schema, table, and column names to lower case.
What is real datatype in PostgreSQL?
real or float8 is a 4-byte floating-point number. numeric or numeric(p,s) is a real number with p digits with s number after the decimal point. The numeric(p,s) is the exact number.
How do you create a relationship in a database?
Create a table relationship by using the Relationships window
- On the Database Tools tab, in the Relationships group, click Relationships.
- On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013).
- Select one or more tables or queries and then click Add.
Postgres : Relation does not exist error
Postgres : Relation does not exist error
Postgres : Relation does not exist error
Images related to the topicPostgres : Relation does not exist error
How do you identify a relationship in a database?
Identifying Entity Relationships in DBMS
- Weak Entity. Weak Entity is dependent on Strong Entity and does not have a primary key. …
- Strong Entity. Other entities are dependent on Strong Entity and it has a key attribute i.e. a primary key and represented as a single rectangle.
- Identifying Relationships.
What are the 3 types of relationships in a database?
There are 3 different types of relations in the database:
- one-to-one.
- one-to-many, and.
- many-to-many.
Related searches to postgresql error relation does not exist
- org.postgresql.util.psqlexception error relation hibernate_sequence does not exist
- error: relation does not exist sql
- org.postgresql.util.psqlexception error relation does not exist
- postgresql insert error relation does not exist
- relation does not exist postgres python
- error: relation does not exist redshift
- caused by org.postgresql.util.psqlexception error relation table does not exist
- postgresql copy error relation does not exist
- error relation does not exist sql
- postgresql sql error 42p01 error relation does not exist
- postgresql jdbc error relation does not exist
- postgresql select error relation does not exist
- error relation employee does not exist in postgresql
- error: relation does not exist postgres spring boot
- java postgresql error relation does not exist
- relation does not exist pgadmin
- caused by org.postgresql.util.psqlexception error relation dual does not exist
- cause org.postgresql.util.psqlexception error relation does not exist
- error relation does not exist postgres spring boot
- org.postgresql.util.psqlexception error relation dual does not exist
- pq relation does not exist golang
- postgresql error relation does not exist at character
- postgresql.util.psqlexception error relation does not exist
- postgresql grant error relation does not exist
- postgresql sequence error relation does not exist
- relation does not exist postgres node
- postgresql error relation does not exist sql state 42p01
- error relation does not exist spring boot
- error relation does not exist sql state 42p01
Information related to the topic postgresql error relation does not exist
Here are the search results of the thread postgresql error relation does not exist from Bing. You can read more if you want.
You have just come across an article on the topic postgresql error relation does not exist. If you found this article useful, please share it. Thank you very much.