API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 10th, 2017
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 67.24 KB | None | 0 0
raw download clone embed print report
  1. Attachments:
  2. connection: redmine
  3. tableName: attachments
  4. columns:
  5. id:
  6. type: integer(4)
  7. fixed: false
  8. unsigned: false
  9. primary: true
  10. autoincrement: true
  11. container_id:
  12. type: integer(4)
  13. fixed: false
  14. unsigned: false
  15. primary: false
  16. default: '0'
  17. notnull: true
  18. autoincrement: false
  19. container_type:
  20. type: string(30)
  21. fixed: false
  22. unsigned: false
  23. primary: false
  24. default: ''
  25. notnull: true
  26. autoincrement: false
  27. filename:
  28. type: string(255)
  29. fixed: false
  30. unsigned: false
  31. primary: false
  32. default: ''
  33. notnull: true
  34. autoincrement: false
  35. disk_filename:
  36. type: string(255)
  37. fixed: false
  38. unsigned: false
  39. primary: false
  40. default: ''
  41. notnull: true
  42. autoincrement: false
  43. filesize:
  44. type: integer(4)
  45. fixed: false
  46. unsigned: false
  47. primary: false
  48. default: '0'
  49. notnull: true
  50. autoincrement: false
  51. content_type:
  52. type: string(255)
  53. fixed: false
  54. unsigned: false
  55. primary: false
  56. default: ''
  57. notnull: false
  58. autoincrement: false
  59. digest:
  60. type: string(40)
  61. fixed: false
  62. unsigned: false
  63. primary: false
  64. default: ''
  65. notnull: true
  66. autoincrement: false
  67. downloads:
  68. type: integer(4)
  69. fixed: false
  70. unsigned: false
  71. primary: false
  72. default: '0'
  73. notnull: true
  74. autoincrement: false
  75. author_id:
  76. type: integer(4)
  77. fixed: false
  78. unsigned: false
  79. primary: false
  80. default: '0'
  81. notnull: true
  82. autoincrement: false
  83. created_on:
  84. type: timestamp(25)
  85. fixed: false
  86. unsigned: false
  87. primary: false
  88. notnull: false
  89. autoincrement: false
  90. description:
  91. type: string(255)
  92. fixed: false
  93. unsigned: false
  94. primary: false
  95. notnull: false
  96. autoincrement: false
  97. AuthSources:
  98. connection: redmine
  99. tableName: auth_sources
  100. columns:
  101. id:
  102. type: integer(4)
  103. fixed: false
  104. unsigned: false
  105. primary: true
  106. autoincrement: true
  107. type:
  108. type: string(30)
  109. fixed: false
  110. unsigned: false
  111. primary: false
  112. default: ''
  113. notnull: true
  114. autoincrement: false
  115. name:
  116. type: string(60)
  117. fixed: false
  118. unsigned: false
  119. primary: false
  120. default: ''
  121. notnull: true
  122. autoincrement: false
  123. host:
  124. type: string(60)
  125. fixed: false
  126. unsigned: false
  127. primary: false
  128. notnull: false
  129. autoincrement: false
  130. port:
  131. type: integer(4)
  132. fixed: false
  133. unsigned: false
  134. primary: false
  135. notnull: false
  136. autoincrement: false
  137. account:
  138. type: string(255)
  139. fixed: false
  140. unsigned: false
  141. primary: false
  142. notnull: false
  143. autoincrement: false
  144. account_password:
  145. type: string(60)
  146. fixed: false
  147. unsigned: false
  148. primary: false
  149. notnull: false
  150. autoincrement: false
  151. base_dn:
  152. type: string(255)
  153. fixed: false
  154. unsigned: false
  155. primary: false
  156. notnull: false
  157. autoincrement: false
  158. attr_login:
  159. type: string(30)
  160. fixed: false
  161. unsigned: false
  162. primary: false
  163. notnull: false
  164. autoincrement: false
  165. attr_firstname:
  166. type: string(30)
  167. fixed: false
  168. unsigned: false
  169. primary: false
  170. notnull: false
  171. autoincrement: false
  172. attr_lastname:
  173. type: string(30)
  174. fixed: false
  175. unsigned: false
  176. primary: false
  177. notnull: false
  178. autoincrement: false
  179. attr_mail:
  180. type: string(30)
  181. fixed: false
  182. unsigned: false
  183. primary: false
  184. notnull: false
  185. autoincrement: false
  186. onthefly_register:
  187. type: integer(1)
  188. fixed: false
  189. unsigned: false
  190. primary: false
  191. default: '0'
  192. notnull: true
  193. autoincrement: false
  194. tls:
  195. type: integer(1)
  196. fixed: false
  197. unsigned: false
  198. primary: false
  199. default: '0'
  200. notnull: true
  201. autoincrement: false
  202. BlogArticles:
  203. connection: ikimea
  204. tableName: blog_articles
  205. columns:
  206. blog_article_id:
  207. type: integer(4)
  208. fixed: false
  209. unsigned: false
  210. primary: true
  211. autoincrement: true
  212. blog_article_cat:
  213. type: integer(4)
  214. fixed: false
  215. unsigned: false
  216. primary: false
  217. notnull: true
  218. autoincrement: false
  219. blog_article_nom:
  220. type: string(50)
  221. fixed: false
  222. unsigned: false
  223. primary: false
  224. notnull: true
  225. autoincrement: false
  226. blog_article_date:
  227. type: integer(4)
  228. fixed: false
  229. unsigned: false
  230. primary: false
  231. notnull: true
  232. autoincrement: false
  233. relations:
  234. BlogCategories:
  235. local: blog_article_cat
  236. foreign: blog_cat_id
  237. type: one
  238. BlogVersions:
  239. local: blog_article_id
  240. foreign: blog_versions_cat
  241. type: many
  242. BlogCategories:
  243. connection: ikimea
  244. tableName: blog_categories
  245. columns:
  246. blog_cat_id:
  247. type: integer(4)
  248. fixed: false
  249. unsigned: false
  250. primary: true
  251. autoincrement: true
  252. blog_cat_nom:
  253. type: string(50)
  254. fixed: false
  255. unsigned: false
  256. primary: false
  257. notnull: true
  258. autoincrement: false
  259. blog_cat_nbr:
  260. type: integer(4)
  261. fixed: false
  262. unsigned: false
  263. primary: false
  264. notnull: true
  265. autoincrement: false
  266. relations:
  267. BlogArticles:
  268. local: blog_cat_id
  269. foreign: blog_article_cat
  270. type: many
  271. BlogVersions:
  272. connection: ikimea
  273. tableName: blog_versions
  274. columns:
  275. blog_versions_id:
  276. type: integer(4)
  277. fixed: false
  278. unsigned: false
  279. primary: true
  280. autoincrement: true
  281. blog_versions_cat:
  282. type: integer(4)
  283. fixed: false
  284. unsigned: false
  285. primary: false
  286. notnull: true
  287. autoincrement: false
  288. blog_versions_texte:
  289. type: string()
  290. fixed: false
  291. unsigned: false
  292. primary: false
  293. notnull: true
  294. autoincrement: false
  295. blog_versions_date:
  296. type: timestamp(25)
  297. fixed: false
  298. unsigned: false
  299. primary: false
  300. notnull: true
  301. autoincrement: false
  302. relations:
  303. BlogArticles:
  304. local: blog_versions_cat
  305. foreign: blog_article_id
  306. type: one
  307. Boards:
  308. connection: redmine
  309. tableName: boards
  310. columns:
  311. id:
  312. type: integer(4)
  313. fixed: false
  314. unsigned: false
  315. primary: true
  316. autoincrement: true
  317. project_id:
  318. type: integer(4)
  319. fixed: false
  320. unsigned: false
  321. primary: false
  322. notnull: true
  323. autoincrement: false
  324. name:
  325. type: string(255)
  326. fixed: false
  327. unsigned: false
  328. primary: false
  329. default: ''
  330. notnull: true
  331. autoincrement: false
  332. description:
  333. type: string(255)
  334. fixed: false
  335. unsigned: false
  336. primary: false
  337. notnull: false
  338. autoincrement: false
  339. position:
  340. type: integer(4)
  341. fixed: false
  342. unsigned: false
  343. primary: false
  344. default: '1'
  345. notnull: false
  346. autoincrement: false
  347. topics_count:
  348. type: integer(4)
  349. fixed: false
  350. unsigned: false
  351. primary: false
  352. default: '0'
  353. notnull: true
  354. autoincrement: false
  355. messages_count:
  356. type: integer(4)
  357. fixed: false
  358. unsigned: false
  359. primary: false
  360. default: '0'
  361. notnull: true
  362. autoincrement: false
  363. last_message_id:
  364. type: integer(4)
  365. fixed: false
  366. unsigned: false
  367. primary: false
  368. notnull: false
  369. autoincrement: false
  370. Changes:
  371. connection: redmine
  372. tableName: changes
  373. columns:
  374. id:
  375. type: integer(4)
  376. fixed: false
  377. unsigned: false
  378. primary: true
  379. autoincrement: true
  380. changeset_id:
  381. type: integer(4)
  382. fixed: false
  383. unsigned: false
  384. primary: false
  385. notnull: true
  386. autoincrement: false
  387. action:
  388. type: string(1)
  389. fixed: false
  390. unsigned: false
  391. primary: false
  392. default: ''
  393. notnull: true
  394. autoincrement: false
  395. path:
  396. type: string()
  397. fixed: false
  398. unsigned: false
  399. primary: false
  400. notnull: true
  401. autoincrement: false
  402. from_path:
  403. type: string()
  404. fixed: false
  405. unsigned: false
  406. primary: false
  407. notnull: false
  408. autoincrement: false
  409. from_revision:
  410. type: string(255)
  411. fixed: false
  412. unsigned: false
  413. primary: false
  414. notnull: false
  415. autoincrement: false
  416. revision:
  417. type: string(255)
  418. fixed: false
  419. unsigned: false
  420. primary: false
  421. notnull: false
  422. autoincrement: false
  423. branch:
  424. type: string(255)
  425. fixed: false
  426. unsigned: false
  427. primary: false
  428. notnull: false
  429. autoincrement: false
  430. Changesets:
  431. connection: redmine
  432. tableName: changesets
  433. columns:
  434. id:
  435. type: integer(4)
  436. fixed: false
  437. unsigned: false
  438. primary: true
  439. autoincrement: true
  440. repository_id:
  441. type: integer(4)
  442. fixed: false
  443. unsigned: false
  444. primary: false
  445. notnull: true
  446. autoincrement: false
  447. revision:
  448. type: string(255)
  449. fixed: false
  450. unsigned: false
  451. primary: false
  452. notnull: true
  453. autoincrement: false
  454. committer:
  455. type: string(255)
  456. fixed: false
  457. unsigned: false
  458. primary: false
  459. notnull: false
  460. autoincrement: false
  461. committed_on:
  462. type: timestamp(25)
  463. fixed: false
  464. unsigned: false
  465. primary: false
  466. notnull: true
  467. autoincrement: false
  468. comments:
  469. type: string()
  470. fixed: false
  471. unsigned: false
  472. primary: false
  473. notnull: false
  474. autoincrement: false
  475. commit_date:
  476. type: date(25)
  477. fixed: false
  478. unsigned: false
  479. primary: false
  480. notnull: false
  481. autoincrement: false
  482. scmid:
  483. type: string(255)
  484. fixed: false
  485. unsigned: false
  486. primary: false
  487. notnull: false
  488. autoincrement: false
  489. user_id:
  490. type: integer(4)
  491. fixed: false
  492. unsigned: false
  493. primary: false
  494. notnull: false
  495. autoincrement: false
  496. ChangesetsIssues:
  497. connection: redmine
  498. tableName: changesets_issues
  499. columns:
  500. changeset_id:
  501. type: integer(4)
  502. fixed: false
  503. unsigned: false
  504. primary: true
  505. autoincrement: false
  506. issue_id:
  507. type: integer(4)
  508. fixed: false
  509. unsigned: false
  510. primary: true
  511. autoincrement: false
  512. Clients:
  513. connection: ikimea
  514. tableName: clients
  515. columns:
  516. client_id:
  517. type: integer(4)
  518. fixed: false
  519. unsigned: false
  520. primary: true
  521. autoincrement: true
  522. client_name:
  523. type: string(255)
  524. fixed: false
  525. unsigned: false
  526. primary: false
  527. notnull: true
  528. autoincrement: false
  529. Comments:
  530. connection: redmine
  531. tableName: comments
  532. columns:
  533. id:
  534. type: integer(4)
  535. fixed: false
  536. unsigned: false
  537. primary: true
  538. autoincrement: true
  539. commented_type:
  540. type: string(30)
  541. fixed: false
  542. unsigned: false
  543. primary: false
  544. default: ''
  545. notnull: true
  546. autoincrement: false
  547. commented_id:
  548. type: integer(4)
  549. fixed: false
  550. unsigned: false
  551. primary: false
  552. default: '0'
  553. notnull: true
  554. autoincrement: false
  555. author_id:
  556. type: integer(4)
  557. fixed: false
  558. unsigned: false
  559. primary: false
  560. default: '0'
  561. notnull: true
  562. autoincrement: false
  563. comments:
  564. type: string()
  565. fixed: false
  566. unsigned: false
  567. primary: false
  568. notnull: false
  569. autoincrement: false
  570. created_on:
  571. type: timestamp(25)
  572. fixed: false
  573. unsigned: false
  574. primary: false
  575. notnull: true
  576. autoincrement: false
  577. updated_on:
  578. type: timestamp(25)
  579. fixed: false
  580. unsigned: false
  581. primary: false
  582. notnull: true
  583. autoincrement: false
  584. Contact:
  585. connection: ikimea
  586. tableName: contact
  587. columns:
  588. contact_id:
  589. type: integer(4)
  590. fixed: false
  591. unsigned: false
  592. primary: true
  593. autoincrement: true
  594. contact_mbr_id:
  595. type: integer(4)
  596. fixed: false
  597. unsigned: false
  598. primary: false
  599. notnull: true
  600. autoincrement: false
  601. contact_lu:
  602. type: integer(4)
  603. fixed: false
  604. unsigned: false
  605. primary: false
  606. notnull: true
  607. autoincrement: false
  608. contact_nom:
  609. type: string(100)
  610. fixed: false
  611. unsigned: false
  612. primary: false
  613. notnull: true
  614. autoincrement: false
  615. contact_email:
  616. type: string(255)
  617. fixed: false
  618. unsigned: false
  619. primary: false
  620. notnull: true
  621. autoincrement: false
  622. contact_sujet:
  623. type: string(255)
  624. fixed: false
  625. unsigned: false
  626. primary: false
  627. notnull: true
  628. autoincrement: false
  629. contact_objet:
  630. type: integer(4)
  631. fixed: false
  632. unsigned: false
  633. primary: false
  634. notnull: true
  635. autoincrement: false
  636. contact_contenu:
  637. type: string()
  638. fixed: false
  639. unsigned: false
  640. primary: false
  641. notnull: true
  642. autoincrement: false
  643. contact_date_heure:
  644. type: timestamp(25)
  645. fixed: false
  646. unsigned: false
  647. primary: false
  648. notnull: true
  649. autoincrement: false
  650. contact_ip:
  651. type: integer(4)
  652. fixed: false
  653. unsigned: false
  654. primary: false
  655. notnull: true
  656. autoincrement: false
  657. CustomFields:
  658. connection: redmine
  659. tableName: custom_fields
  660. columns:
  661. id:
  662. type: integer(4)
  663. fixed: false
  664. unsigned: false
  665. primary: true
  666. autoincrement: true
  667. type:
  668. type: string(30)
  669. fixed: false
  670. unsigned: false
  671. primary: false
  672. default: ''
  673. notnull: true
  674. autoincrement: false
  675. name:
  676. type: string(30)
  677. fixed: false
  678. unsigned: false
  679. primary: false
  680. default: ''
  681. notnull: true
  682. autoincrement: false
  683. field_format:
  684. type: string(30)
  685. fixed: false
  686. unsigned: false
  687. primary: false
  688. default: ''
  689. notnull: true
  690. autoincrement: false
  691. possible_values:
  692. type: string()
  693. fixed: false
  694. unsigned: false
  695. primary: false
  696. notnull: false
  697. autoincrement: false
  698. regexp:
  699. type: string(255)
  700. fixed: false
  701. unsigned: false
  702. primary: false
  703. default: ''
  704. notnull: false
  705. autoincrement: false
  706. min_length:
  707. type: integer(4)
  708. fixed: false
  709. unsigned: false
  710. primary: false
  711. default: '0'
  712. notnull: true
  713. autoincrement: false
  714. max_length:
  715. type: integer(4)
  716. fixed: false
  717. unsigned: false
  718. primary: false
  719. default: '0'
  720. notnull: true
  721. autoincrement: false
  722. is_required:
  723. type: integer(1)
  724. fixed: false
  725. unsigned: false
  726. primary: false
  727. default: '0'
  728. notnull: true
  729. autoincrement: false
  730. is_for_all:
  731. type: integer(1)
  732. fixed: false
  733. unsigned: false
  734. primary: false
  735. default: '0'
  736. notnull: true
  737. autoincrement: false
  738. is_filter:
  739. type: integer(1)
  740. fixed: false
  741. unsigned: false
  742. primary: false
  743. default: '0'
  744. notnull: true
  745. autoincrement: false
  746. position:
  747. type: integer(4)
  748. fixed: false
  749. unsigned: false
  750. primary: false
  751. default: '1'
  752. notnull: false
  753. autoincrement: false
  754. searchable:
  755. type: integer(1)
  756. fixed: false
  757. unsigned: false
  758. primary: false
  759. default: '0'
  760. notnull: false
  761. autoincrement: false
  762. default_value:
  763. type: string()
  764. fixed: false
  765. unsigned: false
  766. primary: false
  767. notnull: false
  768. autoincrement: false
  769. editable:
  770. type: integer(1)
  771. fixed: false
  772. unsigned: false
  773. primary: false
  774. default: '1'
  775. notnull: false
  776. autoincrement: false
  777. CustomFieldsProjects:
  778. connection: redmine
  779. tableName: custom_fields_projects
  780. columns:
  781. id:
  782. type: integer(8)
  783. autoincrement: true
  784. primary: true
  785. custom_field_id:
  786. type: integer(4)
  787. fixed: false
  788. unsigned: false
  789. primary: false
  790. default: '0'
  791. notnull: true
  792. autoincrement: false
  793. project_id:
  794. type: integer(4)
  795. fixed: false
  796. unsigned: false
  797. primary: false
  798. default: '0'
  799. notnull: true
  800. autoincrement: false
  801. CustomFieldsTrackers:
  802. connection: redmine
  803. tableName: custom_fields_trackers
  804. columns:
  805. id:
  806. type: integer(8)
  807. autoincrement: true
  808. primary: true
  809. custom_field_id:
  810. type: integer(4)
  811. fixed: false
  812. unsigned: false
  813. primary: false
  814. default: '0'
  815. notnull: true
  816. autoincrement: false
  817. tracker_id:
  818. type: integer(4)
  819. fixed: false
  820. unsigned: false
  821. primary: false
  822. default: '0'
  823. notnull: true
  824. autoincrement: false
  825. CustomValues:
  826. connection: redmine
  827. tableName: custom_values
  828. columns:
  829. id:
  830. type: integer(4)
  831. fixed: false
  832. unsigned: false
  833. primary: true
  834. autoincrement: true
  835. customized_type:
  836. type: string(30)
  837. fixed: false
  838. unsigned: false
  839. primary: false
  840. default: ''
  841. notnull: true
  842. autoincrement: false
  843. customized_id:
  844. type: integer(4)
  845. fixed: false
  846. unsigned: false
  847. primary: false
  848. default: '0'
  849. notnull: true
  850. autoincrement: false
  851. custom_field_id:
  852. type: integer(4)
  853. fixed: false
  854. unsigned: false
  855. primary: false
  856. default: '0'
  857. notnull: true
  858. autoincrement: false
  859. value:
  860. type: string()
  861. fixed: false
  862. unsigned: false
  863. primary: false
  864. notnull: false
  865. autoincrement: false
  866. Deliverables:
  867. connection: redmine
  868. tableName: deliverables
  869. columns:
  870. id:
  871. type: integer(4)
  872. fixed: false
  873. unsigned: false
  874. primary: true
  875. autoincrement: true
  876. subject:
  877. type: string(255)
  878. fixed: false
  879. unsigned: false
  880. primary: false
  881. notnull: false
  882. autoincrement: false
  883. description:
  884. type: string()
  885. fixed: false
  886. unsigned: false
  887. primary: false
  888. notnull: false
  889. autoincrement: false
  890. type:
  891. type: string(255)
  892. fixed: false
  893. unsigned: false
  894. primary: false
  895. notnull: false
  896. autoincrement: false
  897. project_manager_signoff:
  898. type: integer(1)
  899. fixed: false
  900. unsigned: false
  901. primary: false
  902. default: '0'
  903. notnull: false
  904. autoincrement: false
  905. client_signoff:
  906. type: integer(1)
  907. fixed: false
  908. unsigned: false
  909. primary: false
  910. default: '0'
  911. notnull: false
  912. autoincrement: false
  913. project_id:
  914. type: integer(4)
  915. fixed: false
  916. unsigned: false
  917. primary: false
  918. notnull: false
  919. autoincrement: false
  920. budget:
  921. type: 'decimal(15, 2)'
  922. fixed: false
  923. unsigned: false
  924. primary: false
  925. notnull: false
  926. autoincrement: false
  927. overhead:
  928. type: 'decimal(15, 2)'
  929. fixed: false
  930. unsigned: false
  931. primary: false
  932. notnull: false
  933. autoincrement: false
  934. materials:
  935. type: 'decimal(15, 2)'
  936. fixed: false
  937. unsigned: false
  938. primary: false
  939. notnull: false
  940. autoincrement: false
  941. profit:
  942. type: 'decimal(15, 2)'
  943. fixed: false
  944. unsigned: false
  945. primary: false
  946. notnull: false
  947. autoincrement: false
  948. cost_per_hour:
  949. type: 'decimal(15, 2)'
  950. fixed: false
  951. unsigned: false
  952. primary: false
  953. notnull: false
  954. autoincrement: false
  955. total_hours:
  956. type: 'decimal(15, 2)'
  957. fixed: false
  958. unsigned: false
  959. primary: false
  960. notnull: false
  961. autoincrement: false
  962. fixed_cost:
  963. type: 'decimal(15, 2)'
  964. fixed: false
  965. unsigned: false
  966. primary: false
  967. notnull: false
  968. autoincrement: false
  969. overhead_percent:
  970. type: integer(4)
  971. fixed: false
  972. unsigned: false
  973. primary: false
  974. notnull: false
  975. autoincrement: false
  976. materials_percent:
  977. type: integer(4)
  978. fixed: false
  979. unsigned: false
  980. primary: false
  981. notnull: false
  982. autoincrement: false
  983. profit_percent:
  984. type: integer(4)
  985. fixed: false
  986. unsigned: false
  987. primary: false
  988. notnull: false
  989. autoincrement: false
  990. due:
  991. type: date(25)
  992. fixed: false
  993. unsigned: false
  994. primary: false
  995. notnull: false
  996. autoincrement: false
  997. Documents:
  998. connection: redmine
  999. tableName: documents
  1000. columns:
  1001. id:
  1002. type: integer(4)
  1003. fixed: false
  1004. unsigned: false
  1005. primary: true
  1006. autoincrement: true
  1007. project_id:
  1008. type: integer(4)
  1009. fixed: false
  1010. unsigned: false
  1011. primary: false
  1012. default: '0'
  1013. notnull: true
  1014. autoincrement: false
  1015. category_id:
  1016. type: integer(4)
  1017. fixed: false
  1018. unsigned: false
  1019. primary: false
  1020. default: '0'
  1021. notnull: true
  1022. autoincrement: false
  1023. title:
  1024. type: string(60)
  1025. fixed: false
  1026. unsigned: false
  1027. primary: false
  1028. default: ''
  1029. notnull: true
  1030. autoincrement: false
  1031. description:
  1032. type: string()
  1033. fixed: false
  1034. unsigned: false
  1035. primary: false
  1036. notnull: false
  1037. autoincrement: false
  1038. created_on:
  1039. type: timestamp(25)
  1040. fixed: false
  1041. unsigned: false
  1042. primary: false
  1043. notnull: false
  1044. autoincrement: false
  1045. EnabledModules:
  1046. connection: redmine
  1047. tableName: enabled_modules
  1048. columns:
  1049. id:
  1050. type: integer(4)
  1051. fixed: false
  1052. unsigned: false
  1053. primary: true
  1054. autoincrement: true
  1055. project_id:
  1056. type: integer(4)
  1057. fixed: false
  1058. unsigned: false
  1059. primary: false
  1060. notnull: false
  1061. autoincrement: false
  1062. name:
  1063. type: string(255)
  1064. fixed: false
  1065. unsigned: false
  1066. primary: false
  1067. notnull: true
  1068. autoincrement: false
  1069. Enumerations:
  1070. connection: redmine
  1071. tableName: enumerations
  1072. columns:
  1073. id:
  1074. type: integer(4)
  1075. fixed: false
  1076. unsigned: false
  1077. primary: true
  1078. autoincrement: true
  1079. name:
  1080. type: string(30)
  1081. fixed: false
  1082. unsigned: false
  1083. primary: false
  1084. default: ''
  1085. notnull: true
  1086. autoincrement: false
  1087. position:
  1088. type: integer(4)
  1089. fixed: false
  1090. unsigned: false
  1091. primary: false
  1092. default: '1'
  1093. notnull: false
  1094. autoincrement: false
  1095. is_default:
  1096. type: integer(1)
  1097. fixed: false
  1098. unsigned: false
  1099. primary: false
  1100. default: '0'
  1101. notnull: true
  1102. autoincrement: false
  1103. type:
  1104. type: string(255)
  1105. fixed: false
  1106. unsigned: false
  1107. primary: false
  1108. notnull: false
  1109. autoincrement: false
  1110. active:
  1111. type: integer(1)
  1112. fixed: false
  1113. unsigned: false
  1114. primary: false
  1115. default: '1'
  1116. notnull: true
  1117. autoincrement: false
  1118. project_id:
  1119. type: integer(4)
  1120. fixed: false
  1121. unsigned: false
  1122. primary: false
  1123. notnull: false
  1124. autoincrement: false
  1125. parent_id:
  1126. type: integer(4)
  1127. fixed: false
  1128. unsigned: false
  1129. primary: false
  1130. notnull: false
  1131. autoincrement: false
  1132. GroupsUsers:
  1133. connection: redmine
  1134. tableName: groups_users
  1135. columns:
  1136. group_id:
  1137. type: integer(4)
  1138. fixed: false
  1139. unsigned: false
  1140. primary: true
  1141. autoincrement: false
  1142. user_id:
  1143. type: integer(4)
  1144. fixed: false
  1145. unsigned: false
  1146. primary: true
  1147. autoincrement: false
  1148. IssueCategories:
  1149. connection: redmine
  1150. tableName: issue_categories
  1151. columns:
  1152. id:
  1153. type: integer(4)
  1154. fixed: false
  1155. unsigned: false
  1156. primary: true
  1157. autoincrement: true
  1158. project_id:
  1159. type: integer(4)
  1160. fixed: false
  1161. unsigned: false
  1162. primary: false
  1163. default: '0'
  1164. notnull: true
  1165. autoincrement: false
  1166. name:
  1167. type: string(30)
  1168. fixed: false
  1169. unsigned: false
  1170. primary: false
  1171. default: ''
  1172. notnull: true
  1173. autoincrement: false
  1174. assigned_to_id:
  1175. type: integer(4)
  1176. fixed: false
  1177. unsigned: false
  1178. primary: false
  1179. notnull: false
  1180. autoincrement: false
  1181. IssueRelations:
  1182. connection: redmine
  1183. tableName: issue_relations
  1184. columns:
  1185. id:
  1186. type: integer(4)
  1187. fixed: false
  1188. unsigned: false
  1189. primary: true
  1190. autoincrement: true
  1191. issue_from_id:
  1192. type: integer(4)
  1193. fixed: false
  1194. unsigned: false
  1195. primary: false
  1196. notnull: true
  1197. autoincrement: false
  1198. issue_to_id:
  1199. type: integer(4)
  1200. fixed: false
  1201. unsigned: false
  1202. primary: false
  1203. notnull: true
  1204. autoincrement: false
  1205. relation_type:
  1206. type: string(255)
  1207. fixed: false
  1208. unsigned: false
  1209. primary: false
  1210. default: ''
  1211. notnull: true
  1212. autoincrement: false
  1213. delay:
  1214. type: integer(4)
  1215. fixed: false
  1216. unsigned: false
  1217. primary: false
  1218. notnull: false
  1219. autoincrement: false
  1220. IssueStatuses:
  1221. connection: redmine
  1222. tableName: issue_statuses
  1223. columns:
  1224. id:
  1225. type: integer(4)
  1226. fixed: false
  1227. unsigned: false
  1228. primary: true
  1229. autoincrement: true
  1230. name:
  1231. type: string(30)
  1232. fixed: false
  1233. unsigned: false
  1234. primary: false
  1235. default: ''
  1236. notnull: true
  1237. autoincrement: false
  1238. is_closed:
  1239. type: integer(1)
  1240. fixed: false
  1241. unsigned: false
  1242. primary: false
  1243. default: '0'
  1244. notnull: true
  1245. autoincrement: false
  1246. is_default:
  1247. type: integer(1)
  1248. fixed: false
  1249. unsigned: false
  1250. primary: false
  1251. default: '0'
  1252. notnull: true
  1253. autoincrement: false
  1254. position:
  1255. type: integer(4)
  1256. fixed: false
  1257. unsigned: false
  1258. primary: false
  1259. default: '1'
  1260. notnull: false
  1261. autoincrement: false
  1262. default_done_ratio:
  1263. type: integer(4)
  1264. fixed: false
  1265. unsigned: false
  1266. primary: false
  1267. notnull: false
  1268. autoincrement: false
  1269. Issues:
  1270. connection: redmine
  1271. tableName: issues
  1272. columns:
  1273. id:
  1274. type: integer(4)
  1275. fixed: false
  1276. unsigned: false
  1277. primary: true
  1278. autoincrement: true
  1279. tracker_id:
  1280. type: integer(4)
  1281. fixed: false
  1282. unsigned: false
  1283. primary: false
  1284. default: '0'
  1285. notnull: true
  1286. autoincrement: false
  1287. project_id:
  1288. type: integer(4)
  1289. fixed: false
  1290. unsigned: false
  1291. primary: false
  1292. default: '0'
  1293. notnull: true
  1294. autoincrement: false
  1295. subject:
  1296. type: string(255)
  1297. fixed: false
  1298. unsigned: false
  1299. primary: false
  1300. default: ''
  1301. notnull: true
  1302. autoincrement: false
  1303. description:
  1304. type: string()
  1305. fixed: false
  1306. unsigned: false
  1307. primary: false
  1308. notnull: false
  1309. autoincrement: false
  1310. due_date:
  1311. type: date(25)
  1312. fixed: false
  1313. unsigned: false
  1314. primary: false
  1315. notnull: false
  1316. autoincrement: false
  1317. category_id:
  1318. type: integer(4)
  1319. fixed: false
  1320. unsigned: false
  1321. primary: false
  1322. notnull: false
  1323. autoincrement: false
  1324. status_id:
  1325. type: integer(4)
  1326. fixed: false
  1327. unsigned: false
  1328. primary: false
  1329. default: '0'
  1330. notnull: true
  1331. autoincrement: false
  1332. assigned_to_id:
  1333. type: integer(4)
  1334. fixed: false
  1335. unsigned: false
  1336. primary: false
  1337. notnull: false
  1338. autoincrement: false
  1339. priority_id:
  1340. type: integer(4)
  1341. fixed: false
  1342. unsigned: false
  1343. primary: false
  1344. default: '0'
  1345. notnull: true
  1346. autoincrement: false
  1347. fixed_version_id:
  1348. type: integer(4)
  1349. fixed: false
  1350. unsigned: false
  1351. primary: false
  1352. notnull: false
  1353. autoincrement: false
  1354. author_id:
  1355. type: integer(4)
  1356. fixed: false
  1357. unsigned: false
  1358. primary: false
  1359. default: '0'
  1360. notnull: true
  1361. autoincrement: false
  1362. lock_version:
  1363. type: integer(4)
  1364. fixed: false
  1365. unsigned: false
  1366. primary: false
  1367. default: '0'
  1368. notnull: true
  1369. autoincrement: false
  1370. created_on:
  1371. type: timestamp(25)
  1372. fixed: false
  1373. unsigned: false
  1374. primary: false
  1375. notnull: false
  1376. autoincrement: false
  1377. updated_on:
  1378. type: timestamp(25)
  1379. fixed: false
  1380. unsigned: false
  1381. primary: false
  1382. notnull: false
  1383. autoincrement: false
  1384. start_date:
  1385. type: date(25)
  1386. fixed: false
  1387. unsigned: false
  1388. primary: false
  1389. notnull: false
  1390. autoincrement: false
  1391. done_ratio:
  1392. type: integer(4)
  1393. fixed: false
  1394. unsigned: false
  1395. primary: false
  1396. default: '0'
  1397. notnull: true
  1398. autoincrement: false
  1399. estimated_hours:
  1400. type: float()
  1401. fixed: false
  1402. unsigned: false
  1403. primary: false
  1404. notnull: false
  1405. autoincrement: false
  1406. parent_id:
  1407. type: integer(4)
  1408. fixed: false
  1409. unsigned: false
  1410. primary: false
  1411. notnull: false
  1412. autoincrement: false
  1413. root_id:
  1414. type: integer(4)
  1415. fixed: false
  1416. unsigned: false
  1417. primary: false
  1418. notnull: false
  1419. autoincrement: false
  1420. lft:
  1421. type: integer(4)
  1422. fixed: false
  1423. unsigned: false
  1424. primary: false
  1425. notnull: false
  1426. autoincrement: false
  1427. rgt:
  1428. type: integer(4)
  1429. fixed: false
  1430. unsigned: false
  1431. primary: false
  1432. notnull: false
  1433. autoincrement: false
  1434. deliverable_id:
  1435. type: integer(4)
  1436. fixed: false
  1437. unsigned: false
  1438. primary: false
  1439. notnull: false
  1440. autoincrement: false
  1441. Jobs:
  1442. connection: ikimea
  1443. tableName: jobs
  1444. columns:
  1445. job_id:
  1446. type: integer(4)
  1447. fixed: false
  1448. unsigned: false
  1449. primary: true
  1450. autoincrement: true
  1451. job_cat:
  1452. type: integer(4)
  1453. fixed: false
  1454. unsigned: false
  1455. primary: false
  1456. notnull: true
  1457. autoincrement: false
  1458. job_nom:
  1459. type: string(50)
  1460. fixed: false
  1461. unsigned: false
  1462. primary: false
  1463. notnull: true
  1464. autoincrement: false
  1465. job_date:
  1466. type: timestamp(25)
  1467. fixed: false
  1468. unsigned: false
  1469. primary: false
  1470. notnull: true
  1471. autoincrement: false
  1472. job_maj:
  1473. type: timestamp(25)
  1474. fixed: false
  1475. unsigned: false
  1476. primary: false
  1477. notnull: true
  1478. autoincrement: false
  1479. job_description:
  1480. type: string()
  1481. fixed: false
  1482. unsigned: false
  1483. primary: false
  1484. notnull: true
  1485. autoincrement: false
  1486. relations:
  1487. JobsCategories:
  1488. local: job_cat
  1489. foreign: jc_id
  1490. type: one
  1491. JobsCategories:
  1492. connection: ikimea
  1493. tableName: jobs_categories
  1494. columns:
  1495. jc_id:
  1496. type: integer(4)
  1497. fixed: false
  1498. unsigned: false
  1499. primary: true
  1500. autoincrement: true
  1501. jc_nom:
  1502. type: string(50)
  1503. fixed: false
  1504. unsigned: false
  1505. primary: false
  1506. notnull: true
  1507. autoincrement: false
  1508. relations:
  1509. Jobs:
  1510. local: jc_id
  1511. foreign: job_cat
  1512. type: many
  1513. JournalDetails:
  1514. connection: redmine
  1515. tableName: journal_details
  1516. columns:
  1517. id:
  1518. type: integer(4)
  1519. fixed: false
  1520. unsigned: false
  1521. primary: true
  1522. autoincrement: true
  1523. journal_id:
  1524. type: integer(4)
  1525. fixed: false
  1526. unsigned: false
  1527. primary: false
  1528. default: '0'
  1529. notnull: true
  1530. autoincrement: false
  1531. property:
  1532. type: string(30)
  1533. fixed: false
  1534. unsigned: false
  1535. primary: false
  1536. default: ''
  1537. notnull: true
  1538. autoincrement: false
  1539. prop_key:
  1540. type: string(30)
  1541. fixed: false
  1542. unsigned: false
  1543. primary: false
  1544. default: ''
  1545. notnull: true
  1546. autoincrement: false
  1547. old_value:
  1548. type: string(255)
  1549. fixed: false
  1550. unsigned: false
  1551. primary: false
  1552. notnull: false
  1553. autoincrement: false
  1554. value:
  1555. type: string(255)
  1556. fixed: false
  1557. unsigned: false
  1558. primary: false
  1559. notnull: false
  1560. autoincrement: false
  1561. Journals:
  1562. connection: redmine
  1563. tableName: journals
  1564. columns:
  1565. id:
  1566. type: integer(4)
  1567. fixed: false
  1568. unsigned: false
  1569. primary: true
  1570. autoincrement: true
  1571. journalized_id:
  1572. type: integer(4)
  1573. fixed: false
  1574. unsigned: false
  1575. primary: false
  1576. default: '0'
  1577. notnull: true
  1578. autoincrement: false
  1579. journalized_type:
  1580. type: string(30)
  1581. fixed: false
  1582. unsigned: false
  1583. primary: false
  1584. default: ''
  1585. notnull: true
  1586. autoincrement: false
  1587. user_id:
  1588. type: integer(4)
  1589. fixed: false
  1590. unsigned: false
  1591. primary: false
  1592. default: '0'
  1593. notnull: true
  1594. autoincrement: false
  1595. notes:
  1596. type: string()
  1597. fixed: false
  1598. unsigned: false
  1599. primary: false
  1600. notnull: false
  1601. autoincrement: false
  1602. created_on:
  1603. type: timestamp(25)
  1604. fixed: false
  1605. unsigned: false
  1606. primary: false
  1607. notnull: true
  1608. autoincrement: false
  1609. MemberRoles:
  1610. connection: redmine
  1611. tableName: member_roles
  1612. columns:
  1613. id:
  1614. type: integer(4)
  1615. fixed: false
  1616. unsigned: false
  1617. primary: true
  1618. autoincrement: true
  1619. member_id:
  1620. type: integer(4)
  1621. fixed: false
  1622. unsigned: false
  1623. primary: false
  1624. notnull: true
  1625. autoincrement: false
  1626. role_id:
  1627. type: integer(4)
  1628. fixed: false
  1629. unsigned: false
  1630. primary: false
  1631. notnull: true
  1632. autoincrement: false
  1633. inherited_from:
  1634. type: integer(4)
  1635. fixed: false
  1636. unsigned: false
  1637. primary: false
  1638. notnull: false
  1639. autoincrement: false
  1640. Members:
  1641. connection: redmine
  1642. tableName: members
  1643. columns:
  1644. id:
  1645. type: integer(4)
  1646. fixed: false
  1647. unsigned: false
  1648. primary: true
  1649. autoincrement: true
  1650. user_id:
  1651. type: integer(4)
  1652. fixed: false
  1653. unsigned: false
  1654. primary: false
  1655. default: '0'
  1656. notnull: true
  1657. autoincrement: false
  1658. project_id:
  1659. type: integer(4)
  1660. fixed: false
  1661. unsigned: false
  1662. primary: false
  1663. default: '0'
  1664. notnull: true
  1665. autoincrement: false
  1666. created_on:
  1667. type: timestamp(25)
  1668. fixed: false
  1669. unsigned: false
  1670. primary: false
  1671. notnull: false
  1672. autoincrement: false
  1673. mail_notification:
  1674. type: integer(1)
  1675. fixed: false
  1676. unsigned: false
  1677. primary: false
  1678. default: '0'
  1679. notnull: true
  1680. autoincrement: false
  1681. Messages:
  1682. connection: redmine
  1683. tableName: messages
  1684. columns:
  1685. id:
  1686. type: integer(4)
  1687. fixed: false
  1688. unsigned: false
  1689. primary: true
  1690. autoincrement: true
  1691. board_id:
  1692. type: integer(4)
  1693. fixed: false
  1694. unsigned: false
  1695. primary: false
  1696. notnull: true
  1697. autoincrement: false
  1698. parent_id:
  1699. type: integer(4)
  1700. fixed: false
  1701. unsigned: false
  1702. primary: false
  1703. notnull: false
  1704. autoincrement: false
  1705. subject:
  1706. type: string(255)
  1707. fixed: false
  1708. unsigned: false
  1709. primary: false
  1710. default: ''
  1711. notnull: true
  1712. autoincrement: false
  1713. content:
  1714. type: string()
  1715. fixed: false
  1716. unsigned: false
  1717. primary: false
  1718. notnull: false
  1719. autoincrement: false
  1720. author_id:
  1721. type: integer(4)
  1722. fixed: false
  1723. unsigned: false
  1724. primary: false
  1725. notnull: false
  1726. autoincrement: false
  1727. replies_count:
  1728. type: integer(4)
  1729. fixed: false
  1730. unsigned: false
  1731. primary: false
  1732. default: '0'
  1733. notnull: true
  1734. autoincrement: false
  1735. last_reply_id:
  1736. type: integer(4)
  1737. fixed: false
  1738. unsigned: false
  1739. primary: false
  1740. notnull: false
  1741. autoincrement: false
  1742. created_on:
  1743. type: timestamp(25)
  1744. fixed: false
  1745. unsigned: false
  1746. primary: false
  1747. notnull: true
  1748. autoincrement: false
  1749. updated_on:
  1750. type: timestamp(25)
  1751. fixed: false
  1752. unsigned: false
  1753. primary: false
  1754. notnull: true
  1755. autoincrement: false
  1756. locked:
  1757. type: integer(1)
  1758. fixed: false
  1759. unsigned: false
  1760. primary: false
  1761. default: '0'
  1762. notnull: false
  1763. autoincrement: false
  1764. sticky:
  1765. type: integer(4)
  1766. fixed: false
  1767. unsigned: false
  1768. primary: false
  1769. default: '0'
  1770. notnull: false
  1771. autoincrement: false
  1772. News:
  1773. connection: redmine
  1774. tableName: news
  1775. columns:
  1776. id:
  1777. type: integer(4)
  1778. fixed: false
  1779. unsigned: false
  1780. primary: true
  1781. autoincrement: true
  1782. project_id:
  1783. type: integer(4)
  1784. fixed: false
  1785. unsigned: false
  1786. primary: false
  1787. notnull: false
  1788. autoincrement: false
  1789. title:
  1790. type: string(60)
  1791. fixed: false
  1792. unsigned: false
  1793. primary: false
  1794. default: ''
  1795. notnull: true
  1796. autoincrement: false
  1797. summary:
  1798. type: string(255)
  1799. fixed: false
  1800. unsigned: false
  1801. primary: false
  1802. default: ''
  1803. notnull: false
  1804. autoincrement: false
  1805. description:
  1806. type: string()
  1807. fixed: false
  1808. unsigned: false
  1809. primary: false
  1810. notnull: false
  1811. autoincrement: false
  1812. author_id:
  1813. type: integer(4)
  1814. fixed: false
  1815. unsigned: false
  1816. primary: false
  1817. default: '0'
  1818. notnull: true
  1819. autoincrement: false
  1820. created_on:
  1821. type: timestamp(25)
  1822. fixed: false
  1823. unsigned: false
  1824. primary: false
  1825. notnull: false
  1826. autoincrement: false
  1827. comments_count:
  1828. type: integer(4)
  1829. fixed: false
  1830. unsigned: false
  1831. primary: false
  1832. default: '0'
  1833. notnull: true
  1834. autoincrement: false
  1835. OpenIdAuthenticationAssociations:
  1836. connection: redmine
  1837. tableName: open_id_authentication_associations
  1838. columns:
  1839. id:
  1840. type: integer(4)
  1841. fixed: false
  1842. unsigned: false
  1843. primary: true
  1844. autoincrement: true
  1845. issued:
  1846. type: integer(4)
  1847. fixed: false
  1848. unsigned: false
  1849. primary: false
  1850. notnull: false
  1851. autoincrement: false
  1852. lifetime:
  1853. type: integer(4)
  1854. fixed: false
  1855. unsigned: false
  1856. primary: false
  1857. notnull: false
  1858. autoincrement: false
  1859. handle:
  1860. type: string(255)
  1861. fixed: false
  1862. unsigned: false
  1863. primary: false
  1864. notnull: false
  1865. autoincrement: false
  1866. assoc_type:
  1867. type: string(255)
  1868. fixed: false
  1869. unsigned: false
  1870. primary: false
  1871. notnull: false
  1872. autoincrement: false
  1873. server_url:
  1874. type: blob()
  1875. fixed: false
  1876. unsigned: false
  1877. primary: false
  1878. notnull: false
  1879. autoincrement: false
  1880. secret:
  1881. type: blob()
  1882. fixed: false
  1883. unsigned: false
  1884. primary: false
  1885. notnull: false
  1886. autoincrement: false
  1887. OpenIdAuthenticationNonces:
  1888. connection: redmine
  1889. tableName: open_id_authentication_nonces
  1890. columns:
  1891. id:
  1892. type: integer(4)
  1893. fixed: false
  1894. unsigned: false
  1895. primary: true
  1896. autoincrement: true
  1897. timestamp:
  1898. type: integer(4)
  1899. fixed: false
  1900. unsigned: false
  1901. primary: false
  1902. notnull: true
  1903. autoincrement: false
  1904. server_url:
  1905. type: string(255)
  1906. fixed: false
  1907. unsigned: false
  1908. primary: false
  1909. notnull: false
  1910. autoincrement: false
  1911. salt:
  1912. type: string(255)
  1913. fixed: false
  1914. unsigned: false
  1915. primary: false
  1916. notnull: true
  1917. autoincrement: false
  1918. Projects:
  1919. connection: redmine
  1920. tableName: projects
  1921. columns:
  1922. id:
  1923. type: integer(4)
  1924. fixed: false
  1925. unsigned: false
  1926. primary: true
  1927. autoincrement: true
  1928. name:
  1929. type: string(30)
  1930. fixed: false
  1931. unsigned: false
  1932. primary: false
  1933. default: ''
  1934. notnull: true
  1935. autoincrement: false
  1936. description:
  1937. type: string()
  1938. fixed: false
  1939. unsigned: false
  1940. primary: false
  1941. notnull: false
  1942. autoincrement: false
  1943. homepage:
  1944. type: string(255)
  1945. fixed: false
  1946. unsigned: false
  1947. primary: false
  1948. default: ''
  1949. notnull: false
  1950. autoincrement: false
  1951. is_public:
  1952. type: integer(1)
  1953. fixed: false
  1954. unsigned: false
  1955. primary: false
  1956. default: '1'
  1957. notnull: true
  1958. autoincrement: false
  1959. parent_id:
  1960. type: integer(4)
  1961. fixed: false
  1962. unsigned: false
  1963. primary: false
  1964. notnull: false
  1965. autoincrement: false
  1966. created_on:
  1967. type: timestamp(25)
  1968. fixed: false
  1969. unsigned: false
  1970. primary: false
  1971. notnull: false
  1972. autoincrement: false
  1973. updated_on:
  1974. type: timestamp(25)
  1975. fixed: false
  1976. unsigned: false
  1977. primary: false
  1978. notnull: false
  1979. autoincrement: false
  1980. identifier:
  1981. type: string(20)
  1982. fixed: false
  1983. unsigned: false
  1984. primary: false
  1985. notnull: false
  1986. autoincrement: false
  1987. status:
  1988. type: integer(4)
  1989. fixed: false
  1990. unsigned: false
  1991. primary: false
  1992. default: '1'
  1993. notnull: true
  1994. autoincrement: false
  1995. lft:
  1996. type: integer(4)
  1997. fixed: false
  1998. unsigned: false
  1999. primary: false
  2000. notnull: false
  2001. autoincrement: false
  2002. rgt:
  2003. type: integer(4)
  2004. fixed: false
  2005. unsigned: false
  2006. primary: false
  2007. notnull: false
  2008. autoincrement: false
  2009. ProjectsTrackers:
  2010. connection: redmine
  2011. tableName: projects_trackers
  2012. columns:
  2013. project_id:
  2014. type: integer(4)
  2015. fixed: false
  2016. unsigned: false
  2017. primary: true
  2018. autoincrement: false
  2019. tracker_id:
  2020. type: integer(4)
  2021. fixed: false
  2022. unsigned: false
  2023. primary: true
  2024. autoincrement: false
  2025. Queries:
  2026. connection: redmine
  2027. tableName: queries
  2028. columns:
  2029. id:
  2030. type: integer(4)
  2031. fixed: false
  2032. unsigned: false
  2033. primary: true
  2034. autoincrement: true
  2035. project_id:
  2036. type: integer(4)
  2037. fixed: false
  2038. unsigned: false
  2039. primary: false
  2040. notnull: false
  2041. autoincrement: false
  2042. name:
  2043. type: string(255)
  2044. fixed: false
  2045. unsigned: false
  2046. primary: false
  2047. default: ''
  2048. notnull: true
  2049. autoincrement: false
  2050. filters:
  2051. type: string()
  2052. fixed: false
  2053. unsigned: false
  2054. primary: false
  2055. notnull: false
  2056. autoincrement: false
  2057. user_id:
  2058. type: integer(4)
  2059. fixed: false
  2060. unsigned: false
  2061. primary: false
  2062. default: '0'
  2063. notnull: true
  2064. autoincrement: false
  2065. is_public:
  2066. type: integer(1)
  2067. fixed: false
  2068. unsigned: false
  2069. primary: false
  2070. default: '0'
  2071. notnull: true
  2072. autoincrement: false
  2073. column_names:
  2074. type: string()
  2075. fixed: false
  2076. unsigned: false
  2077. primary: false
  2078. notnull: false
  2079. autoincrement: false
  2080. sort_criteria:
  2081. type: string()
  2082. fixed: false
  2083. unsigned: false
  2084. primary: false
  2085. notnull: false
  2086. autoincrement: false
  2087. group_by:
  2088. type: string(255)
  2089. fixed: false
  2090. unsigned: false
  2091. primary: false
  2092. notnull: false
  2093. autoincrement: false
  2094. Rates:
  2095. connection: redmine
  2096. tableName: rates
  2097. columns:
  2098. id:
  2099. type: integer(4)
  2100. fixed: false
  2101. unsigned: false
  2102. primary: true
  2103. autoincrement: true
  2104. amount:
  2105. type: 'decimal(15, 2)'
  2106. fixed: false
  2107. unsigned: false
  2108. primary: false
  2109. notnull: false
  2110. autoincrement: false
  2111. user_id:
  2112. type: integer(4)
  2113. fixed: false
  2114. unsigned: false
  2115. primary: false
  2116. notnull: false
  2117. autoincrement: false
  2118. project_id:
  2119. type: integer(4)
  2120. fixed: false
  2121. unsigned: false
  2122. primary: false
  2123. notnull: false
  2124. autoincrement: false
  2125. date_in_effect:
  2126. type: date(25)
  2127. fixed: false
  2128. unsigned: false
  2129. primary: false
  2130. notnull: false
  2131. autoincrement: false
  2132. Repositories:
  2133. connection: redmine
  2134. tableName: repositories
  2135. columns:
  2136. id:
  2137. type: integer(4)
  2138. fixed: false
  2139. unsigned: false
  2140. primary: true
  2141. autoincrement: true
  2142. project_id:
  2143. type: integer(4)
  2144. fixed: false
  2145. unsigned: false
  2146. primary: false
  2147. default: '0'
  2148. notnull: true
  2149. autoincrement: false
  2150. url:
  2151. type: string(255)
  2152. fixed: false
  2153. unsigned: false
  2154. primary: false
  2155. default: ''
  2156. notnull: true
  2157. autoincrement: false
  2158. login:
  2159. type: string(60)
  2160. fixed: false
  2161. unsigned: false
  2162. primary: false
  2163. default: ''
  2164. notnull: false
  2165. autoincrement: false
  2166. password:
  2167. type: string(60)
  2168. fixed: false
  2169. unsigned: false
  2170. primary: false
  2171. default: ''
  2172. notnull: false
  2173. autoincrement: false
  2174. root_url:
  2175. type: string(255)
  2176. fixed: false
  2177. unsigned: false
  2178. primary: false
  2179. default: ''
  2180. notnull: false
  2181. autoincrement: false
  2182. type:
  2183. type: string(255)
  2184. fixed: false
  2185. unsigned: false
  2186. primary: false
  2187. notnull: false
  2188. autoincrement: false
  2189. Roles:
  2190. connection: redmine
  2191. tableName: roles
  2192. columns:
  2193. id:
  2194. type: integer(4)
  2195. fixed: false
  2196. unsigned: false
  2197. primary: true
  2198. autoincrement: true
  2199. name:
  2200. type: string(30)
  2201. fixed: false
  2202. unsigned: false
  2203. primary: false
  2204. default: ''
  2205. notnull: true
  2206. autoincrement: false
  2207. position:
  2208. type: integer(4)
  2209. fixed: false
  2210. unsigned: false
  2211. primary: false
  2212. default: '1'
  2213. notnull: false
  2214. autoincrement: false
  2215. assignable:
  2216. type: integer(1)
  2217. fixed: false
  2218. unsigned: false
  2219. primary: false
  2220. default: '1'
  2221. notnull: false
  2222. autoincrement: false
  2223. builtin:
  2224. type: integer(4)
  2225. fixed: false
  2226. unsigned: false
  2227. primary: false
  2228. default: '0'
  2229. notnull: true
  2230. autoincrement: false
  2231. permissions:
  2232. type: string()
  2233. fixed: false
  2234. unsigned: false
  2235. primary: false
  2236. notnull: false
  2237. autoincrement: false
  2238. SchemaMigrations:
  2239. connection: redmine
  2240. tableName: schema_migrations
  2241. columns:
  2242. version:
  2243. type: string(255)
  2244. fixed: false
  2245. unsigned: false
  2246. primary: true
  2247. autoincrement: false
  2248. Settings:
  2249. connection: redmine
  2250. tableName: settings
  2251. columns:
  2252. id:
  2253. type: integer(4)
  2254. fixed: false
  2255. unsigned: false
  2256. primary: true
  2257. autoincrement: true
  2258. name:
  2259. type: string(255)
  2260. fixed: false
  2261. unsigned: false
  2262. primary: false
  2263. default: ''
  2264. notnull: true
  2265. autoincrement: false
  2266. value:
  2267. type: string()
  2268. fixed: false
  2269. unsigned: false
  2270. primary: false
  2271. notnull: false
  2272. autoincrement: false
  2273. updated_on:
  2274. type: timestamp(25)
  2275. fixed: false
  2276. unsigned: false
  2277. primary: false
  2278. notnull: false
  2279. autoincrement: false
  2280. Tasks:
  2281. connection: ikimea
  2282. tableName: tasks
  2283. columns:
  2284. task_id:
  2285. type: integer(4)
  2286. fixed: false
  2287. unsigned: false
  2288. primary: true
  2289. autoincrement: true
  2290. task_name:
  2291. type: string(255)
  2292. fixed: false
  2293. unsigned: false
  2294. primary: false
  2295. notnull: true
  2296. autoincrement: false
  2297. task_user:
  2298. type: integer(4)
  2299. fixed: false
  2300. unsigned: false
  2301. primary: false
  2302. notnull: true
  2303. autoincrement: false
  2304. task_date:
  2305. type: timestamp(25)
  2306. fixed: false
  2307. unsigned: false
  2308. primary: false
  2309. notnull: true
  2310. autoincrement: false
  2311. task_deadline:
  2312. type: timestamp(25)
  2313. fixed: false
  2314. unsigned: false
  2315. primary: false
  2316. notnull: true
  2317. autoincrement: false
  2318. task_statut:
  2319. type: boolean
  2320. fixed: false
  2321. unsigned: false
  2322. primary: false
  2323. notnull: true
  2324. autoincrement: false
  2325. relations:
  2326. Users:
  2327. local: task_user
  2328. foreign: id
  2329. type: one
  2330. Users_2:
  2331. class: Users
  2332. local: task_user
  2333. foreign: id
  2334. type: one
  2335. TimeEntries:
  2336. connection: redmine
  2337. tableName: time_entries
  2338. columns:
  2339. id:
  2340. type: integer(4)
  2341. fixed: false
  2342. unsigned: false
  2343. primary: true
  2344. autoincrement: true
  2345. project_id:
  2346. type: integer(4)
  2347. fixed: false
  2348. unsigned: false
  2349. primary: false
  2350. notnull: true
  2351. autoincrement: false
  2352. user_id:
  2353. type: integer(4)
  2354. fixed: false
  2355. unsigned: false
  2356. primary: false
  2357. notnull: true
  2358. autoincrement: false
  2359. issue_id:
  2360. type: integer(4)
  2361. fixed: false
  2362. unsigned: false
  2363. primary: false
  2364. notnull: false
  2365. autoincrement: false
  2366. hours:
  2367. type: float()
  2368. fixed: false
  2369. unsigned: false
  2370. primary: false
  2371. notnull: true
  2372. autoincrement: false
  2373. comments:
  2374. type: string(255)
  2375. fixed: false
  2376. unsigned: false
  2377. primary: false
  2378. notnull: false
  2379. autoincrement: false
  2380. activity_id:
  2381. type: integer(4)
  2382. fixed: false
  2383. unsigned: false
  2384. primary: false
  2385. notnull: true
  2386. autoincrement: false
  2387. spent_on:
  2388. type: date(25)
  2389. fixed: false
  2390. unsigned: false
  2391. primary: false
  2392. notnull: true
  2393. autoincrement: false
  2394. tyear:
  2395. type: integer(4)
  2396. fixed: false
  2397. unsigned: false
  2398. primary: false
  2399. notnull: true
  2400. autoincrement: false
  2401. tmonth:
  2402. type: integer(4)
  2403. fixed: false
  2404. unsigned: false
  2405. primary: false
  2406. notnull: true
  2407. autoincrement: false
  2408. tweek:
  2409. type: integer(4)
  2410. fixed: false
  2411. unsigned: false
  2412. primary: false
  2413. notnull: true
  2414. autoincrement: false
  2415. created_on:
  2416. type: timestamp(25)
  2417. fixed: false
  2418. unsigned: false
  2419. primary: false
  2420. notnull: true
  2421. autoincrement: false
  2422. updated_on:
  2423. type: timestamp(25)
  2424. fixed: false
  2425. unsigned: false
  2426. primary: false
  2427. notnull: true
  2428. autoincrement: false
  2429. rate_id:
  2430. type: integer(4)
  2431. fixed: false
  2432. unsigned: false
  2433. primary: false
  2434. notnull: false
  2435. autoincrement: false
  2436. Timesheet:
  2437. connection: ikimea
  2438. tableName: timesheet
  2439. columns:
  2440. id:
  2441. type: integer(8)
  2442. autoincrement: true
  2443. primary: true
  2444. cra_id:
  2445. type: integer(4)
  2446. fixed: false
  2447. unsigned: false
  2448. primary: false
  2449. notnull: true
  2450. autoincrement: false
  2451. cra_projet:
  2452. type: integer(4)
  2453. fixed: false
  2454. unsigned: false
  2455. primary: false
  2456. notnull: true
  2457. autoincrement: false
  2458. cra_heure:
  2459. type: timestamp(25)
  2460. fixed: false
  2461. unsigned: false
  2462. primary: false
  2463. notnull: true
  2464. autoincrement: false
  2465. cra_description:
  2466. type: string()
  2467. fixed: false
  2468. unsigned: false
  2469. primary: false
  2470. notnull: true
  2471. autoincrement: false
  2472. relations:
  2473. Projects:
  2474. local: cra_projet
  2475. foreign: id
  2476. type: one
  2477. Tokens:
  2478. connection: redmine
  2479. tableName: tokens
  2480. columns:
  2481. id:
  2482. type: integer(4)
  2483. fixed: false
  2484. unsigned: false
  2485. primary: true
  2486. autoincrement: true
  2487. user_id:
  2488. type: integer(4)
  2489. fixed: false
  2490. unsigned: false
  2491. primary: false
  2492. default: '0'
  2493. notnull: true
  2494. autoincrement: false
  2495. action:
  2496. type: string(30)
  2497. fixed: false
  2498. unsigned: false
  2499. primary: false
  2500. default: ''
  2501. notnull: true
  2502. autoincrement: false
  2503. value:
  2504. type: string(40)
  2505. fixed: false
  2506. unsigned: false
  2507. primary: false
  2508. default: ''
  2509. notnull: true
  2510. autoincrement: false
  2511. created_on:
  2512. type: timestamp(25)
  2513. fixed: false
  2514. unsigned: false
  2515. primary: false
  2516. notnull: true
  2517. autoincrement: false
  2518. Trackers:
  2519. connection: redmine
  2520. tableName: trackers
  2521. columns:
  2522. id:
  2523. type: integer(4)
  2524. fixed: false
  2525. unsigned: false
  2526. primary: true
  2527. autoincrement: true
  2528. name:
  2529. type: string(30)
  2530. fixed: false
  2531. unsigned: false
  2532. primary: false
  2533. default: ''
  2534. notnull: true
  2535. autoincrement: false
  2536. is_in_chlog:
  2537. type: integer(1)
  2538. fixed: false
  2539. unsigned: false
  2540. primary: false
  2541. default: '0'
  2542. notnull: true
  2543. autoincrement: false
  2544. position:
  2545. type: integer(4)
  2546. fixed: false
  2547. unsigned: false
  2548. primary: false
  2549. default: '1'
  2550. notnull: false
  2551. autoincrement: false
  2552. is_in_roadmap:
  2553. type: integer(1)
  2554. fixed: false
  2555. unsigned: false
  2556. primary: false
  2557. default: '1'
  2558. notnull: true
  2559. autoincrement: false
  2560. UserPreferences:
  2561. connection: redmine
  2562. tableName: user_preferences
  2563. columns:
  2564. id:
  2565. type: integer(4)
  2566. fixed: false
  2567. unsigned: false
  2568. primary: true
  2569. autoincrement: true
  2570. user_id:
  2571. type: integer(4)
  2572. fixed: false
  2573. unsigned: false
  2574. primary: false
  2575. default: '0'
  2576. notnull: true
  2577. autoincrement: false
  2578. others:
  2579. type: string()
  2580. fixed: false
  2581. unsigned: false
  2582. primary: false
  2583. notnull: false
  2584. autoincrement: false
  2585. hide_mail:
  2586. type: integer(1)
  2587. fixed: false
  2588. unsigned: false
  2589. primary: false
  2590. default: '0'
  2591. notnull: false
  2592. autoincrement: false
  2593. time_zone:
  2594. type: string(255)
  2595. fixed: false
  2596. unsigned: false
  2597. primary: false
  2598. notnull: false
  2599. autoincrement: false
  2600. Users:
  2601. connection: redmine
  2602. tableName: users
  2603. columns:
  2604. id:
  2605. type: integer(4)
  2606. fixed: false
  2607. unsigned: false
  2608. primary: true
  2609. autoincrement: true
  2610. login:
  2611. type: string(30)
  2612. fixed: false
  2613. unsigned: false
  2614. primary: false
  2615. default: ''
  2616. notnull: true
  2617. autoincrement: false
  2618. hashed_password:
  2619. type: string(40)
  2620. fixed: false
  2621. unsigned: false
  2622. primary: false
  2623. default: ''
  2624. notnull: true
  2625. autoincrement: false
  2626. firstname:
  2627. type: string(30)
  2628. fixed: false
  2629. unsigned: false
  2630. primary: false
  2631. default: ''
  2632. notnull: true
  2633. autoincrement: false
  2634. lastname:
  2635. type: string(30)
  2636. fixed: false
  2637. unsigned: false
  2638. primary: false
  2639. default: ''
  2640. notnull: true
  2641. autoincrement: false
  2642. mail:
  2643. type: string(60)
  2644. fixed: false
  2645. unsigned: false
  2646. primary: false
  2647. default: ''
  2648. notnull: true
  2649. autoincrement: false
  2650. mail_notification:
  2651. type: integer(1)
  2652. fixed: false
  2653. unsigned: false
  2654. primary: false
  2655. default: '1'
  2656. notnull: true
  2657. autoincrement: false
  2658. admin:
  2659. type: integer(1)
  2660. fixed: false
  2661. unsigned: false
  2662. primary: false
  2663. default: '0'
  2664. notnull: true
  2665. autoincrement: false
  2666. status:
  2667. type: integer(4)
  2668. fixed: false
  2669. unsigned: false
  2670. primary: false
  2671. default: '1'
  2672. notnull: true
  2673. autoincrement: false
  2674. last_login_on:
  2675. type: timestamp(25)
  2676. fixed: false
  2677. unsigned: false
  2678. primary: false
  2679. notnull: false
  2680. autoincrement: false
  2681. language:
  2682. type: string(5)
  2683. fixed: false
  2684. unsigned: false
  2685. primary: false
  2686. default: ''
  2687. notnull: false
  2688. autoincrement: false
  2689. auth_source_id:
  2690. type: integer(4)
  2691. fixed: false
  2692. unsigned: false
  2693. primary: false
  2694. notnull: false
  2695. autoincrement: false
  2696. created_on:
  2697. type: timestamp(25)
  2698. fixed: false
  2699. unsigned: false
  2700. primary: false
  2701. notnull: false
  2702. autoincrement: false
  2703. updated_on:
  2704. type: timestamp(25)
  2705. fixed: false
  2706. unsigned: false
  2707. primary: false
  2708. notnull: false
  2709. autoincrement: false
  2710. type:
  2711. type: string(255)
  2712. fixed: false
  2713. unsigned: false
  2714. primary: false
  2715. notnull: false
  2716. autoincrement: false
  2717. identity_url:
  2718. type: string(255)
  2719. fixed: false
  2720. unsigned: false
  2721. primary: false
  2722. notnull: false
  2723. autoincrement: false
  2724. UsersInfos:
  2725. connection: ikimea
  2726. tableName: users_infos
  2727. columns:
  2728. uid_pk:
  2729. type: integer(4)
  2730. fixed: false
  2731. unsigned: false
  2732. primary: true
  2733. autoincrement: true
  2734. uid_id:
  2735. type: integer(4)
  2736. fixed: false
  2737. unsigned: false
  2738. primary: false
  2739. notnull: true
  2740. autoincrement: false
  2741. uid_societe:
  2742. type: string(255)
  2743. fixed: false
  2744. unsigned: false
  2745. primary: false
  2746. notnull: true
  2747. autoincrement: false
  2748. uid_tel_fix:
  2749. type: string(20)
  2750. fixed: false
  2751. unsigned: false
  2752. primary: false
  2753. notnull: true
  2754. autoincrement: false
  2755. uid_tel_mobile:
  2756. type: string(20)
  2757. fixed: false
  2758. unsigned: false
  2759. primary: false
  2760. notnull: true
  2761. autoincrement: false
  2762. uid_adresse:
  2763. type: string(255)
  2764. fixed: false
  2765. unsigned: false
  2766. primary: false
  2767. notnull: true
  2768. autoincrement: false
  2769. uid_code_postal:
  2770. type: integer(4)
  2771. fixed: false
  2772. unsigned: false
  2773. primary: false
  2774. notnull: true
  2775. autoincrement: false
  2776. uid_ville:
  2777. type: string(255)
  2778. fixed: false
  2779. unsigned: false
  2780. primary: false
  2781. notnull: true
  2782. autoincrement: false
  2783. uid_pays:
  2784. type: string(255)
  2785. fixed: false
  2786. unsigned: false
  2787. primary: false
  2788. notnull: true
  2789. autoincrement: false
  2790. Versions:
  2791. connection: redmine
  2792. tableName: versions
  2793. columns:
  2794. id:
  2795. type: integer(4)
  2796. fixed: false
  2797. unsigned: false
  2798. primary: true
  2799. autoincrement: true
  2800. project_id:
  2801. type: integer(4)
  2802. fixed: false
  2803. unsigned: false
  2804. primary: false
  2805. default: '0'
  2806. notnull: true
  2807. autoincrement: false
  2808. name:
  2809. type: string(255)
  2810. fixed: false
  2811. unsigned: false
  2812. primary: false
  2813. default: ''
  2814. notnull: true
  2815. autoincrement: false
  2816. description:
  2817. type: string(255)
  2818. fixed: false
  2819. unsigned: false
  2820. primary: false
  2821. default: ''
  2822. notnull: false
  2823. autoincrement: false
  2824. effective_date:
  2825. type: date(25)
  2826. fixed: false
  2827. unsigned: false
  2828. primary: false
  2829. notnull: false
  2830. autoincrement: false
  2831. created_on:
  2832. type: timestamp(25)
  2833. fixed: false
  2834. unsigned: false
  2835. primary: false
  2836. notnull: false
  2837. autoincrement: false
  2838. updated_on:
  2839. type: timestamp(25)
  2840. fixed: false
  2841. unsigned: false
  2842. primary: false
  2843. notnull: false
  2844. autoincrement: false
  2845. wiki_page_title:
  2846. type: string(255)
  2847. fixed: false
  2848. unsigned: false
  2849. primary: false
  2850. notnull: false
  2851. autoincrement: false
  2852. status:
  2853. type: string(255)
  2854. fixed: false
  2855. unsigned: false
  2856. primary: false
  2857. default: open
  2858. notnull: false
  2859. autoincrement: false
  2860. sharing:
  2861. type: string(255)
  2862. fixed: false
  2863. unsigned: false
  2864. primary: false
  2865. default: none
  2866. notnull: true
  2867. autoincrement: false
  2868. Watchers:
  2869. connection: redmine
  2870. tableName: watchers
  2871. columns:
  2872. id:
  2873. type: integer(4)
  2874. fixed: false
  2875. unsigned: false
  2876. primary: true
  2877. autoincrement: true
  2878. watchable_type:
  2879. type: string(255)
  2880. fixed: false
  2881. unsigned: false
  2882. primary: false
  2883. default: ''
  2884. notnull: true
  2885. autoincrement: false
  2886. watchable_id:
  2887. type: integer(4)
  2888. fixed: false
  2889. unsigned: false
  2890. primary: false
  2891. default: '0'
  2892. notnull: true
  2893. autoincrement: false
  2894. user_id:
  2895. type: integer(4)
  2896. fixed: false
  2897. unsigned: false
  2898. primary: false
  2899. notnull: false
  2900. autoincrement: false
  2901. WikiContentVersions:
  2902. connection: redmine
  2903. tableName: wiki_content_versions
  2904. columns:
  2905. id:
  2906. type: integer(4)
  2907. fixed: false
  2908. unsigned: false
  2909. primary: true
  2910. autoincrement: true
  2911. wiki_content_id:
  2912. type: integer(4)
  2913. fixed: false
  2914. unsigned: false
  2915. primary: false
  2916. notnull: true
  2917. autoincrement: false
  2918. page_id:
  2919. type: integer(4)
  2920. fixed: false
  2921. unsigned: false
  2922. primary: false
  2923. notnull: true
  2924. autoincrement: false
  2925. author_id:
  2926. type: integer(4)
  2927. fixed: false
  2928. unsigned: false
  2929. primary: false
  2930. notnull: false
  2931. autoincrement: false
  2932. data:
  2933. type: blob()
  2934. fixed: false
  2935. unsigned: false
  2936. primary: false
  2937. notnull: false
  2938. autoincrement: false
  2939. compression:
  2940. type: string(6)
  2941. fixed: false
  2942. unsigned: false
  2943. primary: false
  2944. default: ''
  2945. notnull: false
  2946. autoincrement: false
  2947. comments:
  2948. type: string(255)
  2949. fixed: false
  2950. unsigned: false
  2951. primary: false
  2952. default: ''
  2953. notnull: false
  2954. autoincrement: false
  2955. updated_on:
  2956. type: timestamp(25)
  2957. fixed: false
  2958. unsigned: false
  2959. primary: false
  2960. notnull: true
  2961. autoincrement: false
  2962. version:
  2963. type: integer(4)
  2964. fixed: false
  2965. unsigned: false
  2966. primary: false
  2967. notnull: true
  2968. autoincrement: false
  2969. WikiContents:
  2970. connection: redmine
  2971. tableName: wiki_contents
  2972. columns:
  2973. id:
  2974. type: integer(4)
  2975. fixed: false
  2976. unsigned: false
  2977. primary: true
  2978. autoincrement: true
  2979. page_id:
  2980. type: integer(4)
  2981. fixed: false
  2982. unsigned: false
  2983. primary: false
  2984. notnull: true
  2985. autoincrement: false
  2986. author_id:
  2987. type: integer(4)
  2988. fixed: false
  2989. unsigned: false
  2990. primary: false
  2991. notnull: false
  2992. autoincrement: false
  2993. text:
  2994. type: string()
  2995. fixed: false
  2996. unsigned: false
  2997. primary: false
  2998. notnull: false
  2999. autoincrement: false
  3000. comments:
  3001. type: string(255)
  3002. fixed: false
  3003. unsigned: false
  3004. primary: false
  3005. default: ''
  3006. notnull: false
  3007. autoincrement: false
  3008. updated_on:
  3009. type: timestamp(25)
  3010. fixed: false
  3011. unsigned: false
  3012. primary: false
  3013. notnull: true
  3014. autoincrement: false
  3015. version:
  3016. type: integer(4)
  3017. fixed: false
  3018. unsigned: false
  3019. primary: false
  3020. notnull: true
  3021. autoincrement: false
  3022. WikiPages:
  3023. connection: redmine
  3024. tableName: wiki_pages
  3025. columns:
  3026. id:
  3027. type: integer(4)
  3028. fixed: false
  3029. unsigned: false
  3030. primary: true
  3031. autoincrement: true
  3032. wiki_id:
  3033. type: integer(4)
  3034. fixed: false
  3035. unsigned: false
  3036. primary: false
  3037. notnull: true
  3038. autoincrement: false
  3039. title:
  3040. type: string(255)
  3041. fixed: false
  3042. unsigned: false
  3043. primary: false
  3044. notnull: true
  3045. autoincrement: false
  3046. created_on:
  3047. type: timestamp(25)
  3048. fixed: false
  3049. unsigned: false
  3050. primary: false
  3051. notnull: true
  3052. autoincrement: false
  3053. protected:
  3054. type: integer(1)
  3055. fixed: false
  3056. unsigned: false
  3057. primary: false
  3058. default: '0'
  3059. notnull: true
  3060. autoincrement: false
  3061. parent_id:
  3062. type: integer(4)
  3063. fixed: false
  3064. unsigned: false
  3065. primary: false
  3066. notnull: false
  3067. autoincrement: false
  3068. WikiRedirects:
  3069. connection: redmine
  3070. tableName: wiki_redirects
  3071. columns:
  3072. id:
  3073. type: integer(4)
  3074. fixed: false
  3075. unsigned: false
  3076. primary: true
  3077. autoincrement: true
  3078. wiki_id:
  3079. type: integer(4)
  3080. fixed: false
  3081. unsigned: false
  3082. primary: false
  3083. notnull: true
  3084. autoincrement: false
  3085. title:
  3086. type: string(255)
  3087. fixed: false
  3088. unsigned: false
  3089. primary: false
  3090. notnull: false
  3091. autoincrement: false
  3092. redirects_to:
  3093. type: string(255)
  3094. fixed: false
  3095. unsigned: false
  3096. primary: false
  3097. notnull: false
  3098. autoincrement: false
  3099. created_on:
  3100. type: timestamp(25)
  3101. fixed: false
  3102. unsigned: false
  3103. primary: false
  3104. notnull: true
  3105. autoincrement: false
  3106. Wikis:
  3107. connection: redmine
  3108. tableName: wikis
  3109. columns:
  3110. id:
  3111. type: integer(4)
  3112. fixed: false
  3113. unsigned: false
  3114. primary: true
  3115. autoincrement: true
  3116. project_id:
  3117. type: integer(4)
  3118. fixed: false
  3119. unsigned: false
  3120. primary: false
  3121. notnull: true
  3122. autoincrement: false
  3123. start_page:
  3124. type: string(255)
  3125. fixed: false
  3126. unsigned: false
  3127. primary: false
  3128. notnull: true
  3129. autoincrement: false
  3130. status:
  3131. type: integer(4)
  3132. fixed: false
  3133. unsigned: false
  3134. primary: false
  3135. default: '1'
  3136. notnull: true
  3137. autoincrement: false
  3138. Workflows:
  3139. connection: redmine
  3140. tableName: workflows
  3141. columns:
  3142. id:
  3143. type: integer(4)
  3144. fixed: false
  3145. unsigned: false
  3146. primary: true
  3147. autoincrement: true
  3148. tracker_id:
  3149. type: integer(4)
  3150. fixed: false
  3151. unsigned: false
  3152. primary: false
  3153. default: '0'
  3154. notnull: true
  3155. autoincrement: false
  3156. old_status_id:
  3157. type: integer(4)
  3158. fixed: false
  3159. unsigned: false
  3160. primary: false
  3161. default: '0'
  3162. notnull: true
  3163. autoincrement: false
  3164. new_status_id:
  3165. type: integer(4)
  3166. fixed: false
  3167. unsigned: false
  3168. primary: false
  3169. default: '0'
  3170. notnull: true
  3171. autoincrement: false
  3172. role_id:
  3173. type: integer(4)
  3174. fixed: false
  3175. unsigned: false
  3176. primary: false
  3177. default: '0'
  3178. notnull: true
  3179. autoincrement: false
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!