API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 18th, 2017
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
YAML 13.87 KB | None | 0 0
raw download clone embed print report
  1.  
  2. AlkitoMembre:
  3.   connection: doctrine
  4.   tableName: alkito_membre
  5.   columns:
  6.     id:
  7.       type: integer(8)
  8.       fixed: false
  9.       unsigned: false
  10.       primary: true
  11.       autoincrement: true
  12.     user_id:
  13.       type: integer(4)
  14.       fixed: false
  15.       unsigned: false
  16.       primary: false
  17.       notnull: true
  18.       autoincrement: false
  19.     email:
  20.       type: string(80)
  21.       fixed: false
  22.       unsigned: false
  23.       primary: false
  24.       notnull: true
  25.       autoincrement: false
  26.     village_id:
  27.       type: integer(8)
  28.       fixed: false
  29.       unsigned: false
  30.       primary: false
  31.       notnull: false
  32.       autoincrement: false
  33.     pseudo:
  34.       type: string(255)
  35.       fixed: false
  36.       unsigned: false
  37.       primary: false
  38.       notnull: true
  39.       autoincrement: false
  40.     motdepasse:
  41.       type: string(128)
  42.       fixed: false
  43.       unsigned: false
  44.       primary: false
  45.       notnull: false
  46.       autoincrement: false
  47.     avatar:
  48.       type: string(255)
  49.       fixed: false
  50.       unsigned: false
  51.       primary: false
  52.       default: inconnu.jpg
  53.       notnull: false
  54.       autoincrement: false
  55.     level:
  56.       type: integer(3)
  57.       fixed: false
  58.       unsigned: false
  59.       primary: false
  60.       default: '1'
  61.       notnull: true
  62.       autoincrement: false
  63.     argent:
  64.       type: integer(8)
  65.       fixed: false
  66.       unsigned: false
  67.       primary: false
  68.       default: '0'
  69.       notnull: true
  70.       autoincrement: false
  71.     pdv:
  72.       type: integer(8)
  73.       fixed: false
  74.       unsigned: false
  75.       primary: false
  76.       default: '100'
  77.       notnull: true
  78.       autoincrement: false
  79.     pdv_max:
  80.       type: integer(8)
  81.       fixed: false
  82.       unsigned: false
  83.       primary: false
  84.       default: '100'
  85.       notnull: true
  86.       autoincrement: false
  87.     experience:
  88.       type: integer(8)
  89.       fixed: false
  90.       unsigned: false
  91.       primary: false
  92.       default: '0'
  93.       notnull: true
  94.       autoincrement: false
  95.     experience_max:
  96.       type: integer(8)
  97.       fixed: false
  98.       unsigned: false
  99.       primary: false
  100.       default: '100'
  101.       notnull: true
  102.       autoincrement: false
  103.     points_competence:
  104.       type: integer(3)
  105.       fixed: false
  106.       unsigned: false
  107.       primary: false
  108.       default: '0'
  109.       notnull: false
  110.       autoincrement: false
  111.     bois:
  112.       type: integer(8)
  113.       fixed: false
  114.       unsigned: false
  115.       primary: false
  116.       default: '0'
  117.       notnull: false
  118.       autoincrement: false
  119.     pierre:
  120.       type: integer(8)
  121.       fixed: false
  122.       unsigned: false
  123.       primary: false
  124.       default: '0'
  125.       notnull: false
  126.       autoincrement: false
  127.     metal:
  128.       type: integer(8)
  129.       fixed: false
  130.       unsigned: false
  131.       primary: false
  132.       default: '0'
  133.       notnull: false
  134.       autoincrement: false
  135.     arme_id:
  136.       type: integer(8)
  137.       fixed: false
  138.       unsigned: false
  139.       primary: false
  140.       notnull: false
  141.       autoincrement: false
  142.     armure_id:
  143.       type: integer(8)
  144.       fixed: false
  145.       unsigned: false
  146.       primary: false
  147.       notnull: false
  148.       autoincrement: false
  149.     quete_id:
  150.       type: integer(8)
  151.       fixed: false
  152.       unsigned: false
  153.       primary: false
  154.       default: '1'
  155.       notnull: false
  156.       autoincrement: false
  157.     created_at:
  158.       type: timestamp(25)
  159.       fixed: false
  160.       unsigned: false
  161.       primary: false
  162.       notnull: true
  163.       autoincrement: false
  164.     updated_at:
  165.       type: timestamp(25)
  166.       fixed: false
  167.       unsigned: false
  168.       primary: false
  169.       notnull: true
  170.       autoincrement: false
  171.   relations:
  172.     AlkitoObjet:
  173.       local: arme_id
  174.       foreign: id
  175.       type: one
  176.     AlkitoObjet_2:
  177.       class: AlkitoObjet
  178.       local: armure_id
  179.       foreign: id
  180.       type: one
  181.     AlkitoQuete:
  182.       local: quete_id
  183.       foreign: id
  184.       type: one
  185.     SfGuardUser:
  186.       local: user_id
  187.       foreign: id
  188.       type: one
  189.     SfGuardUser_5:
  190.       class: SfGuardUser
  191.       local: user_id
  192.       foreign: id
  193.       type: one
  194.     AlkitoVillage:
  195.       local: id
  196.       foreign: chef_village_id
  197.       type: many
  198.     AlkitoEvenement:
  199.       local: id
  200.       foreign: membre_id
  201.       type: many
  202.     AlkitoMembreAmi:
  203.       local: id
  204.       foreign: membre_id
  205.       type: many
  206.     AlkitoMembreAmi_2:
  207.       class: AlkitoMembreAmi
  208.       local: id
  209.       foreign: ami_membre_id
  210.       type: many
  211.     AlkitoMembreCompetence:
  212.       local: id
  213.       foreign: membre_id
  214.       type: many
  215.     AlkitoObjetPossession:
  216.       local: id
  217.       foreign: membre_id
  218.       type: many
  219.     AlkitoRecetteFabrication:
  220.       local: id
  221.       foreign: membre_id
  222.       type: many
  223.     AlkitoRecolte:
  224.       local: id
  225.       foreign: membre_id
  226.       type: many
  227.     AlkitoVillageCombattant:
  228.       local: id
  229.       foreign: membre_id
  230.       type: many
  231.     AlkitoVillageForumPost:
  232.       local: id
  233.       foreign: membre_id
  234.       type: many
  235.     AlkitoVillageForumTopic:
  236.       local: id
  237.       foreign: membre_id
  238.       type: many
  239.     AlkitoVillageNew:
  240.       local: id
  241.       foreign: membre_id
  242.       type: many
  243.  
  244.  
  245.  
  246. SfGuardForgotPassword:
  247.   connection: doctrine
  248.   tableName: sf_guard_forgot_password
  249.   columns:
  250.     id:
  251.       type: integer(8)
  252.       fixed: false
  253.       unsigned: false
  254.       primary: true
  255.       autoincrement: true
  256.     user_id:
  257.       type: integer(4)
  258.       fixed: false
  259.       unsigned: false
  260.       primary: false
  261.       notnull: true
  262.       autoincrement: false
  263.     unique_key:
  264.       type: string(255)
  265.       fixed: false
  266.       unsigned: false
  267.       primary: false
  268.       notnull: false
  269.       autoincrement: false
  270.     expires_at:
  271.       type: timestamp(25)
  272.       fixed: false
  273.       unsigned: false
  274.       primary: false
  275.       notnull: true
  276.       autoincrement: false
  277.     created_at:
  278.       type: timestamp(25)
  279.       fixed: false
  280.       unsigned: false
  281.       primary: false
  282.       notnull: true
  283.       autoincrement: false
  284.     updated_at:
  285.       type: timestamp(25)
  286.       fixed: false
  287.       unsigned: false
  288.       primary: false
  289.       notnull: true
  290.       autoincrement: false
  291.   relations:
  292.     SfGuardUser:
  293.       local: user_id
  294.       foreign: id
  295.       type: one
  296. SfGuardGroup:
  297.   connection: doctrine
  298.   tableName: sf_guard_group
  299.   columns:
  300.     id:
  301.       type: integer(4)
  302.       fixed: false
  303.       unsigned: false
  304.       primary: true
  305.       autoincrement: true
  306.     name:
  307.       type: string(255)
  308.       fixed: false
  309.       unsigned: false
  310.       primary: false
  311.       notnull: false
  312.       autoincrement: false
  313.     description:
  314.       type: string()
  315.       fixed: false
  316.       unsigned: false
  317.       primary: false
  318.       notnull: false
  319.       autoincrement: false
  320.     created_at:
  321.       type: timestamp(25)
  322.       fixed: false
  323.       unsigned: false
  324.       primary: false
  325.       notnull: true
  326.       autoincrement: false
  327.     updated_at:
  328.       type: timestamp(25)
  329.       fixed: false
  330.       unsigned: false
  331.       primary: false
  332.       notnull: true
  333.       autoincrement: false
  334.   relations:
  335.     SfGuardGroupPermission:
  336.       local: id
  337.       foreign: group_id
  338.       type: many
  339.     SfGuardUserGroup:
  340.       local: id
  341.       foreign: group_id
  342.       type: many
  343. SfGuardGroupPermission:
  344.   connection: doctrine
  345.   tableName: sf_guard_group_permission
  346.   columns:
  347.     group_id:
  348.       type: integer(4)
  349.       fixed: false
  350.       unsigned: false
  351.       primary: true
  352.       autoincrement: false
  353.     permission_id:
  354.       type: integer(4)
  355.       fixed: false
  356.       unsigned: false
  357.       primary: true
  358.       autoincrement: false
  359.     created_at:
  360.       type: timestamp(25)
  361.       fixed: false
  362.       unsigned: false
  363.       primary: false
  364.       notnull: true
  365.       autoincrement: false
  366.     updated_at:
  367.       type: timestamp(25)
  368.       fixed: false
  369.       unsigned: false
  370.       primary: false
  371.       notnull: true
  372.       autoincrement: false
  373.   relations:
  374.     SfGuardGroup:
  375.       local: group_id
  376.       foreign: id
  377.       type: one
  378.     SfGuardPermission:
  379.       local: permission_id
  380.       foreign: id
  381.       type: one
  382. SfGuardPermission:
  383.   connection: doctrine
  384.   tableName: sf_guard_permission
  385.   columns:
  386.     id:
  387.       type: integer(4)
  388.       fixed: false
  389.       unsigned: false
  390.       primary: true
  391.       autoincrement: true
  392.     name:
  393.       type: string(255)
  394.       fixed: false
  395.       unsigned: false
  396.       primary: false
  397.       notnull: false
  398.       autoincrement: false
  399.     description:
  400.       type: string()
  401.       fixed: false
  402.       unsigned: false
  403.       primary: false
  404.       notnull: false
  405.       autoincrement: false
  406.     created_at:
  407.       type: timestamp(25)
  408.       fixed: false
  409.       unsigned: false
  410.       primary: false
  411.       notnull: true
  412.       autoincrement: false
  413.     updated_at:
  414.       type: timestamp(25)
  415.       fixed: false
  416.       unsigned: false
  417.       primary: false
  418.       notnull: true
  419.       autoincrement: false
  420.   relations:
  421.     SfGuardGroupPermission:
  422.       local: id
  423.       foreign: permission_id
  424.       type: many
  425.     SfGuardUserPermission:
  426.       local: id
  427.       foreign: permission_id
  428.       type: many
  429. SfGuardRememberKey:
  430.   connection: doctrine
  431.   tableName: sf_guard_remember_key
  432.   columns:
  433.     id:
  434.       type: integer(4)
  435.       fixed: false
  436.       unsigned: false
  437.       primary: true
  438.       autoincrement: true
  439.     user_id:
  440.       type: integer(4)
  441.       fixed: false
  442.       unsigned: false
  443.       primary: false
  444.       notnull: false
  445.       autoincrement: false
  446.     remember_key:
  447.       type: string(32)
  448.       fixed: false
  449.       unsigned: false
  450.       primary: false
  451.       notnull: false
  452.       autoincrement: false
  453.     ip_address:
  454.       type: string(50)
  455.       fixed: false
  456.       unsigned: false
  457.       primary: true
  458.       autoincrement: false
  459.     created_at:
  460.       type: timestamp(25)
  461.       fixed: false
  462.       unsigned: false
  463.       primary: false
  464.       notnull: true
  465.       autoincrement: false
  466.     updated_at:
  467.       type: timestamp(25)
  468.       fixed: false
  469.       unsigned: false
  470.       primary: false
  471.       notnull: true
  472.       autoincrement: false
  473.   relations:
  474.     SfGuardUser:
  475.       local: user_id
  476.       foreign: id
  477.       type: one
  478. SfGuardUser:
  479.   connection: doctrine
  480.   tableName: sf_guard_user
  481.   columns:
  482.     id:
  483.       type: integer(4)
  484.       fixed: false
  485.       unsigned: false
  486.       primary: true
  487.       autoincrement: true
  488.     username:
  489.       type: string(128)
  490.       fixed: false
  491.       unsigned: false
  492.       primary: false
  493.       notnull: true
  494.       autoincrement: false
  495.     algorithm:
  496.       type: string(128)
  497.       fixed: false
  498.       unsigned: false
  499.       primary: false
  500.       default: sha1
  501.       notnull: true
  502.       autoincrement: false
  503.     salt:
  504.       type: string(128)
  505.       fixed: false
  506.       unsigned: false
  507.       primary: false
  508.       notnull: false
  509.       autoincrement: false
  510.     password:
  511.       type: string(128)
  512.       fixed: false
  513.       unsigned: false
  514.       primary: false
  515.       notnull: false
  516.       autoincrement: false
  517.     is_active:
  518.       type: integer(1)
  519.       fixed: false
  520.       unsigned: false
  521.       primary: false
  522.       default: '1'
  523.       notnull: false
  524.       autoincrement: false
  525.     is_super_admin:
  526.       type: integer(1)
  527.       fixed: false
  528.       unsigned: false
  529.       primary: false
  530.       default: '0'
  531.       notnull: false
  532.       autoincrement: false
  533.     last_login:
  534.       type: timestamp(25)
  535.       fixed: false
  536.       unsigned: false
  537.       primary: false
  538.       notnull: false
  539.       autoincrement: false
  540.     created_at:
  541.       type: timestamp(25)
  542.       fixed: false
  543.       unsigned: false
  544.       primary: false
  545.       notnull: true
  546.       autoincrement: false
  547.     updated_at:
  548.       type: timestamp(25)
  549.       fixed: false
  550.       unsigned: false
  551.       primary: false
  552.       notnull: true
  553.       autoincrement: false
  554.   relations:
  555.     AlkitoMembre:
  556.       local: id
  557.       foreign: user_id
  558.       type: many
  559.     AlkitoMembre_5:
  560.       class: AlkitoMembre
  561.       local: id
  562.       foreign: user_id
  563.       type: many
  564.     SfGuardForgotPassword:
  565.       local: id
  566.       foreign: user_id
  567.       type: many
  568.     SfGuardRememberKey:
  569.       local: id
  570.       foreign: user_id
  571.       type: many
  572.     SfGuardUserGroup:
  573.       local: id
  574.       foreign: user_id
  575.       type: many
  576.     SfGuardUserPermission:
  577.       local: id
  578.       foreign: user_id
  579.       type: many
  580. SfGuardUserGroup:
  581.   connection: doctrine
  582.   tableName: sf_guard_user_group
  583.   columns:
  584.     user_id:
  585.       type: integer(4)
  586.       fixed: false
  587.       unsigned: false
  588.       primary: true
  589.       autoincrement: false
  590.     group_id:
  591.       type: integer(4)
  592.       fixed: false
  593.       unsigned: false
  594.       primary: true
  595.       autoincrement: false
  596.     created_at:
  597.       type: timestamp(25)
  598.       fixed: false
  599.       unsigned: false
  600.       primary: false
  601.       notnull: true
  602.       autoincrement: false
  603.     updated_at:
  604.       type: timestamp(25)
  605.       fixed: false
  606.       unsigned: false
  607.       primary: false
  608.       notnull: true
  609.       autoincrement: false
  610.   relations:
  611.     SfGuardGroup:
  612.       local: group_id
  613.       foreign: id
  614.       type: one
  615.     SfGuardUser:
  616.       local: user_id
  617.       foreign: id
  618.       type: one
  619. SfGuardUserPermission:
  620.   connection: doctrine
  621.   tableName: sf_guard_user_permission
  622.   columns:
  623.     user_id:
  624.       type: integer(4)
  625.       fixed: false
  626.       unsigned: false
  627.       primary: true
  628.       autoincrement: false
  629.     permission_id:
  630.       type: integer(4)
  631.       fixed: false
  632.       unsigned: false
  633.       primary: true
  634.       autoincrement: false
  635.     created_at:
  636.       type: timestamp(25)
  637.       fixed: false
  638.       unsigned: false
  639.       primary: false
  640.       notnull: true
  641.       autoincrement: false
  642.     updated_at:
  643.       type: timestamp(25)
  644.       fixed: false
  645.       unsigned: false
  646.       primary: false
  647.       notnull: true
  648.       autoincrement: false
  649.   relations:
  650.     SfGuardPermission:
  651.       local: permission_id
  652.       foreign: id
  653.       type: one
  654.     SfGuardUser:
  655.       local: user_id
  656.       foreign: id
  657.       type: one
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!