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
21 Feb, 2003
1 commit
  • added parent_folder_ids AS char(100) and another column name full_path char(255) ...
    a11593a4
    to folders
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@1012 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-02-21 09:26:17 +0000  
    Browse Dir »

20 Feb, 2003
1 commit
  • added full_path char(255) and parent_folder_ids CHAR(100) to documents table ...
    80c5d262
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@1008 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-02-20 14:52:10 +0000  
    Browse Dir »

19 Feb, 2003
1 commit
  • converted all tables to type InnoDB ...
    98482d1f
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@1000 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-02-19 16:20:28 +0000  
    Browse Dir »

13 Feb, 2003
2 commits
  • updated folder permission ids ...
    527e6c40
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@953 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-02-13 10:57:58 +0000  
    Browse Dir »
  • removed test folders ...
    68f51cb3
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@949 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-02-13 09:48:18 +0000  
    Browse Dir »

11 Feb, 2003
1 commit
  • added active field to roles table ...
    838caef8
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@927 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-02-11 11:46:26 +0000  
    Browse Dir »

07 Feb, 2003
1 commit
  • added restricted login for indexing process ...
    707e61cb
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@864 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-02-07 08:28:04 +0000  
    Browse Dir »

06 Feb, 2003
2 commits
  • updated tbl subscriptions ...
    5ccb8fb2
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@852 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-02-06 13:29:14 +0000  
    Browse Dir »
  • updated tbl folders_users_roles_link ...
    1b51f8dc
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@851 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-02-06 13:25:14 +0000  
    Browse Dir »

05 Feb, 2003
1 commit
  • updated from email name system setting ...
    926a1a01
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@809 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-02-05 12:58:33 +0000  
    Browse Dir »

03 Feb, 2003
2 commits
  • added fields to subscription tables ...
    5cd03382
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@783 c91229c3-7414-0410-bfa2-8a42b809f60b
    mukhtar authored
    2003-02-03 12:58:16 +0000  
    Browse Dir »
  • added table sys_deleted ...
    12eb8e8f
    
    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 ...
    6507b72e
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@715 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-31 09:32:46 +0000  
    Browse Dir »

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

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 Dir »
  • 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 Dir »

28 Jan, 2003
5 commits
  • initial revision of dms user sql ...
    a1800908
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@654 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-28 17:25:33 +0000  
    Browse Dir »
  • 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 Dir »
  • 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 Dir »
  • 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 Dir »
  • 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 Dir »

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 Dir »

24 Jan, 2003
5 commits
  • added sitemap tables ...
    8b220e00
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@558 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-24 16:03:54 +0000  
    Browse Dir »
  • 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 Dir »
  • 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 Dir »
  • 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 Dir »
  • 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 Dir »

23 Jan, 2003
2 commits
  • added categories_lookup ...
    55fc9ac7
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@519 c91229c3-7414-0410-bfa2-8a42b809f60b
    Michael Joseph authored
    2003-01-23 16:41:34 +0000  
    Browse Dir »
  • 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 Dir »

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 Dir »

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 Dir »

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 Dir »

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 Dir »

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 Dir »
  • 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 Dir »

16 Jan, 2003
4 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 Dir »
  • 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 Dir »
  • 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 Dir »
  • 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 Dir »