#
#BAP DB DESIGNER
#ORACLE VERSION
#Date:$date

#foreach ($tableModel in $tableList)
##create table
drop table ${tableModel.getTableName()};
#set ($tableColumns=${tableModel.getTablecolumn()})
#set($isNumber=1)
create table ${tableModel.getTableName()}
		(#foreach ($tableColumn in $tableColumns) #set ($dataType=${tableColumn.getDataType()})
${tableColumn.getColumnName()} #if($dataType=="String") VARCHAR(${tableColumn.getDataLength()}) #set($isNumber=0) #elseif($dataType=="float") NUMBER(${tableColumn.getDataLength()},${tableColumn.getDecimalLength()})#elseif($dataType=="int")integer#end #if(${tableColumn.isNotNull()})not null #end #if(!$null.isNotNull(${tableColumn.getDefaultValue()})) default  #if($isNumber==0)'#end${tableColumn.getDefaultValue()}#if($isNumber==0)'#end#end comment '${tableColumn.getComments()}'#if($foreach.count!=${tableColumns.size()}),
#end
		#end);
##comment
comment on table  ${tableModel.getTableName()} is '${tableModel.getComments()}';
##primary key
ALTER TABLE ${tableModel.getTableName()} add primary key (#foreach ($tableColumn in $tableColumns)#if(${tableColumn.isPrimaryKey()})#if($foreach.count!=1),#end${tableColumn.getColumnName()}#end#end);
##index
#if(!$null.isNull(${tableModel.getIndex()}))
#set($indexModel=${tableModel.getIndex()})
#set($indexColumns=${indexModel.getColumn()})
#if(${indexColumns.size()}>0)
CREATE INDEX  ${tableModel.getTableName()}_INDEX ON ${tableModel.getTableName()}  (#foreach ($indexColumn in $indexColumns)#if($foreach.count!=1),#end$indexColumn#end);
#end
#end


#end