{"id":2483,"date":"2015-07-25T19:57:06","date_gmt":"2015-07-25T19:57:06","guid":{"rendered":"http:\/\/www.garysieling.com\/blog\/?p=2483"},"modified":"2015-07-25T19:57:06","modified_gmt":"2015-07-25T19:57:06","slug":"liquibase-autoincrement-startwith-example","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/","title":{"rendered":"Liquibase autoIncrement startWith example"},"content":{"rendered":"<p>Liquibase doesn&#8217;t seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &#8220;startWith&#8221; after the fact (useful for a database migration):<\/p>\n<pre lang=\"xml\">\n<changeSet author=\"gary\" id=\"1437853066645-52\">\n  <createTable tableName=\"messages\">\n    <column autoIncrement=\"true\" startWith=\"150000\" name=\"Id\" type=\"bigint\">\n      <constraints primaryKey=\"true\" primaryKeyName=\"pk_messages\">\n    <\/column>\n  <\/createTable>\n<\/changeSet>\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Liquibase doesn&#8217;t seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &#8220;startWith&#8221; after the fact (useful for a database migration):<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[4,6],"tags":[160,340,524],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Liquibase doesn&#039;t seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &quot;startWith&quot; after the fact (useful for a database migration):\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"gary\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Gary Sieling - Software Engineer\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Liquibase autoIncrement startWith example - Gary Sieling\" \/>\n\t\t<meta property=\"og:description\" content=\"Liquibase doesn&#039;t seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &quot;startWith&quot; after the fact (useful for a database migration):\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2015-07-25T19:57:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2015-07-25T19:57:06+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Liquibase autoIncrement startWith example - Gary Sieling\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Liquibase doesn&#039;t seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &quot;startWith&quot; after the fact (useful for a database migration):\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#blogposting\",\"name\":\"Liquibase autoIncrement startWith example - Gary Sieling\",\"headline\":\"Liquibase autoIncrement startWith example\",\"author\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\"},\"datePublished\":\"2015-07-25T19:57:06+00:00\",\"dateModified\":\"2015-07-25T19:57:06+00:00\",\"inLanguage\":\"en-US\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#webpage\"},\"articleSection\":\"Code Examples, Data Science, databases, liquibase, sql server\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.garysieling.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/#listItem\",\"name\":\"Code Examples\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/#listItem\",\"position\":2,\"name\":\"Code Examples\",\"item\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#listItem\",\"name\":\"Liquibase autoIncrement startWith example\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#listItem\",\"position\":3,\"name\":\"Liquibase autoIncrement startWith example\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/#listItem\",\"name\":\"Code Examples\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\",\"name\":\"Gary Sieling\",\"description\":\"Software Engineer\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/\",\"name\":\"gary\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0be925276d848ffe98a6a9dc8cf33e67?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"gary\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#webpage\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/\",\"name\":\"Liquibase autoIncrement startWith example - Gary Sieling\",\"description\":\"Liquibase doesn't seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding \\\"startWith\\\" after the fact (useful for a database migration):\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/liquibase-autoincrement-startwith-example\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\"},\"datePublished\":\"2015-07-25T19:57:06+00:00\",\"dateModified\":\"2015-07-25T19:57:06+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/\",\"name\":\"Gary Sieling\",\"description\":\"Software Engineer\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Liquibase autoIncrement startWith example - Gary Sieling","description":"Liquibase doesn't seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding \"startWith\" after the fact (useful for a database migration):","canonical_url":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#blogposting","name":"Liquibase autoIncrement startWith example - Gary Sieling","headline":"Liquibase autoIncrement startWith example","author":{"@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author"},"publisher":{"@id":"https:\/\/www.garysieling.com\/blog\/#organization"},"datePublished":"2015-07-25T19:57:06+00:00","dateModified":"2015-07-25T19:57:06+00:00","inLanguage":"en-US","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#webpage"},"isPartOf":{"@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#webpage"},"articleSection":"Code Examples, Data Science, databases, liquibase, sql server"},{"@type":"BreadcrumbList","@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.garysieling.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/#listItem","name":"Code Examples"}},{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/#listItem","position":2,"name":"Code Examples","item":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#listItem","name":"Liquibase autoIncrement startWith example"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#listItem","position":3,"name":"Liquibase autoIncrement startWith example","previousItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/#listItem","name":"Code Examples"}}]},{"@type":"Organization","@id":"https:\/\/www.garysieling.com\/blog\/#organization","name":"Gary Sieling","description":"Software Engineer","url":"https:\/\/www.garysieling.com\/blog\/"},{"@type":"Person","@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author","url":"https:\/\/www.garysieling.com\/blog\/author\/gary\/","name":"gary","image":{"@type":"ImageObject","@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/0be925276d848ffe98a6a9dc8cf33e67?s=96&d=identicon&r=g","width":96,"height":96,"caption":"gary"}},{"@type":"WebPage","@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#webpage","url":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/","name":"Liquibase autoIncrement startWith example - Gary Sieling","description":"Liquibase doesn't seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding \"startWith\" after the fact (useful for a database migration):","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.garysieling.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/#breadcrumblist"},"author":{"@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author"},"creator":{"@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author"},"datePublished":"2015-07-25T19:57:06+00:00","dateModified":"2015-07-25T19:57:06+00:00"},{"@type":"WebSite","@id":"https:\/\/www.garysieling.com\/blog\/#website","url":"https:\/\/www.garysieling.com\/blog\/","name":"Gary Sieling","description":"Software Engineer","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.garysieling.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Gary Sieling - Software Engineer","og:type":"article","og:title":"Liquibase autoIncrement startWith example - Gary Sieling","og:description":"Liquibase doesn't seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &quot;startWith&quot; after the fact (useful for a database migration):","og:url":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/","article:published_time":"2015-07-25T19:57:06+00:00","article:modified_time":"2015-07-25T19:57:06+00:00","twitter:card":"summary_large_image","twitter:title":"Liquibase autoIncrement startWith example - Gary Sieling","twitter:description":"Liquibase doesn't seem to have a command line option to let you set the start points on autoIncrement fields when you generate patches, but you can fix this easily by adding &quot;startWith&quot; after the fact (useful for a database migration):"},"aioseo_meta_data":{"post_id":"2483","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2023-02-04 16:28:29","updated":"2026-07-06 01:14:47","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.garysieling.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/\" title=\"Code Examples\">Code Examples<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tLiquibase autoIncrement startWith example\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.garysieling.com\/blog"},{"label":"Code Examples","link":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/"},{"label":"Liquibase autoIncrement startWith example","link":"https:\/\/www.garysieling.com\/blog\/liquibase-autoincrement-startwith-example\/"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/2483"}],"collection":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/comments?post=2483"}],"version-history":[{"count":0,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/2483\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/media?parent=2483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/categories?post=2483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/tags?post=2483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}