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
03 Feb, 2003
1 commit
  • added table sys_deleted ...
    88eed240
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@778 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-02-03 09:23:43 +0000  
    Browse Dir »

31 Jan, 2003
1 commit
  • corrected group_folder_approval_id field name ...
    bf995f6d
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@715 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-31 09:32:46 +0000  
    Browse Dir »

30 Jan, 2003
2 commits
  • updating system settings to reflect unix environments ...
    4941929b
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@707 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-30 15:12:07 +0000  
    Browse Dir »
  • changed subscription tables ...
    f720e194
    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 authored
    2003-01-30 09:39:15 +0000  
    Browse Dir »

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

28 Jan, 2003
5 commits
  • initial revision of dms user sql ...
    539bcca2
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@654 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-28 17:25:33 +0000  
    Browse Dir »
  • added download document transaction type insert ...
    f10d0743
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@649 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-28 14:39:52 +0000  
    Browse Dir »
  • added is_enabled to sitemap table and updated inserts ...
    194b0e1b
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@639 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-28 12:23:37 +0000  
    Browse Dir »
  • added units_lookup and units_organisations_link tables.. ...
    345ad727
    
    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 Dir »
  • no message ...
    536f271e
    
    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 Dir »

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

24 Jan, 2003
5 commits
  • added sitemap tables ...
    da80c177
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@558 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-24 16:03:54 +0000  
    Browse Dir »
  • added sitemap tables and inserts ...
    08b88562
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@557 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-24 16:03:32 +0000  
    Browse Dir »
  • added is_generic field to document_field ...
    2edc6da5
    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 authored
    2003-01-24 10:02:03 +0000  
    Browse Dir »
  • added some users to the finance group ...
    9b134bab
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@522 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-24 08:14:58 +0000  
    Browse Dir »
  • created separate groups for each unit instead of mapping them repeatedly ...
    9ef54c47
    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 authored
    2003-01-24 08:13:50 +0000  
    Browse Dir »

23 Jan, 2003
2 commits
  • added categories_lookup ...
    81d572d1
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@519 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-23 16:41:34 +0000  
    Browse Dir »
  • added folder structure, users and groups ...
    28f7dd95
    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 authored
    2003-01-23 16:41:18 +0000  
    Browse Dir »

22 Jan, 2003
1 commit
  • Add some default insert data ...
    7f02e44d
    
    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 Dir »

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

20 Jan, 2003
1 commit
  • added language_lookup table and changed language in users to language_id ...
    25d83fb9
    
    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 Dir »

18 Jan, 2003
1 commit
  • Add entries for document_transaction_types_lookup ...
    993cf1dd
    
    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 Dir »

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

16 Jan, 2003
7 commits
  • Added insert statements for folders table for testing purposes ...
    52d34b96
    
    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 Dir »
  • added icon_path to mime_types table ...
    6c270b37
    
    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 Dir »
  • changed done type from bool to bit in folders_users_roles_link ...
    27748a00
    
    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 Dir »
  • fixed bug with insertion into users_groups_link ...
    d1a78fdd
    
    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 Dir »
  • changes...renamed ...
    34aadb4f
    - 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 Dir »
  • updated drop script for changed table (group_users_link -> group_units_link) ...
    b7d9cd77
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@238 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-16 08:03:55 +0000  
    Browse Dir »
  • added some default inserts for testing ...
    54bb3d80
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@237 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-16 08:03:07 +0000  
    Browse Dir »

15 Jan, 2003
3 commits
  • fixed error ...
    5154469b
    
    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 Dir »
  • added groups_units_link table ...
    06be86d7
    
    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 Dir »
  • changed mobile field in users to a char instead of an integer ...
    d665bc6e
    
    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 Dir »

14 Jan, 2003
4 commits
  • updated to reflect new/renamed tables ...
    a470c9ac
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@180 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-14 14:32:38 +0000  
    Browse Dir »
  • - added session_id CHAR(255) to active sessions ...
    228853eb
    
    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 Dir »
  • - modified users table, added language field ...
    46026a0e
    
    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 Dir »
  • - deleted group_id from users ...
    22eb2713
    - 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 Dir »

13 Jan, 2003
1 commit
  • updated for modified and new table names ...
    f5565e5b
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@154 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-13 16:09:24 +0000  
    Browse Dir »