SyncServer/databaseUpdates.sql at main · dam024/SyncServer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

--
--Update the database structure
--


--[Action required]
--
-- Treat Data of DeleteTracker:
--

--
-- Delete table DeleteTracker
--
DROP TABLE DeleteTracker;


--
-- Create new table ChangesTracker
--
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ChangesTracker` (
  `ChangesTracker_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ChangesTracker_DATE` datetime NOT NULL,
  `ChangesTracker_ENTITY` varchar(20) NOT NULL,
  `ChangesTracker_ObjID` varchar(64) NOT NULL,
  `ChangesTracker_DEVICE` int(11) NOT NULL,
  `ChangesTracker_Type` char(6) NOT NULL COMMENT '`modif` or `delete` to indicate the type of changes in the data',
  PRIMARY KEY (`ChangesTracker_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Create new table TestAdd
--
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ChangesTracker` (
  `ChangesTracker_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ChangesTracker_DATE` datetime NOT NULL,
  `ChangesTracker_ENTITY` varchar(20) NOT NULL,
  `ChangesTracker_ObjID` varchar(64) NOT NULL,
  `ChangesTracker_DEVICE` int(11) NOT NULL,
  `ChangesTracker_Type` char(6) NOT NULL COMMENT '`modif` or `delete` to indicate the type of changes in the data',
  PRIMARY KEY (`ChangesTracker_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TestAdd` (
  `TESTfs` int(11) NOT NULL,
  `jfklsahég` int(11) NOT NULL,
  `jgksaélf` int(11) NOT NULL,
  `jhgkaséj` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Modify data type of ProgramClass.PROGRAMCLASS_OBJECTIVE
--
ALTER TABLE ProgramClass
MODIFY COLUMN PROGRAMCLASS_OBJECTIVE text;