Re: [Slashcode-general] safe to delete from submissions table after posting?

[Jamie M. <ja...@mc...>]

sla...@i1... (barry) writes:

> >>I noticed all my stories are still in the submissions table,
> >>even though they have been accepted. Is it safe to delete them
> >>en-masse?

Yes.

> >Are they also in the stories table?
> 
> Yes, and they are also in the newstories table.
>
> I would think that stories first go into submissions, then get
> moved to newstories and stories, then they age out of newstories
> at some point. Does it work differently then that?

Well, 2.2 doesn't have a 'newstories' table any more.  And they
don't get "moved" from submissions to stories, so much as copied;
whatever was in submissions, stays.

Submissions are never actually deleted, just marked so they don't
show up in the bin.  This has proved useful on Slashdot since we
can go in and search for old submissions when the need arises
(though not often enough that we've felt the need to provide a
web-based search).

Delete old submissions when you feel like it :)
--
 Jamie McCarthy
 ja...@mc...