rem: ["constraint USERABSTR_UK_NAME   unique(NAME)"] 
add: ["constraint USERABSTR_UK_NAME   unique(NAME)"], ["constraint USERABSTR_UK_EXTKEY unique(EXTERNALKEY)"] 
context: function _eFapsCreateAllUserTables(_con, _stmt)  {  print("Create User Tables");  _eFapsCreateCreateTable(_con, _stmt, "Abstract User", "USERABSTRACT", null,[      ["TYPEID                "+TYPE_INTEGER+"                   not null"],      ["NAME                  "+TYPE_STRING_SHORT+"(128)         not null"],      ["CREATOR               "+TYPE_INTEGER+"                   not null"],      ["CREATED               "+TYPE_DATETIME+"                  not null"],      ["MODIFIER              "+TYPE_INTEGER+"                   not null"],      ["MODIFIED              "+TYPE_DATETIME+"                  not null"],["STATUS  int  default 10001 not null"],      ["constraint USERABSTR_UK_NAME   unique(NAME)"]  ]);  _eFapsCreateCreateTable(_con, _stmt, "Person object", "USERPERSON", "USERABSTRACT",[      ["FIRSTNAME             "+TYPE_STRING_SHORT+"(128)         not null"],      ["LASTNAME              "+TYPE_STRING_SHORT+"(128)         not null"],      ["EMAIL                 "+TYPE_STRING_SHORT+"(128)         not null"],      ["ORG                   "+TYPE_STRING_SHORT+"(128)"],      ["URL                   "+TYPE_STRING_SHORT+"(254)"],      ["PHONE                 "+TYPE_STRING_SHORT+"(32)"],      ["MOBILE                "+TYPE_STRING_SHORT+"(32)"],      ["FAX                   "+TYPE_STRING_SHORT+"(32)"],      ["PASSWORD              "+TYPE_STRING_SHORT+"(128)"]  ]);  _eFapsCreateCreateTable(_con, _stmt, "Connection between Abstract User and Abstract User", "USERABSTRACT2ABSTRACT", null,[      ["TYPEID                "+TYPE_INTEGER+"                   not null"],      ["CREATOR               "+TYPE_INTEGER+"                   not null"],      ["CREATED               "+TYPE_DATETIME+"                  not null"],      ["MODIFIER              "+TYPE_INTEGER+"                   not null"],      ["MODIFIED              "+TYPE_DATETIME+"                  not null"],      ["USERABSTRACTFROM      "+TYPE_INTEGER+"                   not null"],      ["USERABSTRACTTO        "+TYPE_INTEGER+"                   not null"],      ["constraint USRABS2ABS_UK_FRTO  unique(USERABSTRACTFROM,USERABSTRACTTO)"],      ["constraint USRABS2ABS_FK_CRTR  foreign key(CREATOR)          references USERABSTRACT(ID)"],      ["constraint USRABS2ABS_FK_MDFR  foreign key(MODIFIER)         references USERABSTRACT(ID)"],      ["constraint USRABS2ABS_FK_FROM  foreign key(USERABSTRACTFROM) references USERABSTRACT(ID)"],      ["constraint USRABS2ABS_FK_TO    foreign key(USERABSTRACTTO)   references USERABSTRACT(ID)"]  ]);}
meta: 8605	/local1/tlutelli/issta_data/temp/all_js/javascript/2006_temp/2006/8605/52fab603779c7bfb6898b8e521707b793ce9e673/CreateAll.js/buggy/trunk/shell/src/main/resources/org/efaps/js/functions/CreateAll.js