1 CREATE SEQUENCE layouts_pk_seq
8 id INTEGER NOT NULL DEFAULT nextval('layouts_pk_seq'::text),
9 name character varying(255) NOT NULL default '',
10 description text NOT NULL,
11 scope char(1) NOT NULL default 'S',
16 -- Contenu de la table 'layouts'
19 INSERT INTO layouts (id, name, description, scope) VALUES
20 (1, '2 columns', 'Simple layout made of 2 columns', 'S');
21 INSERT INTO layouts (id, name, description, scope) VALUES
22 (2, '3 columns', 'Simple layout made of 3 columns', 'S');
23 INSERT INTO layouts (id, name, description, scope) VALUES
24 (3, 'Left', 'Simple layout made of a main column and a small, left sided, column', 'S');
25 INSERT INTO layouts (id, name, description, scope) VALUES
26 (4, 'Right', 'Simple layout made of a main column and a small, right sided, column', 'S');
29 -- Structure de la table 'layouts_contents'
32 CREATE TABLE layouts_contents (
33 owner_id INTEGER NOT NULL default '0',
34 owner_type character varying(1) NOT NULL default 'u',
35 layout_id INTEGER NOT NULL default '0',
36 column_id INTEGER NOT NULL default '0',
37 name character varying(255) NOT NULL default '',
38 rank INTEGER NOT NULL default '0',
39 is_minimized INTEGER NOT NULL default '0',
40 is_removed INTEGER NOT NULL default '0',
41 display_preferences INTEGER NOT NULL default '0',
42 content_id INTEGER NOT NULL default '0'
46 CREATE SEQUENCE layouts_rows_pk_seq
53 -- Structure de la table 'layouts_rows'
56 CREATE TABLE layouts_rows (
57 id INTEGER NOT NULL DEFAULT nextval('layouts_rows_pk_seq'::text),
58 layout_id INTEGER NOT NULL default '0',
59 rank INTEGER NOT NULL default '0',
64 -- Contenu de la table 'layouts_rows'
67 INSERT INTO layouts_rows (id, layout_id, rank) VALUES
69 INSERT INTO layouts_rows (id, layout_id, rank) VALUES
71 INSERT INTO layouts_rows (id, layout_id, rank) VALUES
73 INSERT INTO layouts_rows (id, layout_id, rank) VALUES
76 CREATE SEQUENCE layouts_rows_columns_pk_seq
84 -- Structure de la table 'layouts_rows_columns'
87 CREATE TABLE layouts_rows_columns (
88 id INTEGER NOT NULL DEFAULT nextval('layouts_rows_columns_pk_seq'::text),
89 layout_row_id INTEGER NOT NULL default '0',
90 width INTEGER NOT NULL default '0',
95 -- Contenu de la table 'layouts_rows_columns'
98 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
100 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
102 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
104 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
106 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
108 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
110 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
112 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
114 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
119 -- Structure de la table 'owner_layouts'
122 CREATE TABLE owner_layouts (
123 owner_id INTEGER NOT NULL default '0',
124 owner_type character varying(1) NOT NULL default 'u',
125 layout_id INTEGER NOT NULL default '0',
126 is_default INTEGER NOT NULL default '0',
127 PRIMARY KEY (owner_id,owner_type,layout_id)
130 CREATE SEQUENCE widget_rss_pk_seq
137 --- Widget Rss table ---
138 CREATE TABLE widget_rss (
139 id INTEGER NOT NULL DEFAULT nextval('widget_rss_pk_seq'::text),
140 owner_id INTEGER NOT NULL default '0',
141 owner_type character varying(1) NOT NULL default 'u',
142 title character varying(255) NOT NULL,