From 3ff03dc4f0a72432b34c00da620272cf011e4ddd Mon Sep 17 00:00:00 2001 From: Yuchen Pei Date: Thu, 29 Jul 2021 14:17:20 +1000 Subject: Publishing h-node.org code. - this is the h-node.org code, except - removed a js file (3x copies at three different locations) without license / copyright headers - /Js/linkToForm.js - /Public/Js/linkToForm.js - /admin/Public/Js/linkToForm.js - removed config files containing credentials - /Application/Include/params.php - /Config/Config.php - /admin/Application/Include/params.php - /admin/Config/Config.php - added license and copyright header to one php file - /admin/Library/ErrorReporting.php (almost identical to /Library/ErrorReporting.php which has the headers) --- h-source/tables.sql | 616 ---------------------------------------------------- 1 file changed, 616 deletions(-) delete mode 100644 h-source/tables.sql (limited to 'h-source/tables.sql') diff --git a/h-source/tables.sql b/h-source/tables.sql deleted file mode 100644 index 6b06a28..0000000 --- a/h-source/tables.sql +++ /dev/null @@ -1,616 +0,0 @@ --- h-source, a web software to build a community of people that want to share their hardware information. --- Copyright (C) 2010 Antonio Gallo (h-source-copyright.txt) --- --- This file is part of h-source --- --- h-source is free software: you can redistribute it and/or modify --- it under the terms of the GNU General Public License as published by --- the Free Software Foundation, either version 3 of the License, or --- (at your option) any later version. --- --- h-source is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with h-source. If not, see . - - -SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; - - --- -------------------------------------------------------- - --- --- Table structure for table `accesses` --- - -CREATE TABLE IF NOT EXISTS `accesses` ( - `id` int(12) NOT NULL AUTO_INCREMENT, - `ip` char(20) NOT NULL, - `data` char(10) NOT NULL, - `ora` char(8) NOT NULL, - `username` varchar(30) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `admingroups` --- - -CREATE TABLE IF NOT EXISTS `admingroups` ( - `id_group` int(10) unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - PRIMARY KEY (`id_group`), - UNIQUE KEY `name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `adminsessions` --- - -CREATE TABLE IF NOT EXISTS `adminsessions` ( - `uid` char(32) NOT NULL, - `token` char(32) NOT NULL, - `id_user` int(10) unsigned NOT NULL, - `creation_date` int(10) unsigned NOT NULL, - `user_agent` char(32) NOT NULL, - KEY `uid` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `adminusers` --- - -CREATE TABLE IF NOT EXISTS `adminusers` ( - `id_user` int(10) unsigned NOT NULL AUTO_INCREMENT, - `username` varchar(80) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `password` char(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `last_failure` int(10) unsigned NOT NULL, - `has_confirmed` int(10) unsigned NOT NULL, - PRIMARY KEY (`id_user`), - UNIQUE KEY `username` (`username`), - KEY `username_2` (`username`,`password`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `adminusers_groups` --- - -CREATE TABLE IF NOT EXISTS `adminusers_groups` ( - `id_user` int(11) unsigned NOT NULL, - `id_group` int(11) unsigned NOT NULL, - UNIQUE KEY `id_group` (`id_group`,`id_user`), - KEY `group_indx` (`id_group`), - KEY `user_indx` (`id_user`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `boxes` --- - -CREATE TABLE IF NOT EXISTS `boxes` ( - `id_box` int(11) NOT NULL AUTO_INCREMENT, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `title` varchar(150) NOT NULL, - `message` text NOT NULL, - PRIMARY KEY (`id_box`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `deletion` --- - -CREATE TABLE IF NOT EXISTS `deletion` ( - `id_del` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `object` char(15) NOT NULL, - `message` text NOT NULL, - `id_hard` int(10) unsigned NOT NULL, - `id_duplicate` int(10) unsigned NOT NULL, - PRIMARY KEY (`id_del`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `hardware` --- - -CREATE TABLE IF NOT EXISTS `hardware` ( - `id_hard` int(10) unsigned NOT NULL AUTO_INCREMENT, - `type` varchar(50) NOT NULL, - `kernel` varchar(100) NOT NULL, - `vendor` varchar(50) NOT NULL, - `model` varchar(200) NOT NULL, - `created_by` int(11) NOT NULL, - `updated_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `update_date` datetime NOT NULL, - `compatibility` char(15) NOT NULL, - `description` text NOT NULL, - `distribution` varchar(300) NOT NULL, - `video_card_type` varchar(100) NOT NULL, - `video_card_works` varchar(30) NOT NULL, - `wifi_type` varchar(100) NOT NULL, - `wifi_works` varchar(30) NOT NULL, - `comm_year` char(15) NOT NULL, - `ask_for_del` char(4) NOT NULL DEFAULT 'no', - `deleted` char(4) NOT NULL DEFAULT 'no', - `pci_id` char(10) NOT NULL, - `subtype` char(25) NOT NULL, - `driver` varchar(50) NOT NULL, - `interface` char(15) NOT NULL DEFAULT 'not-specified', - `bios` char(20) NOT NULL DEFAULT 'not-specified', - `webcam_type` varchar(100) NOT NULL, - `webcam_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `sound_card_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `bluetooth_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `fingerprint_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `architecture` char(15) NOT NULL DEFAULT 'not-specified', - `other_names` text NOT NULL, - `approved` char(4) NOT NULL DEFAULT 'yes', - `cleared` char(3) NOT NULL DEFAULT 'no', - `ethernet_card_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `sd_card_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `can_free_systems_be_installed` varchar(30) NOT NULL DEFAULT 'not-specified', - `it_tracks_users` varchar(30) NOT NULL DEFAULT 'not-specified', - `prevent_wifi` char(20) NOT NULL DEFAULT 'not-specified', - PRIMARY KEY (`id_hard`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `hardware_users` --- - -CREATE TABLE IF NOT EXISTS `hardware_users` ( - `id_user` int(11) unsigned NOT NULL, - `id_hard` int(11) unsigned NOT NULL, - UNIQUE KEY `id_user` (`id_user`,`id_hard`), - KEY `hard_indx` (`id_hard`), - KEY `user_indx` (`id_user`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `history` --- - -CREATE TABLE IF NOT EXISTS `history` ( - `id_history` int(11) NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `type` char(15) NOT NULL, - `action` char(15) NOT NULL, - `id` int(10) unsigned NOT NULL, - `message` text NOT NULL, - `gr` char(15) NOT NULL, - PRIMARY KEY (`id_history`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; - --- -------------------------------------------------------- - --- --- Table structure for table `issues` --- - -CREATE TABLE IF NOT EXISTS `issues` ( - `id_issue` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `update_date` datetime NOT NULL, - `topic` char(35) NOT NULL, - `title` varchar(100) NOT NULL, - `message` text NOT NULL, - `priority` char(15) NOT NULL, - `status` char(15) NOT NULL, - `notice` text NOT NULL, - `deleted` char(4) NOT NULL DEFAULT 'no', - PRIMARY KEY (`id_issue`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `messages` --- - -CREATE TABLE IF NOT EXISTS `messages` ( - `id_mes` int(11) NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `message` text NOT NULL, - `id_issue` int(10) unsigned NOT NULL, - `deleted` char(4) NOT NULL DEFAULT 'no', - `has_read` char(4) NOT NULL DEFAULT 'no', - PRIMARY KEY (`id_mes`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `news` --- - -CREATE TABLE IF NOT EXISTS `news` ( - `id_news` int(10) unsigned NOT NULL AUTO_INCREMENT, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `title` varchar(150) NOT NULL, - `message` text NOT NULL, - PRIMARY KEY (`id_news`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `params` --- - -CREATE TABLE IF NOT EXISTS `params` ( - `id_par` int(10) unsigned NOT NULL AUTO_INCREMENT, - `updating` char(4) NOT NULL DEFAULT 'no', - `boxes_xml` text NOT NULL, - PRIMARY KEY (`id_par`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ; - -insert into params (updating) values ('no'); - --- -------------------------------------------------------- - --- --- Table structure for table `profile` --- - -CREATE TABLE IF NOT EXISTS `profile` ( - `id_prof` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `update_date` datetime NOT NULL, - `real_name` varchar(100) NOT NULL, - `where_you_are` varchar(100) NOT NULL, - `birth_date` varchar(100) NOT NULL, - `fav_distro` varchar(100) NOT NULL, - `projects` text NOT NULL, - `publish_mail` char(4) NOT NULL DEFAULT 'no', - `description` text NOT NULL, - `website` varchar(100) NOT NULL, - `send_notification` char(4) NOT NULL DEFAULT 'yes', - PRIMARY KEY (`id_prof`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `regaccesses` --- - -CREATE TABLE IF NOT EXISTS `regaccesses` ( - `id` int(12) NOT NULL AUTO_INCREMENT, - `ip` char(20) NOT NULL, - `data` char(10) NOT NULL, - `ora` char(8) NOT NULL, - `username` varchar(30) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; - --- -------------------------------------------------------- - --- --- Table structure for table `reggroups` --- - -CREATE TABLE IF NOT EXISTS `reggroups` ( - `id_group` int(10) unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - PRIMARY KEY (`id_group`), - UNIQUE KEY `name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ; - --- -------------------------------------------------------- - --- --- Table structure for table `regsessions` --- - -CREATE TABLE IF NOT EXISTS `regsessions` ( - `uid` char(32) NOT NULL, - `token` char(32) NOT NULL, - `id_user` int(10) unsigned NOT NULL, - `creation_date` int(10) unsigned NOT NULL, - `user_agent` char(32) NOT NULL, - KEY `uid` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `regusers` --- - -CREATE TABLE IF NOT EXISTS `regusers` ( - `id_user` int(10) unsigned NOT NULL AUTO_INCREMENT, - `username` varchar(80) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `password` char(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `last_failure` int(10) unsigned NOT NULL, - `has_confirmed` int(10) unsigned NOT NULL, - `e_mail` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `confirmation_token` char(32) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `creation_time` int(10) unsigned NOT NULL, - `temp_field` char(32) NOT NULL, - `deleted` char(4) NOT NULL DEFAULT 'no', - `forgot_token` char(32) NOT NULL, - `forgot_time` int(10) unsigned NOT NULL, - `blocked` char(4) NOT NULL DEFAULT 'no', - PRIMARY KEY (`id_user`), - UNIQUE KEY `username` (`username`), - KEY `username_2` (`username`,`password`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ; - --- -------------------------------------------------------- - --- --- Table structure for table `regusers_groups` --- - -CREATE TABLE IF NOT EXISTS `regusers_groups` ( - `id_user` int(11) unsigned NOT NULL, - `id_group` int(11) unsigned NOT NULL, - UNIQUE KEY `id_group` (`id_group`,`id_user`), - KEY `group_indx` (`id_group`), - KEY `user_indx` (`id_user`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `revisions` --- - -CREATE TABLE IF NOT EXISTS `revisions` ( - `id_rev` int(10) unsigned NOT NULL AUTO_INCREMENT, - `type` varchar(50) NOT NULL, - `kernel` varchar(100) NOT NULL, - `vendor` varchar(50) NOT NULL, - `model` varchar(200) NOT NULL, - `created_by` int(11) NOT NULL, - `updated_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `update_date` datetime NOT NULL, - `compatibility` char(15) NOT NULL, - `description` text NOT NULL, - `distribution` varchar(300) NOT NULL, - `video_card_type` varchar(100) NOT NULL, - `video_card_works` varchar(30) NOT NULL, - `wifi_type` varchar(100) NOT NULL, - `wifi_works` varchar(30) NOT NULL, - `comm_year` char(15) NOT NULL, - `id_hard` int(10) unsigned NOT NULL, - `pci_id` char(10) NOT NULL, - `subtype` char(25) NOT NULL, - `driver` varchar(50) NOT NULL, - `interface` char(15) NOT NULL DEFAULT 'not-specified', - `bios` char(20) NOT NULL DEFAULT 'not-specified', - `webcam_type` varchar(100) NOT NULL, - `webcam_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `sound_card_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `bluetooth_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `fingerprint_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `architecture` char(15) NOT NULL DEFAULT 'not-specified', - `other_names` text NOT NULL, - `approved` char(4) NOT NULL DEFAULT 'yes', - `cleared` char(3) NOT NULL DEFAULT 'no', - `ethernet_card_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `sd_card_works` varchar(30) NOT NULL DEFAULT 'not-specified', - `can_free_systems_be_installed` varchar(30) NOT NULL DEFAULT 'not-specified', - `it_tracks_users` varchar(30) NOT NULL DEFAULT 'not-specified', - `prevent_wifi` char(20) NOT NULL DEFAULT 'not-specified', - PRIMARY KEY (`id_rev`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `talk` --- - -CREATE TABLE IF NOT EXISTS `talk` ( - `id_talk` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `title` varchar(100) NOT NULL, - `message` text NOT NULL, - `id_hard` int(10) unsigned NOT NULL, - `deleted` char(4) NOT NULL DEFAULT 'no', - PRIMARY KEY (`id_talk`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `wiki` --- - -CREATE TABLE IF NOT EXISTS `wiki` ( - `id_wiki` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `update_date` datetime NOT NULL, - `title` varchar(200) NOT NULL, - `title_clean` varchar(200) NOT NULL, - `page` text NOT NULL, - `deleted` char(3) NOT NULL DEFAULT 'no', - `blocked` char(3) NOT NULL DEFAULT 'no', - `is_main` char(3) NOT NULL DEFAULT 'no', - PRIMARY KEY (`id_wiki`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `wiki_revisions` --- - -CREATE TABLE IF NOT EXISTS `wiki_revisions` ( - `id_rev` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `update_date` datetime NOT NULL, - `title` varchar(200) NOT NULL, - `title_clean` varchar(200) NOT NULL, - `page` text NOT NULL, - `id_wiki` int(10) unsigned NOT NULL, - PRIMARY KEY (`id_rev`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `wiki_talk` --- - -CREATE TABLE IF NOT EXISTS `wiki_talk` ( - `id_talk` int(10) unsigned NOT NULL AUTO_INCREMENT, - `created_by` int(11) NOT NULL, - `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `title` varchar(100) NOT NULL, - `message` text NOT NULL, - `id_wiki` int(10) unsigned NOT NULL, - `deleted` char(4) NOT NULL DEFAULT 'no', - PRIMARY KEY (`id_talk`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -------------------------------------------------------- - --- --- Table structure for table `wiki_users` --- - -CREATE TABLE IF NOT EXISTS `wiki_users` ( - `id_user` int(11) unsigned NOT NULL, - `id_wiki` int(11) unsigned NOT NULL, - UNIQUE KEY `id_user` (`id_user`,`id_wiki`), - KEY `wiki_indx` (`id_wiki`), - KEY `user_indx` (`id_user`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- --- Constraints for dumped tables --- - --- --- Constraints for table `adminusers_groups` --- -ALTER TABLE `adminusers_groups` - ADD CONSTRAINT `adminusers_groups_ibfk_1` FOREIGN KEY (`id_group`) REFERENCES `admingroups` (`id_group`), - ADD CONSTRAINT `adminusers_groups_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `adminusers` (`id_user`); - --- --- Constraints for table `hardware_users` --- -ALTER TABLE `hardware_users` - ADD CONSTRAINT `hardware_users_ibfk_1` FOREIGN KEY (`id_hard`) REFERENCES `hardware` (`id_hard`), - ADD CONSTRAINT `hardware_users_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `regusers` (`id_user`); - --- --- Constraints for table `regusers_groups` --- -ALTER TABLE `regusers_groups` - ADD CONSTRAINT `regusers_groups_ibfk_1` FOREIGN KEY (`id_group`) REFERENCES `reggroups` (`id_group`), - ADD CONSTRAINT `regusers_groups_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `regusers` (`id_user`); - --- --- Constraints for table `wiki_users` --- -ALTER TABLE `wiki_users` - ADD CONSTRAINT `wiki_users_ibfk_1` FOREIGN KEY (`id_wiki`) REFERENCES `wiki` (`id_wiki`), - ADD CONSTRAINT `wiki_users_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `regusers` (`id_user`); - - -create table vendors ( - id_vendor INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, - creation_date timestamp default CURRENT_TIMESTAMP, - update_date datetime NOT NULL, - vendorid CHAR(4) not null, - clean_name varchar(200) CHARACTER SET utf8 not null, - full_name varchar(200) CHARACTER SET utf8 not null, - bus ENUM('PCI', 'USB'), - unique(bus,vendorid) -)engine=innodb; - - -create table distros ( - id_distro INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, - creation_date timestamp default CURRENT_TIMESTAMP, - clean_name varchar(200) CHARACTER SET utf8 not null, - full_name varchar(200) CHARACTER SET utf8 not null, - id_order INT UNSIGNED NOT NULL, - active tinyint(1) NOT NULL DEFAULT 1 -)engine=innodb; - -insert into distros (clean_name, full_name, id_order, active) values ('blag_90001', 'BLAG 90001', 1, 0); -insert into distros (clean_name, full_name, id_order, active) values ('blag_120000', 'BLAG 120000', 2, 0); -insert into distros (clean_name, full_name, id_order, active) values ('blag_140000', 'BLAG 1400000', 3, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian', 'Debian GNU/Linux Testing/Unstable', 4, 1); -insert into distros (clean_name, full_name, id_order, active) values ('debian_6', 'Debian GNU/Linux 6 squeeze', 5, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_7', 'Debian GNU/Linux 7 wheezy', 6, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_8', 'Debian GNU/Linux 8 jessie', 7, 1); -insert into distros (clean_name, full_name, id_order, active) values ('debian_9', 'Debian GNU/Linux 9 stretch', 8, 1); -insert into distros (clean_name, full_name, id_order, active) values ('dragora_1_1', 'Dragora 1.1', 9, 0); -insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_0', 'Dragora 2.0 Ardi', 10, 0); -insert into distros (clean_name, full_name, id_order, active) values ('dragora_2_2', 'Dragora 2.2 Rafaela', 11, 0); -insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_2_5_2', 'Dyne:bolic 2.5.2 DHORUBA', 12, 0); -insert into distros (clean_name, full_name, id_order, active) values ('dynebolic_3_0_X', 'Dyne:III 3.0.X MUNIR', 13, 0); -insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_2_3', 'gNewSense 2.3 Deltah', 14, 0); -insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0', 'gNewSense 3.0 Metad (beta)', 15, 0); -insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_3_0_parkes', 'gNewSense 3.0 Parkes', 16, 0); -insert into distros (clean_name, full_name, id_order, active) values ('gnewsense_4_0', 'gNewSense 4.0 Ucclia', 17, 0); -insert into distros (clean_name, full_name, id_order, active) values ('guix_0_10', 'GuixSD 0.10', 18, 0); -insert into distros (clean_name, full_name, id_order, active) values ('guix', 'GuixSD', 19, 1); -insert into distros (clean_name, full_name, id_order, active) values ('musix_2_0', 'Musix GNU+Linux 2.0 R0', 20, 0); -insert into distros (clean_name, full_name, id_order, active) values ('musix_3_0_1', 'Musix GNU+Linux 3.0.1', 21, 0); -insert into distros (clean_name, full_name, id_order, active) values ('parabola', 'Parabola GNU/Linux', 22, 1); -insert into distros (clean_name, full_name, id_order, active) values ('pureos_8_0', 'PureOS 8.0 Prometheus', 23, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_3_5', 'Trisquel 3.5 Awen', 24, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_0', 'Trisquel 4.0 Taranis', 25, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_4_5', 'Trisquel 4.5 Slaine', 26, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_0', 'Trisquel 5.0 Dagda', 27, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_5_5', 'Trisquel 5.5 Brigantia', 28, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_6_0', 'Trisquel 6.0 Toutatis', 29, 0); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_7_0', 'Trisquel 7.0 Belenos', 30, 1); -insert into distros (clean_name, full_name, id_order, active) values ('trisquel_8_0', 'Trisquel 8.0 Flidas', 31, 1); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2009', 'UTUTO XS 2009', 32, 0); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2010', 'UTUTO XS 2010', 33, 0); -insert into distros (clean_name, full_name, id_order, active) values ('ututo_xs_2012_04', 'UTUTO XS 2012.04', 34, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8', 'VENENUX 0.8', 35, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_8_2', 'VENENUX-EC 0.8.2', 36, 0); -insert into distros (clean_name, full_name, id_order, active) values ('venenux_0_9', 'VENENUX 0.9', 37, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_testing', 'Debian GNU/Linux Testing', 38, 0); -insert into distros (clean_name, full_name, id_order, active) values ('debian_unstable', 'Debian GNU/Linux Unstable', 39, 0); - -insert into reggroups (name) values ('manager'); -insert into reggroups (name) values ('admin'); -insert into reggroups (name) values ('moderator'); - -insert into regusers (username,password) values ('admin',sha1('admin')); - -insert into regusers_groups (id_user, id_group) values (1,1); -insert into regusers_groups (id_user, id_group) values (1,2); -insert into regusers_groups (id_user, id_group) values (1,3); -- cgit v1.2.3