START TRANSACTION;

-- selling options node type

insert nodeTypeT (
    id, 
    forceSingleNode,
    internalTypeId,
    forceSingleType,
    code,
    forceSinglePhoto,
    canEditType,
    canEditNode,
    canHavePhoto,
    canHaveRatingPoints,
    canLinkFrom,
    canLinkTo,
    canSearch,
    displayInObject,
    displayInObjectList,
    searchAnd,
    displayNode,
    requiredForObject,
    sorter,
    added,
    changed) 
values (
/* id */                    23, 
/* forceSingleNode */       NULL,
/* internalTypeId */        'tag',
/* forceSingleType */       NULL,
/* code */                  'selloption',
/* forceSinglePhoto */      'y',
/* canEditType */           'y',
/* canEditNode */           'y',
/* canHavePhoto */          'y',
/* canHaveRatingPoints */   'n',
/* canLinkFrom */           'y',
/* canLinkTo */             'y',
/* canSearch */             'y',
/* displayInObject */       'y',
/* displayInObjectList */   'y',
/* searchAnd */             'n',
/* displayNode */           'y',
/* requiredForObject */     'n',
/* sorter */                65,
/* added */                 now(),
/* changed */               now());


insert nodeTypeTL (
    id,
    languageId,
    name)
values (
/* id */            23,
/* languageId */    'ukr',
/* name */          'Варіанти продажу'),
(
/* id */            23,
/* languageId */    'rus',
/* name */          'Варианты продажи'),
(
/* id */            23,
/* languageId */    'eng',
/* name */          'Selling Options');


-- selling options - allowed links

insert allowedNodeLinkT (
    srcNodeTypeId,
    dstNodeTypeId,
    essential,
    singleSrc,
    added,
    changed)
values (
/* srcNodeTypeId */ 5,
/* dstNodeTypeId */ 23,
/* essential */     'n',
/* singleSrc */     'n',
/* added */         now(),
/* changed */       now()),
(
/* srcNodeTypeId */ 12,
/* dstNodeTypeId */ 23,
/* essential */     'n',
/* singleSrc */     'n',
/* added */         now(),
/* changed */       now()),
(
/* srcNodeTypeId */ 23,
/* dstNodeTypeId */ 2,
/* essential */     'n',
/* singleSrc */     'n',
/* added */         now(),
/* changed */       now());


-- selling options 

set @tag_id = tag_Create(
/* type_id_ */                  23,
/* type_code_ */                null,
/* name_ */                     'Торг',
/* sorter_ */                   10,
/* can_search_ */               'y',
/* display_in_object_ */        'y',
/* display_in_object_list_ */   'y',
/* factor_ */                   null,
/* rating_points_ */            null,
/* enabled_ */                  null);

select @tag_id, 'Торг';

select tag_UpdateLocal(tag_UpdateLocal(@tag_id, 'rus', 'Торг'), 'eng', 'Bargain');

set @tag_id = tag_Create(
/* type_id_ */                  23,
/* type_code_ */                null,
/* name_ */                     'Обмін',
/* sorter_ */                   20,
/* can_search_ */               'y',
/* display_in_object_ */        'y',
/* display_in_object_list_ */   'y',
/* factor_ */                   null,
/* rating_points_ */            null,
/* enabled_ */                  null);

select @tag_id, 'Обмін';

select tag_UpdateLocal(tag_UpdateLocal(@tag_id, 'rus', 'Обмен'), 'eng', 'Exchange');

COMMIT;