Guest User

create_table_filter

a guest
Feb 18th, 2012
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.54 KB | None | 0 0
  1. --
  2. -- Table structure for table 'filter'
  3. --
  4.  
  5. CREATE TABLE filter (
  6.   filter_id int(11) NOT NULL AUTO_INCREMENT,
  7.   in_from varchar(200) NOT NULL,
  8.   in_subject varchar(200) NOT NULL,
  9.   in_haswords varchar(200) NOT NULL,
  10.   in_doesnt_have varchar(200) NOT NULL,
  11.   out_desc varchar(200) NOT NULL,
  12.   out_prio int(11) NOT NULL,
  13.   out_list_tags varchar(200) NOT NULL,
  14.   out_due_date varchar(20) NOT NULL,
  15.   out_estimate varchar(20) NOT NULL,
  16.   out_location varchar(200) NOT NULL,
  17.   PRIMARY KEY (filter_id)
  18. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment