Home
last modified time | relevance | path

Searched refs:llx_website_page (Results 1 – 25 of 28) sorted by relevance

12

/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/install/mysql/migration/
H A D11.0.0-12.0.0.sql111 UPDATE llx_website_page SET lang = 'en' WHERE lang like 'en_%';
112 UPDATE llx_website_page SET lang = 'fr' WHERE lang like 'fr_%';
113 UPDATE llx_website_page SET lang = 'es' WHERE lang like 'es_%';
114 UPDATE llx_website_page SET lang = 'de' WHERE lang like 'de_%';
115 UPDATE llx_website_page SET lang = 'it' WHERE lang like 'it_%';
116 UPDATE llx_website_page SET lang = 'pt' WHERE lang like 'pt_%';
121 ALTER TABLE llx_website_page ADD COLUMN author_alias varchar(64);
303 …_website_page_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid);
H A D6.0.0-7.0.0.sql95 ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;
96 ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;
232 ALTER TABLE llx_website_page MODIFY COLUMN pageurl varchar(255);
233 ALTER TABLE llx_website_page ADD COLUMN lang varchar(6);
234 ALTER TABLE llx_website_page ADD COLUMN fk_page integer;
235 ALTER TABLE llx_website_page ADD COLUMN grabbed_from varchar(255);
236 ALTER TABLE llx_website_page ADD COLUMN htmlheader mediumtext;
237 ALTER TABLE llx_website_page MODIFY COLUMN htmlheader mediumtext;
239 ALTER TABLE llx_website_page MODIFY COLUMN status INTEGER DEFAULT 1;
240 UPDATE llx_website_page set status = 1 WHERE status IS NULL;
[all …]
H A D5.0.0-6.0.0.sql537 CREATE TABLE llx_website_page table
553 ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);
555 ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERE…
557 ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;
558 ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;
H A D7.0.0-8.0.0.sql46 ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;
47 ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;
48 ALTER TABLE llx_website_page ADD COLUMN type_container varchar(16) NOT NULL DEFAULT 'page';
169 ALTER TABLE llx_website_page ADD COLUMN aliasalt varchar(255) after pageurl;
H A D8.0.0-9.0.0.sql140 ALTER TABLE llx_website_page CHANGE COLUMN fk_user_create fk_user_creat integer;
145 ALTER TABLE llx_website_page ADD COLUMN image varchar(255);
H A D12.0.0-13.0.0.sql414 ALTER TABLE llx_website_page ADD COLUMN allowed_in_frames integer DEFAULT 0;
415 ALTER TABLE llx_website_page ADD COLUMN object_type varchar(255);
416 ALTER TABLE llx_website_page ADD COLUMN fk_object varchar(255);
H A D3.9.0-4.0.0.sql149 CREATE TABLE llx_website_page table
164 ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);
166 ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERE…
H A D4.0.0-5.0.0.sql143 ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;
H A D9.0.0-10.0.0.sql408 UPDATE llx_website_page set fk_user_creat = fk_user_modif WHERE fk_user_creat IS NULL and fk_user_m…
/dports/www/dolibarr/dolibarr-14.0.3/htdocs/install/mysql/migration/
H A D11.0.0-12.0.0.sql111 UPDATE llx_website_page SET lang = 'en' WHERE lang like 'en_%';
112 UPDATE llx_website_page SET lang = 'fr' WHERE lang like 'fr_%';
113 UPDATE llx_website_page SET lang = 'es' WHERE lang like 'es_%';
114 UPDATE llx_website_page SET lang = 'de' WHERE lang like 'de_%';
115 UPDATE llx_website_page SET lang = 'it' WHERE lang like 'it_%';
116 UPDATE llx_website_page SET lang = 'pt' WHERE lang like 'pt_%';
121 ALTER TABLE llx_website_page ADD COLUMN author_alias varchar(64);
303 …_website_page_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid);
H A D6.0.0-7.0.0.sql95 ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;
96 ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;
232 ALTER TABLE llx_website_page MODIFY COLUMN pageurl varchar(255);
233 ALTER TABLE llx_website_page ADD COLUMN lang varchar(6);
234 ALTER TABLE llx_website_page ADD COLUMN fk_page integer;
235 ALTER TABLE llx_website_page ADD COLUMN grabbed_from varchar(255);
236 ALTER TABLE llx_website_page ADD COLUMN htmlheader mediumtext;
237 ALTER TABLE llx_website_page MODIFY COLUMN htmlheader mediumtext;
239 ALTER TABLE llx_website_page MODIFY COLUMN status INTEGER DEFAULT 1;
240 UPDATE llx_website_page set status = 1 WHERE status IS NULL;
[all …]
H A D5.0.0-6.0.0.sql537 CREATE TABLE llx_website_page table
553 ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);
555 ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERE…
557 ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;
558 ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;
H A D7.0.0-8.0.0.sql46 ALTER TABLE llx_website_page ADD COLUMN fk_user_create integer;
47 ALTER TABLE llx_website_page ADD COLUMN fk_user_modif integer;
48 ALTER TABLE llx_website_page ADD COLUMN type_container varchar(16) NOT NULL DEFAULT 'page';
169 ALTER TABLE llx_website_page ADD COLUMN aliasalt varchar(255) after pageurl;
H A D8.0.0-9.0.0.sql140 ALTER TABLE llx_website_page CHANGE COLUMN fk_user_create fk_user_creat integer;
145 ALTER TABLE llx_website_page ADD COLUMN image varchar(255);
H A D12.0.0-13.0.0.sql418 ALTER TABLE llx_website_page ADD COLUMN allowed_in_frames integer DEFAULT 0;
419 ALTER TABLE llx_website_page ADD COLUMN object_type varchar(255);
420 ALTER TABLE llx_website_page ADD COLUMN fk_object varchar(255);
H A D3.9.0-4.0.0.sql149 CREATE TABLE llx_website_page table
164 ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website,pageurl);
166 ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERE…
H A D4.0.0-5.0.0.sql143 ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;
H A D9.0.0-10.0.0.sql408 UPDATE llx_website_page set fk_user_creat = fk_user_modif WHERE fk_user_creat IS NULL and fk_user_m…
/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/install/mysql/tables/
H A Dllx_website_page.key.sql19 ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website, pageurl);
21 ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERE…
H A Dllx_categorie_website_page.key.sql24 …e_websitepage_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid);
H A Dllx_website_page.sql20 CREATE TABLE llx_website_page table
/dports/www/dolibarr/dolibarr-14.0.3/htdocs/install/mysql/tables/
H A Dllx_website_page.key.sql19 ALTER TABLE llx_website_page ADD UNIQUE INDEX uk_website_page_url (fk_website, pageurl);
21 ALTER TABLE llx_website_page ADD CONSTRAINT fk_website_page_website FOREIGN KEY (fk_website) REFERE…
H A Dllx_categorie_website_page.key.sql24 …e_websitepage_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid);
H A Dllx_website_page.sql20 CREATE TABLE llx_website_page table
/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/install/pgsql/functions/
H A Dfunctions.sql189 CREATE TRIGGER update_customer_modtime BEFORE UPDATE ON llx_website_page FOR EACH ROW EXECUTE PROCE…

12