| 1 |
3 |
ahitrov@rambler.ru |
create sequence documents_id_seq; |
| 2 |
|
|
select setval('documents_id_seq', 101, true); |
| 3 |
|
|
|
| 4 |
|
|
create table documents |
| 5 |
|
|
( |
| 6 |
|
|
id integer not null primary key default nextval('public.documents_id_seq'::text), |
| 7 |
|
|
class text not null, |
| 8 |
|
|
ctime timestamp not null default now(), |
| 9 |
|
|
mtime timestamp not null default now(), |
| 10 |
|
|
dtime timestamp not null default now(), |
| 11 |
|
|
status smallint not null default 0, |
| 12 |
|
|
sections integer[], |
| 13 |
|
|
name text, |
| 14 |
|
|
data text |
| 15 |
|
|
); |
| 16 |
|
|
create index documents_sections on documents using gist ( "sections" "gist__int_ops" ); |
| 17 |
|
|
create index documents_dtime on documents (dtime); |
| 18 |
|
|
|
| 19 |
|
|
|
| 20 |
|
|
create table sections |
| 21 |
|
|
( |
| 22 |
|
|
id integer not null primary key default nextval('public.documents_id_seq'::text), |
| 23 |
|
|
pid integer, |
| 24 |
|
|
class text not null, |
| 25 |
|
|
ctime timestamp not null default now(), |
| 26 |
|
|
mtime timestamp not null default now(), |
| 27 |
|
|
status smallint not null default 0, |
| 28 |
|
|
sorder integer default 1, |
| 29 |
|
|
name text, |
| 30 |
|
|
alias text, |
| 31 |
|
|
data text |
| 32 |
|
|
); |
| 33 |
|
|
create index sections_parent on sections (pid); |
| 34 |
|
|
create index sections_alias_pid on sections (alias, pid); |
| 35 |
|
|
insert into sections (id, status, sorder, class, name) values (1, 1, 1, 'Contenido::Section', '�������� ������'); |
| 36 |
|
|
|
| 37 |
|
|
|
| 38 |
|
|
create table links |
| 39 |
|
|
( |
| 40 |
|
|
id integer not null primary key default nextval('public.documents_id_seq'::text), |
| 41 |
|
|
class text not null, |
| 42 |
|
|
ctime timestamp not null default now(), |
| 43 |
|
|
mtime timestamp not null default now(), |
| 44 |
|
|
status smallint not null default 1, |
| 45 |
|
|
source_id integer not null, |
| 46 |
|
|
source_class text not null, |
| 47 |
|
|
dest_id integer not null, |
| 48 |
|
|
dest_class text not null, |
| 49 |
|
|
data text |
| 50 |
|
|
); |
| 51 |
|
|
create index links_source on links (source_id); |
| 52 |
|
|
create index links_dest on links (dest_id); |
| 53 |
|
|
|
| 54 |
|
|
create table users |
| 55 |
|
|
( |
| 56 |
|
|
id integer not null primary key default nextval('public.documents_id_seq'::text), |
| 57 |
|
|
login text not null, |
| 58 |
|
|
class text not null, |
| 59 |
|
|
ctime timestamp not null default now(), |
| 60 |
|
|
mtime timestamp not null default now(), |
| 61 |
|
|
status smallint not null default 1, |
| 62 |
|
|
name text, |
| 63 |
|
|
passwd text not null, |
| 64 |
|
|
groups integer[], |
| 65 |
|
|
data text |
| 66 |
|
|
); |
| 67 |
|
|
create unique index users_login on users(login); |
| 68 |
|
|
|
| 69 |
|
|
create table options ( |
| 70 |
|
|
id integer not null primary key default nextval('public.documents_id_seq'::text), |
| 71 |
|
|
pid integer, |
| 72 |
|
|
name text, |
| 73 |
|
|
value text, |
| 74 |
|
|
"type" text not null |
| 75 |
|
|
); |
| 76 |
|
|
|
| 77 |
|
|
insert into options values (1, NULL, 's_alias', NULL, 'HASH'); |
| 78 |
|
|
insert into options values (2, NULL, 'widths', NULL, 'HASH'); |
| 79 |
|
|
insert into options values (3, NULL, 'redirects', NULL, 'HASH'); |
| 80 |
|
|
insert into options values (4, NULL, 'users', NULL, 'HASH'); |
| 81 |
|
|
insert into options values (5, 4, 'Contenido::User::DefaultUser', NULL, 'HASH'); |
| 82 |
|
|
insert into options values (6, NULL, 'links', NULL, 'HASH'); |
| 83 |
|
|
insert into options values (7, 6, 'Contenido::Link::DefaultLink', NULL, 'HASH'); |
| 84 |
|
|
insert into options values (8, NULL, 'sections', NULL, 'HASH'); |
| 85 |
|
|
insert into options values (9, 8, 'Contenido::Section::DefaultSection', NULL, 'HASH'); |
| 86 |
|
|
insert into options values (10, NULL, 'colors', NULL, 'HASH'); |
| 87 |
|
|
insert into options values (11, NULL, 'tabs', NULL, 'HASH'); |
| 88 |
|
|
insert into options values (12, 11, 'admin', NULL, 'HASH'); |
| 89 |
|
|
insert into options values (13, 12, 'id', 'admin', 'SCALAR'); |
| 90 |
|
|
insert into options values (14, 12, 'sections', NULL, 'ARRAY'); |
| 91 |
|
|
insert into options values (15, 14, '0', 'Contenido::Section::DefaultSection', 'SCALAR'); |
| 92 |
|
|
insert into options values (16, 12, 'lefts', NULL, 'ARRAY'); |
| 93 |
|
|
insert into options values (17, 16, '0', 'structure', 'SCALAR'); |
| 94 |
|
|
insert into options values (18, 16, '1', 'project', 'SCALAR'); |
| 95 |
|
|
insert into options values (19, 12, 'name', '�����������������', 'SCALAR'); |
| 96 |
|
|
insert into options values (20, 11, 'rubricator', NULL, 'HASH'); |
| 97 |
|
|
insert into options values (21, 20, 'id', 'rubricator', 'SCALAR'); |
| 98 |
|
|
insert into options values (22, 20, 'sections', NULL, 'ARRAY'); |
| 99 |
|
|
insert into options values (23, 22, '0', 'Contenido::Section::DefaultSection', 'SCALAR'); |
| 100 |
|
|
insert into options values (24, 20, 'lefts', NULL, 'ARRAY'); |
| 101 |
|
|
insert into options values (25, 24, '0', 'finder', 'SCALAR'); |
| 102 |
|
|
insert into options values (26, 20, 'name', '������������ ����������', 'SCALAR'); |
| 103 |
|
|
insert into options values (27, NULL, 'documents', NULL, 'HASH'); |
| 104 |
|
|
insert into options values (28, 27, 'Contenido::Document::DefaultDocument', NULL, 'HASH'); |
RSS Feed