+++ /dev/null
-CREATE TABLE account_code (
- id INT(11) NOT NULL AUTO_INCREMENT ,
- name VARCHAR(8) NULL,
- description VARCHAR(64) NULL,
- cost_center INT(11) NULL,
- accpac VARCHAR(32) NULL,
- accpac_out VARCHAR(32) NULL,
- PRIMARY KEY (id)
-);
-
-ALTER TABLE account_code CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1;
-ALTER TABLE account_code ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1;
-
-
-
-
+++ /dev/null
-CREATE TABLE core_email (
- id INT(11) NOT NULL AUTO_INCREMENT ,
- subject TEXT ,
- bodytext TEXT ,
- plaintext TEXT ,
- name VARCHAR(255) NOT NULL DEFAULT '',
- updated_dt DATETIME NOT NULL ,
- from_email VARCHAR(254) NULL DEFAULT '',
- from_name VARCHAR(254) NULL DEFAULT '',
- owner_id INT(11) NOT NULL DEFAULT 0,
- is_system INT(2) NOT NULL DEFAULT 1,
- PRIMARY KEY (id)
-);
-
-ALTER TABLE core_email CHANGE COLUMN active active INT(2) NOT NULL DEFAULT 1;
-ALTER TABLE core_email ADD COLUMN active INT(2) NOT NULL DEFAULT 1;
-
--- need to store BCC data here.
-ALTER TABLE core_email CHANGE COLUMN bcc_group bcc_group_id INT(11) NOT NULL DEFAULT 0;
-ALTER TABLE core_email ADD COLUMN bcc_group_id INT(11) NOT NULL DEFAULT 0;
-
--- each email template should have a test class with a static method ::test_{name}
-ALTER TABLE core_email CHANGE COLUMN test_class test_class VARCHAR(254) NOT NULL DEFAULT '';
-ALTER TABLE core_email ADD COLUMN test_class VARCHAR(254) NOT NULL DEFAULT '';
-
-ALTER TABLE core_email CHANGE COLUMN in_group to_group_id INT(11) NOT NULL DEFAULT -1;
-ALTER TABLE core_email CHANGE COLUMN to_group to_group_id INT(11) NOT NULL DEFAULT -1;
-ALTER TABLE core_email ADD COLUMN to_group_id INT(11) NOT NULL DEFAULT -1;
-
--- rather than use 'body... use the original file..'
-ALTER TABLE core_email ADD COLUMN use_file VARCHAR(254) NOT NULL DEFAULT '';
-
-
-
-UPDATE core_email SET updated_dt = NOW() where updated_dt IS NULL;
-
+++ /dev/null
-CREATE TABLE cost_centers (
- id INT(11) NOT NULL AUTO_INCREMENT ,
- short_name VARCHAR(8) NULL,
- name VARCHAR(32) NULL,
- PRIMARY KEY (id)
-);
-
-ALTER TABLE cost_centers CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1;
-ALTER TABLE cost_centers ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1;
-
-
-
-
+++ /dev/null
-CREATE TABLE cost_centers (
- id INT(11) NOT NULL AUTO_INCREMENT ,
- short_name VARCHAR(8) NULL,
- name VARCHAR(32) NULL,
- PRIMARY KEY (id)
-);
-
-ALTER TABLE cost_centers CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1;
-ALTER TABLE cost_centers ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1;
-
-
-
-