From: Alan Knowles <alan@roojs.com>
Date: Mon, 16 Jul 2018 04:29:24 +0000 (+0800)
Subject: sync
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=3f8b64f511cf19a09ee8b9c54637a896bf7a61bb

sync
---

diff --git a/sql/account_code.sql b/sql/account_code.sql
deleted file mode 100644
index 5b47c65c..00000000
--- a/sql/account_code.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-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;
-
-
-
-
diff --git a/sql/core_email0.sql b/sql/core_email0.sql
deleted file mode 100644
index 71b8002b..00000000
--- a/sql/core_email0.sql
+++ /dev/null
@@ -1,36 +0,0 @@
-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;
-
diff --git a/sql/cost_centeres.sql b/sql/cost_centeres.sql
deleted file mode 100644
index 89da40d3..00000000
--- a/sql/cost_centeres.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-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;
-
-
-
-
diff --git a/sql/cost_centeres_1.sql b/sql/cost_centeres_1.sql
deleted file mode 100644
index 89da40d3..00000000
--- a/sql/cost_centeres_1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-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;
-
-
-
-