Skip to main content

Create Table in Liquibase

For creating table using liquibase you can use below code and add it in your liquibase file.


<createTable tableName=“employee”>
    <column name="id" type="int">
     <constraints primaryKey="true" nullable="false"/>
  </column>  
  <column name="first_name" type="varchar(255)"/>
  <column name="last_name" type="varchar(255)"/>
  <column name="username" type="varchar(255)">
     <constraints unique="true" nullable="false"/>
  </column>
</createTable>



The use is pretty simple it's the way it looks :

Tag:
<createTable></createTable>
This is an opening/ending tag for creating a table. These tags will enclose column sub tags which will define columns for the table.
Attribute:
 tableName : Name of the table which you want to create. (This is a mandatory                        field)
 schemaName : Name of the table schema
 tablespace : Name of the tablespace where you want to create the table.
 remarks    : A small description of the table.


 Sub Tag:
<column> : It's a self terminating tag or you can use ending tag like '</column>'.

 Attributes used in the above code:
 name: Name of the column.
 type: This defines the data type of the column

 Optional Attributes:

 value : The value that will be set to the column. The value is surrounded by  quotes.
 valueNumeric : Numeric value will be set to the column. The value is not surrounded by quotes.
 valueBoolean : Boolean value (true/false) will be set to the column. The actual value string inserted will be dependent on the database implementation.
 valueDate : Date/Time value will be set to the value.Supported format - "YYYY-MM-DD","hh:mm:ss" or "YYYY-MM-DDThh:mm:ss".
 valueComputed : A value will be set to the column that is returned by a function or a procedure call.
 defaultValue : If there is no value set to the column then the value set for this attribute will be set automatically.
 defaultValueNumeric : Numeric value will be set as a default value.
 defaultValueBoolean : Boolean value will be set as a default value.
 defaultValueDate : Default value for Date/Time can be provided using this attribute. The format remains same as the format define for "valueDate".
 defaultValueComputed : The value returned by a function or a procedure call will be set as the default value for the column.
 autoIncrement : setting the value as true/false will set the columns as auto-increment.They are ignored by the databases that do not support auto-increment fuctionality.
 remarks : Short description of the column.

Reference : http://www.liquibase.org/manual/column
Other links that you might like :

 liquibase.exception.LockException: Could not acquire change log lock.
How databasechangeloglock and databasechangelog table used by liquibase?





Labels:

Comments

Post a Comment

.

Popular posts from this blog

ReferenceError: dhtmlXGrid is not defined : Resolved

For the errors like : ReferenceError: dhtmlXDataView is not defined ReferenceError: dhtmlXGrid is not defined ReferenceError: dhtmlXTree is not defined ReferenceError: dhtmlXTreeGrid is not defined etc I have been working on dhtmlx for long time now and this is one of the most basic exception faced by the developer and which in fact is very easy to resolve. Reasons: 1. You are actually referring to a wrong location of the JS file.    - This is a very common mistake done and most of the time we are so damn sure that we don't even care about checking the path once. Even though you have copied it from your existing project where it is working, if you face this issue don't forget to check the path once, it won't harm you. 2. Check for relative path.    - So now you have copied it and paste it in your new file where you are going to use the dhtmlx component and when you open your file you get this error and it becomes frustrating knowing that same thing is wo
6 comments
Read more

How databasechangeloglock and databasechangelog table used by liquibase?

Liquibase takes care of executing the query on the database while maintaining the list of queries executed and also maintaining the locks over the tables simultaneously. The two tables that are used by the liquibase for this purpose are : Databasechangeloglock : This table have following columns ID | LOCKED| LOCKGRANTED | LOCKEDBY. This maintains the locks information granted to the user. The primary purpose of this table is to make sure that two machines don't attempt to modify the data at the same time. Databasechangelog : This table have following columns ID | AUTHOR | FILENAME | DATEEXECUTED | ORDEREXECUTED | EXECTYPE | MD5SUM | DESCRIPTION | COMMENTS | TAG | LIQUIBASE This table maintains the list of the statements that are executed on the database.
Post a Comment
Read more