[Openfc-tech] complete DB description

[adam <ad...@xs...>]

I madse 3 changes in total to fields, so here is the correct format of the
db as of sunday June 8, 12:00

-- default mysql.database creation script
-- change localhost if you are using separate
-- sql server, .. change at least mypass


CREATE DATABASE openfc;
GRANT INSERT,DELETE,UPDATE,SELECT ON openfc.* TO openfc@localhost
IDENTIFIED BY 'mypass';
FLUSH PRIVILEGES;
USE openfc
CREATE TABLE events (
  ID bigint(20) NOT NULL auto_increment,
  programID int(11) default NULL,
  timetableID int(11) default NULL,
  datetimebegin varchar(20) default NULL,
  elength varchar(10) default NULL,
  datetimeend varchar(20) default NULL,
  recurring varchar(20) default 'no',
  recurr_end varchar(20) default NULL,
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE genres (
  ID bigint(20) NOT NULL auto_increment,
  genre varchar(50) default NULL,
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE programs (
  ID bigint(20) NOT NULL auto_increment,
  name varchar(80) default NULL,
  url text,
  description text,
  length varchar(50) default NULL,
  ownerID int(11) default NULL,
  genreID int(11) default NULL,
  category varchar(80) default NULL,
  format text,
  codec varchar(20) NOT NULL default 'unknown',
  permissions varchar(10) NOT NULL default 'owner',
  bitrate varchar(15) NOT NULL default '56k',
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE timetables (
  ID bigint(20) NOT NULL auto_increment,
  name varchar(200) default NULL,
  description text,
  owner varchar(20) default NULL,
  pagecolor varchar(10) NOT NULL default '#000000',
  tablecolor varchar(10) NOT NULL default '#808080',
  font varchar(40) NOT NULL default 'Geneva, Arial, Helvetica',
  fontcolor varchar(10) NOT NULL default '#FFFFFF',
  fontsize varchar(5) NOT NULL default '-2',
  users varchar(200) default NULL,
  subscribers varchar(200) default NULL,
  logo varchar(100) default NULL,
  pagetext varchar(200) default NULL,
  days char(2) default '7',
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE users (
  ID int(5) NOT NULL auto_increment,
  user varchar(20) default NULL,
  pass varchar(20) default NULL,
  fullname varchar(50) default NULL,
  email varchar(20) default NULL,
  tablez varchar(50) default NULL,
  categories text,
  PRIMARY KEY  (ID),
  KEY ID (ID)
) TYPE=MyISAM;

INSERT INTO users SET
user='adam',pass='adam',fullname='Administrator',email='fc...@yo...';

INSERT INTO genres SET genre='Alternative';
INSERT INTO genres SET genre='Electronica';
INSERT INTO genres SET genre='Rock';
INSERT INTO genres SET genre='Comedy';
INSERT INTO genres SET genre='Abstract';
INSERT INTO genres SET genre='Discussion';
INSERT INTO genres SET genre='Festival';
INSERT INTO genres SET genre='Talk';
INSERT INTO genres SET genre='Pop';