dbupgrade

Contents

object=ue_installation=dbupgrade=#<variable>

object=ue_installation=dbupgrade=<filename>

if you use oder version as beas8.8-0-0-76 then use

object=ue_installation=dbpruef=#<variable>

Add new Tables, Columns or Indexes

or make correct length or types

Normal beas read the file db.ini and execute this table-definition-File

Keyworkds

table=<tablename>	Create a new Table. After this command you need the Primary and the columns
primary=<table>=<column>,<column>	set or change the Primary-key
column=<table>=<columnname=<typ>	Create a new Column for the Table
udf=<table>=<column>=<Description>=<typ>=<typ2>=<length>	Create a SAP-UDF-Column Typ / Typ2 dec,float,decimal,real / rate, sum. price, quantity, percent int, numeric, num / .. date, datetime / time, ... memory, text / .. alpha, char, string, varchar / address, phone / length
delcolumn=<table>=<column>	Delete the Column First you must set "delcolumn" to yes delcolumn=yes delcolumn=mytable=mycolumn
droptable=<table>=<true/false/empty>=<column>	Delete the Table, if colum exist in the table or column is not existing false = delete table, if column not existing true = delete the table, if column is existing empty = delete table allways droptable=mytable delete table allways droptable=mytable=true=mycol delete table, if column mycol not existing
default=table=column=value	set a default value without constraint, if value for the table/column is null
constraint=<table>=<column>=<constraintname>=<constraint>	create or alter a constraint
delconstraint=<table>=<constraintname>	delete a constraint
script=<script>	Execute this beas-Script
sql=<sqlscommand>	Execute this SQL-Command

Example: Create new Table

#define dbcheck

table=beas_oitm_material

primary=beas_oitm_material=baseitemcode,itemcode

column=beas_oitm_material=baseitemcode=varchar(30) not null

column=beas_oitm_material=itemcode=varchar(30) not null

column=beas_oitm_material=quantity=decimal(19,6)

#end

object=ue_installation=dbupgrade=#<dbcheck>