2 FS::dbdef_table - Table objects
7 $dbdef_table = new FS::dbdef_table (
10 $FS_dbdef_unique_object,
11 $FS_dbdef_index_object,
12 @FS_dbdef_column_objects,
15 $dbdef_table->addcolumn ( $FS_dbdef_column_object );
17 $table_name = $dbdef_table->name;
18 $dbdef_table->name ("table_name");
20 $table_name = $dbdef_table->primary_keye;
21 $dbdef_table->primary_key ("primary_key");
23 $FS_dbdef_unique_object = $dbdef_table->unique;
24 $dbdef_table->unique ( $FS_dbdef_unique_object );
26 $FS_dbdef_index_object = $dbdef_table->index;
27 $dbdef_table->index ( $FS_dbdef_index_object );
29 @column_names = $dbdef->columns;
31 $FS_dbdef_column_object = $dbdef->column;
33 @sql_statements = $dbdef->sql_create_table;
34 @sql_statements = $dbdef->sql_create_table $datasrc;
37 FS::dbdef_table objects represent a single database table.
40 new Creates a new FS::dbdef_table object.
43 Adds this FS::dbdef_column object.
46 Returns or sets the table name.
49 Returns or sets the primary key.
52 Returns or sets the FS::dbdef_unique object.
55 Returns or sets the FS::dbdef_index object.
58 Returns a list consisting of the names of all columns.
61 Returns the column object (see the FS::dbdef_column manpage)
64 sql_create_table [ $datasrc ]
65 Returns an array of SQL statments to create this table.
67 If passed a DBI $datasrc specifying the DBD::mysql manpage,
68 will use MySQL-specific syntax. Non-standard syntax for
69 other engines (if applicable) may also be supported in the
74 the FS::dbdef manpage, the FS::dbdef_unique manpage, the
75 FS::dbdef_index manpage, the FS::dbdef_unique manpage, the DBI
79 $Id: dbdef_table.txt,v 1.5 1999-04-08 13:39:32 ivan Exp $
82 class for dealing with table definitions
84 ivan@sisd.com 98-apr-18
86 gained extra functions (should %columns be an IxHash?)
87 ivan@sisd.com 98-may-11
89 sql_create_table returns a list of statments, not just one, and
90 now it does indices (plus mysql hack) ivan@sisd.com 98-jun-2
92 untaint primary_key... hmm. is this a hack around a bigger
93 problem? looks like, did the same thing singles in colgroup!
94 ivan@sisd.com 98-jun-4
96 pod ivan@sisd.com 98-sep-24
98 $Log: dbdef_table.txt,v $
99 Revision 1.5 1999-04-08 13:39:32 ivan
100 convert from pod for 1.2.0 release
101 Revision 1.2 1998/10/14 07:05:06 ivan
102 1.1.4 release, fix postgresql