home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
linuxmafia.com 2016
/
linuxmafia.com.tar
/
linuxmafia.com
/
bale
/
cbstartsql.txt
< prev
next >
Wrap
Text File
|
2002-09-24
|
1KB
|
61 lines
# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : events
# --------------------------------------------------------
#
# Table structure for table 'events'
#
CREATE TABLE events (
eventid int(11) NOT NULL auto_increment,
ename varchar(40),
ecity varchar(40),
ecounty varchar(40),
edate varchar(40),
starttime int(11),
endtime int(11),
description text,
egroup int(11) NOT NULL,
PRIMARY KEY (eventid)
);
# --------------------------------------------------------
#
# Table structure for table 'eventtemplate'
#
CREATE TABLE eventtemplate (
eventtid int(11) NOT NULL auto_increment,
ename varchar(40),
ecity varchar(40),
ecounty varchar(40),
weekday int(11),
weekofmonth int(11),
starttime int(11),
endtime int(11),
description text,
PRIMARY KEY (eventtid)
);
# --------------------------------------------------------
#
# Table structure for table 'groups'
#
CREATE TABLE groups (
gname varchar(40),
gcity varchar(40),
gcounty varchar(40),
description text,
gcode varchar(25) NOT NULL,
active tinyint(4) DEFAULT '1' NOT NULL,
outofarea tinyint(4) NOT NULL,
PRIMARY KEY (gcode)
);