/trunk/centralmanagment/2-sandbox/data/schemas/1.1/schema.yml

https://github.com/eurotux/ETVA · YAML · 204 lines · 204 code · 0 blank · 0 comment · 0 complexity · 9214d6f68e816a38a5f512f316bac104 MD5 · raw file 

    

  1. propel:
    2. 

  2.   _attributes:
    3. 

  3.     defaultIdMethod: native
    4. 

  4.     package: lib.model
    5. 

  5.   network:
    6. 

  6.     _attributes: { phpName: EtvaNetwork }
    7. 

  7.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    8. 

  8.     vlan_id: { type: INTEGER, required: true, foreignTable: vlan, foreignReference: id, onDelete: cascade }
    9. 

  9.     server_id: { type: INTEGER, required: true, foreignTable: server, foreignReference: id, onDelete: cascade }
    10. 

  10.     port: { type: VARCHAR, size: '255' }
    11. 

  11.     ip: { type: VARCHAR, size: '255' }
    12. 

  12.     mask: { type: VARCHAR, size: '255' }
    13. 

  13.     mac: { type: VARCHAR, size: '255' }
    14. 

  14.     target: { type: VARCHAR, size: '255' }
    15. 

  15.     intf_model: { type: VARCHAR, size: '255' }
    16. 

  16.   server:
    17. 

  17.     _attributes: { phpName: EtvaServer }
    18. 

  18.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    19. 

  19.     name: { type: VARCHAR, size: '255', required: true }
    20. 

  20.     description: { type: LONGVARCHAR }
    21. 

  21.     ip: { type: VARCHAR, required: true }
    22. 

  22.     vnc_keymap: { type: VARCHAR, size: '10' }
    23. 

  23.     vnc_keymap_default: { type: INTEGER, required: true, default: '1' }
    24. 

  24.     uuid: { type: VARCHAR, size: '255' }
    25. 

  25.     mem: { type: VARCHAR, size: '255' }
    26. 

  26.     vcpu: { type: INTEGER }
    27. 

  27.     cpuset: { type: VARCHAR, size: '255' }
    28. 

  28.     cpu_sockets: { type: INTEGER }
    29. 

  29.     cpu_cores: { type: INTEGER }
    30. 

  30.     cpu_threads: { type: INTEGER }
    31. 

  31.     location: { type: VARCHAR, size: '255' }
    32. 

  32.     boot: { type: VARCHAR, size: '255' }
    33. 

  33.     cdromextra: { type: VARCHAR, size: '255' }
    34. 

  34.     cdrom: { type: INTEGER, default: '0' }
    35. 

  35.     first_boot: { type: INTEGER, default: '1' }
    36. 

  36.     network_cards: { type: INTEGER }
    37. 

  37.     vm_state: { type: VARCHAR, size: '255' }
    38. 

  38.     mac_addresses: { type: LONGVARCHAR }
    39. 

  39.     created_at: { type: TIMESTAMP, required: true }
    40. 

  40.     updated_at: { type: TIMESTAMP, required: true }
    41. 

  41.     agent_tmpl: { type: VARCHAR, size: '255' }
    42. 

  42.     agent_port: { type: INTEGER }
    43. 

  43.     state: { type: INTEGER, required: true, default: '0' }
    44. 

  44.     vm_type: { type: VARCHAR, size: '255' }
    45. 

  45.     vm_os: { type: VARCHAR, size: '255' }
    46. 

  46.     unassigned: { type: INTEGER, required: true, default: '0' }
    47. 

  47.     autostart: { type: INTEGER, required: true, default: '0' }
    48. 

  48.     node_id: { type: INTEGER, required: true, foreignTable: node, foreignReference: id, onDelete: cascade }
    49. 

  49.     devices: { type: LONGVARCHAR }
    50. 

  50.     features: { type: VARCHAR, size: '255' }
    51. 

  51.     ga_info: { type: LONGVARCHAR }
    52. 

  52.     ga_state: { type: VARCHAR, size: '255' }
    53. 

  53.     hasHA: { type: INTEGER, default: '0' }
    54. 

  54.     priority_ha: { type: INTEGER, default: '0' }
    55. 

  55.     heartbeat: { type: TIMESTAMP }
    56. 

  56.     hbtimeout: { type: INTEGER, default: '0' }
    57. 

  57.     hblaststart: { type: TIMESTAMP }
    58. 

  58.     hbnrestarts: { type: INTEGER, default: '0' }
    59. 

  59.   node:
    60. 

  60.     _attributes: { phpName: EtvaNode }
    61. 

  61.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    62. 

  62.     cluster_id: { type: INTEGER, required: true, foreignTable: cluster, foreignReference: id, onDelete: restrict }
    63. 

  63.     name: { type: VARCHAR, size: '255', required: true }
    64. 

  64.     memtotal: { type: BIGINT }
    65. 

  65.     memfree: { type: BIGINT }
    66. 

  66.     cputotal: { type: INTEGER }
    67. 

  67.     ip: { type: VARCHAR }
    68. 

  68.     port: { type: INTEGER }
    69. 

  69.     uuid: { type: VARCHAR, size: '255' }
    70. 

  70.     storagedir: { type: LONGVARCHAR }
    71. 

  71.     network_cards: { type: INTEGER }
    72. 

  72.     state: { type: INTEGER, required: true, default: '1' }
    73. 

  73.     hypervisor: { type: VARCHAR, size: '255' }
    74. 

  74.     initialize: { type: VARCHAR, size: '255' }
    75. 

  75.     created_at: { type: TIMESTAMP, required: true }
    76. 

  76.     updated_at: { type: TIMESTAMP }
    77. 

  77.     last_keepalive: { type: TIMESTAMP }
    78. 

  78.     last_message: { type: VARCHAR, size: '255' }
    79. 

  79.     isSpareNode: { type: INTEGER, default: '0' }
    80. 

  80.     fencingconf: { type: VARCHAR, size: '255' }
    81. 

  81.   mac:
    82. 

  82.     _attributes: { phpName: EtvaMac }
    83. 

  83.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    84. 

  84.     mac: { type: VARCHAR, size: '255' }
    85. 

  85.     in_use: { type: INTEGER, default: '0' }
    86. 

  86.   vlan:
    87. 

  87.     _attributes: { phpName: EtvaVlan }
    88. 

  88.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    89. 

  89.     cluster_id: { type: INTEGER, required: true, foreignTable: cluster, foreignReference: id, onDelete: restrict }
    90. 

  90.     name: { type: VARCHAR, size: '255', required: true }
    91. 

  91.     tagged: { type: INTEGER, required: true, default: '0' }
    92. 

  92.     vlanid: { type: INTEGER }
    93. 

  93.     intf: { type: VARCHAR, size: '10' }
    94. 

  94.     _uniques: { vlan_index1355: [name, cluster_id], vlan_index1543: [vlanid, cluster_id] }
    95. 

  95.   physicalvolume:
    96. 

  96.     _attributes: { phpName: EtvaPhysicalvolume }
    97. 

  97.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    98. 

  98.     cluster_id: { type: INTEGER, required: true, foreignTable: cluster, foreignReference: id, onDelete: restrict }
    99. 

  99.     uuid: { type: VARCHAR, size: '255' }
    100. 

  100.     name: { type: VARCHAR, size: '255' }
    101. 

  101.     device: { type: VARCHAR, size: '255' }
    102. 

  102.     devsize: { type: BIGINT }
    103. 

  103.     pv: { type: VARCHAR, size: '255' }
    104. 

  104.     pvsize: { type: BIGINT }
    105. 

  105.     pvfreesize: { type: BIGINT }
    106. 

  106.     pvinit: { type: INTEGER, default: '0' }
    107. 

  107.     storage_type: { type: VARCHAR, size: '255' }
    108. 

  108.     allocatable: { type: INTEGER }
    109. 

  109.     inconsistent: { type: INTEGER, required: true }
    110. 

  110.   volumegroup:
    111. 

  111.     _attributes: { phpName: EtvaVolumegroup }
    112. 

  112.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    113. 

  113.     cluster_id: { type: INTEGER, required: true, foreignTable: cluster, foreignReference: id, onDelete: restrict }
    114. 

  114.     uuid: { type: VARCHAR, size: '255' }
    115. 

  115.     vg: { type: VARCHAR, size: '255' }
    116. 

  116.     size: { type: BIGINT }
    117. 

  117.     freesize: { type: BIGINT }
    118. 

  118.     storage_type: { type: VARCHAR, size: '255' }
    119. 

  119.     inconsistent: { type: INTEGER, required: true }
    120. 

  120.   logicalvolume:
    121. 

  121.     _attributes: { phpName: EtvaLogicalvolume }
    122. 

  122.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    123. 

  123.     cluster_id: { type: INTEGER, required: true, foreignTable: cluster, foreignReference: id, onDelete: restrict }
    124. 

  124.     volumegroup_id: { type: INTEGER, required: true, foreignTable: volumegroup, foreignReference: id, onDelete: cascade }
    125. 

  125.     uuid: { type: VARCHAR, size: '255' }
    126. 

  126.     lv: { type: VARCHAR, size: '255' }
    127. 

  127.     lvdevice: { type: VARCHAR, size: '255' }
    128. 

  128.     size: { type: BIGINT }
    129. 

  129.     freesize: { type: BIGINT }
    130. 

  130.     storage_type: { type: VARCHAR, size: '255' }
    131. 

  131.     writeable: { type: INTEGER }
    132. 

  132.     in_use: { type: INTEGER, default: '0' }
    133. 

  133.     target: { type: VARCHAR, size: '255' }
    134. 

  134.     mounted: { type: INTEGER, default: '0' }
    135. 

  135.     snapshot: { type: INTEGER, default: '0' }
    136. 

  136.     origin: { type: VARCHAR, size: '255' }
    137. 

  137.     format: { type: VARCHAR, size: '255' }
    138. 

  138.     snapshot_node_id: { type: INTEGER }
    139. 

  139.     inconsistent: { type: INTEGER, required: true }
    140. 

  140.   vnc_token:
    141. 

  141.     _attributes: { phpName: EtvaVncToken }
    142. 

  142.     username: { type: VARCHAR, size: '255', primaryKey: true, required: true }
    143. 

  143.     token: { type: VARCHAR, size: '255', required: true }
    144. 

  144.     enctoken: { type: VARCHAR, size: '255', required: true }
    145. 

  145.     updated_at: { type: TIMESTAMP }
    146. 

  146.   service:
    147. 

  147.     _attributes: { phpName: EtvaService }
    148. 

  148.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    149. 

  149.     server_id: { type: INTEGER, required: true, foreignTable: server, foreignReference: id, onDelete: cascade }
    150. 

  150.     name_tmpl: { type: VARCHAR, size: '255' }
    151. 

  151.     description: { type: LONGVARCHAR }
    152. 

  152.     params: { type: LONGVARCHAR }
    153. 

  153.   setting:
    154. 

  154.     _attributes: { phpName: EtvaSetting }
    155. 

  155.     param: { type: VARCHAR, size: '255', primaryKey: true, required: true }
    156. 

  156.     value: { type: LONGVARCHAR }
    157. 

  157.   volume_physical:
    158. 

  158.     _attributes: { phpName: EtvaVolumePhysical }
    159. 

  159.     volumegroup_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: volumegroup, foreignReference: id, onDelete: cascade }
    160. 

  160.     physicalvolume_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: physicalvolume, foreignReference: id, onDelete: cascade }
    161. 

  161.   event:
    162. 

  162.     _attributes: { phpName: EtvaEvent }
    163. 

  163.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    164. 

  164.     level: { type: INTEGER }
    165. 

  165.     message: { type: LONGVARCHAR }
    166. 

  166.     created_at: { type: TIMESTAMP }
    167. 

  167.   server_logical:
    168. 

  168.     _attributes: { phpName: EtvaServerLogical }
    169. 

  169.     server_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: server, foreignReference: id, onDelete: cascade }
    170. 

  170.     logicalvolume_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: logicalvolume, foreignReference: id, onDelete: cascade }
    171. 

  171.     disk_type: { type: VARCHAR, size: '255' }
    172. 

  172.     boot_disk: { type: INTEGER, default: '0' }
    173. 

  173.   node_volumegroup:
    174. 

  174.     _attributes: { phpName: EtvaNodeVolumegroup }
    175. 

  175.     node_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: node, foreignReference: id, onDelete: cascade }
    176. 

  176.     volumegroup_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: volumegroup, foreignReference: id, onDelete: cascade }
    177. 

  177.     inconsistent: { type: INTEGER, required: true }
    178. 

  178.   node_physicalvolume:
    179. 

  179.     _attributes: { phpName: EtvaNodePhysicalvolume }
    180. 

  180.     node_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: node, foreignReference: id, onDelete: cascade }
    181. 

  181.     physicalvolume_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: physicalvolume, foreignReference: id, onDelete: cascade }
    182. 

  182.     device: { type: VARCHAR, size: '255' }
    183. 

  183.     inconsistent: { type: INTEGER, required: true }
    184. 

  184.   cluster:
    185. 

  185.     _attributes: { phpName: EtvaCluster }
    186. 

  186.     id: { type: INTEGER, primaryKey: true, required: true, autoIncrement: true }
    187. 

  187.     name: { type: VARCHAR, size: '255', required: true }
    188. 

  188.     isDefaultCluster: { type: INTEGER, required: true, default: '0' }
    189. 

  189.     hasNodeHA: { type: INTEGER, required: true, default: '0' }
    190. 

  190.     _uniques: { cluster_index1827: [name] }
    191. 

  191.   node_logicalvolume:
    192. 

  192.     _attributes: { phpName: EtvaNodeLogicalvolume }
    193. 

  193.     node_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: node, foreignReference: id, onDelete: cascade }
    194. 

  194.     logicalvolume_id: { type: INTEGER, primaryKey: true, required: true, foreignTable: logicalvolume, foreignReference: id, onDelete: cascade }
    195. 

  195.     inconsistent: { type: INTEGER, required: true }
    196. 

  196.   sessions:
    197. 

  197.     sess_id: { type: VARCHAR, size: '255', primaryKey: true, required: true }
    198. 

  198.     sess_data: { type: LONGVARCHAR }
    199. 

  199.     sess_time: { type: INTEGER }
    200. 

  200.   vnc_port:
    201. 

  201.     _attributes: { phpName: EtvaVncPort }
    202. 

  202.     id: { type: INTEGER, primaryKey: true, required: true }
    203. 

  203.     server_id: { type: INTEGER, required: true, foreignTable: server, foreignReference: id, onDelete: cascade }
    204. 

  204.     in_use: { type: INTEGER }
    205.