BBS-Universal
view release on metacpan or search on metacpan
sql/database_setup.sql view on Meta::CPAN
INSERT INTO file_types (type, extension) VALUES ('Atari 400/800/XL/XE Binary Executable', 'XEX');
INSERT INTO file_types (type, extension) VALUES ('Atari ST/STE/TT/Falcon GEM Program', 'PRG');
INSERT INTO file_types (type, extension) VALUES ('Atari ST/STE/TT/Falcon TOS Program', 'TOS');
INSERT INTO file_types (type, extension) VALUES ('Atari ST/STE/TT/Falcon TOS Takes Parameters Program', 'TTP');
INSERT INTO file_types (type, extension) VALUES ('Atari ST/STE/TT/Falcon Desk Accessory', 'ACC');
INSERT INTO file_types (type, extension) VALUES ('Atari ST/STE/TT/Falcon Extendable Desk Accessory', 'CPX');
INSERT INTO file_types (type, extension) VALUES ('Atari ST/STE/TT/Falcon Menu Resource', 'RSC');
INSERT INTO file_types (type, extension) VALUES ('7-Zip Compressed', '7Z');
INSERT INTO file_types (type, extension) VALUES ('Zip Compressed', 'ZIP');
INSERT INTO file_types (type, extension) VALUES ('RAR Compressed', 'RAR');
INSERT INTO file_types (type, extension) VALUES ('Compressed Archive', 'ARC');
INSERT INTO file_types (type, extension) VALUES ('TAR Archive Compressed', 'TGZ');
INSERT INTO file_types (type, extension) VALUES ('TAR Archive', 'TAR');
INSERT INTO file_types (type, extension) VALUES ('GZip Compressed', 'GZ');
INSERT INTO file_types (type, extension) VALUES ('Excel', 'XLS');
INSERT INTO file_types (type, extension) VALUES ('eXtensibe Markup Language', 'XML');
INSERT INTO file_types (type, extension) VALUES ('MS-DOS Command Executable', 'COM');
INSERT INTO file_types (type, extension) VALUES ('MS-DOS Batch', 'BAT');
INSERT INTO file_types (type, extension) VALUES ('MS-DOS/Windows Executable', 'EXE');
INSERT INTO file_categories (title,description,path) VALUES ('BBS::Universal Specific', 'All Files Relating to BBS Universal', 'BBS'); -- 1
INSERT INTO file_categories (title,description,path) VALUES ('General', 'General Files', 'General'); -- 2
INSERT INTO file_categories (title,description,path) VALUES ('Atari 8 Bit', 'Atari 400/800/XL/XE/XEGS Files', 'A800'); -- 3
INSERT INTO file_categories (title,description,path) VALUES ('Atari ST/STE', 'Atari ST/STE Files', 'Atari-ST'); -- 4
INSERT INTO file_categories (title,description,path) VALUES ('Atari TT030', 'Atari TT030 Files', 'Atari-TT'); -- 5
INSERT INTO file_categories (title,description,path) VALUES ('Atari Falcon030', 'Atari Falcon030 Files', 'Atari-Falcon'); -- 6
INSERT INTO file_categories (title,description,path) VALUES ('Commodore PET', 'Commodore PET Files', 'Commoedore-PET'); -- 7
INSERT INTO file_categories (title,description,path) VALUES ('Commodore VIC-20', 'Commodore VIC-20 Files', 'Commodore-VIC20'); -- 8
INSERT INTO file_categories (title,description,path) VALUES ('Commodore C64/128', 'Commodore C64/128 Files', 'Commodore-C64'); -- 9
INSERT INTO file_categories (title,description,path) VALUES ('Commodore TED', 'Commodore C16/Plus4 Files', 'Commodore-TED'); -- 10
INSERT INTO file_categories (title,description,path) VALUES ('Commodore Amiga', 'Commodore Amiga Files', 'Commodore-Amiga'); -- 11
INSERT INTO file_categories (title,description,path) VALUES ('Timex/Sinclair ZX81/1000/1500', 'Timex/Sinclair ZX81/1000/1500 Files', 'TS-1000'); -- 12
INSERT INTO file_categories (title,description,path) VALUES ('Timex/Sinclair 2048', 'Timex/Sinclair 2048 Files', 'TS-2048'); -- 13
INSERT INTO file_categories (title,description,path) VALUES ('Timex/Sinclair 2068', 'Timex/Sinclair 2068 Files', 'TS-2068'); -- 14
INSERT INTO file_categories (title,description,path) VALUES ('Sinclair Spectrum', 'Sinclair Spectrum Files', 'ZX-Spectrum'); -- 15
INSERT INTO file_categories (title,description,path) VALUES ('Heathkit', 'Heathkit Files', 'Heathkit'); -- 16
INSERT INTO file_categories (title,description,path) VALUES ('CP/M', 'CP/M Files', 'CP-M'); -- 17
INSERT INTO file_categories (title,description,path) VALUES ('TRS-80 CoCo', 'TRS-80 Color Computer Files', 'TRS-80-CoCo'); -- 18
INSERT INTO file_categories (title,description,path) VALUES ('TRS-80 Portables', 'TRS-80 Model 100/200 Files', 'TRS-80-Portables'); -- 19
INSERT INTO file_categories (title,description,path) VALUES ('TRS-80 Z80', 'TRS-80 Model I/II/III/4 Files', 'TRS-80-Z80'); -- 20
INSERT INTO file_categories (title,description,path) VALUES ('TRS-80 68000', 'TRS-80 Model 16/6000 Files', 'TRS-80-68000'); -- 21
INSERT INTO file_categories (title,description,path) VALUES ('Apple ][', 'Apple ][/Franklin Ace Files', 'Apple-II'); -- 22
INSERT INTO file_categories (title,description,path) VALUES ('Apple Macintosh 680x0', 'Macintosh 68000 Files', 'Apple-Macintosh-68000'); -- 23
INSERT INTO file_categories (title,description,path) VALUES ('Apple Macintosh PPC', 'Macintosh PowerPC Files', 'Apple-Macintosh-PPC'); -- 24
INSERT INTO file_categories (title,description,path) VALUES ('Apple Macintosh OS-X', 'Macintosh OS-X Files', 'Apple-Macintosh-OS-X'); -- 25
INSERT INTO file_categories (title,description,path) VALUES ('MS-DOS', 'MS-DOS Files', 'MS-DOS'); -- 26
INSERT INTO file_categories (title,description,path) VALUES ('Windows 3.xx', 'Windows 16 Bit Files', 'Win-3.11'); -- 27
INSERT INTO file_categories (title,description,path) VALUES ('Windows NT', 'Windows NT Files', 'Win-NT'); -- 28
INSERT INTO file_categories (title,description,path) VALUES ('Windows 32/64 Bit', 'Windows 32/64 Bit Files', 'Modern-Windows'); -- 29
INSERT INTO file_categories (title,description,path) VALUES ('Linux', 'Linux Files', 'Linux'); -- 30
INSERT INTO file_categories (title,description,path) VALUES ('FreeBSD', 'FreeBSD Files', 'FreeBSD'); -- 31
INSERT INTO file_categories (title,description,path) VALUES ('Homebrew', 'Homebrew Files', 'Homebrew'); -- 32
INSERT INTO file_categories (title,description,path) VALUES ('MSX', 'MSX Files', 'MSX'); -- 33
INSERT INTO file_categories (title,description,path) VALUES ('Wang', 'Wang Files', 'Wang'); -- 34
INSERT INTO file_categories (title,description,path) VALUES ('Oric', 'Oric Files', 'Oric'); -- 35
INSERT INTO file_categories (title,description,path) VALUES ('Tektronix', 'Tektronix Files', 'Tektronix'); -- 36
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="BBS::Universal Specific"), 'BBS_Universal.png','BBS::Universal Logo',(SELECT id FROM file_types WHERE extension='PN...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="BBS::Universal Specific"), 'BBS_Universal_banner.vt','ANSI BBS::Universal Logo',(SELECT id FROM file_types WHERE ex...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="General"), 'usa.ans','ANSI Token File USA',(SELECT id FROM file_types WHERE extension='ANS'),'USA i...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Sinclair Spectrum"), 'sinclair.ans','ANSI Token File Sinclair Logo',(SELECT id FROM file_types WHERE extensio...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Timex/Sinclair ZX81/1000/1500"), 'timex-sinclair.ans','ANSI Token File Timex/Sinclair Logo',(SELECT id FROM file_types WH...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Timex/Sinclair ZX81/1000/1500"), 'timex-sinclair-1000.ans','ANSI Token File Timex/Sinclair 1000 Logo',(SELECT id FROM fil...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Timex/Sinclair ZX81/1000/1500"), 'timex-sinclair-1500.ans','ANSI Token File Timex/Sinclair 1500 Logo',(SELECT id FROM fil...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Timex/Sinclair 2048"), 'timex-sinclair-2048.ans','ANSI Token File Timex/Sinclair 2048 Logo',(SELECT id FROM fil...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Timex/Sinclair 2068"), 'timex-sinclair-2068.ans','ANSI Token File Timex/Sinclair 2068 Logo',(SELECT id FROM fil...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Linux"), 'linux.vt','ANSI Linux Logo',(SELECT id FROM file_types WHERE extension='VT'),'Linux log...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Linux"), 'Linux.png','Linux Penguin Logo',(SELECT id FROM file_types WHERE extension='PNG'),'Linu...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="MS-DOS"), 'ms-dos.png','MS-DOS Logo',(SELECT id FROM file_types WHERE extension='PNG'),'Linux logo...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="MS-DOS"), 'ibm.jpg','IBM Logo',(SELECT id FROM file_types WHERE extension='JPG'),'IBM logo in JPEG...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="MS-DOS"), 'ibm-white.jpg','IBM Logo',(SELECT id FROM file_types WHERE extension='JPG'),'IBM logo w...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="MS-DOS"), 'ms-dos.ans','MS-DOS Logo',(SELECT id FROM file_types WHERE extension='ANS'),'MS-DOS log...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="MSX"), 'msx.png','MSX Logo',(SELECT id FROM file_types WHERE extension='PNG'),'MSX logo in PNG ...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="TRS-80 CoCo"), 'coco-logo.jpg','TRS-80 CoCo Logo',(SELECT id FROM file_types WHERE extension='JPG'),'Co...
INSERT INTO files (category,filename,title,file_type,description,file_size) VALUES ((SELECT id FROM file_categories WHERE title="Tektronix"), 'tektronix-logo.jpg','Tektronix Logo',(SELECT id FROM file_types WHERE extension='JPG'),...
INSERT INTO news (news_title,news_content) VALUES ('BBS Universal Installation','BBS::Universal, written by Richard Kelsch, a Perl based BBS server designed for retro and modern computers has been installed on this server.');
-- END
( run in 0.528 second using v1.01-cache-2.11-cpan-788537b7465 )