Vonderkell: Salle: The difference of them, it’s that User will view a website, and Employee will view a dashboard, where on it, Employee can see User’s informations

Clyatt: Brunoalano: What users see has little to do with how data is stored and in what tables

Zehnpfennig: Salle: In pratice, the User will have only a signup form. The Employee will see what User has inserted on that

Clyatt: Brunoalano: End users should not know about tables and what is store in which table

Revils: Salle: Sure, User won’t know

Brancaccio: Salle: The problem in this design, it’s that I can’t merge them, because both have different and essential relationships. Employee has Roles. User has username slug.

Clyatt: Brunoalano: Roles belong to another table

Gazo: Employee belongs to Role

Clyatt: Brunoalano: Single role?

Spach: Salle: No, sorry, it’s a habtm relation has and belongs to many

Clyatt: Brunoalano: You have several ways to store such data. If users and employees share lot of common data name, email, address, phone etc. you can put that in separate table like Person

Stockard: Salle: Yeah, I’ve created a “Account” table with email, p***word, reset_p***word_token, .

Clyatt: Brunoalano: Ok Account.

Pettigrove: Salle: But I don’t know if this is the best pratice, since they share the same area in the application

Clyatt: Brunoalano: “area in the applictation”?

Segar: Salle: User’s will see a single page website, like a CMS. Employee will see a Dashboard, with some metrics, CRUD operations

Clyatt: Brunoalano: No matter how you store the data in the database it is client application task to separate users from employees

Clyatt: Brunoalano: pseudo codeIF the account is User show him user_page.html ELSEIF account is Employee show him employee_page.html ELSE show error /pseudocode

Clyatt: Brunoalano: It does not matter if the employees and users are stored together or not

Bucheli: Salle: But it’s a good pratice to store both type of Account’s in the same table?

Levine: Brunoalano: Could it be that the account type is a “property” of Persons? “How do you define your database’s entities”-ish style of thinking.

Batarse: Slartibart : https://unsee.cc/zepomibu/

Clyatt: Brunoalano: Once again no matter if you store both types of accounts together or not it is application responcibility to separate them

Clyatt: Brunoalano: You can store common information together and spread the type-specific information to multiple other tables, but in any case it is up to the application to distinct between them and provide different interface to different type of accounts

Lopas: Just trying to move my datadir and feel like i am missing somthign simple. Googled the hell out of it but have done all found recommended steps. chmod -R 777 MYSQL/ ; chown -R mysql:mysql MYSQL/ but no go. wont allow me to su to mysql for sake of x11 auth. copied all of /var/lib/mysql with cp -rp from var/lib/mysql.

Kaliher: I am missing something simple i am sure.

Coriaty: I opened it up just to try

Flournay: Others changed user to root but now ay.

Kachiroubas: Left all other conf in place and works fineerror log is 13 of course which is perms.

Nicarry: Moving datadir reference back to /var/lib/mysql works of course.

Wieto: Is there any issue with mdadm for mysql? perticularly RAID5? and, is there any other permissions outside of general linux mysql requires?

Merryweather: Know am being dumb, how?

Clyatt: Musawshe: apparmor or selinux depending on your distro

Clyatt: Musawshe: Well . perror 13 is always about “permissions denied” so you have to find out what it is

Braun: How many fields is too many fields?

Longin: I think i need about 90

Wolper: Decoux: funny i was just reading about that

Sundholm: Decoux: i dont have situation like employee and department though. i have stat table. id, stat1, stat2, stat3, stat4, . stat 90