API tools faq
paste
Guest User

Untitled

a guest
May 8th, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.62 KB | None | 0 0
raw download clone embed print report
  1. propel:
  2. _attributes:
  3. package: lib.model
  4. defaultIdMethod: native
  5. badlog:
  6. _attributes: { phpName: Badlog }
  7. id: { type: INTEGER, size: '11', autoIncrement: true, required: true }
  8. date: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  9. login: { type: VARCHAR, size: '64', required: true }
  10. pwd: { type: VARCHAR, size: '64', required: true }
  11. ip: { type: VARCHAR, size: '64', required: true }
  12. info1: { type: LONGVARCHAR, required: true }
  13. info2: { type: LONGVARCHAR, required: true }
  14. _uniques: { id: [id] }
  15. bas:
  16. _attributes: { phpName: Bas }
  17. base_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  18. ord: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  19. active: { type: TINYINT, size: '4', required: true, defaultValue: '0' }
  20. server_host: { type: VARCHAR, size: '64', required: true }
  21. server_port: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  22. server_sqlengine: { type: VARCHAR, size: '20', required: true }
  23. server_dbname: { type: VARCHAR, size: '64', required: true }
  24. server_user: { type: VARCHAR, size: '64', required: true }
  25. server_pwd: { type: VARCHAR, size: '64', required: true }
  26. server_coll_id: { type: BIGINT, size: '20', required: true, defaultValue: '0' }
  27. displaydoc: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  28. usrid_mail: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  29. aliases: { type: LONGVARCHAR, required: true }
  30. sbas_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  31. _indexes: { host: [server_host], port: [server_port], dbname: [server_dbname] }
  32. basusr:
  33. _attributes: { phpName: Basusr }
  34. id: { type: BIGINT, size: '11', primaryKey: true, autoIncrement: true, required: true }
  35. base_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  36. usr_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  37. canpreview: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  38. canhd: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  39. canputinalbum: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  40. candwnldhd: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  41. candwnldsubdef: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  42. candwnldpreview: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  43. cancmd: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  44. canadmin: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  45. actif: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  46. canreport: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  47. canpush: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  48. creationdate: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  49. basusr_infousr: { type: LONGVARCHAR, required: true }
  50. mask_and: { type: BIGINT, size: '20', required: true, defaultValue: '0' }
  51. mask_xor: { type: BIGINT, size: '20', required: true, defaultValue: '0' }
  52. restrict_dwnld: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  53. month_dwnld_max: { type: INTEGER, size: '10', required: true, defaultValue: '0' }
  54. remain_dwnld: { type: INTEGER, size: '10', required: true, defaultValue: '0' }
  55. time_limited: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  56. limited_from: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  57. limited_to: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  58. canaddrecord: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  59. canmodifrecord: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  60. candeleterecord: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  61. chgstatus: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  62. lastconn: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  63. imgtools: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  64. manage: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  65. modify_struct: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  66. bas_manage: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  67. bas_modify_struct: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  68. needwatermark: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  69. _indexes: { basid: [base_id], usrid: [usr_id] }
  70. _uniques: { unik: [base_id, usr_id] }
  71. bmodel:
  72. _attributes: { phpName: Bmodel }
  73. bmodel_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  74. name: { type: VARCHAR, size: '64', required: true }
  75. prefstruct: { type: LONGVARCHAR, required: true }
  76. collprefs: { type: LONGVARCHAR, required: true }
  77. cache:
  78. _attributes: { phpName: Cache }
  79. session_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  80. nact: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  81. lastaccess: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  82. answers: { type: BLOB, required: true }
  83. spots: { type: BLOB, required: true }
  84. session: { type: BLOB, required: true }
  85. dist_logid: { type: BLOB, required: true }
  86. thesaurus: { type: CLOB, required: true }
  87. app: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  88. appinf: { type: CLOB, required: true }
  89. demand:
  90. _attributes: { phpName: Demand }
  91. date_modif: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  92. usr_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  93. base_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  94. en_cours: { type: TINYINT, size: '3', primaryKey: true, required: true, defaultValue: '0' }
  95. refuser: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  96. dsel:
  97. _attributes: { phpName: Dsel }
  98. id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  99. name: { type: CHAR, size: '50', primaryKey: true, required: true }
  100. usr_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  101. query: { type: CHAR, size: '255', required: true }
  102. bases: { type: CHAR, size: '255', required: true }
  103. _uniques: { id: [id] }
  104. fam:
  105. _attributes: { phpName: Fam }
  106. fam_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  107. name: { type: CHAR, size: '64', required: true }
  108. fambas:
  109. _attributes: { phpName: Fambas }
  110. id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  111. fam_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  112. base_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  113. findpwd:
  114. _attributes: { phpName: Findpwd }
  115. id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  116. date: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  117. sendto: { type: VARCHAR, size: '128', required: true }
  118. message: { type: CLOB, required: true }
  119. ip: { type: VARCHAR, size: '64', required: true }
  120. detailsip: { type: CLOB, required: true }
  121. ftppreconf:
  122. _attributes: { phpName: Ftppreconf }
  123. id: { type: INTEGER, size: '11', autoIncrement: true, required: true }
  124. name: { type: CHAR, size: '128', required: true }
  125. nbretry: { type: TINYINT, size: '3', required: true, defaultValue: '5' }
  126. mail: { type: CHAR, size: '255', required: true }
  127. addr: { type: CHAR, size: '255', required: true }
  128. login: { type: CHAR, size: '255', required: true }
  129. pwd: { type: CHAR, size: '255', required: true }
  130. passif: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  131. destfolder: { type: CHAR, size: '255', required: true }
  132. sbasid: { type: BIGINT, size: '11', required: true, defaultValue: '0' }
  133. _uniques: { id: [id] }
  134. ftptask:
  135. _attributes: { phpName: Ftptask }
  136. id: { type: INTEGER, size: '11', autoIncrement: true, required: true }
  137. crash: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  138. nbretry: { type: TINYINT, size: '3', required: true, defaultValue: '5' }
  139. mail: { type: VARCHAR, size: '255', required: true }
  140. addr: { type: VARCHAR, size: '255', required: true }
  141. login: { type: VARCHAR, size: '255', required: true }
  142. pwd: { type: VARCHAR, size: '255', required: true }
  143. passif: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  144. scrutedfolder: { type: VARCHAR, size: '255', required: true }
  145. destfolder: { type: VARCHAR, size: '255', required: true }
  146. state: { type: CLOB, required: true }
  147. sendermail: { type: VARCHAR, size: '255', required: true }
  148. text_mail_sender: { type: CLOB, required: true }
  149. text_mail_receiver: { type: CLOB, required: true }
  150. buffer: { type: CLOB, required: true }
  151. sessionid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  152. usrid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  153. reportlogin: { type: VARCHAR, size: '50', required: true }
  154. prov: { type: VARCHAR, size: '255', required: true }
  155. date: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  156. foldertocreate: { type: VARCHAR, size: '128', required: true }
  157. _uniques: { id: [id] }
  158. ftptaskfile:
  159. _attributes: { phpName: Ftptaskfile }
  160. id: { type: BIGINT, size: '11', primaryKey: true, autoIncrement: true, required: true }
  161. ftptask_id: { type: BIGINT, size: '11', required: true, defaultValue: '0' }
  162. bid: { type: BIGINT, size: '11', required: true, defaultValue: '0' }
  163. rid: { type: BIGINT, size: '11', required: true, defaultValue: '0' }
  164. sbid: { type: BIGINT, size: '11', required: true, defaultValue: '0' }
  165. binexp: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  166. originalName: { type: CHAR, size: '255', required: true }
  167. _indexes: { ftptask_id: [ftptask_id] }
  168. recusr:
  169. _attributes: { phpName: Recusr }
  170. record_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  171. sbas_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  172. usr_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  173. rate: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  174. comment: { type: LONGVARCHAR, required: true }
  175. recusr_datmaj: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  176. sbas:
  177. _attributes: { phpName: Sbas }
  178. sbas_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  179. ord: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  180. host: { type: CHAR, size: '64', required: true }
  181. port: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  182. dbname: { type: CHAR, size: '64', required: true }
  183. sqlengine: { type: CHAR, size: '20', required: true }
  184. user: { type: CHAR, size: '64', required: true }
  185. pwd: { type: CHAR, size: '64', required: true }
  186. thesaurus_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  187. viewname: { type: CHAR, size: '128', required: true }
  188. indexable: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
  189. _uniques: { server: [host, port, dbname] }
  190. sbasusr:
  191. _attributes: { phpName: Sbasusr }
  192. sbasusr_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  193. sbas_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  194. usr_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  195. bas_manage: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  196. bas_modify_struct: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  197. bas_modif_th: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  198. bas_chupub: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  199. _uniques: { unikid: [usr_id, sbas_id] }
  200. sitepreff:
  201. _attributes: { phpName: Sitepreff }
  202. id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  203. preffs: { type: CLOB, required: true }
  204. version: { type: VARCHAR, size: '128', required: true }
  205. maj: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  206. ssel:
  207. _attributes: { phpName: Ssel }
  208. ssel_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  209. usr_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  210. name: { type: CHAR, size: '50', required: true, defaultValue: '0' }
  211. pushFrom: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  212. date: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  213. descript: { type: LONGVARCHAR, required: true }
  214. temporaryType: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  215. rid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  216. sbas_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  217. status: { type: INTEGER, size: '4', required: true, defaultValue: '0' }
  218. public: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  219. pub_restrict: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  220. homelink: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  221. pub_date: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  222. updater: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  223. _indexes: { homelink: [homelink] }
  224. sselcont:
  225. _attributes: { phpName: Sselcont }
  226. sselcont_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  227. ssel_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  228. base_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  229. record_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  230. canHD: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  231. ord: { type: BIGINT, size: '11', required: true, defaultValue: '0' }
  232. _uniques: { ssel_ssel_id: [ssel_id, base_id, record_id] }
  233. sselcontusr:
  234. _attributes: { phpName: Sselcontusr }
  235. sselcont_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  236. usr_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  237. agree: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  238. date_maj: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  239. canHD: { type: VARCHAR, size: '1', required: true, defaultValue: '0' }
  240. canRate: { type: VARCHAR, size: '1', required: true, defaultValue: '0' }
  241. canAgree: { type: VARCHAR, size: '1', required: true, defaultValue: '0' }
  242. canSeeOther: { type: VARCHAR, size: '1', required: true, defaultValue: '0' }
  243. canZone: { type: VARCHAR, size: '1', required: true, defaultValue: '0' }
  244. dateFin: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  245. sselcontusrzone:
  246. _attributes: { phpName: Sselcontusrzone }
  247. sselcont_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  248. zone_id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  249. usr_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  250. height: { type: FLOAT, required: true, defaultValue: '0' }
  251. width: { type: FLOAT, required: true, defaultValue: '0' }
  252. top: { type: FLOAT, required: true, defaultValue: '0' }
  253. left_: { type: FLOAT, required: true, defaultValue: '0' }
  254. titre: { type: LONGVARCHAR, required: true }
  255. comment: { type: LONGVARCHAR, required: true }
  256. date_maj: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  257. deleted: { type: VARCHAR, size: '1', required: true, defaultValue: '0' }
  258. sselnew:
  259. _attributes: { phpName: Sselnew }
  260. id: { type: INTEGER, size: '11', primaryKey: true, autoIncrement: true, required: true }
  261. ssel_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  262. usr_id: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  263. _uniques: { couple: [ssel_id, usr_id] }
  264. task:
  265. _attributes: { phpName: Task }
  266. task_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  267. socket: { type: VARCHAR, size: '50', required: true }
  268. running: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  269. crashed: { type: INTEGER, size: '2', required: true, defaultValue: '0' }
  270. active: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  271. name: { type: VARCHAR, size: '100', required: true }
  272. base_id: { type: BIGINT, size: '20', required: true, defaultValue: '0' }
  273. period: { type: INTEGER, size: '3', required: true, defaultValue: '0' }
  274. last_exec_time: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  275. cmd: { type: LONGVARCHAR, required: true }
  276. prefs: { type: LONGVARCHAR, required: true }
  277. uids:
  278. _attributes: { phpName: Uids }
  279. uid: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  280. name: { type: CHAR, size: '16', primaryKey: true, required: true }
  281. usr:
  282. _attributes: { phpName: Usr }
  283. usr_id: { type: INTEGER, size: '11', primaryKey: true, required: true, defaultValue: '0' }
  284. ldap_created: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  285. desktop: { type: LONGVARCHAR, required: true }
  286. usr_sexe: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  287. usr_nom: { type: VARCHAR, size: '50', required: true }
  288. usr_prenom: { type: VARCHAR, size: '50', required: true }
  289. usr_login: { type: VARCHAR, size: '50', required: true }
  290. usr_password: { type: VARCHAR, size: '50', required: true }
  291. query0: { type: VARCHAR, size: '64', required: true }
  292. usr_pfxquery: { type: VARCHAR, size: '50', required: true }
  293. usr_sfxquery: { type: VARCHAR, size: '50', required: true }
  294. usr_cansendchu: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  295. usr_mail: { type: VARCHAR, size: '64', required: true }
  296. usr_creationdate: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  297. usr_modificationdate: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  298. adresse: { type: LONGVARCHAR, required: true }
  299. ville: { type: VARCHAR, size: '64', required: true }
  300. cpostal: { type: VARCHAR, size: '32', required: true }
  301. tel: { type: VARCHAR, size: '32', required: true }
  302. fax: { type: VARCHAR, size: '32', required: true }
  303. fonction: { type: VARCHAR, size: '64', required: true }
  304. societe: { type: VARCHAR, size: '64', required: true }
  305. activite: { type: VARCHAR, size: '200', required: true }
  306. issuperu: { type: INTEGER, size: '1', required: true, defaultValue: '0' }
  307. code8: { type: INTEGER, size: '10', required: true, defaultValue: '0' }
  308. pays: { type: VARCHAR, size: '64', required: true }
  309. usr_activite_id: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  310. last_conn: { type: TIMESTAMP, required: true, defaultValue: '0000-00-00 00:00:00' }
  311. model_of: { type: INTEGER, size: '11', required: true, defaultValue: '0' }
  312. seepwd: { type: TINYINT, size: '2', required: true, defaultValue: '0' }
  313. create_db: { type: TINYINT, size: '3', required: true, defaultValue: '0' }
  314. activeFTP: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  315. addrFTP: { type: VARCHAR, size: '128', required: true }
  316. loginFTP: { type: VARCHAR, size: '128', required: true }
  317. pwdFTP: { type: VARCHAR, size: '128', required: true }
  318. destFTP: { type: VARCHAR, size: '128', required: true }
  319. passifFTP: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  320. retryFTP: { type: TINYINT, size: '1', required: true, defaultValue: '5' }
  321. defaultftpdatasent: { type: BIGINT, size: '20', required: true, defaultValue: '0' }
  322. prefixFTPfolder: { type: VARCHAR, size: '100', required: true }
  323. forceClient: { type: TINYINT, size: '1', required: true, defaultValue: '0' }
  324. lastModel: { type: VARCHAR, size: '50', required: true }
  325. canchgprofil: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
  326. canchgftpprofil: { type: TINYINT, size: '1', required: true, defaultValue: '1' }
  327. _uniques: { usr_login: [usr_login] }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!