php artisan migratemake add_mycolumn_to_mytable A new migration file will be created. Add the code that updates the schema (http://laravel.com/docs/5.1/migrations#modifying-columns). Schema::table(‘mytable’, function($table) { $table->integer(‘mycolumn’); } The following command will update db schema. php artisan migrate
webmin on debian
http://www.webmin.com/deb.html nano /etc/apt/sources.list add the following: deb http://download.webmin.com/download/repository sarge contrib deb http://webmin.mirror.somersettechsolutions.co.uk/repository sarge contrib save-exit Fetch and install webmin GPG key with which the repository is signed, with the commands : cd /root wget http://www.webmin.com/jcameron-key.asc apt-key add jcameron-key.asc install webmin apt-get update apt-get install webmin Wait for webmin to install – depending on your hardware,… Continue reading webmin on debian
linux: find all files of a particular size
Copied from: http://www.ducea.com/2008/02/12/linux-tips-find-all-files-of-a-particular-size/ The Unix find command is a very powerful tool, and this short post is intended to show how easy you can achieve something that might look complicate: to find all the files of a particular size. Let’s assume you are searching for all the files of exactly 6579 bytes size inside the home… Continue reading linux: find all files of a particular size
install iwatch on debian
http://iwatch.sourceforge.net/documentation.html iWatch is a realtime filesystem monitoring program. Its purpose is to monitor any changes in a specific directory or file and send email notification immediately after the change. This can be very useful to watch a sensible file or directory against any changes, like files /etc/passwd,/etc/shadow or directory /bin or to monitor the root… Continue reading install iwatch on debian
wget without checking certificate
–no-check-certificate Don’t check the server certificate against the available certificate authorities. Also don’t require the URL host name to match the common name presented by the certificate. As of Wget 1.10, the default is to verify the server’s certificate against the recognized certificate authorities, breaking the SSL handshake and aborting the download if the verification… Continue reading wget without checking certificate
ispconfig 3, debian, php.ini upload_max_filesize=20M
creating a file .user.ini in the web/ folder (should be found automatically) which contains upload_max_filesize=20M service apache2 restart https://www.howtoforge.com/community/threads/upload_max_filesize-unchangeable.56787/
move one directory up
cp -rf . .. rm -rf *
sql server, find foreign keys associated with given primary key
If you work with an unknown schema and try to investigate the relationships between primary and foreign keys, there is a great answer on stackoverflow originally posted by db2. SELECT o1.name AS FK_table, c1.name AS FK_column, fk.name AS FK_name, o2.name AS PK_table, c2.name AS PK_column, pk.name AS PK_name, fk.delete_referential_action_desc AS Delete_Action, fk.update_referential_action_desc AS Update_Action FROM… Continue reading sql server, find foreign keys associated with given primary key
embedding ftp client in your android app
Open your favorite IDE for android development and create a new project. Unless you choose to implement RFC 959 on your own, include a good ftp client library like this one http://commons.apache.org/proper/commons-net/download_net.cgi If you already know how to include a jar in your android project, skip the following bullets. For android studio fans: copy-paste jar to libs folder of your project,… Continue reading embedding ftp client in your android app