Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database file #3

Open
TechRaY opened this issue Mar 20, 2018 · 3 comments
Open

Database file #3

TechRaY opened this issue Mar 20, 2018 · 3 comments

Comments

@TechRaY
Copy link

TechRaY commented Mar 20, 2018

I guess that the sql file is not the updated one. It only includes the request_raised table. Plz provide the complete one. And the login credentials for the same.

Thank you.

Nice project.

@prabhakar267
Copy link
Collaborator

@TechRaY could you mention what's missing from SQL file, as it has been a long time since we updated the project. Searching for correct sql file would be tiresome
We (@sahildua2305 ) could definitely help you make a new compatible SQL file

@TechRaY
Copy link
Author

TechRaY commented Mar 20, 2018

Actually the sql file which is there in the repo contains only 1 table(raised_requests). While looking at the files it requires other tables too. Plz test it once and try to give the better one. Do give the login credentials as your hashing it and storing it in your database.

@prabhakar267
Copy link
Collaborator

Other tables apart from raised_requests in the project are requests , messages and users. Fields in

  • users table: (id , username,password,name)
  • messages table: (message_id, sender_id,reciever_id,message, timestamp)
  • requests table: (item,defination, last_updated_tx)

These were the fields I am able to find from a quick look at the project code, probably you can start with these and we can incrementally add new fields if necessary

For login credentials, you can set your own MySQL credentials and use that username, password and database name in a new file named inc/connection.inc.php (sample file) to access your MySQL database

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants