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
28 Jan, 2003
4 commits
  • 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 File »
  • 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 File »
  • 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 File »
  • 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 File »

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

24 Jan, 2003
4 commits
  • 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 File »
  • 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 File »
  • 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 File »
  • 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 File »

23 Jan, 2003
1 commit
  • 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 File »

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

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

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

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

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

16 Jan, 2003
6 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 File »
  • 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 File »
  • 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 File »
  • 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 File »
  • 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 File »
  • 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 File »

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

14 Jan, 2003
3 commits
  • - 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 File »
  • - 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 File »
  • - 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 File »

13 Jan, 2003
5 commits
  • formatted and put in alphabetical order ...
    c87fcba2
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@153 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-13 16:09:09 +0000  
    Browse File »
  • Addded groups_folders_link table and amalgamated groups_users_link and groups_un… ...
    b1d91020
    …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.. ...
    d2311bcb
    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 ...
    86010652
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@136 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-13 11:04:50 +0000  
    Browse File »
  • Standardised table naming convention. Added tables to deal with document approval process. ...
    08051624
    
    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 ...
    2376ce57
    fixed guest user insert
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@118 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-10 16:23:25 +0000  
    Browse File »
  • correcting admin default insert ...
    52303d86
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@114 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-10 14:06:27 +0000  
    Browse File »
  • added inserts into web_documents_status after mimes ...
    0253dfd9
    
    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 ...
    9535c715
    fixed formatting
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@104 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-10 09:10:21 +0000  
    Browse File »

09 Jan, 2003
3 commits
  • added and changed owl inserts ...
    730125d6
    adding primary keys at table create time instead of altering the table and adding a pk constraint
    made all id columns auto_increment
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@78 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-09 10:11:34 +0000  
    Browse File »
  • fixed user table syntax bug ...
    65f725e7
    adding drop tables script
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@75 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-09 08:51:56 +0000  
    Browse File »
  • change mobile field type to char ...
    07fc1ff9
    added ldap_dn field
    
    
    git-svn-id: https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk@74 c91229c3-7414-0410-bfa2-8a42b809f60b
    michael authored
    2003-01-09 08:38:12 +0000  
    Browse File »