summaryrefslogtreecommitdiffstats
path: root/interop/src/main/resources/insertdata-mysql.ddl
blob: c6e99e18c5317819cd096e4deeabfd26ef9fb15e (plain)
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
67
68
69
70
71
72
73
74
75
76
--
--  Copyright (c) 2006 The Apache Software Foundation or its licensors, as applicable.
--
--  Licensed under the Apache License, Version 2.0 (the "License");
--  you may not use this file except in compliance with the License.
--  You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
--  Unless required by applicable law or agreed to in writing, software
--  distributed under the License is distributed on an "AS IS" BASIS,
--  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--  See the License for the specific language governing permissions and
--  limitations under the License.
--

USE INTEROP;

DELETE FROM ALLTYPE;
DELETE FROM ALLTYPEPARENT;

------------------------------------------------
-- Add data to table "INTEROP"."ALLTYPEPARENT"
------------------------------------------------
INSERT INTO ALLTYPEPARENT VALUES ( 
                                  1, 
                                  'THE PARENT' );
                                  
------------------------------------------------
-- Add data to table "INTEROP"."ALLTYPE"
------------------------------------------------
--		  ABIT BIT,
--		  ATINYINT TINYINT,
--		  ABOOLEAN BOOLEAN,
--		  ASMALLINT SMALLINT NOT NULL ,
--		  AMEDIUMINT MEDIUMINT,  
--		  AINTEGER INTEGER,
--		  ABIGINT BIGINT,
--		  AFLOAT FLOAT,
--		  ADOUBLE DOUBLE,
--		  ADOUBLEPRECISION DOUBLE,
--		  AREAL REAL,
--		  ADECIMAL DECIMAL,
--		  ADATE DATE,
--		  ADATETIME DATETIME,
--		  ATIMESTAMP TIMESTAMP,
--		  ATIME TIME,
--		  AYEAR YEAR,
--		  ACHAR CHAR,
--		  AVARCHAR VARCHAR(14) 

INSERT INTO ALLTYPE VALUES ( 1, 
                             2, 
                             1,
                             1,
                             4,
                             5,
                             6,
                             1.23,
                             4.56,
                             7.89,
                             0.12,
                             123,
                             '2006-06-11',
                             '2006-06-11 12:47:00',
                             NULL,
                             '12:47:00',
                             2006,
                             'A',
                             'INIT DATA',
                             1 );