Search code examples
scalaplayframework-2.0slickplay-slick

Start generating auto increment column value from default in slick

I having a table column holds auto increment value. I want to start incrementing from specified vlaue. How can i specify this functionality in slick ddl.

Code i am using for column of table creation in slick is :

def id = column[Long]("id", O.PrimaryKey, O.AutoInc, O.NotNull)

I have come across this article but didn't find exact solution.

create table "COCKTAIL" (
  "ID" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 100000) NOT NULL PRIMARY KEY,
  "NAME" VARCHAR NOT NULL)

Can someone help me how to achieve this.

Solution

  • What about O.Default(...)? Look at here: ColumnOption.

    def id = column[Long]("id", O.PrimaryKey, O.AutoInc, O.NotNull,O.Default(100000))