Professional Web Applications Themes

Database planning - MySQL

I need to build a schematic for a database I want to build. My question is this: I will have about 10,000 users in a database which these users will use a username/password to log in to a members area with. Should I store their personal details in the same table as their user/pass or keep it in a "user details" table which holds information like their location/interests etc? Thanks...

  1. #1

    Default Database planning

    I need to build a schematic for a database I want to build. My
    question is this:

    I will have about 10,000 users in a database which these users will
    use a username/password to log in to a members area with. Should I
    store their personal details in the same table as their user/pass or
    keep it in a "user details" table which holds information like their
    location/interests etc?

    Thanks

    brad@programs.net Guest

  2. #2

    Default Re: Database planning

    On Apr 9, 10:54 pm, net wrote: 

    second option

    strawberry Guest

  3. Moderated Post

    Default Re: Database planning

    Removed by Administrator
    Gordon Guest
    Moderated Post

  4. #4

    Default Re: Database planning

    net wrote: 

    From a security standpoint it doesn't make much difference. If someone
    can access your source code and/or database directly, they can find
    passwords and/or copy your database files to their own system.

    Otherwise you haven't given nearly enough information. I suggest you
    search on "database normalization". It's a good place to start.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  5. #5

    Default Re: Database planning

    On 10.04.2007 00:02, strawberry wrote: 
    >
    > second option[/ref]

    Why?

    robert
    Robert Guest

  6. #6

    Default Re: Database planning

    On Apr 10, 12:07 pm, Robert Klemme <com> wrote: [/ref]
    > [/ref]
    > [/ref]

    >
    > Why?
    >
    > robert[/ref]

    Because I didn't read the question properly. The answer I would (tend
    to) opt for is, as others (more expert and literate than myself) have
    hinted at, the one that leans towards the greatest normalization,
    which, of course is neither option 1 nor option 2 in this case.

    strawberry Guest

Similar Threads

  1. Interactive CD-ROM project planning
    By notanumber in forum Macromedia Director Basics
    Replies: 3
    Last Post: June 17th, 08:21 AM
  2. Planning a project with PHP.
    By Info@Best-It in forum PHP Development
    Replies: 1
    Last Post: September 6th, 05:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139