Author: vip Date: Fri Dec 28 23:27:50 2007 New Revision: 9167 Added: packages.php/database.sql Log: - database structure
Added: packages.php/database.sql ============================================================================== --- (empty file) +++ packages.php/database.sql Fri Dec 28 23:27:50 2007 @@ -0,0 +1,52 @@ +CREATE TABLE IF NOT EXISTS `arch` ( + `arch_id` smallint(6) NOT NULL AUTO_INCREMENT, + `name` varchar(100) NOT NULL, + PRIMARY KEY (`arch_id`) +) ENGINE=InnoDB DEFAULT; + +CREATE TABLE IF NOT EXISTS `description` ( + `name` varchar(100) NOT NULL, + `summary` varchar(255) NOT NULL, + `url` varchar(255) NOT NULL, + `description` text NOT NULL, + PRIMARY KEY (`name`) +) ENGINE=InnoDB DEFAULT; + +CREATE TABLE IF NOT EXISTS `dist` ( + `dist_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(20) NOT NULL, + PRIMARY KEY (`dist_id`) +) ENGINE=InnoDB DEFAULT; + +CREATE TABLE IF NOT EXISTS `file` ( + `package_id` varchar(50) NOT NULL, + `filepath` text NOT NULL, + KEY `package_id` (`package_id`) +) ENGINE=InnoDB DEFAULT; + +CREATE TABLE IF NOT EXISTS `module` ( + `module_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `dist_id` smallint(5) unsigned NOT NULL, + `arch_id` smallint(5) unsigned NOT NULL, + `name` varchar(20) NOT NULL, + `url` text NOT NULL, + PRIMARY KEY (`module_id`) +) ENGINE=InnoDB DEFAULT; + +CREATE TABLE IF NOT EXISTS `package` ( + `package_id` varchar(50) NOT NULL, + `name` varchar(100) NOT NULL, + `module_id` smallint(5) unsigned NOT NULL, + `epoch` smallint(5) unsigned NOT NULL, + `version` varchar(50) NOT NULL, + `release` varchar(50) NOT NULL, + `file_time` datetime NOT NULL, + `build_time` datetime NOT NULL, + `package_size` int(10) unsigned NOT NULL, + `installed_size` int(10) unsigned NOT NULL, + `archive_size` int(10) unsigned NOT NULL, + PRIMARY KEY (`package_id`) +) ENGINE=InnoDB DEFAULT; + +ALTER TABLE `file` + ADD CONSTRAINT `file_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `package` (`package_id`) ON DELETE CASCADE; _______________________________________________ pld-cvs-commit mailing list [email protected] http://lists.pld-linux.org/mailman/listinfo/pld-cvs-commit
