topic Where alfresco store users data ? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/where-alfresco-store-users-data/m-p/262003#M215133 <HTML><HEAD></HEAD><BODY><SPAN>hi,</SPAN><BR /><SPAN>i am using alfresco </SPAN><STRONG>4.2b community addition</STRONG><SPAN> and configure it with </SPAN><STRONG>MySql 5.1</STRONG><SPAN> and created database alfresco .</SPAN><BR /><SPAN>In alfresco database there is table </SPAN><STRONG>act_id_user</STRONG><SPAN> , but in it there isn't any entry even if i created 5 users.</SPAN><BR /><SPAN>so please tell me that ,&nbsp; alfresco use another table for storing user data </SPAN><STRONG>or</STRONG><SPAN> it use filesystem to store user data </SPAN><STRONG>or</STRONG><SPAN> any other strategy to store user data.</SPAN></BODY></HTML> Wed, 26 Dec 2012 05:27:40 GMT ankit6190 2012-12-26T05:27:40Z Where alfresco store users data ? https://connect.hyland.com/t5/alfresco-archive/where-alfresco-store-users-data/m-p/262003#M215133 hi,i am using alfresco 4.2b community addition and configure it with MySql 5.1 and created database alfresco .In alfresco database there is table act_id_user , but in it there isn't any entry even if i created 5 users.so please tell me that ,&nbsp; alfresco use another table for storing user data or it u Wed, 26 Dec 2012 05:27:40 GMT https://connect.hyland.com/t5/alfresco-archive/where-alfresco-store-users-data/m-p/262003#M215133 ankit6190 2012-12-26T05:27:40Z Re: Where alfresco store users data ? https://connect.hyland.com/t5/alfresco-archive/where-alfresco-store-users-data/m-p/262004#M215134 <HTML><HEAD></HEAD><BODY><SPAN>I got it ,</SPAN><BR /><SPAN>Alfresco create all the Model as a node,</SPAN><BR /><SPAN>so when u create </SPAN><STRONG> User ,&nbsp; Folder , Document , Image , Space&nbsp; etc… </STRONG><SPAN> then alfresco store these as a node and placed the entry in </SPAN><STRONG>&nbsp; alf_node table </STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>All The properties of node are placed in the </SPAN><STRONG>alf_node_properties table</STRONG><SPAN> . In </SPAN><STRONG>alf_node_properties table</STRONG><SPAN> you will find </SPAN><STRONG> string_value </STRONG><SPAN> and </SPAN><STRONG>qname_id</STRONG><SPAN> columns. The </SPAN><STRONG>qname_id</STRONG><SPAN> define entry in </SPAN><STRONG>alf_qname table</STRONG><SPAN>. By </SPAN><STRONG>qname_id</STRONG><SPAN> you can check that&nbsp; your </SPAN><STRONG>string_value</STRONG><SPAN> belongs to which </SPAN><STRONG>local_name</STRONG><SPAN> .</SPAN></BODY></HTML> Wed, 26 Dec 2012 10:26:58 GMT https://connect.hyland.com/t5/alfresco-archive/where-alfresco-store-users-data/m-p/262004#M215134 ankit6190 2012-12-26T10:26:58Z