Re: [sqlite] Defining user groups in SQLite table

2009-09-03 Thread Simon Slavin
On 3 Sep 2009, at 6:57pm, karenebs wrote: > I have a database table that holds about 20,000 codes. Each code > can be used > by several different user groups. I could add a column to the > database > table for each user group to indicate which codes that particular > group has > access

Re: [sqlite] Defining user groups in SQLite table

2009-09-03 Thread Nicolas Williams
On Thu, Sep 03, 2009 at 10:57:13AM -0700, karenebs wrote: > I have a database table that holds about 20,000 codes. Each code can be used > by several different user groups. I could add a column to the database > table for each user group to indicate which codes that particular group has > access

Re: [sqlite] Defining user groups in SQLite table

2009-09-03 Thread Jay A. Kreibich
On Thu, Sep 03, 2009 at 10:57:13AM -0700, karenebs scratched on the wall: > > I have a database table that holds about 20,000 codes. Each code can be used > by several different user groups. I could add a column to the database > table for each user group to indicate which codes that particular

Re: [sqlite] Defining user groups in SQLite table

2009-09-03 Thread Sebastian Bermudez
table groups ( group_id, group_descri ) table access ( rela_group, rela_code) --- El jue 3-sep-09, karenebs <ka...@echobasesoftware.com> escribió: > De: karenebs <ka...@echobasesoftware.com> > Asunto: [sqlite] Defining user groups in SQLite table > Para: sqlite-use

[sqlite] Defining user groups in SQLite table

2009-09-03 Thread karenebs
another way of doing this? So, group 1 has access to code1, code2, code3, code4, code5; group 2 has access to code1, code2, code3; group 3 has access to code 2, code3, code4. etc. Thanks in advance for any suggestions! -- View this message in context: http://www.nabble.com/Defining-user-groups