1
CREATE DATABASE mediaDb;
6
-- Table structure for table `media`
10
id INTEGER unsigned NOT NULL auto_increment,
11
category varchar(100) NOT NULL default '',
12
subcategory varchar(100) NOT NULL default '',
13
type varchar(10) NOT NULL default '',
14
format varchar(10) NOT NULL default '',
15
insertedby varchar(100) NOT NULL default '',
16
insertdate datetime NOT NULL default '0000-00-00 00:00:00',
17
description varchar(100) default '',
18
textcolour varchar(10) DEFAULT 'NULL',
19
shadowcolour varchar(10) DEFAULT 'NULL',
22
UNIQUE KEY data (data(100),description,category,subcategory,type,format)
26
-- Dumping data for table `media`
29
INSERT INTO media VALUES (1,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','black','','','');
30
INSERT INTO media VALUES (2,'Main','','img','bg','cjd','2004-08-01 17:02:25','black','','','');
31
INSERT INTO media VALUES (5,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','orange','','','');
32
INSERT INTO media VALUES (6,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','gray','','','');
33
INSERT INTO media VALUES (7,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','red','','','');
34
INSERT INTO media VALUES (8,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','green','','','');
35
INSERT INTO media VALUES (9,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','blue','','','');
36
INSERT INTO media VALUES (10,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','yellow','','','');
37
INSERT INTO media VALUES (11,'Solid','','bg','bg','cjd','2004-08-01 17:03:47','white','','','');