Logo white

Peter M. Groen / knowledgetree

Sign in
  • Sign in
  • Project
  • Files
  • Commits
  • Network
  • Graphs
  • Milestones
  • Issues 0
  • Merge Requests 0
  • Labels
  • Wiki
  • Commits 9,762
  • Compare
  • Branches 2
  • Tags 28
  • knowledgetree
  • sql
  • tables.sql
30 Jan, 2003
1 commit
  • changed subscription tables ...
    aefae4c1
    updated folders_users_roles_link
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@694 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-30 09:39:15 +0000  
    Browse File »

29 Jan, 2003
2 commits
  • added system settings ...
    b097fa9a
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@689 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-29 16:55:39 +0000  
    Browse File »
  • added write permission for unit admins on unit root folders ...
    4f26bc68
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@663 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-29 09:39:25 +0000  
    Browse File »

28 Jan, 2003
4 commits
  • added download document transaction type insert ...
    654db22e
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@649 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-28 14:39:52 +0000  
    Browse File »
  • added is_enabled to sitemap table and updated inserts ...
    d9364bb6
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@639 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-28 12:23:37 +0000  
    Browse File »
  • added units_lookup and units_organisations_link tables.. ...
    38fe9947
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@634 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-28 12:16:38 +0000  
    Browse File »
  • no message ...
    6a339cbf
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@618 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-28 10:11:03 +0000  
    Browse File »

27 Jan, 2003
1 commit
  • added document_fields_lookup table ...
    61a56539
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@591 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-27 13:14:03 +0000  
    Browse File »

24 Jan, 2003
4 commits
  • added sitemap tables and inserts ...
    206b7b44
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@557 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-24 16:03:32 +0000  
    Browse File »
  • added is_generic field to document_field ...
    b5e7b8ac
    changed all BOOL types to BIT
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@529 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-24 10:02:03 +0000  
    Browse File »
  • added some users to the finance group ...
    f3029119
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@522 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-24 08:14:58 +0000  
    Browse File »
  • created separate groups for each unit instead of mapping them repeatedly ...
    51b3172d
    updated group_ids in folder permission sql
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@521 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-24 08:13:50 +0000  
    Browse File »

23 Jan, 2003
1 commit
  • added folder structure, users and groups ...
    280fa8f0
    TODO: add files to the folders
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@518 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-23 16:41:18 +0000  
    Browse File »

22 Jan, 2003
1 commit
  • Add some default insert data ...
    4c9a6999
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@470 c91229c3-7414-0410-bfa2-8a42b809f60b
    rob authored
    2003-01-22 14:51:00 +0000  
    Browse File »

21 Jan, 2003
1 commit
  • updated test document insert, set folder_id=3 ...
    d7627dd7
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@424 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-21 10:36:17 +0000  
    Browse File »

20 Jan, 2003
1 commit
  • added language_lookup table and changed language in users to language_id ...
    1809187e
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@399 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-20 14:59:51 +0000  
    Browse File »

18 Jan, 2003
1 commit
  • Add entries for document_transaction_types_lookup ...
    38563ff8
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@338 c91229c3-7414-0410-bfa2-8a42b809f60b
    rob authored
    2003-01-18 14:07:13 +0000  
    Browse File »

17 Jan, 2003
2 commits
  • changed max_sessions value to 1 for admin default user ...
    610ac985
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@329 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-17 15:38:41 +0000  
    Browse File »
  • s/MRC/Medical Research Council/g ...
    8234428f
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@313 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-17 11:24:52 +0000  
    Browse File »

16 Jan, 2003
6 commits
  • Added insert statements for folders table for testing purposes ...
    945dce89
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@291 c91229c3-7414-0410-bfa2-8a42b809f60b
    rob authored
    2003-01-16 16:11:37 +0000  
    Browse File »
  • added icon_path to mime_types table ...
    d9847be1
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@281 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-16 15:41:37 +0000  
    Browse File »
  • changed done type from bool to bit in folders_users_roles_link ...
    5e635166
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@270 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-16 11:38:30 +0000  
    Browse File »
  • fixed bug with insertion into users_groups_link ...
    a205d985
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@244 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-16 08:54:31 +0000  
    Browse File »
  • changes...renamed ...
    11b678f3
    - folders_user_roles_link => folders_users_roles_link
    - user_group_link => users_groups_link
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@243 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-16 08:51:20 +0000  
    Browse File »
  • added some default inserts for testing ...
    3d82503a
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@237 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-16 08:03:07 +0000  
    Browse File »

15 Jan, 2003
3 commits
  • fixed error ...
    7ce3e7ae
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@224 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-15 15:21:37 +0000  
    Browse File »
  • added groups_units_link table ...
    85c8d02f
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@221 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-15 14:45:38 +0000  
    Browse File »
  • changed mobile field in users to a char instead of an integer ...
    43888bcb
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@213 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-15 11:38:07 +0000  
    Browse File »

14 Jan, 2003
3 commits
  • - added session_id CHAR(255) to active sessions ...
    1adec9f4
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@170 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-14 13:51:38 +0000  
    Browse File »
  • - modified users table, added language field ...
    4b173d6f
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@168 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-14 13:13:05 +0000  
    Browse File »
  • - deleted group_id from users ...
    813b2daf
    - changed inserts into users to reflect this deletion
    - added 2 fields to folders_user_roles_link table
         -> datetime DATETIME
         -> done BOOL
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@165 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-14 10:58:37 +0000  
    Browse File »

13 Jan, 2003
5 commits
  • formatted and put in alphabetical order ...
    e2f817b4
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@153 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-13 16:09:09 +0000  
    Browse File »
  • Addded groups_folders_link table and amalgamated groups_users_link and groups_un… ...
    0cac97a9
    …its_link into one table
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@147 c91229c3-7414-0410-bfa2-8a42b809f60b
    rob authored
    2003-01-13 14:41:08 +0000  
    Browse File »
  • fixed couple of errors.. ...
    206acc5f
    adding auto_increment to several tables
    Renamed creatorid to creator_id
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@144 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-13 11:56:37 +0000  
    Browse File »
  • resolved merge conflict ...
    35e1ebc5
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@136 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-13 11:04:50 +0000  
    Browse File »
  • Standardised table naming convention. Added tables to deal with document approval process. ...
    414865d1
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@135 c91229c3-7414-0410-bfa2-8a42b809f60b
    rob authored
    2003-01-13 10:59:07 +0000  
    Browse File »

10 Jan, 2003
4 commits
  • added session_id field to active_sessions ...
    d633bc54
    fixed guest user insert
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@118 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-10 16:23:25 +0000  
    Browse File »
  • correcting admin default insert ...
    30c101b1
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@114 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-10 14:06:27 +0000  
    Browse File »
  • added inserts into web_documents_status after mimes ...
    7f2b429c
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@110 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-01-10 10:06:26 +0000  
    Browse File »
  • added default groups ...
    a85c082b
    fixed formatting
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@104 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-10 09:10:21 +0000  
    Browse File »