|
Revision 1356, 0.5 kB
(checked in by rho, 1 year ago)
|
added postgres schema provided by Misja
|
| Line | |
|---|
| 1 |
CREATE TABLE prefix_pages ( |
|---|
| 2 |
ident SERIAL PRIMARY KEY, |
|---|
| 3 |
name varchar(128) NOT NULL default '', |
|---|
| 4 |
uri varchar(128) NOT NULL default '', |
|---|
| 5 |
parent integer NOT NULL default '0', |
|---|
| 6 |
weight integer NOT NULL default '0', |
|---|
| 7 |
title varchar(128) NOT NULL default '', |
|---|
| 8 |
content text NOT NULL default '', |
|---|
| 9 |
owner integer NOT NULL default '-1', |
|---|
| 10 |
access varchar(20) NOT NULL default 'PUBLIC' |
|---|
| 11 |
); |
|---|
| 12 |
|
|---|
| 13 |
CREATE INDEX prefix_pages_parent_idx ON prefix_pages (parent,owner); |
|---|
| 14 |
CREATE UNIQUE INDEX prefix_pages_pk ON prefix_pages(name,uri,owner); |
|---|
