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 (2, '3 columns', 'Simple layout made of 3 columns', 'S'),
22 (3, 'Left', 'Simple layout made of a main column and a small, left sided, column', 'S'),
23 (4, 'Right', 'Simple layout made of a main column and a small, right sided, column', 'S');
26 -- Structure de la table 'layouts_contents'
29 CREATE TABLE layouts_contents (
30 owner_id INTEGER NOT NULL default '0',
31 owner_type character varying(1) NOT NULL default 'u',
32 layout_id INTEGER NOT NULL default '0',
33 column_id INTEGER NOT NULL default '0',
34 name character varying(255) NOT NULL default '',
35 rank INTEGER NOT NULL default '0',
36 is_minimized INTEGER NOT NULL default '0',
37 is_removed INTEGER NOT NULL default '0',
38 display_preferences INTEGER NOT NULL default '0',
39 content_id INTEGER NOT NULL default '0'
43 CREATE SEQUENCE layouts_rows_pk_seq
50 -- Structure de la table 'layouts_rows'
53 CREATE TABLE layouts_rows (
54 id INTEGER NOT NULL DEFAULT nextval('layouts_rows_pk_seq'::text),
55 layout_id INTEGER NOT NULL default '0',
56 rank INTEGER NOT NULL default '0',
61 -- Contenu de la table 'layouts_rows'
64 INSERT INTO layouts_rows (id, layout_id, rank) VALUES
70 CREATE SEQUENCE layouts_rows_columns_pk_seq
78 -- Structure de la table 'layouts_rows_columns'
81 CREATE TABLE layouts_rows_columns (
82 id INTEGER NOT NULL DEFAULT nextval('layouts_rows_columns_pk_seq'::text),
83 layout_row_id INTEGER NOT NULL default '0',
84 width INTEGER NOT NULL default '0',
89 -- Contenu de la table 'layouts_rows_columns'
92 INSERT INTO layouts_rows_columns (id, layout_row_id, width) VALUES
105 -- Structure de la table 'owner_layouts'
108 CREATE TABLE owner_layouts (
109 owner_id INTEGER NOT NULL default '0',
110 owner_type character varying(1) NOT NULL default 'u',
111 layout_id INTEGER NOT NULL default '0',
112 is_default INTEGER NOT NULL default '0',
113 PRIMARY KEY (owner_id,owner_type,layout_id)
116 CREATE SEQUENCE widget_rss_pk_seq
123 --- Widget Rss table ---
124 CREATE TABLE widget_rss (
125 id INTEGER NOT NULL DEFAULT nextval('widget_rss_pk_seq'::text),
126 owner_id INTEGER NOT NULL default '0',
127 owner_type character varying(1) NOT NULL default 'u',
128 title character varying(255) NOT NULL,