Restoring the partition table is unlikely, overwritten data cannot be recovered.. this is a fact that seems to be disputed often, but it would be cost prohibitive and prone to failure. (It can't be done by specialized software, it would require a hardware solution..)
Now, if you only destroyed the partition table.. the file system would remain and you could recreate it with the same geometry, but if you created a file system.. several super block copies were made throughout the disk.. potentially fragmenting any existing data on the drive.
If you installed anything on the drive, over the existing data... your hope of recovery is slim to none.
Still, software like mentioned above might be able to recover any data that wasn't overwritten.. I hope you recover everything that was important to you, and I'm sure you'll be more cautious in the future. (Like more regular Backups.. paying attention to dmesg output)
I wish you the best of luck...