/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/install/mysql/migration/ |
H A D | 11.0.0-12.0.0.sql | 111 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 D | 6.0.0-7.0.0.sql | 95 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 D | 5.0.0-6.0.0.sql | 537 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 D | 7.0.0-8.0.0.sql | 46 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 D | 8.0.0-9.0.0.sql | 140 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 D | 12.0.0-13.0.0.sql | 414 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 D | 3.9.0-4.0.0.sql | 149 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 D | 4.0.0-5.0.0.sql | 143 ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;
|
H A D | 9.0.0-10.0.0.sql | 408 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 D | 11.0.0-12.0.0.sql | 111 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 D | 6.0.0-7.0.0.sql | 95 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 D | 5.0.0-6.0.0.sql | 537 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 D | 7.0.0-8.0.0.sql | 46 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 D | 8.0.0-9.0.0.sql | 140 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 D | 12.0.0-13.0.0.sql | 418 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 D | 3.9.0-4.0.0.sql | 149 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 D | 4.0.0-5.0.0.sql | 143 ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;
|
H A D | 9.0.0-10.0.0.sql | 408 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 D | llx_website_page.key.sql | 19 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 D | llx_categorie_website_page.key.sql | 24 …e_websitepage_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid);
|
H A D | llx_website_page.sql | 20 CREATE TABLE llx_website_page table
|
/dports/www/dolibarr/dolibarr-14.0.3/htdocs/install/mysql/tables/ |
H A D | llx_website_page.key.sql | 19 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 D | llx_categorie_website_page.key.sql | 24 …e_websitepage_website_page_rowid FOREIGN KEY (fk_website_page) REFERENCES llx_website_page (rowid);
|
H A D | llx_website_page.sql | 20 CREATE TABLE llx_website_page table
|
/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/install/pgsql/functions/ |
H A D | functions.sql | 189 CREATE TRIGGER update_customer_modtime BEFORE UPDATE ON llx_website_page FOR EACH ROW EXECUTE PROCE…
|