Sporks-R-Us: Bastard Hybrid Utensil of D00M!
Front Page · Everything · News · Op/Ed · Ask A Spork · Interviews · Religion · Reviews · MLP · AK5CG · Strange · Cats · Nonsense · Fiction · Dead at 54 · The Pits of Hell · Meta · Vlad's Store · Diaries · Site News
Display: Sort:
who the fuck deleted my comment history | 12 comments (12 topical, 0 hidden)
If you can give me (5.00 / 1) (#10)
by Beef on Sun Apr 24, 2005 at 09:28:20 PM GMT

the brand of DB and a complete schema, I might be able to whip something up.  Hopefully it's something simple like some foreign key relationship getting blown away.

I'm not sure how missing indexes would cause this to happen, but if you can also send me the list of what the indexes used to be, restoring those should be a snap.

You hace my email, right?

--
Be conservative in what you do. Be liberal in what you accept from others.
[ Parent ]



Indexes may be the wrong word. (none / 0) (#11)
by Vladinator on Sun Apr 24, 2005 at 10:56:02 PM GMT

It's a MySQL database, and the schema is in the Scoop tarball... I'm not 100% sure what version we're running.

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"
[ Parent ]



when I have a mo' (5.00 / 1) (#12)
by Beef on Mon Apr 25, 2005 at 02:28:08 PM GMT

I've worked with MySQL, and it's documented to death.  I'll look at the scoop schema and take a crack at it.

The comments are still there.  So my first guess is that there's a user-comments table with foreign keys to a user table and to a comments table.  This should be easy to rebuild.  Unless I'm completely and totally wrong, which is entirely possible.

--
Be conservative in what you do. Be liberal in what you accept from others.
[ Parent ]



who the fuck deleted my comment history | 12 comments (12 topical, 0 hidden)
Display: Sort:

Menu
· create account · faq · search · mission · topics

Login
Make a new account
Username:
Password:

SRU - Embrace the Spork! SourceForge Logo Powered by Scoop
Inspiration
The Arkansas legislature passed a law that states that the Arkansas River can rise no higher than to the Main Street bridge in Little Rock.

Please buy the stuff we sell on ebay.
All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest © 2003-2006 The Management

create account | faq | search