API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 7th, 2017
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.04 KB | None | 0 0
raw download clone embed print report
  1. options:
  2. type: INNODB
  3. collate: utf8_czech_ci
  4. charset: utf8
  5. State:
  6. tableName: states
  7. columns:
  8. name:
  9. notnull: true
  10. type: string(150)
  11. shortcut: string(2)
  12. indexes:
  13. shortcut:
  14. type: unique
  15. fields: shortcut
  16. User:
  17. tableName: users
  18. actAs:
  19. QQC_Model_Template_Fulltext:
  20. type: user
  21. QQC_Model_Template_Authenticate:
  22. QQC_Model_Template_SoftDelete:
  23. Timestampable:
  24. created:
  25. name: created
  26. type: timestamp
  27. updated:
  28. name: updated
  29. type: timestamp
  30. Sluggable:
  31. unique: true
  32. fields: [nickname]
  33. canUpdate: false
  34. name: url
  35. columns:
  36. id_state: int(20)
  37. id_disabledBy: int(20)
  38. active:
  39. type: boolean
  40. default: false
  41. disabled:
  42. type: boolean
  43. default: false
  44. disableFor: string(250)
  45.  
  46. email:
  47. type: string(250)
  48. notnull: true
  49. unique: true
  50. password: string(40)
  51. nickname:
  52. unique: true
  53. type: string(200)
  54. firmname: string(250)
  55. surname: string(250)
  56. quakenetAuth: string(100)
  57. activateCode: string(10)
  58. relations:
  59. State:
  60. class: State
  61. local: id_state
  62. foreign: id
  63. foreignKeyName: User_State
  64. foreignType: one
  65. foreignAlias: Players
  66. Roles:
  67. class: User_Role
  68. local: id_user
  69. foreign: id_role
  70. refClass: User_Has_Role
  71. foreignKeyName: User_Roles
  72. foreignAlias: Users
  73. Logins:
  74. class: User_Login_Location
  75. local: id
  76. foreign: id_user
  77. type: many
  78. onDelete: CASCADE
  79. foreignKeyName: User_Logins
  80. foreignAlias: User
  81. DisabledBy:
  82. class: User
  83. local: id_disabledBy
  84. foreign: id
  85. foreignKeyName: User_Disabled
  86. foreignType: one
  87.  
  88. User_ChangePassword_Request:
  89. tableName: user_changepassword_requests
  90. actAs:
  91. QQC_Model_Template_IpAddress:
  92. QQC_Model_Template_UserAgent:
  93. Timestampable:
  94. created:
  95. name: created
  96. type: timestamp
  97. updated:
  98. name: updated
  99. type: timestamp
  100. columns:
  101. code:
  102. type: string(10)
  103. unique: true
  104. notnull: true
  105. id_user: int(20)
  106. used:
  107. type: boolean
  108. default: false
  109. relations:
  110. User:
  111. class: User
  112. local: id_user
  113. foreign: id
  114. foreignType: one
  115. foreignKeyName: ChangePasReq_user
  116. foreignAlias: ChangePasswordRequests
  117.  
  118. User_Login_Location:
  119. tableName: user_login_locations
  120. actAs:
  121. QQC_Model_Template_UserAgent:
  122. QQC_Model_Template_IpAddress:
  123. Timestampable:
  124. created:
  125. name: created
  126. type: timestamp
  127. updated:
  128. disabled: true
  129. columns:
  130. id_user: int(20)
  131. result: boolean
  132. User_Role:
  133. tableName: user_roles
  134. actAs:
  135. SoftDelete:
  136. Timestampable:
  137. created:
  138. name: created
  139. type: timestamp
  140. updated:
  141. name: updated
  142. type: timestamp
  143. columns:
  144. name:
  145. type: string(100)
  146. notnull: true
  147. canHaveMembers:
  148. type: boolean
  149. default: false
  150. id_inherit: int(20)
  151. addForVisitor:
  152. type: boolean
  153. default: false
  154. addForRegistered:
  155. type: boolean
  156. default: false
  157. relations:
  158. Inherit:
  159. class: User_Role
  160. local: id_inherit
  161. foreign: id
  162. foreignKeyName: Role_Inherit
  163. foreignType: one
  164. User_Has_Role:
  165. tableName: user_has_roles
  166. columns:
  167. id_user: int(20)
  168. id_role: int(20)
  169. indexes:
  170. unique:
  171. type: unique
  172. fields: [id_user, id_role]
  173. User_Award:
  174. tableName: user_awards
  175. listeners: [ QQC_Model_Listener_Author ]
  176. actAs:
  177. SoftDelete:
  178. Timestampable:
  179. created:
  180. name: created
  181. type: timestamp
  182. updated:
  183. name: updated
  184. type: timestamp
  185. Sluggable:
  186. unique: true
  187. fields: [name]
  188. canUpdate: false
  189. name: url
  190. columns:
  191. id_author: int(20)
  192. id_acceptor: int(20)
  193. id_category: int(20)
  194. name:
  195. type: string(200)
  196. notnull: true
  197. description: string(3000)
  198. accepted:
  199. type: boolean
  200. default: false
  201. indexes:
  202. name:
  203. type: unique
  204. fields: [name]
  205. relations:
  206. Author:
  207. class: User
  208. local: id_author
  209. foreign: id
  210. foreignType: one
  211. foreignKeyName: UserAward_Author
  212. foreignAlias: CreatedAwards
  213. Acceptor:
  214. class: User
  215. local: id_acceptor
  216. foreign: id
  217. foreignType: one
  218. foreignKeyName: UserAward_Acceptor
  219. foreignAlias: AcceptedAwards
  220. Category:
  221. class: User_Award_Category
  222. local: id_category
  223. foreign: id
  224. foreignType: one
  225. foreignKeyName: UserAward_Category
  226. foreignAlias: Awards
  227. User_Award_Category:
  228. tableName: user_award_categories
  229. actAs:
  230. SoftDelete:
  231. Timestampable:
  232. created:
  233. name: created
  234. type: timestamp
  235. updated:
  236. name: updated
  237. type: timestamp
  238. columns:
  239. name:
  240. type: string(200)
  241. notnull: true
  242. active:
  243. type: boolean
  244. default: false
  245. description: string(3000)
  246. indexes:
  247. name:
  248. type: unique
  249. fields: [name]
  250. User_Has_User_Award:
  251. tableName: user_has_user_awards
  252. listeners: [ QQC_Model_Listener_Author ]
  253. actAs:
  254. Timestampable:
  255. created:
  256. name: created
  257. type: timestamp
  258. updated:
  259. disabled: true
  260. columns:
  261. id_user: int(20)
  262. id_award: int(20)
  263. id_author: int(20)
  264. relations:
  265. Author:
  266. class: User
  267. local: id_author
  268. foreign: id
  269. foreignType: one
  270. foreignKeyName: UserHasAward_Author
  271. foreignAlias: DelegateAwards
  272. User:
  273. class: User
  274. local: id_user
  275. foreign: id
  276. foreignType: one
  277. foreignKeyName: UserHasAward_User
  278. foreignAlias: HasAwards
  279. Award:
  280. class: User_Award
  281. local: id_award
  282. foreign: id
  283. foreignType: one
  284. foreignKeyName: UserHasAward_Award
  285. foreignAlias: HasUsers
  286. indexes:
  287. unique:
  288. type: unique
  289. fields: [id_user, id_award]
  290. Article:
  291. tableName: articles
  292. listeners: [ QQC_Model_Listener_Author ]
  293. actAs:
  294. QQC_Model_Template_Fulltext:
  295. type: article
  296. QQC_Model_Template_SoftDelete:
  297. Versionable:
  298. versionColumn: version
  299. className: Article_Version
  300. auditLog: true
  301. Timestampable:
  302. created:
  303. name: created
  304. type: timestamp
  305. updated:
  306. name: updated
  307. type: timestamp
  308. Sluggable:
  309. unique: true
  310. fields: [title]
  311. canUpdate: false
  312. name: url
  313. columns:
  314. id_author: int(20)
  315. id_category: int(20)
  316. id_publisher: int(20)
  317. published: timestamp
  318. title:
  319. type: string(250)
  320. notnull: true
  321. perex:
  322. type: string(3000)
  323. notnull: true
  324. text: string(99999)
  325. countComments:
  326. type: int(20)
  327. default: 0
  328. avarageVoteFactor:
  329. type: decimal(10)
  330. scale: 2
  331. default: 0
  332. relations:
  333. Author:
  334. class: User
  335. local: id_author
  336. foreign: id
  337. foreignType: one
  338. foreignKeyName: Article_Author
  339. foreignAlias: Articles
  340. Publisher:
  341. class: User
  342. local: id_publisher
  343. foreign: id
  344. foreignType: one
  345. foreignKeyName: Article_Publisher
  346. foreignAlias: PublishedArticles
  347. Category:
  348. class: Category
  349. local: id_category
  350. foreign: id
  351. foreignType: one
  352. foreignKeyName: Article_Category
  353. foreignAlias: Articles
  354. Labels:
  355. class: Article_Has_Label
  356. local: id
  357. foreign: id_article
  358. foreignType: many
  359. foreignKeyName: Article_Labels
  360. foreignAlias: Articles
  361.  
  362. Article_Has_Label:
  363. inheritance:
  364. extends: Entity_Has_Label
  365. type: column_aggregation
  366. keyField: type
  367. keyValue: Article
  368. columns:
  369. id_article: int(20)
  370.  
  371. Label:
  372. tableName: labels
  373. listeners: [ QQC_Model_Listener_Author ]
  374. actAs:
  375. SoftDelete:
  376. Timestampable:
  377. created:
  378. name: created
  379. type: timestamp
  380. updated:
  381. disabled: true
  382. Sluggable:
  383. unique: true
  384. fields: [label]
  385. canUpdate: false
  386. name: url
  387. columns:
  388. label:
  389. type: string(100)
  390. notnull: true
  391. id_author: int(20)
  392. relations:
  393. Author:
  394. class: User
  395. local: id_author
  396. foreign: id
  397. type: one
  398. foreignKeyName: Label_Author
  399. foreignAlias: MyLabels
  400. Video:
  401. tableName: videos
  402. listeners: [ QQC_Model_Listener_Author ]
  403. actAs:
  404. SoftDelete:
  405. Timestampable:
  406. created:
  407. name: created
  408. type: timestamp
  409. updated:
  410. name: updated
  411. type: timestamp
  412. Sluggable:
  413. unique: true
  414. fields: [name]
  415. canUpdate: false
  416. name: url
  417. columns:
  418. name:
  419. type: string(250)
  420. notnull: true
  421. url: string(255)
  422. embed: string(3000)
  423. id_author: int(20)
  424. id_category: int(20)
  425. relations:
  426. Author:
  427. class: User
  428. local: id_author
  429. foreign: id
  430. type: one
  431. foreignKeyName: Video_Author
  432. foreignAlias: MyVideos
  433. Category:
  434. class: Video_Category
  435. local: id_category
  436. foreign: id
  437. type: one
  438. foreignKeyName: Video_Category
  439. foreignAlias: Videos
  440. Video_Category:
  441. tableName: video_category
  442. listeners: [ QQC_Model_Listener_Author ]
  443. actAs:
  444. SoftDelete:
  445. Sluggable:
  446. unique: true
  447. fields: [name]
  448. canUpdate: false
  449. name: url
  450. columns:
  451. id_author: int(20)
  452. name: string(50)
  453. active:
  454. type: boolean
  455. default: false
  456. description: string(3000)
  457. relations:
  458. Author:
  459. class: User
  460. local: id_author
  461. foreign: id
  462. type: one
  463. foreignKeyName: VideoCat_Author
  464. Video_Download_Url:
  465. tableName: video_download_url
  466. listeners: [ QQC_Model_Listener_Author ]
  467. columns:
  468. id_video: int(20)
  469. id_author: int(20)
  470. url: string(3000)
  471. death:
  472. type: boolean
  473. default: false
  474. relations:
  475. Author:
  476. class: User
  477. local: id_author
  478. foreign: id
  479. type: one
  480. foreignKeyName: VideoDownload_Author
  481. foreignAlias: MyVideoMirrors
  482. Video_User_Vote:
  483. tableName: video_user_votes
  484. listeners: [ QQC_Model_Listener_Author ]
  485. columns:
  486. id_video: int(20)
  487. id_author: int(20)
  488. id_value: int(20)
  489. relations:
  490. Author:
  491. class: User
  492. local: id_author
  493. foreign: id
  494. type: one
  495. foreignKeyName: VideoVote_Author
  496. foreignAlias: MyVotedVideos
  497.  
  498. Vote_Value:
  499. tableName: vote_value
  500. columns:
  501. value: int(1)
  502. label: string(50)
  503.  
  504. Article_Comment:
  505. inheritance:
  506. extends: Comment
  507. type: column_aggregation
  508. keyField: type
  509. keyValue: Article
  510. columns:
  511. id_article: int(20)
  512.  
  513. Category:
  514. tableName: articleCategories
  515. actAs:
  516. SoftDelete:
  517. Timestampable:
  518. created:
  519. name: created
  520. type: timestamp
  521. updated:
  522. name: updated
  523. type: timestamp
  524. Sluggable:
  525. unique: true
  526. fields: [name]
  527. canUpdate: false
  528. name: url
  529. columns:
  530. name:
  531. type: string(250)
  532. notnull: true
  533. description: string(5000)
  534. Game:
  535. tableName: games
  536. actAs:
  537. SoftDelete:
  538. Sluggable:
  539. unique: true
  540. fields: [name]
  541. canUpdate: false
  542. name: url
  543. columns:
  544. name: string(200)
  545. shortcut: string(10)
  546. id_superAdmin: int(11)
  547. relations:
  548. Admin:
  549. class: User
  550. local: id_superAdmin
  551. foreign: id
  552. foreignType: one
  553. foreignKeyName: Game_Admin
  554. indexes:
  555. shortcut:
  556. type: unique
  557. fields: shortcut
  558. Clan:
  559. tableName: clans
  560. actAs:
  561. SoftDelete:
  562. Sluggable:
  563. unique: true
  564. fields: [name]
  565. canUpdate: false
  566. name: url
  567. columns:
  568. id_clanleader: int(22)
  569. name: string(200)
  570. tag: string(50)
  571. irc: string(100)
  572. www: string(250)
  573. description: string(3000)
  574. relations:
  575. Clanleader:
  576. class: User
  577. local: id_clanleader
  578. foreign: id
  579. foreignType: one
  580. foreignKeyName: Clan_Leader
  581. indexes:
  582. tag:
  583. type: unique
  584. fields: tag
  585. Clan_Squad:
  586. tableName: clanSquads
  587. columns:
  588. id_clan:
  589. type: int(20)
  590. notnull: true
  591. id_leader: int(20)
  592. id_game:
  593. type: int(20)
  594. notnull: true
  595. id_gametype:
  596. type: int(20)
  597. notnull: true
  598. name:
  599. type: string(200)
  600. notnull: true
  601. relations:
  602. Leader:
  603. class: User
  604. local: id_leader
  605. foreign: id
  606. foreignType: one
  607. foreignKeyName: Squad_Leader
  608. foreignKeyName: SquadsLeader
  609. Clan:
  610. class: Clan
  611. local: id_clan
  612. foreign: id
  613. foreignType: one
  614. foreignKeyName: Squad_Clan
  615. foreignKeyName: Squads
  616. Game:
  617. class: Game
  618. local: id_game
  619. foreign: id
  620. foreignType: one
  621. foreignKeyName: Squad_Game
  622. foreignKeyName: Squads
  623. GameType:
  624. class: Game_Type
  625. local: id_gametype
  626. foreign: id
  627. foreignType: one
  628. foreignKeyName: Squad_GameType
  629. foreignKeyName: Squads
  630. indexes:
  631. unique:
  632. type: unique
  633. fields: [id_clan, id_game, id_gametype]
  634. Clan_Squad_Players:
  635. tableName: clanSquadPlayers
  636. actAs:
  637. SoftDelete:
  638. Timestampable:
  639. created:
  640. name: created
  641. type: timestamp
  642. updated:
  643. name: updated
  644. type: timestamp
  645. columns:
  646. id_squad:
  647. type: int(20)
  648. notnull: true
  649. id_user:
  650. type: int(20)
  651. notnull: true
  652. active:
  653. type: boolean
  654. default: false
  655. relations:
  656. Player:
  657. class: User
  658. local: id_user
  659. foreign: id
  660. foreignType: one
  661. foreignKeyName: SquadPlayers_User
  662. foreignAlias: Squads
  663. Squad:
  664. class: Clan_Squad
  665. local: id_squad
  666. foreign: id
  667. foreignType: one
  668. foreignKeyName: SquadPlayers_Squad
  669. foreignAlias: Players
  670. indexes:
  671. unique:
  672. type: unique
  673. fields: [id_squad, id_user, deleted_at]
  674. Map:
  675. tableName: maps
  676. actAs:
  677. SoftDelete:
  678. Sluggable:
  679. unique: true
  680. fields: [name]
  681. canUpdate: false
  682. name: url
  683. columns:
  684. id_game: int(22)
  685. name: string(100)
  686. shortcut: string(20)
  687. hasImage:
  688. type: boolean
  689. default: false
  690. relations:
  691. game:
  692. class: Game
  693. local: id_game
  694. foreign: id
  695. foreignType: one
  696. foreignKeyName: Map_Game
  697. foreignAlias: Maps
  698. indexes:
  699. gameMap:
  700. type: unique
  701. fields: [id_game,name]
  702. shortcut:
  703. type: unique
  704. fields: [id_game, shortcut]
  705. Maplist:
  706. tableName: maplists
  707. listeners: [ QQC_Model_Listener_Author ]
  708. actAs:
  709. SoftDelete:
  710. Sluggable:
  711. unique: true
  712. fields: [name]
  713. canUpdate: false
  714. name: url
  715. columns:
  716. id_game: int(20)
  717. id_gameType: int(20)
  718. id_author: int(20)
  719. name: string(100)
  720. shortcut: string(20)
  721. relations:
  722. game:
  723. class: Game
  724. local: id_game
  725. foreign: id
  726. foreignType: one
  727. foreignKeyName: Maplist_Game
  728. foreignAlias: Maplists
  729. gametype:
  730. class: Game_Type
  731. local: id_gameType
  732. foreignType: one
  733. foreignKeyName: Maplist_GameType
  734. foreignAlias: Maplists
  735. Author:
  736. class: User
  737. local: id_author
  738. foreign: id
  739. foreignType: one
  740. foreignKeyName: Maplist_Author
  741. foreignAlias: Maplists
  742. Maps:
  743. refClass: Map_Maplist
  744. local: id_maplist
  745. foreign: id_map
  746. foreignKeyName: Maplist_Map
  747. foreignAlias: Maplists
  748. onDelete: CASCADE
  749. onUpdate: CASCADE
  750. Map_Maplist:
  751. tableName: mapsInMaplists
  752. columns:
  753. id_map: int(20)
  754. id_maplist: int(20)
  755. indexes:
  756. uniq:
  757. type: unique
  758. fields: [id_map, id_maplist]
  759. Game_Type:
  760. tableName: gameTypes
  761. columns:
  762. name: string(100)
  763. shortcut: string(20)
  764. Tournament:
  765. tableName: tournaments
  766. actAs:
  767. SoftDelete:
  768. Sluggable:
  769. unique: true
  770. fields: [name]
  771. canUpdate: false
  772. name: url
  773. Timestampable:
  774. created:
  775. name: created
  776. type: timestamp
  777. updated:
  778. name: updated
  779. type: timestamp
  780. columns:
  781. id_superAdmin: int(20)
  782. id_game: int(20)
  783. id_gametype: int(20)
  784. id_article: int(20)
  785. id_maplist: int(20)
  786. start: timestamp
  787. checkin: timestamp
  788. name: string(250)
  789. relations:
  790. SuperAdmin:
  791. class: User
  792. local: id_superAdmin
  793. foreign: id
  794. foreignType: one
  795. foreignKeyName: Tourney_SuperAdmin
  796. Game:
  797. class: Game
  798. local: id_game
  799. foreign: id
  800. foreignType: one
  801. foreignKeyName: Tourney_Game
  802. foreignAlias: Tournaments
  803. GameType:
  804. class: Game_Type
  805. local: id_gametype
  806. foreign: id
  807. foreignType: one
  808. foreignKeyName: Tourney_GameType
  809. foreignAlias: Tournaments
  810. Article:
  811. class: Article
  812. local: id_article
  813. foreign: id
  814. foreignType: one
  815. foreignKeyName: Tourney_Article
  816. Maplist:
  817. class: Maplist
  818. local: id_maplist
  819. foreign: id
  820. foreignType: one
  821. foreignKeyName: Tourney_Maplist
  822. foreignAlias: Tournaments
  823. Admins:
  824. refclass: Tournament_Admins
  825. local: id_tournament
  826. foreign: id_user
  827. foreignKeyName: Tourney_Admins
  828. onDelete: CASCADE
  829. onUpdate: CASCADE
  830. Matches:
  831. class: Tournament_Match
  832. type: many
  833. local: id
  834. foreign: id_tournament
  835. foreignKeyName: Tourney_Matchs
  836. foreignAlias: Tournament
  837. onDelete: CASCADE
  838. onUpdate: CASCADE
  839. Tournament_Admins:
  840. tableName: tournamentAdmins
  841. columns:
  842. id_tournament: int(20)
  843. id_user: int(20)
  844. Tournament_Players:
  845. tableName: tournamentPlayers
  846. actAs:
  847. Timestampable:
  848. created:
  849. name: signed
  850. type: timestamp
  851. updated:
  852. name: updated
  853. type: timestamp
  854. columns:
  855. id_tournament: int(20)
  856. id_user: int(20)
  857. checked:
  858. type: boolean
  859. default: false
  860. checkinTime: timestamp
  861. relations:
  862. Player:
  863. class: User
  864. local: id_user
  865. foreign: id
  866. foreignType: one
  867. foreignKeyName: Players_User
  868. foreignAlias: Tournaments
  869. Tournament:
  870. class: Tournament
  871. local: id_tournament
  872. foreign: id
  873. foreignKeyName: Players_Tournament
  874. foreignAlias: Players
  875. Tournament_Match:
  876. tableName: tournamentMatch
  877. actAs:
  878. Timestampable:
  879. created:
  880. name: created
  881. type: timestamp
  882. updated:
  883. name: updated
  884. type: timestamp
  885. columns:
  886. id_tournament: int(20)
  887. Tournament_Match_Map:
  888. tableName: tournamentMatchMap
  889. actAs:
  890. Timestampable:
  891. created:
  892. name: created
  893. type: timestamp
  894. updated:
  895. name: updated
  896. type: timestamp
  897. columns:
  898. id_match: int(20)
  899. firstScore: int(10)
  900. secondScore: int(10)
  901. relations:
  902. Match:
  903. class: Tournament_Match
  904. local: id_match
  905. foreign: id
  906. foreignType: one
  907. foreignKeyName: Map_Match
  908. foreignAlias: Maps
  909. Poll:
  910. tableName: polls
  911. listeners: [ QQC_Model_Listener_Author ]
  912. actAs:
  913. SoftDelete:
  914. Timestampable:
  915. created:
  916. name: created
  917. type: timestamp
  918. updated:
  919. name: updated
  920. type: timestamp
  921. columns:
  922. id_author: int(20)
  923. question: string(250)
  924. active:
  925. type: boolean
  926. default: false
  927. allowForVisitors:
  928. type: boolean
  929. default: false
  930. top:
  931. type: boolean
  932. default: false
  933. relations:
  934. Author:
  935. class: User
  936. local: id_author
  937. foreign: id
  938. foreignType: one
  939. foreignKeyName: Polls_Author
  940. foreignAlias: Polls
  941. Options:
  942. class: Poll_Option
  943. local: id
  944. foreign: id_poll
  945. type: many
  946. foreignKeyName: Poll_Options
  947. foreignAlias: Poll
  948.  
  949. Poll_Option:
  950. tableName: pollOptions
  951. actAs:
  952. SoftDelete:
  953. columns:
  954. id_poll: int(20)
  955. value:
  956. type: string(250)
  957. notnull: true
  958. votes:
  959. type: int
  960. default: 0
  961.  
  962. Poll_User_Vote:
  963. tableName: pollUserVotes
  964. actAs:
  965. Timestampable:
  966. created:
  967. name: created
  968. type: timestamp
  969. updated:
  970. disabled: true
  971. columns:
  972. id_user: int(20)
  973. id_option: int(20)
  974. relations:
  975. Author:
  976. class: User
  977. local: id_user
  978. foreign: id
  979. foreignType: one
  980. foreignKeyName: Vote_User
  981. foreignAlias: PollVotes
  982. Option:
  983. class: Poll_Option
  984. local: id_option
  985. foreign: id
  986. foreignType: one
  987. foreignKeyName: Vote_Option
  988. foreignAlias: Votes
  989. Web_Acl:
  990. tableName: web_acl
  991. columns:
  992. id_inherit: int(20)
  993. name: string(200)
  994. module: string(100)
  995. controller: string(100)
  996. action: string(100)
  997. resource: string(100)
  998. relations:
  999. Inherit:
  1000. class: Web_Acl
  1001. local: id_inherit
  1002. foreign: id
  1003. foreignKeyName: WebAcl_Inherit
  1004. foreignType: one
  1005. Web_Acl_Settings:
  1006. tableName: web_acl_settings
  1007. columns:
  1008. id_acl: int(20)
  1009. id_role: int(20)
  1010. allow:
  1011. type: boolean
  1012. default: false
  1013. relations:
  1014. Role:
  1015. class: User_Role
  1016. local: id_role
  1017. foreign: id
  1018. foreignType: One
  1019. foreignKeyName: AclSettings_Role
  1020. foreignAlias: AclSettings
  1021. Acl:
  1022. class: Web_Acl
  1023. local: id_Acl
  1024. foreign: id
  1025. foreignType: One
  1026. foreignKeyName: AclSettings_Acl
  1027. foreignAlias: AclSettings
  1028.  
  1029. # ============================ BASE CLASSES ==========================
  1030. Entity_Has_Label:
  1031. tableName: entity_has_label
  1032. actAs:
  1033. Timestampable:
  1034. created:
  1035. name: created
  1036. type: timestamp
  1037. updated:
  1038. disabled: true
  1039. columns:
  1040. type:
  1041. type: string(10)
  1042. fixed: true
  1043. notnull: true
  1044. id_label:
  1045. type: int(20)
  1046. notnull: true
  1047. id_author:
  1048. type: int(20)
  1049. notnull: true
  1050. relations:
  1051. Author:
  1052. class: User
  1053. local: id_author
  1054. foreign: id
  1055. type: one
  1056. foreignKeyName: Entity_Label_Author
  1057. foreignAlias: MyAddedLabels
  1058. Label:
  1059. class: Label
  1060. local: id_label
  1061. foreign: id
  1062. foreignType: many
  1063. foreignKeyName: EntityLabel_Label
  1064. foreignAlias: Entities
  1065. indexes:
  1066. typeIdx:
  1067. fields: [type]
  1068.  
  1069. Comment:
  1070. tableName: comments
  1071. listeners: [ QQC_Model_Listener_Author ]
  1072. actAs:
  1073. QQC_Model_Template_Fulltext:
  1074. type: comment
  1075. QQC_Model_Template_IpAddress:
  1076. QQC_Model_Template_UserAgent:
  1077. QQC_Model_Template_SoftDelete:
  1078. Timestampable:
  1079. created:
  1080. name: created
  1081. type: timestamp
  1082. updated:
  1083. disabled: true
  1084. NestedSet:
  1085. hasManyRoots: true
  1086. rootColumnName: id_root
  1087. columns:
  1088. type:
  1089. type: string(10)
  1090. fixed: true
  1091. notnull: true
  1092. id_author: int(20)
  1093. nickname: string(100)
  1094. plus:
  1095. type: int
  1096. default: 0
  1097. minus:
  1098. type: int
  1099. default: 0
  1100. spam:
  1101. type: int
  1102. default: 0
  1103. text:
  1104. type: string(3000)
  1105. notnull: true
  1106. relations:
  1107. Author:
  1108. class: User
  1109. local: id_author
  1110. foreign: id
  1111. foreignType: many
  1112. foreignKeyName: Comment_Author
  1113. foreignAlias: Comments
  1114. Article:
  1115. class: Article
  1116. local: id_article
  1117. foreign: id
  1118. foreignType: many
  1119. foreignKeyName: Comment_Article
  1120. foreignAlias: Comments
  1121. indexes:
  1122. typeIdx:
  1123. fields: [type]
  1124.  
  1125. Feedback:
  1126. tableName: feedbacks
  1127. actAs:
  1128. SoftDelete:
  1129. QQC_Model_Template_IpAddress:
  1130. QQC_Model_Template_UserAgent:
  1131. QQC_Model_Template_Author:
  1132. notnull: false
  1133. foreignKeyName: Feedback_Author
  1134. foreignAlias: Feedbacks
  1135. Timestampable:
  1136. created:
  1137. name: created
  1138. type: timestamp
  1139. updated:
  1140. disabled: true
  1141. columns:
  1142. author: string(30)
  1143. text: string(3000)
  1144. url: string(255)
  1145.  
  1146. Rating:
  1147. tableName: ratings
  1148. columns:
  1149. type:
  1150. type: string(10)
  1151. fixed: true
  1152. notnull: true
  1153. id_author: int(20)
  1154. nickname: string(100)
  1155. grade:
  1156. type: int(20)
  1157. notnull: true
  1158. relations:
  1159. Author:
  1160. class: User
  1161. local: id_author
  1162. foreign: id
  1163. foreignType: many
  1164. foreignKeyName: Rating_Author
  1165. foreignAlias: Ratings
  1166. Vote_Value:
  1167. class: Vote_Value
  1168. local: id
  1169. foreign: id
  1170. foreignType: many
  1171. foreignKeyName: Rating_Vote
  1172. foreignAlias: Ratings
  1173. indexes:
  1174. typeIdx:
  1175. fields: [type]
  1176.  
  1177. Article_Vote:
  1178. inheritance:
  1179. extends: Vote
  1180. type: column_aggregation
  1181. keyField: type
  1182. keyValue: Article
  1183.  
  1184. Video_Vote:
  1185. inheritance:
  1186. extends: Vote
  1187. type: column_aggregation
  1188. keyField: type
  1189. keyValue: Video
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!