Changeset 8651 for trunk/install
- Timestamp:
- Jan 13, 2011, 4:24:18 PM (13 years ago)
- Location:
- trunk/install
- Files:
-
- 1 added
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/config.sql
r8626 r8651 27 27 INSERT INTO piwigo_config (param,value,comment) VALUES ('email_admin_on_comment','false','Send an email to the administrators when a valid comment is entered'); 28 28 INSERT INTO piwigo_config (param,value,comment) VALUES ('email_admin_on_comment_validation','false','Send an email to the administrators when a comment requires validation'); 29 INSERT INTO piwigo_config (param,value,comment) VALUES ('email_admin_on_picture_uploaded','false','Send an email to the administrators when a picture is uploaded');30 29 INSERT INTO piwigo_config (param,value,comment) VALUES ('obligatory_user_mail_address','false','Mail address is obligatory for users'); 31 30 INSERT INTO piwigo_config (param,value,comment) VALUES ('c13y_ignore',null,'List of ignored anomalies'); 32 INSERT INTO piwigo_config (param,value,comment) VALUES ('upload_link_everytime','false','Show upload link every time');33 INSERT INTO piwigo_config (param,value,comment) VALUES ('upload_user_access',2 /*ACCESS_CLASSIC*/,'User access level to upload');34 31 INSERT INTO piwigo_config (param,value,comment) VALUES ('extents_for_templates','a:0:{}','Actived template-extension(s)'); 35 32 INSERT INTO piwigo_config (param,value,comment) VALUES ('blk_menubar','','Menubar options'); -
trunk/install/piwigo_structure-mysql.sql
r8464 r8651 31 31 `site_id` tinyint(4) unsigned default '1', 32 32 `visible` enum('true','false') NOT NULL default 'true', 33 `uploadable` enum('true','false') NOT NULL default 'false',34 33 `representative_picture_id` mediumint(8) unsigned default NULL, 35 34 `uppercats` varchar(255) NOT NULL default '', … … 447 446 UNIQUE KEY `users_ui1` (`username`) 448 447 ) TYPE=MyISAM; 449 450 --451 -- Table structure for table `piwigo_waiting`452 --453 454 DROP TABLE IF EXISTS `piwigo_waiting`;455 CREATE TABLE `piwigo_waiting` (456 `id` int(10) unsigned NOT NULL auto_increment,457 `storage_category_id` smallint(5) unsigned NOT NULL default '0',458 `file` varchar(255) NOT NULL default '',459 `username` varchar(255) NOT NULL default '',460 `mail_address` varchar(255) NOT NULL default '',461 `date` int(10) unsigned NOT NULL default '0',462 `tn_ext` char(3) default NULL,463 `validated` enum('true','false') NOT NULL default 'false',464 `infos` text,465 PRIMARY KEY (`id`)466 ) TYPE=MyISAM; -
trunk/install/piwigo_structure-pdo-sqlite.sql
r8464 r8651 27 27 "site_id" INTEGER default 1, 28 28 "visible" BOOLEAN default true, 29 "uploadable" BOOLEAN default false,30 29 "representative_picture_id" INTEGER, 31 30 "uppercats" TEXT, … … 538 537 CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id"); 539 538 540 -----------------------------------------------------------------------------541 -- piwigo_waiting542 -----------------------------------------------------------------------------543 544 DROP TABLE IF EXISTS piwigo_waiting;545 CREATE TABLE piwigo_waiting546 (547 "id" INTEGER NOT NULL,548 "storage_category_id" INTEGER default 0 NOT NULL,549 "file" VARCHAR(255) default '' NOT NULL,550 "username" VARCHAR(255) default '' NOT NULL,551 "mail_address" VARCHAR(255) default '' NOT NULL,552 "date" INTEGER default 0 NOT NULL,553 "tn_ext" CHAR(3),554 "validated" BOOLEAN default false,555 "infos" TEXT,556 PRIMARY KEY ("id")557 );558 -
trunk/install/piwigo_structure-pgsql.sql
r8464 r8651 34 34 "site_id" INTEGER default 1, 35 35 "visible" BOOLEAN default true, 36 "uploadable" BOOLEAN default false,37 36 "representative_picture_id" INTEGER, 38 37 "uppercats" TEXT, … … 653 652 654 653 CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id"); 655 656 -----------------------------------------------------------------------------657 -- piwigo_waiting658 -----------------------------------------------------------------------------659 660 DROP TABLE IF EXISTS "piwigo_waiting" CASCADE;661 CREATE TABLE "piwigo_waiting"662 (663 "id" serial NOT NULL,664 "storage_category_id" INTEGER default 0 NOT NULL,665 "file" VARCHAR(255) default '' NOT NULL,666 "username" VARCHAR(255) default '' NOT NULL,667 "mail_address" VARCHAR(255) default '' NOT NULL,668 "date" INTEGER default 0 NOT NULL,669 "tn_ext" CHAR(3),670 "validated" BOOLEAN default false,671 "infos" TEXT,672 PRIMARY KEY ("id")673 );674 675 COMMENT ON TABLE "piwigo_waiting" IS '';676 677 678 SET search_path TO public; -
trunk/install/piwigo_structure-sqlite.sql
r8464 r8651 27 27 "site_id" INTEGER default 1, 28 28 "visible" BOOLEAN default true, 29 "uploadable" BOOLEAN default false,30 29 "representative_picture_id" INTEGER, 31 30 "uppercats" TEXT, … … 537 536 CREATE INDEX "comments_i2" ON "piwigo_comments" ("validation_date"); 538 537 CREATE INDEX "comments_i1" ON "piwigo_comments" ("image_id"); 539 540 -----------------------------------------------------------------------------541 -- piwigo_waiting542 -----------------------------------------------------------------------------543 544 DROP TABLE IF EXISTS piwigo_waiting;545 CREATE TABLE piwigo_waiting546 (547 "id" INTEGER NOT NULL,548 "storage_category_id" INTEGER default 0 NOT NULL,549 "file" VARCHAR(255) default '' NOT NULL,550 "username" VARCHAR(255) default '' NOT NULL,551 "mail_address" VARCHAR(255) default '' NOT NULL,552 "date" INTEGER default 0 NOT NULL,553 "tn_ext" CHAR(3),554 "validated" BOOLEAN default false,555 "infos" TEXT,556 PRIMARY KEY ("id")557 );558
Note: See TracChangeset
for help on using the changeset viewer.