API tools faq
paste
Guest User

Untitled

a guest
Mar 10th, 2018
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.62 KB | None | 0 0
raw download clone embed print report
  1. smUser:
  2. tableName: sm_user
  3. actAs:
  4. Timestampable:
  5. created:
  6. name: created_at
  7. type: timestamp
  8. format:Y-m-d H:i:s
  9. options: []
  10. updated:
  11. name: updated_at
  12. type: timestamp
  13. format: Y-m-d H:i:s
  14. options: []
  15. columns:
  16. id:
  17. type: integer
  18. size: 8
  19. primary: true
  20. autoincrement: true
  21. username:
  22. type: string
  23. size: 128
  24. notnull: true
  25. unique: true
  26. email:
  27. type: string
  28. size: 128
  29. notnull: true
  30. algorithm:
  31. type: string
  32. size: 128
  33. default: sha1
  34. notnull: true
  35. salt:
  36. type: string
  37. size: 128
  38. notnull: true
  39. sha1password:
  40. type: string
  41. size: 128
  42. notnull: true
  43. last_login:
  44. type: timestamp
  45. size: null
  46. is_active:
  47. type: boolean
  48. size: null
  49. default: 1
  50. notnull: true
  51. has_confirmed:
  52. type: boolean
  53. size: null
  54. default: 1
  55. notnull: true
  56. is_super_admin:
  57. type: boolean
  58. size: null
  59. default: 0
  60. notnull: true
  61. relations:
  62. groups:
  63. class: smGroup
  64. foreignAlias: users
  65. refClass: smUserGroup
  66. local: user_id
  67. foreign: group_id
  68. permissions:
  69. class: smPermission
  70. foreignAlias: users
  71. refClass: smUserPermission
  72. local: user_id
  73. foreign: permission_id
  74.  
  75. smGroup:
  76. tableName: sm_group
  77. actAs:
  78. Timestampable:
  79. created:
  80. name: created_at
  81. type: timestamp
  82. format:Y-m-d H:i:s
  83. options: []
  84. updated:
  85. name: updated_at
  86. type: timestamp
  87. format: Y-m-d H:i:s
  88. options: []
  89. columns:
  90. id:
  91. type: integer
  92. size: 8
  93. primary: true
  94. autoincrement: true
  95. name:
  96. type: string
  97. size: 255
  98. notnull: true
  99. unique: true
  100. description:
  101. type: string
  102. size: 4000
  103. profile_id:
  104. type: integer
  105. size: 8
  106. relations:
  107. permissions:
  108. class: smPermission
  109. refClass: smGroupPermission
  110. local: group_id
  111. foreign: permission_id
  112. users:
  113. class: smUser
  114. refClass: smUserGroup
  115. local: group_id
  116. foreign: user_id
  117.  
  118. smUserGroup:
  119. tableName: sm_user_group
  120. actAs:
  121. Timestampable:
  122. created:
  123. name: created_at
  124. type: timestamp
  125. format:Y-m-d H:i:s
  126. options: []
  127. updated:
  128. name: updated_at
  129. type: timestamp
  130. format: Y-m-d H:i:s
  131. options: []
  132. columns:
  133. group_id:
  134. type: integer
  135. size: 8
  136. primary: true
  137. user_id:
  138. type: integer
  139. size: 8
  140. primary: true
  141. relations:
  142. smGroup:
  143. class: smGroup
  144. local: group_id
  145. onDelete: CASCADE
  146. smUser:
  147. class: smUser
  148. local: user_id
  149. onDelete: CASCADE
  150.  
  151. smPermission:
  152. tableName: sm_permission
  153. actAs:
  154. Timestampable:
  155. created:
  156. name: created_at
  157. type: timestamp
  158. format:Y-m-d H:i:s
  159. options: []
  160. updated:
  161. name: updated_at
  162. type: timestamp
  163. format: Y-m-d H:i:s
  164. options: []
  165. columns:
  166. id:
  167. type: integer
  168. size: 8
  169. primary: true
  170. autoincrement: true
  171. name:
  172. type: string
  173. size: 255
  174. notnull: true
  175. description:
  176. type: string
  177. size: 4000
  178. relations:
  179. groups:
  180. class: smGroup
  181. refClass: smGroupPermission
  182. local: permission_id
  183. foreign: group_id
  184. users:
  185. class: smUser
  186. refClass: smUserPermission
  187. local: permission_id
  188. foreign: user_id
  189.  
  190. smUserPermission:
  191. tableName: sm_user_permission
  192. actAs:
  193. Timestampable:
  194. created:
  195. name: created_at
  196. type: timestamp
  197. format:Y-m-d H:i:s
  198. options: []
  199. updated:
  200. name: updated_at
  201. type: timestamp
  202. format: Y-m-d H:i:s
  203. options: []
  204. columns:
  205. user_id:
  206. type: integer
  207. size: 8
  208. primary: true
  209. permission_id:
  210. type: integer
  211. size: 8
  212. primary: true
  213. relations:
  214. smUser:
  215. class: smUser
  216. local: user_id
  217. onDelete: CASCADE
  218. smPermission:
  219. class: smPermission
  220. local: permission_id
  221. onDelete: CASCADE
  222.  
  223. smGroupPermission:
  224. tableName: sm_group_permission
  225. actAs:
  226. Timestampable:
  227. created:
  228. name: created_at
  229. type: timestamp
  230. format:Y-m-d H:i:s
  231. options: []
  232. updated:
  233. name: updated_at
  234. type: timestamp
  235. format: Y-m-d H:i:s
  236. options: []
  237. columns:
  238. group_id:
  239. type: integer
  240. size: 8
  241. primary: true
  242. notnull: true
  243. permission_id:
  244. type: integer
  245. size: 8
  246. primary: true
  247. notnull: true
  248. relations:
  249. smGroup:
  250. class: smGroup
  251. local: group_id
  252. smPermission:
  253. class: smPermission
  254. local: permission_id
  255.  
  256. smSignUp:
  257. tableName: sm_sign_up
  258. actAs:
  259. Timestampable:
  260. created:
  261. name: created_at
  262. type: timestamp
  263. format:Y-m-d H:i:s
  264. options: []
  265. updated:
  266. name: updated_at
  267. type: timestamp
  268. format: Y-m-d H:i:s
  269. options: []
  270. columns:
  271. id:
  272. type: integer
  273. size: 8
  274. primary: true
  275. autoincrement: true
  276. confirm_code:
  277. type: string
  278. size: 32
  279. ip_address:
  280. type: string
  281. size: 15
  282. user_id:
  283. type: integer
  284. size: 8
  285. relations:
  286. smUser:
  287. foreignType: one
  288. local: user_id
  289. onDelete: CASCADE
  290.  
  291. smProfile:
  292. tableName: sm_profile
  293. actAs:
  294. Timestampable:
  295. created:
  296. name: created_at
  297. type: timestamp
  298. format:Y-m-d H:i:s
  299. options: []
  300. updated:
  301. name: updated_at
  302. type: timestamp
  303. format: Y-m-d H:i:s
  304. options: []
  305. columns:
  306. id:
  307. type: integer
  308. size: 8
  309. primary: true
  310. autoincrement: true
  311. name:
  312. type: string
  313. size: 255
  314. notnull: true
  315. unique: true
  316. profile_type_id:
  317. type: integer
  318. size: 8
  319. user_id:
  320. type: integer
  321. size: 8
  322. group_id:
  323. type: integer
  324. size: 8
  325. relations:
  326. smUser:
  327. foreignType: one
  328. local: user_id
  329. onDelete: CASCADE
  330. smGroup:
  331. foreignType: one
  332. local: group_id
  333. onDelete: CASCADE
  334. smProfileType:
  335. foreignType: one
  336. local: profile_type_id
  337. onDelete: CASCADE
  338.  
  339.  
  340.  
  341. smProfileType:
  342. tableName: sm_profile_type
  343. actAs:
  344. Timestampable:
  345. created:
  346. name: created_at
  347. type: timestamp
  348. format:Y-m-d H:i:s
  349. options: []
  350. updated:
  351. name: updated_at
  352. type: timestamp
  353. format: Y-m-d H:i:s
  354. options: []
  355. columns:
  356. id:
  357. type: integer
  358. size: 8
  359. primary: true
  360. autoincrement: true
  361. name:
  362. type: string
  363. size: 255
  364. notnull: true
  365. description:
  366. type: string
  367. size: 255
  368. notnull: true
  369. profile_id:
  370. type: integer
  371. size: 8
  372. relations:
  373. fields:
  374. class: smProfileField
  375. foreignAlias: profile_type
  376. refClass: smProfileTypeField
  377. local: profile_type_id
  378. foreign: profile_field_id
  379.  
  380. smProfileField:
  381. tableName: sm_profile_field
  382. actAs:
  383. Timestampable:
  384. created:
  385. name: created_at
  386. type: timestamp
  387. format:Y-m-d H:i:s
  388. options: []
  389. updated:
  390. name: updated_at
  391. type: timestamp
  392. format: Y-m-d H:i:s
  393. options: []
  394. columns:
  395. id:
  396. type: integer
  397. size: 8
  398. primary: true
  399. autoincrement: true
  400. name:
  401. type: string
  402. size: 255
  403. notnull: true
  404. description:
  405. type: string
  406. size: 255
  407. notnull: true
  408. fieldtype:
  409. type: string
  410. size: 100
  411. notnull: true
  412. options:
  413. type: string
  414. size: 4000
  415. relations:
  416. profile_type:
  417. class: smProfileType
  418. foreignAlias: fields
  419. refClass: smProfileTypeField
  420. local: profile_field_id
  421. foreign: profile_type_id
  422.  
  423. smProfileTypeField:
  424. tableName: sm_profile_type_field
  425. columns:
  426. profile_type_id:
  427. type: integer
  428. size: 8
  429. profile_field_id:
  430. type: integer
  431. size: 8
  432. position:
  433. type: integer
  434. size: 8
  435. relations:
  436. smProfileType:
  437. class: smProfileType
  438. local: profile_type_id
  439. onDelete: CASCADE
  440. smProfileField:
  441. class: smProfileField
  442. local: profile_field_id
  443. onDelete: CASCADE
  444.  
  445. smProfileValue:
  446. tableName: sm_profile_value
  447. actAs:
  448. Timestampable:
  449. created:
  450. name: created_at
  451. type: timestamp
  452. format:Y-m-d H:i:s
  453. options: []
  454. updated:
  455. name: updated_at
  456. type: timestamp
  457. format: Y-m-d H:i:s
  458. options: []
  459. columns:
  460. profile_field_id:
  461. type: integer
  462. size: 8
  463. notnull: true
  464. profile_id:
  465. type: integer
  466. size: 8
  467. notnull: true
  468. value:
  469. type: string
  470. size: 4000
  471. notnull: true
  472. profile_field_id:
  473. type: integer
  474. size: 8
  475. profile_id:
  476. type: integer
  477. size: 8
  478. relations:
  479. smProfileField:
  480. foreignType: one
  481. local: profile_field_id
  482. onDelete: CASCADE
  483. smProfile:
  484. local: profile_id
  485. foreignType: one
  486. onDelete: CASCADE
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!