n06GMLNa

1create table if not exists 'content' (
2    'content_id'    int(11)         default null auto_increment,
3    'titel'         varchar(255)    character set utf8 collate utf8_general_ci not null,
4    'datum'         varchar(255)    character set utf8 collate utf8_general_ci,
5    'text'          text            character set utf8 collate utf8_general_ci,
6    'is_project'    tinyint(1)      not null default '0',
7    primary key('content_id')
8) engine = MyISAM character set utf8 collate utf8_general_ci;
9
10create table if not exists 'file' (
11    'file_id'       int(11)         default null auto_increment,
12    'name'          varchar(255)    character set utf8 collate utf8_general_ci not null,
13    'file'          varchar(255)    character set utf8 collate utf8_general_ci,
14    primary key('file_id')
15) engine = MyISAM character set utf8 collate utf8_general_ci;
16
17create table if not exists 'content_file' (
18    'content_id'    int(11)         default null auto_increment,
19    'file_id'       int(11)         default null auto_increment,
20    primary key('content_id','file_id')
21) engine = MyISAM character set utf8 collate utf8_general_ci;