Start generating auto increment column value from

问题:

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.

回答1:

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

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