[Linpha-cvs] SF.net SVN: linpha: [4454] trunk/linpha2
Status: Inactive
Brought to you by:
bzrudi
From: <fan...@us...> - 2006-03-29 16:52:46
|
Revision: 4454 Author: fangehrn Date: 2006-03-29 08:52:29 -0800 (Wed, 29 Mar 2006) ViewCVS: http://svn.sourceforge.net/linpha/?rev=4454&view=rev Log Message: ----------- * updated installer script, but not yet tested @todo db_data.sql -> sql.data.php Modified Paths: -------------- trunk/linpha2/ChangeLog trunk/linpha2/install/sql/sql.mysql.php trunk/linpha2/install/sql/sql.tables.php Removed Paths: ------------- trunk/linpha2/db_mysql.sql trunk/linpha2/db_pgsql.sql Modified: trunk/linpha2/ChangeLog =================================================================== --- trunk/linpha2/ChangeLog 2006-03-29 16:35:34 UTC (rev 4453) +++ trunk/linpha2/ChangeLog 2006-03-29 16:52:29 UTC (rev 4454) @@ -4,6 +4,8 @@ makes things a lot easier, and looks nice * added ie hack for the menu, all should work now, but it will never look that nice + * updated installer script, but not yet tested + @todo db_data.sql -> sql.data.php 2006-03-26 flo * applying bastian's theme Deleted: trunk/linpha2/db_mysql.sql =================================================================== --- trunk/linpha2/db_mysql.sql 2006-03-29 16:35:34 UTC (rev 4453) +++ trunk/linpha2/db_mysql.sql 2006-03-29 16:52:29 UTC (rev 4454) @@ -1,165 +0,0 @@ --- phpMyAdmin SQL Dump --- version 2.7.0-pl1 --- http://www.phpmyadmin.net --- --- Host: localhost --- Erstellungszeit: 21. Februar 2006 um 21:26 --- Server Version: 4.1.14 --- PHP-Version: 5.0.5-pl5-gentoo --- --- Datenbank: `eclipse` --- - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_config` --- - -use linpha2; - -DROP TABLE IF EXISTS `linpha_config`; -CREATE TABLE `linpha_config` ( - `ID` smallint(5) unsigned NOT NULL auto_increment, - `option_name` varchar(50) NOT NULL default '', - `option_value` varchar(100) NOT NULL default '', - `userid` mediumint(8) unsigned default '0', - PRIMARY KEY (`ID`), - UNIQUE KEY `option_name_2` (`option_name`), - KEY `option_name` (`option_name`), - KEY `option_value` (`option_value`) -); - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_groups` --- - -DROP TABLE IF EXISTS `linpha_groups`; -CREATE TABLE `linpha_groups` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(100) NOT NULL default '', - PRIMARY KEY (`id`) -); - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_permissions` --- - -DROP TABLE IF EXISTS `linpha_permissions`; -CREATE TABLE `linpha_permissions` ( - `id` int(11) NOT NULL auto_increment, - `photos_id` int(11) NOT NULL default '0', - `perm_type` varchar(255) NOT NULL default '0', - `permission` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`) -); - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_photos` --- - -DROP TABLE IF EXISTS `linpha_photos`; -CREATE TABLE `linpha_photos` ( - `id` int(11) NOT NULL auto_increment, - `parent_id` int(11) NOT NULL default '0', - `img_type` int(11) NOT NULL default '0', - `name` text NOT NULL, - `md5sum` varchar(40) NOT NULL default '', - `time_add` int(11) NOT NULL default '0', - `time_mod` int(11) NOT NULL default '0', - `time_exif` int(11) NOT NULL default '0', - `stats_numbers` int(11) NOT NULL default '0', - `stats_views` int(11) NOT NULL default '0', - `stats_downloads` int(11) NOT NULL default '0', - PRIMARY KEY (`id`) -); - - -DROP TABLE IF EXISTS `linpha_meta_fields`; -CREATE TABLE IF NOT EXISTS linpha_meta_fields ( - id int(11) NOT NULL auto_increment, - name varchar(255) NOT NULL default '', - field_type int(11) NOT NULL default '0', - flags int(11) NOT NULL default '0', - PRIMARY KEY (id) -); - - -DROP TABLE IF EXISTS `linpha_meta_category`; -CREATE TABLE linpha_meta_category ( - id int(11) NOT NULL auto_increment, - field_id int(11) NOT NULL default '0', - name varchar(255) NOT NULL default '', - isprivate int(11) default NULL, - PRIMARY KEY (id) -); - --- --- Tabellenstruktur f?r Tabelle `linpha_meta_exif` --- - -DROP TABLE IF EXISTS linpha_meta_exif; -CREATE TABLE IF NOT EXISTS linpha_meta_exif ( - md5sum varchar(32) NOT NULL default '', - datetimeoriginal varchar(255) default NULL, - make varchar(255) default NULL, - model varchar(255) default NULL, - artist varchar(255) default NULL, - copyright varchar(255) default NULL, - aperturevalue varchar(255) default NULL, - shutterspeedvalue varchar(255) default NULL, - exposuretime varchar(255) default NULL, - isospeedratings varchar(255) default NULL, - flash varchar(255) default NULL, - focallength varchar(255) default NULL, - fnumber varchar(255) default NULL, - PRIMARY KEY (md5sum), - KEY md5sum (md5sum) -); - --- --- Tabellenstruktur f?r Tabelle `linpha_meta_iptc` --- - -DROP TABLE IF EXISTS linpha_meta_iptc; -CREATE TABLE IF NOT EXISTS linpha_meta_iptc ( - md5sum varchar(32) NOT NULL default '', - PRIMARY KEY (md5sum), - KEY md5sum (md5sum) -); - - - --- --- Tabellenstruktur f?r Tabelle `linpha_meta_comments` --- - -DROP TABLE IF EXISTS linpha_meta_comments; -CREATE TABLE IF NOT EXISTS linpha_meta_comments ( - id int(11) NOT NULL auto_increment, - `time` int(11) NOT NULL default '0', - md5sum varchar(32) NOT NULL default '', - author varchar(255) NOT NULL default '', - `comment` text NOT NULL, - PRIMARY KEY (id) -); - - --- --- Tabellenstruktur f?r Tabelle `linpha_meta_data` --- - -DROP TABLE IF EXISTS linpha_meta_data; -CREATE TABLE IF NOT EXISTS linpha_meta_data ( - id int(11) NOT NULL auto_increment, - field_id int(11) NOT NULL default '0', - md5sum varchar(32) NOT NULL default '', - meta_data varchar(255) NOT NULL default '', - PRIMARY KEY (id) -); \ No newline at end of file Deleted: trunk/linpha2/db_pgsql.sql =================================================================== --- trunk/linpha2/db_pgsql.sql 2006-03-29 16:35:34 UTC (rev 4453) +++ trunk/linpha2/db_pgsql.sql 2006-03-29 16:52:29 UTC (rev 4454) @@ -1,79 +0,0 @@ --- phpMyAdmin SQL Dump --- version 2.7.0-pl1 --- http://www.phpmyadmin.net --- --- Host: localhost --- Erstellungszeit: 21. Februar 2006 um 21:28 --- Server Version: 4.1.14 --- PHP-Version: 5.0.5-pl5-gentoo --- --- Datenbank: `eclipse` --- - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_config` --- - -DROP TABLE IF EXISTS `linpha_config`; -CREATE TABLE "linpha_config" ( - "ID" smallint(5) unsigned NOT NULL, - "option_name" varchar(50) NOT NULL default '', - "option_value" varchar(100) NOT NULL default '', - "userid" mediumint(8) unsigned default '0', - PRIMARY KEY ("ID"), - UNIQUE KEY "option_name_2" ("option_name"), - KEY "option_name" ("option_name"), - KEY "option_value" ("option_value") -); - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_groups` --- - -DROP TABLE IF EXISTS `linpha_groups`; -CREATE TABLE "linpha_groups" ( - "id" int(11) NOT NULL, - "name" varchar(100) NOT NULL default '', - PRIMARY KEY ("id") -); - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_permissions` --- - -DROP TABLE IF EXISTS `linpha_permissions`; -CREATE TABLE "linpha_permissions" ( - "id" int(11) NOT NULL, - "photos_id" int(11) NOT NULL default '0', - "perm_type" varchar(255) NOT NULL default '0', - "permission" varchar(255) NOT NULL default '', - PRIMARY KEY ("id") -); - --- -------------------------------------------------------- - --- --- Tabellenstruktur f?r Tabelle `linpha_photos` --- - -DROP TABLE IF EXISTS `linpha_photos`; -CREATE TABLE "linpha_photos" ( - "id" int(11) NOT NULL, - "parent_id" int(11) NOT NULL default '0', - "img_type" int(11) NOT NULL default '0', - "name" text NOT NULL, - "md5sum" varchar(40) NOT NULL default '', - "time_add" int(11) NOT NULL default '0', - "time_mod" int(11) NOT NULL default '0', - "time_exif" int(11) NOT NULL default '0', - "stats_numbers" int(11) NOT NULL default '0', - "stats_views" int(11) NOT NULL default '0', - "stats_downloads" int(11) NOT NULL default '0', - PRIMARY KEY ("id") -); Modified: trunk/linpha2/install/sql/sql.mysql.php =================================================================== --- trunk/linpha2/install/sql/sql.mysql.php 2006-03-29 16:35:34 UTC (rev 4453) +++ trunk/linpha2/install/sql/sql.mysql.php 2006-03-29 16:52:29 UTC (rev 4454) @@ -23,231 +23,91 @@ $sql_tables = array( "CREATE TABLE ".$linpha_tables['config']." ( ". - "ID smallint unsigned not null auto_increment, ". - "option_name varchar(50) not null, ". - "option_value varchar(100) not null, ". - "userid mediumint unsigned default 0, ". - "PRIMARY KEY(ID), ". - "KEY(option_name), ". - "KEY(option_value), ". - "UNIQUE(option_name) ". + "`id` smallint(5) unsigned NOT NULL auto_increment, " . + "`option_name` varchar(50) NOT NULL default '', " . + "`option_value` varchar(100) NOT NULL default '', " . + "`userid` mediumint(8) unsigned default '0', " . + "PRIMARY KEY (`id`), " . + "UNIQUE KEY `option_name_2` (`option_name`), " . + "KEY `option_name` (`option_name`), " . + "KEY `option_value` (`option_value`) " . ")", - - "CREATE TABLE ".$linpha_tables['users']." ( ". - "ID mediumint unsigned not null auto_increment, ". - "nickname varchar(20) not null, ". - "password varchar(32) not null, ". - "email varchar(255), ". - "lang varchar(100) default 'English', ". - "level tinyint unsigned, ". - "groups varchar(255), ". - "fullname varchar(50), ". - "PRIMARY KEY(ID) ". - ")", - - "CREATE TABLE ".$linpha_tables['first_lev_album']." ( ". - "ID smallint unsigned not null auto_increment, ". - "date timestamp, ". - "path varchar(255) not null, ". - "name varchar(255) not null, ". - "level tinyint unsigned, ". - "groups varchar(255) DEFAULT ';public;', ". - "photos SMALLINT, ". - "PRIMARY KEY(ID) ". - ")", - - "CREATE TABLE ".$linpha_tables['sec_lev_album']." ( " . - "ID smallint unsigned not null auto_increment, ". - "date timestamp, ". - "path varchar(255) not null, ". - "name varchar(255) not null, ". - "prev_alb_name varchar(255) not null, ". - "level tinyint unsigned, ". - "res varchar(64), ". - "res1 varchar(64), ". - "PRIMARY KEY(ID), ". - "KEY (prev_alb_name) ". - ")", - - "CREATE TABLE ".$linpha_tables['third_lev_album']." ( ". - "ID smallint unsigned not null auto_increment, ". - "date timestamp, ". - "path varchar(255) not null, ". - "name varchar(255) not null, ". - "prev_alb_name varchar(255) not null, ". - "level tinyint unsigned, ". - "res varchar(64), ". - "res1 varchar(64), ". - "PRIMARY KEY(ID), ". - "KEY (prev_alb_name) ". - ")", - - "CREATE TABLE ".$linpha_tables['photos']." ( " . - "ID int unsigned not null auto_increment, ". - "date timestamp, ". - "name varchar(255), ". - "filename varchar(255) not null, ". - "thumbnail mediumblob, ". - "prev_path varchar(255), ". - "level tinyint unsigned, ". - "res INT(5) DEFAULT 0 NOT NULL, ". - "md5sum varchar(40), ". - "downloads mediumint, ". - "fmkey_location varchar(100), ". - "fmkey_type varchar(100), ". - "fmkey_date varchar(100), ". - "PRIMARY KEY(ID), ". - "KEY (date), ". - "KEY (name), ". - "KEY (filename), ". - "KEY (res), ". - "KEY (md5sum), ". - "KEY (prev_path) ". - ")", - - "CREATE TABLE ".$linpha_tables['photo_cache']." ( ". - "filename VARCHAR(255) NOT NULL, ". - "photo_id INT UNSIGNED NOT NULL, ". - "date DATETIME NOT NULL, ". - "used TIMESTAMP, ". - "hits MEDIUMINT UNSIGNED DEFAULT '0' NOT NULL, ". - "size INT UNSIGNED DEFAULT '0' NOT NULL, ". - "convert_time FLOAT DEFAULT '0.0' NOT NULL, ". - "PRIMARY KEY (filename), ". - "KEY (filename) ". - ")", - - "CREATE TABLE ".$linpha_tables['category']." ( " . - "ID smallint unsigned not null auto_increment, ". - "name varchar(255) not null, ". - "isprivate SMALLINT(1), ". - "PRIMARY KEY(ID) ". - ")", - - "CREATE TABLE ".$linpha_tables['counter_stats']." ( ". - "ID int unsigned not null auto_increment, ". - "date timestamp, ". - "ip varchar(32), ". - "res mediumint unsigned, ". - "PRIMARY KEY(ID) ". - ")", - "CREATE TABLE ".$linpha_tables['groups']." ( ". - "ID SMALLINT(3) NOT NULL AUTO_INCREMENT, ". - "groups VARCHAR(15) NOT NULL, ". - "res VARCHAR(20) NOT NULL, ". - "PRIMARY KEY ( ID ) ". + "`id` int(11) NOT NULL auto_increment, " . + "`name` varchar(100) NOT NULL default '', " . + "PRIMARY KEY (`id`) " . ")", - - "CREATE TABLE ".$linpha_tables['image_comments']." ( ". - "ID INT NOT NULL AUTO_INCREMENT, ". - "date TIMESTAMP, ". - "md5sum VARCHAR(40), ". - "author VARCHAR(20), ". - "comment TEXT, ". - "description VARCHAR(255), ". - "category VARCHAR(255), ". - "PRIMARY KEY ( ID ), ". - "KEY (md5sum) ". + "CREATE TABLE ".$linpha_tables['permissions']." ( ". + "`id` int(11) NOT NULL auto_increment, " . + "`photos_id` int(11) NOT NULL default '0', " . + "`perm_type` varchar(255) NOT NULL default '0', " . + "`permission` varchar(255) NOT NULL default '', " . + "PRIMARY KEY (`id`) " . ")", - - "CREATE TABLE ".$linpha_tables['album_comments']." ( ". - "ID INT NOT NULL AUTO_INCREMENT, ". - "date TIMESTAMP, ". - "album VARCHAR(255), ". - "author VARCHAR(20), ". - "comment TEXT, ". - "PRIMARY KEY (ID) ". + "CREATE TABLE ".$linpha_tables['photos']." ( ". + "`id` int(11) NOT NULL auto_increment, " . + "`parent_id` int(11) NOT NULL default '0', " . + "`img_type` int(11) NOT NULL default '0', " . + "`name` text NOT NULL, " . + "`md5sum` varchar(40) NOT NULL default '', " . + "`time_add` int(11) NOT NULL default '0', " . + "`time_mod` int(11) NOT NULL default '0', " . + "`time_exif` int(11) NOT NULL default '0', " . + "`stats_numbers` int(11) NOT NULL default '0', " . + "`stats_views` int(11) NOT NULL default '0', " . + "`stats_downloads` int(11) NOT NULL default '0', " . + "PRIMARY KEY (`id`) " . ")", - - "CREATE TABLE ".$linpha_tables['plugins']." ( ". - "ID INT NOT NULL AUTO_INCREMENT, ". - "name VARCHAR(255), ". - "active SMALLINT(1) DEFAULT '0' NOT NULL, ". - "PRIMARY KEY ( ID ) ". + "CREATE TABLE ".$linpha_tables['meta_fields']." ( ". + "id int(11) NOT NULL auto_increment, " . + "name varchar(255) NOT NULL default '', " . + "field_type int(11) NOT NULL default '0', " . + "flags int(11) NOT NULL default '0', " . + "PRIMARY KEY (id) " . ")", - - "CREATE TABLE ".$linpha_tables['guestbook']." ( ". - "id INT (5) UNSIGNED not null AUTO_INCREMENT, ". - "name VARCHAR (50), ". - "email VARCHAR (50), ". - "country VARCHAR (50), ". - "url VARCHAR (150), ". - "comment TEXT not null, ". - "date INT (11), ". - "PRIMARY KEY (id) ". + "CREATE TABLE ".$linpha_tables['meta_category']." ( ". + "id int(11) NOT NULL auto_increment, " . + "field_id int(11) NOT NULL default '0', " . + "name varchar(255) NOT NULL default '', " . + "isprivate int(11) default NULL, " . + "PRIMARY KEY (id) " . ")", - - "CREATE TABLE ".$linpha_tables['mail_list']." ( ". - "ID int(25) NOT NULL auto_increment, ". - "name varchar(100) NOT NULL default '', ". - "email varchar(100) NOT NULL default '', ". - "date int(14) NOT NULL default '0', ". - "active tinyint(1) NOT NULL default '0', ". - "PRIMARY KEY (ID) ". + "CREATE TABLE ".$linpha_tables['meta_exif']." ( ". + "md5sum varchar(32) NOT NULL default '', " . + "datetimeoriginal varchar(255) default NULL, " . + "make varchar(255) default NULL, " . + "model varchar(255) default NULL, " . + "artist varchar(255) default NULL, " . + "copyright varchar(255) default NULL, " . + "aperturevalue varchar(255) default NULL, " . + "shutterspeedvalue varchar(255) default NULL, " . + "exposuretime varchar(255) default NULL, " . + "isospeedratings varchar(255) default NULL, " . + "flash varchar(255) default NULL, " . + "focallength varchar(255) default NULL, " . + "fnumber varchar(255) default NULL, " . + "PRIMARY KEY (md5sum), " . + "KEY md5sum (md5sum) " . ")", - - "CREATE TABLE ".$linpha_tables['permissions']." (". - "id int(11) NOT NULL auto_increment, ". - "type varchar(255) NOT NULL, ". - "who int(1) NOT NULL default '0', ". - "groups_exceptions varchar(255) NOT NULL default '', ". - "groups_additional varchar(255) NOT NULL default '', ". - "and_or int(1) NOT NULL default '0', ". - "alb int(1) NOT NULL default '0', ". - "albums text NOT NULL, ". - "PRIMARY KEY (id) ". - ")", - "CREATE TABLE ".$linpha_tables['meta_iptc']." ( ". - "md5sum VARCHAR(32) NOT NULL, ". - - // caption fields - "caption VARCHAR(255) NOT NULL, ". - "caption_writer VARCHAR(255) NOT NULL, ". - "headline VARCHAR(255) NOT NULL, ". - "instructions VARCHAR(255) NOT NULL, ". - - // keywords fields - "keywords VARCHAR(255) NOT NULL, ". - - // categories fields - "category VARCHAR(3) NOT NULL, ". - "supplemental_categorie VARCHAR(255) NOT NULL, ". - - //credits fields - "copyright VARCHAR(255) NOT NULL, ". - "byline VARCHAR(255) NOT NULL, " . - "byline_title VARCHAR(255) NOT NULL, ". - "credit VARCHAR(255) NOT NULL, ". - "source VARCHAR(255) NOT NULL, ". - - //status fields - "edit_status VARCHAR(255) NOT NULL, ". - "priority VARCHAR(255) NOT NULL, ". - "object_cycle VARCHAR(255) NOT NULL, ". - "job_id VARCHAR(255) NOT NULL, ". - "program VARCHAR(255) NOT NULL, ". - - // origin fields - "object_name VARCHAR(255) NOT NULL, ". - "date_created VARCHAR(255) NOT NULL, " . - "date_released VARCHAR(255) NOT NULL, ". - "time_created VARCHAR(255) NOT NULL, ". - "time_released VARCHAR(255) NOT NULL, ". - "city VARCHAR(255) NOT NULL, ". - "sublocation VARCHAR(255) NOT NULL, ". - "state VARCHAR(255) NOT NULL, ". - "country VARCHAR(255) NOT NULL, ". - "country_code VARCHAR(5) NOT NULL, ". - "trans_reference VARCHAR(255) NOT NULL, ". - "marked_ignored INT(1), ". - "PRIMARY KEY (md5sum) ". - ")", - - "CREATE TABLE ".$linpha_tables['blacklist']." ( ". - "action VARCHAR(20), ". - "value TEXT". + "md5sum varchar(32) NOT NULL default '', " . + "PRIMARY KEY (md5sum), " . + "KEY md5sum (md5sum) " . + ")", + "CREATE TABLE ".$linpha_tables['meta_comments']." ( ". + "id int(11) NOT NULL auto_increment, " . + "`time` int(11) NOT NULL default '0', " . + "md5sum varchar(32) NOT NULL default '', " . + "author varchar(255) NOT NULL default '', " . + "`comment` text NOT NULL, " . + " PRIMARY KEY (id) " . + ")", + "CREATE TABLE ".$linpha_tables['meta_data']." ( ". + "id int(11) NOT NULL auto_increment, " . + "field_id int(11) NOT NULL default '0', " . + "md5sum varchar(32) NOT NULL default '', " . + "meta_data varchar(255) NOT NULL default '', " . + "PRIMARY KEY (id) " . ")" ); Modified: trunk/linpha2/install/sql/sql.tables.php =================================================================== --- trunk/linpha2/install/sql/sql.tables.php 2006-03-29 16:35:34 UTC (rev 4453) +++ trunk/linpha2/install/sql/sql.tables.php 2006-03-29 16:52:29 UTC (rev 4454) @@ -23,6 +23,19 @@ $linpha_tables = Array( "config" => "config", + "groups" => "groups", + "permissions" => "permissions", + "photos" => "photos", + "meta_fields" => "meta_fields", + "meta_category" => "meta_category", + "meta_exif" => "meta_exif", + "meta_iptc" => "meta_iptc", + "meta_comments" => "meta_data" +); + +/* +$linpha_tables = Array( + "config" => "config", "users" => "users", "first_lev_album" => "first_lev_album", "sec_lev_album" => "sec_lev_album", @@ -41,6 +54,6 @@ "permissions" => "permissions", "blacklist" => "blacklist", "meta_exif" => "meta_exif" -); +);*/ ?> \ No newline at end of file This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |