/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/testing/tests/regression-suite/ |
H A D | sample-data.sql | 6 INSERT INTO role_member (user_no, role_no) VALUES( 2, 1); 31 INSERT INTO role_member (user_no, role_no) VALUES( 100, 4); 34 INSERT INTO role_member (user_no, role_no) VALUES( 101, 4); 38 INSERT INTO role_member (user_no, role_no) VALUES( 200, 2); 55 FROM usr ORDER BY user_no; 63 FROM usr ORDER BY user_no; 70 … AND NOT EXISTS(SELECT 1 FROM principal WHERE principal.user_no = usr.user_no) ORDER BY user_no; 75 … AND NOT EXISTS(SELECT 1 FROM principal WHERE principal.user_no = usr.user_no) ORDER BY user_no; 80 … AND NOT EXISTS(SELECT 1 FROM principal WHERE principal.user_no = usr.user_no) ORDER BY user_no; 124 JOIN principal pby ON(t.user_no=pby.user_no) [all …]
|
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/patches/ |
H A D | 1.2.3a.sql | 11 …ember ADD CONSTRAINT "role_member_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 14 …E session ADD CONSTRAINT "session_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 17 …INT "relationship_from_user_fkey" FOREIGN KEY (from_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 19 …STRAINT "relationship_to_user_fkey" FOREIGN KEY (to_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 22 …tting ADD CONSTRAINT "usr_setting_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 25 …word ADD CONSTRAINT "tmp_password_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 28 …_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 30 … "caldav_data_logged_user_fkey" FOREIGN KEY (logged_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 33 …RAINT "property_changed_by_fkey" FOREIGN KEY (changed_by) REFERENCES usr(user_no) ON UPDATE CASCAD… 36 …tem ADD CONSTRAINT "calendar_item_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
|
H A D | 1.2.3.sql | 30 …ember ADD CONSTRAINT "role_member_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 33 …E session ADD CONSTRAINT "session_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 36 …INT "relationship_from_user_fkey" FOREIGN KEY (from_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 38 …STRAINT "relationship_to_user_fkey" FOREIGN KEY (to_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 41 …tting ADD CONSTRAINT "usr_setting_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 44 …word ADD CONSTRAINT "tmp_password_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 47 …_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 49 … "caldav_data_logged_user_fkey" FOREIGN KEY (logged_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 52 …RAINT "property_changed_by_fkey" FOREIGN KEY (changed_by) REFERENCES usr(user_no) ON UPDATE CASCAD… 55 …tem ADD CONSTRAINT "calendar_item_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
|
H A D | 1.2.6.sql | 514 user_no INT8 NULL REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field 519 INSERT INTO principal (type_id, user_no, displayname, default_privileges) 521 …e_member JOIN roles USING(role_no) WHERE role_name = 'Group' AND role_member.user_no = usr.user_no) 522 …ber JOIN roles USING(role_no) WHERE role_name = 'Resource' AND role_member.user_no = usr.user_no) ; 524 INSERT INTO principal (type_id, user_no, displayname, default_privileges) 526 …mber JOIN roles USING(role_no) WHERE role_name = 'Resource' AND role_member.user_no = usr.user_no); 530 …_member JOIN roles USING(role_no) WHERE role_name = 'Group' AND role_member.user_no = usr.user_no); 560 FROM relationship r JOIN usr f ON(f.user_no=r.from_user) 561 JOIN usr t ON(t.user_no=r.to_user) 562 JOIN principal pby ON(t.user_no=pby.user_no) [all …]
|
H A D | 1.2.5.sql | 10 …ndar_item ADD CONSTRAINT "calendar_item_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) 14 …ata ADD CONSTRAINT "caldav_data_logged_user_fkey" FOREIGN KEY (logged_user) REFERENCES usr(user_no) 18 …INT "relationship_from_user_fkey" FOREIGN KEY (from_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 20 …STRAINT "relationship_to_user_fkey" FOREIGN KEY (to_user) REFERENCES usr(user_no) ON UPDATE CASCAD… 25 …property ADD CONSTRAINT "property_changed_by_fkey" FOREIGN KEY (changed_by) REFERENCES usr(user_no)
|
H A D | 1.2.1.sql | 59 ALTER TABLE collection ADD UNIQUE (user_no,dav_name); 63 INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calenda… 64 …SELECT user_no, '/'||username||'/', '/'||username||'/home/', md5(user_no::text||'/'||username||'/h… 69 … (select collection.dav_name FROM collection WHERE collection.user_no = caldav_data.user_no limit …
|
H A D | 1.2.1a.sql | 59 ALTER TABLE collection ADD UNIQUE (user_no,dav_name); 63 INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calenda… 64 …SELECT user_no, '/'||username||'/', '/'||username||'/home/', md5(user_no::text||'/'||username||'/h… 69 … (select collection.dav_name FROM collection WHERE collection.user_no = caldav_data.user_no limit …
|
H A D | 1.1.11.sql | 8 ALTER TABLE caldav_data ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE… 11 ALTER TABLE collection ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE …
|
H A D | 1.1.11a.sql | 9 …_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U… 12 …ection ADD CONSTRAINT "collection_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
|
H A D | 1.2.1b.sql | 59 ALTER TABLE collection ADD UNIQUE (user_no,dav_name); 63 INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calenda… 64 …SELECT user_no, '/'||username||'/', '/'||username||'/home/', md5(user_no::text||'/'||username||'/h…
|
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/scripts/ |
H A D | load_calendar.php | 66 var $user_no; variable in FakeSession 74 function __construct($user_no = null) { argument 75 if ( empty($user_no) ) { 76 $this->user_no = -1; 82 $this->user_no = $user_no; 83 $principal = new Principal('user_no',$user_no); 105 $session = new FakeSession($dest->user_no()); 116 $user_no = $dest->user_no(); variable 120 controlRequestContainer( $session->username, $dest->user_no(), $target, false, ($dest->IsPublic() ?… 121 import_collection( $ics, $dest->user_no(), $target, $session->user_no, ($mode == 'append') );
|
H A D | export_calendar.php | 36 var $user_no; variable in FakeSession 44 function __construct($user_no = null) { argument 45 if ( empty($user_no) ) { 46 $this->user_no = -1; 52 $this->user_no = $user_no; 53 $principal = new Principal('user_no',$user_no);
|
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/views/ |
H A D | dav_principal.sql | 7 SELECT user_no, usr.active AS user_active, joined AS created, updated AS modified, 17 FROM usr JOIN principal USING(user_no); 22 …INSERT INTO usr ( user_no, active, joined, updated, username, password, fullname, email, email_ok,… 24 COALESCE( NEW.user_no, nextval('usr_user_no_seq')), 34 INSERT INTO principal ( user_no, principal_id, type_id, displayname, default_privileges ) 36 COALESCE( NEW.user_no, currval('usr_user_no_seq')), 50 user_no=NEW.user_no, 60 WHERE user_no=OLD.user_no; 74 DELETE FROM usr WHERE user_no=OLD.user_no;
|
/dports/devel/php-libawl/awl-827fbfed7dab0ca339998ca6cdcffb328246d83b/inc/ |
H A D | User.php | 42 var $user_no; variable in User 65 $this->user_no = 0; 72 $this->user_no = $id; 83 if ( $this->user_no == 0 ) { 116 $rc = ( $this->user_no > 0 && $session->user_no == $this->user_no ); 120 $rc = ( $this->user_no > 0 && $session->user_no == $this->user_no ); 124 $rc = ( ($this->user_no > 0 && $session->user_no == $this->user_no) 173 if ( $this->user_no > 0 ) $html .= $ef->HiddenField( "user_no", $this->user_no ); 357 $this->user_no = $sequence_value[0]; 360 …if ( $this->user_no == $session->user_no && $this->Get("date_format_type") != $session->date_forma… [all …]
|
H A D | Session.php | 33 * @param int $user_no Which user is attempting to log on. 36 function check_temporary_passwords( $they_sent, $user_no ) { argument 38 $qry = new AwlQuery( $sql, $user_no, $they_sent ); 45 $qry = new AwlQuery( $sql, $user_no ); 75 var $user_no; variable in Session 346 $user_no = ( method_exists( $usr, 'user_no' ) ? $usr->user_no() : $usr->user_no ); 354 dbg_error_log( "Login", " Login: Valid username/password for $username ($user_no)" ); 357 …n.user_no = ? ORDER BY session_id DESC LIMIT 1) WHERE user_no = ?;', $usr->user_no, $usr->user_no); 362 $qry = new AwlQuery( $sql, $session_id, $user_no, $session_key ); 371 … dbg_error_log( "Login", " Login: New session $session_id started for $username ($user_no)" ); [all …]
|
/dports/devel/php-libawl/awl-827fbfed7dab0ca339998ca6cdcffb328246d83b/dba/ |
H A D | awl-tables.sql | 13 user_no SERIAL PRIMARY KEY, field 31 user_no INT4 REFERENCES usr ( user_no ) ON DELETE CASCADE, field 34 PRIMARY KEY ( user_no, setting_name ) 52 user_no INT4 REFERENCES usr ( user_no ) ON DELETE CASCADE field 58 user_no INT4 REFERENCES usr ( user_no ) ON DELETE CASCADE, field 67 user_no INT4 REFERENCES usr ( user_no ), field
|
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/ |
H A D | davical.sql | 99 user_no INT references usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field 116 UNIQUE(user_no,dav_name) 124 user_no INT references usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field 136 PRIMARY KEY ( user_no, dav_name ) 144 user_no INT references usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field 178 PRIMARY KEY ( user_no, dav_name ) 232 user_no integer NOT NULL REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE, field 253 OR OLD.user_no != NEW.user_no OR OLD.dav_name != NEW.dav_name THEN 254 UPDATE calendar_item SET dav_id = NEW.dav_id, user_no = NEW.user_no, 261 UPDATE calendar_item SET dav_id = NEW.dav_id, user_no = NEW.user_no, [all …]
|
H A D | base-data.sql | 17 INSERT INTO usr ( user_no, active, email_ok, updated, username, password, fullname, email ) 19 INSERT INTO principal ( principal_id, type_id, user_no, displayname, default_privileges ) 22 INSERT INTO role_member (user_no, role_no) VALUES(1, 1);
|
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/inc/ |
H A D | caldav-PUT-functions.php | 67 * @param int $user_no The user making the change 118 ':user_no' => $user_no, 121 ':dav_etag' => md5($user_no. $request_container), 150 function public_events_only( $user_no, $dav_name ) { argument 837 ':session_user' => $session->user_no, 885 $dav_data_params[':user_no'] = $user_no; 1072 $dav_data_params[':user_no'] = $user_no; 1380 $user_no = $collection->user_no(); 1534 if ( public_events_only($user_no, $path) ) { 1622 $dav_params[':user_no'] = $user_no; [all …]
|
H A D | log_caldav_action.php | 22 * @param integer $user_no The user owning the containing collection. 26 function log_caldav_action( $action_type, $uid, $user_no, $collection_id, $dav_name ) { argument 35 …$logline = sprintf( '%s, %s, %s, %s, %s, %s', $action_type, $uid, $user_no, $collection_id, $dav_n… 42 function post_commit_action( $action_type, $uid, $user_no, $collection_id, $dav_name ) { argument 51 …$logline = sprintf( '%s, %s, %s, %s, %s, %s', $action_type, $uid, $user_no, $collection_id, $dav_n…
|
H A D | auth-functions.php | 63 function getUserByID( $user_no, $use_cache = true ) { argument 65 return new Principal('user_no', $user_no, $use_cache); 117 $params[':user_no'] = $principal->user_no(); 151 $params2[':user_no'] = $principal->user_no(); 250 if ( !isset($usr->user_no) || intval($usr->user_no) == 0 ) { 254 $usr->user_no = $sequence_value[0]; 257 … = new AwlQuery('SELECT * FROM usr WHERE user_no = :user_no', array(':user_no' => $usr->user_no) ); 283 if ( $type != 'INSERT' ) $params[':user_no'] = $usr->user_no; 302 array(':new_display' => $usr->fullname, ':user_no' => $usr->user_no)
|
H A D | PublicSession.php | 30 * @var user_no int 32 public $user_no; variable in PublicSession 73 $this->user_no = $principal->user_no();
|
H A D | WritableCollection.php | 42 $user_no = $this->user_no(); 47 …rollback_on_error( $caldav_context, $user_no, $this->dav_name.'/'.$segment_name, translate('No cal… 83 rollback_on_error( $caldav_context, $user_no, $path); 94 ':user_no' => $user_no, 102 ':session_user' => $session->user_no, 123 rollback_on_error( $caldav_context, $user_no, $path); 259 … log_caldav_action( $put_action_type, $first->GetPValue('UID'), $user_no, $collection_id, $path ); 263 $put_action_type, $first->GetPValue('UID'), $user_no, $collection_id, $path ); 269 rollback_on_error( $caldav_context, $user_no, $path); 275 dbg_error_log( 'PUT', 'User: %d, ETag: %s, Path: %s', $session->user_no, $etag, $path);
|
H A D | caldav-PUT-vcard.php | 71 $user_no = $dest->GetProperty('user_no'); variable 114 ':user_no' => $user_no, 118 ':session_user' => $session->user_no, 130 import_collection($request->raw_post, $request->user_no, $request->path, true, $appending); 166 log_caldav_action( $put_action_type, $uid, $user_no, $collection_id, $request->path ); 170 $put_action_type, $uid, $user_no, $collection_id, $request->path );
|
H A D | Principal.php | 50 protected $user_no; variable in Principal 145 case 'user_no': $this->user_no = $value; break; 186 self::$byUserno[$row->user_no] = $row->username; 228 self::$byUserno[$row->user_no] = $row->username; 266 $this->user_no = -1; 352 function user_no() { function in Principal 353 return (isset($this->user_no)?$this->user_no:false); 414 …lQuery('SELECT * FROM collection WHERE user_no= :user_no', array(':user_no' => $this->user_no()) ); 562 if ( isset($this->user_no) ) { 565 $sql_params[':user_no'] = $this->user_no;
|