search

KamandPrompt / SAC-Portal

SAC Portal for IIT Mandi
2 stars 17 forks source link

Table Creation #8

Closed Signior-X closed 4 years ago

Signior-X commented 4 years ago

I have created a folder Make_Tables which has the code to create tables in the local server. One needs to change the username and password according to their system in the text file in that folder. Also, moved the html file into the templates folder. This code will also give general idea to others, how to add some data into the table also.

Signior-X commented 4 years ago

One has to first edit the mysqlinfo.txt and add there database credentials and then run createdatabase.py file

Signior-X commented 4 years ago

I have created the requirements.txt file and also added the description in README.md file, check the changes

Signior-X commented 4 years ago

I have done the changes as you said, created the .env file and used it using python-dotenv, and also added it in the requirements.txt file. I have added the Foreign key constraints in the Coordies and Registered Table, Also changed the name of the tables. Rest also done, check them.

Signior-X commented 4 years ago

Changed Registered to ClubMembers Added the Events Table Moved .env done rest all, review them

Milind712000 commented 4 years ago

Fixes #6