scire/docs/scire3.sql

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.")

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