phpBB.de

Code: Alles auswählen

$db_setup = " CREATE TABLE IF NOT EXISTS `ext` (
                    `theme` varchar(20) NOT NULL,
                    `ext` varchar(4) NOT NULL,
                    `img` varchar(10) NOT NULL
                  ) 
                  
                  
                  
                  INSERT INTO `ext` (`theme`, `ext`, `img`) VALUES
                  ('standard', 'avi', 'avi.png'),
                  ('standard', 'bat', 'bat.png'),
                  ('standard', 'bmp', 'bmp.png'),
                  ('standard', 'gif', 'gif.png'),
                  ('standard', 'html', 'html.png'),
                  ('standard', 'htm', 'html.png'),
                  ('standard', 'img', 'img.png'),
                  ('standard', 'inf', 'inf.png'),
                  ('standard', 'iso', 'iso.png'),
                  ('standard', 'jpeg', 'jpg.png'),
                  ('standard', 'jpg', 'jpg.png'),
                  ('standard', 'midi', 'mid.png'),
                  ('standard', 'mid', 'mid.png'),
                  ('standard', 'mov', 'mov.png'),
                  ('standard', 'mp4', 'mp4.png'),
                  ('standard', 'mpg', 'mpg.png'),
                  ('standard', 'pdf', 'pdf.png'),
                  ('standard', 'png', 'png.png'),
                  ('standard', 'rar', 'rar.png'),
                  ('standard', 'txt', 'txt.png'),
                  ('standard', 'tiff', 'tiff.png'),
                  ('standard', 'doc', 'doc.png'),
                  ('standard', 'docx', 'doc.png'),
                  ('standard', 'wav', 'wav.png'),
                  ('standard', 'file', 'file.png'),
                  ('standard', 'wmv', 'wmv.png'),
                  ('standard', 'xml', 'xml.png'),
                  ('standard', 'zip', 'zip.png'),
                  ('standard', '7z', 'zip.png');
                  
                  
                  
                  CREATE TABLE IF NOT EXISTS `files` (
                    `user` bigint(20) NOT NULL,
                    `time` bigint(20) NOT NULL,
                    `filename` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
                    `size` float NOT NULL,
                    `type` varchar(4) character set latin1 collate latin1_general_ci NOT NULL,
                    `downloads` tinyint(3) unsigned NOT NULL default '0'
                  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
                  
                  

                  CREATE TABLE IF NOT EXISTS `theme` (
                    `theme` varchar(20) character set latin1 collate latin1_general_ci NOT NULL,
                    UNIQUE KEY `grey` (`theme`)
                  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
                  

                  INSERT INTO `theme` (`theme`) VALUES
                  ('grey');
                  INSERT INTO `theme` (`theme`) VALUES
                  ('glossy');
                  INSERT INTO `theme` (`theme`) VALUES
                  ('colored');
                  
                  CREATE TABLE IF NOT EXISTS `user` (
                    `id` bigint(20) NOT NULL,
                    `user` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
                    `password` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
                    `uploadlimit` bigint(20) unsigned NOT NULL default '10240' COMMENT 'uploadlimit in kB',
                    `theme` varchar(20) character set latin1 collate latin1_general_ci NOT NULL default 'grey',
                    `realpreview` tinyint(1) NOT NULL default '0',
                    `selfcount` tinyint(1) NOT NULL default '0',
                    `lastlogin` bigint(20) default NULL,
                    PRIMARY KEY  (`id`),
                    UNIQUE KEY `user` (`user`)
                  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;