リビジョン 101
年マスタ・月マスタ・日マスタ追加・コンバートツール修正・Create文追加
| ProcessManagement.sql | ||
|---|---|---|
| 119 | 119 |
DROP TABLE IF EXISTS DailyDataMaterials; |
| 120 | 120 |
DROP TABLE IF EXISTS DailyDataSubcontractors; |
| 121 | 121 |
DROP TABLE IF EXISTS DailyDataVehicles; |
| 122 |
DROP TABLE IF EXISTS DayMaster; |
|
| 122 | 123 |
DROP TABLE IF EXISTS DepartmentExpensesMaster; |
| 123 | 124 |
DROP TABLE IF EXISTS DepartmentMaster; |
| 124 | 125 |
DROP TABLE IF EXISTS DivisionMaster; |
| ... | ... | |
| 132 | 133 |
DROP TABLE IF EXISTS MessageBoardData; |
| 133 | 134 |
DROP TABLE IF EXISTS MessageBoardTerget; |
| 134 | 135 |
DROP TABLE IF EXISTS MessageBrowsingHistory; |
| 136 |
DROP TABLE IF EXISTS MonthMaster; |
|
| 135 | 137 |
DROP TABLE IF EXISTS OrderersMaster; |
| 136 | 138 |
DROP TABLE IF EXISTS OrdersPriceData; |
| 137 | 139 |
DROP TABLE IF EXISTS PersonApproval; |
| ... | ... | |
| 168 | 170 |
DROP TABLE IF EXISTS VehicleMaster; |
| 169 | 171 |
DROP TABLE IF EXISTS VehicleRecordData; |
| 170 | 172 |
DROP TABLE IF EXISTS VehicleScheduleData; |
| 173 |
DROP TABLE IF EXISTS YearMaster; |
|
| 171 | 174 |
|
| 172 | 175 |
|
| 173 | 176 |
|
| ... | ... | |
| 926 | 929 |
) COMMENT = '日報データ (車両)'; |
| 927 | 930 |
|
| 928 | 931 |
|
| 932 |
-- 日マスタ |
|
| 933 |
CREATE TABLE DayMaster |
|
| 934 |
( |
|
| 935 |
days smallint NOT NULL COMMENT '日' |
|
| 936 |
) COMMENT = '日マスタ'; |
|
| 937 |
|
|
| 938 |
|
|
| 929 | 939 |
-- 部署経費率マスタ |
| 930 | 940 |
CREATE TABLE DepartmentExpensesMaster |
| 931 | 941 |
( |
| ... | ... | |
| 1147 | 1157 |
) COMMENT = '掲示板メッセージ閲覧履歴'; |
| 1148 | 1158 |
|
| 1149 | 1159 |
|
| 1160 |
-- 月マスタ |
|
| 1161 |
CREATE TABLE MonthMaster |
|
| 1162 |
( |
|
| 1163 |
month smallint NOT NULL COMMENT '月' |
|
| 1164 |
) COMMENT = '月マスタ'; |
|
| 1165 |
|
|
| 1166 |
|
|
| 1150 | 1167 |
-- 発注者マスタ |
| 1151 | 1168 |
CREATE TABLE OrderersMaster |
| 1152 | 1169 |
( |
| ... | ... | |
| 1816 | 1833 |
) COMMENT = '車両予約データ'; |
| 1817 | 1834 |
|
| 1818 | 1835 |
|
| 1836 |
-- 年マスタ |
|
| 1837 |
CREATE TABLE YearMaster |
|
| 1838 |
( |
|
| 1839 |
years smallint NOT NULL COMMENT '年' |
|
| 1840 |
) COMMENT = '年マスタ'; |
|
| 1819 | 1841 |
|
| 1842 |
|
|
| 1843 |
|
|
| 1820 | 1844 |
/* Create Indexes */ |
| 1821 | 1845 |
|
| 1822 | 1846 |
CREATE INDEX ActionScheduleData_Index1 ON ActionScheduleData (TargetYear ASC); |
他の形式にエクスポート: Unified diff