Thread: [Isocial-svn] SF.net SVN: isocial: [247] app/installers/groupapp/group_installer.php
Status: Pre-Alpha
Brought to you by:
aguidrevitch
Menu
▾
▴
isocial-svn
|
From: <di...@us...> - 2008-06-24 16:27:15
|
Revision: 247
http://isocial.svn.sourceforge.net/isocial/?rev=247&view=rev
Author: dim0s77
Date: 2008-06-24 09:27:00 -0700 (Tue, 24 Jun 2008)
Log Message:
-----------
Added subgroups
Modified Paths:
--------------
app/installers/groupapp/group_installer.php
Modified: app/installers/groupapp/group_installer.php
===================================================================
--- app/installers/groupapp/group_installer.php 2008-06-24 14:58:01 UTC (rev 246)
+++ app/installers/groupapp/group_installer.php 2008-06-24 16:27:00 UTC (rev 247)
@@ -24,6 +24,166 @@
$this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (10, 0, 'Sports & Recreation')");
$this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (11, 0, 'Student Group')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (101, 1, 'Companies')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (102, 1, 'Consumer Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (103, 1, 'Employment & Work')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (104, 1, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (105, 1, 'Home Business')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (106, 1, 'Investing')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (107, 1, 'Marketing & Advertising')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (108, 1, 'Public Relations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (109, 1, 'Real Estate')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (201, 2, 'Activities')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (202, 2, 'Age')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (203, 2, 'Beauty')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (204, 2, 'Beliefs & Causes')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (205, 2, 'Current Events')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (206, 2, 'Dating & Relationships')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (207, 2, 'Families')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (208, 2, 'Food & Drink')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (209, 2, 'Friends')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (210, 2, 'Gardening')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (211, 2, 'Health & Wellness')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (212, 2, 'History')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (213, 2, 'Hobbies & Crafts')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (214, 2, 'Languages')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (215, 2, 'Pets & Animals')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (216, 2, 'Philosophy')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (217, 2, 'Politics')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (218, 2, 'Religion & Spirituality')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (219, 2, 'Science')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (220, 2, 'Self-help')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (221, 2, 'Sexuality')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (222, 2, 'Travel')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (223, 2, 'Wine')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (301, 3, 'Books & Literature')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (302, 3, 'Celebrities')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (303, 3, 'Comics & Animation')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (304, 3, 'Dance')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (305, 3, 'Fashion')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (306, 3, 'Fine Arts')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (307, 3, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (308, 3, 'Humor')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (309, 3, 'Movies')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (310, 3, 'Nightlife')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (311, 3, 'Online Media')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (312, 3, 'Performing Arts')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (313, 3, 'Radio')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (314, 3, 'Television')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (315, 3, 'Theater')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (401, 4, 'Cities')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (402, 4, 'Countries')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (403, 4, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (404, 4, 'Neighborhoods')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (405, 4, 'Places')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (406, 4, 'Regions')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (407, 4, 'Ridesharing & Transportation')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (408, 4, 'States')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (501, 5, 'Computers & Hardware')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (502, 5, 'Cyberculture')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (503, 5, 'Gadgets')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (504, 5, 'Gaming')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (505, 5, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (506, 5, 'Languages & Formats')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (507, 5, 'Mobile')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (508, 5, 'Multimedia')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (509, 5, 'News')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (510, 5, 'Software')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (511, 5, 'Websites')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (601, 6, 'PROJECT_NAME Classics')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (602, 6, 'Fan Clubs')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (603, 6, 'Inside Jokes')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (604, 6, 'Outlandish Statements')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (605, 6, 'Too Much Information')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (606, 6, 'Totally Pointless')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (607, 6, 'Totally Random')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (701, 7, 'Blues')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (702, 7, 'Classical')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (703, 7, 'Country')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (704, 7, 'Dance')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (705, 7, 'Electronic')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (706, 7, 'Folk')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (707, 7, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (708, 7, 'Indie')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (709, 7, 'Instruments')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (710, 7, 'International')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (711, 7, 'Jazz')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (712, 7, 'Latin')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (713, 7, 'Live Music')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (714, 7, 'Metal')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (715, 7, 'R&B & Soul')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (716, 7, 'Rap & Hip Hop')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (717, 7, 'Reggae')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (718, 7, 'Religious')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (719, 7, 'Rock')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (720, 7, 'Songwriting')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (801, 8, 'Academic Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (802, 8, 'Advocacy Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (803, 8, 'Clubs & Societies')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (804, 8, 'Community Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (805, 8, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (806, 8, 'Non-Profit Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (807, 8, 'Philanthropic Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (808, 8, 'Political Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (809, 8, 'Professional Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (810, 8, 'Religious Organizations')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (811, 8, 'Volunteer Organizations')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (901, 9, 'Sponsored')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1001, 10, 'Automotive & Racing')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1002, 10, 'Cheerleading')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1003, 10, 'College Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1004, 10, 'Dance')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1005, 10, 'Extreme Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1006, 10, 'Fantasy Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1007, 10, 'Fitness & Exercise')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1008, 10, 'Gambling')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1009, 10, 'Games')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1010, 10, 'General Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1011, 10, 'High School Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1012, 10, 'International Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1013, 10, 'Intramural Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1014, 10, 'Martial Arts')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1015, 10, 'Olympic Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1016, 10, 'Outdoor Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1017, 10, 'Professional Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1018, 10, 'Recreational Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1019, 10, 'Sports Leagues')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1020, 10, 'Water Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1021, 10, 'Weightlifting & Bodybuilding')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1022, 10, 'Winter Sports')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1023, 10, 'Yoga')");
+
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1101, 11, 'Abroad/Overseas Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1102, 11, 'Academic Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1103, 11, 'Advising Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1104, 11, 'Alumni Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1105, 11, 'Classes & Departments')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1106, 11, 'Clubs & Societies')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1107, 11, 'Community Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1108, 11, 'Creative Arts Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1109, 11, 'Dorms & Residences')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1110, 11, 'Ethnic/Cultural Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1111, 11, 'Fraternities & Sororities')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1112, 11, 'General')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1113, 11, 'Media/Publication Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1114, 11, 'Musical Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1115, 11, 'Political Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1116, 11, 'Pre-Professional Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1117, 11, 'Religious Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1118, 11, 'Service Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1119, 11, 'Social Groups')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1120, 11, 'Student Government')");
+ $this->execute("INSERT INTO `groupapp_group_types` (id, parent_id, en_name) VALUES (1121, 11, 'Study Groups')");
+
$this->execute(
"CREATE TABLE `groupapp_groups` (
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
Thanks for helping keep SourceForge clean.
X