2 CREATE TABLE core_project (
3 id int(11) NOT NULL auto_increment,
10 ALTER TABLE core_project ADD COLUMN name varchar(254) NOT NULL DEFAULT '';
11 ALTER TABLE core_project ADD COLUMN remarks text ;
12 ALTER TABLE core_project ADD COLUMN owner_id int(11) default NULL;
13 ALTER TABLE core_project ADD COLUMN code varchar(32) NOT NULL DEFAULT '';
14 ALTER TABLE core_project ADD COLUMN active int(11) default '1';
15 ALTER TABLE core_project ADD COLUMN type varchar(1) NOT NULL default 'P';
16 ALTER TABLE core_project ADD COLUMN client_id int(11) NOT NULL default '0';
17 ALTER TABLE core_project ADD COLUMN team_id int(11) NOT NULL default '0';
18 ALTER TABLE core_project ADD COLUMN file_location varchar(254) NOT NULL default '';
19 ALTER TABLE core_project ADD COLUMN open_date date NOT NULL DEFAULT '1000-01-01';
20 ALTER TABLE core_project ADD COLUMN open_by int(11) NOT NULL default 0;
22 ALTER TABLE core_project ADD COLUMN updated_dt DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';
23 ALTER TABLE core_project ADD COLUMN deleted_by INT NOT NULL DEFAULT 0;
24 ALTER TABLE core_project ADD COLUMN deleted_dt DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';
28 -- these should be removed, as they are code specific..
29 ALTER TABLE core_project ADD COLUMN countries varchar(128) NOT NULL DEFAULT '';
30 ALTER TABLE core_project ADD COLUMN languages varchar(128) NOT NULL DEFAULT '';
31 ALTER TABLE core_project ADD COLUMN agency_id int(11) NOT NULL DEFAULT 0 ;
33 ALTER TABLE core_project ADD INDEX plookup (code);
35 ALTER TABLE core_project ADD INDEX lookup_client_id (client_id);
36 ALTER TABLE core_project ADD INDEX lookup_agency_id (agency_id);
38 ALTER TABLE core_project ADD INDEX lookup_open_by (open_by);
39 ALTER TABLE core_project ADD INDEX lookup_owner_id (owner_id);