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
|
-------------------------------------------------------------------------------
-- --
-- GNADE : GNat Ada Database Environment --
-- --
-- Filename : $Source: /cvsroot/gnade/gnade/samples/mysql/dbinstall.sql,v $
-- Description : create the tables for the mysql example --
-- Author : Michael Erdmann <Michael.Erdmann@snafu.de> --
-- Created On : 22-Dec-2000 --
-- Last Modified By: $Author: merdmann $ --
-- Last Modified On: $Date: 2003/02/02 18:15:03 $ --
-- Status : $State: Exp $ --
-- --
-- Copyright (C) 2000-2003 Michael Erdmann --
-- --
-- GNADE is free software; you can redistribute it and/or modify it under --
-- terms of the GNU General Public License as published by the Free Soft- --
-- ware Foundation; either version 2, or (at your option) any later ver- --
-- sion. GNAT is distributed in the hope that it will be useful, but WITH- --
-- OUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY --
-- or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License --
-- for more details. You should have received a copy of the GNU General --
-- Public License distributed with GNAT; see file COPYING. If not, write --
-- to the Free Software Foundation, 59 Temple Place - Suite 330, Boston, --
-- MA 02111-1307, USA. --
-- --
-- As a special exception, if other files instantiate generics from this --
-- unit, or you link this unit with other files to produce an executable, --
-- this unit does not by itself cause the resulting executable to be --
-- covered by the GNU General Public License. This exception does not --
-- however invalidate any other reasons why the executable file might be --
-- covered by the GNU Public License. --
-- --
-- GNADE is implemented to work with GNAT, the GNU Ada compiler. --
-- --
-- Functional Description --
-- ====================== --
-- Create the tables needed for the test program. --
-- --
-- Restrictions --
-- ============ --
-- --
-- References --
-- ========== --
-- --
-------------------------------------------------------------------------------
use testdb ;
create table Test (
id char(30),
create_Time date,
value float,
data longblob
);
insert into Test (id, create_time, value, data )
values ( "Hallo", "1999-10-11", 10.3, BINARY "HHHHYYY" );
insert into Test (id, create_time, value, data )
values ( "Otto", "1999-10-11", 10.3, BINARY "Das ist ein Test" );
insert into Test (id, create_time, value ) values ( "Otto", "1999-11-11", 10.5 );
|
