Setting up Database

Thanks for your interest in this project! This forum is for general discussions and questions regarding the SmarterApp project and source code. An overview of the entire system can be found find in the Architecture Document, available here: http://www.smarterapp.org/documents/Sma ... 112014.pdf and more general information here: http://www.smarterapp.org.
Forum rules
SmarterApp Forum Rules

Rule No. 1 - Flaming, Bashing, and Trolling
Hate posts and personal attacks will not be tolerated on Template Shares. Treat others on these message boards as you would expect them to treat you. Posting topics specifically designed to provoke a negative response from someone (aka trolling) is also asked to be avoided. There are however some posts that will cause debates that may offend you. If you are easily offended by discussions about race, religion, and other highly opinionated topics we suggest you stay out of those topics.
Rule No. 2 - No 'Spamming'
Purposely spamming a message board with senseless, vacuous, or empty messages to gain a higher post count, or just to annoy others is HIGHLY frowned upon! Commercial spamming and advertising are just as unwelcome, double posting is allowed to an extent. Many users use 'Threaded Mode' and it is allowed to double post if posting to two different replies.
Rule No. 3 - Impersonating Other Users / Accessing Another User('s) Account
You may not impersonate another board member or create an account specifically for the purpose of provoking other users. Also, accessing or using someone else's account or attempting to access another poster's account is strictly prohibited. You will be banned.
Rule No. 4 - Piracy, and Warez
Absolutely no warez. Linking or giving information about any site that distributes illegal software, or warez, seeking help to circumvent any copyright laws, or encouraging software or media piracy is grounds for an immediate ban.
Rule No. 5 - Nudity/****
Please remember that this board is a 'PUBLIC' forum. There are 12 year olds here just as there are 50 year olds. Nudity and **** is prohibited for obvious reasons.
Rule No. 6 - Copyrighted Material
Template Shares users agree not to post any material that is protected by copyright, trademark or other proprietary right without the express permission of the owner(s) of said copyright, trademark or other proprietary right.
Rule No. 7 - Report Button
Please note that the report button was made for reporting bad posts only. Please do not abuse this button to get attention to your thread/other threads, or try to get faster support.
Rule No. 8 - Requesting Support
Before asking for support ensure that you read the sticky topics placed throughout the forums. Chances are your query will be anwsered and will save staff and members time in anwsering repeated questions.
Rule no. 9 - This forum is seen by younger individuals; please do not post pictures with BAD WORDS written on them because the word filter will miss this.
Rule no. 10 - This is an English speaking forum, please type your post in English. If you don't speak English, please check our International Forums.
Post Reply
sijusamuel
Posts: 15
Joined: Thu Oct 23, 2014 3:43 pm

Setting up Database

Post by sijusamuel » Thu Oct 23, 2014 9:08 pm

There are many data base scripts and programs specific to creating database and tables ( example tds_dll_schemas) . Would like to have some input on this in the general, how to do developer settings? whether to create it programtically or by manually runing scripts..etc.

User avatar
ramilevy
Posts: 160
Joined: Thu Jun 27, 2013 1:07 am

Re: Setting up Database

Post by ramilevy » Thu Oct 23, 2014 10:06 pm

Hello Siju,

In general, applications requiring databases include scripts and/or schemas in the source repositories. Additionally, you should find instructions on how to run/implement those in the project's README file or other documentation.

Regards,
Rami

johnniewalk
Posts: 1
Joined: Wed Nov 23, 2016 2:03 pm
Contact:

Re: Setting up Database

Post by johnniewalk » Fri Nov 25, 2016 11:14 am

I don't much about the database and its setting, so i just suggest you to go through the following link it helps. https://hedgehogdevelopment.github.io/tds/chapter4.html

RosieKay
Posts: 2
Joined: Wed Jan 04, 2017 6:33 am

Re: Setting up Database

Post by RosieKay » Wed Jan 04, 2017 6:37 am

Where’s the execution of the sql query?! It’s missing! And when you do commands like insert, or update from outside, you must double check it. MBA Essay Writing Service

jamesmoliver
Posts: 1
Joined: Mon Apr 03, 2017 1:19 pm

Re: Setting up Database

Post by jamesmoliver » Mon Apr 03, 2017 1:39 pm

this is example i think work for you


mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

graciemilligan
Posts: 1
Joined: Wed May 17, 2017 6:40 am
Location: UK
Contact:

Re: Setting up Database

Post by graciemilligan » Wed May 17, 2017 6:47 am

Thank you for your information, I don't know more about database, but I have intereset to understand more about it.

Post Reply