1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
drop table if exists user_pref;
create table user_pref (
user_id INT NOT NULL,
jobs_layout VARCHAR(250),
jobs_fields VARCHAR(250),
PRIMARY KEY (user_id)
) Type=MyISAM;
--example. user_id = 1234
-- jobs_layout = csv of field_ids = "5,7,8,1,2,55,24"
-- jobs_fields = csv of sort order+direction. 0 = not sorted. = "0a,0a,1d,3a,2d,0a,0a"
drop table if exists jobs_fields;
create table jobs_fields (
field_id INT NOT NULL,
field_name VARCHAR(50),
field_desc VARCHAR(200),
PRIMARY KEY (field_id)
) Type=MyISAM;
--example (5, "Priority", "Shows the priority of the job.")
|
GitWeb
