[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Fresh database schema
- To: uu@total-knowledge.com
- Subject: Fresh database schema
- From: "Alexey Parshin" <alexeyp@gmail.com>
- Date: Fri, 16 Feb 2007 17:17:06 +1100
- Delivered-to: mailing list uu@total-knowledge.com
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=IET/nELpwE6rN5DTkSs7ogrg01y1uJsSJ0bFW43KqVQ2/69eqQzT9j6BcSR8WCRO57061ozzLuog6Rqe3YX17FTvnXjIsTi6citzQsGcVU/2SCTIHm9IkQb50sw24FOs6xWMMa7eJrGABKboMG+8swHWWikKozK2iWng634/h8A=
- Mailing-list: contact uu-help@total-knowledge.com; run by ezmlm
Folks,
The attached is the latest version of the database schema script.
Please, be careful:
This script
destroys the existing
uu database and creates a new one.
It creates all the tables, applies extra FKs and indices, and creates stored procedures.
It also adds default records for the tables with id = 1 and empty content. This approach allows to avoid outer joins and still be able to show empty records.
--
Alexey Parshin,
http://www.sptk.net
Attachment:
uu_db.schema
Description: Binary data