[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[PATCH 2/3] [db] Rename sections table to components (since that's what they are)



---
 db/db.sql |   20 ++++++++++----------
 1 files changed, 10 insertions(+), 10 deletions(-)

diff --git a/db/db.sql b/db/db.sql
index a97944f..a0e5bc9 100644
--- a/db/db.sql
+++ b/db/db.sql
@@ -74,17 +74,17 @@ INSERT INTO distributions (name, priority) VALUES ('stable', 1);
 INSERT INTO distributions (name, priority, depwait, hidden)
 	VALUES ('stable-security', 1, 'f', 't');
 
-CREATE TABLE sections (
+CREATE TABLE components (
 	name text
-	  CONSTRAINT section_name PRIMARY KEY
+	  CONSTRAINT component_name PRIMARY KEY
 );
 
-COMMENT ON TABLE sections IS 'Valid archive sections';
-COMMENT ON COLUMN sections.name IS 'Section name';
+COMMENT ON TABLE components IS 'Valid archive components';
+COMMENT ON COLUMN components.name IS 'Component name';
 
-INSERT INTO sections (name) VALUES ('main');
-INSERT INTO sections (name) VALUES ('contrib');
-INSERT INTO sections (name) VALUES ('non-free');
+INSERT INTO components (name) VALUES ('main');
+INSERT INTO components (name) VALUES ('contrib');
+INSERT INTO components (name) VALUES ('non-free');
 
 CREATE TABLE package_priorities (
 	name text
@@ -155,8 +155,8 @@ CREATE TABLE sources (
 	name text
 	  NOT NULL,
 	version debversion NOT NULL,
-	section_name text
-	  CONSTRAINT source_sect_fkey REFERENCES sections(name)
+	component_name text
+	  CONSTRAINT source_comp_fkey REFERENCES components(name)
 	  ON DELETE CASCADE
 	  NOT NULL,
 	pkg_section_name text
@@ -180,7 +180,7 @@ CREATE INDEX sources_pkg_idx ON sources (name);
 COMMENT ON TABLE sources IS 'Source packages common to all architectures (from Sources)';
 COMMENT ON COLUMN sources.name IS 'Package name';
 COMMENT ON COLUMN sources.version IS 'Package version number';
-COMMENT ON COLUMN sources.section_name IS 'Archive section';
+COMMENT ON COLUMN sources.component_name IS 'Archive component';
 COMMENT ON COLUMN sources.pkg_section_name IS 'Package section';
 COMMENT ON COLUMN sources.pkg_priority_name IS 'Package priority';
 COMMENT ON COLUMN sources.maintainer IS 'Package maintainer name';
-- 
1.6.1.265.ga5b81


Reply to: