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
20 Feb, 2003
1 commit
  • added full_path char(255) and parent_folder_ids CHAR(100) to documents table ...
    75259a27
    
    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 ...
    85f7c8fc
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@1000 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-02-19 16:20:28 +0000  
    Browse Dir »

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

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

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

06 Feb, 2003
2 commits
  • updated tbl subscriptions ...
    f27a9582
    
    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 ...
    383035c7
    
    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 ...
    e98b1213
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@809 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-02-05 12:58:33 +0000  
    Browse Dir »

03 Feb, 2003
2 commits
  • added fields to subscription tables ...
    9e150862
    
    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 ...
    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
5 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 »