|
Originally Posted by X337
 *The SQL code is in bottom of script
|
|
/* SQL DUMP <X-Gang.sql> -- phpMyAdmin SQL Dump -- version 4.2.7.1 -- http://www.phpmyadmin.net -- -------------------------------------------------------- -- -- Table structure for table `gang` -- CREATE TABLE IF NOT EXISTS `gang` ( `id` int(10) NOT NULL, `name` varchar(30) NOT NULL, `color` varchar(6) NOT NULL, `tag` varchar(3) NOT NULL, `score` int(10) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `member` -- CREATE TABLE IF NOT EXISTS `member` ( `id` int(10) NOT NULL, `name` varchar(30) NOT NULL, `status` int(1) NOT NULL DEFAULT '1', `gang` int(10) NOT NULL DEFAULT '-1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `zone` -- CREATE TABLE IF NOT EXISTS `zone` ( `id` int(10) NOT NULL, `minx` varchar(10) NOT NULL, `miny` varchar(10) NOT NULL, `maxx` varchar(10) NOT NULL, `maxy` varchar(10) NOT NULL, `owner` int(10) NOT NULL DEFAULT '-1', `name` varchar(50) NOT NULL DEFAULT 'Undefined Zone' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Indexes for dumped tables -- -- -- Indexes for table `gang` -- ALTER TABLE `gang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `member` -- ALTER TABLE `member` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`); -- -- Indexes for table `zone` -- ALTER TABLE `zone` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `gang` -- ALTER TABLE `gang` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `member` -- ALTER TABLE `member` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zone` -- ALTER TABLE `zone` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- ------------------------------------------------ */ |
