42 lines
1.3 KiB
SQL
42 lines
1.3 KiB
SQL
create table s_repair_photo
|
|
(
|
|
id int auto_increment
|
|
primary key,
|
|
repair_id int default 0 not null,
|
|
img varchar(100) default '' not null,
|
|
position int default 0 not null
|
|
)
|
|
engine = MyISAM
|
|
charset = utf8;
|
|
;
|
|
|
|
|
|
create table s_repairs
|
|
(
|
|
id int auto_increment
|
|
primary key,
|
|
name text not null,
|
|
url varchar(255) default '' not null,
|
|
meta_title text not null,
|
|
meta_keywords text not null,
|
|
meta_description text not null,
|
|
annotation text not null,
|
|
image varchar(255) default '' not null,
|
|
text longtext not null,
|
|
visible tinyint(1) default 0 not null,
|
|
date timestamp default '0000-00-00 00:00:00' not null
|
|
)
|
|
engine = MyISAM
|
|
charset = utf8;
|
|
|
|
create index `1gb_VISIBLE_DATE_ID_AUTO`
|
|
on s_repairs (visible, date, id);
|
|
|
|
create index enabled
|
|
on s_repairs (visible);
|
|
|
|
create index url
|
|
on s_repairs (url);
|
|
|
|
|