Drizzled Public API Documentation

alter.inc

00001 # 
00002 # Simple test of the transaction log for testing ALTER command 
00003 #
00004 --disable_warnings
00005 DROP TABLE IF EXISTS t1;
00006 --enable_warnings
00007 
00008 CREATE TABLE t1 (
00009   id INT NOT NULL
00010 , padding VARCHAR(200) NOT NULL
00011 , PRIMARY KEY (id)
00012 );
00013 
00014 INSERT INTO t1 VALUES (1, "I love testing.");
00015 INSERT INTO t1 VALUES (2, "I hate testing.");
00016 
00017 # Simple addition of a new column
00018 ALTER TABLE t1 ADD dummy INT;
00019 
00020 # Add an index via ALTER TABLE
00021 ALTER TABLE t1 ADD INDEX ix_padding (padding(20));
00022 
00023 DROP TABLE t1;
00024