Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 4th, 2012  |  syntax: None  |  size: 6.15 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Category:
  2.   connection: doctrine
  3.   tableName: category
  4.   columns:
  5.     category_id:
  6.       type: integer(4)
  7.       fixed: false
  8.       unsigned: false
  9.       primary: true
  10.       autoincrement: true
  11.     category_name:
  12.       type: string()
  13.       fixed: false
  14.       unsigned: false
  15.       primary: false
  16.       notnull: true
  17.       autoincrement: false
  18. Client:
  19.   connection: doctrine
  20.   tableName: client
  21.   columns:
  22.     client_name:
  23.       type: string()
  24.       fixed: false
  25.       unsigned: false
  26.       primary: false
  27.       notnull: true
  28.       autoincrement: false
  29.     client_password:
  30.       type: string()
  31.       fixed: false
  32.       unsigned: false
  33.       primary: false
  34.       notnull: true
  35.       autoincrement: false
  36.     client_full_name:
  37.       type: string()
  38.       fixed: false
  39.       unsigned: false
  40.       primary: false
  41.       notnull: true
  42.       autoincrement: false
  43.     client_address:
  44.       type: integer(4)
  45.       fixed: false
  46.       unsigned: false
  47.       primary: false
  48.       notnull: true
  49.       autoincrement: false
  50.     client_zip:
  51.       type: integer(4)
  52.       fixed: false
  53.       unsigned: false
  54.       primary: false
  55.       notnull: true
  56.       autoincrement: false
  57.     client_creditcard_number:
  58.       type: integer(4)
  59.       fixed: false
  60.       unsigned: false
  61.       primary: false
  62.       notnull: true
  63.       autoincrement: false
  64.     client_company:
  65.       type: string()
  66.       fixed: false
  67.       unsigned: false
  68.       primary: false
  69.       notnull: true
  70.       autoincrement: false
  71.     client_email:
  72.       type: integer(4)
  73.       fixed: false
  74.       unsigned: false
  75.       primary: false
  76.       notnull: true
  77.       autoincrement: false
  78.     client_phone:
  79.       type: integer(4)
  80.       fixed: false
  81.       unsigned: false
  82.       primary: false
  83.       notnull: true
  84.       autoincrement: false
  85.     client_fax:
  86.       type: integer(4)
  87.       fixed: false
  88.       unsigned: false
  89.       primary: false
  90.       notnull: true
  91.       autoincrement: false
  92.     client_d_and_b:
  93.       type: integer(4)
  94.       fixed: false
  95.       unsigned: false
  96.       primary: false
  97.       notnull: true
  98.       autoincrement: false
  99.     client_index:
  100.       type: integer(4)
  101.       fixed: false
  102.       unsigned: false
  103.       primary: true
  104.       autoincrement: true
  105. Company:
  106.   connection: doctrine
  107.   tableName: company
  108.   columns:
  109.     company_name:
  110.       type: string()
  111.       fixed: false
  112.       unsigned: false
  113.       primary: false
  114.       notnull: true
  115.       autoincrement: false
  116.     company_url:
  117.       type: string()
  118.       fixed: false
  119.       unsigned: false
  120.       primary: false
  121.       notnull: true
  122.       autoincrement: false
  123.     company_email:
  124.       type: string()
  125.       fixed: false
  126.       unsigned: false
  127.       primary: false
  128.       notnull: true
  129.       autoincrement: false
  130.     company_address:
  131.       type: string()
  132.       fixed: false
  133.       unsigned: false
  134.       primary: false
  135.       notnull: true
  136.       autoincrement: false
  137.     company_city:
  138.       type: string()
  139.       fixed: false
  140.       unsigned: false
  141.       primary: false
  142.       notnull: true
  143.       autoincrement: false
  144.     company_zip:
  145.       type: string()
  146.       fixed: false
  147.       unsigned: false
  148.       primary: false
  149.       notnull: true
  150.       autoincrement: false
  151.     company_phone:
  152.       type: integer(4)
  153.       fixed: false
  154.       unsigned: false
  155.       primary: false
  156.       notnull: true
  157.       autoincrement: false
  158.     company_fax:
  159.       type: integer(4)
  160.       fixed: false
  161.       unsigned: false
  162.       primary: false
  163.       notnull: true
  164.       autoincrement: false
  165.     company_d_and_b:
  166.       type: integer(4)
  167.       fixed: false
  168.       unsigned: false
  169.       primary: false
  170.       notnull: true
  171.       autoincrement: false
  172.     company_description:
  173.       type: string()
  174.       fixed: false
  175.       unsigned: false
  176.       primary: false
  177.       notnull: true
  178.       autoincrement: false
  179.     company_category_id:
  180.       type: integer(4)
  181.       fixed: false
  182.       unsigned: false
  183.       primary: false
  184.       notnull: true
  185.       autoincrement: false
  186.     company_index:
  187.       type: integer(4)
  188.       fixed: false
  189.       unsigned: false
  190.       primary: true
  191.       autoincrement: true
  192.     company_timestamp:
  193.       type: timestamp(25)
  194.       fixed: false
  195.       unsigned: false
  196.       primary: false
  197.       notnull: true
  198.       autoincrement: false
  199.     company_logo:
  200.       type: string(255)
  201.       fixed: false
  202.       unsigned: false
  203.       primary: false
  204.       notnull: true
  205.       autoincrement: false
  206.     company_keywords:
  207.       type: string()
  208.       fixed: false
  209.       unsigned: false
  210.       primary: false
  211.       notnull: true
  212.       autoincrement: false
  213.     company_is_premium:
  214.       type: integer(1)
  215.       fixed: false
  216.       unsigned: false
  217.       primary: false
  218.       notnull: true
  219.       autoincrement: false
  220.     company_is_approved:
  221.       type: integer(1)
  222.       fixed: false
  223.       unsigned: false
  224.       primary: false
  225.       notnull: true
  226.       autoincrement: false
  227.     relations:
  228.       category: { onDelete: CASCADE, local: company_category_id, foreign: category_id, foreignAlias: Categories }
  229.  
  230. Users:
  231.   connection: doctrine
  232.   tableName: users
  233.   columns:
  234.     user_type:
  235.       type: integer(4)
  236.       fixed: false
  237.       unsigned: false
  238.       primary: false
  239.       notnull: true
  240.       autoincrement: false
  241.     user_full_name:
  242.       type: string()
  243.       fixed: false
  244.       unsigned: false
  245.       primary: false
  246.       notnull: true
  247.       autoincrement: false
  248.     user_email:
  249.       type: string()
  250.       fixed: false
  251.       unsigned: false
  252.       primary: false
  253.       notnull: true
  254.       autoincrement: false
  255.     user_name:
  256.       type: string()
  257.       fixed: false
  258.       unsigned: false
  259.       primary: false
  260.       notnull: true
  261.       autoincrement: false
  262.     user_name_password:
  263.       type: string()
  264.       fixed: false
  265.       unsigned: false
  266.       primary: false
  267.       notnull: true
  268.       autoincrement: false
  269.     user_phone:
  270.       type: integer(4)
  271.       fixed: false
  272.       unsigned: false
  273.       primary: false
  274.       notnull: true
  275.       autoincrement: false
  276.     user_index:
  277.       type: integer(4)
  278.       fixed: false
  279.       unsigned: false
  280.       primary: true
  281.       autoincrement: true
create a new version of this paste RAW Paste Data