SQL code to create the OML database
CREATE TABLE oml
(
file character varying(255) NOT NULL,
path character varying(64) NOT NULL,
date character varying(10),
"time" character varying(8),
quality character varying(2),
party character varying(1),
annoy character varying(1),
year character varying(4),
bitrate smallint,
size integer,
style character varying(3),
popularity character varying(1),
utime integer,
ratetime integer, -- utime
radio character varying(1),
lyrics character varying(1),
comment character varying,
yearmb character varying(4), -- MusicBrainz Year
yearall character varying(4),
speed character varying(1),
la character varying(3),
album character varying,
nr smallint,
CONSTRAINT oml_file_key UNIQUE (file, path)
)
WITH (
OIDS=TRUE
);
CREATE TABLE style
(
style character varying(3) NOT NULL,
descr character varying NOT NULL,
comment character varying,
CONSTRAINT style_pkey PRIMARY KEY (style)
)
WITH (
OIDS=TRUE
);
configuration of c:/xampp/apache/conf/httpd.conf
(exchange the G:/mp3/ path with your directory)
look for this passage and insert:
<IfModule alias_module>
Alias /mp3 "G:/mp3/"
<Directory "G:/mp3/">
Options Indexes FollowSymLinks MultiViews ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
back to Radiovibrations.com start page